20220628
13273700
1.0
FALSE
Harmonized_TIM_Dev_Backup_20220628
002
file://\\TALL155\C$\Data\Projects\67234-tim-migration\ArcPro\Migration Testing\Migration Testing.gdb
Local Area Network
Projected
GCS_North_American_1983_HARN
Linear Unit: Meter (1.000000)
NAD_1983_HARN_Florida_GDL_Albers
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS["NAD_1983_HARN_Florida_GDL_Albers",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.0],PARAMETER["Standard_Parallel_1",24.0],PARAMETER["Standard_Parallel_2",31.5],PARAMETER["Latitude_Of_Origin",24.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3087]]</WKT><XOrigin>-19550100</XOrigin><YOrigin>-7526400</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>3087</WKID><LatestWKID>3087</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass "Harmonized TIM" "C:\Data\Projects\67234-tim-migration\ArcPro\Migration Testing\Migration Testing.gdb" Harmonized_TIM_Dev_Backup_20220628 # "created_date "Created Date" true true false 29 Date 0 0,First,#,Harmonized TIM,created_date,-1,-1;sys_closed_date "System Closed Date" true true false 29 Date 0 0,First,#,Harmonized TIM,sys_closed_date,-1,-1;event_id "Event ID" true true false 0 Long 0 0,First,#,Harmonized TIM,event_id,-1,-1;is_perfmeasd "Is Performance Measure" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,is_perfmeasd,0,2147483647;last_modified_date "Last Modified Date" true true false 29 Date 0 0,First,#,Harmonized TIM,last_modified_date,-1,-1;last_modified_by "Last Modified By" true true false 15 Text 0 0,First,#,Harmonized TIM,last_modified_by,0,15;last_event_audid "Last Event Audit ID" true true false 0 Long 0 0,First,#,Harmonized TIM,last_event_audid,-1,-1;detected_date "Detected Date" true true false 29 Date 0 0,First,#,Harmonized TIM,detected_date,-1,-1;knowledge_date "Knowledge Date" true true false 29 Date 0 0,First,#,Harmonized TIM,knowledge_date,-1,-1;closed_date "Closed Date" true true false 29 Date 0 0,First,#,Harmonized TIM,closed_date,-1,-1;initial_confirmed_date "Initial Confirmed Date" true true false 29 Date 0 0,First,#,Harmonized TIM,initial_confirmed_date,-1,-1;initial_owned_date "Initial Owned Date" true true false 29 Date 0 0,First,#,Harmonized TIM,initial_owned_date,-1,-1;first_responder_arrival_date "First Responder Arrival Date" true true false 29 Date 0 0,First,#,Harmonized TIM,first_responder_arrival_date,-1,-1;first_responder_notified_date "First Responder Notified Date" true true false 29 Date 0 0,First,#,Harmonized TIM,first_responder_notified_date,-1,-1;last_responder_departure_date "Last Responder Notified Date" true true false 29 Date 0 0,First,#,Harmonized TIM,last_responder_departure_date,-1,-1;first_dsphveh_dispatched_date "First DSPHVEH Dispatched Date" true true false 29 Date 0 0,First,#,Harmonized TIM,first_dsphveh_dispatched_date,-1,-1;first_dsphveh_arrival_date "First DSPHVEH Arrival Date" true true false 29 Date 0 0,First,#,Harmonized TIM,first_dsphveh_arrival_date,-1,-1;last_dsphveh_departure_date "Last DSPHVEH Departure Date" true true false 29 Date 0 0,First,#,Harmonized TIM,last_dsphveh_departure_date,-1,-1;first_lane_blocked_date "First Lane Blocked Date" true true false 29 Date 0 0,First,#,Harmonized TIM,first_lane_blocked_date,-1,-1;lanes_reopened_date "Lanes Reopened Date" true true false 29 Date 0 0,First,#,Harmonized TIM,lanes_reopened_date,-1,-1;wrs_blockage_date "WRS Blockage Date" true true false 29 Date 0 0,First,#,Harmonized TIM,wrs_blockage_date,-1,-1;wrs_blockage_desc "WRS Blockage Description" true true false 7999 Text 0 0,First,#,Harmonized TIM,wrs_blockage_desc,0,7999;wrs_blk_travellane_cnt "WRS Blockage Travel Lane Count" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_travellane_cnt,-1,-1;wrs_blk_entrylane_cnt "WRS Blockage Entrylane Count" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_entrylane_cnt,-1,-1;wrs_blk_exitlane_cnt "WRS Blockage Exitlane Count" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_exitlane_cnt,-1,-1;wrs_blk_shoulderlane_cnt "WRS Blockage Shoulder Lane Count" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_shoulderlane_cnt,-1,-1;wrs_blk_shoulderonly "WRS Blockage Shoulder Only" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_shoulderonly,-1,-1;wrs_fullclosure "WRS Full Closure" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_fullclosure,-1,-1;last_event_responseplan_id "Last Event response Plan ID" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,last_event_responseplan_id,0,2147483647;first_rspnsplan_activated_date "First Resonse Plan Activated Date" true true false 29 Date 0 0,First,#,Harmonized TIM,first_rspnsplan_activated_date,-1,-1;last_rspnsplan_terminated_date "Last Response Plan Terminated Date" true true false 29 Date 0 0,First,#,Harmonized TIM,last_rspnsplan_terminated_date,-1,-1;is_severity_other "Is Severity Other" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,is_severity_other,0,2147483647;severity_id "Severity ID" true true false 0 Short 0 0,First,#,Harmonized TIM,severity_id,-1,-1;conditions_desc "Conditions Description" true true false 7999 Text 0 0,First,#,Harmonized TIM,conditions_desc,0,7999;contacts_desc "Contacts Description" true true false 7999 Text 0 0,First,#,Harmonized TIM,contacts_desc,0,7999;involvedvehicles_desc "Involved Vehicles Description" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,involvedvehicles_desc,0,2147483647;dsphveh_assisted "DSPHVEH Assisted" true true false 0 Short 0 0,First,#,Harmonized TIM,dsphveh_assisted,-1,-1;dsphveh_cnt "DSPHVEH Count" true true false 0 Short 0 0,First,#,Harmonized TIM,dsphveh_cnt,-1,-1;usererror_cnt "User Error Count" true true false 0 Short 0 0,First,#,Harmonized TIM,usererror_cnt,-1,-1;activity_cnt "Activity Count" true true false 0 Long 0 0,First,#,Harmonized TIM,activity_cnt,-1,-1;roadranger_assisted "Road Ranger Assisted" true true false 0 Short 0 0,First,#,Harmonized TIM,roadranger_assisted,-1,-1;roadranger_cnt "Road Ranger Count" true true false 0 Short 0 0,First,#,Harmonized TIM,roadranger_cnt,-1,-1;rr_usererror_cnt "Road Ranger User Error Count" true true false 0 Short 0 0,First,#,Harmonized TIM,rr_usererror_cnt,-1,-1;rr_activity_cnt "Road Ranger Activity Count" true true false 0 Short 0 0,First,#,Harmonized TIM,rr_activity_cnt,-1,-1;sirv_assisted "SIRV Assisted" true true false 0 Short 0 0,First,#,Harmonized TIM,sirv_assisted,-1,-1;sirv_cnt "SIRV Count" true true false 0 Short 0 0,First,#,Harmonized TIM,sirv_cnt,-1,-1;sirv_usererror_cnt "SIRV User Error Count" true true false 0 Short 0 0,First,#,Harmonized TIM,sirv_usererror_cnt,-1,-1;sirv_activity_cnt "SIRV Activity Count" true true false 0 Short 0 0,First,#,Harmonized TIM,sirv_activity_cnt,-1,-1;dsphveh_dispatch_mnt_avgof "DSPHVEH Dispatch Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,dsphveh_dispatch_mnt_avgof,-1,-1;dsphveh_response_mnt_avgof "DHSPVEH Response Minute (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,dsphveh_response_mnt_avgof,-1,-1;dsphveh_onscene_mnt_avgof "DSPHVEH Onscene Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,dsphveh_onscene_mnt_avgof,-1,-1;rr_dispatch_mnt_avgof "Road Ranger Dispatched Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,rr_dispatch_mnt_avgof,-1,-1;rr_response_mnt_avgof "Road Ranger Response Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,rr_response_mnt_avgof,-1,-1;rr_onscene_mnt_avgof "Road Ranger Onscene Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,rr_onscene_mnt_avgof,-1,-1;sirv_dispatch_mnt_avgof "SIRV Dispatch Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,sirv_dispatch_mnt_avgof,-1,-1;sirv_response_mnt_avgof "SIRV Response Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,sirv_response_mnt_avgof,-1,-1;sirv_onscene_mnt_avgof "SIRV Onscene Minutes (Average)" true true false 0 Double 0 0,First,#,Harmonized TIM,sirv_onscene_mnt_avgof,-1,-1;responder_notified_mnt_avgof "Responder Notified Minutes (Average)" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,responder_notified_mnt_avgof,0,2147483647;responder_response_mnt_avgof "Responder Response Minutes (Average)" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,responder_response_mnt_avgof,0,2147483647;responder_onscene_mnt_avgof "Responder Onscene Minutes (Average)" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,responder_onscene_mnt_avgof,0,2147483647;event_latitude "Event Latitude" true true false 0 Long 0 0,First,#,Harmonized TIM,event_latitude,-1,-1;event_longitude "Event Longitude" true true false 0 Long 0 0,First,#,Harmonized TIM,event_longitude,-1,-1;wrs_blk_leftturnlane_cnt "WRS Blockage Left Turn Lane Count" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_leftturnlane_cnt,-1,-1;wrs_blk_rightturnlane_cnt "WRS Blockage Right Turn Lane Count" true true false 0 Short 0 0,First,#,Harmonized TIM,wrs_blk_rightturnlane_cnt,-1,-1;last_lane_blocked_date "Last Lane Blocked Date" true true false 29 Date 0 0,First,#,Harmonized TIM,last_lane_blocked_date,-1,-1;total_lane_blockage_mins "Total Lane Blockage Minutes" true true false 0 Double 0 0,First,#,Harmonized TIM,total_lane_blockage_mins,-1,-1;severity "Severity" true true false 8 Text 0 0,First,#,Harmonized TIM,severity,0,8;event_type "Event Type" true true false 255 Text 0 0,First,#,Harmonized TIM,event_type,0,255;et_is_perfmeasd "ET Is Performance Measure" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,et_is_perfmeasd,0,2147483647;event_status "Event Type Status" true true false 6 Text 0 0,First,#,Harmonized TIM,event_status,0,6;es_is_valid "Event Status is Valid" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,es_is_valid,0,2147483647;es_is_perfmeasd "Event Status is Performance Measure" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,es_is_perfmeasd,0,2147483647;primary_event_id "Primary Event Id (Secondary Events Only)" true true false 0 Long 0 0,First,#,Harmonized TIM,primary_event_id,-1,-1;sys_location_desc "System Location Description" true true false 7999 Text 0 0,First,#,Harmonized TIM,sys_location_desc,0,7999;roadway_name "Roadway Name" true true false 20 Text 0 0,First,#,Harmonized TIM,roadway_name,0,20;county "County" true true false 12 Text 0 0,First,#,Harmonized TIM,county,0,12;ro_is_perfmeasd "RO is Performance Measure" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,ro_is_perfmeasd,0,2147483647;direction "Direction" true true false 255 Text 0 0,First,#,Harmonized TIM,direction,0,255;latitude "Latitude" true true false 0 Double 0 0,First,#,Harmonized TIM,latitude,-1,-1;longitude "Longitude" true true false 0 Double 0 0,First,#,Harmonized TIM,longitude,-1,-1;police_incidentno "Police Incident Number" true true false 255 Text 0 0,First,#,Harmonized TIM,police_incidentno,0,255;district "District" true true false 20 Text 0 0,First,#,Harmonized TIM,district,0,20;report_district "Report District" true true false 20 Text 0 0,First,#,Harmonized TIM,report_district,0,20;fdot_fhp_notified_time "FDOT FHP Notified Time" true true false 29 Date 0 0,First,#,Harmonized TIM,fdot_fhp_notified_time,-1,-1;is_time_ok "Is Time Ok" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,is_time_ok,0,2147483647;is_pm_event "Is Performance Measure Event" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,is_pm_event,0,2147483647;is_tim_event "Is TIM Event" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,is_tim_event,0,2147483647;report_year "Report Year" true true false 0 Short 0 0,First,#,Harmonized TIM,report_year,-1,-1;rct "Roadway Clearance Time" true true false 0 Double 0 0,First,#,Harmonized TIM,rct,-1,-1;ict "Incident Clearance Time" true true false 0 Double 0 0,First,#,Harmonized TIM,ict,-1,-1;roadway "Roadway" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,roadway,0,2147483647;rd_status "Road Status" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,rd_status,0,2147483647;detectedyear "Detected Year" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedyear,-1,-1;detectedquarter "Detected Quarter" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedquarter,-1,-1;detectedmonth "Detected Month" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedmonth,-1,-1;detectedweek "Detected Week" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedweek,-1,-1;detectedday "Detected Day" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedday,-1,-1;detectedhour "Detected Hour" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedhour,-1,-1;detectedfiscalyear "Detected Fiscal Year" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedfiscalyear,-1,-1;detectedfiscalmonth "Detected Fiscal Month" true true false 0 Long 0 0,First,#,Harmonized TIM,detectedfiscalmonth,-1,-1;is_secondary "Is Secondary Event" true true false 0 Long 0 0,First,#,Harmonized TIM,is_secondary,-1,-1;fy_string "Fiscal Year (String)" true true false 4 Text 0 0,First,#,Harmonized TIM,fy_string,0,4;rct_duration "Roadway_Clearance_Duration" true true false 255 Text 0 0,First,#,Harmonized TIM,rct_duration,0,255;rct_bins "Roadway Clearance Bins" true true false 255 Text 0 0,First,#,Harmonized TIM,rct_bins,0,255;major_corridor "Major Corridor" true true false 2147483647 Text 0 0,First,#,Harmonized TIM,major_corridor,0,2147483647" #
CalculateField Harmonized_TIM_Dev_Backup_20220628 district 'District 3 - Chipley' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Harmonized_TIM_Dev_Backup_20220628 county 'DeSoto' "Python 3" # Text NO_ENFORCE_DOMAINS
CopyMultiple "'C:\Data\Projects\67234-tim-migration\ArcPro\Migration Testing\Migration Testing.gdb\Harmonized_TIM_Dev_Backup_20220628' FeatureClass" "C:\Data\Projects\67234-tim-migration\ArcPro\Migration Testing\Migration Testing.gdb" Harmonized_TIM_Dev_Backup_20220628_1 "Harmonized_TIM_Dev_Backup_20220628 FeatureClass Harmonized_TIM_Dev_Backup_20220628_1 #"
Rename "C:\Data\Projects\67234-tim-migration\ArcPro\Migration Testing\Migration Testing.gdb\Harmonized_TIM_Dev_Backup_20220628_1" "C:\Data\Projects\67234-tim-migration\ArcPro\Migration Testing\Migration Testing.gdb\Harmonized_TIM" FeatureClass
20220628
11005700
20220628
11005700
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 12.9.3.32739
Harmonized TIM v21
TIM
Traffic Incident Management
TIM Analystics 2.0
Harmonized TIM feature service v2.1
File Geodatabase Feature Class
dataset
EPSG
6.12(9.2.0)
0
Simple
FALSE
0
TRUE
FALSE
Harmonized_TIM_Dev_Backup_20220628
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
created_date
Created Date
Date
8
0
0
sys_closed_date
System Closed Date
Date
8
0
0
event_id
Event ID
Integer
4
0
0
is_perfmeasd
Is Performance Measure
String
2147483647
0
0
last_modified_date
Last Modified Date
Date
8
0
0
last_modified_by
Last Modified By
String
15
0
0
last_event_audid
Last Event Audit ID
Integer
4
0
0
detected_date
Detected Date
Date
8
0
0
knowledge_date
Knowledge Date
Date
8
0
0
closed_date
Closed Date
Date
8
0
0
initial_confirmed_date
Initial Confirmed Date
Date
8
0
0
initial_owned_date
Initial Owned Date
Date
8
0
0
first_responder_arrival_date
First Responder Arrival Date
Date
8
0
0
first_responder_notified_date
First Responder Notified Date
Date
8
0
0
last_responder_departure_date
Last Responder Notified Date
Date
8
0
0
first_dsphveh_dispatched_date
First DSPHVEH Dispatched Date
Date
8
0
0
first_dsphveh_arrival_date
First DSPHVEH Arrival Date
Date
8
0
0
last_dsphveh_departure_date
Last DSPHVEH Departure Date
Date
8
0
0
first_lane_blocked_date
First Lane Blocked Date
Date
8
0
0
lanes_reopened_date
Lanes Reopened Date
Date
8
0
0
wrs_blockage_date
WRS Blockage Date
Date
8
0
0
wrs_blockage_desc
WRS Blockage Description
String
7999
0
0
wrs_blk_travellane_cnt
WRS Blockage Travel Lane Count
SmallInteger
2
0
0
wrs_blk_entrylane_cnt
WRS Blockage Entrylane Count
SmallInteger
2
0
0
wrs_blk_exitlane_cnt
WRS Blockage Exitlane Count
SmallInteger
2
0
0
wrs_blk_shoulderlane_cnt
WRS Blockage Shoulder Lane Count
SmallInteger
2
0
0
wrs_blk_shoulderonly
WRS Blockage Shoulder Only
SmallInteger
2
0
0
wrs_fullclosure
WRS Full Closure
SmallInteger
2
0
0
last_event_responseplan_id
Last Event response Plan ID
String
2147483647
0
0
first_rspnsplan_activated_date
First Resonse Plan Activated Date
Date
8
0
0
last_rspnsplan_terminated_date
Last Response Plan Terminated Date
Date
8
0
0
is_severity_other
Is Severity Other
String
2147483647
0
0
severity_id
Severity ID
SmallInteger
2
0
0
conditions_desc
Conditions Description
String
7999
0
0
contacts_desc
Contacts Description
String
7999
0
0
involvedvehicles_desc
Involved Vehicles Description
String
2147483647
0
0
dsphveh_assisted
DSPHVEH Assisted
SmallInteger
2
0
0
dsphveh_cnt
DSPHVEH Count
SmallInteger
2
0
0
usererror_cnt
User Error Count
SmallInteger
2
0
0
activity_cnt
Activity Count
Integer
4
0
0
roadranger_assisted
Road Ranger Assisted
SmallInteger
2
0
0
roadranger_cnt
Road Ranger Count
SmallInteger
2
0
0
rr_usererror_cnt
Road Ranger User Error Count
SmallInteger
2
0
0
rr_activity_cnt
Road Ranger Activity Count
SmallInteger
2
0
0
sirv_assisted
SIRV Assisted
SmallInteger
2
0
0
sirv_cnt
SIRV Count
SmallInteger
2
0
0
sirv_usererror_cnt
SIRV User Error Count
SmallInteger
2
0
0
sirv_activity_cnt
SIRV Activity Count
SmallInteger
2
0
0
dsphveh_dispatch_mnt_avgof
DSPHVEH Dispatch Minutes (Average)
Double
8
0
0
dsphveh_response_mnt_avgof
DHSPVEH Response Minute (Average)
Double
8
0
0
dsphveh_onscene_mnt_avgof
DSPHVEH Onscene Minutes (Average)
Double
8
0
0
rr_dispatch_mnt_avgof
Road Ranger Dispatched Minutes (Average)
Double
8
0
0
rr_response_mnt_avgof
Road Ranger Response Minutes (Average)
Double
8
0
0
rr_onscene_mnt_avgof
Road Ranger Onscene Minutes (Average)
Double
8
0
0
sirv_dispatch_mnt_avgof
SIRV Dispatch Minutes (Average)
Double
8
0
0
sirv_response_mnt_avgof
SIRV Response Minutes (Average)
Double
8
0
0
sirv_onscene_mnt_avgof
SIRV Onscene Minutes (Average)
Double
8
0
0
responder_notified_mnt_avgof
Responder Notified Minutes (Average)
String
2147483647
0
0
responder_response_mnt_avgof
Responder Response Minutes (Average)
String
2147483647
0
0
responder_onscene_mnt_avgof
Responder Onscene Minutes (Average)
String
2147483647
0
0
event_latitude
Event Latitude
Integer
4
0
0
event_longitude
Event Longitude
Integer
4
0
0
wrs_blk_leftturnlane_cnt
WRS Blockage Left Turn Lane Count
SmallInteger
2
0
0
wrs_blk_rightturnlane_cnt
WRS Blockage Right Turn Lane Count
SmallInteger
2
0
0
last_lane_blocked_date
Last Lane Blocked Date
Date
8
0
0
total_lane_blockage_mins
Total Lane Blockage Minutes
Double
8
0
0
severity
Severity
String
8
0
0
event_type
Event Type
String
255
0
0
et_is_perfmeasd
ET Is Performance Measure
String
2147483647
0
0
event_status
Event Type Status
String
6
0
0
es_is_valid
Event Status is Valid
String
2147483647
0
0
es_is_perfmeasd
Event Status is Performance Measure
String
2147483647
0
0
primary_event_id
Primary Event Id (Secondary Events Only)
Integer
4
0
0
sys_location_desc
System Location Description
String
7999
0
0
roadway_name
Roadway Name
String
20
0
0
county
County
String
12
0
0
ro_is_perfmeasd
RO is Performance Measure
String
2147483647
0
0
direction
Direction
String
255
0
0
latitude
Latitude
Double
8
0
0
longitude
Longitude
Double
8
0
0
police_incidentno
Police Incident Number
String
255
0
0
district
District
String
20
0
0
report_district
Report District
String
20
0
0
fdot_fhp_notified_time
FDOT FHP Notified Time
Date
8
0
0
is_time_ok
Is Time Ok
String
2147483647
0
0
is_pm_event
Is Performance Measure Event
String
2147483647
0
0
is_tim_event
Is TIM Event
String
2147483647
0
0
report_year
Report Year
SmallInteger
2
0
0
rct
Roadway Clearance Time
Double
8
0
0
ict
Incident Clearance Time
Double
8
0
0
roadway
Roadway
String
2147483647
0
0
rd_status
Road Status
String
2147483647
0
0
detectedyear
Detected Year
Integer
4
0
0
detectedquarter
Detected Quarter
Integer
4
0
0
detectedmonth
Detected Month
Integer
4
0
0
detectedweek
Detected Week
Integer
4
0
0
detectedday
Detected Day
Integer
4
0
0
detectedhour
Detected Hour
Integer
4
0
0
detectedfiscalyear
Detected Fiscal Year
Integer
4
0
0
detectedfiscalmonth
Detected Fiscal Month
Integer
4
0
0
is_secondary
Is Secondary Event
Integer
4
0
0
fy_string
Fiscal Year (String)
String
4
0
0
rct_duration
Roadway_Clearance_Duration
String
255
0
0
rct_bins
Roadway Clearance Bins
String
255
0
0
major_corridor
Major Corridor
String
2147483647
0
0
20220628
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2eiii
uw88KKKKAClBI6HFJRQBIJT0P50x+V2Ph1Ycg0lIRkVm6S6GiqPqYGq6bq+p3Men2siWelBf3kkZ
+Zv9kDtW7pel2uk2SWdpGEiX9T6mhJWjbDHj1q0rBhkdK5aiktzqU7qyHOQgJJ4FZkmsWo6S4Oea
u3EbTQsiOUP94Vl/YJlJzctk+1YtgSLqtuDuLnA68VKs63K+YhypqubCYKpMz59cdakhgkhzvkZx
2z2qGImXrVxcKAPaqqjvUpYlgRkVdODlsLmUdyUsPxpV6VEHIbIFSKQen5Vo6coq7QKab0Akg0E0
vXpWJozapFe3lnfhpYlbfDcEYDA/w/hj9am10Xa6NtTk81nPpSahdzf2hZWs1sMGEkZbPvWih2np
TwcHg8elOLsCdjF1Lwho+pQBHtVidPuSRfKy/Q1w+r+B9b0W5bXdF1OS5uolyY5RyyjsTnnivVQQ
3HehlDKVI4IwatSaLU2jzTTPEPjLW9NjuLfTrQ7hjeXwAR17Vajt/H5yfN01WJ4UpnH61NozN4c8
a3eiySD7Je5ntlJ6HPIH512+2lOyeiCTSeiOIMnjy4X7OsdjbsPvT9QfoKj/AOEP1zU5/N1nX5Co
4EduNo/nXdbT3pkjrFyx4pc76IXO+iPK/FPgaw0mbT7hGlnhllEU4nfdnJAB/WvK7mG3hudQtplZ
NjHy8jkEH9BX0D4w0e98S29lZWjiK3Mu+abuoGCMVBYfD3SNI1FLxcMgiKyiUZ3nn5if89K3p1LL
Vmqq8sdTwnwn4Zk8RaydOikaHdlt78jpX0H4U0CTw3oqabJc/aPLJw23H9a5fVtMh0D4h6VqsMcc
FhcZjLIMDcQQM/pXo7gYDDvVRqNzXYxxU3KOmwyiiitzzwooooAKKKKACimBsU4EGmK4tFFFIYUU
UUAFFFFACMoYYNSwsAAnpUdC538VFSCki4ScWWMH6VHIhLAgfWpGcAAE4NMMijnOc1w8jex1NpBy
aUgDk9KZ5hI96ZknrzWkKEm9TOVRLYViuMBT9RSUUV1wgobGEpOW4UdKKKokkWTnn86lIqtU0bjb
tPauatSSXMjopTvox2eKaBjmnH1o4NcpsCkk/SpCeBTAOMCnt1AqlsNHIePrBX0hdViXF1YuJFcH
B29xXR6XfLqOl2t6gws8YcDOcZFS31ol7YT2zqGWVCuDXFeDtYh0a2m0DV547a5s2wplcKGQ9ME/
Sr3iXvH0O5PWq90Mw596pt4i0tSQt3FIAM7o2DD9KBr+lsArzfgVNRYixbtNyod2dvapbiCO6t2h
lUOjjBHqKp2utWV5cG3ic7+wKkVoAYpapgzH1rQbfVvD8mn7SoVcxEdUYcj+VZ/grUptR0Aw3Lhr
qzkaGTHH3SQP0FdQv3jjvXDKyeGviBJG7rHZ6qmVBOAsg/xwa3TswS5oOLOwooorrOAKKKKACiii
gCOiiiqIHBvWnVHSg4pWGmPopAc0tBQUUUUgCiiigAHXnn60YAooosO4UUUUCCiiigAooooAKKKK
AJk5Sq14l2Yl+xyIj7gTvzjGeamRyh9R6U/cHbAriqwcXc6qc015jwSAOMnvTyCRnimKQWwKVmK8
VHQ1HgZHWvPviX4OTWdMfUbZcXkAzx/GvpXfRscHPNKwVxg4IPUGnFtaoqMnF3RwHww0myh8LLKH
S5klbLhgDsPpXai0tyebeL/vgVw5lHgzxuY0if8As7UzkIgGFkz29Otd/nPPrRO979x1N+buMW2h
RtyRIreoUZpt1Ebm2kg8xk3qV3L1FLMSCMHFMSRtwz0qFLUzbH28TW9vHFvZ9qgbm6msHxnpS6n4
eudsam5iXfC+0kqQe2K6bqPY00p2zVap3KWjuef+E9Z1XWdJUblS4ttsMqSKQRgdfqcV0pXU9inf
HuAOQOh9K5kWx8LePAWlZ7TVQcFuNsnX+hrt67IWaMMQlGV0tGUrMX29jdmPHYJV2iitErHO3cKK
KKBEdFFFUQFFFFABTwc0yigaZJRSA5paRQUUUUgCiiigAooooAKKKKACiiigAooooAKTkcilopSi
pKzGnZ3RJBwpPcU5myaiVmGelORsnBx0rilRlFXOmNRPQljI9alwMc9arqMNmrAO4VETVHHfES1d
/DZvYTtms5BMregHWtfw3LBP4fglguXuFYZLuxJz6c1H41Uf8IbqgwSPIbj8KzPCGp20Wmabp8Vu
Uhlt94mAAUt3H16Vpb3LGm8LHSSPkgdhTNxBqV4iOR0qIjPWubVO5i0SicJhWbqeKlWWORcq4Yeo
OapuqshVu/SmaTBDZwvbxqECsWPvk5J/Wt3JT95ChorHP/EKAHTbPUApb7FcrKfpyP610sU0dzBF
cRHMcqh1Psa4/wAW30/iC8/4RfSWU+aM3cw5Eaf5xTvCF1Ppl5ceFryUSyWi74JQeXj/AKdq1pO2
5dWHNT80djRRRXUcAUUUUAR0UUVRAUUUUAFFFFAAOKkBzUdOU9qGNDqKKKkoKKKKACiiigAooooA
KKKKACiiigAooooAKM45oooAsRspI96lIwOKrR4Az3qySeMVwySTaR3Qd1chuI0nheGVdyONrKeh
Fed6Hp3nnVfCF1K6fZn862dGwQDnH5Yr0h+Oa8w8SQalcfEmF9DmEV2lpuc4yDjPB+tOD1aNYdUd
7oUeoR6UsGphTPH8oZWzvHYmr32ZTySRWB4c8WJq8z2F1C1rqcHEsMnU+4rpGDnoRUyjd6kyWupC
LcAnPIrD8Vw48O3rx3L2pWMkyJ1I9PxpdW1TUpr7+zdJTZOg3STSx5THoK8o+I/iPXbGYaNeXsUk
b4d/Lj2++OpyKcKfvKxUKd2j0D4b6RDaeF1naLE93l3Yjkqen6VS8S+H7fw1JB4j0wS+fBIBMC+Q
yHrn9K0PA/iP7f4UW8uUggtbZFjEivkccEkdq2NQex8ReH7u3guI5kmhPKnPvQ21K7BtqTbLsM8d
xDHNEcxyKGU+oqSuV8A3U134QtFmXa9uTBj/AHeM11IORXZBu2pwVY8s2haKKKozI6KKKogKKKKA
CiiigAooooAeDkUtMBwafSKQUUUUhhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAD4zgEVjaLrVxfa5
q1jOFCWsgEWOpHP+FbcK7s1xlpb/AG3xxrsUNy8ZMSKXjxkHmuSavKR3UV7mp1WsarbaPpkt5dOF
jQcepPoK57wTplw73mvX67bq/OQpGCqDp/M1R8Vt/auvaR4cizMyyCadieijHWu5VNiqo4AGABWe
y9TTaPqYPiLwz/arJe6fMLTVYf8AVTgdfY+oqlpfiy8sL6PSfE1uLa5biO6X/VSf4fnXXJ0rL8R6
Zp+oaTP9uthMsUbSADqCBnj8qcZXVmEZX0Z5n8RdXu7LxdA+jaqIZHt8v84Cjr3ry3VNUm1G/F1f
S/ap93zMTwSBXbnwHbzeC7rxFJeyrIWJjiJ3BQHwAe9cNp2nyX0jwwWc1xORlBENxBzySAOnWumF
rHXCyj6HbfC/xDb2F7dpfTiOylQ/uWHDNkdP1r1/TrHSry7GoWsLxOieWQOAQfb8K8i8BR22nS3n
n+Hrm+vVcL8nSP2PHWvRLLWtVsbSTZ4dvXBlJIeQZ5yeMDpWNRa6GFWL5tDJ8Pi+0rx/qWlwF5LA
uZBGGwI9x64713STsJirV5TdeJryy8cGYxHS3ulAlF0Nwx7YxXdWni3QLy/WC3v0eaTAVemWNU1K
6aMa0L6tdDp6KRc7RnrS10nnkINOzUVLmrsZ3JKKaDTqQwooooAKKKKAClBxSUUDJKKYDing5pDT
CiiikMKKKKACiiigAooooAKKKKACiiihuyuNK7sQalcPaaLeTRn50jJFZHgGyht/DMF4Rm5u1Es0
rHJYkZ/rWxqsSvoV4sjBVMRya81sfGiWPwz8qCQ/bYl8iMbevHUevSuJXkj0oxfLZHR+DI4LzxN4
hvigeUXGxJCc8ZPArt29K5jwJBZ2XhSzkhkQm4UOzE8sx611JG6pnqyZ7jQvFQXiNJZzosgjZkYB
26Lx1NcfrHxLsrGSe2sbOa8uICRIE+6mB1NZKX2s+MrOWS8vIdJ00oSFjcF5AO564o9m1qx+ze7O
H+x+ItQsdS0+2nQ6fa3BkaTcAjnPQE8de1YWl2d9b6zBJPK9tbNJ5Us6cD35Fe76Bp2mXngv7DEs
dxB8wfy8rvIJxz1zWFB4UlHgDU7O4tvLlErywKxyVAbP8q3VTdM3VRK6ZqeALWK1GqJbOslqJx5U
gYMWHOcmu3A4rkvC6wal4WsG0ycWrIF87ylGSwGCCCPWutHyisZfEYT+I888c/D2HXLe4vLaSUXo
y4XcMN6jnpWP4G8PaRqNjFcqjQzwzBgm9S2V7nuK9YdQyMQeoryvwW2nWfjfXLYMY5FlITc2Bjnt
WtKT2YNydNq+x6UBgYoqL7RDz+9Tjr8wpRcQkZEqY/3hXTdHnWZFRRSZFaGIucUu8Uw9aSnYVyYN
S5qHJpQxFKw7k1FMDZpwNIq4tFFFIAoBxRRQA8HNLTAcGn0ikFFFFIYUUUUAFFFFABRRRQAUhwOS
eBS0h9+lTUfuuxdNe8rnGeK/Gmitot/pv24rKymPKo3B9M4rzGbV7QW2iGFkH2aBhIFTdg/L1B7n
muj8Z6Xd634vk0y0+zwQQRiRkC4L5xk8Dk81r6f4Z03TNIkgvdPa6DoCZREoYcdM9axiopHpKUYL
U5jwt4g1u4sYtM061t3EMxeKWR8EE9Bt/Cu2Nv491LTp5o9YtElUFfs6IM5x0zjj86x/AS6bFDLf
/wBnSSSi4YRuEHC+1ejadqFm12YoLN4WmJYtsADH1qJSV9AnJJ6Hk+k+GPFdjHfWz6MZDeKVeaWR
RgnuCDmvQ/DXg+x0fQ4rS/CyXEmS4Z88+gzXWkZHWqlxptteTQTzKxkgJKHcRg0nO5MpuRW0NNNh
tZLfTI9kUTlWXBHzfjWiVBGCBzwQarWenxWUlw8TSEzPvO9ycHHbPSpLu5FpbPcMrOqdVUZPWoe5
L1ZyWoeGL7RLyXV/DcoTOWns2Pyydzj0NbXhzxHB4i08SopiuE+WaBuGRvSteOUTwpIAQGUHB964
XxDbnw34tstet8xWdwfLvto+X2OPXjrVfFoUve0Z3ZUCvNfGmiW+j61B4niRQhkVLlefmB716PDN
FdW6TQyLJGwyrKeCKo+INIXW9BurAsFMqEKxGdp9amLsyYOzKcWjWAi+RSRIufvk5BqP/hHLDsJB
7CRv8ay/AvmahpH264dzc27G0b5ztYJznHTPzV1ddcEmjkqqUJWuU6KKK6jjCiiigAooooAM4qRW
zUdFICcGlqNTxUgqWWgooopAFSDpUdPHSkykLRRRSGFFFFABRRRQAUUUUAFFFFAHn2j2drN8TdVv
bp2+0wIBFuOBt7/0rV8TeI0fTlsdGkjutQvD5Uaq33fUmud8fXuhrPNcx6jLa6rCpjPldX9jzXD+
BdXFhqv767jstzBmuSNxx3UHjr/Ss5Kysj0adLn/AHjPfPC+kDQ9AtbFljWVEHmbO7dzWthC4OFL
Dv3rn7XXPD+oarFJbaqkly6bFRZOD+HrTrXRoNJ1IXs+rXcjynYqTSkqSewFczXcbXc3mkRM7nAw
M8mobK9t7+3E9rKssZJG5fasLXYdIt9Ut7y+uLlJpMIio/yn6j8a57Rr3UtNLaXDJ5EcdwztLPFh
fL68HP1oUboajdHYa3qb6Z9mlV4liaUJJvPODwMfjVi63BBIjkA+hrA1nw5a3OlXF3M016yt9phH
mY2kD+E9hxTPA2oTapoLpe+asiyEL5rZOM5AB9hxScbxugsuW5u21yQ+1znPQmrd3bQX1pJbzxh4
pFwykcGoYbe3eVgkodozhgOxq7t7VCTRB5/oNxN4T1+TQL0kWFwxaxkZsgD+7n15Fd4sqscZBz71
k+JtK0vU9NWLU38pQ48uUHBVu2DWHN4Hu7WD7Rput3v2yP5k82QlWPoRmtLJ6l6S1ZF4NY6V4o1z
QpCQgl+0Qbu4br/KuxdCHIFeTa/rGvQz2etzaDcWd7ZnbPc/wOnoeOnWvQbHxjol7Yw3P2tFMigl
W4INaJ8upFanzJMs0UuOKSu88kKKKKACiiigAooooAcpwalBqAcVKDkVLGh9FIDS1JQU9elMp69K
GNC0UUVJQUUUUAFFFFABRRRQAUUUUAcb4n8EaVqNpqF5ICty67xIT90ivDdOjja8tIUlAkMu3jrX
1E6CSNkYZDDBrw7UNJTwv8UbSW4bNo8wkU42gZ7UpbHoYSq3eLPSodE1fTb+zmsvsUsOxQ0ci4dc
dSDn+ldVczWBnhgu3h8/78aMecjuKq3ulx39/Y3yysj2xyNp4YHHB/Ki/it767W1uLBphs3CXB2j
2zXFzXKvc1WVXAyoOOmRWRpepW+vC9j+zfuYZTFubkPwP8apTwa+ukXEtoyi7kb5IJWyqL6A8Uvg
i4il0ARhCk8UjLOpOSHzn+tO2lx2smzZv7E3entawTvbEgBXj4KgVyaeGzY+NbW9uGnuo2j2o55C
OBjJ/AH867jINc/4m06/1W1ltrdEVQgeKUvgiQMP0xmiLCL6G1DaW9vJLJDEqNKdzkD7xqasPT/7
fTTLRbsWxuQ+JiOmznkc9elWL/Tri5uhLFqM8C7cbEIxn1pE28zRkijmULIgYA5wR3p9Z39qhtRN
rFEZEUHdMrZCsP4T71fSQSD39KfK7XJur2MjxY6x+E9VdlVgLVzhhkHg181RapPHEEwnHq2K+pdR
sotR064s5l3RzIUYexFfPrRRabI9ndWF150LFW49+O3pitKTVtjpotJPS57oelMp5pldyPBCiiim
AUUUUAFFFFABSqcGkooAmp1RK3rUgNQ0UmLTlptKvWkykPoooqSgooooAKKKKACiiigAooooAK4n
4k+GzrWifaYFJubY7ht6kd8V21IQGUgjINBUJuElJHhdn/wlFtawtplxeAzJvRPMDFUHqMZrW03x
peWBS+Grz3gjGLiyuVCEeu04GTXqek6JY2Es0kceZJGLZY9Aew9qy/FPhKx1rSZrRLaJJgCYnUbS
GPrisLJuzR6Ht4uza0NjSr6bVGS9heJtPliDR4+9u5zmrNtDcR3txuSBbZsFNi4YnvmuE+FupNZ2
tx4dvgYr61kJCN3X2z1ruZLLzNVivvtEo8tCvlA/K3Xk/nWErJ2CWjsXgAKz9bQy6VPEIpJd2Btj
ba3UdDWhuz0qneyoYpLb7SkM7xkqdwyPfBpX7Eoktk8q1hT5gFQD5jk9Khtr+2up5445CzQttfjv
VGG6g0jRYTfXzXSH5PPA3Fif90UuhPpc9vcLpyOoSQh96sDuz/tdaFFdQadm0XFhhid2hjCb2LNj
uT3qRG2ODTaUKWOB3rtsuW3Q4eZuV+pdyDULQW7sWaGNmPUlAaftIFNrgbZ23Mw9KbStSV6yPKCi
iimAUUUUAFFFFABRRRQAVIhqOnoKTBEtKOtJRUFklFIDkUtIsKKKKQBRRRQAUUUUAFFFFABRRRQA
DrSqMsCe5pKCAyMpJwR2NTLa5Udzzj4o/ZNOlttWsp0h1NWC7lbnGepA6/jT/DfxVbUvJtJNLnmn
AxJJFjb9eap/EXS9O07SAkJllv5fulhvbaOSST0Fct8OLHVotUnl0l43mSHe0cv3ZBkjHtWKiuTU
9aKi4XPUbvx1LY3skL6NcyIMFHjKng4681sWmkm61CbVZpWK3MAVIXUfusgZrO0rxPbXDta6xpn9
n3i5yrR5Vsc5BGa2LTW4bvVZtPhjO2KJZBJxhgcdPzrJ6dDJproU4PCxhsLi1OozOsv3Mov7rnjA
xTbDw1fWElxIurys80e0kouAw6NjH1/OujB4FOpKTYudmXa6fdwSyPNeGcMqgKVAwR1PA71cijKn
J4NWKQ9c1XO2rGfIubmEywPJFIZFBwetL35qoy5Y81k20MpUUUV655QUUUUAFFFFABRRRQAUUUUA
FPQ84oopMCUdKKKKgscvWnUUUmUgooopDCiiigAooooAKKKKACiiigAo4oooaAx9R0CG+vxflyJ0
haJAwyoyD2/GvPfBUP8AwjvxPudO88NHIpVmI2gnGQAPqaKKiaVmduFm5c0XtY9hmgin4kiRxjHz
KDWMmiT23ihdQtvKFs8PlSJ0246Y/IUUVxItM3R8valDA0UUr62EKWApobPXpRRQ3qA4HtTDCpOa
KKrcZ//Z