20230312 23025500 FALSE 20231117 13085300 SCHOOL_PRIORITY 6157301.040000 6547663.788500 1780000.571750 2095276.920000 1 file://\\COSD35842\C$\Users\jsustait\AppData\Local\Temp\ArcGISProTemp16440\aa0a49e9-21b9-44be-8a33-196334cb86d8\Default.gdb Local Area Network 0.029 002 Projected GCS_North_American_1983 NAD_1983_StatePlane_California_VI_FIPS_0406_Feet <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.9.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_California_VI_FIPS_0406_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,6561666.666666666],PARAMETER[&quot;False_Northing&quot;,1640416.666666667],PARAMETER[&quot;Central_Meridian&quot;,-116.25],PARAMETER[&quot;Standard_Parallel_1&quot;,32.78333333333333],PARAMETER[&quot;Standard_Parallel_2&quot;,33.88333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,32.16666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2230]]</WKT><XOrigin>-118608900</XOrigin><YOrigin>-91259500</YOrigin><XYScale>4000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.002</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102646</WKID><LatestWKID>2230</LatestWKID></ProjectedCoordinateSystem> Linear Unit: Foot_US (0.304801) FeatureClassToFeatureClass \\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp \\PALA\home\share\Review\SCHOOL.gdb SCHOOL # "CDSCode "CDSCode" true true false 14 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,CDSCode,-1,-1;District "District" true true false 90 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,District,-1,-1;School "School" true true false 90 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,School,-1,-1;Street "Street" true true false 201 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,Street,-1,-1;City "City" true true false 25 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,City,-1,-1;ZIP "ZIP" true true false 10 Double 0 10 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,ZIP,-1,-1;OpenDate "OpenDate" true true false 8 Date 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,OpenDate,-1,-1;Charter "Charter" true true false 1 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,Charter,-1,-1;DOCType "DOCType" true true false 50 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,DOCType,-1,-1;SOCType "SOCType" true true false 50 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,SOCType,-1,-1;GSoffered "GSoffered" true true false 8 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,GSoffered,-1,-1;ShortName "ShortName" true true false 20 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,ShortName,-1,-1;ID "ID" true true false 10 Double 0 10 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,ID,-1,-1;Priv "Priv" true true false 1 Text 0 0 ,First,#,\\PALA\home\share\Louise\Ad_Hoc_Updates\2016\February\Schools\Schools.shp,Priv,-1,-1" # FeatureClassToFeatureClass \\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL \\gaskill\data\DIVA_Data\PUBLIC_Data\Shapefiles_02-10-2016\ SCHOOL.shp # "CDSCODE "CDSCODE" true true false 14 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,CDSCODE,-1,-1;DISTRICT "DISTRICT" true true false 90 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,DISTRICT,-1,-1;SCHOOL "SCHOOL" true true false 90 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,SCHOOL,-1,-1;STREET "STREET" true true false 201 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,STREET,-1,-1;CITY "CITY" true true false 25 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,CITY,-1,-1;ZIP "ZIP" true true false 8 Double 8 38 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,ZIP,-1,-1;OPENDATE "OPENDATE" true true false 36 Date 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,OPENDATE,-1,-1;CHARTER "CHARTER" true true false 1 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,CHARTER,-1,-1;DOCTYPE "DOCTYPE" true true false 50 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,DOCTYPE,-1,-1;SOCTYPE "SOCTYPE" true true false 50 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,SOCTYPE,-1,-1;GSOFFERED "GSOFFERED" true true false 8 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,GSOFFERED,-1,-1;SHORTNAME "SHORTNAME" true true false 20 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,SHORTNAME,-1,-1;ID "ID" true true false 8 Double 8 38 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,ID,-1,-1;PRIV "PRIV" true true false 1 Text 0 0 ,First,#,\\gaskill\SanGIS_apps\DIVA\DIVA_Exports\PUBLIC_Process\PUBS@Reception@default.sde\SANGIS.SCHOOL,PRIV,-1,-1" # RepairGeometry \\gaskill\data\DIVA_Data\PUBLIC_Data\Shapefiles_02-10-2016\\SCHOOL.shp DELETE_NULL FeatureClassToFeatureClass M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp "Database Connections\sql2014b8.gis.SPACECORE.sde\SPACECORE.GIS.Spacecore" School # "schoolID "schoolID" true true false 10 Long 0 10 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,schoolID,-1,-1;cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,priv,-1,-1;regionID "regionID" true true false 5 Long 0 5 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,regionID,-1,-1;Check_ "Check_" true true false 5 Long 0 5 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,Check_,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,ClosedDate,-1,-1;Phantom "Phantom" true true false 5 Long 0 5 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,M:\TEMP\RRI\Schools\SchoolsSPACECORE\School.shp,Notes,-1,-1" GEOMETRY CalculateField SPACECORE.GIS.School CheckCheck [Check_] VB # CalculateField SPACECORE.GIS.School Check_ [CheckCheck] VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Notes "Coincident with additional school point(s)" VB # CalculateField SPACECORE.GIS.School Check_ 0 VB # CalculateField SPACECORE.GIS.School priv "N" VB # CalculateField SPACECORE.GIS.School Notes "" VB # CalculateField SPACECORE.GIS.School Phantom 0 VB # CalculateField SPACECORE.GIS.School priv "N" VB # CalculateField SPACECORE.GIS.School shrtName Left( [name], 20 ) VB # CalculateField SPACECORE.GIS.School docType "Elementary School District" VB # CalculateField SPACECORE.GIS.School docType "Elementary School District" VB # CalculateField SPACECORE.GIS.School docType "Elementary School District" VB # CalculateField SPACECORE.GIS.School docType "Elementary School District" VB # CalculateField SPACECORE.GIS.School docType "Elementary School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "High School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "Elementary School District" VB # CalculateField SPACECORE.GIS.School docType "High School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School docType "Unified School District" VB # CalculateField SPACECORE.GIS.School charter "N" VB # CalculateField SPACECORE.GIS.School Check_ 0 VB # CalculateField SPACECORE.GIS.School Check_ 0 VB # CalculateField "SPACECORE.GIS.School - all" schoolID Right( [cdsCode],7 ) VB # CalculateField "SPACECORE.GIS.School - all" schoolID "131947 + (Right( [OBJECTID],2 ))" VB # CalculateField SPACECORE.GIS.School regionID 0 VB # CalculateField "All Schools\Schools - Public - new" schoolID -1 VB # CalculateField "All Schools\Schools - Public - new" schoolID -2 VB # CalculateField "All Schools\Schools - Public - new" priv "Y" VB # CalculateField "All Schools\Schools - Public - new" Check_ 0 VB # CalculateField "Schools - Private - closed" Phantom 0 VB # CalculateField SPACECORE.GIS.School Phantom 0 VB # CalculateField SPACECORE.GIS.School Phantom 1 VB # CalculateField SPACECORE.GIS.School Phantom 1 VB # CalculateField SPACECORE.GIS.School regionID 0 VB # CalculateField SPACECORE.GIS.School Notes "" VB # CalculateField SPACECORE.GIS.School Notes "" VB # CalculateField "Schools - Public - new" zip 92069 VB # CalculateField "Schools - Public - new" ClosedDate 6/28/2013 VB # CalculateField "Schools - Public - new" ClosedDate "6/28/2013" VB # CalculateField "Schools - Public - new" zip 92027 VB # CalculateField "Schools - Everything" city "No Data" VB # CalculateField "Schools - Public - new" Phantom 0 VB # CalculateField "Schools - Not on a building" Check_ 6 VB # CalculateField SPACECORE.GIS.School regionID 0 VB # CalculateField SPACECORE.GIS.School regionID 2 VB # CalculateField "Schools - Everything - Public" Notes "RRI. Closed" VB # CalculateField "Schools - Everything - Public" Notes "" VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 66 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Phantom 1 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Phantom 1 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 0 VB # CalculateField "Schools - Fix" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools\Schools - Everything" Check_ 6 VB # CalculateField "Schools - Fix" Check_ 6 VB # CalculateField "Schools - Fix" Check_ 6 VB # CalculateField "Schools - Everything" Check_ 66 VB # Append K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019 K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2019 NO_TEST "schoolID "schoolID" true true false 4 Long 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,schoolID,-1,-1;cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2019\Schools.gdb\Schools_2018_the292MissingFrom2019,regionID,-1,-1;schoolID_2 "schoolID_2" true true false 4 Long 0 0 ,First,#" # CalculateField Schools2020_preEdit Check_ 0 VB # CalculateField Schools2020_preEdit Change 0 VB # CalculateField Schools2020_preEdit socType "Private" VB # CalculateField Schools2020_preEdit charter "N" VB # CalculateField Schools2020_preEdit Check_ 5 VB # CalculateField School_PreEdits cdeCodeD [cdsCode] VB # CalculateField School_PreEdits cdeCodeD [cdsCode] VB # CalculateField School_PreEdits cdeCodeNUM [cdsCode] VB # Append 'Geocoding Result: Schools_PreEdits_Relocated_Existing_' Schools_PreEdits NO_TEST "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,District_1,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Newaddr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Newcity,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Newzipcode,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,OpenDate_1,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Charter_1,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,DOCType_1,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,SOCType_1,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#;Phantom "Phantom" true true false 4 Long 0 0 ,First,#;Notes "Notes" true true false 254 Text 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,Geocoding Result: Schools_PreEdits_Relocated_Existing_,cdeCodeNUM,-1,-1" # CalculateField Schools_PreEdits Notes "" VB # CalculateField Schools_PreEdits Check_ 10 VB # CalculateField Schools_PreEdits Check_ 10 VB # CalculateField Schools_PreEdits Check_ 10 VB # Append DUPS_toDelete Schools_PreEdits NO_TEST "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,DUPS_toDelete,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,DUPS_toDelete,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,DUPS_toDelete,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,DUPS_toDelete,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,DUPS_toDelete,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,DUPS_toDelete,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,DUPS_toDelete,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,DUPS_toDelete,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,DUPS_toDelete,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,DUPS_toDelete,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,DUPS_toDelete,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,DUPS_toDelete,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,DUPS_toDelete,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,DUPS_toDelete,cdeCodeNUM,-1,-1" # Append DUPS_toDelete Schools_PreEdits NO_TEST "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,DUPS_toDelete,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,DUPS_toDelete,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,DUPS_toDelete,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,DUPS_toDelete,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,DUPS_toDelete,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,DUPS_toDelete,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,DUPS_toDelete,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,DUPS_toDelete,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,DUPS_toDelete,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,DUPS_toDelete,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,DUPS_toDelete,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,DUPS_toDelete,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,DUPS_toDelete,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,DUPS_toDelete,cdeCodeNUM,-1,-1" # Append DUPS_toDelete Schools_PreEdits NO_TEST "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,DUPS_toDelete,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,DUPS_toDelete,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,DUPS_toDelete,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,DUPS_toDelete,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,DUPS_toDelete,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,DUPS_toDelete,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,DUPS_toDelete,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,DUPS_toDelete,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,DUPS_toDelete,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,DUPS_toDelete,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,DUPS_toDelete,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,DUPS_toDelete,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,DUPS_toDelete,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,DUPS_toDelete,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,DUPS_toDelete,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,DUPS_toDelete,cdeCodeNUM,-1,-1" # Append Schools_NEWPUBL Schools_PreEdits NO_TEST "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,Schools_NEWPUBL,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,Schools_NEWPUBL,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,Schools_NEWPUBL,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,Schools_NEWPUBL,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,Schools_NEWPUBL,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,Schools_NEWPUBL,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,Schools_NEWPUBL,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,Schools_NEWPUBL,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,Schools_NEWPUBL,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,Schools_NEWPUBL,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,Schools_NEWPUBL,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,Schools_NEWPUBL,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,Schools_NEWPUBL,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,Schools_NEWPUBL,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,Schools_NEWPUBL,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,Schools_NEWPUBL,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,Schools_NEWPUBL,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,Schools_NEWPUBL,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,Schools_NEWPUBL,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,Schools_NEWPUBL,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,Schools_NEWPUBL,cdsCode,-1,-1" # Append Schools_NEWPRIV Schools_PreEdits NO_TEST "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,Schools_NEWPRIV,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,Schools_NEWPRIV,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,Schools_NEWPRIV,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,Schools_NEWPRIV,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,Schools_NEWPRIV,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,Schools_NEWPRIV,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,Schools_NEWPRIV,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,Schools_NEWPRIV,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,Schools_NEWPRIV,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,Schools_NEWPRIV,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,Schools_NEWPRIV,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,Schools_NEWPRIV,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,Schools_NEWPRIV,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,Schools_NEWPRIV,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,Schools_NEWPRIV,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,Schools_NEWPRIV,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,Schools_NEWPRIV,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,Schools_NEWPRIV,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,Schools_NEWPRIV,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,Schools_NEWPRIV,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,Schools_NEWPRIV,cdsCode,-1,-1" # CalculateField Schools_PreEdits regionID 0 VB # CalculateField Schools_PreEdits Change 0 VB # CalculateField Schools_PreEdits Check_ 0 VB # CalculateField Schools_PreEdits Check_ 0 VB # CalculateField Schools_PreEdits regionID 0 VB # CalculateField Schools_PreEdits Change 0 VB # CalculateField Schools_PreEdits Check_ "10" VB # CalculateField Schools_PreEdits Notes "PHO: No longer exists on CA DOE website" VB # FeatureClassToFeatureClass K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021 K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb Schools2021_041522 # "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021,cdeCodeNUM,-1,-1" # CalculateField Schools2021_041522 Notes [Notes]&". PHO: Assigned new schoolID to prevent duplicate" VB # FeatureClassToFeatureClass K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522 K:\box1\gis\Schools\Schools2021\Schools2021.gdb Schools2021 # "cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,cdsCode,-1,-1;district "district" true true false 90 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,district,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,name,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,addr,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,city,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,zip,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,openDate,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,charter,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,docType,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,socType,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,gsOffered,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,shrtName,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,priv,-1,-1;ClosedDate "ClosedDate" true true false 8 Date 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,Notes,-1,-1;Check_ "Check_" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0 ,First,#,K:\box1\gis\Schools\Schools2021\Schools2021\Schools2021.gdb\Schools2021_041522,cdeCodeNUM,-1,-1" # CopyMultiple "\\nasa8\ts\box1\gis\Schools\Schools2021\Schools2021.gdb\Schools2021 FeatureClass" \\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb Schools2021 "Schools2021 FeatureClass Schools2021 #" Rename \\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb\Schools2021 \\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb\Schools_preEdits FeatureClass Append publicschoolsSD_newSchools_Geocoded;privateschools_newSchools_Geocoded Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_CDSCode,-1,-1,privateschools_newSchools_Geocoded,USER_CDS_Code,-1,-1;district "district" true true false 90 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_District,0,255,privateschools_newSchools_Geocoded,USER_Public_District,0,8000;name "name" true true false 90 Text 0 0,First,#,privateschools_newSchools_Geocoded,USER_School,0,8000;addr "addr" true true false 75 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_Street,0,255,privateschools_newSchools_Geocoded,USER_Street,0,8000;city "city" true true false 25 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_City,0,255,privateschools_newSchools_Geocoded,USER_City,0,8000;zip "zip" true true false 5 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_Zip,0,255,privateschools_newSchools_Geocoded,USER_Zip,0,8000;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb\publicschoolsSD_newSchools_Geocoded,openDate,-1,-1,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\privateschools_newSchools_Geocoded,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_Charter,0,255;docType "docType" true true false 50 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_DOCType,0,255,privateschools_newSchools_Geocoded,USER_Public_District,0,8000;socType "socType" true true false 50 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_SOCType,0,255;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_GSoffered,0,255,privateschools_newSchools_Geocoded,USER_Low_Grade,0,8000;shrtName "shrtName" true true false 20 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_School,0,255,privateschools_newSchools_Geocoded,USER_School,0,8000;priv "priv" true true false 50 Text 0 0,First,#;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#;Phantom "Phantom" true true false 4 Long 0 0,First,#;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb\publicschoolsSD_newSchools_Geocoded,Notes,0,255,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\privateschools_newSchools_Geocoded,Notes,0,255;Check_ "Check_" true true false 2 Short 0 0,First,#;regionID "regionID" true true false 2 Short 0 0,First,#;schoolID "schoolID" true true false 4 Long 0 0,First,#;Change "Change" true true false 2 Short 0 0,First,#;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_CDSCode,-1,-1,privateschools_newSchools_Geocoded,USER_CDS_Code,-1,-1" # # Append publicschoolsSD_newSchools_Geocoded;privateschools_newSchools_Geocoded Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_CDSCode,-1,-1,privateschools_newSchools_Geocoded,USER_CDS_Code,-1,-1;district "district" true true false 90 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_District,0,255,privateschools_newSchools_Geocoded,USER_Public_District,0,8000;name "name" true true false 90 Text 0 0,First,#,privateschools_newSchools_Geocoded,USER_School,0,8000;addr "addr" true true false 75 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_Street,0,255,privateschools_newSchools_Geocoded,USER_Street,0,8000;city "city" true true false 25 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_City,0,255,privateschools_newSchools_Geocoded,USER_City,0,8000;zip "zip" true true false 5 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_Zip,0,255,privateschools_newSchools_Geocoded,USER_Zip,0,8000;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb\publicschoolsSD_newSchools_Geocoded,openDate,-1,-1,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\privateschools_newSchools_Geocoded,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_Charter,0,255;docType "docType" true true false 50 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_DOCType,0,255,privateschools_newSchools_Geocoded,USER_Public_District,0,8000;socType "socType" true true false 50 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_SOCType,0,255;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_GSoffered,0,255,privateschools_newSchools_Geocoded,USER_Low_Grade,0,8000;shrtName "shrtName" true true false 20 Text 0 0,First,#;priv "priv" true true false 50 Text 0 0,First,#;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#;Phantom "Phantom" true true false 4 Long 0 0,First,#;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb\publicschoolsSD_newSchools_Geocoded,Notes,0,255,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\privateschools_newSchools_Geocoded,Notes,0,255;Check_ "Check_" true true false 2 Short 0 0,First,#;regionID "regionID" true true false 2 Short 0 0,First,#;schoolID "schoolID" true true false 4 Long 0 0,First,#;Change "Change" true true false 2 Short 0 0,First,#;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#,publicschoolsSD_newSchools_Geocoded,USER_CDSCode,-1,-1,privateschools_newSchools_Geocoded,USER_CDS_Code,-1,-1" # # Append newSchools_MERGEG Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,newSchools_MERGEG,USER_CDSCode,-1,-1;district "district" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_District,0,255;name "name" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_School,0,8000;addr "addr" true true false 75 Text 0 0,First,#,newSchools_MERGEG,USER_Street,0,8000;city "city" true true false 25 Text 0 0,First,#,newSchools_MERGEG,USER_City,0,8000;zip "zip" true true false 5 Text 0 0,First,#,newSchools_MERGEG,USER_Zip,0,8000;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_Charter,0,255;docType "docType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_DOCType,0,255;socType "socType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_SOCType,0,255;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,newSchools_MERGEG,USER_GSoffered,0,255;shrtName "shrtName" true true false 20 Text 0 0,First,#;priv "priv" true true false 50 Text 0 0,First,#;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#;Phantom "Phantom" true true false 4 Long 0 0,First,#;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,Notes,0,255;Check_ "Check_" true true false 2 Short 0 0,First,#;regionID "regionID" true true false 2 Short 0 0,First,#;schoolID "schoolID" true true false 4 Long 0 0,First,#;Change "Change" true true false 2 Short 0 0,First,#;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#" # # 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.8.0'><WorkspaceConnectionString>DATABASE=\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Schools_preEdits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>zip</field_name><field_type>TEXT</field_type><field_length>20</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> Append newSchools_MERGEG Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,newSchools_MERGEG,USER_CDSCode,-1,-1;district "district" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_District,0,255;name "name" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_School,0,8000;addr "addr" true true false 75 Text 0 0,First,#,newSchools_MERGEG,USER_Street,0,8000;city "city" true true false 25 Text 0 0,First,#,newSchools_MERGEG,USER_City,0,8000;zip "zip" true true false 5 Text 0 0,First,#,newSchools_MERGEG,USER_Zip,0,8000;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_Charter,0,255;docType "docType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_DOCType,0,255;socType "socType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_SOCType,0,255;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,newSchools_MERGEG,USER_GSoffered,0,255;shrtName "shrtName" true true false 20 Text 0 0,First,#;priv "priv" true true false 50 Text 0 0,First,#;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#;Phantom "Phantom" true true false 4 Long 0 0,First,#;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,Notes,0,255;Check_ "Check_" true true false 2 Short 0 0,First,#;regionID "regionID" true true false 2 Short 0 0,First,#;schoolID "schoolID" true true false 4 Long 0 0,First,#;Change "Change" true true false 2 Short 0 0,First,#;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#" # # CalculateField Schools_preEdits cdeCodeNUM $feature.cdsCode Arcade # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits cdeCodeNUM $feature.cdsCode Arcade # Text NO_ENFORCE_DOMAINS Append newSchools_MERGEG Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,newSchools_MERGEG,USER_CDSCode,-1,-1;district "district" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_District,0,255;name "name" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_School,0,8000;addr "addr" true true false 75 Text 0 0,First,#,newSchools_MERGEG,USER_Street,0,8000;city "city" true true false 25 Text 0 0,First,#,newSchools_MERGEG,USER_City,0,8000;zip "zip" true true false 5 Text 0 0,First,#,newSchools_MERGEG,USER_Zip,0,8000;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_Charter,0,255;docType "docType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_DOCType,0,255;socType "socType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_SOCType,0,255;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,newSchools_MERGEG,USER_GSoffered,0,255;shrtName "shrtName" true true false 20 Text 0 0,First,#;priv "priv" true true false 50 Text 0 0,First,#;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#;Phantom "Phantom" true true false 4 Long 0 0,First,#;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,Notes,0,255;Check_ "Check_" true true false 2 Short 0 0,First,#;regionID "regionID" true true false 2 Short 0 0,First,#;schoolID "schoolID" true true false 4 Long 0 0,First,#;Change "Change" true true false 2 Short 0 0,First,#;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#" # # Append newSchools_MERGEG Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,newSchools_MERGEG,USER_CDSCode,-1,-1;district "district" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_District,0,255;name "name" true true false 90 Text 0 0,First,#,newSchools_MERGEG,USER_School,0,8000;addr "addr" true true false 75 Text 0 0,First,#,newSchools_MERGEG,USER_Street,0,8000;city "city" true true false 25 Text 0 0,First,#,newSchools_MERGEG,USER_City,0,8000;zip "zip" true true false 5 Text 0 0,First,#,newSchools_MERGEG,USER_Zip,0,8000;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_Charter,0,255;docType "docType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_DOCType,0,255;socType "socType" true true false 50 Text 0 0,First,#,newSchools_MERGEG,USER_SOCType,0,255;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,newSchools_MERGEG,USER_GSoffered,0,255;shrtName "shrtName" true true false 20 Text 0 0,First,#;priv "priv" true true false 50 Text 0 0,First,#;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#;Phantom "Phantom" true true false 4 Long 0 0,First,#;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\newSchools_MERGEG,Notes,0,255;Check_ "Check_" true true false 2 Short 0 0,First,#;regionID "regionID" true true false 2 Short 0 0,First,#;schoolID "schoolID" true true false 4 Long 0 0,First,#;Change "Change" true true false 2 Short 0 0,First,#;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#" # # CalculateField Schools_preEdits priv "N" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits cdeCodeNUM !cdsCode! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits priv "Y" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits shrtName $feature.name Arcade # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits shrtName $feature.name Arcade # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits shrtName $feature.name Arcade # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits regionID "0" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits Change "0" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Schools_preEdits Phantom "1" "Python 3" # Text NO_ENFORCE_DOMAINS Append SchoolsPreEdits_ADD_DiscoveryIsle Schools_preEdits "Use the field map to reconcile field differences" "cdsCode "cdsCode" true true false 14 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,cdsCode,0,14;district "district" true true false 90 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,district,0,90;name "name" true true false 90 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,name,0,90;addr "addr" true true false 75 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,addr,0,75;city "city" true true false 25 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,city,0,25;zip "zip" true true false 20 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,zip,0,20;openDate "openDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,openDate,-1,-1;charter "charter" true true false 50 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,charter,0,50;docType "docType" true true false 50 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,docType,0,50;socType "socType" true true false 50 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,socType,0,50;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,gsOffered,0,8;shrtName "shrtName" true true false 20 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,shrtName,0,20;priv "priv" true true false 50 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,priv,0,50;ClosedDate "ClosedDate" true true false 8 Date 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,ClosedDate,-1,-1;Phantom "Phantom" true true false 4 Long 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,Phantom,-1,-1;Notes "Notes" true true false 254 Text 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,Notes,0,254;Check_ "Check_" true true false 2 Short 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,Check_,-1,-1;regionID "regionID" true true false 2 Short 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,regionID,-1,-1;schoolID "schoolID" true true false 4 Long 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,schoolID,-1,-1;Change "Change" true true false 2 Short 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,Change,-1,-1;cdeCodeNUM "cdeCodeNUM" true true false 8 Double 0 0,First,#,\\nasa8\ts\box1\gis\Schools\Schools2022\Schools2022\Schools2022\Schools2022.gdb\SchoolsPreEdits_ADD_DiscoveryIsle,cdeCodeNUM,-1,-1" # # CalculateField School_preEdit city "San Diego" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "El Cajon" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "Escondido" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "Escondido" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "Escondido" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "La Jolla" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "Fallbrook" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField School_preEdit city "Chula Vista" "Python 3" # Text NO_ENFORCE_DOMAINS ExportFeatures School_preEdit \\nasa8\ts\box1\gis\Schools\Schools2022\ToExporttoRDW\Schools2022.gdb\SCHOOL # NOT_USE_ALIAS "district "district" true true false 90 Text 0 0,First,#,School_preEdit,district,0,90;Change "Change" true true false 2 Short 0 0,First,#,School_preEdit,Change,-1,-1;schoolID "schoolID" true true false 4 Long 0 0,First,#,School_preEdit,schoolID,-1,-1;priv "priv" true true false 50 Text 0 0,First,#,School_preEdit,priv,0,50;shrtName "shrtName" true true false 20 Text 0 0,First,#,School_preEdit,shrtName,0,20;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,School_preEdit,gsOffered,0,8;socType "socType" true true false 50 Text 0 0,First,#,School_preEdit,socType,0,50;charter "charter" true true false 50 Text 0 0,First,#,School_preEdit,charter,0,50;openDate "openDate" true true false 8 Date 0 0,First,#,School_preEdit,openDate,-1,-1;zip "zip" true true false 20 Text 0 0,First,#,School_preEdit,zip,0,20;city "city" true true false 25 Text 0 0,First,#,School_preEdit,city,0,25;addr "addr" true true false 75 Text 0 0,First,#,School_preEdit,addr,0,75;name "name" true true false 90 Text 0 0,First,#,School_preEdit,name,0,90;cdsCode "cdsCode" true true false 14 Text 0 0,First,#,School_preEdit,cdsCode,0,14;docType "docType" true true false 50 Text 0 0,First,#,School_preEdit,docType,0,50" # Append Schools2022 SCHOOL NO_TEST "district "district" true true false 90 Text 0 0 ,First,#,Schools2022,docType,-1,-1;Change "Change" true true false 2 Short 0 0 ,First,#,Schools2022,Change,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,Schools2022,schoolID,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,Schools2022,priv,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,Schools2022,shrtName,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,Schools2022,gsOffered,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,Schools2022,socType,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,Schools2022,charter,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,Schools2022,openDate,-1,-1;zip "zip" true true false 20 Text 0 0 ,First,#,Schools2022,zip,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,Schools2022,city,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,Schools2022,addr,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,Schools2022,name,-1,-1;cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,Schools2022,cdsCode,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,Schools2022,docType,-1,-1" # ExportFeatures SCHOOL S:\Review\ToLoad\SCHOOL.gdb\SCHOOL # NOT_USE_ALIAS "district "district" true true false 90 Text 0 0,First,#,SCHOOL,district,0,90;schoolID "schoolID" true true false 4 Long 0 0,First,#,SCHOOL,schoolID,-1,-1;priv "priv" true true false 50 Text 0 0,First,#,SCHOOL,priv,0,50;shrtName "shrtName" true true false 20 Text 0 0,First,#,SCHOOL,shrtName,0,20;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,SCHOOL,gsOffered,0,8;socType "socType" true true false 50 Text 0 0,First,#,SCHOOL,socType,0,50;charter "charter" true true false 50 Text 0 0,First,#,SCHOOL,charter,0,50;openDate "openDate" true true false 8 Date 0 0,First,#,SCHOOL,openDate,-1,-1;zip "zip" true true false 5 Text 0 0,First,#,SCHOOL,zip,0,20;city "city" true true false 25 Text 0 0,First,#,SCHOOL,city,0,25;addr "addr" true true false 75 Text 0 0,First,#,SCHOOL,addr,0,75;name "name" true true false 90 Text 0 0,First,#,SCHOOL,name,0,90;cdsCode "cdsCode" true true false 14 Text 0 0,First,#,SCHOOL,cdsCode,0,14;docType "docType" true true false 50 Text 0 0,First,#,SCHOOL,docType,0,50" # FeatureClassToFeatureClass \\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL \\TECATE\Share\Review\Connections\sangis@warehouse@garnet.sde SCHOOL # "district "district" true true false 90 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,district,0,90;schoolID "schoolID" true true false 4 Long 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,schoolID,-1,-1;priv "priv" true true false 50 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,priv,0,50;shrtName "shrtName" true true false 20 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,shrtName,0,20;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,gsOffered,0,8;socType "socType" true true false 50 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,socType,0,50;charter "charter" true true false 50 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,charter,0,50;openDate "openDate" true true false 8 Date 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,openDate,-1,-1;zip "zip" true true false 5 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,zip,0,5;city "city" true true false 25 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,city,0,25;addr "addr" true true false 75 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,addr,0,75;name "name" true true false 90 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,name,0,90;cdsCode "cdsCode" true true false 14 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,cdsCode,0,14;docType "docType" true true false 50 Text 0 0,First,#,\\TECATE\Share\Review\ToLoad\SCHOOL.gdb\SCHOOL,docType,0,50" # ChangePrivileges \\TECATE\Share\Review\Connections\sangis@warehouse@garnet.sde\Warehouse.SANGIS.SCHOOL SANGIS1 "Grant view privileges" "Do not change edit privileges" Copy E:\BatchJobs\ADR\sangis@warehouse@garnet.sde\SCHOOL E:\BatchJobs\ADR\Staging_All\SCHOOL.gdb\SCHOOL FeatureClass # FeatureClassToFeatureClass D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL D:\ADR\Batch\conn\SANGIS@ustlcscsd0020@SDEP.sde SCHOOL_NWW # "district "district" true true false 90 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,district,-1,-1;schoolID "schoolID" true true false 4 Long 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,schoolID,-1,-1;priv "priv" true true false 50 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,priv,-1,-1;shrtName "shrtName" true true false 20 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,shrtName,-1,-1;gsOffered "gsOffered" true true false 8 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,gsOffered,-1,-1;socType "socType" true true false 50 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,socType,-1,-1;charter "charter" true true false 50 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,charter,-1,-1;openDate "openDate" true true false 8 Date 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,openDate,-1,-1;zip "zip" true true false 5 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,zip,-1,-1;city "city" true true false 25 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,city,-1,-1;addr "addr" true true false 75 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,addr,-1,-1;name "name" true true false 90 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,name,-1,-1;cdsCode "cdsCode" true true false 14 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,cdsCode,-1,-1;docType "docType" true true false 50 Text 0 0 ,First,#,D:\gisdata\ADRgen2\downloads\sangis_downloads\SCHOOL.gdb\SCHOOL,docType,-1,-1" # Rename D:\ADR\Batch\conn\SANGIS@ustlcscsd0020@SDEP.sde\SDEP.SANGIS.SCHOOL_NWW D:\ADR\Batch\conn\SANGIS@ustlcscsd0020@SDEP.sde\SDEP.SANGIS.SCHOOL FeatureClass ChangePrivileges D:\ADR\Batch\conn\SANGIS@ustlcscsd0020@SDEP.sde\SDEP.SANGIS.SCHOOL GIS_SDE_USER GRANT # FeatureClassToFeatureClass SDEP.SANGIS.SCHOOL C:\Users\jsustait\AppData\Local\Temp\ArcGISProTemp16440\aa0a49e9-21b9-44be-8a33-196334cb86d8\Default.gdb SCHOOL_PRIORITY # "district "district" true true false 90 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,district,0,90;schoolID "schoolID" true true false 4 Long 0 10,First,#,SDEP.SANGIS.SCHOOL,schoolID,-1,-1;priv "priv" true true false 50 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,priv,0,50;shrtName "shrtName" true true false 20 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,shrtName,0,20;gsOffered "gsOffered" true true false 8 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,gsOffered,0,8;socType "socType" true true false 50 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,socType,0,50;charter "charter" true true false 50 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,charter,0,50;openDate "openDate" true true false 8 Date 0 0,First,#,SDEP.SANGIS.SCHOOL,openDate,-1,-1;zip "zip" true true false 5 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,zip,0,5;city "city" true true false 25 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,city,0,25;addr "addr" true true false 75 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,addr,0,75;name "name" true true false 90 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,name,0,90;cdsCode "cdsCode" true true false 14 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,cdsCode,0,14;docType "docType" true true false 50 Text 0 0,First,#,SDEP.SANGIS.SCHOOL,docType,0,50" # 1.0 RGDW_Publication RGDW_Publication_1.4 20231117 13085300 150000000 5000 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooqpZWTWb3bNeXNz9onMwE7AiIEAbEwBhRjp7mgC3RRRQAUUVmeIW1dPD962gpbvqojP2dbjOw t7++M47ZxnigCxDfrPqV1Yi3uUa2VGMrxFY5N2eEboxGOfTIoh1SwuNQmsIbyCS7hQPLCjgsikkA kfVSPwrj/hxrninW/wC1JfENg0Nu8qzWMwChfKdQfLABzle5OeSRniuwsNLsNLR0sLOC2WR2dxEg XcxYsSce7E/jQBboqob9V1ZNO+z3O5oDN5wiPlABgNpfpu5zj0FW6ACiiigAooooAKKKKACiiigA ooooAKKKKACiiigAooooAKKKKACiiql1dXMF7ZxRWLTW8zMJ7gSKotwFJBIPLZPHHSgC3VKxt7w6 b5GrTW91OxcSNFEY0ZSTgbST/CQDzUGreINO0nQX1ea8tRa7A0UrzBY5C33QH5GCcc8+tedeH/jK 1/HK+oaTKJDeRoLa0RpHgtWBUzsRkSKJFIJXsR+IB2HhOz0vwtpuo6NbanavaaXKzmIYU2cTLvCy Ekkn7zbjjOfat9L+CfSxqFoTdwPD50XkYYyqRkbexz2psGm2EOoXeowW8YubxUWeUcmQICFz24BI o0rSrPRdPjsLCNo7aMsUQuz43MWPLEnqTQAttqEc1pZzTq1pJdqpS3uCFkDFd2wjP3gAcgehokub pdVgtksXe1eJ3kuxIoEbArtXb1OQScjpj3qC7j8/WrCOXSEuIYleZL1yh+zyjCgAH5ssGbkdMe9c 14Rvdag1i+0mZ7TVtPju7jdqNveF3tnLlhDKjkkEBlA2k4x9aAO3oqpYWTWKTq15c3XmzvMDcMCU DHOxcAYUdhVugAooooAKKo6lb6hcfZP7Pv0tPLuEefdAJPNiGd0YyRtzx83bFXqACiiigAoqhc3G ow3zeVZRzWK2zybklxM0wIwgUgLgjPJYc+nWrFlPJdWNvcS20ltJLGrtBIQWjJGSpwSMjpxQBPRR RQAUUUUAFFFFABRRRQAUyaMSwSRnOHUrwAeo9Dx+fFPooA+d/D+leJfEFnD4UfVbrdaxlLmweM2y WduxkQF8KQ8mTuVCQNoXHqvPat4a8Z6JFqsdzcyfarq0jF88f+oYMyxJAWCFS/z8Ku0KADkkDHrn jrwHp7+Jrbxw/iBtIezKtMZJNkcjDCxjf/ACcBuDkGkuvhp4SGi3V/r7RWtpLClxcRW8+y3hl2Mp kVuC/Lkrv3Y6Dg4oA574Rxa/4P8AGl/4I1SI3MYtxc+fFcF44B1Hy9F3FmznBPHbGfZbLUrHUhOb K7huBBM0EvlOG8uRThlPoR6V4n4h1GbQvGVnbeCdcFyuvQwJMYQk7RvGESFmk2nCsCu4ksSC3HIr d1PxH408K2o11vDGmR2rwiTUtOtHLzG4csPPYopwoEa5yTwSMkjgA9ZBB6HNYet6CLnw1qWnaQlv Zz3ZZ9y74lMjEFmYxkNk45IP1yOK+f8AQ/ip4k8G6zfaXcaUtzJPePe3Vu6lWhLgs6rtUnupydwA GB619C+Fb/UNU8LaZf6pCkN9cwLLNEkbIEJ5xtbkEDFAGsowoGc4FLRRQAUUUUAFFFFABRRRQAUU UUAFFFFABRRRQAUUUUAFFFFABRRRQBFc20F5bSW9zDHNBINrxyKGVh6EGvM9R0Xw34fmv9Si8P65 dQ2cUWnm2gUXEVzyGWQBmO4xnjL8KQBjivUa8Y+I3hfU49ba9hsIE8Irj+0LRL9bcXbyvmSUg4UM Dt5Jz8q4PXAB0Xw90jT7vw1pur+HNR1S0tp50nuVuY0L3ASMReWTtwFyoOV64OMdu3l0q2Nxd3lv HHb6hcwCFrtEBkAGdvXrgknms6GyWxsbfwvZQ3tvYrpxih1GKRB5ZAChQevmYy2duOKyfFPjWTwc YLP+yL/UF+zoBfOQkRmZgkaSSYwCxyS3Qccc8AHnOgeDbrw/8UYdSu1OtXEF1DZCL7UZp7ZGjKi6 m+U4BCEhSeAwGeBXuEOnQwaldX6POZrpUV1aZmQBM42qThevOAM1ya+Oza+H9X12+0WQfYtR+xPB Zus02wOqbnHGDliQvoR65rs7edLm2injDBJFDAOpVgD6g8g+x5FAEFpJfvc3i3dvBFCkoFs0cpYy JtGSwIG07sjHPT87dVNNOoNYqdUS2S73NuFszMmNx24LAHO3GffNcdoN14q1/wAfXepXUV5pvhm0 iMVlazRLG105OGd1yWGCpIyBxtPGTkA7yisXTvFFhqGrXOlMs1pqEEsiC3uk2NKqbcyJ2ZCGU5Hr W1QBUu4797mza0uIIoUlJuVkiLGRNpwFII2ndg556fnTPiO0Hin/AIR4wXouzAJxL9mbySvPHmYx njvx2zniteigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK81+MbaQumaC+sak1lBFqazjNu ZY5SiM219vIB6ZGevQ9vSqo6zbLd6Pdwtp8GoExMVtJ8bJWAyFJIIGTjnHFAHkknxG8NeN7rwsgs dRudYttQhlY6fExS2buSWX5kOORgHAJzxzqalrE2h+K7bwJN4ZN94f1RyFudQvt5lZ2LyYLk52lh hM7uM9SKtaF4c1LwR/bOsWOnyeTNIWTQbKRJvNdtm1jKyqy4JYEcgDmuH8S6l430L4gz66PCtsLW TUUihM6RSeYxRUTY4G9WKowyCQC2D0GQCmmu2Gl+MdEvfJa2tI2u7z7NHeiXzZznhWTaeX2xgSAL tj4JBNey+AoRpuhto0sxe+tJDJdRi28lYWmJl2L1BA344ZvrXI/DKPR9Y1KXUobLxDZX6ytdYvyz JJG6gBfN2jzEBOVDHIPPrXpthbXVsk4ur57svO8kbNGqeWhOVT5eoA4yeTQBboqCC9tbqW4it7mG WS3fy5kRwxjbAOGA6HBB59ajtLJrW5vJmvLmcXMokEczArD8oXamAMLxnHPJNAFkohkEhVS6gqGx yAcZGfwH5CnUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVxHjn4iWvhOU6csR/t Ka286CScbbdRu2ks2cnb94qOSOByRXb1zni/RtW1TTxNoeoi01G3RzEskUbxzZA+R9ykhTgdMe/Q YAPGNO8bnwZ8R9f1C8aFba8mCTW73JQmTegeQRr5hwAXZSduVJ69K9tvfGPhzT47N77V7W2S8tzd W5nbYJIwAcjPfBBx19uK+dviF4U1m1uIb/xZcxm+nszdTXVtZtKZnQhREzD5EKqVGQAvrng1V0yX xtqfgaXTr5pLbw1aWnnCWS1UzRwESENGTtZlJGwkH7rAdM0AfUWk6xp2u2X23S7yK7tt7RiWI5Us pwcHvyOvfqOK8/v/AIga5e6/q+jeG9PW6u0L21oJfLREkjKiSVnMnzr+8T5QueDnHNcbovjXW9Gi sbbQNJtrHw1YsZcXLCIzwDYHaZmJ2OxfevOT0w3Gc2bxf4jHiu7udTgTRoXJvbUW3zqhjDSeUzR5 LLMFDMR9/CsOAKAOr1jxP8RbDWZG0zRLZRcQwXksMcMcu3avlzhtjF5GDlBxyAg9Dn1CXUZ725ls 9JmhF1Z3EK3ouYJAojYBiEPALFTxyQO9fO3wyfxvc+Op9W0m0huoZluk8+aOSKyyxDnaQuVBYowX AJB7c4+iJ9RubHW7OG9lt1tL1BDBHHFI8huAGZssPlCbV4yByKAIbbxJbW2gDUta1DTY1Fy1vJNa zF4VfzCiruIznoDnoc9BWvZXtrqVjDe2U8c9tOgeOWM5VlPcVR1Lw9YanZw2jrJBDFdJd7bVzFuk V9/zbeoLcn1PPXmtNESKNY41VEUBVVRgADsBQBWvzqCpB/ZyWzN56Cb7QzACLPzlcA/NjpnijTZL +WxV9St4Le63MGjglMiAbjtwxAzlcHp3q3RQAUVUjsFj1WfUBcXLNNEkRhaUmJdpY7lToGO7k98C rdABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABXN+PdY1XQfB17qGiWbXWoIY1ijERk+86qTtBBOAT /wDqrpKKAPE9JtviB8RPDWoPrOrWVlo0+RGv9nx3HnxlScgKx5U7cck7gecivJNRvr7xHq1rrv8A wkCDUbmZ7SAQr5MyJEqiNikYwu4kDAPXOOAcfVXivStY1TRRDoGsNpN/HIskcuwMjAfwMCD8p9vQ fSvLfiH8HtOsbHU/FmiXM9rfW8T3LW0MStGz8bii/wAAxvOOcEjHTBAPGp3vdcW/1XVdZtLi9gME aiabbNK2VUsOQDtGAXYHp35I6LwTN4k+zvceEHW41Czkgku7DywGmVS8a4ZWBljAK7hwMt3ArkIN H1CazF5HpTC2muUt4Lq4cLDE7MSBk4Un5cEngYORnBH0L4B0bwX4Q0KPxHPFeWEsE7Wn9oakWi87 cQPlXOPLzwCQOhJxyaALUfhzXbHxL4fnvbnUdUaZxdT2qs0UEFxwJJXYFgAqEBYgdpIbHXB7c+K9 LbxHBoVu8t1eSeZ5jW6eZHblBkiRhwp5Ax1yRnGRWvBcQXUQlt5o5YyAQ8bBgcgEcj2IP40RQQwG QxRRxmR98hRQN7YAyfU4A59qAJKKKKACiiigCpqV62nadPdpaXN40S5EFsoaR/ZQSM/nVscjpj2o ooAKKKqX+pWumJA907qJ50t49sbPl3OFHyg4Ge54oAt0UUUAFFFFABRRRQAUUUUAFFFFABRRRQAV Si04QXN/cJdXTPeFSVeYskRC7f3YPC+p9TV2uR+IHhfWvE+kLDoniG40m5iywWM7UmOQQGYfMMEd R69DQB8oa8dU0fXL3T9XDTSRXJ82O5LsZcSMxO4gEgkt8wxncT3rvtZ0PXNRdvF11pV0fDl4UCQ3 MwkNpDJGqBo0X5cL5x2fKdvl8gGm+LvBXxF0K8g8V63eQ6n9iuI8zwyBnRcgA4ZRhO2MEZJJHJNf RPhibXJtDiPiK0tLfUVJVxaSbo3UdGHpn05/oADA+FGhyaF4HiiuLC6s72aeSa5S627zJnGfl/hw ox7e2K7eiigAooooAKqabqVrq1it5Zu7wMzKC8bIcqxU8MAeoNGpQ3lxp08Wn3a2d2y4jnaIShD6 7SRmrYzjnrQBBe25vLG4tluJrczRsgmhOHjyMblPYjtVfRmvjpMA1GAw3SAoymYSkhSQGLAAEsAG PA61fooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAIBGCMg0UUUAFFFFABRRRQAUUU UAFFFFABRRRQAUUUUAFFFFAH/9k= SanGIS 5510 Overland Ave, Suite 230 San Diego California 92123 webmaster@sangis.org US 858-874-7000 Downloadable as a Shapefile from https://rdw.sandag.org 0.029 File Geodatabase Feature Class schools public schools private schools elementary schools middle schools high schools SANDAG SANDAG Data Solutions San Diego San Diego County San Diego region school enrollment enrollment students SANDAG, School, CDE, California Department of Education San Diego, San Diego County, San Diego region SANDAG California Department of Education (CDE) <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Please read the </SPAN><A href="http://www.sandag.org/resources/maps_and_gis/gis_downloads/disclaimer.asp"><SPAN>SANDAG Data Disclaimer </SPAN></A><SPAN>first before using SANDAG data.</SPAN></P></DIV></DIV></DIV> 2023-03-08T01:00:00 2023-03-08T00:00:00 SCHOOL_PRIORITY San Diego region 2021-09-01T23:00:00 This feature class contains public and private school sites, specifically primary, secondary, and adult schools. The feature class is intended for mapping and general analysis purposes. Schools that fall within - the Broadband Priority Census Tracts. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The types of data in this feature class are school names, spatial locations, addresses, and additional school details (e.g. status of operation, whether the facility is private or public,etc.). School addresses were sourced from the California Department of Education (CDE) and were geocoded using the SanGIS parcels and street centerlines. The attributes from previous School iterations were also updated using aerial imagery, online research, site visits, and over-the-phone verification. Certain points were manually relocated to school buildings.</SPAN></P></DIV></DIV></DIV> 2023-12-01T00:00:00 Phoebe Ho SANDAG Associate GIS Analyst 401 B Street, suite 800 San Diego CA 92101 phoebe.ho@sandag.org US 8:30 am - 4:30 pm Rachael Rider Rachael Rider Microsoft Windows 10 Version 10.0 (Build 22621) ; Esri ArcGIS 12.9.4.32739 1 -117.575105 -116.295440 33.416777 32.543296 Schools2021 Feature Class 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. cdsCode cdsCode String 14 0 0 This 14-digit code is the official, unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school. California Department of Education (CDE) 012 schoolID schoolID Integer 4 0 0 Internal school facility identification code for the purposes of joining to SCHOOLPOLY school polygon data (for validation purposes) and tracking CDS codes with multiple locations. 009 SANDAG Data Solutions district district String 90 0 0 School district name. California Department of Education (CDE) 012 city city String 25 0 0 The city where the school is physically located. California Department of Education (CDE) name name String 90 0 0 School name. California Department of Education (CDE) addr addr String 75 0 0 The street address of a school. California Department of Education (CDE) zip zip String 5 0 0 The 5-digit ZIP code, California Department of Education (CDE) openDate openDate Date 8 0 0 The date the school opened. If the start date precedes July 1, 1980 (the date the California Department of Education began maintaining this information), or if the start date is unavailable (in the case of some private schools), then "7/1/1980" is assigned as a value. California Department of Education (CDE) charter charter String 50 0 0 This field identifies charter schools. California Department of Education (CDE) docType docType String 50 0 0 The District Ownership Code Type is the text description used to identity the Administrative Authority. California Department of Education (CDE) socType socType String 50 0 0 The School Ownership Code Type is the text description of the type of school. California Department of Education (CDE) gsOffered gsOffered String 8 0 0 The "grade span offered" field displays the range of grades offered or supported by a school from the lowest grade to the highest grade. California Department of Education (CDE) priv priv String 50 0 0 The private school indicator field contains binary data that indicates whether a school is public (N) or private (Y). SANDAG Data Solutions shrtName shrtName String 20 0 0 This field contains a truncated version of school names. SANDAG Data Solutions 009 Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. Public and private grade school sites. Includes elementary, middle, and high schools. Intended use is for mapping and general analysis purposes. File Structure: Public Schools Database http://www.cde.ca.gov/ds/si/ds/fspubschls.asp dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE 20231117