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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
323 | 943986 | 65 | 1 | 5869000 | FRONT ST: CALIFORNIA ST to HALLECK ST (200 - 234) | 150 CALIFORNIA ST | 0236019 | 118 | 019 | 17MFF-0127 | 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-0127&ExportPDF=1&Filename=17MFF-0127_schedule.pdf | Mo-Fr:6AM-5PM | 03/10/2017 12:00:00 AM | 2017-02-28 | 0 | 03/15/2018 12:00:00 AM | (37.7936733815047, -122.398463509486) |