CalEnviroScreen 2.0

State of California

@usgov.ca_gov_calenviroscreen_2_0

Table List

1 table(2.37 MB)

CalEnviroScreen Final Report

@usgov.ca_gov_calenviroscreen_2_0.calenviroscreen_final_report

calenviroscreen-final-report.csv

2.37 MB
8035 rows
52 columns

census_tract Census Tract	total_population Total Population	california_county California County	ces_2_0_score CES 2.0 Score	ces_2_0_percentile_range CES 2.0 Percentile Range	hyperlink Hyperlink	ozone Ozone	ozone_pctl Ozone Pctl	pm2_5 PM2.5	pm2_5_pctl PM2.5 Pctl	diesel_pm Diesel PM	diesel_pm_pctl Diesel PM Pctl	drinking_water Drinking Water	drinking_water_pctl Drinking Water Pctl	pesticides Pesticides	pesticides_pctl Pesticides Pctl	tox_release Tox. Release	tox_release_pctl Tox. Release Pctl	traffic Traffic	traffic_pctl Traffic Pctl	cleanup_sites Cleanup Sites	cleanup_sites_pctl Cleanup Sites Pctl	groundwater_threats Groundwater Threats	groundwater_threats_pctl Groundwater Threats Pctl	haz_waste Haz. Waste	haz_waste_pctl Haz. Waste Pctl	imp_water_bodies Imp. Water Bodies	imp_water_bodies_pctl Imp. Water Bodies Pctl	solid_waste Solid Waste	solid_waste_pctl Solid Waste Pctl	pollution_burden Pollution Burden	pollution_burden_score Pollution Burden Score	pollution_burden_pctl Pollution Burden Pctl	age Age	age_pctl Age Pctl	asthma Asthma	asthma_pctl Asthma Pctl	low_birth_weight Low Birth Weight	low_birth_weight_pctl Low Birth Weight Pctl	education Education	education_pctl Education Pctl	linguistic_isolation Linguistic Isolation	linguistic_isolation_pctl Linguistic Isolation Pctl	poverty Poverty	poverty_pctl Poverty Pctl	unemployment Unemployment	unemployment_pctl Unemployment Pctl	pop_char Pop. Char.	pop_char_score Pop. Char. Score	pop_char_pctl Pop. Char. Pctl	location_1 Location 1
6019001100	3174	Fresno	89.22	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.765656684999,36.721996035,-119.791633689999,36.699489033	0.255228	80.87	14.74608667	97.83	44.23	93.91	519.8823702	83.3	5.470140445	53.9	96414.45837	99.81	1217.53568	66.95	85.5	98.86	55.75	85.47	0.52	74.84			5	81.49	78.62112747	9.530973451	99.95	26.4	67.66	130.748821	99.03	0.0580253	94.73	55.2	95.6	21.6	83.66	77.50086535	97.78	19.3	92.05	90.07226789	9.360658464	99.6	Fresno 93706 (36.709695199999999, -119.7816961)
6019000300	3609	Fresno	83.71	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.787833689999,36.734409036,-119.813343693999,36.721384034	0.28713	83.28	14.61961825	97.57	46.75	94.76	519.8823702	83.3	37.74917795	69.58	19637.9721	97.79	666.915834	36.06	23.5	86.17	27.5	68.24	0.16	50.42			1	37.88	71.9677581	8.724451449	99.45	29.9	88.03	132.4	99.19	0.0612328	98.4	47.3	91.05	18.3	78.34	81.2040316	98.93	NA	NA	92.32324286	9.594591786	99.9	Fresno 93706 (36.726461999999998, -119.8010347)
6019000200	3167	Fresno	83.47	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.794330691999,36.743608036,-119.813074694999,36.728625035	0.304446	84.4	14.55465574	97.47	46.91	94.8	519.8823702	83.3	11.69644427	60.54	11826.72494	95.53	1012.283892	59.69	21.25	84.41	49.75	83.07	0.21	56.85					72.40857778	8.777912474	99.54	27.5	76.31	132.321225	99.11	0.0628638	99.29	52.1	93.95	16.2	74.04	86.82842288	99.66	25.27	98.14	91.49903941	9.508958264	99.8	Fresno 93706 (36.735491400000001, -119.8055044)
6019001500	2206	Fresno	83.08	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.663879663999,36.706923035,-119.776174685999,36.663175034	0.225687	78.25	14.93764894	98.06	15.66	54.75	753.5405009	98.37	2105.763777	93.82	5846.924529	87.54	785.580102	45.43	51	96.05	100.5	93.72	12.76	99.48			22.2	99.29	78.99940853	9.576797188	99.96	27.9	78.76	69.533088	87.18	0.0525352	69.29	46.4	90.48	19.5	80.68	62.74608783	88.32	18.3	89.6	83.47428094	8.674966744	97.74	Fresno 93725 (36.681600000000003, -119.71784270000001)
6019000600	6161	Fresno	82.95	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.778577689999,36.750377038,-119.808375695999,36.728480036	0.327935	85.81	14.50641288	97.33	57.64	97.57	519.8823702	83.3	568.1125113	87.65	7158.199033	90.58	838.783805	49.37	4.95	43.88	26	66.8	0.27	62.35					71.38042314	8.653170081	99.32	29	84.47	116.899716	97.94	0.062997	99.34	45.9	90.09	16.9	75.49	88.68099296	99.79	26.69	98.61	92.24625973	9.586589624	99.89	Fresno 93721 (36.743062999999999, -119.7933565)
6071001600	6133	San Bernardino	80.7	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-117.575772074999,34.070764894,-117.680847092999,34.044087892	0.465401	92.5	13.88822372	96.19	47.08	94.83	604.3118027	90.34	1.363343185	42.11	8122.687693	91.87	1232.874128	67.41	56.2	96.58	49	82.87	1.845	91.31	5	55.5	2	58.45	80.80037303	9.795126682	99.99	23.9	39.98	44.909559	60.66	0.0638952	99.56	60	97.68	21.8	84.03	66.53966055	91.46	15.71	81.57	79.2770147	8.238796974	94.58	Ontario 91761 (34.0577805, -117.6180131)
6019000902	5252	Fresno	80.05	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.790751689999,36.722593035,-119.817903692999,36.714020033	0.269893	81.91	14.67323087	97.73	40.93	92.38	519.8823702	83.3	29.77080764	68.02	32996.714	98.88	352.831826	14.1	12.1	69.11	6.5	27.03	0.02	8.91			4.25	76.9	66.03011634	8.004606619	97.37	29.8	87.69	132.4	99.19	0.0617052	98.72	57.1	96.47	30.3	92.83	81.2125893	98.95	32.71	99.72	96.22414122	10	100	Fresno 93706 (36.717768999999997, -119.8042772)
6019000502	3606	Fresno	78.84	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.776315689999,36.750395039,-119.787388690999,36.735015037	0.335804	86.22	14.4963366	97.31	59.02	97.66	519.8823702	83.3	1376.853183	91.96	4214.249276	80.71	1467.881111	73.02					0.1	39.19					66.29130288	8.036246818	97.59	29.2	85.4	116.326106	97.88	0.059459	96.75	56.6	96.27	25.4	88.74	74.43046583	96.49	28.8	99.24	94.39562512	9.810026605	99.99	Fresno 93701 (36.744405700000002, -119.781537)
6019000901	3151	Fresno	77.86	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-119.790751689999,36.714159034,-119.817935692999,36.706765032	0.258082	81.06	14.7188158	97.78	41.04	92.54	519.8823702	83.3	64.18533159	73.5	22802.28254	98.12	415.383766	17.54	14.2	74.66	18	55.59					3.5	71.76	67.87770682	8.228633774	98.34	31.3	91.97	132.4	99.19	0.0572989	93.17	48	91.47	15.5	72.35	76.21602289	97.29	19.22	91.92	91.05045802	9.462296309	99.76	Fresno 93706 (36.710469699999997, -119.804301)
6037206050	2146	Los Angeles	77.8	96-100% (highest scores)	http://oehha.maps.arcgis.com/apps/Viewer/index.html?appid=112d915348834263ab8ecd5c6da67f68&extent=-118.217259181999,34.043154856,-118.228700183999,34.014947853	0.020888	40.66	12.69665284	87.03	86.29	99.27	458.0414672	74.57			4981.299677	84.13	4181.53668	97.23	34.3	92.16	39.7	78.13	7.52	98.68	7	71.63	12.6	95.86	73.80230813	8.946781428	99.76	36.8	97.75	56.571369	77	0.0493251	31.26	45.4	89.66	43.1	98.07	67.53006475	92.32	32.16	99.67	83.67653133	8.696063352	97.86	Los Angeles 90023 (34.029903599999997, -118.22445310000001)


CREATE TABLE calenviroscreen_final_report (
  "census_tract" BIGINT,
  "total_population" BIGINT,
  "california_county" VARCHAR,
  "click_for_interactive_map" VARCHAR,
  "ces_2_0_score" VARCHAR,
  "ces_2_0_percentile_range" VARCHAR,
  "hyperlink" VARCHAR,
  "ozone" VARCHAR,
  "ozone_pctl" VARCHAR,
  "pm2_5" VARCHAR,
  "pm2_5_pctl" VARCHAR,
  "diesel_pm" DOUBLE,
  "diesel_pm_pctl" DOUBLE,
  "drinking_water" VARCHAR,
  "drinking_water_pctl" VARCHAR,
  "pesticides" DOUBLE,
  "pesticides_pctl" DOUBLE,
  "tox_release" VARCHAR,
  "tox_release_pctl" VARCHAR,
  "traffic" DOUBLE,
  "traffic_pctl" DOUBLE,
  "cleanup_sites" DOUBLE,
  "cleanup_sites_pctl" DOUBLE,
  "groundwater_threats" DOUBLE,
  "groundwater_threats_pctl" DOUBLE,
  "haz_waste" DOUBLE,
  "haz_waste_pctl" DOUBLE,
  "imp_water_bodies" BIGINT,
  "imp_water_bodies_pctl" DOUBLE,
  "solid_waste" DOUBLE,
  "solid_waste_pctl" DOUBLE,
  "pollution_burden" DOUBLE,
  "pollution_burden_score" DOUBLE,
  "pollution_burden_pctl" DOUBLE,
  "age" VARCHAR,
  "age_pctl" VARCHAR,
  "asthma" DOUBLE,
  "asthma_pctl" DOUBLE,
  "low_birth_weight" VARCHAR,
  "low_birth_weight_pctl" VARCHAR,
  "education" VARCHAR,
  "education_pctl" VARCHAR,
  "linguistic_isolation" VARCHAR,
  "linguistic_isolation_pctl" VARCHAR,
  "poverty" VARCHAR,
  "poverty_pctl" VARCHAR,
  "unemployment" VARCHAR,
  "unemployment_pctl" VARCHAR,
  "pop_char" VARCHAR,
  "pop_char_score" VARCHAR,
  "pop_char_pctl" VARCHAR,
  "location_1" VARCHAR
);