2019 INRIX SQL Data Dictionary

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

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 2019 XD segment metadata table

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 (1 = National Interstates, 2 = Regional Highways and Expressways, 3 = Arterials, 4 = Collector Roads, 5+ = Local Roads)
`[road_number]`	???
`[road_name]`	road name
`[county]`	county location
`[district]`	district location
`[miles]`	length of network link (miles)
`[lanes]`	number of lanes on network link
`[slip_road]`	???
`[special_road]`	???
`[road_list]`	???
`[bearing]`	???
`[xdgroup]`	???
`[shape]`	geometry of XD segment network link in EPSG:2230

Inrix-Datasets

Pre-2017 INRIX-Datasets

2019 INRIX-Datasets