Massachusetts, USA Shapefile with Comprehensive Opportunity for Massachusetts census tracts This shapefile contains data on Z-scores for each of the opportunity categories and the comprehensive opportunity by census tracts for the state of Massachusetts. The shapefile contains the following variables: 1. OBJECTID - The unique ID for each record in the table 2. ID - The GIS-compatible Geographic Identifier 3. SRC_FIEL_1 - Number of jobs for 2000 interpolated from zip code data unto censustracts (Source:County Business Pattern) (EMP_2000) 4. SRC_FIELD - Number of jobs for 2005 interpolated from zip code data unto censustracts (Source:County Business Pattern) (EMP_2005) 5. Z_PROXIMIT - z-score based PROXIMITY (number of jobs within 5 miles of censustract centroids) (Formula: (PROXIMITY - Mean)/Standard Deviation) 6. MC_TIME - Average time to commute for the residents of censustracts (Source: Census 2000) 7. Z_MC_TIME - Z_score based on MC_TIME (Formula: (MC_TIME(MEAN_TRA) - Mean)/Standard Deviation) 8. ZADJ_MC_TI - Adjusted Z-score based on Z_MC_TIME (Formula: -Z_MC_TIME) 9. UNEMPRATE - Unemployment Rate (Formula: UNEMP_CY/CIVLBFR_CY) 10. Z_UEMP_RAT - z-score based on UNEMPRATE (Formula: (UNEMPRATE - Mean)/Standard Deviation) 11. ZADJ_UEMP_ - Adjusted Z-score based on Z_UEMP_RAT (Formula: -Z_UEMP_RAT) 12. Z_GRADRT - z-score based on _GRADUATE (Formula: (_GRADUATE - Mean)/Standard Deviation) 13. Z_DROPOUT - z-score based on _DROPPED_ (Formula: (_DROPPED_ - Mean)/Standard Deviation) 14. Z_ADJ_DROP - Adjusted Z-score based on Z_DROPOUT (Formula: -Z_DROPOUT) 15. Z_LicTch - z-score based on _OF_TEACH (Formula: (_OF_TEACH - Mean)/Standard Deviation) 16. Z_HQ_CORET - z-score based on _OF_CORE_ (Formula: (_OF_CORE_ - Mean)/Standard Deviation) 17. Z_3RD_ENG - z-score based on 3RD_ENGLIS (Formula: (3RD_ENGLIS - Mean)/Standard Deviation) 18. Z_3RD_MATH - z-score based on 3RD_MATH (Formula: (3RD_MATH - Mean)/Standard Deviation) 19. Z_LOWINC - z-score based on LOW_INCOME (Formula: (LOW_INCOME - Mean)/Standard Deviation) 20. Z_ADJ_LOWI - Adjusted Z-score based on Z_LOWINC (Formula: -Z_LOWINC) 21. Z_EXP_STUD - z-score based on EXPENDITUR (Formula: (EXPENDITUR - Mean)/Standard Deviation) 22. Z_EDUC - Z-score for opportunity based on Education indicators (Formula: (Z_GRADRT + Z_ADJ_DROP + Z_LicTch + Z_HQ_CORET + Z_3RD_ENG + Z_3RD_MATH + Z_ADJ_LOWI + Z_EXP_STUD )/8) 23. MEDVALUE - Estimated Median house value for 2000 (Source: Census 2000) 24. Z_MEDVAL - z-score based on MEDVALUE (Formula: (MEDVALUE - Mean)/Standard Deviation) 25. POV_RATE - Percentage of people below poverty for whom the poverty level has been determined by censustracts (Source: Census 2000) 26. Z_POV - z-score based on POV_RATE (Formula: (POV_RATE - Mean)/Standard Deviation) 27. ADJZ_POV - Adjusted Z-score based on Z_POV (Formula: -Z_POV) 28. OWN_RATE - Percenatge of owner occupied homes in the given housing stock (Formula: Owner occupied homes for 2000/Housing stock for 2000) 29. Z_OWN - z-score based on OWN_RATE (Formula: (OWN_RATE - Mean)/Standard Deviation) 30. VAC_RATE_1 - Ratio of vacant houses in the given housing stock (Formula: H_VACANT(Vacant housing units: Other vacant)/H_UNITS(Housing stock for 2000)) 31. Z_VAC_NEW - z-score based on VAC_RATE_1 (Formula: (VAC_RATE_1 - Mean)/Standard Deviation) 32. ADJZ_VAC_N - Adjusted Z-score based on Z_VAC_NEW (Formula: -Z_VAC_NEW) 33. COUNT_ - Number of toxic release/ superfund sites within each censustract based on spatial interpolation 34. TOTAL_ON_ - Total waste generated and disposed to land on-site and offsite. (Formula:Total_On_s + Total_Off) 35. Z_SITES - z-score based on SITES (Formula: (SITES - Mean)/Standard Deviation) 36. Z_REL - z-score based on TOTAL_ON_ (Formula: (TOTAL_ON_ - Mean)/Standard Deviation) 37. ADJZ_SITES - Adjusted Z-score based on Z_SITES (Formula: -Z_SITES) 38. ADJZ_REL - Adjusted Z-score based on Z_REL (Formula: -Z_REL) 39. OP_IND_REV - Opportunity Indicator/Cartegory 40. ECON_CHANG - Change in the number of jobs(employees) from 2000 to 2005 within 5 miles of each censustract (Formula: EMP_2005(SRC_FIELD) - EMP_2000(SRC_FIEL_1)) 41. Z_ECON_CH - z-score based on ECON_CHANG (Formula: (ECON_CHANG - Mean)/Standard Deviation) 42. Z_ECON_ALT - Z-score for opportunity based on Economic and Mobility Indicators (Formula: Z_PROXIMIT + ZADJ_MC_TI + ZADJ_UEMP_ + Z_ECON_CH + ADJZ_PA_MA)/5) 43. CRIME_RATE - Sum of Part 1 offenses per 1000 Population (Formula: TOT_CRIME/(POP2005/1000)) 44. Z_CR_MA - Z-score based on CRIME_RATE (Formula: (CRIME_RATE - Mean)/Standard Deviation) 45. ADJZ_CR_MA - Adjusted Z-score based on Z_CR_MA (Formula: -Z_CR_MA) 46. PA_HOUSEHO - Households With public assistance income 47. NPA_HOUSEH - Households Without public assistance income 48. NON_PA_HOU - Aggregate Households (Formula: PA_HOUSEHO + NON_PA_HOU) 49. P_PA_HOUS - Percentage of Households With public assistance income (Formula: PA_HOUSEHO/ NON_PA_HOU) 50. Z_CHECK - Z-score based on P_PA_HOUS (Formula: (P_PA_HOUS - Mean)/Standard Deviation) 51. ADJZ_PA_MA - Adjusted Z-score based on Z_CHECK (Formula: -Z_CHECK) 52. Z_NBHD_ALT - Z-score for opportunity based on Housing and Neighborhood Indicators (Formula: (Z_MEDVAL + ADJZ_POV + Z_OWN + ADJZ_VAC_N + ADJZ_SITES + ADJZ_REL + ADJZ_CR_MA)/7) 53. COMP_OPP - Comprehensive opportunity score as an average of, Housing and Neighborhood;Economic and Mobility;and Education opportunities Z-scores: (Formula: (Z_NBHD_ALT+ Z_ECON_ALT + Z_EDUC)/3) * - The Z-score is adjusted to ensure positive values of Z-score correspond to positive outcomes of the indicator *Source - US Census 2000; EPA; MA State Police;MA Department of Education; County Business Pattern; MassGIS; ESRI