Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Goal:

Summary:

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 and use proximity to determine the 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

...