Geopath Unified Inventory Taxonomy
- Kevin Narine
This document provides an overview of Geopath’s Unified Inventory Taxonomy Database.
OVERVIEW & DIAGRAM
Table | Table Description |
construction | Record and attributes of the structure that the frame is supported by |
frame | Record and attributes of the frame that supports the advertising |
layout | Record and attributes of unique layouts of content and/or advertising that appear on a frame |
face | Record and attributes of the unique seperate areas of content and/or advertising that appear on a layout |
spot | Record and attributes of the unique content and/or advertising that appear on a face |
message | Record and attributes of the specific unique advertising and/or content that appeared on a panel at a given moment in time |
location | Record and attributes of a spatial location that can be given to any of the various elements in the database |
assignment | Record and attributes of the network assignment information for a given location to a given network |
place | Record and attributes of places that could contain structures for place based measurement |
representation | List of all representatives |
account | List of accounts and their parents that have a representative relationship to inventory |
CONSTRUCTION
Column | Description | Required? | Data Type | Notes |
construction_id | Geopath ID of the construction | T | number |
|
construction_name | Name (Operator ID #) of the construction | F | text | If not provided, Geopath creates a construction name using the lat/lon of the structure |
construction_type_id | Type of construction | T | number |
|
location_id | ID for the location of the construction | T | number |
|
construction_description | Text description | F | text |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
FRAME
Column | Description | Required | Data Type | Notes |
FrameID | ID for Frame | T | number |
|
ConstructionID | ID for Structure/Construction | T | number |
|
PlantFrameID | Operator ID for Frame | F | text |
|
LocationID | ID for the location of the frame | T | number |
|
MediaID | ID for geopath standard media type lookup | T | number |
|
ClassificationID | ID for classification lookup | T | number |
|
PlacementID | ID for placement lookup | T | number |
|
Illumination Start Time | Time illumination starts | T | time |
|
Illumindation End Time | Time illumination end | T | time |
|
IlluminationTypeID | ID for Illumination Type lookup | T | number |
|
FrameMaxHeight | Maximum height in Inches | T | number |
|
FrameMaxWidth | Maximum width in Inches | T | number |
|
frame_max_pixel_width | Maximum pixel height of frame | F | number |
|
frame_max_pixel_height | Maximum pixel width of frame | F | number |
|
ConstructionDate | Date Frame was Constructed | F | Date |
|
FrameStatusTypeID | Geopath Status of the frame | T | number |
|
FrameDescription | Text Description of the Frame | F | text |
|
frame_full_motion | Does the frame support full motion graphics | F | true/false |
|
frame_partial_motion | Does the frame support partial motion graphics | F | true/false |
|
frame_rotating | Does the frame support rotating ads | F | true/false |
|
frame_interactive | Does the frame support interactive ads | F | true/false |
|
frame_audio | Does the frame support audio | F | true/false |
|
frame_media_name | Operator media type name | F | text |
|
engagement | engagement score for the frame | F | number |
|
notes | Text notes about the frame | F | text |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
LAYOUT
Column | Description | Required | Data Type | Notes |
layout_id | Unique ID | T | number |
|
frame_id | ID of the frame | T | number |
|
layout_full_motion | Does the layout support full motion graphics | F | true/false |
|
layout_partial_motion | Does the layout support partial motion graphics | F | true/false |
|
layout_rotating | Does the layout support rotating ads | F | true/false |
|
layout_interactive | Does the layout support interactive ads | F | true/false |
|
layout_audio | Does the layout support audio | F | true/false |
|
share_of_voice | share of voice of this layout for the frame | F | number |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
FACE
Column | Description | Required | Data Type | Notes |
FaceID | Unique ID | T | number |
|
layout_id | ID of the layout | T | number |
|
avg_spot_length | Avg length of a spot on this face | F | number |
|
publisher_unique_face_id | publisher's unqiue id | F | text |
|
spots_in_rotation | number of spots that run on the face in a loop | F | number |
|
face_height | height in inches of this face | T | number | comes from the frame max height if not seperately defined |
face_width | width in inches of this face | T | number | comes from the frame max width if not seperately defined |
face_pixel_height | pixel height of this face | F | number |
|
face_pixel_width | pixel width of this face | F | number |
|
top_left_pixel_x | starting pixel at top x of the face on the screen | F | number |
|
top_left_pixel_y | starting pixel at top y of the face on the screen | F | number |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
SPOT
Column | Description | Required | Data Type | Notes |
spotID | ID of the spot | T | number |
|
face_id | ID of the face | T | number |
|
PublisherUniqueID | Unique ID for the publisher | F | number |
|
plant_spot_id | Operator ID for the spot | F | number |
|
share_of_voice | Share of voice for this spot on the face | F | number |
|
spot_lenth | Length of the time the spot is displayed for digital or rotating signs | F | number |
|
spot_full_motion | Does the spot support full motion graphics | F | true/false |
|
spot_partial_motion | Does the spot support partial motion graphics | F | true/false |
|
spot_rotating | Does the spot support rotating ads | F | true/false |
|
spot_interactive | Does the spot support interactive ads | F | true/false |
|
spot_audio | Does the spot support audio | F | true/false |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
MESSAGE
Column | Description | Required | Data Type | Notes |
message_play_id | unqiue id of the ad play | T | number |
|
play_timestamp | when the ad was played | T | number |
|
spot_id | ID of the panel where the ad appeared | T | number |
|
message_id | ID of the message that appeared during the ad | F | text |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
LOCATION
Column | Description | Required | Data Type | Notes |
location_id | Id of the location | T | number |
|
orientation | compass heading of the facing in degrees | T | number |
|
primary_read | Read direction (L/R) of the location from the primary artery | F | text |
|
primary_artery | the primary road the location is seen from | F | text |
|
level | Floor of a building the location is on | F | number |
|
levels_visible | How many levels of a building the location is visibile from | F | number |
|
latitude | latitude coordinates of the location | T | number |
|
longitude | longitude coordinates of the location | T | number |
|
block_id | The census block id of the location | F | number | automaticaly dervied from lat/lon |
elevation | The elevation of the frame / structure at the middle of the frame, elevation above sealevel | F | number |
|
geom | Geometry of the location for geospatial use | F | geometry | automaticaly dervied from lat/lon |
dma_id | ID of the dma the location is in | F | number | automaticaly dervied from lat/lon |
zip_code | ID of the zip code the location is id | F | number | automaticaly dervied from lat/lon |
time_zone | ID of the time zone the location is in | F | number | automaticaly dervied from lat/lon |
place_type_id | ID for place type lookup | F | number |
|
description | text description of the location | F | text |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
ASSIGNMENT
Column | Description | Required | Data Type | Notes |
assignment_id | ID of the assingment | T | number |
|
location_id | Id of the location | T | number |
|
assignment_type_id | ID for assignment type lookup | T | number |
|
assignment_date | Date Assignment was made | T | datae/time | |
network_type_sk | ID for network type lookup | T | number |
|
segment_id | Road Segment assignment was made to. | T | date/time |
|
mode | Type of traffic the assignments counts for | F | text |
|
max_noting_distance_override | Allowed override value for maximum noting distance | F | number |
|
dwell_time_override | Allowed override value for dwell time | F | number |
|
distance_from_audience | Distance of the location to the closest point on the assigned segment | F | number |
|
distance_angle | Angle of the line between the location and the closest point on the assigned segment | F | number |
|
right_hand | If the assignment is a right hand read | F | true/false |
|
center | If the assignment is a center read | F | true/false |
|
perpendicular | If the location is perpendicular to the roadway | F | true/false |
|
pct_pop_extended_dwell |
| F | number |
|
viewable_percent |
| F | number |
|
exposure_probability |
| F | number |
|
height_above_audience |
| F | number |
|
distance_in_view |
| F | number |
|
best_degree_off_center |
| F | number |
|
best_apparent_size |
| F | number |
|
placement_adjustment_factor | factor related to the placement type of the location | F | number |
|
place_id | Place assignment was made to | F | number |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
PLACE
Column | Description | Required | Data Type | Notes |
place_id | ID of the venue the structure or location is located in | T | number |
|
place_type_id | ID for the place type lookup | T | number |
|
location_id | ID of the location | F | number |
|
here_place_id | ID that corresponds to the external HERE dataset of venues | T | text |
|
transfer_station | is the place a transit transfer station | F | true/false |
|
street_address | street address of the placce | F | text |
|
city | city the place is located in | F | text |
|
state | state the place is located in | F | text |
|
zip_code | zip code the place is located in | F | text |
|
place_name | name of the place | F | text |
|
place_short_name | shorter name of the place | F | text |
|
entrances_cnt | number of entrances to the place | F | number |
|
floors_cnt | number of floors in the place | F | number |
|
concourse_cnt | number of transit concoruses in the place | F | number |
|
platforms_cnt | number of transit platforms in the place | F | number |
|
gates_cnt | number of gates in the place | F | number |
|
polygons | geometric shapes of the place | F | geometry |
|
area_sqft | total square feet of the place | F | number |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
REPRESENTATION
Column | Description | Required | Data Type | Notes |
representation_id | ID of the representation record | F | integer |
|
rep_type_id | ID of the representation type lookup | F | integer |
|
account_sk | Geopath Account ID for the representative | F | integer |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
ACCOUNT
Column | Description | Required | Data Type | Notes |
account_id | unqiue id | T | number |
|
account_name | Name of the account | T | text |
|
account_operator_code | Unique Account code for the operator | F | text |
|
parent_account_id | account id of the parent account | F | number |
|
parent_account_name | Name of the parent account | F | text |
|
created_by | Date record was created | T | date/time |
|
created_dtm | Who created the record | T | text |
|
updated_by | If record has been updated, who updated it | F | text |
|
updated_dtm | If record has been updated, when it was updated | F | date/time |
|
current_ind | Marks if the record is current or not | T | true/false |
|
updated_desc | Text description of why is was updated | F | text |
|
