View In:   ArcGIS Online Map Viewer

Name: TrafficPoles

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This Poles layer was created for use in the CityWorks work order and traffic data asset management system of Portland, Maine. Each Pole is designated by its main Pole Use including Traffic Signal, School Flasher, PedFlasher, Traffic Flasher, Parking Ban, Lane Use, PedLight, Speed Monitor, and PedButton. Each Pole has a unique ID and is linked to the unique ID of its respective Intersection and Controller. Additional data on attributes of Poles useful for maintenance and management is included. For example information on whether a Pole has a Signal, Sign, PedLight, PedButton, and/or Streetlight is present, each as an independent field in boolean format. Poles were digitized by Briana Fischella in the summer of 2018 to current status with a combination of Streetscan imagery, 2015, 2017 and 2018 orthoimagery, and field verification for older imagery and newer infrastructure not captured in most recent imagery. Also in the summer of 2018, fields and domains for all Poles were refined by multiple meetings and discussions with Scott Ouillette, Kevin Thomas, Thea Youngs, Kevin Deneault, Frank Mackie, and Jeremiah Bartlett based on maintenance and management needs of digitized traffic information. These data fields involving attributes of assets useful for management and maintenance are included for each Pole. Ideally, these data will be updated through the CityWorks platform real-time as maintenance and servicing of assets occurs.

Service Item Id: 8596b40e93cd497e8029796f49e3ebde

Copyright Text: Briana Fischella, Scott Ouillette, Kevin Thomas, Thea Youngs, Kevin Deneault, Frank Mackie, Jeremiah Bartlett, Charles Wordell, Cashel Stewart, City of Portland Department of Public Works

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 23999.99999999971

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: 2907616.32848008
YMin: 295148.8578881547
XMax: 2931414.959688496
YMax: 323516.75161156803
Spatial Reference: 26856  (26856)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: POLETYPE
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: Aluminum
  Label: Aluminum
  Description:
  Symbol:
  
• Value: Other
  Label: Other
  Description:
  Symbol:
  
• Value: Steel
  Label: Steel
  Description:
  Symbol:
  
• Value: Wood
  Label: Wood
  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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: POLETYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: FID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INTERSECTI ( type: esriFieldTypeString, alias: INTERSECTI, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INTERSECTI )
• CABINETID ( type: esriFieldTypeString, alias: CABINETID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CABINETID )
• POLETYPE ( type: esriFieldTypeString, alias: POLETYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLETYPE , Coded Values: [Wood: Wood] , [Steel: Steel] , [Aluminum: Aluminum] , ...1 more... )
• MAST_ARM ( type: esriFieldTypeString, alias: MAST_ARM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAST_ARM , Coded Values: [Yes: Yes] , [No: No] )
• MAST_ARM_LEN ( type: esriFieldTypeString, alias: MAST_ARM_LEN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAST_ARM_LEN )
• MAST_ARM_HEIGHT ( type: esriFieldTypeString, alias: MAST_ARM_HEIGHT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAST_ARM_HEIGHT )
• POLE_USE ( type: esriFieldTypeString, alias: POLE_USE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_USE , Coded Values: [TrafficSignal: Traffic Signal] , [PedLight: PedLight] , [PedButton: PedButton] , ...7 more... )
• JOINT_USE ( type: esriFieldTypeString, alias: JOINT_USE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JOINT_USE , Coded Values: [Yes: Yes] , [No: No] )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• SIGNAL ( type: esriFieldTypeString, alias: SIGNAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGNAL , Coded Values: [Yes: Yes] , [No: No] )
• PEDLIGHT ( type: esriFieldTypeString, alias: PEDLIGHT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PEDLIGHT , Coded Values: [Yes: Yes] , [No: No] )
• PEDBUTTON ( type: esriFieldTypeString, alias: PEDBUTTON, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PEDBUTTON , Coded Values: [Yes: Yes] , [No: No] )
• STREETLIGHT ( type: esriFieldTypeString, alias: STREETLIGHT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETLIGHT , Coded Values: [Yes: Yes] , [No: No] )
• SIGN ( type: esriFieldTypeString, alias: SIGN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN , Coded Values: [Yes: Yes] , [No: No] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [VeryGood: Very Good] , [Good: Good] , ...2 more... )
• OWNEDBY ( type: esriFieldTypeString, alias: OWNEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNEDBY , Coded Values: [Portland: City of Portland] , [Private: Private] , [CMP: Central Maine Power] , ...1 more... )
• MAINTBY ( type: esriFieldTypeString, alias: MAINTBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTBY , Coded Values: [Portland: City of Portland] , [Private: Private] , [CMP: Central Maine Power] , ...1 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Aluminum
Name: Aluminum
Domains:
• POLETYPE:
  Inherited
• MAST_ARM:
  Inherited
• POLE_USE:
  Inherited
• JOINT_USE:
  Inherited
• SIGNAL:
  Inherited
• PEDLIGHT:
  Inherited
• PEDBUTTON:
  Inherited
• STREETLIGHT:
  Inherited
• SIGN:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
Templates:
• Name: Aluminum
  Description:
  Prototype:
  LASTEDITOR: null
  LASTUPDATE: null
  FACILITYID: null
  INTERSECTI: null
  CABINETID: null
  POLETYPE: Aluminum
  MAST_ARM: null
  MAST_ARM_LEN: null
  MAST_ARM_HEIGHT: null
  POLE_USE: null
  JOINT_USE: null
  LOCATION: null
  SIGNAL: null
  PEDLIGHT: null
  PEDBUTTON: null
  STREETLIGHT: null
  SIGN: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Other
Name: Other
Domains:
• POLETYPE:
  Inherited
• MAST_ARM:
  Inherited
• POLE_USE:
  Inherited
• JOINT_USE:
  Inherited
• SIGNAL:
  Inherited
• PEDLIGHT:
  Inherited
• PEDBUTTON:
  Inherited
• STREETLIGHT:
  Inherited
• SIGN:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  LASTEDITOR: null
  LASTUPDATE: null
  FACILITYID: null
  INTERSECTI: null
  CABINETID: null
  POLETYPE: Other
  MAST_ARM: null
  MAST_ARM_LEN: null
  MAST_ARM_HEIGHT: null
  POLE_USE: null
  JOINT_USE: null
  LOCATION: null
  SIGNAL: null
  PEDLIGHT: null
  PEDBUTTON: null
  STREETLIGHT: null
  SIGN: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Steel
Name: Steel
Domains:
• POLETYPE:
  Inherited
• MAST_ARM:
  Inherited
• POLE_USE:
  Inherited
• JOINT_USE:
  Inherited
• SIGNAL:
  Inherited
• PEDLIGHT:
  Inherited
• PEDBUTTON:
  Inherited
• STREETLIGHT:
  Inherited
• SIGN:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
Templates:
• Name: Steel
  Description:
  Prototype:
  LASTEDITOR: null
  LASTUPDATE: null
  FACILITYID: null
  INTERSECTI: null
  CABINETID: null
  POLETYPE: Steel
  MAST_ARM: null
  MAST_ARM_LEN: null
  MAST_ARM_HEIGHT: null
  POLE_USE: null
  JOINT_USE: null
  LOCATION: null
  SIGNAL: null
  PEDLIGHT: null
  PEDBUTTON: null
  STREETLIGHT: null
  SIGN: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Wood
Name: Wood
Domains:
• POLETYPE:
  Inherited
• MAST_ARM:
  Inherited
• POLE_USE:
  Inherited
• JOINT_USE:
  Inherited
• SIGNAL:
  Inherited
• PEDLIGHT:
  Inherited
• PEDBUTTON:
  Inherited
• STREETLIGHT:
  Inherited
• SIGN:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
Templates:
• Name: Wood
  Description:
  Prototype:
  LASTEDITOR: null
  LASTUPDATE: null
  FACILITYID: null
  INTERSECTI: null
  CABINETID: null
  POLETYPE: Wood
  MAST_ARM: null
  MAST_ARM_LEN: null
  MAST_ARM_HEIGHT: null
  POLE_USE: null
  JOINT_USE: null
  LOCATION: null
  SIGNAL: null
  PEDLIGHT: null
  PEDBUTTON: null
  STREETLIGHT: null
  SIGN: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

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