Continental Crosswalks by US Government | Demographics and Population Studies

About this Dataset

Continental Crosswalks

A. SUMMARY This dataset lists intersections that have at least one continental crosswalk and meet the following criteria:

Installed after January 1st, 2015
Installed before January 1st, 2015 and on the high injury network Continental crosswalks are marked with bold, wide stripes to indicate safe places for pedestrians to cross the road. Their high-visibility design helps alert drivers and cyclists to watch for people crossing. B. HOW THE DATASET IS CREATED Locations of continental crosswalks collected at the intersection level. Pre-2015 data was collected in the summer of 2019 as a one-time effort to locate every intersection with continental crosswalks on the city's High Injury Network. Crosswalks painted post-2015 are collected as part of Vision Zero data reporting. "Shops reports" are used as the data source. Shops reports include data citywide. Crosswalks marked "UNDETERMINED" in the "CONTINENTAL" field may or may not have continental crosswalks and require additional scrutiny. These two data sources were joined with an intersection nodes layer to create the feature class. The dataset is made available by SFMTA via their ArcGIS server/ feature server. C. UPDATE PROCESS The dataset is updated by MTA quarterly and published to the Open Data Portal automatically. D. HOW TO USE THIS DATASET This dataset includes: (1) all continental crosswalks citywide that were installed after 1/1/2015, and (2) all continental crosswalks that were installed before 12/31/2014 on the High Injury Network. It does not include continental crosswalks off the High Injury Network that were painted before 2015.
Organization: City of San Francisco
Last updated: 2025-03-29T16:58:36.112675

Tables

Table 1

@usgov.city_of_san_francisco_continental_crosswalks.table_1

665.08 KB
9678 rows
22 columns


CREATE TABLE table_1 (
  "objectid_12" BIGINT,
  "objectid" BIGINT,
  "objectid_1" BIGINT,
  "nodelayer" VARCHAR,
  "cnn" BIGINT,
  "streetname" VARCHAR,
  "cross_street" VARCHAR,
  "report_date" VARCHAR,
  "yr_install" BIGINT,
  "continental" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "last_repaint_date" DOUBLE,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "shape" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);