Add new data sources

[banjtheman]

What is the Task

Add the following data soucres to our PostGis database

• [x] Bike trails
• [x] Sidwalks
• [ ] Recreation
• [ ] Retail
• [ ] Truck and Bus

Why do we want to do this

We need this data for #84 and #85 to get accurate information

How can I get started?

1. Download GeoJson data from here

Bike trails: https://opendata.dc.gov/datasets/bike-trails/explore?location=14.465233%2C59.704936%2C0.00&showTable=true Sidwalks: https://opendata.dc.gov/datasets/sidewalks/explore?location=14.465233%2C59.704936%2C0.00&showTable=true Rec: https://opendata.dc.gov/datasets/recreation-facilities/explore?location=38.894577%2C-77.008442%2C12.47&showTable=true Retail : https://opendata.dc.gov/datasets/retail-sites/explore?location=38.892472%2C-77.066473%2C11.26 Truck and bus: https://opendata.dc.gov/datasets/e376de8e9a4d4a1c8cfc54918630d5e0_104/explore?location=8.865305%2C59.704936%2C0.00&showTable=true

2. Convert to PostGis format

   gdf=geopandas.read_file('https://opendata.arcgis.com/datasets/URL.geojson')

3. Insert into DB https://github.com/CharlotteJackson/DC_Crash_Bot#sample-query

Definition of Done

Data has been added to PostGIS with geography