CharlotteJackson / DC_Crash_Bot

10 stars 7 forks source link

Given an address, determine nearby construction projects #101

Closed banjtheman closed 3 years ago

banjtheman commented 3 years ago

What is the Task

Create a function to get nearby construction projects given an address

Why do we want to do this

Step 1 in the TSA ask Is this location near an existing construction project? If yes, please provide the name and location of the project and any construction‐related concerns.

We would like to be able to get this information automatically

How can I get started?

Can look out how useful this API is in collecting data https://docs.microsoft.com/en-us/bingmaps/rest-services/traffic/traffic-incident-data

DDOT also has an API but, not updated at all... Heres an example call https://maps2.dcgis.dc.gov/dcgis/rest/services/DDOT/Cityworks/FeatureServer/2/query?f=json&where=((StatusClosed%20%3D%20%27NOT%20CLOSED%27)%20AND%20(HasWorkOrder%20%3D%20%27YES%27))%20AND%20(datetimeinit%3C%3Dtimestamp%20%272021-04-27%2003%3A59%3A59%27)&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&outSR=102100&resultOffset=0&resultRecordCount=500&resultType=standard

Definition of Done

We have a way to get nearby construction data from an address

banjtheman commented 3 years ago

Using the bing maps api, was able to get JSON data off all the incidents near an address.

image