Baselight

2015 Project Appendix

City of San Francisco

@usgov.city_of_san_francisco_2015_project_appendix

Loading...
Loading...

About this Dataset

2015 Project Appendix

This is an appendix for future general fund capital projects as they have been entered by departments and collected by the capital planning program
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:05.508069

Tables

Table 1

@usgov.city_of_san_francisco_2015_project_appendix.table_1
  • 54.92 KB
  • 126 rows
  • 33 columns
Loading...

CREATE TABLE table_1 (
  "projectid" BIGINT,
  "projectname" VARCHAR,
  "address" VARCHAR,
  "short_description" VARCHAR,
  "plan_status" VARCHAR,
  "departmentname" VARCHAR,
  "fundingprinciple" VARCHAR,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE,
  "n_2025" DOUBLE,
  "fund_fy6_10" DOUBLE,
  "futurefund" DOUBLE,
  "fundtotal" DOUBLE,
  "plantotal" DOUBLE,
  "fundname" VARCHAR,
  "groupname" VARCHAR,
  "project_image" VARCHAR,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "delete_fire_prevention_districts" DOUBLE,
  "delete_police_districts" DOUBLE,
  "delete_supervisor_districts" DOUBLE,
  "delete_zip_codes" DOUBLE,
  "delete_neighborhoods" DOUBLE
);

Share link

Anyone who has the link will be able to view this.