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_vac_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_vac_rate" # # # #
AddField layer_HI_complex_vac_rate sym "Double (64-bit floating point)" # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_vac_rate sym !vac_rate! "Python 3" # Text NO_ENFORCE_DOMAINS
AlterField layer_HI_complex_vac_rate sym # "Teacher Vacancies per 100 Students" "Double (64-bit floating point)" 8 NULLABLE DO_NOT_CLEAR
AddField layer_HI_complex_vac_rate type Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_vac_rate type "vac_rate" "Python 3" # Text NO_ENFORCE_DOMAINS
AddField layer_HI_complex_vac_rate type2 Text # # # # NULLABLE NON_REQUIRED #
CalculateField layer_HI_complex_vac_rate type2 "complex" "Python 3" # Text NO_ENFORCE_DOMAINS
20260108
10240000
20260108
10240000
FGDC CSDGM Metadata
150000000
5000
FGDC
Microsoft Windows 10 Version 10.0 (Build 22631) ; Esri ArcGIS 13.1.3.41833
layer_HI_complex_vac_rate_06172022
1
-160.250473
-154.732112
22.232969
18.893352
HI Teacher Shortages (updated 7/16/2024)
Updated 011426 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_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.
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/WuzC0IVE3J6nBi8RUpSSitD1r+17xwCJuMdgOfetLStQe6keOYguBu
UgYyO/8ASuO0W2mh0qFZ5JDIRnBP3R2FddoEQW3llOSzNgMfQf8A181nVjGKZ1U5OSTZt0UUVzmw
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFADa
ydeu7iy0S7uLSIyTonyKBnnpnHt1/CtejFNOzuTJNqyZxPh/wq8VzBrWpSzvqTZkZS3CkjGDxnOD
jHSu26CiinKbk7smnTUFZBWTqmhadrCoLy3EjICEcEhlz7itamn60k2ndFSipKzVzITw9boqKss2
1ePmYEkfXFa0cSQxrHGoVFGABT6WhtvcaSWwUUUUhhRRRQAUUUUAFFFc1q3icafdiGK3MqKR5khO
B7ge9OMXJ2RMpKKuzpaKhilWaJJUOVdQwPsampFBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU0jKkZIz3HanUUAcRe61fWWoz2c
jzyYbEZQYZgenH9RWfBLfXyMsWntLEwOG5C4zjqeP/1Guy1KyhdkvjFuntlJT/6/rjrWHbyXFsXk
iimdIwxARchcjk88V0RmuXRHO4Svq9CTwxNe291Npt2oVYk3oGbLDOOB6iurBB6HNcHfXTS+ROvn
JqITzDO5xs/2FHfr+vvit3w5PefZWgvbdonRsodmAQefz6/nWc4394qnK3unQ0UUVmbBRRRQAUUU
UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAV3hilKl41YocqSOVPt6VMI0U5CgGnUUAFFFVp4kngkhkBKSKVYAkHBGDyORQB5vefFuwst
ZurUWhurKIgRXNu/LnAzwe2cjOece9WV+L/h9reRhBepKqMUjkQYYgDAyCcZz19j7Z1v+FaeFBIJ
P7IBO7dgzyY/LdjHtS6h8OfDN/b+UdNS3I6SWx2MOMfQ/jmujmoO2jOPlxGuqI7T4k+Frm3EraiI
HEYd4pI3DKccr0wSOnGa19D8T6X4j87+y7rzvJOHBRlI9DggcH+hriW+DFh9qDLql0IO6FFL9f73
Tp7V2+h6Bp/hzT1tNOh2JwXZuXkbpuY9z+npipqqil7jbZdJ1m/fSSN2iqX26AX32MuBcbN4Q9xz
0/KrlYnQncWiiigYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR
RRQAUUUUAFFFFABRRRQAhrnvEcurQQC4sZkSBFzIAoLfXkEYroTVe5t0u7WWCTOyRSpx1waqLs7k
zV42OQ0fxdP9oWHUmVom480LgqffHGK7RxwDjODnFc5ZeErO1nSaWWSYoQQpwFz7+tdN2qqrg3eB
nRU1H3zhvFbXNnrdrqEIVQECxuD1IJJyP+BVi6/4x1OSHyYJFtd5/wCWQ+bbj+8en4Yr0qe2guCh
mjRyjbl3DODjH9a8f8W2n2TXblA67PMOxAMbQef611YXkqNRktjjxvPTg5Re5v8AgPWtY1DVpILi
d7m2EZd2l52HPGD756e3tXo4cHjofQ1414WvtZsLiWTSbJrpZCqyr5ZK8ZI5HTvXrdrJJNZwvcwi
OZ41Lx5ztYjkfhWWMhy1NLWNMBUcqVne/mXqKaoIUA9cc06uY7gooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAqhqN3La2vmQ20lzJkARx+
/c+1X6Q0LcT2Of0i41m4vZmv4TDblMom0DBz69en+RVfWfBlhrV6Lqaa4icj5hER83T1Bx0rpxSG
rU3F3joZulGUeWWvqZGi+H7XQrYwWzSspbezSNkk/hgfpWuFAHHFL2pccVLbbuy4xUVZbC0UUUig
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigDn/EmrXGlQQtbKu+RyCzDIAA/nVTSvF0N0/lXwjt2xxJu+Vj/AE/OtPXt
NOq6eYUbbKp3pnpkdj+dealSGw3UHoK66NOFSFupx1qk6c79D15WDKGUgqRkEd6kryy11jULSMRw
XUiIDkLwQPzrb07xjIrbL+IOpP8ArIxgj6jvUSw01tqXHFQe+h3FFZ9jqljqaFrS6jmwASqn5l+o
6itCuc6QooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigBKTpzS1geKbq7ttKLWhZSzhZGUcqpB/LnHNOMeZpEylypso+I9eFvALawmTznJEjx
tkoBxj2P8q4ocHHY9KWlVGkkREUsxPAFepTpqmrI8upUdSVxywyuu5I3YeoU0y5inht2fyZPTO08
V0tpCbe1SNjkjripqzlUbukbxoJWbOI0+PU7e7jmsknilB+V1Ugfj2x7GvWNG1GS9tUS6CLdquXC
dD7iueq3p9/HZXDu6s+VxhR3yK5JUlY61PU6yioLa4S6t0mQEK3Y9RU9YmgUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABUE9vFdQtDPGskbdVYZ
BqeigDxDWpLjTNYvLFW+WKVghIBO08j9CKz4dSu4LlLhJTvXpkcfTFdj8SdMWKa01GOJQJSUmcAc
sANufXgH8q4Ovcw7jUppnzmJ56VVq/oeh2Or2t3Yfanlji2rmQM4GzHXPtTrDWdO1PeLK7jmKfeC
nkfh+FeLajOZL2XbIWX7vHTHp+dQ21zNaXEdxbyNHJGcqynkGoeFTvZnTHGvS69T3B9Qt1iDtKTk
cIvWs+fVZXQrGoiXuQcmuHXxs8m57izUybesbYBb6dqzb/xRe3iGOILbxnrsOWP41MMO+pVTF9md
94f+KFlZXhsbwP8AYeSl0ASVbqcrjJB9ev8AT1OxvrTUrVLqznjngfO2SNsg+tfP3hDwPqPiqYSj
/RtPRvnuHB+b1CDuf0H6V71o+k22h6VBptmrLBCCFDMSSSSSSfckmuPFRpRfu79Tqwk6slea06Gp
RRRXIdwUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFAHB/EqYLo9pDn5nuN3XqAp/xFeR6tO0FphDhnO3PcCvTvivHdJp1pewReZFAWWQZ+6Wxgken
BrxOaeS4kLyMWY/pXsYL+FoeBj0/bNsYKntLK51C4W3s7eW4mbokSlj+lavhTw+/ifxBBpwkMaEF
5ZAMlUHX8eg59a9/0Xw1pXh+CSHTbQQCUgyNuLM5HTJJJx7dOT60YjFKlpa7HhsHKr7zdkeaW3wb
u5LJJLnVooblsExLCXVfbdkZOMdvbnrXT+H/AIVaPpJ82/P9pT9vNTbGv/AMnP4k16DRXnSxNWSs
2erDCUou6RHFFHDGscSKiKMBVGAKloorA6QooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigBhAIwRmuH8VfDzStdS4uLaIWupFPkePhWI6bl6
c9M13VJVQnKDvFkThGatJXOR8FeEE8KabsZ1lvJwDcSL93IzgLnnAz+PXiuuFFLSlJybbHCChFRj
sLRRRSKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/9k=