Given an address, Describe multi‐modal facilities

[banjtheman]

What is the Task

Create function to get multi‐modal facilities given an address

Why do we want to do this

Step 6 for the TSA is to Describe multi‐modal facilities Are there sidewalks? Bike facilities or trails? Nearby Metrorail station or Metrobus stop(s)?

How can I get started?

We have metro data - https://docs.google.com/spreadsheets/d/18OQh78KhlL65JHM2DyQKVEdYUY8zXjHzTfYbdsd-Kes/edit#gid=821041532

We have road calming features - https://docs.google.com/spreadsheets/d/18OQh78KhlL65JHM2DyQKVEdYUY8zXjHzTfYbdsd-Kes/edit#gid=2064723036

Will have to look for trails and any other points of interest

Definition of Done

A Function given an address returns multi‐modal facilities

[banjtheman]

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

[CharlotteJackson]

Check out source_data.sidewalks and source_data.bike_trails! Are those in the right format to be useful? Also all the columns except the geography are varchars; do you need me to cast anything to numeric or int?

[banjtheman]

@CharlotteJackson everything works, thanks!!!

[banjtheman]

Example output

Address: 607 13th St NW, Washington, DC 20005

Nearby Metro Stations:
Metro Center
Nearby Sidewalk types:
Sidewalk: 82
Crosswalk: 63
Stairs: 12
Hidden Sidewalk: 1