20220429 15242800 1.0 FALSE layer_HI_island_to_rate_s 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 unnamed Linear Unit: METER (1.000000) NAD83 UTM, Zone 4 North, Meter <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[&quot;NAD83 UTM, Zone 4 North, Meter&quot;,GEOGCS[&quot;unnamed&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;Geodetic Reference System of 1980&quot;,6378137.0,298.257222100911]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;false_easting&quot;,500000.0],PARAMETER[&quot;false_northing&quot;,0.0],PARAMETER[&quot;central_meridian&quot;,-159.0],PARAMETER[&quot;scale_factor&quot;,0.9996],PARAMETER[&quot;latitude_of_origin&quot;,0.0],UNIT[&quot;METER&quot;,1.0]]</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></ProjectedCoordinateSystem> Dissolve Haw_St_geo_20070426_region "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 04042022\GTL 04042022.gdb\Haw_St_geo_20070426_region_D" ISLAND # MULTI_PART DISSOLVE_LINES FeatureClassToFeatureClass Haw_St_geo_20070426_region_D "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\Shapefiles" Sch_islands.shp # "ISLAND "ISLAND" true true false 10 Text 0 0,First,#,Haw_St_geo_20070426_region_D,ISLAND,0,10;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Haw_St_geo_20070426_region_D,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Haw_St_geo_20070426_region_D,Shape_Area,-1,-1" # Select "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\Shapefiles\Sch_islands.shp" "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb\layer_island" # AddField layer_island ID_NEW Text # # # # NULLABLE NON_REQUIRED # CalculateField layer_island ID_NEW !ISLAND!.lower() "Python 3" # Text NO_ENFORCE_DOMAINS JoinField layer_island ID_NEW "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\CleanData\HI_Island_Data2.csv" name_id_clean # CopyFeatures layer_island "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb\layer_HI_island_to_rate_s" # # # # AddField layer_HI_island_to_rate_s sym "Double (double precision)" # # # # NULLABLE NON_REQUIRED # CalculateField layer_HI_island_to_rate_s sym !to_rate_s! "Python 3" # Text NO_ENFORCE_DOMAINS AlterField layer_HI_island_to_rate_s sym # "Teacher Mobility/Attrition Rate per 100 Students (Seperations)" "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR AddField layer_HI_island_to_rate_s sym_pu Text # # # # NULLABLE NON_REQUIRED # CalculateField layer_HI_island_to_rate_s sym_pu !to_rate_s_pu! "Python 3" # Text NO_ENFORCE_DOMAINS AddField layer_HI_island_to_rate_s type Text # # # # NULLABLE NON_REQUIRED # CalculateField layer_HI_island_to_rate_s type "to_rate_s" "Python 3" # Text NO_ENFORCE_DOMAINS AddField layer_HI_island_to_rate_s type2 Text # # # # NULLABLE NON_REQUIRED # CalculateField layer_HI_island_to_rate_s type2 "island" "Python 3" # Text NO_ENFORCE_DOMAINS 20220527 10321800 20220527 10321800 Microsoft Windows 10 Version 10.0 (Build 19043) ; Esri ArcGIS 12.9.2.32739 layer_HI_island_to_rate_s HITS HI Teacher Shortage: Teacher Mobility/Attrition Rate per 100 Students (Seperations), Island Level (updated 05/27/2022) File Geodatabase Feature Class 0.000 dataset 0 Simple FALSE 0 TRUE FALSE layer_HI_island_to_rate_s 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. ISLAND ISLAND String 10 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 island_1 island String 8000 0 0 septran septran Double 8 0 0 seperations seperations Double 8 0 0 septran_5yr septran_5yr 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 String 8000 0 0 mhi_slide mhi_slide Double 8 0 0 hcost_pu hcost_pu String 8000 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/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigD//2Q==