Name: ITSSQLSandbox.DBO.VW_EVENTCOMBINED_OPERATORDASHBOARD_ERAdded

Display Field: CTUSER_FNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 1b50174a3b2b41729bcf47284bfe846a

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 10000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EVENT_ID_1 ( type: esriFieldTypeDouble, alias: EVENT_ID_1 )
• EVENT_ID ( type: esriFieldTypeDouble, alias: EVENT_ID )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• TITLE ( type: esriFieldTypeString, alias: TITLE, length: 64 )
• MODIFIED_DATE ( type: esriFieldTypeDate, alias: MODIFIED_DATE, length: 8 )
• Expr1 ( type: esriFieldTypeString, alias: Expr1, length: 64 )
• MODIFIED_NUM ( type: esriFieldTypeInteger, alias: MODIFIED_NUM )
• SYS_CONFIRMED_DATE ( type: esriFieldTypeDate, alias: SYS_CONFIRMED_DATE, length: 8 )
• SYS_CLOSED_DATE ( type: esriFieldTypeDate, alias: SYS_CLOSED_DATE, length: 8 )
• DETECTED_DATE ( type: esriFieldTypeDate, alias: DETECTED_DATE, length: 8 )
• EVENTSTATUS_ID ( type: esriFieldTypeDouble, alias: EVENTSTATUS_ID )
• EVENTSTATUS_DATE ( type: esriFieldTypeDate, alias: EVENTSTATUS_DATE, length: 8 )
• OWNEDBY_USER_ID ( type: esriFieldTypeDouble, alias: OWNEDBY_USER_ID )
• OWNED_DATE ( type: esriFieldTypeDate, alias: OWNED_DATE, length: 8 )
• OWNEDBY_ORG_ID ( type: esriFieldTypeDouble, alias: OWNEDBY_ORG_ID )
• NOTIFIER_AGENCY_ID ( type: esriFieldTypeDouble, alias: NOTIFIER_AGENCY_ID )
• NOTIFIER_CONTACT_ID ( type: esriFieldTypeDouble, alias: NOTIFIER_CONTACT_ID )
• POLICE_INCIDENTNO ( type: esriFieldTypeString, alias: POLICE_INCIDENTNO, length: 64 )
• EVENTTYPE_ID ( type: esriFieldTypeDouble, alias: EVENTTYPE_ID )
• HAS_NOAPPLICABLE_CCTV ( type: esriFieldTypeSmallInteger, alias: HAS_NOAPPLICABLE_CCTV )
• CCTV_ID ( type: esriFieldTypeString, alias: CCTV_ID, length: 30 )
• CCTV_ASSIGNED_DATE ( type: esriFieldTypeDate, alias: CCTV_ASSIGNED_DATE, length: 8 )
• CCTV_PRESET ( type: esriFieldTypeDouble, alias: CCTV_PRESET )
• PRIMARY_EVENT_ID ( type: esriFieldTypeDouble, alias: PRIMARY_EVENT_ID )
• INJURYTYPE_ID ( type: esriFieldTypeDouble, alias: INJURYTYPE_ID )
• POINT_LATITUDE ( type: esriFieldTypeDouble, alias: POINT_LATITUDE )
• POINT_LONGITUDE ( type: esriFieldTypeDouble, alias: POINT_LONGITUDE )
• CAN_PUBLISH ( type: esriFieldTypeSmallInteger, alias: CAN_PUBLISH )
• EVENTTYPE_DATE ( type: esriFieldTypeDate, alias: EVENTTYPE_DATE, length: 8 )
• ATIS_SEVERITY_LEVEL ( type: esriFieldTypeString, alias: ATIS_SEVERITY_LEVEL, length: 15 )
• ATIS_SEVERITY_DATE ( type: esriFieldTypeDate, alias: ATIS_SEVERITY_DATE, length: 8 )
• SAE_MESSAGE ( type: esriFieldTypeString, alias: SAE_MESSAGE, length: 2048 )
• EMLOC_CREATED_BY ( type: esriFieldTypeString, alias: EMLOC_CREATED_BY, length: 64 )
• EMLOC_MODIFIED_DATE ( type: esriFieldTypeDate, alias: EMLOC_MODIFIED_DATE, length: 8 )
• EMLOC_MODIFIED_BY ( type: esriFieldTypeString, alias: EMLOC_MODIFIED_BY, length: 64 )
• EMLOC_DESCRIPTION ( type: esriFieldTypeString, alias: EMLOC_DESCRIPTION, length: 500 )
• EMLOC_BLOCKAGE_DESCRIPTION ( type: esriFieldTypeString, alias: EMLOC_BLOCKAGE_DESCRIPTION, length: 500 )
• EMLOC_FIRST_LANE_BLOCKED_DATE ( type: esriFieldTypeDate, alias: EMLOC_FIRST_LANE_BLOCKED_DATE, length: 8 )
• EMLOC_LANES_REOPENED_DATE ( type: esriFieldTypeDate, alias: EMLOC_LANES_REOPENED_DATE, length: 8 )
• EMLOC_SET_DATE ( type: esriFieldTypeDate, alias: EMLOC_SET_DATE, length: 8 )
• EMLOC_BLOCKAGE_SET_DATE ( type: esriFieldTypeDate, alias: EMLOC_BLOCKAGE_SET_DATE, length: 8 )
• EMLOC_ALLOW_UNCONFIRMED_BLOCKAG ( type: esriFieldTypeSmallInteger, alias: EMLOC_ALLOW_UNCONFIRMED_BLOCKAG )
• EMLOC_CONGESTION_DESCRIPTION ( type: esriFieldTypeString, alias: EMLOC_CONGESTION_DESCRIPTION, length: 500 )
• EMLOC_CONGESTION_SET_DATE ( type: esriFieldTypeDate, alias: EMLOC_CONGESTION_SET_DATE, length: 8 )
• EMLOC_CONGESTION_CLEARED_DATE ( type: esriFieldTypeDate, alias: EMLOC_CONGESTION_CLEARED_DATE, length: 8 )
• CTUSER_FNAME ( type: esriFieldTypeString, alias: CTUSER_FNAME, length: 128 )
• CTUSER_LNAME ( type: esriFieldTypeString, alias: CTUSER_LNAME, length: 128 )
• CTUSER_EMAIL ( type: esriFieldTypeString, alias: CTUSER_EMAIL, length: 64 )
• EMRESP_ACTIVATED_DATE ( type: esriFieldTypeDate, alias: EMRESP_ACTIVATED_DATE, length: 8 )
• EMRESP_TERMINATED_DATE ( type: esriFieldTypeDate, alias: EMRESP_TERMINATED_DATE, length: 8 )
• EMRESP_RESPONSEPLAN_ITEM_TYPE ( type: esriFieldTypeString, alias: EMRESP_RESPONSEPLAN_ITEM_TYPE, length: 20 )
• EMRESP_DMS_NAME ( type: esriFieldTypeString, alias: EMRESP_DMS_NAME, length: 256 )
• DMS_MESSAGE_MULTITEXT ( type: esriFieldTypeString, alias: DMS_MESSAGE_MULTITEXT, length: 2048 )
• EMRR_VEHICLE_NAME ( type: esriFieldTypeDouble, alias: EMRR_VEHICLE_NAME )
• EMRR_BELONGTO_AGENCY_ID ( type: esriFieldTypeDouble, alias: EMRR_BELONGTO_AGENCY_ID )
• EMRR_DRIVER_NAME ( type: esriFieldTypeDouble, alias: EMRR_DRIVER_NAME )
• EMRR_DISPATCHED_DATE ( type: esriFieldTypeDate, alias: EMRR_DISPATCHED_DATE, length: 8 )
• EMRR_ARRIVAL_DATE ( type: esriFieldTypeDate, alias: EMRR_ARRIVAL_DATE, length: 8 )
• EMRR_DEPARTURE_DATE ( type: esriFieldTypeDate, alias: EMRR_DEPARTURE_DATE, length: 8 )
• EMRR_CANCELED_DATE ( type: esriFieldTypeDate, alias: EMRR_CANCELED_DATE, length: 8 )
• CalcI_AlerttoSGActiveTime ( type: esriFieldTypeInteger, alias: CalcI_AlerttoSGActiveTime )
• CalcK_FirstAlerttoLocationConfi ( type: esriFieldTypeInteger, alias: CalcK_FirstAlerttoLocationConfi )
• CalcN_FirstAlerttoRoadRangerTim ( type: esriFieldTypeInteger, alias: CalcN_FirstAlerttoRoadRangerTim )
• CalcX_InitialLaneBlocktoRPGTime ( type: esriFieldTypeInteger, alias: CalcX_InitialLaneBlocktoRPGTime )
• CalcAA_SGActiveTimetoPrimaryDMS ( type: esriFieldTypeInteger, alias: CalcAA_SGActiveTimetoPrimaryDMS )
• CalcAM_RoadwayClearance ( type: esriFieldTypeInteger, alias: CalcAM_RoadwayClearance )
• CalcAO_RPGTermTimetoRoadwayClea ( type: esriFieldTypeInteger, alias: CalcAO_RPGTermTimetoRoadwayClea )
• Agency_1 ( type: esriFieldTypeInteger, alias: Agency_1 )
• Agency_159 ( type: esriFieldTypeInteger, alias: Agency_159 )
• Agency_179 ( type: esriFieldTypeInteger, alias: Agency_179 )
• Agency_204 ( type: esriFieldTypeInteger, alias: Agency_204 )
• AGENCY_ID1 ( type: esriFieldTypeDate, alias: AGENCY_ID1, length: 8 )
• AGENCY_ID159 ( type: esriFieldTypeDate, alias: AGENCY_ID159, length: 8 )
• AGENCY_ID179 ( type: esriFieldTypeDate, alias: AGENCY_ID179, length: 8 )
• AGENCY_ID203 ( type: esriFieldTypeDate, alias: AGENCY_ID203, length: 8 )
• AGENCY_ID204 ( type: esriFieldTypeDate, alias: AGENCY_ID204, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata