Pre 2017 INRIX Project - SANDAG/INRIX-Datasets GitHub Wiki
The Pre-2017 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 pre-2017 INRIX data-sets
- Update the settings.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 settings.py file located in the python folder with the desired full path of the folder containing the pre-2017 INRIX zip archives
- Use the environment.yml file located in the python folder to create the inrixLoadPre2017 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 |
settings.py |
settings file used to run INRIX python files |
Data
| File |
Description |
tmcGeo2016.csv |
geo-spatial INRIX TMC network (assumed 2016) |
tmcHwyCovXRef2016.csv |
manually created cross-reference between INRIX TMC network and SANDAG's highway network (assumed 2016) |
SQL Objects
| Name |
Description |
[inrix].[highway_coverage_xref_pre2017] |
manual lookup table of pre 2017 (2016?) TMC links and SANDAGs (2016?) highway network links |
[inrix].[holiday] |
holiday date table |
[inrix].[sp_agg_speed_data_pre2017] |
aggregator of INRIX speed dataset pre-2017 data |
[inrix].[speed_data_pre2017] |
INRIX speed dataset pre-2017 data |
[inrix].[time_min1_xref] |
1-minute time period cross-reference |
[inrix].[tmc_metadata_pre2017] |
INRIX pre-2017 TMC metadata table |