About this Dataset

SFMTA Projects - Points

A. SUMMARY This dataset is the data behind the Interactive Project Map (IPM) Collector Tool web map. The IPM web map gathers spatial data for agency projects that have project pages on SFMTA.com and CIP projects. For more information about this dataset please contact ProjectMap@sfmta.com B. METHODOLOGY Data is collected from project managers and SFMTA.com project page editors through the Interactive Project Map Collector Tool. C. UPDATE FREQUENCY The data is updated on an as needed basis. Project geographies should be updated by project managers and project pge editors whenever project extents change. D. OTHER CRITICAL INFO Please note there is a 250ft buffer for projects to more accurately represent the supervisor districts and neighborhoods that could potentially be affected by a project.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:40.674742

Tables

Table 1

@usgov.city_of_san_francisco_sfmta_projects_points.table_1

42.66 KB
238 rows
29 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "projectnode" BIGINT,
  "projectname" VARCHAR,
  "cip_id" VARCHAR,
  "cip_title" VARCHAR,
  "projectpage" VARCHAR,
  "teaser" VARCHAR,
  "projectphase" VARCHAR,
  "projecttype" VARCHAR,
  "partneragencies" VARCHAR,
  "webpagepublished" VARCHAR,
  "supervisorname" VARCHAR,
  "supervisordistrict" VARCHAR,
  "neighborhood" VARCHAR,
  "map_option" VARCHAR,
  "geoevent_lastupdate" TIMESTAMP,
  "created_date" TIMESTAMP,
  "created_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "nhood_node" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "current_supervisor_districts_2" BIGINT,
  "analysis_neighborhoods_2" DOUBLE,
  "neighborhoods" DOUBLE
);