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_s
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_s" # # # #
AddField layer_HI_complex_to_rate_s sym "Double (64-bit floating point)" # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_to_rate_s sym !to_rate_s! "Python 3" # Text NO_ENFORCE_DOMAINS
AlterField layer_HI_complex_to_rate_s sym # "Teacher Seperation Rate per 100 Students" "Double (64-bit floating point)" 8 NULLABLE DO_NOT_CLEAR
AddField layer_HI_complex_to_rate_s type Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_to_rate_s type "to_rate_s" "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_complex_to_rate_s type2 Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_to_rate_s type2 "complex" "Python 3" # Text NO_ENFORCE_DOMAINS
20260108
10222100
20260108
10222100
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_s_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_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.
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
CiiigAooooAKKKKACiiigAooooAKKzb3VIbGS3idXeSd9ipGAT9celaNFmJNMgmljghkmkbakalm
PoBya43U/GUjgx2ERjX/AJ6yAE/gOn55+lbvia1u7vS9lnkncC6L1dfSvPpoJbeQxzRvG4/hdcGu
rD0oS1kcuIqzjojUbxRqrYxchRtx8qLz79Ov+FdD4a1yXU5Jba72mVF3qwGMjoc/mPzrhAMjOTz0
ruPBVsEsp7gq26STaGI4KgdvxJrSvCEYbGWHnOVTVnWUUUVwnoBRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZmrzzWml3E1uheVV+UAdO2fw61
pUULRiaujl9F0Bklh1K8lka8b5ypPAz6++K6mikpyk5O7FGKirIWs6/0m01ML9piDlQQrZIIzWh2
ooTad0NpPRnNHwXp2VKyThQeV3DkenSt+GCK3hWKFFSNRhVUcCp6SnKcpbsmMIx2QtFFFSWFFFFA
BRRRQAUlFZV9qb2kgVLdmQdXIIB9hTSb0Qm7GtRTI3WRFdTlWGRT6QwooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKaRkEZI9xTqK
APPbv4gLpGv3ei6jp95LJGw+zPbJlrgHoNpI556g4OD06Vn2PxA1zV1mFr4Ue5tHL+XM0vkoU3EL
ksCuexweoP4dhrelWs00OsvbebeaejtByR1HOcdcdRXM2dzcJo8sJsbyTyC0sTwJnGQS3BwM9SM+
tdEVBxukckvaKdnLT0N3w5q80122n3EQikjgWVkMgfaTj5VI+8BzzXUAg9CD9K8hhgvTHZXw+1x6
rIFcSvwY8j7gXp0P+eRXaeD7j7PYtpsyiNonYx4UDduJY9OM5J6Uq1JL3osqlVbfLJHW0UUVgdIU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRR
RQAUUUUAFFFFAEU0EVwhSVAynsaZHbQRPvjiRGxtyq44qxRQAUUUhAIIPQ0AMBYjIAx2zxS7m/u8
/Wl2f7TfnTdmBwzD8c/zoAXf6q2fpShgTjBB96TD+o+uKZJJHbRNLK2FHVjQBLS1mWur2l3cG3Ry
swG4I/BI9q06bTW4k09gooopDCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKAG1yfjCbXbS1F1pU8ccEKFphsBf68gjAFdZVS9tI72xntJc+
XNGY22nBwRjiqhJRkm0Z1YOcGk7Hn3h7x9ObxINYaMwvhROq7Sp9Wxxj+Vd9qVu1zYskeSwIYAd8
dq5rTfh7p1jcx3Ms007xkMqthVyOhIHX867LpWlaVNzvTMcNGqoNVGeT+JdZfw9dQ3+xhKOIsDqw
7N6dfyzXOax8VPEGpxSQ2xi0+JjjMGTJjHTcen1ABr2+506yvHikuLaGVom3oXQHBwRn8ia+dfGt
hHpnjHVbWLHlicuoAAADgPgD0G7H4V1YaVOq7SjqjlxaqUlzRlozd8MfEvVNMvwmr3Et9ZSHDeYc
vHk53A9+p49AMYxXsej+INM1y3WXT7qKUlFdow4Lx57Mucg18vjp04rU0XS9T1TVIIdLSX7QW+WR
SVCYGSS3bArWvhqb95aGWHxVRWjbm/M+paKggV0gjSRt8iqAzepxyanryj2QooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigArG1u/uNK09rm
006fUJtwVYIOpJOMk9h6nBrYooW4mro4jwtqPi281W8m16zFnYmMGCEIvytn+9nPTrn9MGjXvhto
3iHVn1Kea7hmkx5ohcYcgAA8g44A6V21FX7VqXNHT0M/ZRceWWvqcjo/gDw7o0W1LBbuRshpbsCV
iPpjA9OAPeumtbWCyt1gtoI4IUGFjiQKq/QCrH40tTKUpO7ZUYRgrRVhaKKKRYUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQByfjHXrrQrC3ktUQySy7S0i5AAGfXr/APXqn4Y8bLrF2ljeQrBcMP3bISRIQMkYx8vAz1rX
8VaH/b+jvao4SZGEkRPTcAeD7EEis7w74Kg0WWO8lla4vF5Vh8qpkEEAd+vf9K6Yul7K0viOKare
2Tj8J2IIIyORS03YO2R9DSfMvfcPfrXMdo+iqNnqdjqO77JcxTFfvKrZK/UVeoAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooASkNFcX8SN
R1XTfCkk2lFkdpAk0qD5o4yDkg9jnAz2z2604Rc5KK6kTnyRcn0Mf4jeO10+xGm6LfRNezMyTyQu
GaBRwRkH5WJ49Rg9Dg0fDbxpJq6f2NqDzS30as6TsQQyDHHA6j3zXidd98JD/wAVoWwTi1k6D3Wv
Tq4aEKDXVa3PKpYuc66fR6WPeDKgJGeR7VkeINTfT9FuJreOSSYrsTap4J4znHbrWvGCBz1JJxUl
eWeweM6XpuupexS2FrdxS5+WQIVHXuTxj6163YtdfZIlvhGLnb8/l/dJ9qt1A8mJBtBYgEEDt0oA
nopqtuXOCPY06gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKAEFU7yxtr6zktLuCOaCT78brlW5z0+vNXKKBNXPl3xLpi6L4j1HTkX93BMRHk5Ow
8r+hFQ6RrF7oeox31jKI5k45UEMD1BHoa9E+MekrDPY6tDAqiYtFcSAAEvgbM9zwG/75ryrNe3Rk
qtJXPn68XRrPlPpTQPFena5oKan58VvtXNwjyAeSR1yT29/SreleI9J1suunX8Nw0f3lU8jkjoec
cHmvmTcygqGIDDDAHr35/EU+1vJ7G7iurWV4Z4m3JIhwQa53gE7tP0OqOYtWTj6n1SHMgByxz/Co
xj8adtIQ7iEUckL/AI15t4T+JsmsXQsLu0ijmEWVcSkeY464XHAxk9f/AK3UXWq3N0pTIjQ9Qnf8
a4ZUJxdpHpQrQnHmiXk1qEXBQRkQ9m759cVrxTRzxiSJgynuK5ezsprx/l+WMdXPT8PU10tvbpbQ
LDHnavrSmorYuLb3J6KKKzKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooA8x+M1wE8O2NvnDSXYbGeoVG/qwrxQcc17J8Y9Pu7mwsLyJS1tbM6zA
HkFtuDj04NeNk5r18Fb2aSPCx1/au4Cp7Syub+4W3s7eW4mbokSlj+lavhTw+/ifxBBpwkMaEF5Z
AMlUHX8eg59a9/0Xw1pXh+CSHTbQQCUgyNuLM5HTJJJx7dOT61WIxSpaWuxYbByre83ZHm1h8H7/
AOyxXEmsJbXwIbZHGWEfP97IOcY7fn1r0XSPDzWFokd/d/b5l/5aGPYD9Rk/zx7V0NFeXUr1KnxM
9ilQhT+FDVRUUKoAUdABT6KKyNgooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigBhAIwRmuH8VfDzStdS4uLaIWupFPkePhWI6bl6c9M13VJV
QnKDvFkThGatJXOR8FeEE8KabsZ1lvJwDcSL93IzgLnnAz+PXiuuFFLSlJybbHCChFRjsLRRRSKC
iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKAP/9k=