20170620
13291600
1.0
FALSE
layer_HI_complex_NatHaw
002
file://\\PSHENRYC\C$\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb
Local Area Network
0.000
Projected
GCS_North_American_1983_HARN
NAD_1983_HARN_UTM_Zone_4N
<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.9.0'><WKT>PROJCS["NAD_1983_HARN_UTM_Zone_4N",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-159.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3750]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</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>102202</WKID><LatestWKID>3750</LatestWKID></ProjectedCoordinateSystem>
Linear Unit: Meter (1.000000)
Merge 'S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas';S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs S:\district\Hawaii\GIS\SchlYr1011\GDB\BaseMap.gdb\StudyAreas "STDYAREA "STDYAREA" true true false 6 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,STDYAREA,-1,-1;ELEM_ "ELEM_" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ELEM_,-1,-1;MID_ "MID_" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,MID_,-1,-1;INT_ "INT_" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,INT_,-1,-1;HIGH_ "HIGH_" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,HIGH_,-1,-1;DISTRICT "DISTRICT" true true false 6 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,DISTRICT,-1,-1;ADD_SCHL1 "ADD_SCHL1" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ADD_SCHL1,-1,-1;ADD_SCHL2 "ADD_SCHL2" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ADD_SCHL2,-1,-1;ADD_SCHL3 "ADD_SCHL3" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ADD_SCHL3,-1,-1;ADD_SCHL4 "ADD_SCHL4" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ADD_SCHL4,-1,-1;ADD_SCHL5 "ADD_SCHL5" true true false 2 Short 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ADD_SCHL5,-1,-1;ELEM_DESC "ELEM_DESC" true true false 50 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,ELEM_DESC,-1,-1;MID_DESC "MID_DESC" true true false 50 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,MID_DESC,-1,-1;INT_DESC "INT_DESC" true true false 50 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,INT_DESC,-1,-1;HIGH_DESC "HIGH_DESC" true true false 50 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,HIGH_DESC,-1,-1;REGION1 "REGION1" true true false 50 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,REGION1,-1,-1;REGION2 "REGION2" true true false 50 Text 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,REGION2,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,SHAPE_Length,-1,-1,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,Shape_Length,-1,-1;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#,S:\Documents\Data and Procedural Standards\Data Structure\DDP_Data\BaseMap.gdb\Main\StudyAreas,SHAPE_Area,-1,-1,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,Shape_Area,-1,-1;FID_HawaiiCoastlineProvided_June2011 "FID_HawaiiCoastlineProvided_June2011" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,FID_HawaiiCoastlineProvided_June2011,-1,-1;AREA "AREA" true true false 8 Double 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,AREA,-1,-1;PERIMETER "PERIMETER" true true false 8 Double 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,PERIMETER,-1,-1;COASTLINE_ "COASTLINE_" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,COASTLINE_,-1,-1;COASTLIN_1 "COASTLIN_1" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,COASTLIN_1,-1,-1;WATER "WATER" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,WATER,-1,-1;FID_DistrictsOfHawaii "FID_DistrictsOfHawaii" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,FID_DistrictsOfHawaii,-1,-1;ADMIN_NAME "ADMIN_NAME" true true false 10 Text 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,ADMIN_NAME,-1,-1;FID_HighSchoolBoundariesFromStHI "FID_HighSchoolBoundariesFromStHI" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,FID_HighSchoolBoundariesFromStHI,-1,-1;AREA_1 "AREA" true true false 8 Double 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,AREA_1,-1,-1;PERIMETER_1 "PERIMETER" true true false 8 Double 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,PERIMETER_1,-1,-1;HIGHDIST_ "HIGHDIST_" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,HIGHDIST_,-1,-1;HIGHDIST_I "HIGHDIST_I" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,HIGHDIST_I,-1,-1;ID "ID" true true false 4 Long 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,ID,-1,-1;COUNTY "COUNTY" true true false 5 Text 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,COUNTY,-1,-1;SECONDARY "SECONDARY" true true false 5 Text 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,SECONDARY,-1,-1;NAME "NAME" true true false 60 Text 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,NAME,-1,-1;ADMIN "ADMIN" true true false 5 Text 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,ADMIN,-1,-1;ADMIN_NAME_1 "ADMIN_NAME" true true false 10 Text 0 0 ,First,#,S:\district\Hawaii\GIS\SchlYr1011\GDB\Misc.gdb\MergeCoastcasHSAAs,ADMIN_NAME_1,-1,-1"
CalculateField StudyAreas REGION2 "KAUAI" VB #
CalculateField StudyAreas REGION2 "OAHU" VB #
CalculateField StudyAreas REGION2 "MOLOKAI" VB #
CalculateField StudyAreas REGION2 "LANAI" VB #
CalculateField StudyAreas REGION2 "KAHOOLAWE" VB #
CalculateField StudyAreas REGION2 "MAUI" VB #
CalculateField StudyAreas REGION2 "HAWAII" VB #
CalculateField StudyAreas REGION1 [ADMIN_NAME] VB #
CalculateField StudyAreas HIGH_DESC [NAME] VB #
CalculateField StudyAreas HIGH_ [SECONDARY] VB #
CalculateField StudyAreas ELEM_DESC "Aina Haina" VB #
CalculateField StudyAreas ELEM_DESC "Wilson" VB #
CalculateField StudyAreas ELEM_DESC "Waialae" VB #
CalculateField StudyAreas ELEM_DESC "Liliuokalani" VB #
CalculateField StudyAreas ELEM_DESC "Hokulani" VB #
CalculateField StudyAreas ELEM_DESC "Kahala" VB #
CalculateField StudyAreas ELEM_DESC "Waikiki" VB #
CalculateField StudyAreas ELEM_DESC "Liholiho" VB #
CalculateField StudyAreas ELEM_DESC "Ala Wai" VB #
CalculateField StudyAreas ELEM_DESC "Lunalilo" VB #
CalculateField StudyAreas ELEM_DESC "Kaahumanu" VB #
CalculateField StudyAreas ELEM_DESC "Royal" VB #
CalculateField StudyAreas ELEM_DESC "Kaiulani" VB #
CalculateField StudyAreas ELEM_DESC "Maemae" VB #
CalculateField StudyAreas ELEM_DESC "Puuhale" VB #
CalculateField StudyAreas ELEM_DESC "Kapalama" VB #
CalculateField StudyAreas ELEM_DESC "Kapalama" VB #
CalculateField StudyAreas ELEM_DESC "Ewa Beach" VB #
CalculateField StudyAreas ADD_SCHL_Name "Keoneula" VB #
CalculateField StudyAreas MID_DESC "" VB #
CalculateField StudyAreas INT_ 273 VB #
CalculateField StudyAreas HIGH_ 272 VB #
CalculateField StudyAreas INT_DESC "Waianae Int" VB #
CalculateField StudyAreas INT_ 263 VB #
CalculateField StudyAreas HIGH_ 263 VB #
CalculateField StudyAreas INT_DESC "Nanakuli Int" VB #
CalculateField StudyAreas HIGH_ 292 VB #
CalculateField StudyAreas INT_ 291 VB #
CalculateField StudyAreas HIGH_ 252 VB #
CalculateField StudyAreas INT_DESC "Ewa Makai Mid" VB #
CalculateField StudyAreas INT_ 307 VB #
CalculateField StudyAreas HIGH_ 307 VB #
CalculateField StudyAreas INT_DESC "Kahuku High and Int" VB #
CalculateField StudyAreas HIGH_ 214 VB #
CalculateField StudyAreas INT_DESC "Mililani Mid" VB #
CalculateField StudyAreas INT_ 238 VB #
CalculateField StudyAreas HIGH_ 216 VB #
CalculateField StudyAreas INT_DESC "King Int" VB #
CalculateField StudyAreas HIGH_ 301 VB #
CalculateField StudyAreas INT_ 318 VB #
CalculateField StudyAreas INT_DESC "Kailua Int" VB #
CalculateField StudyAreas HIGH_ 312 VB #
CalculateField StudyAreas INT_ 310 VB #
CalculateField StudyAreas HIGH_ 309 VB #
CalculateField StudyAreas INT_ 310 VB #
CalculateField StudyAreas INT_ 139 VB #
CalculateField StudyAreas INT_DESC "Niu Valley Mid" VB #
CalculateField StudyAreas HIGH_ 119 VB #
CalculateField StudyAreas ELEM_ 114 VB #
CalculateField StudyAreas INT_ 116 VB #
CalculateField StudyAreas HIGH_ 119 VB #
CalculateField StudyAreas ELEM_ 149 VB #
CalculateField StudyAreas INT_DESC "Waipahu Int" VB #
CalculateField StudyAreas HIGH_ 277 VB #
CalculateField StudyAreas INT_ 278 VB #
CalculateField StudyAreas INT_DESC "Highlands Int" VB #
CalculateField StudyAreas INT_ 255 VB #
CalculateField StudyAreas HIGH_ 266 VB #
CalculateField StudyAreas INT_DESC "Aiea Int" VB #
CalculateField StudyAreas INT_ 201 VB #
CalculateField StudyAreas HIGH_ 202 VB #
CalculateField StudyAreas INT_DESC "Moanalua Int" VB #
CalculateField StudyAreas HIGH_ 218 VB #
CalculateField StudyAreas INT_ 219 VB #
CalculateField StudyAreas ELEM_ 203 VB #
CalculateField StudyAreas HIGH_DESC Radford VB #
CalculateField StudyAreas HIGH_DESC "Radford" VB #
CalculateField StudyAreas INT_DESC "Aliamanu Mid" VB #
CalculateField StudyAreas INT_ 204 VB #
CalculateField StudyAreas HIGH_ 224 VB #
CalculateField StudyAreas INT_DESC "Aliamanu Mid" VB #
CalculateField StudyAreas STDYAREA "" VB #
CalculateField StudyAreas ELEM_ 0 VB #
CalculateField StudyAreas MID_ 0 VB #
CalculateField StudyAreas INT_ 0 VB #
CalculateField StudyAreas DISTRICT "" VB #
CalculateField StudyAreas ADD_SCHL1 0 VB #
CalculateField StudyAreas ADD_SCHL2 0 VB #
CalculateField StudyAreas ADD_SCHL3 0 VB #
CalculateField StudyAreas ADD_SCHL4 0 VB #
CalculateField StudyAreas ADD_SCHL5 0 VB #
CalculateField StudyAreas INT_DESC "" VB #
CalculateField StudyAreas ertyert "" VB #
CnvText2Proper StudyAreas ELEM_DESC ertyert
CalculateField StudyAreas ELEM_DESC [ertyert] VB #
CnvText2Proper StudyAreas INT_DESC ertyert
CalculateField StudyAreas INT_DESC [ertyert] VB #
CnvText2Proper StudyAreas HIGH_DESC ertyert
CalculateField StudyAreas HIGH_DESC [ertyert] VB #
CnvText2Proper StudyAreas REGION2 ertyert
CalculateField StudyAreas REGION2 [ertyert] VB #
CalculateField StudyAreas HIGH_ 355 VB #
CalculateField StudyAreas INT_ 356 VB #
CalculateField StudyAreas HIGH_ 392 VB #
CalculateField StudyAreas INT_ 390 VB #
CalculateField StudyAreas INT_ 404 VB #
CalculateField StudyAreas HIGH_ 400 VB #
CalculateField StudyAreas HIGH_ 418 VB #
CalculateField StudyAreas INT_ 420 VB #
CalculateField StudyAreas HIGH_ 435 VB #
CalculateField StudyAreas HIGH_ 455 VB #
CalculateField StudyAreas HIGH_ 456 VB #
CalculateField StudyAreas INT_ 448 VB #
CalculateField StudyAreas INT_DESC "" VB #
CalculateField StudyAreas INT_DESC "Ewa Makai Mid" VB #
CalculateField StudyAreas TempNameField [HIGH_DESC] VB #
CalculateField StudyAreas TRUSTEE 0 VB #
CalculateField StudyAreas ADD_SCHL_Name "" VB #
CalculateField StudyAreas DISTRICT "HIDOE" VB #
CalculateField Admin_Name STDYAREA [OBJECTID] VB #
CalculateField StudyAreas COMPLEX_ZONE [HIGH_DESC] VB #
CalculateField StudyAreas COMPLEX_ZONE RTrim( [COMPLEX_ZONE] ) VB #
CalculateField StudyAreas COMPLEX_ZONE "[COMPLEX_ZONE] &" "& "Complex"" VB #
CalculateField StudyAreas STDYAREA [OBJECTID] VB #
CalculateField StudyAreas ELEM_DESC "Koa Ridge and Waiawa Open Area" VB #
CalculateField StudyAreas INT_DESC "Koa Ridge and Waiawa Open Area" VB #
CalculateField StudyAreas HIGH_DESC "Koa Ridge and Waiawa Open Area" VB #
CalculateField StudyAreas COMPLEX_AREA "FARRINGTON-KAISER-KALANI" VB #
CalculateField StudyAreas COMPLEX_AREA "KAIMUKI-MCKINLEY-ROOSEVELT" VB #
CalculateField StudyAreas COMPLEX_AREA "AIEA-MOANALUA-RADFORD" VB #
CalculateField StudyAreas COMPLEX_AREA "LEILEHUA-MILILANI-WAIALUA" VB #
CalculateField StudyAreas COMPLEX_AREA "CAMPBELL-KAPOLEI" VB #
CalculateField StudyAreas COMPLEX_AREA "PEARL CITY-WAIPAHU" VB #
CalculateField StudyAreas COMPLEX_AREA "NANAKULI-WAIANAE" VB #
CalculateField StudyAreas COMPLEX_AREA "CASTLE-KAHUKU" VB #
CalculateField StudyAreas COMPLEX_AREA "KAILUA-KALAHEO" VB #
CalculateField StudyAreas COMPLEX_AREA "HILO-WAIAKEA" VB #
CalculateField StudyAreas COMPLEX_AREA "KAU-KEAAU-PAHOA" VB #
CalculateField StudyAreas COMPLEX_AREA "HONOKAA-KEALAKEHE-KOHALA-KONAWAENA" VB #
CalculateField StudyAreas COMPLEX_AREA "BALDWIN-KEKAULIKE-MAUI" VB #
CalculateField StudyAreas COMPLEX_AREA "HANA-LAHAINALUNA-LANAI-MOLOKAI" VB #
CalculateField StudyAreas COMPLEX_AREA "KAPAA-KAUAI-WAIMEA" VB #
CalculateField StudyAreas COMPLEX_AREA "NIIHAU" VB #
CalculateField StudyAreas COMPLEX_AREA "NON APPLICABLE" VB #
CalculateField StudyAreas COMPLEX_AREA "NON APPLICABLE" VB #
Dissolve StudyAreas S:\district\Hawaii\GIS\SchlYr1213\GDB\BaseMap.gdb\Misc\ComplexAreas COMPLEX_AREA # MULTI_PART DISSOLVE_LINES
Project ComplexAreas "J:\GIS\00_New Data to clean and load\00_20170530 - Update 6\SOH_Update6_process.gdb\Sch_Complex_Areas" PROJCS['NAD_1983_HARN_UTM_Zone_4N',GEOGCS['GCS_North_American_1983_HARN',DATUM['D_North_American_1983_HARN',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Transverse_Mercator'],PARAMETER['False_Easting',500000.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-159.0],PARAMETER['Scale_Factor',0.9996],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Meter',1.0]] NAD_1983_To_HARN_Hawaii PROJCS['NAD_1983_UTM_Zone_4N',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Transverse_Mercator'],PARAMETER['False_Easting',500000.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-159.0],PARAMETER['Scale_Factor',0.9996],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Meter',1.0]] NO_PRESERVE_SHAPE # NO_VERTICAL
FeatureClassToFeatureClass Z:\Geodatabase\SOH.gdb\AdminBnd\Sch_Complex_Areas "J:\GIS\00_New Data to clean and load\00_20170530 - Update 6\00_20170626 - For Download site\DOE Boundaries" Sch_Complex_Areas.shp # "COMPLEX_AR "COMPLEX_AREA" true true false 50 Text 0 0 ,First,#,Z:\Geodatabase\SOH.gdb\AdminBnd\Sch_Complex_Areas,COMPLEX_AREA,-1,-1;Shape_Leng "Shape_Leng" false true true 8 Double 0 0 ,First,#,Z:\Geodatabase\SOH.gdb\AdminBnd\Sch_Complex_Areas,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,Z:\Geodatabase\SOH.gdb\AdminBnd\Sch_Complex_Areas,Shape_Area,-1,-1" #
Select "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\Shapefiles\Sch_Complex_Areas.shp" "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb\layer_complex" #
AddField layer_complex ID_NEW Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_complex ID_NEW name_clean(!COMPLEX_AR!) "Python 3" # Text NO_ENFORCE_DOMAINS
JoinField layer_complex ID_NEW "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\CleanData\HI_Complex_Data2.csv" name_id_clean #
CopyFeatures layer_complex "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb\layer_HI_complex_NatHaw" # # # #
AddField layer_HI_complex_NatHaw sym "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_NatHaw sym !NatHaw! "Python 3" # Text NO_ENFORCE_DOMAINS
AlterField layer_HI_complex_NatHaw sym # "% Native Hawaiian" "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR
AddField layer_HI_complex_NatHaw sym_pu Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_NatHaw sym_pu !NatHaw_pu! "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_complex_NatHaw type Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_NatHaw type "NatHaw" "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_complex_NatHaw type2 Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_NatHaw type2 "complex" "Python 3" # Text NO_ENFORCE_DOMAINS
20220527
10410100
20220527
10410100
FGDC CSDGM Metadata
Microsoft Windows 10 Version 10.0 (Build 19043) ; Esri ArcGIS 12.9.2.32739
layer_HI_complex_NatHaw
002
HITS
HI Teacher Shortage: % Native Hawaiian, Complex Level (updated 05/27/2022)
File Geodatabase Feature Class
0.000
dataset
EPSG
6.13(10.0.0)
Simple
FALSE
0
TRUE
FALSE
0
layer_HI_complex_NatHaw
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.
COMPLEX_AR
COMPLEX_AR
String
50
0
0
Shape_Leng
Shape_Leng
Double
8
0
0
ID_NEW
ID_NEW
String
255
0
0
Field1
Field1
Integer
4
0
0
name_id_clean
name_id_clean
String
8000
0
0
mhi
mhi
Double
8
0
0
hcost
hcost
Double
8
0
0
complex_area
complex_area
String
8000
0
0
septran
septran
Double
8
0
0
septran_5yr
septran_5yr
Double
8
0
0
seperations
seperations
Double
8
0
0
transfers
transfers
Double
8
0
0
stu_curr_total
stu_curr_total
Double
8
0
0
retain
retain
Double
8
0
0
vacancies
vacancies
Double
8
0
0
st_bipoc_c
st_bipoc_c
Double
8
0
0
othPacIs_c
othPacIs_c
Double
8
0
0
Micronesian_c
Micronesian_c
Double
8
0
0
NatHaw_c
NatHaw_c
Double
8
0
0
tr_bipoc_c
tr_bipoc_c
Double
8
0
0
staff_fte
staff_fte
Double
8
0
0
st_bipoc
st_bipoc
Double
8
0
0
othPacIs
othPacIs
Double
8
0
0
Micronesian
Micronesian
Double
8
0
0
NatHaw
NatHaw
Double
8
0
0
tr_bipoc_per
tr_bipoc_per
Double
8
0
0
bipoc_gap
bipoc_gap
Double
8
0
0
bipoc_parity
bipoc_parity
Double
8
0
0
to_rate
to_rate
Double
8
0
0
to_rate_pu
to_rate_pu
String
8000
0
0
to_rate_slide
to_rate_slide
Double
8
0
0
to_rate_s
to_rate_s
Double
8
0
0
to_rate_s_pu
to_rate_s_pu
String
8000
0
0
to_rate_s_slide
to_rate_s_slide
Double
8
0
0
to_rate_t
to_rate_t
Double
8
0
0
to_rate_t_pu
to_rate_t_pu
String
8000
0
0
to_rate_t_slide
to_rate_t_slide
Double
8
0
0
ret_rate
ret_rate
Double
8
0
0
ret_rate_pu
ret_rate_pu
String
8000
0
0
ret_rate_slide
ret_rate_slide
Double
8
0
0
vac_rate
vac_rate
Double
8
0
0
vac_rate_pu
vac_rate_pu
String
8000
0
0
vac_rate_slide
vac_rate_slide
Double
8
0
0
mhi_pu
mhi_pu
Integer
4
0
0
mhi_slide
mhi_slide
Double
8
0
0
hcost_pu
hcost_pu
Integer
4
0
0
hcost_slide
hcost_slide
Double
8
0
0
st_bipoc_slide
st_bipoc_slide
Double
8
0
0
st_bipoc_pu
st_bipoc_pu
String
8000
0
0
bipoc_gap_slide
bipoc_gap_slide
Double
8
0
0
bipoc_gap_pu
bipoc_gap_pu
String
8000
0
0
bipoc_parity_slide
bipoc_parity_slide
Double
8
0
0
bipoc_parity_pu
bipoc_parity_pu
String
8000
0
0
othPacIs_slide
othPacIs_slide
Double
8
0
0
othPacIs_pu
othPacIs_pu
String
8000
0
0
Micronesian_slide
Micronesian_slide
Double
8
0
0
Micronesian_pu
Micronesian_pu
String
8000
0
0
NatHaw_slide
NatHaw_slide
Double
8
0
0
NatHaw_pu
NatHaw_pu
String
8000
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.
20220527
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iik
LBRliAM45oAWiis2X7TdjekqpCeVjKn5h2yQc8+noeRWVWrGkryGlc0qK5iO6spZJmZ5YNrGMsu4
kMo+YBh36j6AYro7cyG2iM2BLsG/H97HNKlW9pfSwNWJKKKK2EFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUUUAFZUpfU5HhABiSTDKeBgMQcnnngkAdOD6Vq0gVVLEAAsckgdT0/pUyj
zaALVC5sZdn+hymPJOUJ+U/Q4JX8P06i/RROEZq0lcDDg0if7OtvKIo0OBIYzuBAwABkcE4Ofr3r
coopQpxhpEbdwoooqxBRRUMl3bQ7/MuIkKfeBcAjjNAE1FZJ1O4S7QyRbbVzwWwCB/e6/Q4OMDPX
Fa1RCcZ6xYWCiiirAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACsbXYJ
ET7XAoBwElcKS6rzg8EZAycj0Oe3OzSOqujIwyrDBB7ipnFSjysDyxtV+yXPkSOZEba0JUAhTzxu
4xzge36113hnXn1Ax2rW5iiji2I5BO8j3/3cH3OcZxWqdC0pt+6wgJf7zFck/U9apW3hHS7WaOVP
PPlS+ZGrSZC9cL64Gc//AKzUQp8uw7m9RRVWa5lW4EcCI+1cvuYjB7DOD7/p61cpxgry2EWqKoi/
l80xfZWZlALFXG0ewJxk+3/1svS/VzF+5lUSkBSdvcZ7HNSq1OWiY7Mt0UUVoIKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAContoJH3vDGzf3ioJqWigChOlgrGNocNgKTFE
2QD2yopT9ntrOW8h+bbGzB3ZmxjqMnJAyOR7VLdQOzxTQqpkU4bJxuXB4zj1wfwot4GUytKEBk6o
pyvpnkck/wBBWPve01WncfQz4tWS3ujFc3kcqu+xcAZDFcjgdR1Hc9OtTHXbRZnRhIFQEtIQAowc
HvnqD27VFfaV5avdQStviXcqELztOQuSOO4z1564qCO1SOCOZLlkQkCRZACshz7epHXJ4PpXPOtU
opKWo0kzeVldQysGB6EHNLWTC4EkfkF45WYboQTjbu5JU9OMnOB1/CtaumjVVSPNawmrBRRRWogo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigApsvmeU/lbfM2nbu6Z7Zp1FAGfDa3M
jyi7IaGVCrJ5hOc47YAHGRx+tOXSbUSB3UybegbGPxx16981eoqeSPXUBkcUcS7Y0VFznCjAzT6K
qvehHfMMhiU4MgxjjqcZzgUSlGO7sBaopFZXUMpDKeQQcg0tUAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABWbcFo73yEnRPOBkHTcuMAgD365+tXLiYwou1dzu21R2
z7+3BqmbJZCzyu5lY5LoxUcdMDOOK4sZUgo8j3KimN+yLbxr5EzwbRj5ehPqV6E0+K6uoiqTIJtw
JBQbWAGOo6E8juKhE0kkincMCNTgRM2GPXofTH504NIJS+/JIwP9Hfj9a4oV6sNmU0maUUqTJvjb
I6e4PoR2NPrGF1BaX8O6aRWnYq5kUqpGDjtgHOAOmfethHV0V0YMrDIYHIIr1aNT2kOYhqwtFFFa
iCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAKuoWrXdoyRvslwdjHpkgjB9uaz0
8ue3icW6Q+YgbmMM3IHQf4/lW1WZFbGKa4RH2IHyu0DOCM459CTgVw42HuqZUSGBIIUENxFEHVRt
JUZcf1b169R606VrVAgWGPcz7OYuRwT0xntU1uCzvKWZgcKpbHIGeeO3NOubeO4RfMZl2MHDK20j
HP4j2PFebfXU0M65sImX7RLbRYjyzFkBYLjnauCB+OTjjr0u2Nx5FuishEBOI2HJXJwFYeuTjj8e
mTDDPH5iwzNJNcqoYADIcdmGPl/w/KrsNqXlM04xyCsWeAR3Pqf0GBXZhVV5tNiJWLlFFFeoQFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZwd2urpEGD5g+YjoNq/ma0ahmto5ju
O5JMYDocH/6/0ORWGIpOrDlQ07MpSGS0txsYSBcKqsMFiTgDPQZOB0qwlq0hD3JDYORGOVHpnjJP
+ccZojtpTOGndWWM5jCj7x9W9/p9fQC3WOGw3J701qNy7DVRUztULk5OBjJp1FFdpIUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH//Z