Datasets > Restaurant Inspections

Category Public Safety
Agency City of Portland
Sub-Agency Technology
Date Released September 28, 2012
Date Updated September 28, 2012
Frequency As needed
Description

RESTful web service returning 25 most recent restaurant inspections by default. Optional parameters include Count, Since, and From & To, in support of the number of records to return and date filters. Sourced from Multnomah County.
Agency Program City of Portland / Technology
Technical Documentation Restaurant Inspections (metadata)
Keywords
Discussion
hanajensen :: October 15, 2012 - 7:44pm

GET http://api.civicapps.org/restaurant-inspections/

aferlitsch :: December 1, 2013 - 9:41am

The data seems to be out-of-date. There are no inspection reports after Oct. 2012?

toadslick :: January 1, 2014 - 1:16pm

There appears to be a SQL error when trying to perform location-based queries on the API. If I try to run the example request, I receive the following error message: GET http://api.civicapps.org/restaurant-inspections/near/-122.663148,45.577742?distance=5&limit=5&format=geojson "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY distance' at line 1"

chnelson :: January 2, 2014 - 10:29am

Thanks for catching that and reporting it here, it has been fixed and is working now.

mtupper :: April 15, 2015 - 2:31pm

It looks as though all the Lat/Longs are exactly the same for each restaurant listing. Can this be fixed?

mtupper :: April 15, 2015 - 6:21pm

Also, is there no way to call a restaurant by id or restaurant_id ???

cjohnk :: April 16, 2015 - 9:11am

The lat/lon problem has been resolved. We'll work on adding a restaurant id/name lookup over the next week.

mtupper :: April 16, 2015 - 9:41am

Thanks for the quick response!

cjohnk :: April 24, 2015 - 3:35pm

I've just added parameters that allow you to specify a particular restaurant id, or provide part or all of a restaurant name for a case insensitive search.

Snacky :: July 13, 2015 - 7:03pm

I've been doing parallel work; I created an API for the inspections: https://github.com/eaternet/adapters-ruby/blob/master/lib/eaternet/agencies/multco.rb It produces output in the LIVES open data format, http://www.yelp.com/healthscores. It's one of several I've made: https://github.com/eaternet/adapters-ruby/blob/master/README.md Now, though, Multnomah County has moved to a new information system and both my feed and yours are no longer getting new information. Would you like to collaborate on a new 'adapter' for the County? I've gotten in contact with Accela, the portal provider, and it seems like I'll be able to use an API to get the information going forward.

bjmcdonough :: February 19, 2016 - 2:50pm

Hi Snacky, Any word on pulling the information from the new Multnomah County system. I'm currently writing a IOS App and information is only good up to (5.13.2015) the cut-over . Thanks! Brian :) bjmcdonough@gmail.com