2019 INRIX Project

The 2019 INRIX project contains SQL objects and a Python project.

To run the Python project

• Pull the INRIX-Datasets repository from GitHub into your local environment
• Checkout the remote branch associated with 2019 INRIX data-sets
• Update the main.py file located in the python folder to point at the correct SQL Server instance and database containing the INRIX SQL objects created by the inrixObjects.sql file in the sql folder
• Update the main.py file located in the python folder with the desired full path of the folder containing the 2019 INRIX zip archives
• Ensure the zipped INRIX XD-based segment shape file USA_California.zip is located in the project data folder
• Use the environment.yml file located in the python folder to create the inrixLoad2019 Python virtual environment and set as the project interpreter
• Run main.py from the python folder as the working directory

Python

File	Description
environment.yml	conda environment used to run INRIX python files
main.py	orchestrator file used to load INRIX datasets to the database environment

Data

File	Description
USA_California.zip	zipped INRIX XD-based segment shape file

SQL Objects

Name	Description
[inrix].[holiday]	holiday date table
[inrix].[sp_agg_speed_15min]	aggregator of 15-minute INRIX speed dataset
[inrix].[speed_15min]	15-minute INRIX speed dataset
[inrix].[time_min15_xref]	15-minute time period cross-reference
[inrix].[xdseg_metadata]	INRIX XD-based segment metadata