Name: Safer Routes Program - Schools
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Safer Routes Program - Schools

A. SUMMARY This dataset was created to show the locations of participating schools in the SRTS program (from 2009 to present).

B. METHODOLOGY Manually updated using posted list of schools on http://sfsaferoutes.org/

C. UPDATE FREQUENCY Annually

D. OTHER CRITICAL INFO N/A
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:21.960607

Tables

Table 1

@usgov.city_of_san_francisco_safer_routes_program_schools.table_1

39.16 KB
46 rows
26 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "address" VARCHAR,
  "streetname" VARCHAR,
  "supdist" BIGINT,
  "grade" VARCHAR,
  "grade_cat" VARCHAR,
  "public" VARCHAR,
  "school" VARCHAR,
  "full_name" VARCHAR,
  "schoolzone" BIGINT,
  "f2009_2010" VARCHAR,
  "f2010_2011" VARCHAR,
  "f2011_2012" VARCHAR,
  "f2012_2013" VARCHAR,
  "f2013_2014" VARCHAR,
  "f2014_2015" VARCHAR,
  "f2015_2016" VARCHAR,
  "f2016_2017" VARCHAR,
  "formername" VARCHAR,
  "f2017_2018" VARCHAR,
  "nhood" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" BIGINT
);