Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Received (date)
Link | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
509 | 509 | 934819 | Natan's Catering 100 | Truck 1 | 197101 | 03RD ST: MARIN ST to ARTHUR AVE \ CARGO WAY (3201 - 3399) -- EAST -- | 3201 03RD ST | 4377001 | 4377 213 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6016160.221 | 2100487.333 | 37.748445338837705 | -122.38687903198 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7484453388377, -122.38687903198) | ||
516 | 516 | 934822 | Natan's Catering 100 | Truck 1 | 7164000 | Assessors Block 8722/Lot001 | 8722001 | 8722 268 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6016110.001 | 2107608.418 | 37.7679955456856 | -122.387549426547 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7679955456856, -122.387549426547) | |||
517 | 517 | 934809 | Natan's Catering 100 | Truck 1 | 7166000 | ILLINOIS ST: MARIPOSA ST \ TERRY A FRANCOIS BLVD to 18TH ST (600 - 699) | Assessors Block 3941/Lot001 | 3941001 | 3941 347 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6016208.818 | 2106421.254 | 37.764741322675 | -122.387124812179 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.764741322675, -122.387124812179) | ||
519 | 519 | 934817 | Natan's Catering 100 | Truck 1 | 10827000 | QUINT ST: ARTHUR AVE to CUSTER AVE (1 - 199) | 50 QUINT ST | 5201001 | 5201 348 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6015535.265 | 2099780.721 | 37.7464705066471 | -122.388990808654 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7464705066471, -122.388990808654) | ||
526 | 526 | 934798 | Natan's Catering 100 | Truck 1 | 698000 | 16TH ST: 04TH ST to OWENS ST (600 - 699) | 600 16TH ST | 8718001 | 8718 354 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6015149.302 | 2107435.0609999998 | 37.7674662871448 | -122.390860289431 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7674662871448, -122.390860289431) | ||
531 | 531 | 934791 | Natan's Catering 100 | Truck 1 | 6759001 | HARRISON ST: 26TH ST to KAMILLE CT (3000 - 3048) | 3040 HARRISON ST | 6573001 | 6573 357 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6008722.691000001 | 2100785.001 | 37.748848056566295 | -122.412618994655 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7488480565663, -122.412618994655) | ||
541 | 541 | 934824 | Natan's Catering 100 | Truck 1 | 15019101 | MISSION BAY BLVD SOUTH: 03RD ST \ MISSION BAY BLVD to 04TH ST \ MISSION BAY BLVD (501 - 599) | Assessors Block 8732/Lot001 | 8732001 | 8732 363 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6015193.322000001 | 2108612.958 | 37.770702976097496 | -122.39079035556601 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7707029760975, -122.390790355566) | ||
544 | 544 | 934804 | Natan's Catering 100 | Truck 1 | 0 | Assessors Block 4046/Lot001 | 4046001 | 4046 366 | 001 | 17MFF-0123 | APPROVED 5 | Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks | 6016675.163 | 2105416.559 | 37.7620084580302 | -122.38544181156799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf | 04/07/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7620084580302, -122.385441811568) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Mobile_Food_Facility_Permit" ( "locationid" INTEGER, "Applicant" INTEGER, "FacilityType" INTEGER, "cnn" INTEGER, "LocationDescription" TEXT, "Address" TEXT, "blocklot" TEXT, "block" INTEGER, "lot" TEXT, "permit" TEXT, "Status" INTEGER, "FoodItems" TEXT, "X" REAL, "Y" REAL, "Latitude" REAL, "Longitude" REAL, "Schedule" TEXT, "dayshours" REAL, "NOISent" REAL, "Approved" REAL, "Received" TEXT, "PriorPermit" INTEGER, "ExpirationDate" REAL, "Location" TEXT , FOREIGN KEY ("Applicant") REFERENCES [Applicant](id), FOREIGN KEY ("FacilityType") REFERENCES [FacilityType](id), FOREIGN KEY ("Status") REFERENCES [Status](id), FOREIGN KEY ("block") REFERENCES [block](id)); CREATE INDEX ["Mobile_Food_Facility_Permit_Applicant"] ON [Mobile_Food_Facility_Permit]("Applicant"); CREATE INDEX ["Mobile_Food_Facility_Permit_FacilityType"] ON [Mobile_Food_Facility_Permit]("FacilityType"); CREATE INDEX ["Mobile_Food_Facility_Permit_Status"] ON [Mobile_Food_Facility_Permit]("Status"); CREATE INDEX ["Mobile_Food_Facility_Permit_block"] ON [Mobile_Food_Facility_Permit]("block");