20210525
08502100
1.0
FALSE
BIDDEFORD.SDE.ssOutfall
002
Server=GISSQL; Service=sde:sqlserver:GISSQL\SEWER; Database=Sewer_Feild_Data; User=sa; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Maine_West_FIPS_1802_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/10.5'><WKT>PROJCS["NAD_1983_StatePlane_Maine_West_FIPS_1802_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["Transverse_Mercator"],PARAMETER["False_Easting",2952750.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-70.16666666666667],PARAMETER["Scale_Factor",0.9999666666666667],PARAMETER["Latitude_Of_Origin",42.83333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",26848]]</WKT><XOrigin>-15495200</XOrigin><YOrigin>-48378500</YOrigin><XYScale>4000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.002</XYTolerance><ZTolerance>0.002</ZTolerance><MTolerance>0.002</MTolerance><HighPrecision>true</HighPrecision><WKID>102684</WKID><LatestWKID>26848</LatestWKID></ProjectedCoordinateSystem>
CalculateField BIDDEFORD.SDE.ssOutfall_copy Orig_Data_Set "CDM Sewer Mapping" VB #
Append Seans BIDDEFORD.SDE.ssOutfall_copy NO_TEST "AncillaryRole "AncillaryRole" true true false 2 Short 0 5 ,First,#;Enabled "Enabled" true true false 2 Short 0 5 ,First,#;Subtype "Subtype" true true false 4 Long 0 10 ,First,#;FacilityID "FacilityID" true true false 20 Text 0 0 ,First,#;InstallDate "InstallDate" true true false 36 Date 0 0 ,First,#;LocationDescription "LocationDescription" true true false 200 Text 0 0 ,First,#;Rotation "Rotation" true true false 8 Double 8 38 ,First,#;Status "Status" true true false 20 Text 0 0 ,First,#;WaterType "WaterType" true true false 255 Text 0 0 ,First,#;Comments "Comments" true true false 120 Text 0 0 ,First,#,Seans,COMMENTS,-1,-1;OutfallID "OutfallID" true true false 20 Text 0 0 ,First,#;Diameter "Diameter" true true false 4 Long 0 10 ,First,#;Invert "Invert" true true false 8 Double 8 38 ,First,#;Label_ID "Label_ID" true true false 2 Short 0 5 ,First,#,Seans,Label_ID,-1,-1;Orig_Data_Set "Orig_Data_Set" true true false 50 Text 0 0 ,First,#" #
CalculateField BIDDEFORD.SDE.ssOutfall_copy Orig_Data_Set "Sean Nealy - 2005" VB #
CalculateField BIDDEFORD.SDE.ssOutfall_copy Orig_Data_Set "John Perry - 2014" VB #
CalculateField BIDDEFORD.SDE.ssOutfall_copy Label_ID_txt [Label_ID] VB #
CalculateField BIDDEFORD.SDE.ssOutfall_copy Comments NULL VB #
CalculateField BIDDEFORD.SDE.ssOutfall_copy FacilityID "OF00" VB #
CalculateField "Sewer System\Outfalls" ReceivingWaters "Thacher Brook" VB #
CalculateField "Sewer System\Outfalls" Status "Active" VB #
CalculateField "Sewer System\Outfalls" FacilityID NULL VB #
CalculateField "Sewer System\Outfalls" OutfallID NULL
VB #
CalculateField "Sewer System\Outfalls" Label_ID_txt NULL VB #
CalculateField "Sewer System\Outfalls" Label_ID NULL VB #
CalculateField "Sewer System\Outfalls" Sign_Dsgntn null VB #
CalculateField "Sewer System\Outfalls" OutfallID null VB #
CalculateField "Sewer System\Outfalls" Northing null VB #
CalculateField "Sewer System\Outfalls" Easting null VB #
CalculateField "Sewer System\Outfalls" Latitude null VB #
CalculateField "Sewer System\Outfalls" Longitude null VB #
CalculateField "Sewer System\Outfalls" Enabled False
VB #
CalculateField "Sewer System\Outfalls" Subtype 1 VB #
CalculateField "Sewer System\Outfalls" Rotation 0
VB #
CalculateField "Sewer System\ssOutfall" FacilityID ""OFL" & Left( [FacilityID],5 )" VB #
CalculateField "Sewer System\ssOutfall" FacilityID ""OFL" & Right( [FacilityID],5 )" VB #
CopyFeatures "C:\Users\gcopeland.CITY_HALL\GIS\Bidd Sewers\Bidd_Sewers.mdb\Sewer_Stormwater_Network\ssOutfall" "Database Connections\sde_new.sde\BIDDEFORD.SDE.Sewer_and_Stormwater_Network\BIDDEFORD.SDE.ssOutfall" # 0 0 0
CalculateField "Sewer System\Outfalls" GUID ID() PYTHON_9.3 "def ID():
import uuid
return '{' + str(uuid.uuid4()) + '}'"
CalculateField "Sewer System\Outfalls" Protected_GUID !GUID! PYTHON_9.3 #
CalculateField Bidd_2012.DBO.ssOutfall Protected_GUID [GlobalID] VB #
20170623
16060500
20170623
16060500
Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.5.0.6491
DryWeatherOutfallInspectionData_MIL1
Dry Weather Outfall Inspection Data
Dry Weather Outfall Inspection Data
SDE Feature Class
dataset
EPSG
6.16(10.0.0)
0
Simple
FALSE
0
TRUE
FALSE
BIDDEFORD.SDE.ssOutfall
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
AncillaryRole
AncillaryRole
SmallInteger
2
5
0
Enabled
Enabled
SmallInteger
2
5
0
Subtype
Subtype
Integer
4
10
0
FacilityID
FacilityID
String
20
0
0
InstallDate
InstallDate
Date
8
0
0
LocationDescription
LocationDescription
String
200
0
0
Rotation
Rotation
Double
8
38
8
Status
Status
String
20
0
0
WaterType
WaterType
String
255
0
0
Comments
Comments
String
120
0
0
OutfallID
OutfallID
String
20
0
0
Diameter
Diameter
Integer
4
10
0
Invert
Invert
Double
8
38
8
Label_ID
Label_ID
SmallInteger
2
5
0
Orig_Data_Set
Orig_Data_Set
String
50
0
0
ReceivingWaters
ReceivingWaters
String
50
0
0
Label_ID_txt
Label_ID_txt
String
4
0
0
PipeMaterial
PipeMaterial
String
255
0
0
Sign_Dsgntn
Sign_Dsgntn
String
10
0
0
Northing
Northing
Double
8
38
8
Easting
Easting
Double
8
38
8
Latitude
Latitude
Double
8
38
8
Longitude
Longitude
Double
8
38
8
GRID
GRID
String
10
0
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
20170623
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigD//2Q==