20220429
15242800
1.0
FALSE
layer_HI_island_ret_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_ret_rate" # # # #
AddField layer_HI_island_ret_rate sym "Double (64-bit floating point)" # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_island_ret_rate sym !ret_rate! "Python 3" # Text NO_ENFORCE_DOMAINS
AlterField layer_HI_island_ret_rate sym # "Teacher Retention Rate per 100 Students" "Double (64-bit floating point)" 8 NULLABLE DO_NOT_CLEAR
AddField layer_HI_island_ret_rate type Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_island_ret_rate type "ret_rate" "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_island_ret_rate type2 Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_island_ret_rate type2 "island" "Python 3" # Text NO_ENFORCE_DOMAINS
20260108
10142300
20260108
10142300
Microsoft Windows 10 Version 10.0 (Build 22631) ; Esri ArcGIS 13.1.3.41833
layer_HI_island_ret_rate_06172022
HITS
HI Teacher Shortages (updated 7/16/2022)
Updated 011526 CDeal
File Geodatabase Feature Class
0.000
dataset
0
Simple
FALSE
0
TRUE
FALSE
layer_HI_island_ret_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
CiiigAooooAKKKKACiiigAooooAKKzb7VYbCW3idXeSd9ipGMt9celaNFmJNMCQoJPQU35m/2R+t
D9QcEgdhTgwboc0DG7D/AH2pBkNtJyCOM1JUanc7H04FAElFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZurTy22l3E0CFpVT5QBnB6Z/D
rWjR1oTsxNXRy+i6CySw6peTStdt85XPAz6/hXU0UlOUnJ3YoxUVZC00qCc5IPqKdRSKGYb+9x9O
acAFGB0paKACiiigAooooAKKKKACkpaxbzWFt7jyo0DhT87Z/MCmk3sJuxtUUxHWRFdTlWGRT6Qw
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKaRkEZx7inUUAcveXd5DPJAbmQqCRyACRVCui1izE9uZlzviGeB1FYUUDy5IRyoGcqu
R0zXRCStcyknc1NEuZWdrdiCiqWGeo6cfSt0EHpXGKZIJFcbkccg4ra0a7UxfZ3ZVYH5BjGe5qKk
PtIqMuhtUUUVkWFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAFFFFABRRRQAUUUUAFFFFABRRRQBDPbQ3KhZow4HTNJHawRPvjiRGxtyBjip6KLgFFFV5olnheJ
87XUqcEg4PuORQB5tefFvTrLW7q0FrJcWUR2x3Vu+S5wM8HHGcjOecZHWra/F3w89rLJ5V2kyqxS
KSMfOQOBkEgZ6VqL8MvCKsGGlZIOebiUj/0KjUPhx4Zvrfyhpq27DpJbsVYcfkfxrovQdtGcfLiN
XdDofiF4YktUuW1WKPKbmjYNvU9xjGc8f5yK09E8TaT4hWY6Vdi48ogONjKRnpwwBx/ga4g/BbT/
ADxjV7nyMcqY13fn09e1dvoegaf4c09bTTodiDBdm5eRum5j3P6emKmoqKXuNtl0nWcvfSSN2imB
uQCCCemafWJ0hRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAlcl4wuNdtLYXOkyxpBGhaXCBn+vIIxj+Vdb3qne2kd5Yz2kufLmjMb
bTg4IxxVQkoyTauZ1YuUGk7HAeH/AB/M94sGreX5MmAJkXbsPv7fyr0c8gHHQ5rj9O+HunWN1HcT
TTXJjIZUfCrkdyB1+ldljjFaV3Tcr00Y4aNWMbVGKQHXg/Qik2k/eb8BxQY1JyR9fehOmPQkVidQ
bSvIJ+hNKHBOOh9DTqY5XGCM+1AD6KaoIUA9cc06gAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigArO1S+ksbQywWU13JuCrFEOcnufQe9a
NFAHLaHe6/eajcnVLY29tszHH5eADn+916f5FdLtI+62M+oqSigBuzP3iTShQvQYpaKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigDM1W8ks4o/KA3MepGcAVBZ62kjbLkLGccODwT/SrWpWn2u1KqcOp3L7n0rm
K2hFSiRJtM7UEEAggg9xRXJQ3tzbqFimZVBzjqK0LbXZFOLlAy/3k4P5VLpyQ1NG/RVa3u4bpcwy
BsdR3H1FWazKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACikrN1eaaG0zESuWwzDsKaV3YTdiDU9S8uMQwOC7feZTnaPT61hUUV1Rioqx
k3cKKKKYh0cjxSB42KuOhFdFpmoi8Qo+BMo5HqPWubq7p15HZTvJIrMCm0BfqKipG6Ki7M6qioLa
4S6gWVAQrdj1qeuY1CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKjliSaJo5F3I3UVJRQBxtzF5FzLF2RiBn07VFWtrtuEmjnVcb+GPuP8A638q
ya64u6uYtWYUUUUxBRRRQBp6bqYtB5M2TF2IH3a34po54xJEwZT3FcvZWct45CfKi/ec9B7fWult
rdLWBIo87V9eprCoop6GkbliiiisiwooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKAMXxA4EEKdy5b8h/9esKtvXonIhlAyi5B9iaxK6aXwmUtwpVV
mOFUsfQDJqa1tjdXKRBtu7qcdBXS2tlBZqREmCerE5JonNRBRuZEegzsgZ5UVj/DjOPxq5baHDEd
0zGU+nQVq0Vi5yZaihiIkaBEUKo6ADAqSiioKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAGEAjBAIPY1mXekxThpIR5cmOAuNpNatFNNr
YGrmdptgLKMljulb7xHQewrRopaG23diSsFFFFIYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB
/9k=