2019 INRIX Project - SANDAG/INRIX-Datasets GitHub Wiki
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 |