Layer: Dashboard_Data_Backup

View In: Map Viewer

Name: Dashboard_Data_Backup_20220128

Display Field: roadway_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,169,230,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[153,153,153,64],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
sys_closed_date (type: esriFieldTypeDate, alias: System Closed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
event_id (type: esriFieldTypeInteger, alias: Event ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
is_perfmeasd (type: esriFieldTypeString, alias: Is Performance Measure, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
last_modified_date (type: esriFieldTypeDate, alias: Last Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_modified_by (type: esriFieldTypeString, alias: Last Modified By, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
last_event_audid (type: esriFieldTypeInteger, alias: Last Event Audit ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
detected_date (type: esriFieldTypeDate, alias: Detected Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
knowledge_date (type: esriFieldTypeDate, alias: Knowledge Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
closed_date (type: esriFieldTypeDate, alias: Closed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
initial_confirmed_date (type: esriFieldTypeDate, alias: Initial Confirmed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
initial_owned_date (type: esriFieldTypeDate, alias: Initial Owned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
first_responder_arrival_date (type: esriFieldTypeDate, alias: First Responder Arrival Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
first_responder_notified_date (type: esriFieldTypeDate, alias: First Responder Notified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_responder_departure_date (type: esriFieldTypeDate, alias: Last Responder Notified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
first_dsphveh_dispatched_date (type: esriFieldTypeDate, alias: First DSPHVEH Dispatched Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
first_dsphveh_arrival_date (type: esriFieldTypeDate, alias: First DSPHVEH Arrival Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_dsphveh_departure_date (type: esriFieldTypeDate, alias: Last DSPHVEH Departure Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
first_lane_blocked_date (type: esriFieldTypeDate, alias: First Lane Blocked Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
lanes_reopened_date (type: esriFieldTypeDate, alias: Lanes Reopened Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
wrs_blockage_date (type: esriFieldTypeDate, alias: WRS Blockage Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
wrs_blockage_desc (type: esriFieldTypeString, alias: WRS Blockage Description, SQL Type: sqlTypeOther, length: 7999, nullable: true, editable: true)
wrs_blk_travellane_cnt (type: esriFieldTypeSmallInteger, alias: WRS Blockage Travel Lane Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_blk_entrylane_cnt (type: esriFieldTypeSmallInteger, alias: WRS Blockage Entrylane Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_blk_exitlane_cnt (type: esriFieldTypeSmallInteger, alias: WRS Blockage Exitlane Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_blk_shoulderlane_cnt (type: esriFieldTypeSmallInteger, alias: WRS Blockage Shoulder Lane Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_blk_shoulderonly (type: esriFieldTypeSmallInteger, alias: WRS Blockage Shoulder Only, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_fullclosure (type: esriFieldTypeSmallInteger, alias: WRS Full Closure, SQL Type: sqlTypeOther, nullable: true, editable: true)
last_event_responseplan_id (type: esriFieldTypeString, alias: Last Event response Plan ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
first_rspnsplan_activated_date (type: esriFieldTypeDate, alias: First Resonse Plan Activated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_rspnsplan_terminated_date (type: esriFieldTypeDate, alias: Last Response Plan Terminated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
is_severity_other (type: esriFieldTypeString, alias: Is Severity Other, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
severity_id (type: esriFieldTypeSmallInteger, alias: Severity ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
conditions_desc (type: esriFieldTypeString, alias: Conditions Description, SQL Type: sqlTypeOther, length: 7999, nullable: true, editable: true)
contacts_desc (type: esriFieldTypeString, alias: Contacts Description, SQL Type: sqlTypeOther, length: 7999, nullable: true, editable: true)
involvedvehicles_desc (type: esriFieldTypeString, alias: Involved Vehicles Description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
dsphveh_assisted (type: esriFieldTypeSmallInteger, alias: DSPHVEH Assisted, SQL Type: sqlTypeOther, nullable: true, editable: true)
dsphveh_cnt (type: esriFieldTypeSmallInteger, alias: DSPHVEH Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
usererror_cnt (type: esriFieldTypeSmallInteger, alias: User Error Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
activity_cnt (type: esriFieldTypeInteger, alias: Activity Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
roadranger_assisted (type: esriFieldTypeSmallInteger, alias: Road Ranger Assisted, SQL Type: sqlTypeOther, nullable: true, editable: true)
roadranger_cnt (type: esriFieldTypeSmallInteger, alias: Road Ranger Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
rr_usererror_cnt (type: esriFieldTypeSmallInteger, alias: Road Ranger User Error Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
rr_activity_cnt (type: esriFieldTypeSmallInteger, alias: Road Ranger Activity Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_assisted (type: esriFieldTypeSmallInteger, alias: SIRV Assisted, SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_cnt (type: esriFieldTypeSmallInteger, alias: SIRV Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_usererror_cnt (type: esriFieldTypeSmallInteger, alias: SIRV User Error Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_activity_cnt (type: esriFieldTypeSmallInteger, alias: SIRV Activity Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
dsphveh_dispatch_mnt_avgof (type: esriFieldTypeDouble, alias: DSPHVEH Dispatch Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
dsphveh_response_mnt_avgof (type: esriFieldTypeDouble, alias: DHSPVEH Response Minute (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
dsphveh_onscene_mnt_avgof (type: esriFieldTypeDouble, alias: DSPHVEH Onscene Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
rr_dispatch_mnt_avgof (type: esriFieldTypeDouble, alias: Road Ranger Dispatched Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
rr_response_mnt_avgof (type: esriFieldTypeDouble, alias: Road Ranger Response Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
rr_onscene_mnt_avgof (type: esriFieldTypeDouble, alias: Road Ranger Onscene Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_dispatch_mnt_avgof (type: esriFieldTypeDouble, alias: SIRV Dispatch Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_response_mnt_avgof (type: esriFieldTypeDouble, alias: SIRV Response Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
sirv_onscene_mnt_avgof (type: esriFieldTypeDouble, alias: SIRV Onscene Minutes (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
responder_notified_mnt_avgof (type: esriFieldTypeString, alias: Responder Notified Minutes (Average), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
responder_response_mnt_avgof (type: esriFieldTypeString, alias: Responder Response Minutes (Average), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
responder_onscene_mnt_avgof (type: esriFieldTypeString, alias: Responder Onscene Minutes (Average), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
event_latitude (type: esriFieldTypeInteger, alias: Event Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
event_longitude (type: esriFieldTypeInteger, alias: Event Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_blk_leftturnlane_cnt (type: esriFieldTypeSmallInteger, alias: WRS Blockage Left Turn Lane Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
wrs_blk_rightturnlane_cnt (type: esriFieldTypeSmallInteger, alias: WRS Blockage Right Turn Lane Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
last_lane_blocked_date (type: esriFieldTypeDate, alias: Last Lane Blocked Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
total_lane_blockage_mins (type: esriFieldTypeDouble, alias: Total Lane Blockage Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
severity (type: esriFieldTypeString, alias: Severity, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
event_type (type: esriFieldTypeString, alias: Event Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
et_is_perfmeasd (type: esriFieldTypeString, alias: ET Is Performance Measure, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
event_status (type: esriFieldTypeString, alias: Event Type Status, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
es_is_valid (type: esriFieldTypeString, alias: Event Status is Valid, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
es_is_perfmeasd (type: esriFieldTypeString, alias: Event Status is Performance Measure, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
primary_event_id (type: esriFieldTypeInteger, alias: Primary Event Id (Secondary Events Only), SQL Type: sqlTypeOther, nullable: true, editable: true)
sys_location_desc (type: esriFieldTypeString, alias: System Location Description, SQL Type: sqlTypeOther, length: 7999, nullable: true, editable: true)
roadway_name (type: esriFieldTypeString, alias: Roadway Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
ro_is_perfmeasd (type: esriFieldTypeString, alias: RO is Performance Measure, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
police_incidentno (type: esriFieldTypeString, alias: Police Incident Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
district (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
report_district (type: esriFieldTypeString, alias: Report District, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
fdot_fhp_notified_time (type: esriFieldTypeDate, alias: FDOT FHP Notified Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
is_time_ok (type: esriFieldTypeString, alias: Is Time Ok, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
is_pm_event (type: esriFieldTypeString, alias: Is Performance Measure Event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
is_tim_event (type: esriFieldTypeString, alias: Is TIM Event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
report_year (type: esriFieldTypeSmallInteger, alias: Report Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
rct (type: esriFieldTypeDouble, alias: Roadway Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
ict (type: esriFieldTypeDouble, alias: Incident Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
roadway (type: esriFieldTypeString, alias: Roadway, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
rd_status (type: esriFieldTypeString, alias: Road Status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
detectedyear (type: esriFieldTypeInteger, alias: Detected Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedquarter (type: esriFieldTypeInteger, alias: Detected Quarter, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedmonth (type: esriFieldTypeInteger, alias: Detected Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedweek (type: esriFieldTypeInteger, alias: Detected Week, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedday (type: esriFieldTypeInteger, alias: Detected Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedhour (type: esriFieldTypeInteger, alias: Detected Hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedfiscalyear (type: esriFieldTypeInteger, alias: Detected Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
detectedfiscalmonth (type: esriFieldTypeInteger, alias: Detected Fiscal Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
is_secondary (type: esriFieldTypeInteger, alias: Is Secondary Event, SQL Type: sqlTypeOther, nullable: true, editable: true)
fy_string (type: esriFieldTypeString, alias: Fiscal Year (String), SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
rct_duration (type: esriFieldTypeString, alias: Roadway_Clearance_Duration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
rct_bins (type: esriFieldTypeString, alias: Roadway Clearance Bins, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/28/2023 4:53:55 AM

Schema Last Edit Date: 1/28/2023 4:53:55 AM

Data Last Edit Date: 1/29/2022 1:30:34 AM

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

Layer: Dashboard_Data_Backup_20220128 (ID:1)