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)
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:
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:
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
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat