About this Dataset

Parking Regulations (except Non-metered Color Curb)

A. SUMMARY Parking regulations by blockface for the City of San Francisco. Includes the following regulations: Residential Parking Permits, Time limits, Government Permit, No overnight, Oversized Vehicle. Does not include non metered color curb or curb cuts. Update as of 1/1/2018: started recording No parking any time (regulations like ""TOW AWAY NO PARKING""), Limited No Parking (tow-away or no parking for certain periods of the day), B. METHODOLOGY Mix of manual updates and data compilation. C. UPDATE FREQUENCY Updated as MTA Board resolutions are passed that impact parking regulations. D. OTHER CRITICAL INFO This dataset has not been comprehensively updated or vetted for accuracy. Dataset does not include color curb regulations such as loading zones or blue zones. Does not include detailed information for metered parking such as cap color or operating hours, which is contained in a separate relational database maintained by SFpark. No parking any time block faces were verified using Google Streetview, and only for Mission Bay blockfaces (Feburary 2017). "
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:36.696095
Tags: government-permit, limited-no-parking, no-overnight-parking, no-parking-any-time, oversized-vehicles, parking, parking-regulations, permit, residential-parking-permit, rpp, time-limits

Tables

Table 1

@usgov.city_of_san_francisco_parking_regulations_except_non_m_1044583c.table_1

623.79 kB
7,783 rows
40 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "agency" VARCHAR,
  "regulation" VARCHAR,
  "days" VARCHAR,
  "hours" VARCHAR,
  "hrs_begin" DOUBLE,
  "hrs_end" DOUBLE,
  "regdetails" VARCHAR,
  "modified" TIMESTAMP,
  "editor" VARCHAR,
  "rpparea1" VARCHAR,
  "rpparea2" VARCHAR,
  "rpparea3" VARCHAR,
  "fid_100" DOUBLE,
  "length_ft" DOUBLE,
  "conflict" DOUBLE,
  "enacted" VARCHAR,
  "created_us" VARCHAR,
  "created_da" DOUBLE,
  "last_edite" VARCHAR,
  "last_edi_1" DOUBLE,
  "hrlimit" DOUBLE,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "rpp_sym" VARCHAR,
  "mtab_date" TIMESTAMP,
  "mtab_motion" VARCHAR,
  "mtab_reso_text" VARCHAR,
  "sym_rpp2" VARCHAR,
  "globalid" VARCHAR,
  "exceptions" VARCHAR,
  "from_time" VARCHAR,
  "to_time" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" VARCHAR,
  "data_loaded_at" VARCHAR
);