Name: Traffic Pole
Display Field: StreetName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: The spatial location of poles within the cCity of Prince George. Standard poles for traffic signals, sign poles, fence poles, etc. Related feature tables such as TLamp, TSIgn, TPedestrian Signal, etc. have the objects mounted or related to each specific pole.
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: false
Max Record Count: 2000
Supported query Formats: JSON
Use Standardized Queries: True
Extent:
XMin: 506977.579901
YMin: 5963068.212719
XMax: 525536.049151001
YMax: 5986107.946844
Spatial Reference: 26910 (26910)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"SubType","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,52,163,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[128,0,100,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"1","label":"TLightPole"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,93,150,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"4","label":"TMeterPole"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,47,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"5","label":"TPowerPole"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,3,173,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"2","label":"TSignalPole"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[79,0,143,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"3","label":"TSignPole"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: SubType
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- FacilityID (type: esriFieldTypeInteger, alias: FacilityID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LegacyID (type: esriFieldTypeString, alias: LegacyID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LifeCycleStatus (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [ABN: Abandoned], ... 2 more ...)
- SubType (type: esriFieldTypeInteger, alias: SubType, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AssetOwner (type: esriFieldTypeSmallInteger, alias: AssetOwner, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CPG], [-1: RDFFG], [-2: Private], ... 3 more ...)
- AssetManager (type: esriFieldTypeSmallInteger, alias: AssetManager, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asset], [2: Bylaw], [3: Civic Facility], ... 21 more ...)
- AdministrativeArea (type: esriFieldTypeString, alias: AdministrativeArea, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- InstallContractor (type: esriFieldTypeString, alias: InstallContractor, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- OperationalArea (type: esriFieldTypeString, alias: OperationalArea, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- StreetName (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- PrimaryImage (type: esriFieldTypeString, alias: PrimaryImage, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- BoltPattern (type: esriFieldTypeString, alias: BoltPattern, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
- Class (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
- FootingDiameter (type: esriFieldTypeDouble, alias: FootingDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UpperAccess (type: esriFieldTypeInteger, alias: UpperAccess, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- CommJBox (type: esriFieldTypeInteger, alias: CommJBox, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
- Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
- FinishColor (type: esriFieldTypeString, alias: FinishColor, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Red], [2: Blue], [3: Yellow], ... 4 more ...)
- Style (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [DEC: Decorative], [STA: Standard])
- MountType (type: esriFieldTypeString, alias: MountType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
- RecordedLength (type: esriFieldTypeDouble, alias: RecordedLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Diameter (type: esriFieldTypeSmallInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Code1], [0: Unknown], [1: Other])
- Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [WD: Wood], [FG: Fiberglass], [UNK: Unknown], ... 3 more ...)
- MeterYoke (type: esriFieldTypeInteger, alias: MeterYoke, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
- mylegacy (type: esriFieldTypeSmallInteger, alias: mylegacy, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ConditionDate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AcquisitionCost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DeprecationMethod (type: esriFieldTypeString, alias: DeprecationMethod, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- ExpectedLife (type: esriFieldTypeDouble, alias: ExpectedLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ResidualValue (type: esriFieldTypeDouble, alias: ResidualValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
- slightID_old (type: esriFieldTypeSmallInteger, alias: slightID_old, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bstopID_old (type: esriFieldTypeSmallInteger, alias: bstopID_old, SQL Type: sqlTypeOther, nullable: true, editable: true)
- signID_old (type: esriFieldTypeSmallInteger, alias: signID_old, SQL Type: sqlTypeOther, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- BusStop (type: esriFieldTypeInteger, alias: BusStop, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- SubType_TEXT (type: esriFieldTypeString, alias: SubType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Condition (type: esriFieldTypeDouble, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CoFScore (type: esriFieldTypeDouble, alias: CoFScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CoFDate (type: esriFieldTypeDate, alias: CoFDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- RiskScore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DF (type: esriFieldTypeString, alias: DF, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DisconnectType (type: esriFieldTypeString, alias: Disconnect Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Types:
ID: 1
Name: TLightPole
Domains:
- Field Name: LifeCycleStatus
Inherited
- Field Name: AssetOwner
Inherited
- Field Name: AssetManager
Inherited
- Field Name: BoltPattern
Inherited
- Field Name: Class
Inherited
- Field Name: UpperAccess
Inherited
- Field Name: CommJBox
Inherited
- Field Name: Manufacturer
Inherited
- Field Name: FinishColor
Inherited
- Field Name: Style
Inherited
- Field Name: MountType
Inherited
- Field Name: Diameter
Inherited
- Field Name: Material
Inherited
- Field Name: MeterYoke
Inherited
- Field Name: Enabled
Coded Values:[0: False], [1: True]
- Field Name: DisconnectType
Coded Values:[ServBase: Service Base], [RegDiscon: Regular Disconnect], [None: None], More
Templates:
Name: TLightPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: 4
Name: TMeterPole
Domains:
- Field Name: LifeCycleStatus
Inherited
- Field Name: AssetOwner
Inherited
- Field Name: AssetManager
Inherited
- Field Name: BoltPattern
Inherited
- Field Name: Class
Inherited
- Field Name: UpperAccess
Inherited
- Field Name: CommJBox
Inherited
- Field Name: Manufacturer
Inherited
- Field Name: FinishColor
Inherited
- Field Name: Style
Inherited
- Field Name: MountType
Inherited
- Field Name: Diameter
Inherited
- Field Name: Material
Inherited
- Field Name: MeterYoke
Inherited
- Field Name: Enabled
Coded Values:[0: False], [1: True]
- Field Name: DisconnectType
Coded Values:[ServBase: Service Base], [RegDiscon: Regular Disconnect], [None: None], More
Templates:
Name: TMeterPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: 5
Name: TPowerPole
Domains:
- Field Name: LifeCycleStatus
Inherited
- Field Name: AssetOwner
Inherited
- Field Name: AssetManager
Inherited
- Field Name: BoltPattern
Inherited
- Field Name: Class
Inherited
- Field Name: UpperAccess
Inherited
- Field Name: CommJBox
Inherited
- Field Name: Manufacturer
Inherited
- Field Name: FinishColor
Inherited
- Field Name: Style
Inherited
- Field Name: MountType
Inherited
- Field Name: Diameter
Inherited
- Field Name: Material
Inherited
- Field Name: MeterYoke
Inherited
- Field Name: Enabled
Coded Values:[0: False], [1: True]
- Field Name: DisconnectType
Coded Values:[ServBase: Service Base], [RegDiscon: Regular Disconnect], [None: None], More
Templates:
Name: TPowerPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: 2
Name: TSignalPole
Domains:
- Field Name: LifeCycleStatus
Inherited
- Field Name: AssetOwner
Inherited
- Field Name: AssetManager
Inherited
- Field Name: BoltPattern
Inherited
- Field Name: Class
Inherited
- Field Name: UpperAccess
Inherited
- Field Name: CommJBox
Inherited
- Field Name: Manufacturer
Inherited
- Field Name: FinishColor
Inherited
- Field Name: Style
Inherited
- Field Name: MountType
Inherited
- Field Name: Diameter
Inherited
- Field Name: Material
Inherited
- Field Name: MeterYoke
Inherited
- Field Name: Enabled
Coded Values:[0: False], [1: True]
- Field Name: DisconnectType
Coded Values:[ServBase: Service Base], [RegDiscon: Regular Disconnect], [None: None], More
Templates:
Name: TSignalPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
ID: 3
Name: TSignPole
Domains:
- Field Name: LifeCycleStatus
Inherited
- Field Name: AssetOwner
Inherited
- Field Name: AssetManager
Inherited
- Field Name: BoltPattern
Inherited
- Field Name: Class
Inherited
- Field Name: UpperAccess
Inherited
- Field Name: CommJBox
Inherited
- Field Name: Manufacturer
Inherited
- Field Name: FinishColor
Inherited
- Field Name: Style
Inherited
- Field Name: MountType
Inherited
- Field Name: Diameter
Inherited
- Field Name: Material
Inherited
- Field Name: MeterYoke
Inherited
- Field Name: Enabled
Coded Values:[0: False], [1: True]
- Field Name: DisconnectType
Coded Values:[ServBase: Service Base], [RegDiscon: Regular Disconnect], [None: None], More
Templates:
Name: TSignPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/17/2024 3:29:59 AM
Schema Last Edit Date: 4/17/2024 3:29:59 AM
Data Last Edit Date: 4/17/2024 3:29:59 AM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates