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 do each of these constructions contain.
Current State: Construction name (structure ID) is not kept up to date nor is it being enforced as a required field. While the construction type is not being reviewed as frequently as it should be to ensure we have the correct information.
Ideal State: Construction name is accurately provided for every single location to enable us to know how many individual structures exist in the out of home space. The contractions type would also be reviewed and updated where needed by the auditor.
Potential short term resolution: Use the latitude and longitude to determine nearby frames that are associated with the same construction (structure).
Standard:
Definition: Geopath currently defines 17 different constructions across multiple media classification. The construction is defined as where the frame resides
TABLE | CONSTRUCTION | Type | Rule |
CONSTRUCTION | CONSTRUCTION_SK | Number | |
CONSTRUCTION | CONSTRUCTION_ID | Number | |
CONSTRUCTION | CONSTRUCTION_NAME | Text | No null or bank 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 |
TABLE | CONSTRUCTION_TYPE | Type |
CONSTRUCTION_TYPE | CONSTRUCTION_TYPE_SK | Number |
CONSTRUCTION_TYPE | CONSTRUCTION_TYPE_ID | Number |
CONSTRUCTION_TYPE | CONSTRUCTION_TYPE_NAME | Text |
CONSTRUCTION_TYPE | CONSTRUCTION_TYPE_DESCRIPTION | Text |
CONSTRUCTION_TYPE | CREATED_BY | Text |
CONSTRUCTION_TYPE | CREATED_DTM | Date |
CONSTRUCTION_TYPE | UPDATED_BY | Text |
CONSTRUCTION_TYPE | UPDATED_DTM | Date |
CONSTRUCTION_TYPE | CURRENT_IND | True/False |
CONSTRUCTION_TYPE | UPDATED_DESC | Text |
Add Comment