Goal: In order to ensure the quality of Geopath’s data and address the needs of the industry we need The construction is where the frame is supported. For example, for traditional bulletins, the steel pole is what is referred to as the construction. This construction supports the frame or frames that reside on the steel pole.
All inventory submitted to Geopath must clearly state the construction name. The construction name can be an ID, text, or a combination of the two. The purpose of the construction name is 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.Definition: A frame exists on a construction (structure).The construction is what holds the frames. Geopath currently defines 17 different types of constructions across multiple media classifications.
...
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:supports. Each construction should also indicate when the construction was built. The construction date will be provided by the media operator. This information will help us have a repository of construction dates and the historical context of when the constructions were built.
Use cases:
A media operator has a construction where they have two frames on a steel pole. In this case two bulletins. Both of these frames will have the same construction name. The construction name is provided by the media operator and for example, can have an ID of 234968. Both frames on this construction will have construction name 234968. The construction type for this kind of build is called freestanding.
Many bulletin constructions support two frames. For example, the image below illustrates a situation where there are two frames on one steel pole. These two frames will have the same construction name because they are supported by the same construction. Similarly, the triple-sided construction with three frames will have the same construction name because they are supported by the same construction.
...
Other media types also have this same relationship with the construction and the frame(s). A media operator has three frames on a single construction. In this case on a transit shelter. The construction is the physical shelter. The construction name is provided by the media operator and for example, can have an ID of 369748. All three frames on this construction will have construction name 369748. Note that there are two frames on the inside of the transit shelter while the other is on the outside of the transit shelter. The construction type for this kind of build is called furniture.
For exterior fleet, the construction name is based on the bus model type. For example, a single bus garage might have three different bus models. Those bus models will represent three different construction names. All frames on the construction in this the bus model will share that same construction name.
...
Construction Types
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 | the flat surface where people may walk |
Tablet | may be maybe 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: