DESCRIPTION | AUTHENTICATION | TYPE | NOTES | SOURCE |
Geographic/Demographic | | | | |
Master Address Repository Geocoder | Free (only works on windows) | .exe file | This is the best way to geocode addresses in DC. It is a program that will take in an excel file of addresses and output lat/long, precinct, X/Y coords, etc. | https://octo.dc.gov/service/download-mar-geocoder (Links to an external site.) |
Zillow API. Home/Neighborhood Data | Make account for free api key | API | Zillow has quite a few APIs, all accessed in a similar way with the same ID. You can access data about neighborhoods, home prices, demographic data, etc. The most useful may be the neighborhood data, which could be used as a classification variable. There are a few libraries that assist in the processing of the zillow API, including ZillowR and pyzillow. Additionally, Zillow has some cool mapping tools. The link below details how you can get data to map out their neighborhoods. https://www.zillow.com/howto/api/APIOverview.htm | https://www.zillow.com/howto/api/APIOverview.htm (Links to an external site.) |
Google Maps geocoding API | 0.005 USD per query with account | API | Useful for turning addresses into lat/long | https://developers.google.com/maps/documentation/geocoding/usage-and-billing (Links to an external site.) |
Google Maps directions API | 0.005 USD per query with account | API | Useful for finding directions. Might be able to help optimize the routes of inspectors. | https://developers.google.com/maps/documentation/directions/usage-and-billing (Links to an external site.) |
Voting Precinct Data | Free | Excel File | Shows polygons of the voting precincts as of 2012 | http://opendata.dc.gov/datasets/voting-precinct-2012 (Links to an external site.) |
Police Districts | Free | Excel File | Polygons of MPD Districts. | http://opendata.dc.gov/datasets/police-districts (Links to an external site.) |
DC Main Street Corridors | Free | Excel File | Recent data about Main Street Corridors | http://opendata.dc.gov/datasets/dc-main-street-corridors (Links to an external site.) |
Washington DC Boundary | Free | Excel File | Boundary areas of DC | http://opendata.dc.gov/datasets/washington-dc-boundary (Links to an external site.) |
Zip-code Demographic Data | Free | Excel File | Polygons of zip-codes, as well as some demographic data | http://opendata.dc.gov/datasets/zip-codes (Links to an external site.) |
Crime | | | | |
DC Hate Crimes-list of incidents and locations | Free | Excel File | Uses address as location. Could be used in conjunction with the google maps api to get lat/long. Although this may get expensive. | https://mpdc.dc.gov/node/1334781 (Links to an external site.) |
Dc Juvenile Arrest Data | Free | Excel File | There are a lot of crime data files. I won’t list them all but there are more found at the following link. https://mpdc.dc.gov/node/208852 | https://mpdc.dc.gov/node/208852 (Links to an external site.) |
2018 Crime Data file | Free | Excel File | Best Crime data so far. Includes lat/long and is broken down by district, voting precinct, neighborhood group, etc. | http://opendata.dc.gov/datasets/crime-incidents-in-2018?orderBy=BLOCK (Links to an external site.) |
| | | | |
Business | | | | |
Historically Underutilized Business Zones | Free | Excel File | Recent data, HUBZ areas as well as some demographics | http://opendata.dc.gov/datasets/historically-underutilized-business-zones (Links to an external site.) |
Economic Development Zones | Free | Excel File | From 2004, but might be good historical data | http://opendata.dc.gov/datasets/a3aefd57db394fd68d739556253dc44d_18 (Links to an external site.) |
District Revitalization Areas | Free | Excel File | From 2003 | http://opendata.dc.gov/datasets/900148002b174f13881ecd3961119d9c_17 (Links to an external site.) |
| | | | |
Housing | | | | |
Affordable housing projects | Free | Excel File | Data on affordable housing projects | http://opendata.dc.gov/datasets/affordable-housing (Links to an external site.) |
Basic Business Licenses (DCRA) | Free | Excel File | Business Licenses, this may be duplicated data. | http://opendata.dc.gov/datasets/basic-business-licenses (Links to an external site.) |
| | | | |
Politics | | | | |
Bill/Sponsors/Legislation Info | Free with id number | API (with lots of options) | Very cool API, link is to the documentation. It allows you to get info about current/past sessions, active bills, sponsorship of bills. | https://legiscan.com/gaits/documentation/legiscan |