Name: Pole
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 483698.345326033
YMin: 5449756.46500441
XMax: 498313.848966276
YMax: 5461581.24723116
Spatial Reference: 26910 (26910)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[81,163,122,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
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: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ATTACHID (type: esriFieldTypeString, alias: Attachment ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- INTERSECTID (type: esriFieldTypeString, alias: Intersection Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CABINETID (type: esriFieldTypeString, alias: Cabinet Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- POLESHAPE (type: esriFieldTypeString, alias: Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I-Shape: I-Shape], [Rectangular: Rectangular], [Round: Round], ... 24 more ...)
- MASTARM (type: esriFieldTypeString, alias: Mast Arm Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Single: Single], [Double: Double])
- POLEUSE (type: esriFieldTypeString, alias: Primary Use, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sign: Sign], [Signal: Signal], [Streetlight: Streetlight], ... 3 more ...)
- JOINTUSE (type: esriFieldTypeString, alias: Joint Use, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- HEIGHT (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
- INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
- MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other], ... 52 more ...)
- PAINTDATE (type: esriFieldTypeDate, alias: Paint Date (COV), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DIAMETER (type: esriFieldTypeDouble, alias: Pole Diameter (in) (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- SUBAREA (type: esriFieldTypeString, alias: Subarea (COV), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- UNITDESC (type: esriFieldTypeString, alias: Unit Description (COV), SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
- ORACLEID (type: esriFieldTypeString, alias: Oracle ID (COV), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- FIDFUSEBANK (type: esriFieldTypeInteger, alias: Service Panel ID (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- OWNPERCENT (type: esriFieldTypeDouble, alias: Shared COV % (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ORIENTATION (type: esriFieldTypeDouble, alias: Orientation (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TBFID (type: esriFieldTypeInteger, alias: FID (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- MRN (type: esriFieldTypeString, alias: Major Road Network (COV), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 1 more ...)
- POLENUM (type: esriFieldTypeDouble, alias: Pole # (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- PANELNUM (type: esriFieldTypeString, alias: Service Panel # (COV), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- FLDLOCID (type: esriFieldTypeString, alias: Legacy SLI ID (COV), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LASTINSDATE (type: esriFieldTypeDate, alias: Pole last install date (COV), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ODDPOLE (type: esriFieldTypeString, alias: Odd # Pole (COV), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 1 more ...)
- POLETYPE (type: esriFieldTypeString, alias: Pole Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Fiberglass: Fiberglass], [Concrete: Concrete], [U-Channel: U-Channel], ... 59 more ...)
- MATERIAL (type: esriFieldTypeString, alias: Material (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Steel: Steel], [Aluminum: Aluminum], [Asphalt: Asphalt], ... 18 more ...)
- LOCSYMBOL (type: esriFieldTypeString, alias: Fixture Type (COV), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PU: 2 - Teardrop K 205 Marquis MH 150w/Teardrop K 204 Viscount Induction 85w], [IG: 1 - Sign board 4X40w. Flo. Tubes], [OA: 1 - LightWay Acorn LED 42W], ... 524 more ...)
- BLOCKTYPE (type: esriFieldTypeString, alias: Block Type (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BE: BE], [BL: BL], [BN: BN], ... 209 more ...)
- DATASOURCE (type: esriFieldTypeString, alias: Data Source (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ACAD: ACAD], [ORTHOPHOTO: ORTHOPHOTO], [MUMS: MUMS], ... 6 more ...)
- OWNERSHARED (type: esriFieldTypeString, alias: Pole Shared With (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Parks/CM: Parks-Coast Mountain], [Burnaby: City of Burnaby], [CoastMtn: Coast Mountain], ... 12 more ...)
- OWNEDBY (type: esriFieldTypeString, alias: Owner (COV), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COVNoAV: COV No Asset Valuation], [CP_Rail: CP Rail], [UEL: University Endowment Lands], ... 8 more ...)
- SERVSTATUS (type: esriFieldTypeString, alias: Service Status (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OST_INSTAL: Installed - Out of Service], [u: unknown], [PENDING: Asset is planned], ... 8 more ...)
- LOCATION (type: esriFieldTypeString, alias: Location (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [2nd L/W: 2nd L/W of], [ON: On], [L/S: L/S of], ... 16 more ...)
- POLECOLOR (type: esriFieldTypeString, alias: Pole Color (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [RAL5008: HALE BLUE-DWTN S/KERRISDALEBIA], [RAL6033: Green-Cambie Bridge], [RAL9004: Black-Marpole BIA], ... 36 more ...)
- PAINTTYPE (type: esriFieldTypeString, alias: Paint Type (COV), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Polyester: Polyester], [WetOnGlPct: Wet Paint over Galv P-Coated], [PrimedOnly: Primed Only], ... 11 more ...)
- COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COMPTYPE (type: esriFieldTypeInteger, alias: COMPTYPE (COV), SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Pole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/13/2026 9:13:17 AM
Schema Last Edit Date: 8/13/2026 8:59:28 AM
Data Last Edit Date: 8/13/2026 9:13:17 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat