Geocode Restaurant Inspection Data

[jasonasher]

Start with the DC DOH Food Service Establishment Inspection report data in the /Data Sets/Restaurant Inspections/ folder in Dropbox.

Write a script to geocode each inspection (using the establishment address data in the inspection summary file).

Input: CSV files with inspection summary and violation details

Output: A CSV file with

• 1 row for each inspection id
• The dataset should include the following columns:

inspection_id: The ID for the inspection latitude: The latitude of the establishment address of the inspection longitude: The latitude of the establishment address of the inspection

When you are finished Submit a pull request on GitHub (or upload your scripts) Upload any files to Dropbox Let Jason or Elizabeth know so they can make sure the results are widely available as other issues depend upon this step.

Need more information? Flag Jason or Elizabeth, or ask your question in the comments below and we'll respond as soon as we can!

[dardinel]

Jason, looks like I will be late tomorrow but I went ahead and did the geocodes on this since your notes said other things were dependent on it. I put the output file, the R code used to create it, and a sample plot of points dropped on a map into your dropbox. Hope this helps.

• Greg

[jasonasher]

This is great - thank you, especially for doing it so early!