Created
November 19, 2018 20:49
-
-
Save wertyoo/0afcde00cd963b5db373ce2eb3a7c8ea to your computer and use it in GitHub Desktop.
Invetory with comments
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Show hidden characters
{ | |
"_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