Mobile_Food_Facility_Permit

Data source: data.sfgov.org

8 rows where Applicant = 49

View and edit SQL

Suggested facets: lot, dayshours, 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
183 936620 BH & MT LLC 49 Truck 1 10770000 PRESIDIO AVE: POST ST to GEARY BLVD (900 - 999) 949 PRESIDIO AVE 1072001 1072 151 001 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 5999130.566000001 2113756.702 37.7839220701115 -122.446721633172 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:9AM-10AM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7839220701115, -122.446721633172)
184 936622 BH & MT LLC 49 Truck 1 736000 16TH ST: SPENCER ST to DOLORES ST (3220 - 3299) 3253 16TH ST 3567039 3567 152 039 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 6005214.0879999995 2106542.595 37.7644595214424 -122.42516137635799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:10AM-11AM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7644595214424, -122.425161376358)
185 936625 BH & MT LLC 49 Truck 1 10048000 OTIS ST: GOUGH ST \ MCCOPPIN ST to 13TH ST \ DUBOCE AVE \ HWY 101 NORTHBOUND RAMP \ MISSION ST (100 - 199) 170 OTIS ST 3513007 3513 153 007 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:6AM-9AM/11AM-3PM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (0, 0)
186 936619 BH & MT LLC 49 Truck 1 6563000 GROVE ST: SCOTT ST to DIVISADERO ST (1200 - 1299) 1265 GROVE ST 1202002D 1202 154 002D 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 6001782.163 2110734.277 37.775774368410296 -122.437331607841 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:9AM-10AM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7757743684103, -122.437331607841)
187 936623 BH & MT LLC 49 Truck 1 8764101 MARKET ST: CHURCH ST to 15TH ST (2101 - 2195) -- SOUTH -- 2145 MARKET ST 3543003B 3543 155 003B 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 6003973.245 2107356.733 37.7666247727157 -122.429511176347 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:10AM-11AM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7666247727157, -122.429511176347)
189 936626 BH & MT LLC 49 Truck 1 25871000 DOLORES ST: 14TH ST intersection 2001 MARKET ST 3535001 3535 157 001 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 6004679.693 2107959.664 37.7683202495106 -122.427110643955 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf     02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7683202495106, -122.427110643955)
190 936624 BH & MT LLC 49 Truck 1 1232000 23RD ST: END to ILLINOIS ST (100 - 699) 401 23RD ST 4232010 4232 158 010 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 6016887.317000001 2102871.037 37.7550307267667 -122.384530734223 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:11AM-12PM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7550307267667, -122.384530734223)
191 936621 BH & MT LLC 49 Truck 1 6565000 GROVE ST: BRODERICK ST to BAKER ST (1400 - 1499) 1477 GROVE ST 1200015 1200 159 015 17MFF-0125 APPROVED 5 Cold Truck: Breakfast: Sandwiches: Salads: Pre-Packaged Snacks: Beverages 6000796.183999999 2110578.3540000003 37.7752901423195 -122.44073116211099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0125&ExportPDF=1&Filename=17MFF-0125_schedule.pdf Mo-Fr:10AM-11AM   02/22/2017 12:00:00 AM 2017-02-22 1 03/15/2018 12:00:00 AM (37.7752901423195, -122.440731162111)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 42.885ms · Data source: data.sfgov.org