Name: Signals

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 1994011.68008518
YMin: 768260.49632737
XMax: 2070663.64662057
YMax: 898368.002880543
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"ownedby","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[104,104,104,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,77,168,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"City of Durham","label":"City of Durham"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"NCDOT","label":"NCDOT"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,194,255],"toColor":[252,179,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,184,255],"toColor":[179,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,225,252,255],"toColor":[187,225,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,227,179,255],"toColor":[252,227,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[231,184,252,255],"toColor":[231,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,233,255],"toColor":[204,252,233,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,248,255],"toColor":[252,212,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,197,252,255],"toColor":[187,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,252,192,255],"toColor":[230,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,198,182,255],"toColor":[252,198,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,218,255],"toColor":[252,207,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,230,210,255],"toColor":[252,230,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,207,255],"toColor":[197,252,207,255]}]}}},"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: ownedby

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: 20, nullable: true, editable: true)
• stateid (type: esriFieldTypeString, alias: NCDOT Inventory ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• cityid (type: esriFieldTypeString, alias: City of Durham Inventory ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• systemid (type: esriFieldTypeString, alias: City of Durham System ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• signaltype (type: esriFieldTypeString, alias: Signal Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: Intersection/Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• signalphases (type: esriFieldTypeSmallInteger, alias: Signal Phases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pedsignalhead (type: esriFieldTypeString, alias: Pedestrian Signal Head, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• preempt (type: esriFieldTypeString, alias: Preemption, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Emergency Vehicle: Emergency Vehicle], [Railroad : Railroad], [Transit: Transit], ... 3 more ...)
• commchannel (type: esriFieldTypeString, alias: Communication Channel, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• cabinstalldate (type: esriFieldTypeDate, alias: Cabinet Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• emnsignal (type: esriFieldTypeString, alias: Electric Meter Number - Signal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• emnlight (type: esriFieldTypeString, alias: Electric Meter Number - Light, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• controltype (type: esriFieldTypeString, alias: Controller Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• signalsystem (type: esriFieldTypeString, alias: Signal System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• signaldocs (type: esriFieldTypeString, alias: Resource URL, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• software (type: esriFieldTypeString, alias: Software, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ASC/3: ASC/3], [McCain: ASC/3])
• ownedby (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [City of Durham: City of Durham], [NCDOT: NCDOT])
• mainby (type: esriFieldTypeString, alias: Managed By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [City of Durham: City of Durham], [NCDOT: NCDOT])
• 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)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive])
• facilityid_int (type: esriFieldTypeInteger, alias: Facility Identifier, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Types:

ID: City of Durham
Name: City of Durham
Domains:

• Field Name: pedsignalhead
  Inherited
  
• Field Name: preempt
  Inherited
  
• Field Name: software
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: mainby
  Inherited
  
• Field Name: status
  Inherited
  
Templates:

Name: City of Durham
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ownedby: City of Durham

---

ID: NCDOT
Name: NCDOT
Domains:

• Field Name: pedsignalhead
  Inherited
  
• Field Name: preempt
  Inherited
  
• Field Name: software
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: mainby
  Inherited
  
• Field Name: status
  Inherited
  
Templates:

Name: NCDOT
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ownedby: NCDOT

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/10/2025 7:44:55 AM

Schema Last Edit Date: 1/10/2025 7:44:55 AM

Data Last Edit Date: 1/10/2025 7:44:55 AM

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