Name: dbo.Traffic_Signals_LRS_AGO

Display Field: CHANGE_REVIEW

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: UID

Unique ID Field:

Name : UID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• UID (type: esriFieldTypeOID, alias: UID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SIG_UID (type: esriFieldTypeInteger, alias: SIG_UID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LRS_ID (type: esriFieldTypeInteger, alias: LRS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LRS_AT (type: esriFieldTypeDouble, alias: LRS_AT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHANGE_REVIEW (type: esriFieldTypeString, alias: CHANGE_REVIEW, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• UPDATE_DESCRIPTION (type: esriFieldTypeString, alias: UPDATE_DESCRIPTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_DATE (type: esriFieldTypeDate, alias: REVIEW_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REVIEWER (type: esriFieldTypeString, alias: REVIEWER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REVIEW_NOTES (type: esriFieldTypeString, alias: REVIEW_NOTES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EQUIPMENT_REMOVAL_NEEDED (type: esriFieldTypeSmallInteger, alias: EQUIPMENT_REMOVAL_NEEDED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• LOCATION_LOC_TYPE (type: esriFieldTypeString, alias: LOCATION_LOC_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION_STATUS (type: esriFieldTypeString, alias: LOCATION_STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION_OWNER (type: esriFieldTypeString, alias: LOCATION_OWNER, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LOCATION_MAINTAINER (type: esriFieldTypeString, alias: LOCATION_MAINTAINER, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LOCATION_OFF_MAINT (type: esriFieldTypeSmallInteger, alias: LOCATION_OFF_MAINT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION_STICKER_NEEDED (type: esriFieldTypeSmallInteger, alias: LOCATION_STICKER_NEEDED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CABINET_CONTROLLER (type: esriFieldTypeString, alias: CABINET_CONTROLLER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_CONTROLLER_MOD_NUM (type: esriFieldTypeString, alias: CABINET_CONTROLLER_MOD_NUM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_CONTROLLER_SERIAL (type: esriFieldTypeString, alias: CABINET_CONTROLLER_SERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CABINET_CONTROLLER_SOFTWARE (type: esriFieldTypeString, alias: CABINET_CONTROLLER_SOFTWARE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CABINET_MMU_CMU (type: esriFieldTypeString, alias: CABINET_MMU_CMU, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_MMU_MOD_NUM (type: esriFieldTypeString, alias: CABINET_MMU_MOD_NUM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_MMU_SERIAL (type: esriFieldTypeString, alias: CABINET_MMU_SERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CABINET_PREMP (type: esriFieldTypeString, alias: CABINET_PREMP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_PREMP_MOD_NUM (type: esriFieldTypeString, alias: CABINET_PREMP_MOD_NUM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_TS2 (type: esriFieldTypeString, alias: CABINET_TS2, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• CABINET_COMM_CABINET (type: esriFieldTypeSmallInteger, alias: CABINET_COMM_CABINET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CABINET_ADAPTIVE (type: esriFieldTypeSmallInteger, alias: CABINET_ADAPTIVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CABINET_VEH_COUNT_SYSTEM (type: esriFieldTypeSmallInteger, alias: CABINET_VEH_COUNT_SYSTEM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_FLASHER_POSTMOUNT (type: esriFieldTypeSmallInteger, alias: FIELD_FLASHER_POSTMOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_FLASHER_PEDTYPE (type: esriFieldTypeString, alias: FIELD_FLASHER_PEDTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_FLASHER_OVERHEAD (type: esriFieldTypeSmallInteger, alias: FIELD_FLASHER_OVERHEAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_FLASHER_SOLAR (type: esriFieldTypeSmallInteger, alias: FIELD_FLASHER_SOLAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_FLASHER_LED (type: esriFieldTypeSmallInteger, alias: FIELD_FLASHER_LED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_FLASHER_RRFB (type: esriFieldTypeSmallInteger, alias: FIELD_FLASHER_RRFB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_OPH_EXISTS (type: esriFieldTypeSmallInteger, alias: FIELD_OPH_EXISTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_OPH_DIRECTIONS (type: esriFieldTypeString, alias: FIELD_OPH_DIRECTIONS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_LED_SIGNS (type: esriFieldTypeSmallInteger, alias: FIELD_LED_SIGNS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_STREETLIGHTS (type: esriFieldTypeSmallInteger, alias: FIELD_STREETLIGHTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_STREETLIGHTS_TYPE (type: esriFieldTypeString, alias: FIELD_STREETLIGHTS_TYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FIELD_STREETLIGHTS_MAKE (type: esriFieldTypeString, alias: FIELD_STREETLIGHTS_MAKE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FIELD_STREETLIGHTS_MODEL (type: esriFieldTypeString, alias: FIELD_STREETLIGHTS_MODEL, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FIELD_STREETLIGHTS_MAINT (type: esriFieldTypeString, alias: FIELD_STREETLIGHTS_MAINT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FIELD_STREETLIGHTS_WATTS (type: esriFieldTypeString, alias: FIELD_STREETLIGHTS_WATTS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PED_TYPE (type: esriFieldTypeString, alias: FIELD_PED_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_RR_INTERCONNECT (type: esriFieldTypeSmallInteger, alias: FIELD_RR_INTERCONNECT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_SERVICE (type: esriFieldTypeString, alias: FIELD_SERVICE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_GROUNDING (type: esriFieldTypeString, alias: FIELD_GROUNDING, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PTZ_STATUS (type: esriFieldTypeString, alias: FIELD_PTZ_STATUS, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FIELD_PTZ_QUANTITY (type: esriFieldTypeSmallInteger, alias: FIELD_PTZ_QUANTITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_PTZ1_MAKE (type: esriFieldTypeString, alias: FIELD_PTZ1_MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PTZ1_MODEL (type: esriFieldTypeString, alias: FIELD_PTZ1_MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PTZ1_ENCODER (type: esriFieldTypeString, alias: FIELD_PTZ1_ENCODER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PTZ2_MAKE (type: esriFieldTypeString, alias: FIELD_PTZ2_MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PTZ2_MODEL (type: esriFieldTypeString, alias: FIELD_PTZ2_MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_PTZ2_ENCODER (type: esriFieldTypeString, alias: FIELD_PTZ2_ENCODER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET_SYS_QUANTITY (type: esriFieldTypeSmallInteger, alias: FIELD_DET_SYS_QUANTITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_DET1_TYPE (type: esriFieldTypeString, alias: FIELD_DET1_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET1_DEVICE_QTY (type: esriFieldTypeSmallInteger, alias: FIELD_DET1_DEVICE_QTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_DET1_MAKE (type: esriFieldTypeString, alias: FIELD_DET1_MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET1_MODEL (type: esriFieldTypeString, alias: FIELD_DET1_MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET1_ENCODER (type: esriFieldTypeString, alias: FIELD_DET1_ENCODER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET2_TYPE (type: esriFieldTypeString, alias: FIELD_DET2_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET2_DEVICE_QTY (type: esriFieldTypeSmallInteger, alias: FIELD_DET2_DEVICE_QTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_DET2_MAKE (type: esriFieldTypeString, alias: FIELD_DET2_MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET2_MODEL (type: esriFieldTypeString, alias: FIELD_DET2_MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_DET2_ENCODER (type: esriFieldTypeString, alias: FIELD_DET2_ENCODER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIELD_REFLECTIVE_BACKPLATE (type: esriFieldTypeSmallInteger, alias: FIELD_REFLECTIVE_BACKPLATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPS_MAKE (type: esriFieldTypeString, alias: UPS_MAKE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• UPS_MODEL (type: esriFieldTypeString, alias: UPS_MODEL, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• UPS_INSTALL_DATE (type: esriFieldTypeDate, alias: UPS_INSTALL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UPS_COMM_CABINET_MAKE (type: esriFieldTypeString, alias: UPS_COMM_CABINET_MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UPS_COMM_CABINET_MODEL (type: esriFieldTypeString, alias: UPS_COMM_CABINET_MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATES_TURN_ON (type: esriFieldTypeDate, alias: DATES_TURN_ON, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATES_CONTROLLER_INSTALL (type: esriFieldTypeDate, alias: DATES_CONTROLLER_INSTALL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATES_COMM_CABINET_UPS_INSTALL (type: esriFieldTypeDate, alias: DATES_COMM_CABINET_UPS_INSTALL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATES_LED_INSTALL (type: esriFieldTypeDate, alias: DATES_LED_INSTALL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATES_STREETLIGHTS_INSTALL (type: esriFieldTypeDate, alias: DATES_STREETLIGHTS_INSTALL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMM_WIRELESS (type: esriFieldTypeString, alias: COMM_WIRELESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMM_WIRELESS_LOC (type: esriFieldTypeString, alias: COMM_WIRELESS_LOC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMM_WIRELESS_P2PA (type: esriFieldTypeSmallInteger, alias: COMM_WIRELESS_P2PA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMM_COMM_SYSTEM (type: esriFieldTypeString, alias: COMM_COMM_SYSTEM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMM_CELL_MODEM (type: esriFieldTypeSmallInteger, alias: COMM_CELL_MODEM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMM_CELL_MAKE (type: esriFieldTypeString, alias: COMM_CELL_MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMM_CELL_MODEL (type: esriFieldTypeString, alias: COMM_CELL_MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMM_BLUETOAD (type: esriFieldTypeSmallInteger, alias: COMM_BLUETOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: dbo.Traffic_Signals_LRS_AGO
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/18/2026 7:34:22 PM

Schema Last Edit Date: 2/18/2026 7:34:22 PM

Data Last Edit Date: 2/18/2026 7:34:22 PM

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