DVRPC TIM Viewer

codenames: tart, peeping TIM

This is an internal tool for exploring the inputs and outputs of the DVRPC Travel Improvement Model (TIM). Product is in early development.

Viewer Roadmap

This roadmap is organized by network system and feature priority.

Highway

• [x] Federal functional class (1)
• [x] Number of lanes (1) requires offset visualization for readability
• [x] Traffic counts (1)
• [x] Average speed: hourly (2)
• [x] Travel time index: hourly (2)
• [ ] AADT by segment (2)
• [ ] Volume or V/C simulated (2)

Bike

• [x] Facility type (1)
• [ ] Slope (1)

Transit

• [x] Line route (1)
• [ ] Stop location (1)
• [ ] Headway/frequency (1)
• [ ] Line boardings (3)
• [ ] Stop boardings (4)
• [ ] Average traffic speed (4)

Zone and travel data

• [x] Population (1)
• [x] Households (1)
• [x] Employment totals (1)
• [x] Employment by sector (1)
• [x] Number of POIs (2) available but require metadata to implement
• [x] OD Desrire lines (3)
• [x] Top travel destinations (1)

Front End

Required dependencies

• Mapbox-gl - map rendering and interactivity in browser
• D3.js - for charting

Vector layer hosting

• Tileserver-gl
  • vector tile host, alternatives available

Vector tile layer preparation

• ogr2ogr
  • for data preparation and spatial transformations
• tippecanoe
  • for creation of Mbtiles
  • runs on Linux or OSX
• mbutils
  • for final dump of Mbtiles for web server

Back End

API documentation Dependencies - Core

• Python 3.9
  • psycopg2
  • numpy
• PostgreSQL 14.9
  • PostGIS 3.4 (with pgRouting)
  • tablefunc (extension needs to be enabled)

Dependencies - Utilities

• Python 3.9
  • MS Access ODBC
    • pypyodbc PyPi Github
    • Microsoft Access Database Engine (for your flavour of Microsoft Office) Note: You may need to add the /passive switch to install e.g. AccessDatabaseEngine_x64.exe /passive

This is not a formally supported or endorsed product of the DVRPC