Baselight

On-street Carshare Parking

City of San Francisco

@usgov.city_of_san_francisco_on_street_carshare_parking

Loading...
Loading...

About this Dataset

On-street Carshare Parking

A. SUMMARY This dataset was first created as part of the SFMTA On Street Car Share Pilot Program (approved by the MTA Board in July 2013) to illustrate the location of implemented and planned (various stages) spaces throughout the city. B. METHODOLOGY The locations were originally provided to the MTA as requests by the three car share organizations (CSOs). These were given as a .kml file, which was converted to a .shp. Additional fields were created using spatial joins (zipcode, supervisor district, CNN, etc). Use definition query tool to display those locations with a certain attribute. For example, query Existing = 1 to display those locations that are on street operating. 500 submissions were given by CSOs to the MTA, but only a portion of those were brought to the MTA Board for approval, and even fewer were implemented as operational on street spaces. With no definition query, you can see all spaces as features, with varying levels of data completion. C. UPDATE FREQUENCY During periods of implementation/construction, updates were as frequent as daily or weekly. However, as the frequency of newly implemented spaces slowed over the course of the pilot, updates occurred less frequently--weekly or monthly. Updates will be needed as new spaces are implemented--many of the spaces not taken past MTA Board approval have incomplete data. D. OTHER CRITICAL INFO Each feature (or each row, or point) represents a single car share parking space. Some parking spaces belong to a "pod" where there are two adjacent car share parking spaces, indicated by the "PodType" field. To summarize or analyze by pod, use the "POD" field.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:32.987230
Tags: car-share, carshare, on-street-car-share, on-street-car-share-pilot, onstreet

Tables

Table 1

@usgov.city_of_san_francisco_on_street_carshare_parking.table_1
  • 42.09 KB
  • 175 rows
  • 44 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "spaceid" VARCHAR,
  "info" VARCHAR,
  "pod" VARCHAR,
  "space_type" VARCHAR,
  "cso" VARCHAR,
  "datesubmit" VARCHAR,
  "datemodify" VARCHAR,
  "existing" VARCHAR,
  "conflict" VARCHAR,
  "flag_note" VARCHAR,
  "point_x" DOUBLE,
  "point_y" DOUBLE,
  "st_name" VARCHAR,
  "st_type" VARCHAR,
  "streetname" VARCHAR,
  "addrange" VARCHAR,
  "post_id" VARCHAR,
  "ph_date" VARCHAR,
  "tasc_date" VARCHAR,
  "mtab_date" VARCHAR,
  "approval" VARCHAR,
  "wo_log_no" VARCHAR,
  "wo_round" VARCHAR,
  "wo_status" VARCHAR,
  "wo_complet" VARCHAR,
  "oper_date" VARCHAR,
  "address" VARCHAR,
  "intrsxn" VARCHAR,
  "cnn_seg" DOUBLE,
  "cnn_intxn" DOUBLE,
  "podtype" VARCHAR,
  "zipcode" VARCHAR,
  "nhood" VARCHAR,
  "pricezone" BIGINT,
  "supname" VARCHAR,
  "supdstrict" BIGINT,
  "status" VARCHAR,
  "cso_num" VARCHAR,
  "globalid" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR
);

Share link

Anyone who has the link will be able to view this.