20210707
08494500
1.0
FALSE
FeatureClassToFeatureClass MS21a C:\Users\halseysm\Documents\ArcGIS\Projects\Scott_Project\Scott_Project.gdb MS21a_Join # "MS21a_Schl "MS21a_Schl" true true false 60 Text 0 0,First,#,MS21a,MS21a.MS21a_Schl,0,60;MS21a_Schl_Num "MS21a_Schl_Num" true true false 4 Long 0 0,First,#,MS21a,MS21a.MS21a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,MS21a,For_Pro$.School_Name_3a,0,255" #
FeatureClassToFeatureClass MS21a_Join C:\Users\halseysm\Documents\ArcGIS\Projects\Scott_Project\Omni_GDB_Scott.sde\OmniGDB.HALSEYSM.Reference_Topology_2021 MS21a_QAT_1 # "MS21a_Schl "MS21a_Schl" true true false 60 Text 0 0,First,#,MS21a_Join,MS21a_Schl,0,60;MS21a_Schl_Num "MS21a_Schl_Num" true true false 4 Long 0 0,First,#,MS21a_Join,MS21a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,MS21a_Join,MS_Schl_Name_3a,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS21a_Join,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS21a_Join,Shape_Area,-1,-1" #
FeatureClassToFeatureClass OmniGDB.HALSEYSM.MS21a_QAT_1 "C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Topology\Topology.gdb\Topology_2021" MS21a # "MS21a_Schl "MS21a_Schl" true true false 60 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS21a_Schl,0,60;MS21a_Schl_Num "MS21a_Schl_Num" true true false 4 Long 0 10,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS21a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QAT_1,MS_Schl_Name_3a,0,255" #
FeatureClassToFeatureClass MS21a "C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Topology\db-sql-express-gdb.ciee3dl0g1bl.us-east-1.rds.amazonaws.com.sde\OmniGDB.HALSEYSM.Reference_Topology_2021" MS21a_QA_2021 # "MS21a_Schl "MS21a_Schl" true true false 60 Text 0 0,First,#,MS21a,MS21a_Schl,0,60;MS21a_Schl_Num "MS21a_Schl_Num" true true false 4 Long 0 0,First,#,MS21a,MS21a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,MS21a,MS_Schl_Name_3a,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS21a,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS21a,Shape_Area,-1,-1" #
FeatureClassToFeatureClass OmniGDB.HALSEYSM.MS21a_QA_2021 C:\Users\halseysm\Documents\ArcGIS\Projects\Scott_Project\Scott_Project.gdb\Topology_2022 MS22a # "MS22a_Schl "MS22a_Schl" true true false 60 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS21a_Schl,0,60;MS22a_Schl_Num "MS22a_Schl_Num" true true false 4 Long 0 10,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS21a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS21a_QA_2021,MS_Schl_Name_3a,0,255" #
ExportFeatures MS22a "C:\Users\halseysm\Documents\ArcGIS\Projects\Scott_Project\Omni_GDB_Scott (2).sde\OmniGDB.HALSEYSM.Reference_Topology_2022\OmniGDB.HALSEYSM.MS22a_QAT" # NOT_USE_ALIAS "MS22a_Schl "MS22a_Schl" true true false 60 Text 0 0,First,#,MS22a,MS22a_Schl,0,60;MS22a_Schl_Num "MS22a_Schl_Num" true true false 4 Long 0 0,First,#,MS22a,MS22a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,MS22a,MS_Schl_Name_3a,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS22a,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS22a,Shape_Area,-1,-1" #
ExportFeatures OmniGDB.HALSEYSM.MS22a_QAT "C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Scotts_2022_Projects\Scotts_2022_Projects.gdb\Topology_2023\MS23a" # NOT_USE_ALIAS "MS22a_Schl "MS22a_Schl" true true false 60 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS22a_Schl,0,60;MS22a_Schl_Num "MS22a_Schl_Num" true true false 4 Long 0 10,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS22a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,OmniGDB.HALSEYSM.MS22a_QAT,MS_Schl_Name_3a,0,255" #
ExportFeatures MS23a "C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Scotts_2022_Projects\Scotts_2022_Projects.gdb\Topology_2023\MS23aV1" # NOT_USE_ALIAS "MS22a_Schl "MS22a_Schl" true true false 60 Text 0 0,First,#,MS23a,MS23a.MS22a_Schl,0,60;MS22a_Schl_Num "MS22a_Schl_Num" true true false 4 Long 0 0,First,#,MS23a,MS23a.MS22a_Schl_Num,-1,-1;MS_Schl_Name_1 "MS_Schl_Name_1" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_1,0,255;MS_Schl_Name_1a "MS_Schl_Name_1a" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_1a,0,255;MS_Schl_Name_1b "MS_Schl_Name_1b" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_1b,0,255;MS_Schl_Name_2 "MS_Schl_Name_2" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_2,0,255;MS_Schl_Name_2a "MS_Schl_Name_2a" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_2a,0,255;MS_Schl_Name_2b "MS_Schl_Name_2b" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_2b,0,255;MS_Schl_Name_3 "MS_Schl_Name_3" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_3,0,255;MS_Schl_Name_3a "MS_Schl_Name_3a" true true false 255 Text 0 0,First,#,MS23a,MS23a.MS_Schl_Name_3a,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS23a,MS23a.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS23a,MS23a.Shape_Area,-1,-1;Join_Field "Join_Field" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.Join_Field,0,8000;MS_First_Ref "MS_First_Ref" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_First_Ref,0,8000;MS_Second_Ref "MS_Second_Ref" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_Second_Ref,0,8000;MS_Third_Ref "MS_Third_Ref" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_Third_Ref,0,8000;MS_Address "MS_Address" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_Address,0,8000;MS_City "MS_City" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_City,0,8000;MS_Phone "MS_Phone" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_Phone,0,8000;MS_Website "MS_Website" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.MS_Website,0,8000;Magisterial "Magisterial" true true false 8000 Text 0 0,First,#,MS23a,Middle_FYS.csv.Magisterial,0,8000" #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><FeatureDataset>Topology_2023</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Scotts_2022_Projects\Scotts_2022_Projects.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MS23aV1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>MS22a_Schl_Num</field_name><field_name>MS_Schl_Name_1</field_name><field_name>MS_Schl_Name_1a</field_name><field_name>MS_Schl_Name_1b</field_name><field_name>MS_Schl_Name_2</field_name><field_name>MS_Schl_Name_2a</field_name><field_name>MS_Schl_Name_2b</field_name><field_name>MS_Schl_Name_3</field_name><field_name>MS_Schl_Name_3a</field_name><field_name>Join_Field</field_name><field_name>MS_Address</field_name><field_name>MS_City</field_name><field_name>MS_Phone</field_name><field_name>MS_Website</field_name><field_name>Magisterial</field_name></DeleteField></workflow><workflow><AlterField><field_name>MS22a_Schl</field_name><new_field_name>schoolName2023</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>MS_First_Ref</field_name><new_field_name>firstReference</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>MS_Second_Ref</field_name><new_field_name>secondReference</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>MS_Third_Ref</field_name><new_field_name>thirdReference</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><FeatureDataset>Topology_2023</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Scotts_2022_Projects\Scotts_2022_Projects.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MS23aV1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>vdoeNumber</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField MS23aV1 vdoeNumber Reclass(!schoolName2023!) "Python 3" "def Reclass(schoolName):
dict = {
'Alvey ES' : '0220',
'Antietam ES' : '0760',
'Ashland ES' : '0200',
'Bel Air ES' : '0670',
'Belmont ES' : '0600',
'Bennett ES' : '0840',
'Bristow Run ES' : '0860',
'Buckland Mills ES' : '0950',
'Cedar Point ES' : '0900',
'Coles ES' : '0660',
'Covington-Harper ES' : '0309',
'Dale City ES' : '0610',
'Dumfries ES' : '0280',
'Ellis ES' : '0270',
'Enterprise ES' : '0120',
'Featherstone ES' : '0450',
'Fitzgerald ES' : '0370',
'Glenkirk ES' : '0340',
'Gravely ES' : '0360',
'Haymarket ES' : '0250',
'Henderson ES' : '0330',
'Innovation ES' : '0317',
'Jenkins ES' : '0319',
'Kerrydale ES' : '0070',
'Kilby ES' : '0440',
'King ES' : '0160',
'Lake Ridge ES' : '0180',
'Leesylvania ES' : '0830',
'Loch Lomond ES' : '0460',
'Marshall ES' : '0790',
'Marumsco Hills ES' : '0570',
'McAuliffe ES' : '0730',
'Minnieville ES' : '0030',
'Montclair ES' : '0880',
'Mountain View ES' : '0810',
'Mullen ES' : '0770',
'Neabsco ES' : '0700',
'Nokesville School, The' : '0150',
'Occoquan ES' : '0260',
'Old Bridge ES' : '0820',
'Parks ES' : '0941',
'Pattie ES' : '0130',
'Penn ES' : '0850',
'Piney Branch ES' : '0110',
'Potomac View ES' : '0550',
'River Oaks ES' : '0750',
'Rockledge ES' : '0040',
'Signal Hill ES' : '0500',
'Sinclair ES' : '0620',
'Springwoods ES' : '0320',
'Sudley ES' : '0020',
'Swans Creek ES' : '0890',
'Triangle ES' : '0430',
'Tyler ES' : '0630',
'Vaughan ES' : '0580',
'Victory ES' : '0390',
'West Gate ES' : '0540',
'Westridge ES' : '0740',
'Williams ES' : '0240',
'Wilson ES' : '0306',
'Wood ES' : '0470',
'Yorkshire ES' : '0350',
'Yung ES' : '0970',
'Benton MS' : '0880',
'Beville MS' : '0780',
'Bull Run MS' : '0920',
'Gainesville MS' : '0960',
'Graham Park MS' : '0510',
'Hampton MS' : '0640',
'Lake Ridge MS' : '0720',
'Lynn MS' : '0520',
'Marsteller MS' : '0490',
'Parkside MS' : '0501',
'Potomac MS' : '0170',
'Potomac Shores MS' : '0414',
'Reagan MS' : '0310',
'Rippon MS' : '0591',
'Saunders MS' : '0380',
'Unity Braxton MS' : '0480',
'Woodbridge MS' : '0560',
'Battlefield HS' : '0290',
'Brentsville HS' : '0530',
'Colgan HS' : '5010',
'Forest Park HS' : '0870',
'Freedom HS' : '0300',
'Gainesville HS' : '5130',
'Gar-Field HS' : '0690',
'Hylton HS' : '0710',
'Osbourn Park HS' : '0080',
'Patriot HS' : '1060',
'Potomac HS' : '0140',
'Unity Reed HS' : '0680',
'Woodbridge HS' : '0060'
}
try:
return dict[schoolName]
except:
pass" Text NO_ENFORCE_DOMAINS
ExportFeatures MS23aV1 "C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Scotts_2022_Projects\Scotts_2022_Projects.gdb\Topology_2023\MS23a" # NOT_USE_ALIAS "schoolName2023 "schoolName2023" true true false 60 Text 0 0,First,#,MS23aV1,schoolName2023,0,60;vdoeNumber "vdoeNumber" true true false 255 Text 0 0,First,#,MS23aV1,vdoeNumber,0,255;firstReference "firstReference" true true false 8000 Text 0 0,First,#,MS23aV1,firstReference,0,8000;secondReference "secondReference" true true false 8000 Text 0 0,First,#,MS23aV1,secondReference,0,8000;thirdReference "thirdReference" true true false 8000 Text 0 0,First,#,MS23aV1,thirdReference,0,8000;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS23aV1,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS23aV1,Shape_Area,-1,-1" #
ExportFeatures MS23a "C:\Users\Scott Halsey\Documents\ArcGIS\Projects\Scotts_2022_Projects\SDE_OmniGDB.sde\OmniGDB.SDE.Historical_School_Attendance_Areas\OmniGDB.SDE.MS23a" # NOT_USE_ALIAS "schoolName2023 "schoolName2023" true true false 60 Text 0 0,First,#,MS23a,schoolName2023,0,60;vdoeNumber "vdoeNumber" true true false 255 Text 0 0,First,#,MS23a,vdoeNumber,0,255;firstReference "firstReference" true true false 8000 Text 0 0,First,#,MS23a,firstReference,0,8000;secondReference "secondReference" true true false 8000 Text 0 0,First,#,MS23a,secondReference,0,8000;thirdReference "thirdReference" true true false 8000 Text 0 0,First,#,MS23a,thirdReference,0,8000;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS23a,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS23a,Shape_Area,-1,-1" #
ExportFeatures OmniGDB.SDE.MS23a "C:\Users\orahilsd\OneDrive - Prince William County Public Schools\Documents\ArcGIS\Projects\Nokesville_School_Redistricting\Nokesville_School_Redistricting.gdb\OmniGDB_ExportFeatures1" # NOT_USE_ALIAS "schoolName2023 "schoolName2023" true true false 60 Text 0 0,First,#,OmniGDB.SDE.MS23a,schoolName2023,0,59;vdoeNumber "vdoeNumber" true true false 255 Text 0 0,First,#,OmniGDB.SDE.MS23a,vdoeNumber,0,254;firstReference "firstReference" true true false 1073741822 Text 0 0,First,#,OmniGDB.SDE.MS23a,firstReference,0,1073741821;secondReference "secondReference" true true false 1073741822 Text 0 0,First,#,OmniGDB.SDE.MS23a,secondReference,0,1073741821;thirdReference "thirdReference" true true false 1073741822 Text 0 0,First,#,OmniGDB.SDE.MS23a,thirdReference,0,1073741821" #
ExportFeatures MS_Proposed_Changes "C:\Users\orahilsd\OneDrive - Prince William County Public Schools\Documents\ArcGIS\Projects\Nokesville_School_Redistricting\Nokesville_School_Redistricting.gdb\Proposed_Adjustment_Middle" # NOT_USE_ALIAS "schoolName2023 "schoolName2023" true true false 60 Text 0 0,First,#,MS_Proposed_Changes,schoolName2023,0,59;vdoeNumber "vdoeNumber" true true false 255 Text 0 0,First,#,MS_Proposed_Changes,vdoeNumber,0,254;firstReference "firstReference" true true false 1073741822 Text 0 0,First,#,MS_Proposed_Changes,firstReference,0,1073741821;secondReference "secondReference" true true false 1073741822 Text 0 0,First,#,MS_Proposed_Changes,secondReference,0,1073741821;thirdReference "thirdReference" true true false 1073741822 Text 0 0,First,#,MS_Proposed_Changes,thirdReference,0,1073741821;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MS_Proposed_Changes,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MS_Proposed_Changes,Shape_Area,-1,-1" #
Proposed_Adjustment_Middle
002
file://\\IHC-778822\C$\Users\orahilsd\OneDrive - Prince William County Public Schools\Documents\ArcGIS\Projects\Nokesville_School_Redistricting\Nokesville_School_Redistricting.gdb
Local Area Network
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</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>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20241125
13481200
20241125
13481200
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 13.3.0.52636
MS_Proposed_Changes
File Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
Proposed_Adjustment_Middle
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.
schoolName2023
schoolName2023
String
60
0
0
vdoeNumber
vdoeNumber
String
255
0
0
firstReference
firstReference
String
1073741822
0
0
secondReference
secondReference
String
1073741822
0
0
thirdReference
thirdReference
String
1073741822
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
Shape_Area
Shape_Area
Double
8
0
0
Area of feature in internal units squared.
Esri
Positive real numbers that are automatically generated.
20241125
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAEVdJREFUeJzt3dlyG2d6xvGn0Y19ITaSAAkSIikuEqk99oztKcd25SAzNTlO
zUXlJnIFqUpOcuTELk/ZVmRJ1kgkxRUgiH0HGju6U5QSjzWiNhJkN7qfX5UP7eoiwb+7G+/3fdK/
/vu/qDf/uAoieunhv23hT/E67FaBPxKdkWZuRLS+BiJdESt12K8yVnokheZ8Wl8DkW702gP40QXg
0PpS6BSSYOH/SYj+37CvoCY58CgxwHJEhMMqQLTw56MXktYXQKQnTp8N1/75Lo53SjhMVxDqN3Fl
QoXfrsJhBZodFbAATgkvYkaXi8Ei+ts/CpuI2PoUhqth1AstPDiswN9swj9sI1ETIHgcCDfK+HTV
xp/dJWOwiN5AlCwIRD0v/um2+kgfVGGLAkqnB3unyp+bBhgsovdgd1kxuz6J7PMSvKk0bs7zT0cL
/KkTvadGoYXBsyTuzqmwSnx/pQUGi+g9nDwSlh4m8el0Hy47Y6UVBovoHVRFRfphGuu2BkIexkpL
DBbR26h48d5qrl1CPKzCIjBYWmKwiN5AVYFGXoYtlUXc3YdN4gSp1hgsojfoyT20drJYEWWEvYyV
HjBYRG9aorNXxEy7jLlpxkovGCyiU9TTNThSGSzPqJC43lY3GCyiv9Gud9F6ksSnkwM4rLy70hMG
i+hXhgMF+1/v4qtwB343Y6U3DBbRr+atdv6cxCfeBqZ9In8uOsRgEf3fCENup4zpQgYLq/yz0Cv+
ZogANPNNqDtH+O0i/yT0jL8dMr0XL9k3j3E70IOdi5p1jcEimH0P9/pOHlfQQNgjgCtv9I3BInMP
hybKCFSKmAsqkESuE9Q7BovMSQXalRaEwyyuBvpw2hirccBgkWn3tyo/TuGepwO/i7EaFwwWmVJp
O48VtYLohMT3VmOEwSLTye6WYN1NYvU6P/7jhr8xMpVmqY3W/T3803VOso8jBotMNW9V+GEfn19R
IfE457HEYJFp5q0KT9K46ZIR4mZ8Y4vBIsNThirKu0XMyCXMTfMbwXHGYJHhFzWXElV483mshRRY
ORw61hgsMrR2rQNLKo9FRxsuG/e3GncMFhlWvzNA/XkO8W4F0xGR81YGwGCRYTfjq6dqcB9nsLzE
WBkFg0WGdHKeYPdpAp/ELeAEg3EwWGQ4HbmP+s9J3Av24LRxQNRIGCwyFGWgIPVjErfFOiIBxspo
GCwy1AhD9lkecbmAhThjZUQMFhlGdqcE11EaN2MW8OxTY2KwyBCalQ6EwwxuTQ5g477shsVgkSHW
CeZ/OsJdh4wJJ4dDjYzBorGmDBWUdwtYFeuI+S0cDjU4BovGfjjUlc4hFhhAtPDuyugYLBpPKtCq
tjFM5HDN24XPxViZAYNFY6nfHaCxncPioIZwgLEyCwaLxlL2aQ6RWhGLMxxhMBMGi8ZO+bgBz3Ea
12dViBy4MhUGi8ZuX/b8N9v4w7IKl527h5oNg0VjY9BXkPhzAr9fUuB1MFZmxGDR2OzLnvqfFG6I
VXidjJVZMVg0FvNWxb0SpupFLE2Bw6EmxmCR7ndgaBZkiMksln192KwcYTAzBot0rdPoor2bw6q9
jaDHAj4MmhuDRbo16A3RPCxhplNBNKzCIjBXZsdgkX7XCabrsB1lsDTD8wTpJQaLdKkr91D7KYGv
5oZwWHlnRS8xWKRLu1/v46vJDnxObnVMf8Vgka4oiorjRxmso4xowKb15ZDOMFikG6qqonRYgfsg
idurjBW9jsEi3ajnZCibSXy2wFkrOh2DRbpZ1CxvHuNu4OTwU75kp9MxWKS5fmeA2vMcFlFHyMNY
0ZsxWKT9vFWyglCliHhYhcT9regtGCzSjgrUsk0IJ+sE/QPOW9E7MVikmW6rj+5eFuvWk/MEOW9F
78ZgkSaUgYLqTgGT9RJm44wVvR8GizTZMqaSrMKVTGGDsaIPwGDRpWsUZDQfHuCrOGDlzRV9AAaL
LpVc7aDyMInfRvrwOFgr+jAMFl3qe6vikzQ2bHVMTTBW9OEYLLq0eavUkxzmOmXEp7n0hs6GwaJL
O/w0WMpjJajw8FM6MwaLLlyz0oH8NIXrng7cdt5d0dkxWHTh6wTlvTyu2ZuYnmCs6HwYLLrY4dCD
MgLFPOJRnidI58dg0YUNhzbyTdhSOawGh7CKvLui82Ow6EL0233Iz45x29GCz8VY0WgwWHQh+7In
fkjirtRAxM9Y0egwWDRyyUdZxOUC4vMiePYpjRKDRSNVOqrDm0zhzoIIvraiUWOwaGR6rT6K3+/j
j0sqJJFbHdPoMVg0snmr7P0EPpvpwcmTmumCMFh0bsO+gvJOAfF+DZMTnLeii8Ng0bkoQxXVVA2e
XB6L/iFsEh8F6eIwWHQu7WobymEWi84O3A6OMNDFYrDozPrtAepbWVxFA1M+C3hvRReNwaIzUVUV
jWwd3mIB8SsCeJwgXQYGi85EgADRYUW2b0Op2UNkgvdXdPEYLDobAfBFvBC/WMODx0lc79cwHxQ4
LEoXisGiMztZduMJOyHci+PJoxQ6xSquBBTOYdGFYbDo3Nx+Byz35nG4bUc1n8c1/xB+Nx8RafQY
LBoJp9cG660ZZJ9Z8eAogxvDHia9Fi5+ppFisGh0HyariJmNKRTdNjw+zCLeqmNpiougaXQYLBop
i2jB5FIAzQk7tp8co54o40bMAjvXF9IIMFg0coIgwBt2Q7oXR27LgfZRDneiKjxOvtei82Gw6GII
gHPCjsidWWQ3bfh+/wgfzyrcLpnOhcGiCyXZRMzemEbWbsW3m0ncm+ph+mQZD2+26AwYLLpwgkVA
dC2EkseKb348xEf9Nmb9And2oA/GYNGlCcV8sDqu4scfkliSa7g2DbgdvNWi98dg0aXyhV1wfLmE
5INjtNIFXA8PEfLysAp6PwwWXTqby4r4x3PIbdnx08lBq70O5kIid3ygd2KwSBOSXUTk+jQqPgd+
3kyhO5CxOClCEvkLoTdjsEgzotWC4LwfVoeEJ49PHhFrWJ8RYOWJO/QGDBZpyiIKL7apcfiWsPld
Au3DAn6zKPHxkE7FYJHmTmay7G4rVr5YwPPvJOQeZfDVmgivQ+C8Fr2CwSJdDZmufR5Hds+H/3yw
j89iQ0z5BB7KSr9gsEh3j4gzK0HkJQE/PDvGSkfGUghw2DivRQwW6dTkQgBOnx37f0mjU6hgOajC
6zzZSZ7MjHdYpN/tl0MuSHfmUNhzopnNYSPQR9DDdYhmxmCRrqN1suODtB7BcW+IXCsHvxvg1IN5
MVike4PeEFKrDb9dhYUHIJoag0W6pgwVlJ/nMT+oYTrMd1hmx2CRbqkqUDuuw18qYDkMnnlIDBbp
V6fRxTCRx5K7B4fNovXlkA7wDot0adgfovY8j1m5jKlZroimlxgs0qVqsgZPJou1ee6VRX/FYJHu
tOs9dJ4l8XFE5bIcegWDRbobYTj4dh9f+LvwOPneil7FYJGuHN4/xi1bDRE/Y0WvY7BIN4rJGqL1
PFZnufyGTsdgkS505T6622ncC6mct6I3YrBIc/3OAPmf01i1yvA6tL4a0jMGizSlDFVUExVMNkqY
DSkQuVaQ3oLBIk21K21ImQKu+vpw2fmind6OwSLN9Np9NHZyWBaaCLoZK3o3Bos0oSgqKvtlhKpF
zEVf7n1F9C4MFmmi2+hC3UlhY16FVWKt6P0wWKSJvf/awx8iA+7CQB+EwaJLfxTc+e4It2x1BDz8
+NGH4SeGLnVDvvJhFe6jY1zb4EePPhw/NXRpWtU2+tspfLkqcpqdzoTBokvR6wxQ28xi3dOBk4ei
0hkxWHQp0+zlnSKmW2VEwioEzjDQGUmNUhvekPOs/z7RO9XSDbhyeVydGMLGEQY6B6n09SbqG3HM
roXO898hOlWn2YOSymPZ0YHXwXkrOh/pH5eG+GFrF7slGVc+moVk44b/NLozBeuJMvyFIqIL3Jud
zk+yW4FPFgRsZjPY/+82Qjdj8IRdsPA8cDrnCEM924CyncJ63AJuwkAje+luFQWsRwX4ylU8f9RH
d2Ea/vkArA6+k6ez6bf76Gyl8VF0yF0YaGR+KZJoAeIhCzxNGU+3DpGvtuG/OgV3kDuq0YdRFRWF
ZzksDmsIevmKgUbnlVuok2+bw14LPrKp2Clmkbgvo7U2g9CcDxbe09N7Sm8V4U2nsXyFsaLROvWZ
z2UXsBEF/OU6dp71kCxOYnZjGlY7P4D0dtWsDHEnhTszL+/aiUbpjS+pTj5s82EL/K0unmXT2K+0
MHsvBk+Aj4j05jMFa39J4dPpPjxOjjDQ6L31rfrJR27CJeDujAJPvoS9R4D14zjsbusFXAqNu6OH
GayJDQTdjBVdjPf6GvDkW8ST8Qeb28ZvDulUuf0qwpU84lMKLFx6Q1oGqyir2Bp4EV6Z4nwWvaZd
7UBIZLHi68Np44sr0jBYclfFZsOOiY0Y3H6+v6JXDbpDNA4KiAuNF98wE2kWLEUFnuYFyHNRzEQ9
F3ohNJ5Lb2pHVXiLRcyFVD4KkrbBepoaIOOLYv7aJLcEodd06l0o+xkseXp8FCRtg5WpDLEnBhC9
PcP3VnT6HldPM7jhaCHs46MgaRisekvB/YINU1/Mw+G2XdKl0DjJ75UQqRcxGxNejL8QaRKsoaLi
cdYC370FuALc2I9e16p3Uft+F1/e5N7spGGwVACb6SFaszGEoz6+t6JTp9k3/2MLf9qwwMbNPOiS
Sb/evyhTVZDzhDGxPMWN/OjUbwXTj9L4cubkIAm+tyINg9XoqNjtOCGsTMLptWtwKaT3LWNKB1UE
innMzTJWpGGwegMVezUR7egUpmITLxcREv1Ko9iCup/GRngIibvRkkakk+HQo6qAvCeE4FKYIwz0
mm6rj85BHivONnzchYE0JNXbKrZ6HgRvR2Bz8i0qvf7eqnFUxaRcQTTIaXbSlvT1LhD8IgYX1wnS
aQdJ5GQoBxksBAc8U5A0J7n+7iomol6tr4N0qN/pQ97JYsNx8ijIF+2kPSmyEtT6GkiHVFVFPVHB
dK2I+UW+KiB94CeRTiWX2ug/S+LWVe7jT/rBYNFr2o0est/t4e8jQ0gWPgqSfjBY9IrhQEHu0TFu
u2WEfby7In1hsOgVue0iYnIRi7OMFekPg0W/KKXqkA7TWIuoXPhOusRg0QsduYfuTgY3J3pw2bg2
i/SJwaIXC5vLzwtYFBqI+ATwlC7SKwbL7FSglmnAXy0j5lMgWnh3RfrFYJlcq9ZB+3kGi5YW3HaO
MJC+MVgmNuwP0dgvYqZTxWyMsSL9Y7BMrJ5pwJPLYTUigE+CNA4YLJPqNHto/pzEZ5ND2K18b0Xj
gcEyIWWgYP+bA/zO24bfzUdBGh8MlgkdP83jhqWCWFDkbtg0Vhgsk6kX2xB3jnB9VeS8FY0dBstk
763S3+7i93FudUzjicEyiWFfQeZRGvcCbXgcfMlO44nBMsnSm2qyglivglgAHGGgscVgmYBc6UBI
FXDF1YeDIww0xhgsE5wp2NzNYVGpI+DioyCNNwbLwJShCvm4ikC5gHgUEDlyRWOOwTKwbqOL3vYx
fhNVeaYgGQKDZVQqkPjuAJ9PdOHiLgxkEAyWQU9sPvjxGGtqBdGAVevLIRoZBsuAatkmPMkj3Fhj
rMhYGCyDadW6qD44xD8sWDhvRYbDYBlIrzN4cabgLU8Lbk6zkwExWEY6SGK3iLluGbEpzluRMTFY
BlHPy/AUi1gJKrBKDBYZE4NlAB25j/ZeDmuWFjx2xoqMi8EywDR7db+IcK2IWMzCPa7I0BiscaYC
zXwTtmQW61GBS2/I8BisMdaVe5C307jj78Fh40JBMj4Ga4y/FSxs5jDbLGMqzl8jmQM/6WOqeFiF
N53B9Tj3ZifzYLDGdJq99XMCn86BuzCQqTBYY2Y4UJC+f4TfTXIXBjIfBmvM7P94jBWlgikfX7IT
TOXxQQ//CwqL1LLprz0aAAAAAElFTkSuQmCC