Construction

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.

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.

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.

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.

Policy:

1. Each frame has an identifiable and valid construction name that is ideally provided by the media operator.

2. If the media operator does not have a construction name then Geopath will create a construction name that is unique across the parent account.

3. 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:

These are visual examples of some construction types.

Database Rules:

SQL queries: