README_20150505.txt

This document describes the files related to EJSCREEN that are provided in this directory.

http://www.epa.gov/ejscreen is where EJSCREEN may be found. EJSCREEN is the United States Environmental Protection Agency (EPA) screening and mapping tool for Environmental Justice (EJ).

ftp://newftp.epa.gov/EJSCREEN/ is the FTP site from which these files can be downloaded.

enviromail_group@epa.gov is the email address to use when contacting the application owners in case you have any questions about these files.


Files:


EJSCREEN2015.UserGuide_20150505.pdf

This PDF document is the "Help" of "How-To" document associated with EJSCREEN. This file is associated with the online application and can help anyone learn about and use the various features within the EJSCREEN tool such as finding an address, specifying a location (buffer area), obtaining a report, and viewing color-coded maps.


EJSCREEN2015.Technical_Document_20150505.pdf

This PDF document is the technical documentation for EPA's EJSCREEN application and database. This is the most comprehensive documentation of EJSCREEN. It provides information about EJ at the EPA, intended purpose and uses of EJSCREEN, caveats and limitations, data overviews, and details on the data sources and methods used.


EJSCREEN_v23.gdb.zip (as of 20150505)

This is a very large (almost 1 Gigabyte zipped) Zip file that contains the full EJSCREEN dataset in ESRI ArcGIS geodatabase format. The geodatabase includes the feature class with block group boundaries and a full data table of block group level EJSCREEN data. It also contains three other tables, which are lookup tables used to look up a raw value and find out what percentile that represents in the USA, Region, or State. These tables are called USA, Regions, and States, and are described further below in this file. The field names are identical to those in the main data table. The tables in this geodatabase are also provided separately as csv files for those not using ArcGIS. Note that exporting the attribute tables from ArcGIS to dbf or txt/csv format does not preserve the distinction between zero and missing values -- both are exported as zeroes in a dbf or txt/csv file. That has been addressed in the csv described below, in which missing values are stored as NA rather than zero. The same is true for the USA, States, and Regions lookup table csv files.


EJSCREEN_20150505.csv.zip

This is a Zip file (approx 300 Megabytes zipped) that contains a single comma-separated-values file of the same name but without the .zip extension. This file is an export of the Census Block Group polygon feature class attribute table "EJScreen_Full" from the EJSCREEN file geodatabase. The table is provided as a convenience for those not working in ArcGIS. This csv file is the main dataset of EJSCREEN variables, with one row per block group. The file EJSCREEN_FIELDNAMES_AND_FORMULAS_..., described below, provides information about fieldnames and definitions -- fieldnames in this csv may differ from those in the gdb, but the gdb versus csv versions of names are documented in the EJSCREEN_FIELDNAMES_AND_FORMULAS_... file. All descriptions of the attributes (fields or columns) are provided in the metadata as well. There are 217,739 records (plus a header row) in this file and over 250 EJSCREEN fields/attributes. It contains the geographical information such as Census Bureau FIPS code, raw data fields, US percentiles, bin numbers that correspond to colors on the maps, and other information. Depending on the version, the csv file might not contain the text fields used for popups on maps, fields which are only in the geodatabase (.gdb) file. No formatting is provided in the csv file. It can be imported to Microsoft Excel or any statistical software environment. Care should be taken to ensure Census block group FIPS codes are imported as character string text not as numbers, so they can retain any necessary leading zeroes.


USA_20150505.csv
Regions_20150505.csv
States_20150505.csv

Three files, for States, Regions, and USA - These are the State, US EPA Regional, and national (USA) averages and percentile values for EJSCREEN raw indicator and index values (Environmental Indicators, Demographic Indicators, and EJ Indexes). They were calculated using the File Geodatabase feature class (the full dataset). These tables are used by the application to assign a percentile (relative to the entire State, EPA Region or Nation) for each of the EJSCREEN indicators. These are described in the data processing PDF as the "Lookup Tables." The tables contain the population average (arithmetic mean) values for an area (e.g., state = PA) and individual percentile values (population percentiles) from 0 - 100, (and a row for the the standard deviation in the US and each Region but not for each State), for a total of 102 records per Region or for the US (101 for each State). The number of records included in each file is as follows: States (n = 5202 records, after the header row), Regions (n = 1020 records, after the header row), and USA (n = 102 records, after the header row). The field names are identical to those in the main data table. The first row of each file provides fieldnames (headers) as follows:
OBJECTID,REGION,PCTILE,MINORPCT,LOWINCPCT,LESSHSPCT,LINGISOPCT,UNDER5PCT,OVER64PCT,PRE1960PCT,VULEOPCT,VULSVI6PCT,DSLPM,CANCER,RESP,NEURO,PTRAF,PWDIS,PNPL,PRMP,PTSDF,OZONE,PM25,D_LDPNT_2,LDPNT_D6,LDPNT_B2,LDPNT_B6,LDPNT_P2,LDPNT_P6,D_DSLPM_2,DSLPM_D6,DSLPM_B2,DSLPM_B6,DSLPM_P2,DSLPM_P6,D_CANCR_2,CANCR_D6,CANCR_B2,CANCR_B6,CANCR_P2,CANCR_P6,D_RESP_2,RESP_D6,RESP_B2,RESP_B6,RESP_P2,RESP_P6,D_NEURO_2,NEURO_D6,NEURO_B2,NEURO_B6,NEURO_P2,NEURO_P6,D_PTRAF_2,PTRAF_D6,PTRAF_B2,PTRAF_B6,PTRAF_P2,PTRAF_P6,D_PWDIS_2,PWDIS_D6,PWDIS_B2,PWDIS_B6,PWDIS_P2,PWDIS_P6,D_PNPL_2,PNPL_D6,PNPL_B2,PNPL_B6,PNPL_P2,PNPL_P6,D_PRMP_2,PRMP_D6,PRMP_B2,PRMP_B6,PRMP_P2,PRMP_P6,D_PTSDF_2,PTSDF_D6,PTSDF_B2,PTSDF_B6,PTSDF_P2,PTSDF_P6,D_OZONE_2,OZONE_D6,OZONE_B2,OZONE_B6,OZONE_P2,OZONE_P6,D_PM25_2,PM25_D6,PM25_B2,PM25_B6,PM25_P2,PM25_P6


EJSCREEN_FIELDNAMES_AND_FORMULAS_20150505.csv

This csv file shows the fieldnames and any relevant formulas for EJSCREEN variables and raw count variables used to calculate the EJSCREEN fields. It maps between the fieldnames used in the geodatabase, in the Census Bureau ACS tables, and in internal calculations as documented in an Appendix of the EJSCREEN Technical Documentation. It also has longer descriptions of most fields. The fields in this mapping file are as follows: "gdbfieldname","Rfieldname","acsfieldname","type","glossaryfieldname","formula","acsfieldnamelong","universe"


ACS2008-2012_Race_Ethnicity_subgroup_counts_and_percents_by_block_group.zip

This zipped file contains a comma separated values (csv) file that provides calculated demographic data for every block group in the US. It provides fields that are more detailed than what the EJSCREEN geodatabase and main csv dataset provide -- It has a breakdown of the subgroups within the overall category of "minority" population, such as count and percent Hispanic, non-Hispanic Asian alone, etc. Names of the fields can be interpreted using the csv file above, called EJSCREEN_FIELDNAMES_AND_FORMULAS_20150505.csv  The fields are the following (also see the README text file in the zip file):
"FIPS","ST","pctpre1960","pop","pctlowinc","pctmin","pctlths","pctlingiso","pctunder5","pctover64","pre1960","builtunits","lowinc","age25up","povknownratio","mins","nonmins","lths","lingiso","hhlds","under5","over64","pcthisp","pctnhwa","pctnhba","pctnhaiana","pctnhaa","pctnhnhpia","pctnhotheralone","pctnhmulti","hisp","nhwa","nhba","nhaiana","nhaa","nhnhpia","nhotheralone","nhmulti"


ACS2008-2012_EJSCREEN_inputs_raw_count_tables_with_MOE_by_block_group.zip

This zipped file contains a comma separated values (csv) file that provides raw counts of demographic data, including estimate and margin of error (denoted by .m suffix on the field name) for every block group in the US, directly from the ACS. It provides fields that are more detailed than what the EJSCREEN geodatabase and main csv dataset provide -- It has a breakdown of the subgroups within the overall category of "minority" population, such as count and percent Hispanic, non-Hispanic Asian alone, etc. Names of the fields can be interpreted using ACS Summary File documentation or the csv file above, called EJSCREEN_FIELDNAMES_AND_FORMULAS_20150505.csv  The fields are the following (also see the README text file in the zip file):
"KEY","SUMLEVEL","FIPS","STUSAB","GEOID","B01001.001","B01001.001.m","B01001.003","B01001.003.m","B01001.004","B01001.004.m","B01001.005","B01001.005.m","B01001.006","B01001.006.m","B01001.020","B01001.020.m","B01001.021","B01001.021.m","B01001.022","B01001.022.m","B01001.023","B01001.023.m","B01001.024","B01001.024.m","B01001.025","B01001.025.m","B01001.027","B01001.027.m","B01001.028","B01001.028.m","B01001.029","B01001.029.m","B01001.030","B01001.030.m","B01001.044","B01001.044.m","B01001.045","B01001.045.m","B01001.046","B01001.046.m","B01001.047","B01001.047.m","B01001.048","B01001.048.m","B01001.049","B01001.049.m","B03002.001","B03002.001.m","B03002.002","B03002.002.m","B03002.003","B03002.003.m","B03002.004","B03002.004.m","B03002.005","B03002.005.m","B03002.006","B03002.006.m","B03002.007","B03002.007.m","B03002.008","B03002.008.m","B03002.009","B03002.009.m","B03002.010","B03002.010.m","B03002.011","B03002.011.m","B03002.012","B03002.012.m","B03002.013","B03002.013.m","B03002.014","B03002.014.m","B03002.015","B03002.015.m","B03002.016","B03002.016.m","B03002.017","B03002.017.m","B03002.018","B03002.018.m","B03002.019","B03002.019.m","B03002.020","B03002.020.m","B03002.021","B03002.021.m","B15002.001","B15002.001.m","B15002.003","B15002.003.m","B15002.004","B15002.004.m","B15002.005","B15002.005.m","B15002.006","B15002.006.m","B15002.007","B15002.007.m","B15002.008","B15002.008.m","B15002.009","B15002.009.m","B15002.010","B15002.010.m","B15002.020","B15002.020.m","B15002.021","B15002.021.m","B15002.022","B15002.022.m","B15002.023","B15002.023.m","B15002.024","B15002.024.m","B15002.025","B15002.025.m","B15002.026","B15002.026.m","B15002.027","B15002.027.m","B16002.001","B16002.001.m","B16002.003","B16002.003.m","B16002.004","B16002.004.m","B16002.006","B16002.006.m","B16002.007","B16002.007.m","B16002.009","B16002.009.m","B16002.010","B16002.010.m","B16002.012","B16002.012.m","B16002.013","B16002.013.m","C17002.001","C17002.001.m","C17002.002","C17002.002.m","C17002.003","C17002.003.m","C17002.004","C17002.004.m","C17002.005","C17002.005.m","C17002.006","C17002.006.m","C17002.007","C17002.007.m","C17002.008","C17002.008.m","B25034.001","B25034.001.m","B25034.002","B25034.002.m","B25034.003","B25034.003.m","B25034.004","B25034.004.m","B25034.005","B25034.005.m","B25034.006","B25034.006.m","B25034.007","B25034.007.m","B25034.008","B25034.008.m","B25034.009","B25034.009.m","B25034.010","B25034.010.m"