20211022
15563200
1.0
FALSE
file://\\DESKTOP-3NIS9O2\C$\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Hawaii_Jan26\Hawaii_Jan26.gdb
Local Area Network
layer_HI_complex_to_rate
002
371125.265000
940279.454500
2094231.125400
2458613.756900
1
0.000
Projected
GCS_North_American_1983_HARN
Linear Unit: Meter (1.000000)
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/3.1.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>
FeatureClassToFeatureClass high_sch_areas "C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb" incentives # "OBJECTID "OBJECTID" true true false 10 Long 0 10,First,#,high_sch_areas,OBJECTID,-1,-1;HIGH_DESC "HIGH_DESC" true true false 50 Text 0 0,First,#,high_sch_areas,HIGH_DESC,0,50;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,high_sch_areas,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,high_sch_areas,Shape_Area,-1,-1" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>DATABASE=C:\Users\chenry\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\GTL 05262022\GTL 05262022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>incentives</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Tier</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Tier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
DeleteField incentives Tier "Delete Fields"
FeatureClassToFeatureClass incentives "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\Shapefiles" hi_complex.shp # "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,incentives,OBJECTID,-1,-1;HIGH_DESC "HIGH_DESC" true true false 50 Text 0 0,First,#,incentives,HIGH_DESC,0,50;Shape_Leng "Shape_Leng" true true false 8 Double 0 0,First,#,incentives,Shape_Leng,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,incentives,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,incentives,Shape_Area,-1,-1" #
PairwiseDissolve hi_complex "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\Shapefiles\hi_complex_dissolve.shp" HIGH_DESC # MULTI_PART
Select "\\dc1fs\dc1ehd\share\GIS Methods Group\GTL\Shapefiles\hi_complex_dissolve.shp" "C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Hawaii_Jan26\Hawaii_Jan26.gdb\layer_complex" #
JoinField layer_complex HIGH_DESC table_HI_complex complex # "Select transfer fields" #
CopyFeatures layer_complex "C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Hawaii_Jan26\Hawaii_Jan26.gdb\layer_HI_complex_to_rate" # # # #
AddField layer_HI_complex_to_rate sym "Double (64-bit floating point)" # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_to_rate sym !to_rate! "Python 3" # Text NO_ENFORCE_DOMAINS
AlterField layer_HI_complex_to_rate sym # "Teacher Seperation and Transfer Rate per 100 Students" "Double (64-bit floating point)" 8 NULLABLE DO_NOT_CLEAR
AddField layer_HI_complex_to_rate type Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_to_rate type "to_rate" "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_complex_to_rate type2 Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_to_rate type2 "complex" "Python 3" # Text NO_ENFORCE_DOMAINS
20260108
10214800
20260108
10214800
FGDC CSDGM Metadata
150000000
5000
FGDC
Microsoft Windows 10 Version 10.0 (Build 22631) ; Esri ArcGIS 13.1.3.41833
layer_HI_complex_to_rate_06172022
1
-160.250473
-154.732112
22.232969
18.893352
HI Teacher Shortages (updated 7/16/2024)
Updated 011526 CDeal
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>High School District Areas as of September 2021. Source Hawaii State Department of Education. For more information, please refer to metadata at https://files.hawaii.gov/dbedt/op/gis/data/public_school_area_boundaries.pdf or contact Hawaii Statewide GIS Program, Office of Planning and Sustainable Development, State of Hawaii; PO Box 2359, Honolulu, Hi. 96804; (808) 587-2846; email: gis@hawaii.gov; Website: https://planning.hawaii.gov/gis.</SPAN></P></DIV></DIV></DIV>
Hawaii State Department of Education; Hawaii Statewide GIS Program
HITS
File Geodatabase Feature Class
0.000
dataset
EPSG
6.13(10.0.0)
0
Simple
FALSE
0
TRUE
FALSE
layer_HI_complex_to_rate
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.
HIGH_DESC
HIGH_DESC
String
50
0
0
Field1
Field1
Integer
4
0
0
Unnamed__0_x
Unnamed: 0_x
Integer
4
0
0
complex
complex
String
8000
0
0
complex_area
complex_area
String
8000
0
0
stu_curr_total
stu_curr_total
Double
8
0
0
tcurr_total
tcurr_total
Double
8
0
0
seperations
seperations
Double
8
0
0
transfers
transfers
Double
8
0
0
septran
septran
Double
8
0
0
retain
retain
Double
8
0
0
vacancies
vacancies
Double
8
0
0
FTE_total
FTE_total
Double
8
0
0
vacancies_5yr
vacancies_5yr
Double
8
0
0
FTE_total_5yr
FTE_total_5yr
Double
8
0
0
staff_fte
staff_fte
Double
8
0
0
tr_bipoc_c
tr_bipoc_c
Double
8
0
0
stu_curr_total_5yr
stu_curr_total_5yr
Double
8
0
0
cte_count
cte_count
Double
8
0
0
total
total
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
st_bipoc
st_bipoc
Double
8
0
0
st_bipoc_slide
st_bipoc_slide
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_gap_slide
bipoc_gap_slide
Double
8
0
0
bipoc_parity
bipoc_parity
Double
8
0
0
bipoc_parity_slide
bipoc_parity_slide
Double
8
0
0
to_rate
to_rate
Double
8
0
0
to_rate_slide
to_rate_slide
Double
8
0
0
to_rate_p
to_rate_p
Double
8
0
0
to_rate_s
to_rate_s
Double
8
0
0
to_rate_s_slide
to_rate_s_slide
Double
8
0
0
to_rate_s_p
to_rate_s_p
Double
8
0
0
to_rate_t
to_rate_t
Double
8
0
0
to_rate_t_slide
to_rate_t_slide
Double
8
0
0
to_rate_t_p
to_rate_t_p
Double
8
0
0
ret_rate
ret_rate
Double
8
0
0
ret_rate_slide
ret_rate_slide
Double
8
0
0
ret_rate_p
ret_rate_p
Double
8
0
0
vac_rate
vac_rate
Double
8
0
0
vac_rate_slide
vac_rate_slide
Double
8
0
0
vac_rate_p
vac_rate_p
Double
8
0
0
vac_rate_5yr
vac_rate_5yr
Double
8
0
0
vac_rate_5yr_p
vac_rate_5yr_p
Double
8
0
0
vac_rate_5diff
vac_rate_5diff
Double
8
0
0
vac_rate_5diff_p
vac_rate_5diff_p
Double
8
0
0
Unnamed__0_y
Unnamed: 0_y
Integer
4
0
0
mhi
mhi
Double
8
0
0
hcost
hcost
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.
20260108
/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
CiiigAooooAKKKKACiiigAooooASisfU9at9MmtIHjeSa6lEaRxgFv8AexnoOK1weKGmkJSTdkQT
zx2ltLPM22OJS7t6ADJNcdL8QLGUrHA7x7m273Tke/oB+dafjSx1DUNCaLTiS+8GSNTgyL6fyP4V
5Fc2txZzGG5gkhkHO2RSp/WuzC0IVE3J6nBi8TUoySitD1r+17xwCJuMdgOfetLStQe6d4piC4G5
SBjI7/0rzTT7q8gs40adzxwDzgdhXfeEmkmspbiVTvaTaGxgFQO345pVqShG5tRr+0djpaKKK5Dq
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAb
WTr13cWWiXdxaRGSdE+RQM89M49uv4Vr0Ypp2dyZJtWTOJ8P+FXiuYNa1KWd9SbMjKW4UkYweM5w
cY6V23QUUU5Tcndk06agrIKydV0LT9YVBeW4kZAQjgkMufcVrU0/Wkm07oqUVJWauc1/whWngptk
nCqeVLg5HpnGa6GGGK3hWGFFSNRhVUcCpqSnKcpbsUYRj8KHUUUVJYUUUUAFFFFABRRURlyxCkD0
z3oAlopqncoI706gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC
iiigAooooAKKKKACiiigAooooAKaRkEZI9xTqKAPPbr4gLpOv3ei6lp95LJGw+zPbJlrgHoNpI55
6g4OD06VS034g6/qzyfYfC0tzbsWMU3mmJSm4hckgjI6HB6g/h1evadas0etm08+902OR4BuIzkc
5x19RXM+FdRvbfRJI2srt2iMjxSRxcJkEnrx1JI+uK6IqDhzJdupxylNVFFy016HX6Xqkl1Ktrc2
7292IFkmjLAhWIGQpHXnPNbAIPTB+leYXFzNBFbXbPdy6tKgkaaX5RHxxGiYx3/X3xW/4KnurWwf
S7+D7PNE5aMbAu4Nlj04zkk9uoqJ07LmRpTq3fK0dnRRRWR0BRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUmKWigCu8EUpUvGrFD
lSRyp9vSnCCJZTKsaiQjBbHOKmooAKKKQgEEHoaAGAsRkAY7Z4pdzf3efrS7P9pvzpuzA4Zh+Of5
0ALv9VbP0pQwJxgg+9Jh/UfXFMkkjtomllbCjqxoAlpazLXV7S7uDbo5WYDcEfgke1adNprcSaew
UUUUhhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABUbZDDJIXpx61JSMNwxQBGdyc53L3z1qrqlu9zYskeSwIYAd8dqt7SeGbj0AxmpKE7O
4HmeoS3FlqkN1ENjpjafcdQR+NZHjTx3qyWKwWk4snmY8wr82zHPzHp1HIwa9Xmsrad0klhR3U5B
Zec4xXg3xIsmtPEcuZozFvIihVcFQcE+3fH5V34eUKskpLY87FKdKDlF7lnwx8S9U0y/CavcS31l
IcN5hy8eTncD36nj0AxjFex6P4g0zXLdZdPuopSUV2jDgvHnsy5yDXy+OnTitTRdL1PVNUgh0tJf
tBb5ZFJUJgZJLdsCtq+Gpv3loc+HxVRWjbm/M+paKggV0gjSRt8iqAzepxyanryj2QooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAqhqN3L
a2vmQ20lzJkARx+/c+1X6Q0LcT2Of0e41m4vZmv4jDblMom0DBz69en+RWd4k+H+l+J75Lu6nuoX
UHcIWUbunqDjpXY0VaqOL5o6EOnGUeWepyGj+APDmjRbUsFu5GyGluwJWI+mMD04A966a1tYLK3W
C2gjghQYWOJAqr9AKsfjS1MpSk7tjjCMFaKsLRRRSLCiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAOT8Y69daFYW8lq
iGSWXaWkXIAAz69f/r1T8MeNl1i7SxvIVguGH7tkJIkIGSMY+XgZ61r+KtD/ALf0d7VHCTIwkiJ6
bgDwfYgkVneHfBUGiyx3ksrXF4vKsPlVMgggDv17/pXTF0vZWl8RxTVb2ycfhOxBBGRyKWm7B2yP
oaT5l77h79a5jtH0VRs9TsdR3fZLmKYr95VbJX6ir1ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAB
RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFACUhori/iRqOq6b4Ukm0osjtIEmlQf
NHGQckHsc4Ge2e3WnCLnJRXUic+SLk+hj/Ebx2un2I03Rb6Jr2ZmSeSFwzQKOCMg/KxPHqMHocGj
4beNJNXT+xtQeaW+jVnSdiCGQY44HUe+a8TrvvhIf+K0LYJxaydB7rXp1cNCFFrqtbnlUsXOddPo
9LHvBlQEjPI9qyPEGpvp+i3E1vHJJMV2JtU8E8Zzjt1rXjBA56kk4qSvLPYPGdL03XUvYpbC1u4p
c/LIEKjr3J4x9a9bsWuvskS3wjFzt+fy/uk+1W6geTEg2gsQCCB26UAT0U1W3LnBHsadQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFACCqd5Y21
9ZyWl3BHNBJ9+N1yrc56fXmrlFAmrnh2peDNKstXuYfKk2RyYVDJxt7dOenNXtIij0KcT6bGsMg6
t1yPQ57V1njSzCTwXsaACTKSMO7Dp+mfyrla9SnP2kFc8mpD2dR2PSbHXLO800XUk0cO1cyq7AbM
dc57VLp2t6bqpcWd3HMyfeUZBH4H6V4ley+ZdSFZCyn5eOmPT86jt7ia2uI7i3kaOWM7ldTgg1P1
C6umL+02pWcdD3sOZADljn+FRjH407aQnzEIo5IX/GuG0Dx5LeSC0ubWMSbMhxJje3fjHHc1sXWp
3N0pTIjQ9Qnf8a45UJxdpHp068KkeaLLya1CLgoIyIezd8+uK14po54xJEwZT3FcvZ2U14/y/LGO
rnp+Hqa6W3t0toFhjztX1qZqK2Li29yeiiisygooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKAOU8aygadbxZ5aXd+AB/xFed6nM0VsApwXOM+1dx8
QBPHZW91FHvSMsrc/dJxg4/A15fJK8zl3YljXq4OF4XPGx9Tlm0MqW3tp7uYQ28LyyHoqKSav6Dp
Da3q0VkHKI2WkcDO1R1/w/GvXdL0Kx0eJ47K3EXmEF23FmbHqT/Lpya0xGKVLTdnNhcFKv7zdkcT
a/De78iOaTUEgueDsVCQn/Asjn8P8a7HS/D4s4FW8uDdyj+IrtH5ZP8AOt6krzJ4ipP4me3Sw9Ol
8KGqiooVQAo6ACn0UVibhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFADCoIwRmuT17wZp+qpNcW0fkXpX5WThWI9R056ZrrqQ+9VCcoO8WR
UpxqK0lc5vwr4bXw/YsHYSXUwBmdfu8ZwB7c10fc0velolJzfNLcIQjCKjHZC0UUVJYUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQB//9k=