About this Dataset

SFMTA Managed Off-street Parking

A. SUMMARY SFMTA managed off street parking locations, hours, and amenities. Includes both lots and garages. B. METHODOLOGY Imported from SFpark data warehouse C. UPDATE FREQUENCY Updated once per month D. OTHER CRITICAL INFO Includes both lots and garages operated by SFMTA
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:01.870322
Tags: garages, lots, off-street, parking

Tables

Table 1

@usgov.city_of_san_francisco_sfmta_managed_off_street_parking.table_1

39.88 kB
46 rows
46 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "osp_id" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "location" VARCHAR,
  "phone" VARCHAR,
  "pm_district_id" BIGINT,
  "area_type" VARCHAR,
  "blockface_id" BIGINT,
  "street_seg_ctrln_id" BIGINT,
  "facility_type" VARCHAR,
  "owner" VARCHAR,
  "sensor_flag" VARCHAR,
  "meter_flag" VARCHAR,
  "data_feed_flag" VARCHAR,
  "services" VARCHAR,
  "web_site" VARCHAR,
  "veh_entry_lanes" BIGINT,
  "mc_entry_lanes" BIGINT,
  "veh_exit_lanes" BIGINT,
  "mc_exit_lanes" BIGINT,
  "system" VARCHAR,
  "hi_vol_disc_flag" VARCHAR,
  "validation_pgm" VARCHAR,
  "sp_evt_rates" VARCHAR,
  "activation_fee" BIGINT,
  "card_replace_fee" BIGINT,
  "late_fee" BIGINT,
  "reopen_fee" BIGINT,
  "no_key_valet_fee" BIGINT,
  "capacity" BIGINT,
  "main_entrance_long" DOUBLE,
  "main_entrance_lat" DOUBLE,
  "created_dt" VARCHAR,
  "last_upd_dt" VARCHAR,
  "globalid" 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
);