20220429
15242800
1.0
FALSE
layer_HI_island_vac_rate
002
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
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/3.1.0'><WKT>PROJCS["NAD83 UTM, Zone 4 North, Meter",GEOGCS["unnamed",DATUM["D_North_American_1983",SPHEROID["Geodetic Reference System of 1980",6378137.0,298.257222100911]],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]]</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\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Hawaii_Jan26\Hawaii_Jan26.gdb\layer_island" #
JoinField layer_island ISLAND table_HI_island island # "Select transfer fields" #
CopyFeatures layer_island "C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Hawaii_Jan26\Hawaii_Jan26.gdb\layer_HI_island_vac_rate" # # # #
AddField layer_HI_island_vac_rate sym "Double (64-bit floating point)" # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_island_vac_rate sym !vac_rate! "Python 3" # Text NO_ENFORCE_DOMAINS
AlterField layer_HI_island_vac_rate sym # "Teacher Vacancies per 100 Students" "Double (64-bit floating point)" 8 NULLABLE DO_NOT_CLEAR
AddField layer_HI_island_vac_rate type Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_island_vac_rate type "vac_rate" "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_island_vac_rate type2 Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_island_vac_rate type2 "island" "Python 3" # Text NO_ENFORCE_DOMAINS
20260108
10151400
20260108
10151400
Microsoft Windows 10 Version 10.0 (Build 22631) ; Esri ArcGIS 13.1.3.41833
layer_HI_island_vac_rate_06172022
HITS
HI Teacher Shortages (updated 7/16/2024)
Updated 011526 CDeal
File Geodatabase Feature Class
0.000
dataset
0
Simple
FALSE
0
TRUE
FALSE
layer_HI_island_vac_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.
ISLAND
ISLAND
String
10
0
0
Shape_Leng
Shape_Leng
Double
8
0
0
Field1
Field1
Integer
4
0
0
Unnamed__0_x
Unnamed: 0_x
Integer
4
0
0
island_1
island
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
Double
8
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
CiiigAooooAKKKKACiiigAooooAKKYzheOp9qfQBFI6xRtI5wqgkn2rFu9cZxttVKDu7Dn8BV3Vo
Z5rQLBk4b5lHUiubZGRirqVYdiMGtacU9WRJtF06rekj99jAxwo5rQ0rUZLp3hmILgblYDGR3rBr
d0CJRDLLj5i20H2q6kUoii3c2qKKK5zQKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigApjnC9cds+lPooAiVc4PAXOQMc1LRRQAVUubGC7wZUyR0Y
HBq3RQnYDIOgW24Yklx3GRz+laccSQxrHGoVFGABUlJTbb3EkkLRRRSGFFFFABRRRQAUlLWLeawt
vceVGgcKfnbP5gU0m9hN2NqimI6yIrqcqwyKfSGFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABTSMgjOPcU6igDl7y7vIZ5IDcyFQ
SOQASKoV0WsWYntzMud8QzwOorCigeXJCOVAzlVyOma6ISVrmUk7mpolzKztbsQUVSwz1HTj6Vug
g9K4xTJBIrjcjjkHFbWjXamL7O7KrA/IMYz3NRUh9pFRl0NqiiisiwooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAIZ7aG5UL
NGHA6ZpI7WCJ98cSI2NuQMcVPRRcAooqvNEs8LxPna6lTgkHB9xyKAPNrz4t6dZa3dWgtZLiyiO2
O6t3yXOBng44zkZzzjI61bX4u+HntZZPKu0mVWKRSRj5yBwMgkDPStRfhl4RVgw0rJBzzcSkf+hU
ah8OfDN9b+UNNW3YdJLdirDj8j+NdF6Dtozj5cRq7odD8QvDElqly2qxR5Tc0bBt6nuMYznj/ORW
nonibSfEKzHSrwXHlEBxsZSM9OGAOP8AA1w5+C2n+eMavc+RjlTGu78+nr2rttK0nSvCel+RaIIY
EAaSRzlnbpuY9yf/ANQqaipJe422XSlWb/eJJG9RWVp2u2WqStFA7CRedrrgkeorVrFpp2Z0KSau
haKKKBhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFACGue8RzarbRCexdVhjXMuFBb9e1dCar3Nul3aywSZ2SKVOOuDVRdncmavGxyOkeLpj
ciLUNhibgSKMbT7+1b3iKymvtHlit8mQEOFBxux2qjZeELS2uVmllkmKEEKQAuff1rpaucoKScDK
nGTi4zPJbe4msrtJ4iUlibIz2Pof5Vr3vivUrkFIitsn/TMfN+Z/piu3lsLOadZpbaN5R0cqM/8A
16861m2W01e7hTARZCVAGAAecfrXRCcK0tVqc1SE6MdHozQ0rxReW10PtkrzwNw27qvuK7Sx1O01
CIPbyoxKglNw3Ln1HavLKsWVvc3V2kVoGM5+7tOCPfPanVoReuxNLETjo9T1qioowyxIrHLBQCfU
1LXCekFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAB
RRRQAUUUUAFZ2qX0ljaGWCymu5NwVYohzk9z6D3rRooA5bQ73X7zUbk6pbG3ttmY4/LwAc/3uvT/
ACKnv/C9nf3bXTySxu/3whGCce44roKWqjJxd4kyipK0kYtl4a06zXAtxKxGC03zfp0rTgght4xH
BEkSDoqKAP0qeik5N7sIxUdkLRRRSKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAOT8Y6/daHYW8lqiGSSXaTIuQAB
n169P1qjoHxAgvpfs+prFaSbRtl3HYx79fu/ia2PFejf25oz26ttnQ+bCT03AHg/UEivGHUo7I3V
Tg85rvw1GnWptPc8rF16tCspL4WfQqsGUMpBB5BHen14bYeJtY02JYbe+kESkEIwDDjjHPQewrqN
J+JEoYR6rbKynjzYBgj6qev4flWdTBVI6rU2p4+lPR6HpVLWZp2r2Oqx77O6jmAALKp+Zc9MjqPx
rSrlaadmdyaauhaKKKQwooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKAE7UmRjNFcv44vr3T/D7SWTFGaQJJIvVEIIz7c4GfenCLnJRXUipNQg5PoZ
3jPxV9itUs9NuVNxIxEkikN5ag4I9mJ49sHocV5hRRXuUKMaUbI+axGIlWndhRRRW5gT2d7c6fcp
c2k7wzIchkP6H1Hsa9Z8J+J4tetjFKFjvYhmSPPDD+8PbPbtXj9dH4Q1610C9ubm6WZw8QRUiAJJ
yD3IrjxVFThdLU7cFiHTqJN+6z2alrO0zUINWsIb2Dd5Uoyu4YIwcEH8RWh2rx2mnZn0KaauhaKK
KBhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAlVrq
1hvbaS3uIxJFIMMp6EVZooE1c8F1uxGm6zd2a52RSkJk5O3qP0IqhXefEnTVintdQiiA84lJnA6s
ANufwB/KuDr3sPU9pTTPmMTS9nVcQooorYwCiiigDsPCPi9NJh/s/UN32UEmORVz5eTkggDJBJPq
f6eoWl3b31ss9rMksTdHQ5Brxzw54YvNfnJT91aIf3k7Dj6L6n+Xftn1zStPh0nTYbG3B8qIEAsc
kknJJ+pJNePjI0lK8d+p7uAlVcLS26GjRRRXGekFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBwfxKmC6PaQ5+Z7jd16gKf8RXmNekfEqzuJrWyu
owWhhLrJg9CcYOPwNeb17GCt7JWPnswv7V3CpILea5lEVvDJLIeiRqWP5Cr+g6Qdb1aKyEnlq2Wd
8Zwo64969e0vQrHR4XjsrcRhyC7bizNj1J/l05NPEYpUtLXYsLgpVvebsjiLf4Z3clsrz6hFFMes
YjLAf8CyOfwrb0z4e6dYgyXbNfSjoHG1B/wHPP4mu0FIfpXmyxNWSs2exDB0YO6iQwwxW8KxQxpH
GowqIoAA9gKsUUVgdQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQBGVDKVYAg9Qa5PxB4JstVElxar9nu9vylMBHPuP6119IfeqhOUHeLsZ
1KcaitJXOb8L+Go/D1m29hJdygea46cdAvGcV0frS0vSiUnN80txwhGEVGOyFoooqSwooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigD/2Q==