Name: DPW.Traffic_Signal

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

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6309802.50033145
YMin: 1729108.71040893
XMax: 6664468.47821222
YMax: 2105223.50029886
Spatial Reference: 102645 (2229)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[34,34,145,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: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• EQNUM (type: esriFieldTypeString, alias: EQNUM, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SIG_TYPE (type: esriFieldTypeString, alias: SIG_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MXCREATIONSTATE (type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CW_ASSETID (type: esriFieldTypeString, alias: Cityworks Asset ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• STREET (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• XSTREET (type: esriFieldTypeString, alias: XSTREET, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LONG_DESCRIPTION (type: esriFieldTypeString, alias: LONG_DESCRIPTION, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MAINTDIST (type: esriFieldTypeString, alias: MAINTDIST, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SEQUENCE (type: esriFieldTypeSmallInteger, alias: SEQUENCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACCPTDATE (type: esriFieldTypeDate, alias: Acceptance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PUSHBTTN (type: esriFieldTypeSmallInteger, alias: No. Of Push-Button Assemblies, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJECTNUM (type: esriFieldTypeString, alias: Project Number (PCA), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IMPLEDATE (type: esriFieldTypeDate, alias: Implementation of New Timing Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AUDIOPED (type: esriFieldTypeSmallInteger, alias: No. of Audible PED Stations, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BBS (type: esriFieldTypeString, alias: Battery Backup System, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [210E: 210E], [210P: 210P], [2010ECL: 2010ECL], ... 9 more ...)
• TSCABTYP (type: esriFieldTypeString, alias: TS Cabinet Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ECONOLITE: ECONOLITE], [SAFETRAN: SAFETRAN], [MC CAIN/SWARCO: MC CAIN/SWARCO], ... 4 more ...)
• CONTMFG (type: esriFieldTypeString, alias: Controller Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [MC CAIN/SWARCO: MC CAIN/SWARCO], [ECONOLITE: ECONOLITE], [SAFETRAN: SAFETRAN], ... 4 more ...)
• CONPRGTP (type: esriFieldTypeString, alias: Controller Program Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CONTTYP (type: esriFieldTypeString, alias: Controller Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIGHVOLT (type: esriFieldTypeString, alias: High Voltage Lines?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• HSLACCT (type: esriFieldTypeString, alias: HSL Electrical Service Acct Num, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INTERCON (type: esriFieldTypeString, alias: Inter-Connected System, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [FREE: FREE], [MANUAL: MANUAL], [GPS: GPS], ... 4 more ...)
• JURISCD1 (type: esriFieldTypeString, alias: Juris 1 - Code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [116: 116], [117: 117], [118: 118], ... 121 more ...)
• JURISCD2 (type: esriFieldTypeString, alias: Juris 2 - Code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [116: 116], [117: 117], [118: 118], ... 121 more ...)
• JURISCD3 (type: esriFieldTypeString, alias: Juris 3 - Code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [116: 116], [117: 117], [118: 118], ... 121 more ...)
• JURPER1 (type: esriFieldTypeDouble, alias: Juris 1 - Percent%, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JURPER2 (type: esriFieldTypeDouble, alias: Juris 2 - Percent%, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JURPER3 (type: esriFieldTypeDouble, alias: Juris 3 - Percent%, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METERNO (type: esriFieldTypeString, alias: Electrical Meter Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PEDHEADS (type: esriFieldTypeSmallInteger, alias: No. of Pedestrian Heads, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREEMPT (type: esriFieldTypeString, alias: Preemption, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [EV: EV], [NONE: NONE], [RxR 1: RxR 1], ... 1 more ...)
• SIGHEADS (type: esriFieldTypeSmallInteger, alias: No. of Signal Heads, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGLAMP (type: esriFieldTypeSmallInteger, alias: No. of Signal Lamps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SRVADDR (type: esriFieldTypeString, alias: Electrical Service Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SVCACCT (type: esriFieldTypeString, alias: Electrical Service Account No., SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SVCTYPE (type: esriFieldTypeString, alias: Electrical Service Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OH: OH], [UG: UG], [UG Dual Meter: UG Dual Meter], ... 1 more ...)
• SYSTYPE (type: esriFieldTypeString, alias: TS Cabinet System Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [GPS: GPS], [Fiber Optics: Fiber Optics], [Wireless Radio: Wireless Radio], ... 2 more ...)
• 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)
• SD (type: esriFieldTypeString, alias: Supervisorial District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: DPW.Traffic_Signal
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/13/2025 6:48:51 PM

Schema Last Edit Date: 1/13/2025 6:48:51 PM

Data Last Edit Date: 1/13/2025 6:48:51 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat