Crossing Guard Intersections by US Government | Demographics and Population Studies

About this Dataset

Crossing Guard Intersections

A. SUMMARY
This table contains information about the intersection locations served by the SFMTA Adult School Crossing Guard Program. The placement and assignment of crossing guards is dependent on a number of criteria. To find out more about the program, please visit: http://www.sfmta.com/services/streets-sidewalks/request-crossing-guard.

B. METHODOLOGY
Manually updated.Updates from School Crossing Guard Program Manager.

C. UPDATE FREQUENCY
Updated as needed

D. OTHER CRITICAL INFO
N/A
Organization: City of San Francisco
Last updated: 2020-12-04T19:35:27.787798

Tables

Table 1

@usgov.city_of_san_francisco_crossing_guard_intersections_points.table_1

26.65 KB
156 rows
19 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cnn" BIGINT,
  "street1" VARCHAR,
  "street2" VARCHAR,
  "street3" VARCHAR,
  "street4" VARCHAR,
  "primary_st" VARCHAR,
  "secondary" VARCHAR,
  "school_nam" VARCHAR,
  "num_guards" BIGINT,
  "created_user" VARCHAR,
  "created_date" DOUBLE,
  "last_edited_user" VARCHAR,
  "last_edited_date" BIGINT,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" BIGINT
);