View In:   ArcGIS Online Map Viewer

Name: ControlBoxes

Display Field: FEATURE_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This ControlBox layer was created for use with the CityWorks work order and traffic data asset management system of Portland, Maine. Each Control Box is designated by its Feature Type including Traffic Signal Controllers, School Flasher Controllers, PedFlasher Controllers, Traffic Flasher Controllers, Parking Ban Controllers, Speed Monitor Controllers, and Lane Use Controllers. Each Control Boxes has a unique ID and is linked to the unique ID of its respective intersection. Additional data on attributes of control boxes useful for maintenance and management is included. Control boxes were largely digitized based on the GIS layer sde.PORTGIS.TrafficLightControlBoxes originally digitized by Michelle Sweeney in 2006 and in updated by Thea Youngs in 2016, with assistance from Nasir Shir and Kevin Thomas in the summer of 2016 using staff knowledge and 2015 orthoimagery. These were updated 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. In the summer of 2018, fields and domains for all Control Boxes 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 for attributes of assets useful for management and maintenance are included for each ControlBox. 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, Michelle Sweeney, 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: 2907722.819080744
YMin: 295237.7645344883
XMax: 2931414.959688496
YMax: 323488.38519848883
Spatial Reference: 26856  (26856)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FEATURE_TYPE ( type: esriFieldTypeString, alias: FEATURE_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FEATURE_TYPE , Coded Values: [TrafficSignal: Traffic Signal Controller] , [SchoolFlasher: School Flasher Controller] , [PedFlasher: Ped Flasher Controller] , ...3 more... )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• INTERSECTID ( type: esriFieldTypeString, alias: INTERSECTID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERSECTID )
• INTERSECTID_2 ( type: esriFieldTypeString, alias: INTERSECTID_2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERSECTID_2 )
• CMPID ( type: esriFieldTypeString, alias: CMPID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CMPID )
• CABTYPE ( type: esriFieldTypeString, alias: CABTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CABTYPE , Coded Values: [ATC: Advanced Traffic Control] , [NEMA: NEMA] , [Other: Other] , ...2 more... )
• CABSIZE ( type: esriFieldTypeString, alias: Cabinet Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CABSIZE , Coded Values: [Small: Small] , [Medium: Medium] , [Large: Large] )
• CABCOLOR ( type: esriFieldTypeString, alias: CABCOLOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CABCOLOR , Coded Values: [Black: Black] , [Silver: Silver] , [Green: Green] , ...2 more... )
• CABBASE ( type: esriFieldTypeString, alias: CABBASE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CABBASE , Coded Values: [FlushMount: Flush Mount] , [PoleMount: Pole Mount] , [Pedestal: Pedestal] )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• UPS_TYPE ( type: esriFieldTypeString, alias: UPS_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UPS_TYPE , Coded Values: [Battery: Battery] , [Generator: Generator] , [Both: Both] , ...1 more... )
• CTRL_TYPE ( type: esriFieldTypeString, alias: CTRL_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CTRL_TYPE , Coded Values: [Chronomax: Chronomax] , [Multisonic: Multisonic] , [Naztec: Naztec] , ...6 more... )
• CTRL_VERSION ( type: esriFieldTypeString, alias: CTRL_VERSION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CTRL_VERSION )
• CONFLCT_MON_UNIT ( type: esriFieldTypeString, alias: CONFLCT_MON_UNIT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONFLCT_MON_UNIT , Coded Values: [16: 16 Channel] , [12: 12 Channel] , [6: 6 Channel] , ...1 more... )
• GPS_ANTENNA ( type: esriFieldTypeString, alias: GPS_ANTENNA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_ANTENNA , Coded Values: [Yes: Yes] , [No: No] )
• INTERCONNECT_ID ( type: esriFieldTypeString, alias: INTERCONNECT_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERCONNECT_ID )
• INTRCONNECTYPE ( type: esriFieldTypeString, alias: INTRCONNECTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTRCONNECTYPE , Coded Values: [Fiber: Fiber] , [Copper: Copper] , [Radio: Radio] , ...1 more... )
• INTRCONNECTLOC ( type: esriFieldTypeString, alias: INTRCONNECTLOC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTRCONNECTLOC , Coded Values: [ABV_GRND: Above Ground] , [BLW_GRND: Below Ground] , [NONE: None] )
• INTERCONNECT2_ID ( type: esriFieldTypeString, alias: INTERCONNECT2_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERCONNECT2_ID )
• INTERCONNECT2_TYPE ( type: esriFieldTypeString, alias: INTERCONNECT2_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERCONNECT2_TYPE , Coded Values: [Fiber: Fiber] , [Copper: Copper] , [Radio: Radio] , ...1 more... )
• INTERCONNECTLOC2 ( type: esriFieldTypeString, alias: INTERCONNECTLOC2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERCONNECTLOC2 , Coded Values: [ABV_GRND: Above Ground] , [BLW_GRND: Below Ground] , [NONE: None] )
• ADAPTIVE_TYPE ( type: esriFieldTypeString, alias: Adaptive Signal Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADAPTIVE_TYPE , Coded Values: [SurTrac: SurTrac] , [Rhythm: Rhythm] , [None: No Adaptive Signal] , ...1 more... )
• ETHERNET_TYPE ( type: esriFieldTypeString, alias: Ethernet Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ETHERNET_TYPE , Coded Values: [Actelis: Actelis] , [Other: Other Ethernet connection] , [None: No Ethernet connection] )
• CTRL_IP ( type: esriFieldTypeString, alias: CTRL_IP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CTRL_IP )
• SWITCH_IP ( type: esriFieldTypeString, alias: SWITCH_IP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SWITCH_IP )
• CAM_TYPE ( type: esriFieldTypeString, alias: CAM_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CAM_TYPE , Coded Values: [AutoScope: AutoScope] , [Flir: Flir] , [Gridsmart: Gridsmart Camera] , ...11 more... )
• DET_INGROUND ( type: esriFieldTypeString, alias: Inground Detection Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DET_INGROUND , Coded Values: [Loop: Detection Loop] , [ValencePod: Valence Pod] , [None: No Inground Detection] )
• DET_MICRO ( type: esriFieldTypeString, alias: DET_MICRO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DET_MICRO , Coded Values: [Yes: Yes] , [No: No] )
• DET_RADAR ( type: esriFieldTypeString, alias: DET_RADAR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DET_RADAR , Coded Values: [Hawkeye: Hawkeye] , [Trafiradar: Trafiradar] , [Wavetronix: Wavetronix] , ...1 more... )
• E_PREEMPTION ( type: esriFieldTypeString, alias: E_PREEMPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: E_PREEMPTION , Coded Values: [Yes: Yes] , [No: No] )
• RR_PREEMPTION ( type: esriFieldTypeString, alias: RR_PREEMPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RR_PREEMPTION , Coded Values: [Yes: Yes] , [No: No] )
• TRANPREEMPTION ( type: esriFieldTypeString, alias: TRANPREEMPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TRANPREEMPTION , Coded Values: [Yes: Yes] , [No: No] )
• PED_ACT ( type: esriFieldTypeString, alias: PED_ACT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PED_ACT , Coded Values: [ACTU: Actuated] , [CONTROL: Controlled] , [INFRARED: Infrared] , ...1 more... )
• PED_OPS ( type: esriFieldTypeString, alias: PED_OPS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PED_OPS , Coded Values: [EXCL: Exclusive] , [CONC: Concurrent] , [NONE: None] )
• PED_BULB ( type: esriFieldTypeString, alias: PED_BULB, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PED_BULB , Coded Values: [LED: LED] , [LED_COUNTD: LED Countdown] , [INCAN: Incandescent] , ...1 more... )
• TIME_CLOCK ( type: esriFieldTypeString, alias: TIME_CLOCK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TIME_CLOCK , 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... )
• 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 )

Templates:

• Name: ControlBoxes
  Description:
  Prototype:
  LASTEDITOR: null
  LASTUPDATE: null
  FEATURE_TYPE: null
  FACILITYID: null
  INTERSECTID: null
  INTERSECTID_2: null
  CMPID: null
  CABTYPE: null
  CABSIZE: null
  CABCOLOR: null
  CABBASE: null
  LOCATION: null
  UPS_TYPE: null
  CTRL_TYPE: null
  CTRL_VERSION: null
  CONFLCT_MON_UNIT: null
  GPS_ANTENNA: null
  INTERCONNECT_ID: null
  INTRCONNECTYPE: null
  INTRCONNECTLOC: null
  INTERCONNECT2_ID: null
  INTERCONNECT2_TYPE: null
  INTERCONNECTLOC2: null
  ADAPTIVE_TYPE: null
  ETHERNET_TYPE: null
  CTRL_IP: null
  SWITCH_IP: null
  CAM_TYPE: null
  DET_INGROUND: null
  DET_MICRO: null
  DET_RADAR: null
  E_PREEMPTION: null
  RR_PREEMPTION: null
  TRANPREEMPTION: null
  PED_ACT: null
  PED_OPS: null
  PED_BULB: null
  TIME_CLOCK: null
  INSTALLDATE: null
  CONDITION: 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