Skip to content

Instantly share code, notes, and snippets.

@wertyoo
Created November 19, 2018 20:49
Show Gist options
  • Save wertyoo/0afcde00cd963b5db373ce2eb3a7c8ea to your computer and use it in GitHub Desktop.
Save wertyoo/0afcde00cd963b5db373ce2eb3a7c8ea to your computer and use it in GitHub Desktop.
Invetory with comments
{
"_id": "string", // set to mongo ObjectID
"_type": "string", // infer
"_display_name": "string", // infer
"_create_time": "datetime", // unsure
"_update_time": "datetime", // unsure
"id": "string", // good
"type": "string", // infer
"partner_display_ids": [ // need datastore
"string"
],
"code": "string", // good
"operational": "boolean", // unsure
"exchange_ready": "boolean", // need datastore
"plant_id": "string", // good
"plant": {
"_id": "string", // set to mongo ObjectID
"_type": "string", // infer
"_display_name": "string", // infer
"_create_time": "datetime", // unsure
"_update_time": "datetime", // unsure
"name": "string", // good
"code": "string", // good
"region": "string", // infer
"url": "string", // good
"display_ids": [ // infer via query - but should use datastore
"string"
],
"address": { /// infer via query
"intersection": "string",
"address_line_1": "string",
"address_line_2": "string",
"city": "string",
"state": "string",
"region": "string", // do not have
"country": "string", // do not have - possible to infer?
"zipcode": "string"
},
"contacts": [ // do not have
{
"first_name": "string",
"last_name": "string",
"title": "string",
"email": "string",
"mobile": "string",
"work": "string",
"phone": "string",
"fax": "string"
}
]
},
"market": { // good - How does this array work?
"name": "string",
"code": "number",
"type": "string",
"region": "string"
},
"media_type": {
"name": "string", // good
"style": "string", // good
"category": "string" // need datastore
},
"structure": {
"_id": "string", // set to mongo ObjectID
"_type": "string", // infer
"_display_name": "string", // infer
"_create_time": "datetime", // unsure
"_update_time": "datetime", // unsure
"publisher_id": "string", // do not have - should remove?
"plant_id": "string", // set to mongo ObjectID
"contact_id": "string", // do not have
"venue_id": "string", // do not have - should remove?
"display_ids": [ // infer via query
"string"
],
"status": "string", // do not have
"birth_date": "datetime", // do not have
"install_date": "datetime", // do not have
"height_above_ground_level_feet": "number", // do not have - important
"display_types": [ // infer via query - but should use datastore *Plants have display types - called Products
"string"
],
"last_service_date": "datetime", // do not have
"service_needed": "boolean" // do not have - should remove?
},
"venue_id": "string", // do not have - should remove?
"publisher_id": "string", // do not have - should remove?
"tab_id": "string", // good
"sibling_display_ids": [ // infer via query - but should use datastore
"string"
],
"location": {
"_id": "string", // set to mongo ObjectID
"_type": "string", // infer
"_display_name": "string", // infer
"_create_time": "datetime", // unsure
"_update_time": "datetime", // unsure
"geo": {
"lat": "number", // good
"lon": "number" // good
},
"address": {
"intersection": "string", // good -LocationDescription
"address_line_1": "string", // do not have
"address_line_2": "string", // do not have
"city": "string", // infer via query - but should use datastore
"state": "string", // ''
"region": "string", // ''
"country": "string", // ''
"zipcode": "string" // good - within Structe object
},
"type": "number", // do not have
"ip_service": "string", // do not have
"utc_offset": "string", // unsure
"position": "number" // do not have
},
"measurement": {
"expire_time": "datetime", // set to hourly maybe
"gross_traffic": "number", // lamar possibly
"gross_traffic_seconds": "number", // lamar possibly
"impression_multiplier": "number", // just some math
"plays_per_day": "number", // do not have
"plays_per_day_per_slot": "number", // do not have
"daily_effective_circulation": "number", // good - but mostly null or 0
"data_provider_name": "string", // value is always Geopath
"age_range": "number", // need from Geopath
"age_range_percent": "number", // need from Geopath
"household_income_range": "number", // need from Geopath
"household_income_percent": "number" // need from Geopath
},
"restriction": { // need an array of lamar restrictions that include IAB
"blocked_categories": [ // do not have
"string"
],
"blocked_domains": [ // do not have
"string"
],
"blocked_buyers": [ // do not have
"string"
],
"blocked_lamar_verticals": [ // good
"string"
],
"blocked_lamar_categories": [ // good
"string"
],
"details": "string" // good
},
"rate": {
"_id": "string", // set to mongo ObjectID
"_type": "string", // infer
"_display_name": "string", // infer
"_create_time": "datetime", // unsure
"_update_time": "datetime", // unsure
"daily_base_rate": "number", // do not have - important
"daily_bid_floor": "number", // do not have - important
"cpm_base_rate": "number", // do not have - important
"cpm_bid_floor": "number", // do not have - important
"currency": "string", // should always be USD
"expire_time": "datetime" // set to daily maybe
},
"brand": { // change to branding
"details": "string", // good
"photosheet_url": "string", // good
"photo_urls": [ // good
"string"
],
"spec_sheet_url": "string" // good
},
"visibility": {
"read": "string", // good
"read_detail": "string", // good
"cross_read": "union", // unsure
"facing_direction": "string", // good
"facing_degrees": "number", // good
"traffic_type": "string", // could infer from "Route" : "LOCAL TRAFFIC",
"traffic_direction": "string", // unsure
"approach_meters": "number", // do not have
"line_of_sight_display_ids": [ // do not have
"string"
]
},
"static": {
"illumination": "boolean", // have
"lights_on_time": "datetime", // unsure
"lights_off_time": "datetime", // unsure
"solar_power": "boolean", // unsure
"aspect_ratio": "string", // infer possibly
"dots_per_inch": "number", // do not have, maybe constant 300dpi
"width_inches": "number", // good - need to parse and convert to inches
"height_inches": "number", // good - need to parse and convert to inches
"vinyl_width_inches": "number", // good - need to parse and convert to inches
"vinyl_height_inches": "number" // good - need to parse and convert to inches
},
"digital": { // What is Gauranteed Spots - important
"ad_slot_amount": "number", // good
"ad_slot_duration_seconds": "number", // good
"ad_share_of_voice": "number", // infer
"ip_address_v4": "string", // DELETE
"display_make": "string", // do not have
"display_model": "string", // do not have
"auto_scale_width_pixels": "number", // infer - need datastore
"auto_scale_height_pixels": "number", // infer - need datastore
"auto_scale_name": "string", // infer - need datastore
"auto_scale_code": "string", // infer - need datastore
"true_width_pixels": "number", // good
"true_height_pixels": "number", // good
"aspect_ratio": "string", // infer - need datastore
"dots_per_inch": "number", // do not have - should be 72 dpi possibly
"width_inches": "number", // good - change to display_width_inches
"height_inches": "number", // good - change to display_height_inches
"pitch": "string", // do not have
"carrier": "string", // do not have
"connection_type": "number" // infer possibly
}
}
/*
Need to add
"AcceptsExtensions" : false,
"Interchange" : "I-75",
"ExpirationDate" : null,
What does
"Area" : "01", "Area" : "SH 60",
"RideNumber" : 0,
"PoliticalDivision" : 2,
mean?
Can you send use the URL's for
"MapIcon" : "jr_posters_s_map_pin.png",
"PhotoType" : "PhotosheetApproach", "FileName" : "290.082003.PhotosheetApproach.201202041040118844624.jpg"
"PhotoType" : "PhotosheetCloseUp", FileName" : "290.082003.PhotosheetCloseUp.201202041040060235175.jpg"
How often is updated data sent?
Do the ObjectIDs change every time cache is written? Every night during dump?
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment