Geopath Unified Inventory Taxonomy
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 |