About this Dataset

SFMTA - Off-Street Parking Locations (Lots And Parking Garages)

A. PURPOSE
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: 2023-12-02T06:11:46.380438

Tables

Table 1

@usgov.city_of_san_francisco_mta_offstreetparking_data.table_1

215.1 kB
1,406 rows
61 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "owner" VARCHAR,
  "globalid" VARCHAR,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "off_id_1" BIGINT,
  "twohr_1" BIGINT,
  "wedopen" BIGINT,
  "friopen" BIGINT,
  "address_1" VARCHAR,
  "wedclose" BIGINT,
  "sunopen" BIGINT,
  "early1star" BIGINT,
  "ver_date_1" VARCHAR,
  "tuesclose" BIGINT,
  "onehr_1" DOUBLE,
  "evestart" DOUBLE,
  "early1end" BIGINT,
  "eveend" DOUBLE,
  "secondty_1" VARCHAR,
  "oldhours_1" VARCHAR,
  "friclosed" BIGINT,
  "earlybird1" BIGINT,
  "notes_1" VARCHAR,
  "thursclose" BIGINT,
  "eveflat_1" BIGINT,
  "assessor_1" BIGINT,
  "regmonth_1" BIGINT,
  "primetyp_1" VARCHAR,
  "satclose" BIGINT,
  "lotgone" BIGINT,
  "twelvehr_1" BIGINT,
  "monclose" BIGINT,
  "dailyfla_1" BIGINT,
  "g_l_1" VARCHAR,
  "dailyend" DOUBLE,
  "verifier_1" VARCHAR,
  "name2_1" VARCHAR,
  "tuesopen" BIGINT,
  "oldhours" VARCHAR,
  "assignmt_1" BIGINT,
  "early2star" BIGINT,
  "regcap_1" BIGINT,
  "thursopen" BIGINT,
  "dailystart" DOUBLE,
  "fourhr_1" BIGINT,
  "monopen" BIGINT,
  "definiti_1" VARCHAR,
  "early2end" BIGINT,
  "threehr_1" DOUBLE,
  "sunclose" BIGINT,
  "mc_cap_1" BIGINT,
  "earlybird2" BIGINT,
  "valetcap_1" BIGINT,
  "name1_1" VARCHAR,
  "satopen" BIGINT,
  "agency_1" VARCHAR,
  "dailymax_1" BIGINT
);