search

louisvillemetro-innovation / IFTTT-Smart-City-Data-Integrator

IFTTT Smart City Data Integrator (SCDI) Project is a system to grab open data updates and send them to IFTTT for action.
https://ifttt.com/smartlouisville
MIT License
6 stars 0 forks source link

Monthly Restaurant Inspection Report #13

Open mgottholsen opened 6 years ago

mgottholsen commented 6 years ago

From @mgottholsen on June 28, 2017 17:48

See this article. www.bizjournals.com/louisville/news/2017/04/12/these-louisville-restaurants-had-critical-food.html

Now, automate it.

Copied from original issue: mgottholsen/IFTTT-Smart-Louisville#13

mgottholsen commented 6 years ago

@jorgefelico You up for tackling this one?

mgottholsen commented 6 years ago

From @jorgefelico on July 4, 2017 2:59

Sure am!

mgottholsen commented 6 years ago

See also https://github.com/LouisvilleMetro/IFTTT-Smart-Louisville/issues/11

mgottholsen commented 6 years ago

New Feature Description:

As an IFTTT user, I want to receive a time-based (daily, weekly, monthly, quarterly) digest of critical food code violations of all restaurants that have been inspected.

Template:

Restaurant Name, Address Grade Inspection Result (bulleted list)

mgottholsen commented 6 years ago

From @jorgefelico on November 22, 2017 14:20

@mgottholsen I'm working on this issue and noticed that our open data for the inspections does not have the inspection result as a list. We only have the score and grade. Here's a sample of one entry:

EstablishmentID: "27867",
InspectionID: "1320961",
EstablishmentName: "FUNNEL CAKE #5",
PlaceName: " ",
Address: "MOBILE UNIT",
Address2: null,
City: "LOUISVILLE",
State: "KY",
Zip: "40202",
TypeDescription: "SELF-CONTAINED MOBILE FOOD UNITS",
Latitude: "38.2527",
Longitude   : "-85.7585",
InspectionDate: "2017-09-03 00:00:00",
Score: "93",
Grade: "C",
NameSearch: "FUNNELCAKE",
Intersection: null

So, my proposal

Template

Restaurant Name, Address Grade Score

mgottholsen commented 6 years ago

There are a couple of different datasets that contain this information, but would require additional leg work.

We could pull just from Restaurant Inspection Scores. Or we could pull a query from the open data site that joins the following:

https://data.louisvilleky.gov/dataset/inspections https://data.louisvilleky.gov/dataset/establishments

Or even:

https://data.louisvilleky.gov/dataset/yelp-data (the preview on this one does not automatically update, but the file download does. Or we could pull the files from S3)

Thoughts?

mgottholsen commented 6 years ago

Also, check out some of the other datasets https://data.louisvilleky.gov/group/health-wellness