About this Dataset

Bicycle Parking Racks

A. SUMMARY This dataset contains the locations of bicycle parking racks installed by the SFMTA. The data includes locations that are installed on sidewalks, in on-street bicycle corrals, in city-owned garages, and in parklets. This dataset does not include racks installed on private property or in privately owned garages.

B. METHODOLOGY Locations are associated to an address so they may not reflect there actual placement along the sidewalk. Racks are installed in front of addresses along the sidewalk according to the SFMTA Bicycle Parking: Standards, Guidelines, Recommendations.https://www.sfmta.com/sites/default/files/pdfs/Bicycle_Parking_Guidelines.pdf

C. UPDATE FREQUENCY The dataset is updated quarterly as racks are continuously installed upon request from the public, businesses, and property owners as well as where the SFMTA sees demand.

D. OTHER CRITICAL INFO This dataset contains locations for racks installed on the sidewalk, on-street corrals, parklets and parcels, and in city-owned garages. The locations are associated to an address so they may not reflect the exact location installed.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:37.005229
Tags: bicycle-corrals, bicycle-parking, bicycle-racks, bicycles, bike, bike-cages, bike-corrals, bike-parking, bike-racks, bikes, corrals, racks

Tables

Table 1

@usgov.city_of_san_francisco_bicycle_parking.table_1

431.06 kB
6,035 rows
25 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "address" VARCHAR,
  "location" VARCHAR,
  "street" VARCHAR,
  "placement" VARCHAR,
  "racks" BIGINT,
  "spaces" BIGINT,
  "globalid" VARCHAR,
  "install_yr" DOUBLE,
  "install_mo" DOUBLE,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "sf_find_neighborhoods_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "current_supervisor_districts_2" DOUBLE,
  "analysis_neighborhoods_2" DOUBLE,
  "analysis_neighborhoods_2010_census_tracts_assigned_to__c0e174db" DOUBLE  -- Analysis Neighborhoods - 2010 Census Tracts Assigned To Neighborhoods 2,
  "cbd_bid_and_gbd_boundaries_as_of_2017_2" DOUBLE  -- CBD, BID And GBD Boundaries As Of 2017–2,
  "central_market_tenderloin_boundary_polygon_updated_2" DOUBLE  -- Central Market/Tenderloin Boundary Polygon - Updated 2,
  "neighborhoods" DOUBLE
);