View In:   ArcGIS Online Map Viewer

Name: Transformer

Display Field: TilmId

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Relationship: ScanData and WorkSketchData linked by AssetID number. TilmData linked by TilmID, updated partially by Warehouse/Storekeeper, Electrical Engineer, and GIS. TilmPcbData, TransMntc, TransInspect linked by TilmID.</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>

Copyright Text: Original information created by walker & associates with 1985 aerials, Transformer Cards, and TILM Database. Changes have been made with with plan sets, projects, aerial checking, WorkSketches, and field verification. The Gis has been updated by Billy McCurdy, Bill Hale, and Sondya Moriarity.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 976425.8916942014
YMin: 406126.7930461301
XMax: 2995733.100073278
YMax: 1252518.1000947803
Spatial Reference: 102748  (2285)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [78, 78, 78, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 4000.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: false, length: 20, defaultValue: XFM, modelName: AssetID )
• TilmId ( type: esriFieldTypeString, alias: TilmId, editable: true, nullable: true, length: 16, defaultValue: null, modelName: TilmId )
• AdministrativeArea ( type: esriFieldTypeString, alias: Administration, editable: true, nullable: true, length: 60, defaultValue: COPA, modelName: AdministrativeArea , Coded Values: [COPA: COPA] , [Cnty: Cnty] , [Nippon: Nippon] , ...14 more... )
• OperationalArea ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 60, defaultValue: COPA, modelName: OperationalArea , Coded Values: [State: State] , [COPA: COPA] , [Cnty: Cnty] , ...3 more... )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifeCycleStatus , Coded Values: [Active: Active] , [Demolished: Demolished] , [Inactive: Inactive] , ...7 more... )
• SubSta ( type: esriFieldTypeString, alias: SubSta, editable: true, nullable: true, length: 24, defaultValue: null, modelName: SubSta , Coded Values: [A St: A St] , [College: College] , [F St: F St] , ...8 more... )
• Feeder ( type: esriFieldTypeString, alias: Feeder, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Feeder , Coded Values: [PUD: PUD] , [BPA: BPA] , [1201: 1201] , ...11 more... )
• FeederPg ( type: esriFieldTypeString, alias: FeederPg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FeederPg )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Name )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• Project ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project )
• PrimaryImage ( type: esriFieldTypeString, alias: PrimaryImage, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PrimaryImage )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )
• Situs ( type: esriFieldTypeString, alias: Situs, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Situs )
• Intersection ( type: esriFieldTypeString, alias: Intersection, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Intersection , Coded Values: [1st St and US Hwy 101: 1st St and US Hwy 101] , [4th St and 4th St: 4th St and 4th St] , [4th St and 4th/5th Alley: 4th St and 4th/5th Alley] , ...1106 more... )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street , Coded Values: [10th St: 10th St] , [10th/11th Alley: 10th/11th Alley] , [11th St: 11th St] , ...519 more... )
• Str_Direction ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Str_Direction , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• NE_XStreet ( type: esriFieldTypeString, alias: NE_XStreet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NE_XStreet , Coded Values: [10th St: 10th St] , [10th/11th Alley: 10th/11th Alley] , [11th St: 11th St] , ...519 more... )
• SW_XStreet ( type: esriFieldTypeString, alias: SW_XStreet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SW_XStreet , Coded Values: [10th St: 10th St] , [10th/11th Alley: 10th/11th Alley] , [11th St: 11th St] , ...519 more... )
• Grid ( type: esriFieldTypeString, alias: Grid, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Grid )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• TextAngle0 ( type: esriFieldTypeDouble, alias: TextAngle0, editable: true, nullable: true, defaultValue: null, modelName: TextAngle0 )
• TextAngle33 ( type: esriFieldTypeDouble, alias: TextAngle33, editable: true, nullable: true, defaultValue: null, modelName: TextAngle33 )
• TextOffset0 ( type: esriFieldTypeString, alias: TextOffset0, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TextOffset0 )
• TextOffset33 ( type: esriFieldTypeString, alias: TextOffset33, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TextOffset33 )
• ArchiveNotes ( type: esriFieldTypeString, alias: ArchiveNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ArchiveNotes )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• Phase ( type: esriFieldTypeString, alias: Phase, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Phase , Coded Values: [A: A] , [AB: AB] , [ABC: ABC] , ...15 more... )
• Phasing ( type: esriFieldTypeString, alias: Phasing, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Phasing , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...2 more... )
• BankID ( type: esriFieldTypeString, alias: BankID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: BankID )
• SubType ( type: esriFieldTypeInteger, alias: SubType, editable: true, nullable: true, defaultValue: 0, modelName: SubType )
• IsBank ( type: esriFieldTypeInteger, alias: IsBank, editable: true, nullable: true, defaultValue: null, modelName: IsBank )
• LocateID ( type: esriFieldTypeString, alias: LocateID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LocateID )

Templates:

• Name: Transformer
  Description:
  Prototype:
  IsBank: null
  LocateID: null
  AssetID: XFM
  TilmId: null
  AdministrativeArea: COPA
  OperationalArea: COPA
  LifeCycleStatus: Active
  SubSta: null
  Feeder: null
  FeederPg: null
  Name: null
  Notes: null
  Project: null
  PrimaryImage: null
  Location: null
  Situs: null
  Intersection: null
  Street: null
  Str_Direction: null
  NE_XStreet: null
  SW_XStreet: null
  Grid: null
  Rotation: null
  TextAngle0: null
  TextAngle33: null
  TextOffset0: null
  TextOffset33: null
  ArchiveNotes: null
  Enabled: 1
  AncillaryRole: 0
  Phase: null
  Phasing: null
  BankID: null
  SubType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• TilmPcbData (5) -- Related To: TilmPcbData (38)
• ScanData (6) -- Related To: ScanData (33)
• TransMntc (7) -- Related To: Maintenance (37)
• TransInspect (8) -- Related To: Inspection (39)
• TilmData (9) -- Related To: TilmData (28)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata