ArcGIS REST Services Directory
Login
Home
>
services
>
SunStoreApplications
>
OperationsDashboard_ServiceWithViews3 (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (SunStoreApplications/OperationsDashboard_ServiceWithViews3)
Tables:
Table:
ITSSQLSandbox.DBO.VW_EVENTCOMBINED_OPERATORDASHBOARD_ERAdded
(1)
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 )
Table:
ITSSQLSandbox.DBO.VW_EVENTCOMMENT_OPERATORDASHBOARD
(2)
Name:
ITSSQLSandbox.DBO.VW_EVENTCOMMENT_OPERATORDASHBOARD
Display Field:
SUBMITTEDBY_NAME
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_COMMENT_ID
( type: esriFieldTypeDouble, alias: EVENT_COMMENT_ID )
EVENT_ID
( type: esriFieldTypeDouble, alias: EVENT_ID )
CREATED_DATE
( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
CREATED_BY
( type: esriFieldTypeString, alias: CREATED_BY, length: 128 )
MODIFIED_DATE
( type: esriFieldTypeDate, alias: MODIFIED_DATE, length: 8 )
MODIFIED_BY
( type: esriFieldTypeString, alias: MODIFIED_BY, length: 128 )
MODIFIED_NUM
( type: esriFieldTypeInteger, alias: MODIFIED_NUM )
SUBMITTEDBY_NAME
( type: esriFieldTypeString, alias: SUBMITTEDBY_NAME, length: 128 )
SUBMITTED_DATE
( type: esriFieldTypeDate, alias: SUBMITTED_DATE, length: 8 )
COMMENTTYPE_ID
( type: esriFieldTypeDouble, alias: COMMENTTYPE_ID )
COMMENT_TEXT
( type: esriFieldTypeString, alias: COMMENT_TEXT, length: 1000 )
Table:
ITSSQLSandbox.DBO.VW_EVENTATTRIBUTECOMBINED_OPERATORDASHBOARD
(3)
Name:
ITSSQLSandbox.DBO.VW_EVENTATTRIBUTECOMBINED_OPERATORDASHBOARD
Display Field:
SHORT_NAME
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 )
SORT_ORDER
( type: esriFieldTypeDouble, alias: SORT_ORDER )
EVENT_ID
( type: esriFieldTypeDouble, alias: EVENT_ID )
ATTRIBUTETYPE_ID
( type: esriFieldTypeDouble, alias: ATTRIBUTETYPE_ID )
CREATED_DATE
( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
CREATED_BY
( type: esriFieldTypeString, alias: CREATED_BY, length: 128 )
MODIFIED_DATE
( type: esriFieldTypeDate, alias: MODIFIED_DATE, length: 8 )
MODIFIED_BY
( type: esriFieldTypeString, alias: MODIFIED_BY, length: 128 )
CEASED_DATE
( type: esriFieldTypeDate, alias: CEASED_DATE, length: 8 )
CEASED_USE
( type: esriFieldTypeSmallInteger, alias: CEASED_USE )
SHORT_NAME
( type: esriFieldTypeString, alias: SHORT_NAME, length: 20 )
LONG_NAME
( type: esriFieldTypeString, alias: LONG_NAME, length: 50 )
DESCRIPTION
( type: esriFieldTypeString, alias: DESCRIPTION, length: 200 )
TEXT_FIELD
( type: esriFieldTypeSmallInteger, alias: TEXT_FIELD )
VISIBLE
( type: esriFieldTypeSmallInteger, alias: VISIBLE )
SYSTEM
( type: esriFieldTypeSmallInteger, alias: SYSTEM )
IS_SENSITIVE
( type: esriFieldTypeSmallInteger, alias: IS_SENSITIVE )
Table:
ITSSQLSandbox.DBO.VW_EVENT_RESPONDER_OPERATORDASHBOARD
(4)
Name:
ITSSQLSandbox.DBO.VW_EVENT_RESPONDER_OPERATORDASHBOARD
Display Field:
LAST_CONTACT_NAME
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_RESPONDER_ID
( type: esriFieldTypeDouble, alias: EVENT_RESPONDER_ID )
EVENT_ID
( type: esriFieldTypeDouble, alias: EVENT_ID )
CREATED_DATE
( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
CREATED_BY
( type: esriFieldTypeString, alias: CREATED_BY, length: 1 )
MODIFIED_DATE
( type: esriFieldTypeDate, alias: MODIFIED_DATE, length: 8 )
MODIFIED_BY
( type: esriFieldTypeString, alias: MODIFIED_BY, length: 1 )
MODIFIED_NUM
( type: esriFieldTypeInteger, alias: MODIFIED_NUM )
AGENCY_ID
( type: esriFieldTypeDouble, alias: AGENCY_ID )
NOTIFIED_BY_TMC
( type: esriFieldTypeSmallInteger, alias: NOTIFIED_BY_TMC )
NOTIFIED_DATE
( type: esriFieldTypeDate, alias: NOTIFIED_DATE, length: 8 )
ARRIVAL_DATE
( type: esriFieldTypeDate, alias: ARRIVAL_DATE, length: 8 )
DEPARTURE_DATE
( type: esriFieldTypeDate, alias: DEPARTURE_DATE, length: 8 )
LAST_CONTACTED_DATE
( type: esriFieldTypeDate, alias: LAST_CONTACTED_DATE, length: 8 )
LAST_CONTACT_NAME
( type: esriFieldTypeString, alias: LAST_CONTACT_NAME, length: 50 )
LAST_CONTACT_PHONENO
( type: esriFieldTypeString, alias: LAST_CONTACT_PHONENO, length: 20 )
LAST_NOTIFIED_DATE
( type: esriFieldTypeDate, alias: LAST_NOTIFIED_DATE, length: 8 )