Goal: In order to ensure the quality of Geopath’s data and address the needs of the industry we need to understand the total number of unique constructions in the out of home world. This will enable us to answer how many constructions (structures) exist in the out of home world as well as how many frames each of these constructions contain.
...
Element
...
Description
...
Structure
...
The physical structure to which the frame or screen is secured
Current State: Construction name (structure ID) is not kept up to date nor is it being enforced as a required field. Lamar and Clear Channel are some of the few companies that have valid constructions names. We will also need to do some housecleaning of the construction ID. Lamar for example will have a single construction name for a location for two frames but contain different construction IDs.
...
Frame Id
...
Construction Name
...
Construction Id
...
214526
...
7800393
...
214526
...
214527
...
7800393
...
214527
While others like OUTFRONT currently have an invalid construction name. Lastly, the construction type is not being reviewed as frequently as it should be to ensure we have the correct type. For example, this OUTFRONT location, frame Id 30450362, is listed with a construction of freestanding while it should be listed as an exterior wall.
include fleet exterior
construction name - bus model
...
Ideal State: Construction name is accurately provided for every single location to enable us to know how many individual structures or buses exist in the out of home world. All construction IDs are updated to ensure consistency across the database. The construction ID will be unique across the entire database for an individual construction name. The contraction type would also be reviewed and updated where needed by the auditor.
Potential resolution: Using the latitude and longitude to determine nearby frames that are associated with the same construction (structure). This can be followed by a request to the media operator or the creation of the construction name by parent account.
Process and Procedure:
Each frame has an identifiable and valid construction name that is ideally provided by the media operator.
If the media operator does not have a construction name then Geopath will create a construction name that is unique across the parent account.
The Construction ID will also have to be updated to ensure that the same construction ID is used when we have the same construction name.
Standard Construction Types:
...
The construction or the structure is where the frame is supported. For example, for traditional bulletins the steel pole is what is being referred to as the construction. This construction supports the frame or frames that reside on the steel pole.
Geopath has various standard construction types to help describe how the frame is being supported.
Construction Type Name | Construction Type Description |
Freestanding | freestanding structure taller than 10 feet tall |
Exterior Wall | the wall of a standing building |
Interior Wall | the wall inside of a building |
Furniture | freestanding structure less than 10 feet tall |
Stairs | a series of steps |
Rooftop | the surface atop a building |
Ceiling | hangs from or is flush with the area above |
Floor | flat surface where people may walk |
Tablet | may be held by a single individual |
Interior Vehicle | the interior surfaces of a vehicle |
Exterior Vehicle | the exterior surfaces of a vehicle |
Column | a column inside of a building |
Elevator | the interior of an elevator inside a building |
Furniture - Top | the top of a freestanding structure within view of someone passing by |
Bus Exterior | Bus Exterior |
Truck Exterior | Truck Exterior |
Personal Motorized Vehicle Exterior | Personal Motorized Vehicle Exterior |
These Here are a few visual examples of some construction types.
...
Database Rules:
...
TABLE
...
CONSTRUCTION
...
Type
...
Rules
...
CONSTRUCTION
...
CONSTRUCTION_SK
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_ID
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_NAME
...
Text
...
No null, blank, or invalid value
...
CONSTRUCTION
...
CONSTRUCTION_TYPE_SK
...
Number
...
CONSTRUCTION
...
LOCATION_SK
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_DESCRIPTION
...
Text
...
CONSTRUCTION
...
CREATED_BY
...
Text
...
CONSTRUCTION
...
CREATED_DTM
...
Date
...
CONSTRUCTION
...
UPDATED_BY
...
Text
...
CONSTRUCTION
...
UPDATED_DTM
...
Date
...
CONSTRUCTION
...
CURRENT_IND
...
True/False
...
CONSTRUCTION
...
UPDATED_DESC
...
Text
...
CONSTRUCTION
...
CONSTRUCTION_COUNT
...
Number
SQL queries:Submission:
When those who have permission to create and update inventory the media operator for example should always provide the construction name and the construction type. The construction name or the structure ID is what the media operator would identify the steel pole as within their database.
Most bulletins construction support two frames. For example, the image below illustrates a situation where there are two frames and one steel pole. These two frames will have the same construction name because they are supported by the same construction.
Goal:
To understand the total number of unique constructions in the out of home world. This will enable us to answer how many constructions (structures) exist as well as how many frames each of these constructions support. This information can be useful for both buyers and sellers.