Research Request - PeMS lane dataset + postmiles geospatial data

[tiffanychu90]

Complete the below when receiving a research request, and continue to add to this issue as you receive additional details and produce deliverables. Be sure to also add the appropriate project-level label to this issue (eg gtfs-rt, DLA).

Research Question

Single sentence description: Create an aggregated station-lane dataset that includes all the columns flow, occupancy, speed, detector_samples and bring in the geospatial component to allow us to map the results.

• Epic - PeMS Roadmap #1139

Detailed description:

• Eventually we want to be able to put our results on a map and in a table
  • we'll want to filter for certain portions to get at a corridor's metrics (aggregate the metrics for several stations into corridor metrics)
• Use our most aggregated data and see if the columns we have abs_postmiles is useful for merging with the geospatial postmiles data
• Figure out the details of filtering out values later. The schema for our "published df" isn't changing (the details for getting values might change a little), so let's try to use it and see what we're missing.

Stakeholders & End-Users

Henry

Data sources

Cal-ITP data sources:

• use the station-hour-daytype aggregated tables

External data sources:

• postmiles (open data? why is it point data?)
• state highway network lines data