20230606
09101600
1.0
FALSE
DBO.PublicWorks_Drainage
002
515477.324064
608771.689800
6110731.506963
6160805.062598
1
-
Server=gis-sql; Service=sde:sqlserver:gis-sql; Database=GIS_Prod; User=sa; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_11N
<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.4.0'><WKT>PROJCS["NAD_1983_UTM_Zone_11N",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["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-117.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26911]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>26911</WKID><LatestWKID>26911</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass "Drainage Ditches" "C:\Users\PPaek\AppData\Roaming\Esri\ArcGISPro\Favorites\GIS_QC (PPAEK) (2).sde\GIS_QC.DBO.PublicWorks" Drainages # "Name "Name" true true false 254 Text 0 0,First,#,Drainage Ditches,Name,0,254;GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,Drainage Ditches,GlobalID,-1,-1" #
DeleteField GIS_QC.DBO.Drainages GlobalID
CopyFeatures "C:\Users\PPaek\AppData\Roaming\Esri\ArcGISPro\Favorites\BLC-GIS (SA).sde\GIS.DBO.PublicWorks\GIS.DBO.Drainages" C:\Users\ppaek\AppData\Roaming\Esri\ArcGISPro\Favorites\GIS_P.sde\DBO.PublicWorks\DBO.Drainages # # # #
CopyFeatures C:\Users\ppaek\AppData\Local\Temp\ArcGISProTemp8052\Untitled\GIS_P_Backup.sde\DBO.PublicWorks\DBO.Drainages "C:\Users\ppaek\AppData\Roaming\Esri\ArcGISPro\Favorites\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.Drainages" # # # #
CopyMultiple "'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.BridgeFiles' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.RoadPlans' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.CapitalProjects' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.Culverts' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.Drainages' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.GraderBeats' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.Grading' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.Gravelling' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.GravelPits' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.LinePainting_CrackSealing' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.RightOfWay_Purchase' FeatureClass;'W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks\DBO.RoadAllowanceLease' FeatureClass" "W:\Projects\Database Connections\GIS_Prod (SA).sde" Bridge_files;Road_Plans;Capital_Projects;Culvert_Locations;Drainage;Grader_Beats;Grading_All;Gravelling_All;Gravel_Pits;Line_Painting_Crack_Sealing;Right_Of_Way_Purchase;Road_Allowance_Lease "DBO.BridgeFiles FeatureClass DBO.Bridge_files #;DBO.RoadPlans FeatureClass DBO.Road_Plans #;DBO.CapitalProjects FeatureClass DBO.Capital_Projects #;DBO.CapitalProjects__ATTACHREL RelationshipClass DBO.Capital_Projects__ATTACHREL #;DBO.CapitalProjects__ATTACH TableDataset DBO.Capital_Projects__ATTACH #;DBO.Culverts FeatureClass DBO.Culvert_Locations #;DBO.Culverts__ATTACHREL RelationshipClass DBO.Culvert_Locations__ATTACHREL #;DBO.Culverts__ATTACH TableDataset DBO.Culvert_Locations__ATTACH #;DBO.Drainages FeatureClass DBO.Drainage #;DBO.GraderBeats FeatureClass DBO.Grader_Beats #;DBO.Grading FeatureClass DBO.Grading_All #;DBO.Gravelling FeatureClass DBO.Gravelling_All #;DBO.GravelPits FeatureClass DBO.Gravel_Pits #;DBO.GravelPits__ATTACHREL RelationshipClass DBO.Gravel_Pits__ATTACHREL #;DBO.GravelPits__ATTACH TableDataset DBO.Gravel_Pits__ATTACH #;DBO.LinePainting_CrackSealing FeatureClass DBO.Line_Painting_Crack_Sealing #;DBO.RightOfWay_Purchase FeatureClass DBO.Right_Of_Way_Purchase #;DBO.RoadAllowanceLease FeatureClass DBO.Road_Allowance_Lease #"
Rename "W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.Drainage" "W:\Projects\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks_Drainage" 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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684437753647596879756e524948577770333973676f5950314556436c6a6333744e547a3244674539386e593d2a00;ENCRYPTED_PASSWORD=00022e68577964624279524d5a69734c614e376c7a7a363738537163577736306c584b6a5a3551706a3063546262513d2a00;SERVER=gis-sql;INSTANCE=sde:sqlserver:gis-sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-sql;DATABASE=GIS_Prod;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.PublicWorks_Drainage</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><EnableArchiving /></workflow><workflow><EnableReplicaTracking /></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.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684437753647596879756e524948577770333973676f5950314556436c6a6333744e547a3244674539386e593d2a00;ENCRYPTED_PASSWORD=00022e6859683462466c583364433356505663623248617558794e4a527a6c75362f666f4b365133764371664243493d2a00;SERVER=gis-sql;INSTANCE=sde:sqlserver:gis-sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-sql;DATABASE=GIS_Prod;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.PublicWorks_Drainage</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>AMID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>20</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.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684437753647596879756e524948577770333973676f5950314556436c6a6333744e547a3244674539386e593d2a00;ENCRYPTED_PASSWORD=00022e6859683462466c583364433356505663623248617558794e4a527a6c75362f666f4b365133764371664243493d2a00;SERVER=gis-sql;INSTANCE=sde:sqlserver:gis-sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-sql;DATABASE=GIS_Prod;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.PublicWorks_Drainage</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>AMID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>20</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField PublicWorks_Drainage AMID None Python # Text NO_ENFORCE_DOMAINS
EnableEditorTracking "W:\Projects\INTERNAL\Water and Sewer\Water and Sewer.gdb\Drainage_Draft" created_user created_date last_edited_user last_edited_date NO_ADD_FIELDS UTC
DisableEditorTracking "W:\Projects\INTERNAL\Water and Sewer\Water and Sewer.gdb\Drainage_Draft" DISABLE_CREATOR DISABLE_CREATION_DATE DISABLE_LAST_EDITOR DISABLE_LAST_EDIT_DATE
ExportFeatures PublicWorks_Drainage "W:\Projects\INTERNAL\Water and Sewer\Water and Sewer.gdb\Drainage_Draft" # NOT_USE_ALIAS "Name "Name" true true false 254 Text 0 0,First,#,PublicWorks_Drainage,Name,0,253;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,PublicWorks_Drainage,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0,First,#,PublicWorks_Drainage,created_user,0,254;created_date "created_date" false true false 8 Date 0 0,First,#,PublicWorks_Drainage,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,PublicWorks_Drainage,last_edited_user,0,254;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,PublicWorks_Drainage,last_edited_date,-1,-1;AMID "AMID" true true false 20 Text 0 0,First,#,PublicWorks_Drainage,AMID,0,19" #
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.4.0'><WorkspaceConnectionString>DATABASE=W:\Projects\INTERNAL\Water and Sewer\Water and Sewer.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Drainage_Draft</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Status</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Drainage_Draft Status !created_user! PYTHON3 # TEXT NO_ENFORCE_DOMAINS
DeleteField Drainage_Draft created_user;created_date;last_edited_user;last_edited_date;AMID DELETE_FIELDS
ExportFeatures Drainage_Draft "W:\Database Connections\GIS_Prod (SA).sde\DBO.PublicWorks_Drainage" # NOT_USE_ALIAS "Name "Name" true true false 254 Text 0 0,First,#,Drainage_Draft,Name,0,253;Status "Status" true true false 10 Text 0 0,First,#,Drainage_Draft,Status,0,9;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Drainage_Draft,GlobalID,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Drainage_Draft,Shape_Length,-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/3.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684437753647596879756e524948577770333973676f5950314556436c6a6333744e547a3244674539386e593d2a00;ENCRYPTED_PASSWORD=00022e6878672f475159546974566c334f644a614c4f30557a3653393646614f6d396e6b73644371507276323063733d2a00;SERVER=gis-sql;INSTANCE=sde:sqlserver:gis-sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-sql;DATABASE=GIS_Prod;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.PublicWorks_Drainage</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><EnableArchiving /></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.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684437753647596879756e524948577770333973676f5950314556436c6a6333744e547a3244674539386e593d2a00;ENCRYPTED_PASSWORD=00022e68443872752b6f5a36596349542f626d6e6d6c6131425a58426e483378782f4b624946363174763862722b513d2a00;SERVER=gis-sql;INSTANCE=sde:sqlserver:gis-sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-sql;DATABASE=GIS_Prod;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.PublicWorks_Drainage</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><EnableReplicaTracking /></workflow></operationSequence>"
20250924
09212800
20250924
09212800
Microsoft Windows 10 Version 10.0 (Build 26100) ; Esri ArcGIS 13.4.0.55405
Drainages
0.000000
0.000000
1
-116.757183
-115.274488
55.592951
55.131301
Production
Enterprise Geodatabase Feature Class
dataset
EPSG
6.11(3.0.1)
0
Simple
FALSE
0
TRUE
TRUE
DBO.PublicWorks_Drainage
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Name
Name
String
254
0
0
Status
Status
String
10
0
0
SHAPE
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
GlobalID
GlobalID
GlobalID
38
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20250924
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAB9pJREFUeJzt3U9vXFcZwOF3xjMe/23sxCENdZw2NJGKBJEKLS2oAlGx4wN0
xaYrlqz5Bqz5DizYIRagbKiEChLQVpVoqYtKosQVbUodp0ns8cz4onujViUJrZ2M5+adeR7JsiaO
7xw7nl+O75xzp1UURREjUOwV0Wg2RnFXwJhqjeqO3r3wbpz5/plozYzsLoExM7J6bG9ux6A/iNbo
7hIYM+oBpCFYQBqCBaQhWEAaggWkMdpgjWTFFzCuRhascklDb7sXncVO9Lv9aHVM7oCDGVk1Zpdm
Y/PiZuxs7cTbv307nvrxU/v7xCJi0BvEwomFmF+ZP+xhAg+xkQVr9dur8cm/P4ndm7tx+runq/f7
NdgdVG/AZBtZsBYfXazeAO6XE0lAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAa
ggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqC
BaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIF
pCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWk
IVjDVkREY+hHBQRr+LY2tqI92465Y3N+wGDIzLCG7NKfL8WTP3xy2IcFBGu4Ni9tRrFXxNxRsys4
DGZYQ7JzbSfe+s1bcf6l88M6JHAHwRqC/k4/1i+sx9kfnY2F4wvDOCRwD4J1H/rdfgx6g+oZwUaj
ERuvb8T88fk4fu74/RwO2CfBOogionujG+u/X4/pheloTjVjqj1Vnbc6/b3T0WhazwCHSbAO8Gvf
O797J27951asPb8WR584Ws2uyjVXZbiareah/kMBgrVvRVHEia+fiEceeySm56f97EANUsywBruD
aobTeaRT2xjKxaAr51Zqu38gSbBuXL0R1zeux6lnT9U9FKBGKYJVDIrY6+/VPQygZimC1bvVq56J
AybbQx+scmZ16U+X4swPztQ9FKBmrQzPznUWO9UyAmCytTIs1iyjBdBKsWhzu1/3EICHwMMfrEbE
9KKFmkCGYMXtrS8AKYIFkCNYRcTujd26RwE8BB7+YDUiWjP1DXOvtxeDwWBfq/HLPY/30tvuRavT
ivZ8e39PIBQR/d3+3YtlP/fnx752bN9fA4yL2oNVzp6u/O1KdG927/nxna2duPqPq9G93o29we3t
OctPLA/1hR7KoLz6y1djqjN118cGO4Po925HptlsRnuufc9jlGO7M0aLJxer991PutGeaUdvp/d/
Z4vlxu7PrgJR3F7dX77yzufP35XLO8qxXv7L5Xjx5y9WV46ASVJ7sJrtZhWg+IKtgo8///hdV04Y
pvJ4z/30uZhq3R2su2Z7ndq/ZdU4yvjBpKn90VcGYHltue5hRGehvkvXHNTcslflYTLVHiwOrrws
M0wiwQLSEKykdm9Z6sHkEayEylfnKZ+9hEkjWAnNrcxVSx9g0ghWQo2pRhR9xWLyCFZCjWhEYYrF
BBKshMSKSSVYwIQE69PLFx/gdEr598u38teaclsOB1fuLzTLYhI9ULC2r23Hxmsb1b62RqNRrcAu
33+R8moD/W6/2gpTvhKOVdsHt7S2VG3EhknzQMGaXpiOR7/xaHWlgvJ//fKKBOXG3C9TzrDKB9yX
bjbmnmaXZn1nmEgPFKxydrTwlYXhjQbgCzjpDqQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWk
IVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQh
WEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFY
QBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpCFYQBqCBaQhWEAaggWkIVhA
GoIFpCFYQBqCBaQhWEAaggWkIVhAGoIFpJEmWMVeEY1mo+5hADVqZYnVlb9eiVPPnqp7KECNUgTr
5kc349rla4IFEy5FsNpz7bj+/vXY2dqJmSMzdQ8HqEmKYHUWOnH0iaOxeWkzTn7zZN3DAWqSIlil
maWZKIqi7mEANUoTrKnWVHXyHZhcaYLVbDWju9WtexhAjdIEq7PYiY/++VHc+vhWdXt6bjpaM2mG
DwxBmkf8sSePxfuvvx/v/eG96nZ5Av6Fn71Q97CAEUoTrOZUM86/dP6z26/84pVaxwOMXppg3Wn7
2nbdQwBGLG2wltaW4o1fvRG7N3cjioinf/J0tDppvxxgH9I+wp95+ZkqVOVShzd//WYMdgeCBWMu
bbCm2lP/c34LGH9pg/V5i19djA/f/jBWn1mNRsMlaGBcjUWwVr+1Ghf/eDF6271qfRYwnsYiWO3Z
drWIdG93L2Ku7tEAh2UsglVu25ldno31C+uxfHo5Vs6uVLeB8TIWwSqdPH8yjjx2JD74+wdxdf1q
rH1nre4hAUM2NsEqT7bPH5+PlXMr8fG/Pq57OMAhGJtgfap8oYqty1ux8dpGxB1PGB5ZPRILxxfq
GhrwgMYuWPMr87H2/Frs9ffu+lhreuy+XIhJ8l/J656C6pCCgAAAAABJRU5ErkJggg==