This data as json
rowid | locationid | Applicant | FacilityType | cnn | LocationDescription | Address | blocklot | block | lot | permit | Status | FoodItems | X | Y | Latitude | Longitude | Schedule | dayshours | NOISent | Approved | Received | PriorPermit | ExpirationDate | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
345 | 934391 | 65 | 1 | 3525000 | CALIFORNIA ST: DAVIS ST to FRONT ST (100 - 199) | 150 CALIFORNIA ST | 0236019 | 118 | 019 | 17MFF-0075 | 5 | Expresso drinks: assorted beverages (canned: bottled: home made): scones: croissants: bagels: soup: chili: parfaits: smoothies: frappes: milk shakes. | 6013145.602999999 | 2117020.1569999997 | 37.7936733815047 | -122.398463509486 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0075&ExportPDF=1&Filename=17MFF-0075_schedule.pdf | Tu/Th:6AM-8PM | 03/10/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7936733815047, -122.398463509486) |