Layers:

Layer: Transmission Line Upgrades (41)


Name: Transmission Line Upgrades

Display Field: SerialNbr

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

This is a derived feature class from data stored in TLDD. TLDD is the single source of record for all transmission asset layers (structures, spans, and lines). This layer is derived independently from the structure layer. Generated by getting a serial number from the database, retrieving the structure location, finding the ahead on line serial number, finding the AOL structure location, and connecting the two points with a line representing the span. Structure locations are maintained by the Survey Group in the eGIS SDE database, but are stored and updated in the TLDD structure table. All attribute data coming from other systems such as TLM, TLDD, and TRED are also updated in TLDD. The BPA_TLDD_Span feature class is created using four TLDD view tables:

• TranLineDesign.stgr.v_Span (pk: Strc_Serial_Nbr)

• TranLineDesign.dbo.Strc (pk: Strc_Serial_Nbr) - used for structure locations until TLDD updates the stgr.v_Structure table with these values)

• TranLineDesign.stgr.v_Structure (pk: Strc_Serial_Nbr)

• TranLineDesign.stgr.v_Line (pk: XRef_Cd, Maint_District_Nm)



Copyright Text:

Min. Scale: 500000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 7022450.48226925
YMin: 2503911.36745287
XMax: 7147853.53164402
YMax: 2632006.58609873
Spatial Reference: PROJCS["WGS_1984_BPA_Lambert_2",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6750000.0],PARAMETER["False_Northing",1750000.0],PARAMETER["Central_Meridian",-117.25],PARAMETER["Standard_Parallel_1",44.5],PARAMETER["Standard_Parallel_2",47.25],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",45.0],UNIT["Foot",0.3048]]


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[132,0,168,255],"width":3.4}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.AheadMileNbr+ \"/\" + $feature.AheadStrcNbr","title":"Custom"},"lineOrientation":"unconstrained","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"horizontal","deconflictionStrategy":"dynamicNeverRemove","allowOverrun":true,"repeatLabel":false,"lineConnection":"unambiguousLabels","allowOverlapOfFeatureInterior":"avoid","offsetDistance":20,"stackLabel":false,"removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":99000,"name":"large scale","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":[255,255,210,255],"borderLineColor":[130,130,130,255],"borderLineSize":0.5,"verticalAlignment":"middle","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":false,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"\"Transmission Line Upgrades\"","title":"Custom"},"lineOrientation":"unconstrained","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"horizontal","deconflictionStrategy":"dynamicNeverRemove","allowOverrun":true,"repeatLabel":false,"lineConnection":"unambiguousLabels","allowOverlapOfFeatureInterior":"avoid","offsetDistance":20,"stackLabel":false,"removeDuplicates":"none","useCodedValues":true,"maxScale":100000,"minScale":"NaN","name":"small scale","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":[255,255,210,255],"borderLineColor":[130,130,130,255],"borderLineSize":0.5,"verticalAlignment":"middle","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":false,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SerialNbr (type: esriFieldTypeString, alias: SerialNbr, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• BackStrcSerialNbr (type: esriFieldTypeString, alias: BackStrcSerialNbr, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• AheadStrcSerialNbr (type: esriFieldTypeString, alias: AheadStrcSerialNbr, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• XRefCd (type: esriFieldTypeString, alias: XRefCd, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• OperatingLineNm (type: esriFieldTypeString, alias: OperatingLineNm, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BackMileNbr (type: esriFieldTypeSmallInteger, alias: BackMileNbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BackStrcNbr (type: esriFieldTypeSingle, alias: BackStrcNbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AheadMileNbr (type: esriFieldTypeSmallInteger, alias: AheadMileNbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AheadStrcNbr (type: esriFieldTypeSingle, alias: AheadStrcNbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BackLineSerialKey (type: esriFieldTypeString, alias: BackLineSerialKey, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Transmission Line Upgrades
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/23/2025 5:52:18 PM

Schema Last Edit Date: 6/23/2025 5:52:18 PM

Data Last Edit Date: 6/23/2025 5:52:18 PM