tools and scripts for dealing with Portland, OR restaurant inspection data
Shell Ruby PLpgSQL
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
out
script
sql
.gitignore
Gemfile
Gemfile.lock
UCM374510.pdf
readme.md

readme.md

A poorly documented collection of tools and scripts to export Portland, OR. restaurant inspection data from the Civic Apps API, import it into postgres, and export relevant CSV data.

Requirements

General usage

script/sync       # fetches all inspections for 2014 from the civic apps api
script/tocsv      # converts raw inspection and violation data to csv files
script/psqlimport # imports data to postgres database named 'portland'
script/process    # performs a variety of task on the raw data (overlappoing point jittering, postgis Geom from lat/lon, etc.) and exports relevant csv files to the out/ directory