2019 INRIX SQL Data Dictionary - SANDAG/INRIX-Datasets GitHub Wiki

[inrix].[holiday]

holiday date lookup table

Field	Description
`[date]`	date of the holiday
`[holiday]`	text description of the holiday
`[type]`	type of holiday (Observed, Actual, Residual)

[inrix].[speed_15min]

INRIX speed dataset of fifteen-minute 2019 data, years 2014-2019 loaded

Field	Description
`[speed_15min_id]`	table surrogate key
`[segment_id]`	[inrix].[xdseg_metadata] table surrogate key
`[date_time]`	datetime of observation in local time
`[speed]`	estimated harmonic mean speed (mph)
`[hist_av_speed]`	historical average speed for that hour of the day and day of the week (mph)
`[ref_speed]`	The ‘free flow speed’. The speed driven on this road when it is wide open, based on INRIX historical data. Note that this is not legal speed limit. (mph)
`[travel_time]`	travel time along segment in minutes
`[c_value]`	the confidence value is an integer ranging from 0 to 100 inclusive that indicates the confidence that INRIX has in the correctness of a real-time speeds
`[pct_score30]`	percentage of the segment minutes based on actual speeds data for the time period
`[pct_score20]`	percentage of the segment minutes based on historic average speed
`[pct_score10]`	Percentage of the segment minutes based on the reference ‘free flow’ speed

[inrix].[time_min1_xref]

1-minute time period cross-reference

Field	Description
`[min1]`	1-minute time period ID
`[min1_period_start]`	1-minute time period start
`[min1_period_end]`	1-minute time period end
`[min5]`	5-minute time period ID
`[min5_period_start]`	5-minute time period start
`[min5_period_end]`	5-minute time period end
`[min15]`	15-minute time period ID
`[min15_period_start]`	15-minute time period start
`[min15_period_end]`	15-minute time period end
`[min30]`	30-minute time period ID
`[min30_period_start]`	30-minute time period start
`[min30_period_end]`	30-minute time period end
`[abm_half_hour]`	ABM half-hour time period ID
`[abm_half_hour_period_start]`	ABM half-hour time period start
`[abm_half_hour_period_end]`	ABM half-hour time period end
`[min60]`	60-minute time period ID
`[min60_period_start]`	60-minute time period start
`[min60_period_end]`	60-minute time period end
`[abm_5_tod]`	ABM five time of day time period ID
`[abm_5_tod_period_start]`	ABM five time of day time period start
`[abm_5_tod_period_end]`	ABM five time of day time period end
`[day]`	day time period ID
`[day_period_start]`	day time period start
`[day_period_end]`	day time period end

[inrix].[xdseg_metadata]

INRIX 2019 XD segment metadata table for OpenStreetMap-based network

Field	Description
`[segment_id]`	table surrogate key
`[vintage]`	year of the XD network downloaded
`[xdsegid]`	INRIX XD segment network link ID
`[frc]`	functional road classification (0 = Motorways and trunk roads and their links/ramps, 1 = Primary roads and their links/ramps, 2 = Secondary roads and their links/ramps, 3 = Tertiary roads, 4 = All other roads)
`[road_number]`	the commonly accepted numbering for the road section (i.e. “65” for Interstate 65)
`[road_name]`	road name
`[county]`	county name location
`[district]`	Sub-county administrative area or neighborhood, where available
`[miles]`	length of network link (miles)
`[lanes]`	number of lanes on network link
`[slip_road]`	slip road is rolled up from the underlying roads, if any portion of the road is a slip road (usually ramps) then slip road is indicated, in some cases a small portion of the CSeg is considered to be part of a named road so it takes the name rather than leaving the road name blank
`[special_road]`	includes roads, portions of a road, intersections of a road, or the ends of a road that are parts of the vehicular highway system and have separately identifiable characteristics (i.e. cul-de-sacs, traffic circles, access ramps, service drives, etc...)
`[road_list]`	XD segments can extend from one named road to another, when this occurs all primary road names are joined together for reference
`[bearing]`	Approximate overall direction of road that XD is a part of (N, S, E, W)
`[xdgroup]`	Grouping to determine Bearing (see previous field definition)
`[shape]`	geometry of XD segment network link in EPSG:2230