About this Dataset

Bike Volume - Manual Counts

A. SUMMARY
Bicycle counts (volume) from 2009-2017, with the exception of 2012 when counts were not collected.

B. METHODOLOGY
Manually updated

C. UPDATE FREQUENCY
Annually in the fall, counts are collected the second week of September in coordination with the National Bicycle and Pedestrian Documentation Project.

D. OTHER CRITICAL INFO
A bicycle count value of “-1” indicates a null value (bicycle count data was not collected at this location for that year). Bike counts for 2012 are not included in this file, as they are not available/unable to be located. One empty feature from the original “citywide_manual_bicycle_count_locations” (feature 50) was deleted.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:00.420558
Tags: bicycle, bicycle-counts, bike, bike-volume, volume

Tables

Table 1

@usgov.city_of_san_francisco_bike_volume_manual_counts.table_1

32.04 KB
119 rows
29 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "loc_id" BIGINT,
  "location" VARCHAR,
  "nodelayer" VARCHAR,
  "cnn" DOUBLE,
  "time" VARCHAR,
  "yr2006_pm" BIGINT,
  "yr2007_pm" BIGINT,
  "yr2008_pm" BIGINT,
  "yr2009_pm" BIGINT,
  "yr2010_pm" BIGINT,
  "yr2011_pm" BIGINT,
  "yr2013_pm" DOUBLE,
  "yr2014_pm" DOUBLE,
  "yr2015_pm" BIGINT,
  "yr2011padj" DOUBLE,
  "globalid" VARCHAR,
  "yr2016_pm" BIGINT,
  "yr2017_pm" BIGINT,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE
);