About this Dataset

Parking Signs / Street Space Permits

Parking Signs / Street Space permits are generally issued for construction related work such as building construction activities or sidewalk repair work. Related photos of posted signs are here: https://data.sfgov.org/d/pigs-fac7
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:54.107720
Tags: buildings, construction, parking, permits, sfmta, sidewalk, signs, space, street, tow, verification

Tables

Table 1

@usgov.city_of_san_francisco_parking_signs_street_space_permits.table_1

165.06 kB
941 rows
32 columns

CREATE TABLE table_1 (
  "datetimeentered" VARCHAR,
  "datetimeposted" VARCHAR,
  "updatedon" VARCHAR,
  "category" VARCHAR,
  "source" VARCHAR,
  "signtype" VARCHAR,
  "companyname" VARCHAR,
  "companyphone" VARCHAR,
  "permitnumber" VARCHAR,
  "numberofsigns" BIGINT,
  "startdate" VARCHAR,
  "enddate" VARCHAR,
  "starttime" VARCHAR,
  "endtime" VARCHAR,
  "notes" VARCHAR,
  "n_24hourenforcement" VARCHAR  -- 24HourEnforcement,
  "signid" BIGINT,
  "sideofstreet" VARCHAR,
  "location_desc" VARCHAR,
  "address" VARCHAR,
  "cnn" BIGINT,
  "streetfrontagefeet" BIGINT,
  "block" VARCHAR,
  "lot" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "signlink" VARCHAR,
  "alldatalink" VARCHAR,
  "streetfrontagename" VARCHAR,
  "streetfrontagefrom" VARCHAR,
  "streetfrontageto" VARCHAR
);