20191001
09342600
1.0
FALSE
CreateFeatureclass "C:\Users\sburnham\Desktop\Arc Working\SmallCells.gdb" SmallCells Point # No Yes "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]];-20037700 -30241100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" # # # # #
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.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\sburnham\Desktop\Arc Working\SmallCells.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SmallCells</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>Owner</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Owner</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Support_Structure_Type</field_name><field_type>LONG</field_type><field_alias>Support Structure Type</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.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\sburnham\Desktop\Arc Working\SmallCells.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SmallCells</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>Support_Structure_Type</field_name></RemoveDomainFromField><AssignDefaultToField><field_name>Support_Structure_Type</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>Support_Structure_Type</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDomainToField><field_name>Support_Structure_Type</field_name><domain_name>supstrtype</domain_name></AssignDomainToField></workflow></operationSequence>
DefineProjection SmallCells PROJCS['NAD_1983_StatePlane_Indiana_East_FIPS_1301_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',328083.3333333333],PARAMETER['False_Northing',820208.3333333333],PARAMETER['Central_Meridian',-85.66666666666667],PARAMETER['Scale_Factor',0.9999666666666667],PARAMETER['Latitude_Of_Origin',37.5],UNIT['Foot_US',0.3048006096012192]]
Append 'CrownCastle (Fibertech)\Points' "C:\Users\sburnham\Desktop\Arc Working\SmallCells.gdb\SmallCells" "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#" # #
Append Points SmallCells "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#" # #
CalculateField SmallCells AssetID autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField SmallCells AssetID ""SMALLCL-" + $feature.AssetID" Arcade #
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.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\sburnham\Desktop\Arc Working\SmallCells.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SmallCells</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Status</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Status</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>smclstatus</field_domain></AddField></workflow></operationSequence>
Append 'Zayo- Utility Pole Collocate -GN 131st and W [SC]\Points' "C:\Users\sburnham\Desktop\Arc Working\SmallCells.gdb\SmallCells" "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#;Status "Status" true true false 50 Text 0 0,First,#" # #
Append AT&TCingular\Points "Small Cells Existing" "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#;Status "Status" true true false 50 Text 0 0,First,#" # #
Append 'AT&T proposed\Points' "Small Cells Existing" "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#;Status "Status" true true false 50 Text 0 0,First,#" # #
Append 'Zayo Proposed\Points' "Small Cells Existing" "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#;Status "Status" true true false 50 Text 0 0,First,#" # #
CalculateField "Small Cells Existing" AssetID autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField "Small Cells Existing" AssetID autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 24 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField "Small Cells Existing" AssetID ""SMALLCL-" + $feature.AssetID" Arcade #
FeatureClassToFeatureClass SmallCells C:\Users\kshanayda-adm\Documents\ArcGIS\Projects\MyProject\Enterprise.sde\SDE.Engineering SmallCells # "Owner "Owner" true true false 50 Text 0 0,First,#,SmallCells,Owner,0,50;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#,SmallCells,Support_Structure_Type,0,50;AssetID "AssetID" true true false 50 Text 0 0,First,#,SmallCells,AssetID,0,50;Status "Status" true true false 50 Text 0 0,First,#,SmallCells,Status,0,50" #
Append 'Zayo Decorative Poles\Points' SDE.SmallCells "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#;Status "Status" true true false 50 Text 0 0,First,#" # #
CalculateField SDE.SmallCells Status autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 31 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField SDE.SmallCells AssetID autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 32 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField SDE.SmallCells AssetID ""SMALLCL-" + $feature.AssetID" Arcade "rec=0 def autoIncrement(): global rec pStart = 32 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
Append Verizon_07302020 SDE.SmallCells "Use the Field Map to reconcile schema differences" "Owner "Owner" true true false 50 Text 0 0,First,#;Support_Structure_Type "Support Structure Type" true true false 50 Text 0 0,First,#;AssetID "AssetID" true true false 50 Text 0 0,First,#;Status "Status" true true false 50 Text 0 0,First,#" # #
CalculateField SDE.SmallCells AssetID autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 58 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField SDE.SmallCells AssetID ""SMALLCL-" + $feature.AssetID" Arcade #
CalculateField SDE.SmallCells AssetID autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 65 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField SDE.SmallCells AssetID ""SMALLCL-" + $feature.AssetID" Arcade #
SDE.SmallCells
002
Server=issvrsql5; Service=sde:sqlserver:issvrsql5\sql16_gis; Database=Carmel_SDE; User=sde; Version=sde.DEFAULT
ArcSDE Connection
170739.757500
209272.820900
1704355.413700
1723069.644400
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Indiana_East_FIPS_1301_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.5.0'><WKT>PROJCS["NAD_1983_StatePlane_Indiana_East_FIPS_1301_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",328083.3333333333],PARAMETER["False_Northing",820208.3333333333],PARAMETER["Central_Meridian",-85.66666666666667],PARAMETER["Scale_Factor",0.9999666666666667],PARAMETER["Latitude_Of_Origin",37.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2965]]</WKT><XOrigin>-18119800</XOrigin><YOrigin>-45615400</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2244</WKID><LatestWKID>2965</LatestWKID></ProjectedCoordinateSystem>
20200612
09253100
20200612
09253100
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 14393) ; Esri ArcGIS 12.5.0.22081
Small Cells
0.000000
0.000000
1
-86.228116
-86.090305
39.978285
39.926328
Enterprise Geodatabase Feature Class
dataset
EPSG
6.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
SDE.SmallCells
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.
Owner
Owner
String
50
0
0
Support_Structure_Type
Support Structure Type
String
50
0
0
AssetID
AssetID
String
50
0
0
Status
Status
String
50
0
0
20200612
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1iiii
vLPZCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAiuLeK6hMMy7kJBIyR0OR0+lS9BRRT
AKKKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUARXNxFaW7zzuEjQZZj2qUHIyKKKYBRRRSAKKKKACiiigAooooAKKKKAC
iiigAooooAKKKKACiiigAooooAKKhEcwu2kMwMJQARbeQ2Tk5z9OPapqYBRRRSAKKKiuBOYsWzRr
JkcuCRjPP6UwJaKKKQBRRUNxFJMirHO0JDqxZQDkA5I59elMCaiiikAUUVFbC4EWLlo2kyeUBAx2
pgS0UUUgCioIzd+RJ5qwiXLeWFYlSO2ePzp8PmmBPPCCXaN4Q5Ge+KdhXJKKKKQwooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACikLBRkkAeppaACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKAIri3huoTDcRLLG2CUcZBwcj9RUvQYoopgFFFFIAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigBkrmOJ3VGcqMhV
6n2GaInMkKOUZCyglG6r7Gn0UwCiiikAVFNcLA0SsrnzX2DapOD7+g96lopgFFFFIAooooAhnuor
d4UkLAzPsTCk84J5x06VNUU9tDciMTRh/LcSLnsw6GpaeggooopDCiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCOWaKBQ0rqgLBQWOMknAH51JTXjSQAOisAQ
QGGeR0NOpgFFFFIAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAoqK5g+0wmPzZI8kHdGcHg5qWmAUUUUgCiiigAoqK4g+0Iq+bJHtY
NlDgnHb6VLTAKKKKQBRRRQAUVDcNOqKbdEdt6hg7YwueT9cVNTAKKKKQBRRRQAUUUUAFFFFABRRR
QAUUUUAFSw20s/3EJHr2q3Y2AkHmyj5ew9a1lVUUKoAA7CuinQ5tZHLVxKi7RMlNJkP35APYc1YT
SoR95mY1foroVGC6HM69R9Ssun2y/wDLPP1OakFtAB/qU/75qWirUUuhm5ye7OYooorzD1wooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACrtjZmd
97j92P1qtbxiWdEPQmuhRFjQKowBXRRp8zuzmxFXlXKtxwAAwOlFFFdh54UUUUAFFFFAHMUUUV5Z
7IUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
F/Sot1w0h6IP1NbFFFd9Fe4jzcQ71GFFFFamAUUUUAFFFFAH/9k=