View In:   ArcGIS Online Map Viewer

Name: Pole

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 2500.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 12700.2479999997
YMin: 5532604.854
XMax: 31434.2520000003
YMax: 5552876.724
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Pole
  Description:
  Symbol:
  
• Value: 2
  Label: Pole
  Description:
  Symbol:
  
• Value: 4
  Label: Pole
  Description:
  Symbol:
  
• Value: 6
  Label: Pole
  Description:
  Symbol:
  
• Value: 3
  Label: Foreign
  Description:
  Symbol:
  
• Value: 5
  Label: Traffic Light
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPECD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• FIELDVERIFY ( type: esriFieldTypeString, alias: FieldVerify?, editable: true, nullable: true, length: 5, defaultValue: 0, modelName: FieldVerify , Coded Values: [0: No] , [1: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• CREATIONUSER ( type: esriFieldTypeString, alias: CreationUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• LASTUSER ( type: esriFieldTypeString, alias: LastEditUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LastUser )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: LastEditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• SYMBOLROTATION ( type: esriFieldTypeSingle, alias: SymbolRotation, editable: true, nullable: true, defaultValue: null, modelName: SYMBOLROTATION )
• GPSDATE ( type: esriFieldTypeDate, alias: GPSDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCode, editable: true, nullable: true, defaultValue: 2, modelName: SubtypeCD )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: CompatibleUnitID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [1020: Combination Tr St Lt 11m Davit Galvanized] , [1021: Combination Tr St Lt 13m Davit Galvanized] , [1022: Combination Tr St Lt 15m Davit Galvanized] , ...91 more... )
• FEATURE_STATUS ( type: esriFieldTypeString, alias: FEATURE_STATUS, editable: true, nullable: false, length: 10, defaultValue: Existing, modelName: FEATURE_STATUS , Coded Values: [Existing: Existing Feature] , [New: New Feature] , [Proposed: Proposed Feature] , ...2 more... )
• STREETLIGHT_FACILITY ( type: esriFieldTypeString, alias: STREETLIGHT_FACILITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETLIGHT_FACILITY )
• REPLACED_DATE_MM_DD_YYYY ( type: esriFieldTypeDate, alias: REPLACED_DATE_MM_DD_YYYY, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPLACED_DATE_MM_DD_YYYY )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DEVICENUMBER )
• CONDITION_STLT ( type: esriFieldTypeSmallInteger, alias: CONDITION St.Lt., editable: true, nullable: true, defaultValue: 0, modelName: CONDITION , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• CONDITION_STATUS ( type: esriFieldTypeString, alias: CONDITION_STATUS, editable: true, nullable: true, length: 50, defaultValue: 1, modelName: CONDITION_STATUS , Coded Values: [1: New] , [2: Pass] , [3: Marginal] , ...1 more... )
• CONDITION_DATE ( type: esriFieldTypeDate, alias: CONDITION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_DATE )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RULEID , Coded Values: [1: Distribution] , [2: Transmission] , [3: Foreign] , ...5 more... )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• PORCELAINCUTOUTS ( type: esriFieldTypeInteger, alias: Porcelain Cutouts?, editable: true, nullable: true, defaultValue: null, modelName: PORCELAININSULATORS , Coded Values: [0: No] , [1: Yes] )
• DIAMETER ( type: esriFieldTypeSingle, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• DECAY ( type: esriFieldTypeInteger, alias: Decay %, editable: true, nullable: true, defaultValue: null, modelName: DECAY )
• CAVITY ( type: esriFieldTypeInteger, alias: Cavity %, editable: true, nullable: true, defaultValue: null, modelName: CAVITY )
• SHELL ( type: esriFieldTypeSingle, alias: Shell, editable: true, nullable: true, defaultValue: null, modelName: SHELL )
• VISUALABOVEGROUND ( type: esriFieldTypeString, alias: Visual Above Ground, editable: true, nullable: true, length: 100, defaultValue: null, modelName: VISUALABOVEGROUND )
• ORIGINALTREATMENT ( type: esriFieldTypeSmallInteger, alias: Original Treatment, editable: true, nullable: true, defaultValue: null, modelName: ORIGINALTREATMENT , Coded Values: [1: Penta - Full] , [2: Penta - Butt] , [3: Penta - Unknown] , ...4 more... )
• REMEDIALTREATMENT ( type: esriFieldTypeSmallInteger, alias: Remedial Treatment, editable: true, nullable: true, defaultValue: null, modelName: REMEDIALTREATMENT , Coded Values: [1: Fumigant] , [2: 3 Cobra Rods] , [3: 3 Cobra Rods & Liquid] , ...11 more... )
• REMEDIALTREATMENTDATE ( type: esriFieldTypeDate, alias: Remedial Treatment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REMEDIALTREATMENTDATE )
• GROUNDRODRESISTANCE_OHMS ( type: esriFieldTypeSingle, alias: GroundRodResistance_Ohms, editable: true, nullable: true, defaultValue: null, modelName: GROUNDRODRESISTANCE_OHMS )
• CUTOUTINSULATORMANUFACTURER ( type: esriFieldTypeString, alias: CUTOUTINSULATORMANUFACTURER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CUTOUTINSULATORMANUFACTURER , Coded Values: [0: Unknown] , [ABB: ABB] , [C: Chance] , ...7 more... )
• INSULATOR_MATERIAL ( type: esriFieldTypeInteger, alias: INSULATOR_MATERIAL, editable: true, nullable: true, defaultValue: null, modelName: INSULATOR_MATERIAL , Coded Values: [1281: Porcelain] , [1282: Polymer] , [0: Unknown] )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project?, editable: true, nullable: true, defaultValue: 0, modelName: CITYWORKSPROJECT , Coded Values: [0: No] , [1: Yes] )
• FIREHARDENING ( type: esriFieldTypeString, alias: FIREHARDENING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIREHARDENING , Coded Values: [GenFM9: Genics Fire Mesh - 9ft] , [GenFM6: Genics Fire Mesh - 6ft] , [GenFM3: Genics Fire Mesh - 3ft] )
• FIREHARDENINGDATE ( type: esriFieldTypeDate, alias: FIREHARDENINGDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIREHARDENINGDATE )
• REMAININGSTRENGTH ( type: esriFieldTypeInteger, alias: REMAININGSTRENGTH, editable: true, nullable: true, defaultValue: null, modelName: REMAININGSTRENGTH )

Types:

ID: 1
Name: Distribution
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [370: PoleWood 30ft Class 3 WRC] , [168: PoleWood 35ft Class 3 WRC] , [1451: PoleWood 40ft Class 1 WRC] , ...59 more...
• STREETLIGHT_FACILITY:
  Coded Values: [STLT-REN: Streetlights-rental lights] , [LT-OTHER: Lights - Other] , [STLT-MED: Streetlights-in Medicine Hat (529760)] , ...8 more...
• RULEID:
  Inherited
Templates:
• Name: Wood - Distribution
  Description:
  Prototype:
  INSTALLATIONDATE: null
  FIREHARDENING: null
  CITYWORKSPROJECT: null
  DATEMODIFIED: null
  FIREHARDENINGDATE: null
  GPSDATE: null
  OWNERSHIP: null
  COMPATIBLEUNITID: 362
  REMAININGSTRENGTH: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SYMBOLROTATION: 0
  SUBTYPECD: 1
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION_STLT: null
  CONDITION_STATUS: null
  CONDITION_DATE: null
  RULEID: null
  ASSETID: null
  PORCELAINCUTOUTS: null
  DIAMETER: null
  DECAY: null
  CAVITY: null
  SHELL: null
  VISUALABOVEGROUND: null
  ORIGINALTREATMENT: null
  REMEDIALTREATMENT: null
  REMEDIALTREATMENTDATE: null
  GROUNDRODRESISTANCE_OHMS: null
  CUTOUTINSULATORMANUFACTURER: null
  INSULATOR_MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Distribution And Transmission
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [370: PoleWood 30ft Class 3 WRC] , [168: PoleWood 35ft Class 3 WRC] , [1451: PoleWood 40ft Class 1 WRC] , ...59 more...
• FEATURE_STATUS:
  Inherited
• STREETLIGHT_FACILITY:
  Coded Values: [STLT-REN: Streetlights-rental lights] , [LT-OTHER: Lights - Other] , [STLT-MED: Streetlights-in Medicine Hat (529760)] , ...8 more...
• CONDITION_STLT:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Wood - Transmission
  Description:
  Prototype:
  INSTALLATIONDATE: null
  FIREHARDENING: null
  CITYWORKSPROJECT: null
  DATEMODIFIED: null
  FIREHARDENINGDATE: null
  GPSDATE: null
  OWNERSHIP: null
  COMPATIBLEUNITID: 364
  REMAININGSTRENGTH: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SYMBOLROTATION: 0
  SUBTYPECD: 2
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION_STLT: null
  CONDITION_STATUS: null
  CONDITION_DATE: null
  RULEID: null
  ASSETID: null
  PORCELAINCUTOUTS: null
  DIAMETER: null
  DECAY: null
  CAVITY: null
  SHELL: null
  VISUALABOVEGROUND: null
  ORIGINALTREATMENT: null
  REMEDIALTREATMENT: null
  REMEDIALTREATMENTDATE: null
  GROUNDRODRESISTANCE_OHMS: null
  CUTOUTINSULATORMANUFACTURER: null
  INSULATOR_MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Multi-Structure
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [370: PoleWood 30ft Class 3 WRC] , [168: PoleWood 35ft Class 3 WRC] , [1451: PoleWood 40ft Class 1 WRC] , ...59 more...
• RULEID:
  Inherited
Templates:
• Name: Wood - Multi
  Description:
  Prototype:
  INSTALLATIONDATE: null
  FIREHARDENING: null
  CITYWORKSPROJECT: null
  DATEMODIFIED: null
  FIREHARDENINGDATE: null
  GPSDATE: null
  OWNERSHIP: null
  COMPATIBLEUNITID: 362
  REMAININGSTRENGTH: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SYMBOLROTATION: 0
  SUBTYPECD: 4
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION_STLT: null
  CONDITION_STATUS: null
  CONDITION_DATE: null
  RULEID: null
  ASSETID: null
  PORCELAINCUTOUTS: null
  DIAMETER: null
  DECAY: null
  CAVITY: null
  SHELL: null
  VISUALABOVEGROUND: null
  ORIGINALTREATMENT: null
  REMEDIALTREATMENT: null
  REMEDIALTREATMENTDATE: null
  GROUNDRODRESISTANCE_OHMS: null
  CUTOUTINSULATORMANUFACTURER: null
  INSULATOR_MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Steel Tower
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1339: A-Frame Tower] , [1340: Lattic Tower]
• RULEID:
  Inherited
Templates:
• Name: Steel Tower
  Description:
  Prototype:
  INSTALLATIONDATE: null
  FIREHARDENING: null
  CITYWORKSPROJECT: null
  DATEMODIFIED: null
  FIREHARDENINGDATE: null
  GPSDATE: null
  OWNERSHIP: null
  COMPATIBLEUNITID: 999
  REMAININGSTRENGTH: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SYMBOLROTATION: 0
  SUBTYPECD: 6
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION_STLT: null
  CONDITION_STATUS: null
  CONDITION_DATE: null
  RULEID: null
  ASSETID: null
  PORCELAINCUTOUTS: null
  DIAMETER: null
  DECAY: null
  CAVITY: null
  SHELL: null
  VISUALABOVEGROUND: null
  ORIGINALTREATMENT: null
  REMEDIALTREATMENT: null
  REMEDIALTREATMENTDATE: null
  GROUNDRODRESISTANCE_OHMS: null
  CUTOUTINSULATORMANUFACTURER: null
  INSULATOR_MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Foreign
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [370: PoleWood 30ft Class 3 WRC] , [168: PoleWood 35ft Class 3 WRC] , [1451: PoleWood 40ft Class 1 WRC] , ...59 more...
• RULEID:
  Inherited
Templates:
• Name: Wood - Foreign
  Description:
  Prototype:
  INSTALLATIONDATE: null
  FIREHARDENING: null
  CITYWORKSPROJECT: null
  DATEMODIFIED: null
  FIREHARDENINGDATE: null
  GPSDATE: null
  OWNERSHIP: null
  COMPATIBLEUNITID: 362
  REMAININGSTRENGTH: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SYMBOLROTATION: 0
  SUBTYPECD: 3
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION_STLT: null
  CONDITION_STATUS: null
  CONDITION_DATE: null
  RULEID: null
  ASSETID: null
  PORCELAINCUTOUTS: null
  DIAMETER: null
  DECAY: null
  CAVITY: null
  SHELL: null
  VISUALABOVEGROUND: null
  ORIGINALTREATMENT: null
  REMEDIALTREATMENT: null
  REMEDIALTREATMENTDATE: null
  GROUNDRODRESISTANCE_OHMS: null
  CUTOUTINSULATORMANUFACTURER: null
  INSULATOR_MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Traffic Light Pole
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1031: Standard - Steel - 70ft - Galvanized - Sportfield] , [1355: Standard - Steel - 3.5 m - Black Traditional] , [1373: Standard - Steel - 6 m - St Lt 2.5m Davit - Galvanized] , ...36 more...
• STREETLIGHT_FACILITY:
  Coded Values: [STLT-REN: Streetlights-rental lights] , [LT-OTHER: Lights - Other] , [STLT-MED: Streetlights-in Medicine Hat (529760)] , ...8 more...
• RULEID:
  Inherited
Templates:
• Name: Steel - Traffic Light
  Description:
  Prototype:
  INSTALLATIONDATE: null
  FIREHARDENING: null
  CITYWORKSPROJECT: null
  DATEMODIFIED: null
  FIREHARDENINGDATE: null
  GPSDATE: null
  OWNERSHIP: null
  COMPATIBLEUNITID: 999
  REMAININGSTRENGTH: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SYMBOLROTATION: 0
  SUBTYPECD: 5
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION_STLT: null
  CONDITION_STATUS: null
  CONDITION_DATE: null
  RULEID: null
  ASSETID: null
  PORCELAINCUTOUTS: null
  DIAMETER: null
  DECAY: null
  CAVITY: null
  SHELL: null
  VISUALABOVEGROUND: null
  ORIGINALTREATMENT: null
  REMEDIALTREATMENT: null
  REMEDIALTREATMENTDATE: null
  GROUNDRODRESISTANCE_OHMS: null
  CUTOUTINSULATORMANUFACTURER: null
  INSULATOR_MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• ACE.SecondaryOpenPoint (3) -- Related To: Open Point Secondary (47)
• ACE.ConductorConnectors (4) -- Related To: Conductor Connections (7)

Capabilities: Query,Extract

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata