Market Data

• Market (City, State) - what city ad state does the transit system service

• Account Name - the name of the transit system

• Transit System Abbreviation - if available include the abbreviation of the transit system

• Parent Account Name - name of the vendor

• Account ID

Garage Locations

• Transit System Name

• Place Name - is the name of the garage

• Latitude - is the location of the place

• Longitude - is the location of the place

• Address - is the address of the place

• Data Source Key:

Place to Construction

• Place Name - is the name of the garage

• Construction Name - indicate the make, model, and year of the bus

• Construction Count by Place Name - indicate how many bus types are in the garage

• Place Construction SOV - A Geopath Field

Construction to Frame

• Construction Name - indicate the make, model, and year of the bus

• Placement Type Name - indicate which side of the bus the advertising is on, this includes Vehicle Front Exterior, Vehicle Rear Exterior, Vehicle Driver Side Exterior, Vehicle Passenger Side Exterior, and Vehicle Full Wrap Exterior

• Frame Media Name - indicate the type of media name this includes and is not limited to Queen, Full Back, Taillight, Full Wrap, King. Ultra Super King, Kong, Half Side, Full Side, Headlight, Half Wrap, Mini Taillight, Mini Queen, Super King, and Extended Tail

• Height

• Width

• Avg No_Panels per OTS Unit w/Medium - indicate how many possible ads are available per placement type

• Frame Digital

• Operator Media Name

• Plant Frame Id

• Plant Spot Id

• Ads in Rotation

• Ad Length - provide the length of time (seconds)

Bus Routes by Garage

• Route ID

• Place Name - indicate the name of garage, division, or the yard associated with this route

Update Sheet

• Plant Spot Id

• Place Name

• Action

• Parent Account Id

• Parent Account Name

• Account Id

• Representation Id

• Account Name

• Place Name

• Place Id

• Place Type Name

• Notes

• Status Type Id

• Status Type Name

• Construction Type Name

• Construction Name

• Placement Type Name

• Frame Media Name

• Frame Max Height

• Frame Max Width

• Avg No_Panels per OTS Unit w/Medium

• Frame Digital

• Media Type Name

• Latitude

• Longitude

• Spots in Rotation

• Spot Length

• Spot Sov

• Layout SOV

• Construction Count by Place Name