View In:   ArcGIS Online Map Viewer

Name: Traffic Signals

Display Field: EQNUM

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: County maintained traffic signal layerThe purpose of this dataset is to maintain an inventory of traffic signal assets associated with DPW. It includes traffic signal assets that are owned and maintained by DPW, owned by cities/state and maintained by DPW, owned by DPW but maintained by city/state.EQNUM – Corresponding asset number in Maximo database (MMS)SIG_TYPE – Type of signal installation and maintaining organizationCDFS - City Maintained Driver Feedback SignDFS – County Maintained Driver Feedback SignR06CS - City Maintained SignalR06SS - State Maintained SignalRO6TS - County Maintained SignalR06TS SOL - County Maintained Signal w/ Solar STATUS – Operating status of asset.MXCREATIONSTATE - Field required to synchronize ArcGIS database with Maximo GIS interfaceLast Updated: 01/2024

Copyright Text: Michael Picardal – 626-458-1700 Keith Shimizu – 626-458-1700

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 6203721.2357813
YMin: 1729108.71040893
XMax: 6664468.47821222
YMax: 2121148.86479811
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveCenter
Label Expression: [EQNUM]
Use Coded Values: true
Symbol:
Color: [230, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 11
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 50000.0
Max. Scale: NaN

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 )
• EQNUM ( type: esriFieldTypeString, alias: EQNUM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EQNUM )
• SIG_TYPE ( type: esriFieldTypeString, alias: SIG_TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SIG_TYPE )
• ID ( type: esriFieldTypeInteger, alias: ID, editable: true, nullable: true, defaultValue: null, modelName: ID )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATUS )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: null, modelName: MXCREATIONSTATE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CW_ASSETID ( type: esriFieldTypeString, alias: Cityworks Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CW_ASSETID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCATION )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 32, defaultValue: null, modelName: STREET )
• XSTREET ( type: esriFieldTypeString, alias: XSTREET, editable: true, nullable: true, length: 32, defaultValue: null, modelName: XSTREET )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DESCRIPTION )
• LONG_DESCRIPTION ( type: esriFieldTypeString, alias: LONG_DESCRIPTION, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LONG_DESCRIPTION )
• MAINTDIST ( type: esriFieldTypeString, alias: MAINTDIST, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAINTDIST )
• SEQUENCE ( type: esriFieldTypeSmallInteger, alias: SEQUENCE, editable: true, nullable: true, defaultValue: null, modelName: SEQUENCE )
• ACCPTDATE ( type: esriFieldTypeDate, alias: Acceptance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACCPTDATE )
• PUSHBTTN ( type: esriFieldTypeSmallInteger, alias: No. Of Push-Button Assemblies, editable: true, nullable: true, defaultValue: null, modelName: PUSHBTTN )
• PROJECTNUM ( type: esriFieldTypeString, alias: Project Number (PCA), editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROJECTNUM )
• IMPLEDATE ( type: esriFieldTypeDate, alias: Implementation of New Timing Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IMPLEDATE )
• AUDIOPED ( type: esriFieldTypeSmallInteger, alias: No. of Audible PED Stations, editable: true, nullable: true, defaultValue: null, modelName: AUDIOPED )
• BBS ( type: esriFieldTypeString, alias: Battery Backup System, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BBS , Coded Values: [TS CAB IN: Traffic Signal Cabinet Internal] , [TS CAB SIDE: Controller Cabinet Side Mount] , [TS CAB TOP: Controller Cabinet Top Mount] , ...4 more... )
• CFMTYP ( type: esriFieldTypeString, alias: Conflict Monitor Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CFMTYP , Coded Values: [210E: 210E] , [210P: 210P] , [2010ECL: 2010ECL] , ...9 more... )
• TSCABTYP ( type: esriFieldTypeString, alias: TS Cabinet Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TSCABTYP , Coded Values: [332: 170E, 170ATC, 2070xxx] , [332/BBS: Refer to BBS=TS CAB IN] , [337G: TYPE 170 PTM] , ...5 more... )
• TSCABMFG ( type: esriFieldTypeString, alias: TS Cabinet Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TSCABMFG , Coded Values: [ECONOLITE: ECONOLITE] , [SAFETRAN: SAFETRAN] , [MC CAIN/SWARCO: MC CAIN/SWARCO] , ...4 more... )
• CONTMFG ( type: esriFieldTypeString, alias: Controller Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTMFG , Coded Values: [MC CAIN/SWARCO: MC CAIN/SWARCO] , [ECONOLITE: ECONOLITE] , [SAFETRAN: SAFETRAN] , ...4 more... )
• CONPRGTP ( type: esriFieldTypeString, alias: Controller Program Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONPRGTP , Coded Values: [BITRANS 233: BITRANS 233] , [CAL-TRANS C8: CAL-TRANS C8] , [LACO-1HC: LACO-1HC] , ...13 more... )
• CONPRGV ( type: esriFieldTypeString, alias: Controller Program Version, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONPRGV )
• CONTTYP ( type: esriFieldTypeString, alias: Controller Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTTYP , Coded Values: [170E/170ATC: 170E/170ATC] , [2070xx: 2070xx] , [ASC/2-2100: ASC/2-2100] , ...3 more... )
• COUNTPED ( type: esriFieldTypeSmallInteger, alias: No. of Countdown PED Modules, editable: true, nullable: true, defaultValue: null, modelName: COUNTPED )
• HIGHVOLT ( type: esriFieldTypeString, alias: High Voltage Lines?, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HIGHVOLT , Coded Values: [Y: Y] , [N: N] )
• HSLACCT ( type: esriFieldTypeString, alias: HSL Electrical Service Acct Num, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HSLACCT )
• INTERCON ( type: esriFieldTypeString, alias: Inter-Connected System, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INTERCON , Coded Values: [FREE: FREE] , [MANUAL: MANUAL] , [GPS: GPS] , ...4 more... )
• JURISCD1 ( type: esriFieldTypeString, alias: Juris 1 - Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: JURISCD1 , Coded Values: [116: 116] , [117: 117] , [118: 118] , ...121 more... )
• JURISCD2 ( type: esriFieldTypeString, alias: Juris 2 - Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: JURISCD2 , Coded Values: [116: 116] , [117: 117] , [118: 118] , ...121 more... )
• JURISCD3 ( type: esriFieldTypeString, alias: Juris 3 - Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: JURISCD3 , Coded Values: [116: 116] , [117: 117] , [118: 118] , ...121 more... )
• JURPER1 ( type: esriFieldTypeDouble, alias: Juris 1 - Percent%, editable: true, nullable: true, defaultValue: null, modelName: JURPER1 )
• JURPER2 ( type: esriFieldTypeDouble, alias: Juris 2 - Percent%, editable: true, nullable: true, defaultValue: null, modelName: JURPER2 )
• JURPER3 ( type: esriFieldTypeDouble, alias: Juris 3 - Percent%, editable: true, nullable: true, defaultValue: null, modelName: JURPER3 )
• METERNO ( type: esriFieldTypeString, alias: Electrical Meter Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: METERNO )
• PEDHEADS ( type: esriFieldTypeSmallInteger, alias: No. of Pedestrian Heads, editable: true, nullable: true, defaultValue: null, modelName: PEDHEADS )
• PREEMPT ( type: esriFieldTypeString, alias: Preemption, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PREEMPT , Coded Values: [EV: EV] , [NONE: NONE] , [RxR 1: RxR 1] , ...1 more... )
• SIGHEADS ( type: esriFieldTypeSmallInteger, alias: No. of Signal Heads, editable: true, nullable: true, defaultValue: null, modelName: SIGHEADS )
• SIGLAMP ( type: esriFieldTypeSmallInteger, alias: No. of Signal Lamps, editable: true, nullable: true, defaultValue: null, modelName: SIGLAMP )
• SRVADDR ( type: esriFieldTypeString, alias: Electrical Service Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SRVADDR )
• SVCACCT ( type: esriFieldTypeString, alias: Electrical Service Account No., editable: true, nullable: true, length: 20, defaultValue: null, modelName: SVCACCT )
• SVCTYPE ( type: esriFieldTypeString, alias: Electrical Service Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SVCTYPE , Coded Values: [OH: OH] , [UG: UG] , [UG Dual Meter: UG Dual Meter] , ...1 more... )
• SYSTYPE ( type: esriFieldTypeString, alias: TS Cabinet System Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SYSTYPE , Coded Values: [GPS: GPS] , [Fiber Optics: Fiber Optics] , [Wireless Radio: Wireless Radio] , ...2 more... )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: Traffic Signals
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CREATED_DATE
• Creator Field: CREATED_USER
• Edit Date Field: LAST_EDITED_DATE
• Editor Field: LAST_EDITED_USER

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata