Community Resiliency Indicator System
City of San Francisco
@usgov.city_of_san_francisco_community_resiliency_indicator_system
City of San Francisco
@usgov.city_of_san_francisco_community_resiliency_indicator_system
CREATE TABLE table_1 (
"neighborhood" VARCHAR,
"flood_per" DOUBLE,
"heat_per" DOUBLE,
"liq_per" DOUBLE,
"haz_score" DOUBLE,
"imp_per" DOUBLE,
"tree_per" DOUBLE,
"pm_conc" DOUBLE,
"tox_per" DOUBLE,
"env_score" DOUBLE,
"at_min" DOUBLE,
"ptrans_sco" DOUBLE,
"trans_sco" DOUBLE,
"vcrim_rate" DOUBLE,
"vot_rate" DOUBLE,
"newsf_per" DOUBLE,
"citz_per" DOUBLE,
"eng_per" DOUBLE,
"com_score" DOUBLE,
"food_score" DOUBLE,
"hs_per" DOUBLE,
"pharm_per" DOUBLE,
"pr_score" DOUBLE,
"lival_per" DOUBLE,
"eldlival_per" DOUBLE,
"oc_per" DOUBLE,
"viol_rate" DOUBLE,
"ac_per" DOUBLE,
"rent_per" DOUBLE,
"house_score" DOUBLE,
"emp_per" DOUBLE,
"ec_score" DOUBLE,
"shelt_rate" DOUBLE,
"sheltday_rate" DOUBLE,
"dis_per" DOUBLE,
"prevhos" DOUBLE,
"health_score" DOUBLE,
"over85_per" DOUBLE,
"over65_per" DOUBLE,
"under18_per" DOUBLE,
"under5_per" DOUBLE,
"nonwhi_per" DOUBLE,
"lat_per" DOUBLE,
"black_per" VARCHAR,
"asian_per" DOUBLE,
"pov_per" DOUBLE,
"popdens" DOUBLE,
"daypopdens" DOUBLE,
"dem_score" DOUBLE,
"res_score" DOUBLE,
"res_rank" DOUBLE
);
Anyone who has the link will be able to view this.