20220809
17062100
1.0
FALSE
CreateFeatureclass C:\Users\calipper\Documents\ArcGIS\Projects\SOPs\SOPs.sde Reconciliation Point # No No "PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192]];-121841900 -93659000 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # Reconciliation
UpdateSchema C:\Users\calipper\Documents\ArcGIS\Projects\SOPs\SOPs.sde\Reconciliation <operationSequence><workflow><AddField><field_name>project</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>trooper_name</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>troop</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>district</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>registry_number</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>date_worked</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>hours_worked</field_name><field_type>Long</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow></operationSequence>
UpdateSchema C:\Users\calipper\Documents\ArcGIS\Projects\SOPs\SOPs.sde\Reconciliation <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</field_alias></AlterField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68794b47626f376d575863674662614a322b6175754150416467666430597843552f647352717554572b78383d2a00;ENCRYPTED_PASSWORD=00022e68542f53626c54475046564c61486b78323268674b695a305a576178436b3353522f544d614c7755374d65413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.Reconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68436f687645313768577059504b4464635671366371416a6947475571624f6e546c735a35616b4b735572383d2a00;ENCRYPTED_PASSWORD=00022e685343527a7a615a5154596663506b77792b39444549477455526d4158316d75466a616868576a4b6c666e673d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.Reconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>wave</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68436f687645313768577059504b4464635671366371416a6947475571624f6e546c735a35616b4b735572383d2a00;ENCRYPTED_PASSWORD=00022e685343527a7a615a5154596663506b77792b39444549477455526d4158316d75466a616868576a4b6c666e673d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.Reconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>wave</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68436f687645313768577059504b4464635671366371416a6947475571624f6e546c735a35616b4b735572383d2a00;ENCRYPTED_PASSWORD=00022e6839792b4169656c774a4a6d2b4e6c384979317967337753473653336f5661762b4e753642645756534378413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.Reconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>deleteRow</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass Reconciliation C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SpecialProjects.gdb Reconciliation2023 # "project "Project" true true false 255 Text 0 0,First,#,Reconciliation,project,0,255;trooper_name "Trooper Name" true true false 255 Text 0 0,First,#,Reconciliation,trooper_name,0,255;troop "Troop" true true false 255 Text 0 0,First,#,Reconciliation,troop,0,255;district "District" true true false 255 Text 0 0,First,#,Reconciliation,district,0,255;registry_number "Registry Number" true true false 255 Text 0 0,First,#,Reconciliation,registry_number,0,255;date_worked "Date Worked" true true false 255 Text 0 0,First,#,Reconciliation,date_worked,0,255;hours_worked "Hours Worked" true true false 4 Long 0 10,First,#,Reconciliation,hours_worked,-1,-1;wave "Wave" true true false 4 Long 0 10,First,#,Reconciliation,wave,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Reconciliation,GlobalID,-1,-1" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SpecialProjects.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reconciliation2023</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>month</field_name><field_type>LONG</field_type><field_alias>month</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SpecialProjects.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reconciliation2023</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>month</field_name><domain_name>month</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SpecialProjects.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reconciliation2023</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>month</field_name><new_field_name>date_month</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
FeatureClassToFeatureClass Reconciliation2023 C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SOPs.sde sops_reconciliation # "project "Project" true true false 255 Text 0 0,First,#,Reconciliation2023,project,0,255;trooper_name "Trooper Name" true true false 255 Text 0 0,First,#,Reconciliation2023,trooper_name,0,255;troop "Troop" true true false 255 Text 0 0,First,#,Reconciliation2023,troop,0,255;district "District" true true false 255 Text 0 0,First,#,Reconciliation2023,district,0,255;registry_number "Registry Number" true true false 255 Text 0 0,First,#,Reconciliation2023,registry_number,0,255;date_worked "Date Worked" true true false 255 Text 0 0,First,#,Reconciliation2023,date_worked,0,255;date_month "Month" true true false 4 Long 0 0,First,#,Reconciliation2023,date_month,-1,-1;hours_worked "Hours Worked" true true false 4 Long 0 0,First,#,Reconciliation2023,hours_worked,-1,-1;wave "Wave" true true false 4 Long 0 0,First,#,Reconciliation2023,wave,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Reconciliation2023,GlobalID,-1,-1" #
Rename C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SOPs.sde\SOPs.DBO.sops_reconciliation C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SOPs.sde\SOPs.DBO.SOPsReconciliation FeatureClass
Rename C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SOPs.sde\SOPs.DBO.SOPsReconciliation C:\Users\Colleen\Documents\ArcGIS\Projects\SpecialProjects\SOPs.sde\SOPs.DBO.ProjectReconciliation FeatureClass
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>date_month</field_name><domain_name>month</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>troop</field_name><domain_name>troop</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>troop</field_name><domain_name>troop</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>project</field_name><domain_name>project</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>delete_row</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>delete_row</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>delete row</field_domain></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>delete_row</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>delete_row</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>delete row</field_domain></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>district</field_name><domain_name>district</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>district</field_name><domain_name>district</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>district</field_name></RemoveDomainFromField><AssignDefaultToField><field_name>district</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>district</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDomainToField><field_name>district</field_name><domain_name>district</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>delete_row</field_name></RemoveDomainFromField><AssignDefaultToField><field_name>delete_row</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>delete_row</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>delete_row</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>delete_row</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>delete_row</field_name><domain_name>delete_row</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>row_delete</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>row_delete</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>delete_row</field_domain></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>row_delete</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>row_delete</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>delete_row</field_domain></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>row_delete</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>row_delete</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686e54646364682f574a4a5638794f6c4e7a6345556e394e746e3230706c703471382f48782b566c37726f413d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=calipper;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>wave</field_name><domain_name>wave</domain_name></AssignDomainToField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68547a3154614870305531434a6252776e6768534a707379536d59356150524a526b67716749567367554d413d2a00;ENCRYPTED_PASSWORD=00022e687342794f4e4b6a7936714c433632614565757749752f61686441685733465372443456305131767a5265633d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>name_update</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68547a3154614870305531434a6252776e6768534a707379536d59356150524a526b67716749567367554d413d2a00;ENCRYPTED_PASSWORD=00022e687342794f4e4b6a7936714c433632614565757749752f61686441685733465372443456305131767a5265633d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>name_update</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Reconciliation trooper_name !name_update! "Python 3" # Text NO_ENFORCE_DOMAINS
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68547a3154614870305531434a6252776e6768534a707379536d59356150524a526b67716749567367554d413d2a00;ENCRYPTED_PASSWORD=00022e687342794f4e4b6a7936714c433632614565757749752f61686441685733465372443456305131767a5265633d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>name_update</field_name></DeleteField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68547a3154614870305531434a6252776e6768534a707379536d59356150524a526b67716749567367554d413d2a00;ENCRYPTED_PASSWORD=00022e687342794f4e4b6a7936714c433632614565757749752f61686441685733465372443456305131767a5265633d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>name_update</field_name></DeleteField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68547a3154614870305531434a6252776e6768534a707379536d59356150524a526b67716749567367554d413d2a00;ENCRYPTED_PASSWORD=00022e6873355175716c2b685951783677734a586575556e2f3077534c5975464f53464f3663627867484d676f4e673d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>uniqueID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>validate_check</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>validate_message</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.0.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68547a3154614870305531434a6252776e6768534a707379536d59356150524a526b67716749567367554d413d2a00;ENCRYPTED_PASSWORD=00022e6873355175716c2b685951783677734a586575556e2f3077534c5975464f53464f3663627867484d676f4e673d2a00;SERVER=52.152.170.15;INSTANCE=sde:sqlserver:52.152.170.15;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=52.152.170.15;DATABASE=SOPs;USER=gisadmin;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SOPs.DBO.ProjectReconciliation</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>uniqueID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>validate_check</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>validate_message</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
AlterField Reconciliation delete_row # Delete "Long (32-bit integer)" 4 NULLABLE DO_NOT_CLEAR
CalculateField Reconciliation uniqueID "!project! + !trooper_name! + !date_worked!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Reconciliation uniqueID "!project! + "_" + !trooper_name! + "_" + !date_worked!" "Python 3" # Text NO_ENFORCE_DOMAINS
SOPs.DBO.sops_reconciliation
002
Server=52.152.170.15; Service=sde:sqlserver:52.152.170.15; Database=SOPs; User=AdministratorSQL; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_North_Carolina_FIPS_3200_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["NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2264]]</WKT><XOrigin>-121841900</XOrigin><YOrigin>-93659000</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102719</WKID><LatestWKID>2264</LatestWKID></ProjectedCoordinateSystem>
20221103
16532500
20221103
16532500
Microsoft Windows 10 Version 10.0 (Build 22000) ; Esri ArcGIS 12.9.0.32739
ProjectReconciliation
SOPs
Special Projects Reconciliation
Enterprise Geodatabase Feature Class
dataset
EPSG
6.12(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
SOPs.DBO.sops_reconciliation
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
project
Project
String
255
0
0
trooper_name
Trooper Name
String
255
0
0
troop
Troop
String
255
0
0
district
District
String
255
0
0
registry_number
Registry Number
String
255
0
0
date_month
Month
Integer
4
10
0
date_worked
Date Worked
String
255
0
0
hours_worked
Hours Worked
Integer
4
10
0
wave
Wave
Integer
4
10
0
GlobalID
GlobalID
GlobalID
38
0
0
20221103
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1uTVb
tnYJpszqD8vIwRUkGo38l0sUmmvHExxvz0+takcWypCcDrUgVXuYoCEkkVS3TPempqFoj7WuIwSR
3psthHdSP9pVJI/4QRyKzbzTtNtTtjsBK4U/KvX2pWEkbiyRygtG4cA4yDUgHHNc5BqM2nwMItHl
jTPAGOT+dadjqM9y5E1m8KgZ3EjFMZPKwLY7U1UHUDFNnKtIrA1NgAZBrLqSRvbLMhDc+x71V/s6
wADJCu/txWhuG3dx0pik+WB3FVpYegBBGu1e9DsdvHSlLHGSeajJz1pNoTDmk/GgHJwaAfmxUiKd
3dFD5UK75Dx16UWUAtYyHA8wnkirRghhkeVEHmN1aqxJYliaUnbQGOkk3Z7YqNAWAHc0bAwyTjnp
SxuA556cCp66gPACqegxxTYI2mm3Acd802Q7/oO9OvJXtIokjZ0JySVTdVJXY0X5R9yJeh649Kry
M09yiKMIlZrahd5AE7FiMf6nn+VTadPJ9rCyO5z1Bjxg/WrerGa4GeKRiVRgp+Yjg1IxA6dapX1w
Le3ZurHhR709tgILeSSbKO+WDYzU88gt7ZmVsFR1qK0gjit41Ztrn5qZfxMIRtcKCec5OatJNWJd
07luF2eBGc8suaZtJIA/GnxyIY0jwAAAKRuG4b8a2ppq6Mp2epPHtUFgxOOx7UqsQT8rcnPFQb2L
DPSrAbgcVnJOO5rCSewOcjlHxVT5cnaCB71akl8uLPUmqta0l1MqzWwUUUVuYBSE4pTxUbtmhITd
hHfNR5pWptWjNs2EPy+poK854rPj1aELzHLn02mnvq9uoHyuRnB+XpXm9D1LF3G1s1GYoxKZFUb+
5pYZlnRZFB2sO4qQ4VTTAQ478VWuJf3ezp9KfPOgGO9UUHmPjk1nOXREtliKEFAxORUjcHHamj5R
sGcUYODUiJCPTpUWSGK59xSqe1JIeAQMEUxik+9Ic4yT1pAdwyM5pdpIpCGE5pSQMDPJpVXB5pJY
965UfN2oQDs5OCM1F5IVTKfy9KlijfIB6d6W5O2PjpT5dLsdijIxY9eTSKEZ8DoKTjaSevapEj+4
MYyeaztcRYtoFbqM9/pU8t1HETu6gcVBe3ItLfCcu3CjFRWsEkw82cbT/dzWvw6IrYsJhm8zHzMM
49KkGfSkRSrYPPvTyfagQucHis64Vry+WIqyxxfMSRw1TvcujndC+0dCOamSVHj38j6inZgmRyW6
zYJOCPSq+pAJZBSTtyAfmxn8akuNStLSRUmlCF8kZqjealZXEaot1CRnJBcA0LcZqRxRtAuODtGK
jKlcA1HBe28xxbzpJtGSFOaSW9jDcq2QccDNb0nK+mxhUtbUlyMYIqdHLDCr07ms/wC3Q5x8+f8A
dqzDdIyFUDbvUritakboinKzFlJaQgnpSUUVaVlYiTu7hRRSE4FUIazccVGTSk5pjVaRm2B60lFF
Mk2Qic4UVEUQkgqMVDZQm0i8szPLznc5yaskZPQV5m56gIoCgDgUkx2xk07kHPGKqXMu75Ac0pOy
BsiSOSfn+GnOwhG1Ofep4FPk4HFVZBhjmsmrIm1iaI78HIyKmOO3NZjXcMDYL5b+6OtKkl1dKjRk
RLk5z+lVHYaLzOiAl2A+tNSRJF3KwI9azjZI7ATs00vOfSr0VssQAHA67RwKegCspbLJx7+tPzkC
nsQOR+VRbW3ZXoexpPUGSBenvTipRSSagYOnPVgM59KjZpJRlnK/jinoh7Fj7VEkXBJPpVR55LjK
gBVHU1PBEwQgAHP8RpzRJDHvcjAH4Cm7y2EVIogX749SKbPeozeTaKXlHHsKhlu5ZpxFbKxGRmT2
rVtrWK3yVjCsxyxA6mlGNh2KNrpzJMJ5yXl6+won+2yTBbTAQ9S3r3rVZlB2nPNKCpXHaqSAxjHr
KyEZhx2qzZfbSz/atu0dMDrWjtGOtRMTQwYUx1yMLxThz1o+gqRFP7BFM7NOok5+UMOlOGn2Z/5d
oz+FWvr3puzHKmqBtkcVtDA5McSIW7gdaHCkn1HrUjbuA4GPUVG6lTnqD0NbU463MpvQrW8EyzKX
lDr3+WrB+8Tn6UmcZ96K3teVzG9o2CiiirJCo3NSE4qE9aaJkJTDyaUmkqzNhRRSZFAGkAG6cVIN
q/ePNMSJBxg/maZIBnapNeXsrnpiyzAA4OB7VUXlt1K0LtJtDGnNEyAKGrJtt3FuPmuhbqqhWYtn
GKotFc3zh5X8qLsqnBxV0AhVDbSRyCacElbGMD3rRajK8dnDEeFBb+8w5p5LDO0Egdan8oofny5+
tOy2MCPA+tKwWKMbmNjhcsauIXdNzjaBSFTEC3l49eazpp9aVWxawuhOAN3JH50Ri+oWLj3caNiN
Wkb2FSIbhxukwgPYdazYrnVItoeygiGecHn+daD3hYgRqRnueaptIEATMhXPJ7k1MYEGASCfrUMU
fBMm7OeMCpUVAwJwMeppJeQxJ5Pstu0m0sFGcCqonnvSA8YS1x8wYfe+laBkjclQQR354qKb5gAC
MDoM1T0AbAqRLiNcJ0Aqzv3LgVApwOakUjOalNgPC7eScmmgZORxTnIIyKZn5abAcM5xmhhj60Lk
AE0F8t04p20AABtzmgdR6U1iCc5FGf8AaHFIBzgBsihQT24pMjI+ZfzpxkVf4lx9aLagKyB0IYYq
m5YfKScdqtl1P8a/nVSNg7tuYYz61XO46EyimVbu7FpHvaN3GcYQZNU/7ftssPLmyoycIeK15o4V
JcEFiMdaiEcfJCKC3XjrXRBykrmE1GLtYzm123SUI0cwBUMG2HHIzVm0v0vGYIjrtAILDGas7E/u
r+VKFA6AD6VpZkNrsDfdNQHpUznioT0rSJlIbRRRVEDSe1JRRVCNiRgVIB5PSowm0F2OABnNI5Vc
uzAADmqEpbUpDEjFbZCCxx972ryN2eruXEmiljEiEFT0IpjucE+nNPQKqBFX5QMAUot9x5PA7VNr
7CJUVdmRj8aUuANq9arXU/kRHZgueF9M1RE2uALm2gLf72KtIZrhWzS7dvfLVl2susfa1F3FCsB6
7W5FaodU+8QKeiARYm3ZY8elVtQa4Eax2rKkhOdx6AUs9+FJWMZPrWfLcnBZ2yR+tS5W2C5SaHVC
fmvImPqV/wDr1MbXVQqsky7gP7vBpYPPvHyD5Ua88jk1dinflT07GpuluIsxSMiL5nL45+tO/eTA
gKMGmIuSCenvVhD8wA6U1dghY4gi9s0rD0UU4DjoKhkcr0FadChTGCMkYp2xAPu0hc7MkEVlzzX8
82bHytqjB8z1pAaXljsKeYV24xg1jOfEJQgfZA3bGakil1gOpuPs4jB+bb1o2A1FhUH1HrmlEajj
Gay212OJ3RoJWYNgBBnNPtdbiup/KSGcEnGSnAoAvNsBxinBF28AUNFkioZtQtLOVYp5VRmHGaFe
+oi0FQjgCmumB0FUm1jT1jMguVwDg0f2vYsRtuUJbgDNDAuqFPBAzTVgVeQO9IZAHBPTGKa8xVsA
5/pVKF7EuSW4swVkG0DI71WHpT3cuc9M9cU3vmuiEXHc55yUnoFFFFamYySomqWSomqkZyG0hNLT
T1q0QJRRRTAlmkM1wLdQHH/LTPTFWhH5caRLwAMYqvYwi3i8wriR8Zq6FLfM3U/pXj76HqCqoVcd
+9P2d+1NXrz0pJZwi5Ayaq6QDykaLlsCoWuQGGThapzTvI23PzdhmoCshA7/ANKzc29guXZ7pP72
cdhVUyebyPXkmo9oQMZGVR9ajjlkl4g2iNgRvPGDS1bAuXBWGyd1j8yQDIUVRVJA6yzAM3ZccCrN
hbbJzJJMZJDwOTxVmaNA3I681T20AjZmmH7tcVaitlQAtyaWJdq4C4FPO9jgAYpJdWBIqLnqKecA
cU1U28n8qUkHOOMVqihwzgdhTcjJp24KozTWGOe9MBrgswyQFFKm0dAKikkUKfX0p8ecZ4+lTzai
uPcgjOaryxCZWUn5SORVW5uJ1mzB5bR47tjmmx3Ny0yhhCEPXDUbgSTzG2ttkXXGEB9aopea8if8
eMbADk7+T+lbYhRlydrDqDUoOAM00hlHTpryaAtexCJyeAD2qd7GCVi0qLJ6bxnFTEZ60/oKYFI2
FlGGH2eIBsZGBg03+zbVH3R20QPX7oqBnbUbxQq/6PGTlunIrRcruxntQJjCgfGfyFI8caRknFPD
BVJ61EAj844z3pXkloTZDJiAquPSoEcODg5qabyuQ7hTjgE1AjRKeHT8DWlPmbXYyqWVyQdKWkHU
0tdRgRv1qJqlkqGtEZy3CmnrSk4FNqkQFFFFMBbm+eOQCGEzYBLBR+lQjX5mb/kF3e08D5a0Y7dE
BcZBbk1OFPZjXkK1j1DGudfeJcHT7kE8dKtQyNPCrBSuRnDdadK2WI3A4NSKgOH8xRxUaMCtsYTB
yORSMSo3Z6nGBVlz5R+cBl65qvIASQg4PI5qGrCIXs1aczNlw38J6U94vlCqMe1PDsFCkZ461LDF
JKd5yB2otcB9tH5I3t1xUskqOVxjrk+9C2+TmRifQVDLqNhZTiOeQI4GeR2rSK6DRdV1B5YfnUy7
exBrJbxDpSoW85WHt3q3Bc295biaAhkPQitNEPYtyMFXnvVdpcA8HFMgKT/NtIAOME0XA8lS7MFj
Aycmk9QTuSCQFctxjmpYZknTchyM4rHhW41FjsIS3HX1Na6RxwRBEGAKaGV7hP3uQOKlj+ZfSlLb
jzigHiotrckg/s62J3FOR/tGl/s6zAwYsfiaJzJIgEZ+tRFJwmSSx7CqTKRcjVYI1ijHygYAzUm3
setYZ0q6nfzo72WDcSWUc4py6JcjI/tWcgjnGKoDb21T1G5eKIRRAGWThcmorKzm06GXNxJccZVW
7UtrbvJO15NnceFU9hQBbhAjiCtjceWx3NI4B4HSlO0nBPNQNLhuO1Re5LY5ozj5T+GajBZT97pT
2kVlGOaiJx1FdNO/2jCf90iulMqg+UsjDseKgEZ3AG1ULnk7ulXM56UuMVukkrIxeruxBSk4FFRO
3FNITdhjtk02imk1okZNgetJRRVCCiiigC9I5VApPPepFVmt2OMkg00RbzubmpkJUbe2K8aK7nqI
55tLumcloIznv5h/wpDYSovzQpnONu/t+VdCefwpojGSSMk+tJrsBkWlvOjSHygoIHRs5q79mYZI
IzV3oOajcEqdvFHL3CxTjiLSYNaCJtTAqNIfk29TUvzoBuwV6ZqoxBIcBxgioFs4w+51DfUVZHH/
ANemE4f2q9iiJ4IcgeUgH0pR5caYAAA7CnOcjI/KqZY5OetRJ2JbJbIMvmbhxuyKS5tVubhWcnYB
gp2NOgOVwamH3qfNcFsJFE0EeE2hR0GKc3mMuQAaMnpRICU2r3NO4xh37fuDP1pfnEeNoA9jUhQ7
Md8URthSCOlCAjGAKU0jAqcgfKf0o6c9aZQ7p0p4fGKAo2AEVH3xnIpEku4Y+lMyMYxSCmk8Urhc
pajJcnbHayIkmclm5GKz2t9WVubmEhuc7P8A69aUsayNkE59acAAAPSto0XJamUqqWxm28OpR3Sy
SXUbx/xJsxWvJJuAAGBUdFbRpqJk6jasFFFIxwK1MxrtUJOaVmzxTCatIyk7iE9qSiirJCiiigAo
oooA11Tk54pTtC4HWm5I4NAHvXkXPVGlk9frSrICD7VBcsq5PQD1rKXWZlcx/wBm3B7BgOtOwWN3
IbnFJjI9Kp6bfS3YffazQbcf6wYzV2QEqdpANDBiG4ijbYZow390sM0vnRyoVVlbjsaz30ezncyT
xbpjwzbiP61Na6fb2bFoUKkjHLE/zouBaVztweo4pocM+B2pHBxuUc96gUsmWHPrUt2EW/fvSOiN
g7eajj3nk9KnyTwBQtQI+B2xSF1VwCwBPQZqZl3Lisq602S8kYSSFQOFKnBqrDsaPmIPmZ1x65pV
YOcg5HtWMvh2ALtklnPp854rT0+wj06N1RpGDHJ3nNCAt7gVqJt3UcVKOTweKRxnrTY2IjDbiowu
1tw+5/KlHHHSpMqBzQhIa/3RzUbADoaHbaf9n+VBIz1FS03sJjSxVScZ+lY32C+Epcai+DnggHFb
O9cHByahralC+5lOdlZGV9i1MOoGoDYB3QZz+VaECSRxBZZPMf8AvYxUtFdKVjBybCiiiqEBOBUb
HilJzTGPFNIlsjNMpxNNrRGQUUUUwCiiigAooooA2AgC7utN68jiqhdpZooc4UDc3NW+9eSz1L3G
S26zLhhkdx60qRBQCBjFPXvzQGH50DF56CkZ+CKaWC96a74IA6mpuA1C285PFSgZFGBj3pMe1FrC
FU84zUVwoAyPxqYIODzioHlG/wAtAWPtT6DBJ44lXe6rnpk9akN7bYH79Bn3qo+n291IBdRq4wdu
e1MXQNMjG0W4bHTNNaIDWUgjggg1E43N6UqIsSqFGFAwB6CnHae9NgMCMBy2RUvIXGc0m4Bfaqtx
eR2427g0h6Lnk0JAWM4OKXJB68VBG8nkeY6gEjlTUUN2kjbG+R89DS1FctOQeRTC2ec0H9KhducU
4Rc3YmUuVXBnJ+lNoortjFRVkcrk3uHSiiimIKKKKYBTCc0E5pKZLYVG5p56VExqkSxlFFFWQFFF
FABRRRQAUUUUAW7EB/MlPUnC59BVsCqlllY2Uggg1a5xXky3PTWxIrYHAppGRkU05U5HelByKm4x
jrvXg8imhPnG5skVKVJ5rEurGCa8Z5NSeCXvGsmAB9KOXqFjbJGaMVm2iW1mHY3/AJvHO+QHFXEv
rQnm4iP/AAMUwLCE80KoBO0AGjcGGR09qVSvqaYxjR7hzwR0pFPODw3vT8ncfSmSncnTkc0aAS7v
l6VGyYGadG3y9O1U7v7S7+XAQqkfe9KGAlzf7WEEKl3JAOO1ENlFG5crufcWBbnFOtbVLVMLlm7s
epqfd2AqWxXCXLRgVTkiV/vLnFTzXCxRsTyQOAOprGbWdp2mzuN3XAQ9PrT5W2mhM24iNvzcAVH3
rJXXlbj7Hc/98GtSN/MjV8EZGcGuulFRW5z1G2OooorYzCiimlvSgBScU0tmkop2JuFFFITigQ1j
UbdKeelMbpVohjaKKKoQUUUUAFFFFABTc0p6U2mhM0b7fHDuizuPy5Hb3rHWPVXl8uO+UZ4Hy9K2
ph5kXljO4802G1WMgk5Yd68ds9YojT9XRyf7SUqSOqVrqrKgzye9HoM05femAgJJAwKozaVaXMxk
nhV5D1bJH8q0WUZGBQFwc09QM8aPYrvxbrhhhuTzTV0TTVyRbJn/AHj/AI1oliD04qNuTmloALhI
wijCgYApyDjpTcAjjNPQEA880kAFCD14ppHBGakB4wRTXIzTYEUT7RtPX3pTk0yXgBvSjO4GktWJ
skVS2DkYpSqAk54qIMmCT1qMsT3zW0aNzOVSyFnWKQAFdxByD6U2iiuiMFFWRhKTluGB6UUUVRIU
ZHrTWPam07CuKTmkoopkhRRRQAU0mlJxTCaaE2ITmmnpS0VRIyiiiqEFFFFABRRSHpQAhOaSiimS
a6nJJHTtTx1oorx3ueuOC4NPKiiimhgeoxQwOKKKoBhGVznmo+hooqGIchxn1p68cjvRRVLYEQ3d
x5EW7GST0qmNQXGSmPoaKKiW4ycv50BKDcSOB71mPY3jyF1v5Idxzs25x+OaKK1pJPcznotBjaZe
MuP7Umz3O3/69aEMbRQqjOXIGNx6miiupJLY53JvckoooqyApGOKKKEJjKKKKZIUUUUAFFFFADCa
ZRRVkMKKKKAEIptFFNCCiiimAUh6UUUCG0UUVQj/2Q==