2015 Project Appendix
City of San Francisco
@usgov.city_of_san_francisco_2015_project_appendix
City of San Francisco
@usgov.city_of_san_francisco_2015_project_appendix
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
);
Anyone who has the link will be able to view this.