20211202 18321200 1.0 FALSE layer_gates_CHECKUP_Cr_seattle 002 0.000 file://\\PSHENRYC\C$\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Gates V2 part 2\Gates V2 part 2.gdb Local Area Network Projected GCS_WGS_1984_Major_Auxiliary_Sphere Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator&quot;,GEOGCS[&quot;GCS_WGS_1984_Major_Auxiliary_Sphere&quot;,DATUM[&quot;D_WGS_1984_Major_Auxiliary_Sphere&quot;,SPHEROID[&quot;WGS_1984_Major_Auxiliary_Sphere&quot;,6378137.0,0.0]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3785]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102113</WKID><LatestWKID>3785</LatestWKID></ProjectedCoordinateSystem> FeatureClassToFeatureClass "PLACES: Local Data for Better Health\Tracts" "H:\share\GIS Methods Group\Gates\V2\data\Health" HealthData.shp # "TractFIPS "Tract FIPS" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,TractFIPS,0,255;StateAbbr "State abbreviation" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,StateAbbr,0,255;StateName "State name" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,StateName,0,255;CountyName "County name" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CountyName,0,255;CountyFIPS "County FIPS" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CountyFIPS,0,255;TotalPopul "Total population 2010" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,TotalPopulation,-1,-1;ACCESS2_Cr "Lack of health insurance crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,ACCESS2_CrudePrev,-1,-1;ACCESS2__1 "Lack of health insurance crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,ACCESS2_Crude95CI,0,255;ARTHRITIS_ "Arthritis crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,ARTHRITIS_CrudePrev,-1,-1;ARTHRITIS1 "Arthritis crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,ARTHRITIS_Crude95CI,0,255;BINGE_Crud "Binge drinking crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,BINGE_CrudePrev,-1,-1;BINGE_Cr_1 "Binge drinking crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,BINGE_Crude95CI,0,255;BPHIGH_Cru "High blood pressure crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,BPHIGH_CrudePrev,-1,-1;BPHIGH_C_1 "High blood pressure crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,BPHIGH_Crude95CI,0,255;BPMED_Crud "Taking BP medication crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,BPMED_CrudePrev,-1,-1;BPMED_Cr_1 "Taking BP medication crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,BPMED_Crude95CI,0,255;CANCER_Cru "Cancer (except skin) crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CANCER_CrudePrev,-1,-1;CANCER_C_1 "Cancer (except skin) crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CANCER_Crude95CI,0,255;CASTHMA_Cr "Current asthma crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CASTHMA_CrudePrev,-1,-1;CASTHMA__1 "Current asthma crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CASTHMA_Crude95CI,0,255;CERVICAL_C "Cervical cancer screening crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CERVICAL_CrudePrev,-1,-1;CERVICAL_1 "Cervical cancer screening crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CERVICAL_Crude95CI,0,255;CHD_CrudeP "Coronary heart disease crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CHD_CrudePrev,-1,-1;CHD_Crude9 "Coronary heart disease crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CHD_Crude95CI,0,255;CHECKUP_Cr "Annual checkup crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CHECKUP_CrudePrev,-1,-1;CHECKUP__1 "Annual checkup crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CHECKUP_Crude95CI,0,255;CHOLSCREEN "Cholesterol screening crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CHOLSCREEN_CrudePrev,-1,-1;CHOLSCRE_1 "Cholesterol screening crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CHOLSCREEN_Crude95CI,0,255;COLON_SCRE "Colorectal cancer screening crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COLON_SCREEN_CrudePrev,-1,-1;COLON_SC_1 "Colorectal cancer screening crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COLON_SCREEN_Crude95CI,0,255;COPD_Crude "COPD crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COPD_CrudePrev,-1,-1;COPD_Cru_1 "COPD crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COPD_Crude95CI,0,255;COREM_Crud "Core preventive services for older men crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COREM_CrudePrev,-1,-1;COREM_Cr_1 "Core preventive services for older men crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COREM_Crude95CI,0,255;COREW_Crud "Core preventive services for older women crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COREW_CrudePrev,-1,-1;COREW_Cr_1 "Core preventive services for older women crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,COREW_Crude95CI,0,255;CSMOKING_C "Current smoking crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CSMOKING_CrudePrev,-1,-1;CSMOKING_1 "Current smoking crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,CSMOKING_Crude95CI,0,255;DENTAL_Cru "Dental visit crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,DENTAL_CrudePrev,-1,-1;DENTAL_C_1 "Dental visit crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,DENTAL_Crude95CI,0,255;DIABETES_C "Diabetes crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,DIABETES_CrudePrev,-1,-1;DIABETES_1 "Diabetes crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,DIABETES_Crude95CI,0,255;HIGHCHOL_C "High cholesterol crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,HIGHCHOL_CrudePrev,-1,-1;HIGHCHOL_1 "High cholesterol crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,HIGHCHOL_Crude95CI,0,255;KIDNEY_Cru "Chronic kidney disease crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,KIDNEY_CrudePrev,-1,-1;KIDNEY_C_1 "Chronic kidney disease crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,KIDNEY_Crude95CI,0,255;LPA_CrudeP "Physical inactivity crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,LPA_CrudePrev,-1,-1;LPA_Crude9 "Physical inactivity crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,LPA_Crude95CI,0,255;MAMMOUSE_C "Mammography use crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,MAMMOUSE_CrudePrev,-1,-1;MAMMOUSE_1 "Mammography use crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,MAMMOUSE_Crude95CI,0,255;MHLTH_Crud "Frequent mental health distress crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,MHLTH_CrudePrev,-1,-1;MHLTH_Cr_1 "Frequent mental health distress crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,MHLTH_Crude95CI,0,255;OBESITY_Cr "Obesity crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,OBESITY_CrudePrev,-1,-1;OBESITY__1 "Obesity crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,OBESITY_Crude95CI,0,255;PHLTH_Crud "Frequent physical health distress crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,PHLTH_CrudePrev,-1,-1;PHLTH_Cr_1 "Frequent physical health distress crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,PHLTH_Crude95CI,0,255;SLEEP_Crud "Sleep <7 hours crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,SLEEP_CrudePrev,-1,-1;SLEEP_Cr_1 "Sleep <7 hours crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,SLEEP_Crude95CI,0,255;STROKE_Cru "Stroke crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,STROKE_CrudePrev,-1,-1;STROKE_C_1 "Stroke crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,STROKE_Crude95CI,0,255;TEETHLOST_ "Teeth loss crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,TEETHLOST_CrudePrev,-1,-1;TEETHLOST1 "Teeth loss crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,TEETHLOST_Crude95CI,0,255;DEPRESSION "Depression crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,DEPRESSION_CrudePrev,-1,-1;DEPRESSI_1 "Depression crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,DEPRESSION_Crude95CI,0,255;GHLTH_Crud "Fair or poor health crude prevalence (%)" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,GHLTH_CrudePrev,-1,-1;GHLTH_Cr_1 "Fair or poor health crude prevalence 95% CI" true true false 255 Text 0 0,First,#,PLACES: Local Data for Better Health\Tracts,GHLTH_Crude95CI,0,255;Latitude "Latitude" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,Latitude,-1,-1;Longitude "Longitude" true true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,Longitude,-1,-1;Shape__Are "Shape__Area" false true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,Shape__Area,-1,-1;Shape__Len "Shape__Length" false true false 0 Double 0 0,First,#,PLACES: Local Data for Better Health\Tracts,Shape__Length,-1,-1" # Select "H:\share\GIS Methods Group\Gates\V2\data\Health\HealthData.shp" "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Gates V2 part 2\Gates V2 part 2.gdb\TEMP" "CountyFIPS = '06047'" AddField TEMP ID_NEW "Double (double precision)" # # # # NULLABLE NON_REQUIRED # CalculateField TEMP ID_NEW !TractFIPS! "Python 3" # CopyFeatures TEMP "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Gates V2 part 2\Gates V2 part 2.gdb\layer_gates_CHECKUP_Cr_seattle" # # # # JoinField layer_gates_CHECKUP_Cr_seattle ID_NEW "H:\share\GIS Methods Group\Gates\V2\\cleanData\healthData.csv" TractFIPS # AlterField layer_gates_CHECKUP_Cr_seattle sym # Ranges "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR AddField layer_gates_CHECKUP_Cr_seattle Title Text # # # # NULLABLE NON_REQUIRED # CalculateField layer_gates_CHECKUP_Cr_seattle Title "Visits to Doctor for Routine Checkup Among Adults" "Python 3" # 20211219 01522900 20211219 01522900 Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.4.0.19948 layer_gates_CHECKUP_Cr_seattle Gates Gates File Geodatabase Feature Class 0.000 dataset EPSG 6.15(10.1.0) 0 Simple FALSE 0 TRUE FALSE layer_gates_CHECKUP_Cr_seattle Feature Class 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. TractFIPS TractFIPS String 254 0 0 StateAbbr StateAbbr String 254 0 0 StateName StateName String 254 0 0 CountyName CountyName String 254 0 0 CountyFIPS CountyFIPS String 254 0 0 TotalPopul TotalPopul Double 8 0 0 ACCESS2_Cr ACCESS2_Cr Double 8 0 0 ACCESS2__1 ACCESS2__1 String 254 0 0 ARTHRITIS_ ARTHRITIS_ Double 8 0 0 ARTHRITIS1 ARTHRITIS1 String 254 0 0 BINGE_Crud BINGE_Crud Double 8 0 0 BINGE_Cr_1 BINGE_Cr_1 String 254 0 0 BPHIGH_Cru BPHIGH_Cru Double 8 0 0 BPHIGH_C_1 BPHIGH_C_1 String 254 0 0 BPMED_Crud BPMED_Crud Double 8 0 0 BPMED_Cr_1 BPMED_Cr_1 String 254 0 0 CANCER_Cru CANCER_Cru Double 8 0 0 CANCER_C_1 CANCER_C_1 String 254 0 0 CASTHMA_Cr CASTHMA_Cr Double 8 0 0 CASTHMA__1 CASTHMA__1 String 254 0 0 CERVICAL_C CERVICAL_C Double 8 0 0 CERVICAL_1 CERVICAL_1 String 254 0 0 CHD_CrudeP CHD_CrudeP Double 8 0 0 CHD_Crude9 CHD_Crude9 String 254 0 0 CHECKUP_Cr CHECKUP_Cr Double 8 0 0 CHECKUP__1 CHECKUP__1 String 254 0 0 CHOLSCREEN CHOLSCREEN Double 8 0 0 CHOLSCRE_1 CHOLSCRE_1 String 254 0 0 COLON_SCRE COLON_SCRE Double 8 0 0 COLON_SC_1 COLON_SC_1 String 254 0 0 COPD_Crude COPD_Crude Double 8 0 0 COPD_Cru_1 COPD_Cru_1 String 254 0 0 COREM_Crud COREM_Crud Double 8 0 0 COREM_Cr_1 COREM_Cr_1 String 254 0 0 COREW_Crud COREW_Crud Double 8 0 0 COREW_Cr_1 COREW_Cr_1 String 254 0 0 CSMOKING_C CSMOKING_C Double 8 0 0 CSMOKING_1 CSMOKING_1 String 254 0 0 DENTAL_Cru DENTAL_Cru Double 8 0 0 DENTAL_C_1 DENTAL_C_1 String 254 0 0 DIABETES_C DIABETES_C Double 8 0 0 DIABETES_1 DIABETES_1 String 254 0 0 HIGHCHOL_C HIGHCHOL_C Double 8 0 0 HIGHCHOL_1 HIGHCHOL_1 String 254 0 0 KIDNEY_Cru KIDNEY_Cru Double 8 0 0 KIDNEY_C_1 KIDNEY_C_1 String 254 0 0 LPA_CrudeP LPA_CrudeP Double 8 0 0 LPA_Crude9 LPA_Crude9 String 254 0 0 MAMMOUSE_C MAMMOUSE_C Double 8 0 0 MAMMOUSE_1 MAMMOUSE_1 String 254 0 0 MHLTH_Crud MHLTH_Crud Double 8 0 0 MHLTH_Cr_1 MHLTH_Cr_1 String 254 0 0 OBESITY_Cr OBESITY_Cr Double 8 0 0 OBESITY__1 OBESITY__1 String 254 0 0 PHLTH_Crud PHLTH_Crud Double 8 0 0 PHLTH_Cr_1 PHLTH_Cr_1 String 254 0 0 SLEEP_Crud SLEEP_Crud Double 8 0 0 SLEEP_Cr_1 SLEEP_Cr_1 String 254 0 0 STROKE_Cru STROKE_Cru Double 8 0 0 STROKE_C_1 STROKE_C_1 String 254 0 0 TEETHLOST_ TEETHLOST_ Double 8 0 0 TEETHLOST1 TEETHLOST1 String 254 0 0 DEPRESSION DEPRESSION Double 8 0 0 DEPRESSI_1 DEPRESSI_1 String 254 0 0 GHLTH_Crud GHLTH_Crud Double 8 0 0 GHLTH_Cr_1 GHLTH_Cr_1 String 254 0 0 Latitude Latitude Double 8 0 0 Longitude Longitude Double 8 0 0 Shape__Are Shape__Are Double 8 0 0 Shape__Len Shape__Len Double 8 0 0 ID_NEW ID_NEW Double 8 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. Shape_Area Shape_Area Double 8 0 0 Area of feature in internal units squared. Esri Positive real numbers that are automatically generated. 20211219