Parking Meters by US Government | Ecommerce and Consumer Trends

About this Dataset

Parking Meters

A. SUMMARY Location, cap color and other key attributes of parking meters in San Francisco. Does not include operating schedules or rate schedules. B. METHODOLOGY Updated via the SFpark data warehouse (Parking Space Inventory) by meter shop staff, with manual updates sourced from SFMTA CAD drawings and MTAB resolutions. C. UPDATE FREQUENCY Updated weekly. D. OTHER CRITICAL INFO For active meters only, filter for "Active_Met" = 'M" or "T". Meter operating and rate schedules are more complex and available as separate tables. Key field for joining is the Parking Space ID field.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:17.466384
Tags: meters, parking-space-inventory, psi

Tables

Table 1

@usgov.city_of_san_francisco_parking_meters.table_1

2.69 MB
37819 rows
49 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "parking_space_id" VARCHAR,
  "post_id" VARCHAR,
  "ms_pay_station_id" VARCHAR,
  "ms_space_num" BIGINT,
  "sensor_flag" VARCHAR,
  "on_offstreet_type" VARCHAR,
  "osp_id" VARCHAR,
  "jurisdiction" VARCHAR,
  "pm_district_id" DOUBLE,
  "blockface_id" BIGINT,
  "active_meter_flag" VARCHAR,
  "reason_code" VARCHAR,
  "smart_meter_flag" VARCHAR,
  "meter_type" VARCHAR,
  "meter_vendor" VARCHAR,
  "meter_model" VARCHAR,
  "cap_color" VARCHAR,
  "pco_beat" VARCHAR,
  "old_rate_area" VARCHAR,
  "street_id" DOUBLE,
  "street_name" VARCHAR,
  "street_num" DOUBLE,
  "parity_digit_position" VARCHAR,
  "street_seg_ctrln_id" DOUBLE,
  "orientation" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "legislation_ref" VARCHAR,
  "legislation_dt" VARCHAR,
  "work_order" VARCHAR,
  "comments" VARCHAR,
  "collection_route" VARCHAR,
  "collection_subroute" VARCHAR,
  "pmr_route" VARCHAR,
  "nfc_key" VARCHAR,
  "spt_code" VARCHAR,
  "collection_route_desc" VARCHAR,
  "collection_subroute_desc" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" BIGINT,
  "analysis_neighborhoods" BIGINT,
  "neighborhoods" BIGINT,
  "sf_find_neighborhoods" BIGINT,
  "current_police_districts" BIGINT,
  "current_supervisor_districts" BIGINT
);