hackoregon/2019-transportation-data-science issues and pull requests

#63 - filter out small sample sizes

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#62 - New tables for sandbox layer

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#61 - put rush hour definition in database

Issue - State: closed - Opened by znmeb over 5 years ago

#60 - Delete old database backups from S3

Issue - State: open - Opened by znmeb over 5 years ago
Labels: bug

#59 - Null coordinates in disturbance_stops

Issue - State: closed - Opened by znmeb over 5 years ago
Labels: bug

#58 - Add July and August 2018

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: enhancement

#57 - get rid of "monthly" in headers

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#56 - Load bus_stop_catchment_zone data into database

Issue - State: closed - Opened by znmeb over 5 years ago
Labels: enhancement

#55 - Add July 2018

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#54 - disturbance_system_wide_summary is empty in the RDS instance

Issue - State: closed - Opened by znmeb over 5 years ago
Labels: bug

#53 - disturbance_stops appears to be missing April and May of 2018

Issue - State: closed - Opened by znmeb over 5 years ago - 3 comments
Labels: bug

#52 - Add a catalog of available month / year combos in the TOAD data

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#51 - Make sure all the stop locations in the passenger census are in our master table

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#50 - Add census tract column to passenger census

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: enhancement

#49 - Load NCDB_Sample_Transportation_Commute into database

Issue - State: closed - Opened by znmeb over 5 years ago - 4 comments
Labels: enhancement

#48 - remove location_id = 0 from passenger stops tables

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#47 - Add latitude / longitude columns where needed

Issue - State: closed - Opened by znmeb over 5 years ago - 3 comments
Labels: enhancement

#46 - replace negative seconds late with zero

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#45 - Move the reference tables to public schema

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: bug, wontfix

#44 - Primary keys on `bus_passenger_stops` and `rail_passenger_stops` need to be standardized

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#43 - Summary statistics views

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#42 - Put stop-to-stop back in database

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#41 - TriMet GIS tables appear in the RDS instance twice

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#40 - Isolate rush hour boundaries

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#39 - Isolate GIS information for the transpo-housing census tracts

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#38 - Filter out disturbance stop rows with no GIS

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug

#37 - Demo App can load from local csv files.

Pull Request - State: closed - Opened by geophpherie over 5 years ago - 1 comment

#36 - [demo_app] no data displayed after launching demo app

Issue - State: closed - Opened by cdmuhs over 5 years ago - 2 comments

#35 - Time series smoothing for passenger census

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#34 - Add last year's passenger census to database

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#33 - EXPO Card - Transit Ridership in Gentrifying Neighborhoods

Issue - State: open - Opened by jaronheard over 5 years ago

#32 - Add lagged stop events

Pull Request - State: closed - Opened by znmeb over 5 years ago

#31 - Stop segment calcs

Pull Request - State: closed - Opened by geophpherie over 5 years ago - 1 comment

#30 - Order the passenger stop and bus all stop tables for lag calculations

Issue - State: closed - Opened by znmeb over 5 years ago
Labels: enhancement

#29 - add event_no_trip column to bus_passenger_stops

Issue - State: closed - Opened by znmeb over 5 years ago
Labels: enhancement, wontfix

#28 - Missing tables in autodoc

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: bug, wontfix

#27 - Port last year's stop event lagged calculations from R to PostgreSQL

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: enhancement

#26 - [CARD] Ridership by Line & Stop

Issue - State: open - Opened by smooto over 5 years ago

#25 - Edits query format and adds bounding box

Pull Request - State: closed - Opened by geophpherie over 5 years ago

#24 - Demo app with api

Pull Request - State: closed - Opened by geophpherie over 5 years ago

#23 - Database documentation

Issue - State: open - Opened by znmeb over 5 years ago
Labels: Documentation

#22 - Build a routing engine container

Issue - State: closed - Opened by znmeb over 5 years ago
Labels: enhancement

#21 - Partition tables

Pull Request - State: closed - Opened by znmeb over 5 years ago - 2 comments

#20 - Document "xsv" extraction process

Issue - State: open - Opened by znmeb over 5 years ago - 1 comment
Labels: Documentation

#19 - Document Open Source Routing Machine usage

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment
Labels: wontfix, Documentation

#18 - Incorrect logic in bus / rail classification

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: bug

#17 - Rebuild database with partitioned tables

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: bug

#16 - Add Census geometries and TriMet shapefiles to the database

Issue - State: closed - Opened by znmeb over 5 years ago - 1 comment

#15 - LODES data analysis / wrangling

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: enhancement

#14 - Add traffic signal data to database

Issue - State: closed - Opened by znmeb over 5 years ago - 2 comments
Labels: enhancement, good first issue

#13 - Add local development containers

Pull Request - State: closed - Opened by znmeb almost 6 years ago

#12 - Mount a host workspace for the database container's tablespace

Issue - State: closed - Opened by znmeb almost 6 years ago - 1 comment
Labels: bug

#11 - Sourcing real-time data for TOAD

Issue - State: closed - Opened by smooto almost 6 years ago - 3 comments

#10 - Jeff hawthorne explore

Pull Request - State: closed - Opened by geophpherie almost 6 years ago

#9 - 2019 etl branch

Pull Request - State: closed - Opened by znmeb almost 6 years ago

#8 - Create a database for the API

Issue - State: closed - Opened by znmeb almost 7 years ago - 2 comments

#7 - Exploratory data anaylsis

Issue - State: closed - Opened by znmeb almost 7 years ago - 2 comments

#6 - Consolidate monthly CSVs before loading to PostgreSQL

Issue - State: closed - Opened by znmeb almost 7 years ago - 1 comment
Labels: bug

#5 - Use CSV foreign data wrappers to import the CSVs

Issue - State: closed - Opened by znmeb almost 7 years ago - 2 comments
Labels: enhancement

#4 - Set up multiple jobs on dump and restore processes

Issue - State: closed - Opened by znmeb almost 7 years ago - 2 comments
Labels: enhancement

#3 - Add geometry columns and parse timestamps

Issue - State: closed - Opened by znmeb almost 7 years ago - 3 comments
Labels: good first issue

#2 - Set up to run in a container

Issue - State: closed - Opened by znmeb almost 7 years ago - 2 comments
Labels: enhancement

#1 - Refactor PostgreSQL load script to use "make"

Issue - State: closed - Opened by znmeb almost 7 years ago - 2 comments
Labels: enhancement

GitHub / hackoregon/2019-transportation-data-science issues and pull requests