Baselight

Mobile Food Facility Permit

City of San Francisco

@usgov.city_of_san_francisco_mobile_food_facility_permit

Loading...
Loading...

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
Loading...
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)
);

Share link

Anyone who has the link will be able to view this.