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
GET http://api.civicapps.org/restaurant-inspections/
The data seems to be out-of-date. There are no inspection reports after Oct. 2012?
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"
Thanks for catching that and reporting it here, it has been fixed and is working now.
It looks as though all the Lat/Longs are exactly the same for each restaurant listing. Can this be fixed?
Also, is there no way to call a restaurant by id or restaurant_id ???
The lat/lon problem has been resolved. We'll work on adding a restaurant id/name lookup over the next week.
Thanks for the quick response!
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.
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.
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