Name: Mobile Food Facility Permit
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Mobile Food Facility Permit

Mobile Food Facility Permits including name of vendor, location, type of food sold and status of permit. Mobile Food Facility Permit Schedule is here https://data.sfgov.org/d/jjew-r69b
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:52.714247
Tags: facility, food, mff, mobile, permits, truck

Tables

Table 1

@usgov.city_of_san_francisco_mobile_food_facility_permit.table_1

92.78 kB
497 rows
29 columns

CREATE TABLE table_1 (
  "locationid" BIGINT,
  "applicant" VARCHAR,
  "facilitytype" VARCHAR,
  "cnn" BIGINT,
  "locationdescription" VARCHAR,
  "address" VARCHAR,
  "blocklot" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "permit" VARCHAR,
  "status" VARCHAR,
  "fooditems" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "schedule" VARCHAR,
  "dayshours" VARCHAR,
  "noisent" VARCHAR,
  "approved" VARCHAR,
  "received" BIGINT,
  "priorpermit" BIGINT,
  "expirationdate" VARCHAR,
  "location" VARCHAR,
  "fire_prevention_districts" DOUBLE,
  "police_districts" DOUBLE,
  "supervisor_districts" DOUBLE,
  "zip_codes" DOUBLE,
  "neighborhoods_old" DOUBLE  -- Neighborhoods (old)
);