20191121
17061100
1.0
FALSE
Students_Aggregated_to_Road_Segments_Merge
002
file://\\RYWILLIA-PC\C$\Users\labuser\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb
Local Area Network
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_UTM_Zone_16N
<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/2.2.0'><WKT>PROJCS["WGS_1984_UTM_Zone_16N",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-87.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",32616]]</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>32616</WKID><LatestWKID>32616</LatestWKID></ProjectedCoordinateSystem>
SpatialJoin ElemStudentsGeocodedtoStreetSegments MiddleStudentsGeocodedtoStreetSegments C:\Users\labuser\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\Students_Aggregated_to_Road_Segments_Join "Join one to one" KEEP_ALL "roads_obje "Roads_OBJECTID" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,school,-1,-1;roads_lrs_ "LRS_LINK" true true false 80 Text 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,roads_lrs_,0,80;roads_shap "Shape" true true false 0 Double 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,roads_shap,-1,-1;elemtostre "Elem_OBJECTID" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtostre,-1,-1;elemtost_1 "Join_Count" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_1,-1,-1;elemtost_2 "TARGET_FID" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_2,-1,-1;elemtost_3 "objectid" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_3,-1,-1;elemtost_4 "resultid" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_4,-1,-1;elemtost_5 "user_grade" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_5,-1,-1;elemtost_6 "user_address" true true false 254 Text 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_6,0,254;elemtost_7 "user_city" true true false 254 Text 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_7,0,254;elemtost_8 "user_zip" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_8,-1,-1;elemtost_9 "Student_ID" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtost_9,-1,-1;elemtos_10 "LRS_LINK" true true false 80 Text 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtos_10,0,80;elemtos_11 "OBJECTID1" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtos_11,-1,-1;elemtos_12 "Frequency" true true false 0 Long 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,elemtos_12,-1,-1;school "School" true true false 255 Text 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,school,0,255;school_ "School" true true false 256 Text 0 0,First,#,ElemStudentsGeocodedtoStreetSegments,school_,0,256;roads_obje_1 "roads_obje" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,roads_obje,-1,-1;roads_lrs1 "roads_lrs_" true true false 80 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,roads_lrs_,0,80;middletost "MiddletoSt" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middletost,-1,-1;middleto_1 "Middleto_1" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middleto_1,-1,-1;middleto_2 "Middleto_2" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middleto_2,-1,-1;middleto_3 "Middleto_3" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middleto_3,-1,-1;middleto_4 "Middleto_4" true true false 100 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middleto_4,0,100;middleto_5 "Middleto_5" true true false 50 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middleto_5,0,50;middleto_8 "Middleto_8" true true false 254 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middleto_8,0,254;middlet_10 "Middlet_10" true true false 254 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middlet_10,0,254;middlet_11 "Middlet_11" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middlet_11,-1,-1;middlet_13 "Middlet_13" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middlet_13,-1,-1;middlet_15 "Middlet_15" true true false 0 Long 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,middlet_15,-1,-1;school_1 "School" true true false 255 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,school,0,255;school1 "School" true true false 256 Text 0 0,First,#,MiddleStudentsGeocodedtoStreetSegments,school_,0,256" Intersect # #
DeleteField Students_Aggregated_to_Road_Segments_Join school_1
CalculateField Students_Aggregated_to_Road_Segments_Join school1 'Elementary' "Python 3" #
CalculateField Students_Aggregated_to_Road_Segments_Join school1 'Elementary and Middle' "Python 3" #
Merge Students_Aggregated_to_Road_Segments_Join;MiddleStudentsGeocodedtoStreetSegments C:\Users\labuser\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\Students_Aggregated_to_Road_Segments_Merge "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,TARGET_FID,-1,-1;roads_obje "Roads_OBJECTID" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,roads_obje,-1,-1,MiddleStudentsGeocodedtoStreetSegments,roads_obje,-1,-1;roads_lrs_ "LRS_LINK" true true false 80 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,roads_lrs_,0,80,MiddleStudentsGeocodedtoStreetSegments,roads_lrs_,0,80;roads_shap "Shape" true true false 8 Double 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,roads_shap,-1,-1;elemtostre "Elem_OBJECTID" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtostre,-1,-1;elemtost_1 "Join_Count" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_1,-1,-1;elemtost_2 "TARGET_FID" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_2,-1,-1;elemtost_3 "objectid" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_3,-1,-1;elemtost_4 "resultid" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_4,-1,-1;elemtost_5 "user_grade" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_5,-1,-1;elemtost_6 "user_address" true true false 254 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_6,0,254;elemtost_7 "user_city" true true false 254 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_7,0,254;elemtost_8 "user_zip" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_8,-1,-1;elemtost_9 "Student_ID" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtost_9,-1,-1;elemtos_10 "LRS_LINK" true true false 80 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtos_10,0,80;elemtos_11 "OBJECTID1" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtos_11,-1,-1;elemtos_12 "Frequency" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,elemtos_12,-1,-1;school "School" true true false 255 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,school,0,255,MiddleStudentsGeocodedtoStreetSegments,school,0,255;school_ "School" true true false 256 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,school_,0,256,MiddleStudentsGeocodedtoStreetSegments,school_,0,256;roads_obje_1 "roads_obje" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,roads_obje_1,-1,-1;roads_lrs1 "roads_lrs_" true true false 80 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,roads_lrs1,0,80;middletost "MiddletoSt" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middletost,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middletost,-1,-1;middleto_1 "Middleto_1" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middleto_1,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middleto_1,-1,-1;middleto_2 "Middleto_2" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middleto_2,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middleto_2,-1,-1;middleto_3 "Middleto_3" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middleto_3,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middleto_3,-1,-1;middleto_4 "Middleto_4" true true false 100 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middleto_4,0,100,MiddleStudentsGeocodedtoStreetSegments,middleto_4,0,100;middleto_5 "Middleto_5" true true false 50 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middleto_5,0,50,MiddleStudentsGeocodedtoStreetSegments,middleto_5,0,50;middleto_8 "Middleto_8" true true false 254 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middleto_8,0,254,MiddleStudentsGeocodedtoStreetSegments,middleto_8,0,254;middlet_10 "Middlet_10" true true false 254 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middlet_10,0,254,MiddleStudentsGeocodedtoStreetSegments,middlet_10,0,254;middlet_11 "Middlet_11" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middlet_11,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middlet_11,-1,-1;middlet_13 "Middlet_13" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middlet_13,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middlet_13,-1,-1;middlet_15 "Middlet_15" true true false 4 Long 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,middlet_15,-1,-1,MiddleStudentsGeocodedtoStreetSegments,middlet_15,-1,-1;school1 "School" true true false 256 Text 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,school1,0,256;shape_Length "shape_Length" false true true 8 Double 0 0,First,#,Students_Aggregated_to_Road_Segments_Join,shape_Length,-1,-1"
CalculateField Students_Aggregated_to_Road_Segments_Merge school1 'Middle' "Python 3" #
CalculateField Students_Aggregated_to_Road_Segments_Merge elemtost_5 !middleto_8! "Python 3" #
CalculateField Students_Aggregated_to_Road_Segments_Merge elemtost_6 !middleto_4! "Python 3" #
CalculateField Students_Aggregated_to_Road_Segments_Merge elemtost_7 !middleto_5! "Python 3" #
DeleteField Students_Aggregated_to_Road_Segments_Merge elemtost_1
DeleteField Students_Aggregated_to_Road_Segments_Merge elemtost_2
DeleteField Students_Aggregated_to_Road_Segments_Merge school
DeleteField Students_Aggregated_to_Road_Segments_Merge school_
DeleteField Students_Aggregated_to_Road_Segments_Merge middleto_4
DeleteField Students_Aggregated_to_Road_Segments_Merge middleto_5
DeleteField Students_Aggregated_to_Road_Segments_Merge middlet_11;middlet_13;middlet_15
Rename C:\Users\labuser\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\Students_Aggregated_to_Road_Segments_Merge C:\Users\labuser\Documents\ArcGIS\Projects\MyProject5\MyProject5.gdb\Students_Aggregated_to_Road_Segments FeatureClass
20191121
17244100
20191121
17244100
Microsoft Windows 10 Version 10.0 (Build 17134) ; Esri ArcGIS 12.2.0.12813
Students Aggregated to Road Segments
Roads
SRTS
Aggergated
This layer shows both the middle and elementry school studetns agergated to the road segments.
File Geodatabase Feature Class
dataset
EPSG
2.1(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
Students_Aggregated_to_Road_Segments_Merge
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.
Join_Count
Join_Count
Integer
4
0
0
TARGET_FID
TARGET_FID
Integer
4
0
0
roads_obje
Roads_OBJECTID
Integer
4
0
0
roads_lrs_
LRS_LINK
String
80
0
0
roads_shap
Shape
Double
8
0
0
elemtostre
Elem_OBJECTID
Integer
4
0
0
elemtost_1
Join_Count
Integer
4
0
0
elemtost_2
TARGET_FID
Integer
4
0
0
elemtost_3
objectid
Integer
4
0
0
elemtost_4
resultid
Integer
4
0
0
elemtost_5
user_grade
Integer
4
0
0
elemtost_6
user_address
String
254
0
0
elemtost_7
user_city
String
254
0
0
elemtost_8
user_zip
Integer
4
0
0
elemtost_9
Student_ID
Integer
4
0
0
elemtos_10
LRS_LINK
String
80
0
0
elemtos_11
OBJECTID1
Integer
4
0
0
elemtos_12
Frequency
Integer
4
0
0
school
School
String
255
0
0
school_
School
String
256
0
0
roads_obje_1
roads_obje
Integer
4
0
0
roads_lrs1
roads_lrs_
String
80
0
0
middletost
MiddletoSt
Integer
4
0
0
middleto_1
Middleto_1
Integer
4
0
0
middleto_2
Middleto_2
Integer
4
0
0
middleto_3
Middleto_3
Integer
4
0
0
middleto_4
Middleto_4
String
100
0
0
middleto_5
Middleto_5
String
50
0
0
middleto_8
Middleto_8
String
254
0
0
middlet_10
Middlet_10
String
254
0
0
middlet_11
Middlet_11
Integer
4
0
0
middlet_13
Middlet_13
Integer
4
0
0
middlet_15
Middlet_15
Integer
4
0
0
school1
School
String
256
0
0
shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
20191121