20210304
09082300
1.0
FALSE
CO_districts
002
file://\\INFDEALC\C$\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\CO_03032021\CO_03032021.gdb
Local Area Network
Geographic
GCS_North_American_1983
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' 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.4.0'><WKT>GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4269]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>1111948722.2222221</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.9831528411952133e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4269</WKID><LatestWKID>4269</LatestWKID></GeographicCoordinateSystem>
Select "Z:\GIS Methods Group\Colorado Teacher Shortages\CO_2021\District and School Datafiles\district_shapefile\tl_2019_08_unsd.shp" "C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\CO_03032021\CO_03032021.gdb\TEMP" #
AddField TEMP ID_NEW "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateField TEMP ID_NEW !GEOID! "Python 3" #
JoinField TEMP ID_NEW tab4Data nces_id #
AddField TEMP X "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateField TEMP X !SHAPE.CENTROID.X! "Python 3" #
AddField TEMP Y "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateField TEMP Y !SHAPE.CENTROID.Y! "Python 3" #
FeatureClassToFeatureClass TEMP "C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\CO_03032021\CO_03032021.gdb" CO_districts # "STATEFP "STATEFP" true true false 2 Text 0 0,First,#,TEMP,STATEFP,0,2;UNSDLEA "UNSDLEA" true true false 5 Text 0 0,First,#,TEMP,UNSDLEA,0,5;GEOID "GEOID" true true false 7 Text 0 0,First,#,TEMP,GEOID,0,7;NAME "NAME" true true false 100 Text 0 0,First,#,TEMP,NAME,0,100;LSAD "LSAD" true true false 2 Text 0 0,First,#,TEMP,LSAD,0,2;LOGRADE "LOGRADE" true true false 2 Text 0 0,First,#,TEMP,LOGRADE,0,2;HIGRADE "HIGRADE" true true false 2 Text 0 0,First,#,TEMP,HIGRADE,0,2;MTFCC "MTFCC" true true false 5 Text 0 0,First,#,TEMP,MTFCC,0,5;SDTYP "SDTYP" true true false 1 Text 0 0,First,#,TEMP,SDTYP,0,1;FUNCSTAT "FUNCSTAT" true true false 1 Text 0 0,First,#,TEMP,FUNCSTAT,0,1;ALAND "ALAND" true true false 8 Double 0 0,First,#,TEMP,ALAND,-1,-1;AWATER "AWATER" true true false 8 Double 0 0,First,#,TEMP,AWATER,-1,-1;INTPTLAT "INTPTLAT" true true false 11 Text 0 0,First,#,TEMP,INTPTLAT,0,11;INTPTLON "INTPTLON" true true false 12 Text 0 0,First,#,TEMP,INTPTLON,0,12;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,TEMP,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,TEMP,Shape_Area,-1,-1;ID_NEW "ID_NEW" true true false 8 Double 0 0,First,#,TEMP,ID_NEW,-1,-1;Field1 "Field1" true true false 4 Long 0 0,First,#,TEMP,Field1,-1,-1;nces_id "nces_id" true true false 4 Long 0 0,First,#,TEMP,nces_id,-1,-1;districtName "districtName" true true false 8000 Text 0 0,First,#,TEMP,districtName,0,8000;districtID "districtID" true true false 4 Long 0 0,First,#,TEMP,districtID,-1,-1;stipends "stipends" true true false 8 Double 0 0,First,#,TEMP,stipends,-1,-1;grants "grants" true true false 8 Double 0 0,First,#,TEMP,grants,-1,-1;percTeacherTurnover "percTeacherTurnover" true true false 8 Double 0 0,First,#,TEMP,percTeacherTurnover,-1,-1;percUnfilled "percUnfilled" true true false 8 Double 0 0,First,#,TEMP,percUnfilled,-1,-1;turn_slide "turn_slide" true true false 8 Double 0 0,First,#,TEMP,turn_slide,-1,-1;unfill_slide "unfill_slide" true true false 8 Double 0 0,First,#,TEMP,unfill_slide,-1,-1;turn_pop "turn_pop" true true false 8 Double 0 0,First,#,TEMP,turn_pop,-1,-1;unfill_pop "unfill_pop" true true false 8 Double 0 0,First,#,TEMP,unfill_pop,-1,-1;stipends_pop "stipends_pop" true true false 8000 Text 0 0,First,#,TEMP,stipends_pop,0,8000;grants_pop "grants_pop" true true false 8000 Text 0 0,First,#,TEMP,grants_pop,0,8000;X "X" true true false 8 Double 0 0,First,#,TEMP,X,-1,-1;Y "Y" true true false 8 Double 0 0,First,#,TEMP,Y,-1,-1" #
20210304
10053500
20210304
10053500
Microsoft Windows 10 Version 10.0 (Build 18363) ; Esri ArcGIS 12.4.0.19948
CO_districts
CO
CO school district boundaries
File Geodatabase Feature Class
dataset
EPSG
6.12(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
CO_districts
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.
STATEFP
STATEFP
String
2
0
0
UNSDLEA
UNSDLEA
String
5
0
0
GEOID
GEOID
String
7
0
0
NAME
NAME
String
100
0
0
LSAD
LSAD
String
2
0
0
LOGRADE
LOGRADE
String
2
0
0
HIGRADE
HIGRADE
String
2
0
0
MTFCC
MTFCC
String
5
0
0
SDTYP
SDTYP
String
1
0
0
FUNCSTAT
FUNCSTAT
String
1
0
0
ALAND
ALAND
Double
8
0
0
AWATER
AWATER
Double
8
0
0
INTPTLAT
INTPTLAT
String
11
0
0
INTPTLON
INTPTLON
String
12
0
0
ID_NEW
ID_NEW
Double
8
0
0
Field1
Field1
Integer
4
0
0
nces_id
nces_id
Integer
4
0
0
districtName
districtName
String
8000
0
0
districtID
districtID
Integer
4
0
0
stipends
stipends
Double
8
0
0
grants
grants
Double
8
0
0
percTeacherTurnover
percTeacherTurnover
Double
8
0
0
percUnfilled
percUnfilled
Double
8
0
0
turn_slide
turn_slide
Double
8
0
0
unfill_slide
unfill_slide
Double
8
0
0
turn_pop
turn_pop
Double
8
0
0
unfill_pop
unfill_pop
Double
8
0
0
stipends_pop
stipends_pop
String
8000
0
0
grants_pop
grants_pop
String
8000
0
0
X
X
Double
8
0
0
Y
Y
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.
20210304