Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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

  • No labels