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	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