Readme file for the 2006-2010 Environmental Quality Index (EQI) EQI2006-2010_Technical_Report.pdf • Technical report for update of the Environmental Quality Index 2006-2010 2006_2010_EQI_2Jan2018_VC. csv • Contains PCA output for 5 domains and EQI, non-stratified • Contains PCA output for 5 domains and EQI, RUCC stratified (1-4) • Output for 5 domains and EQI, non-stratified and RUCC stratified (1-4) as continuous variables and categorical (tertile, quartile, quintile categories) PCA_Input_Variables_Non_Transformed.csv • Contains all variables from air, water, land, built and sociodemographic domains • Contains county level FIPS and RUCC categories • In the non-transformed file, no transformations have been applied to variables • There are no missing values PC AInputV ariables. csv • Contains all variables from air, water, land, built and sociodemographic domains • Contains county level FIPS and RUCC categories • Includes transformed variables • There are no missing values Data Dictionary Variables EQI 2006 2010.xlsx • List of all variables with domain for two datasets: PCA_Input_Variables_Non_Transformed.csv and PCA Input Variables.csv, actual name/definition, and variable names for both transformed and non-transformed datasets Data_Dictionary_2006_201 OEQIVC.csv • List of all variables, name/definition for the dataset 2006_2010_EQI_2Jan2018_VC.csv EQI_2006_2010_Metadata.xlsx • Contains the data inventory for air, water, land, built and sociodemographic domains • Includes data source names and links to data sources Environmental Quality Index_2006_201 OVCNonTransformed.xml • Contains metadata for non-transformed variables used in the air, water, land, built and sociodemographic domains ------- • Contains description and information on non-transformed variables representing the Air, Water, Land, Built, and Sociodemographic Domains/environment used for construction of the Air, Water, Land, Built, and Sociodemographic Domains index as well as the overall Environmental Quality Index as part of the USEPA's 2006-2010 EQI project. Refer to the original data source for data limitations. Original data sources can be found within documentation. EnvironmentalQualityIndex_2006_201 OVCTransformed.xml • Contains metadata for transformed variables used in the air, water, land, built and sociodemographic domains • Contains description and information on transformed variables representing the Air, Water, Land, Built, and Sociodemographic Domains/environment used for construction of the Air, Water, Land, Built, and Sociodemographic Domains index as well as the overall Environmental Quality Index as part of the USEPA's 2006-2010 EQI project. Refer to the original data source for data limitations. Original data sources can be found within documentation. Environmental QualityIndex_2006_201 OVC.xml • Contains metadata for the environmental quality index for 2006-2010 valence corrected • Contains description and information on overall EQI values, as well as domain-specific index values. Limitations for each data source can be found at source data websites, included in the document. Sample code for adding leading zero to state FIPS Sample SAS code: DATA eqi; SET eqi; LENGTH FIPS $5; IF strips <10000 THEN FIPS = '0'||STRIP(stfips); ELSE Fl PS=STRI P(stfips); DROP stfips; RUN; Sample R code: eqi$fips = substr ( as.numeric(eqi$stfips) + 100000, 2,7) ------- |