1/3/2018: Adam Dylla - Fixed database query to retrieve camera names for ids that are longer than 1 character. 12/19/2017: AJ Skillern - Camera IDs are now displayed as the user readable device name Revision: 1243 Author: britchson Date: 11:45:38 AM, Thursday, February 14, 2013 Message: Functional Change: Changed database table owners to FDOT_ODS instead of FDOT_OWN. They should work now. ---- Modified : /RPT/Unprocessed_Reports/VisioPaD_Summary_Report.rpt Revision: 1240 Author: britchson Date: 9:41:14 AM, Thursday, February 14, 2013 Message: Formatting Change: Made minor changes to format as part of QC process ---- Modified : /RPT/Generic_Report_Template.rpt Modified : /RPT/Unprocessed_Reports/SIRV_Assists.rpt Modified : /RPT/Unprocessed_Reports/Speeds_at_Detector.rpt Modified : /RPT/Unprocessed_Reports/Suspect_Data_Report.rpt Modified : /RPT/Unprocessed_Reports/Traffic_Detection_Rollup_Data_Tabular.rpt Modified : /RPT/Unprocessed_Reports/Traffic_Flow_Report.rpt Modified : /RPT/Unprocessed_Reports/Traffic_Sensor_Links.rpt Modified : /RPT/Unprocessed_Reports/Traffic_Volumes_Report.rpt Modified : /RPT/Unprocessed_Reports/Traveler_Advisory_Messages.rpt Modified : /RPT/Unprocessed_Reports/Typical_Volumes_at_Detector.rpt Modified : /RPT/Unprocessed_Reports/Variable_Speed_Limits_Posted.rpt Modified : /RPT/Unprocessed_Reports/Vehicle_GPS_Location_Report.rpt Modified : /RPT/Unprocessed_Reports/Vehicle_Location_Report.rpt Modified : /RPT/Unprocessed_Reports/Video_Switch_Report.rpt Modified : /RPT/Unprocessed_Reports/VisioPaD_Summary_Report.rpt Revision: 1235 Author: vjohnson Date: 3:24:31 PM, Wednesday, February 13, 2013 Message: Revised versioning Formatted page headers and footers ---- Modified : /RPT/Unprocessed_Reports/VisioPaD_Summary_Report.rpt Revision: 951 Author: tessadm Date: 3:37:15 PM, Thursday, January 12, 2012 Message: ---- Modified : /RPT/Unprocessed_Reports/Typical_Volumes_at_Detector.rpt Modified : /RPT/Unprocessed_Reports/Variable_Speed_Limits_Posted.rpt Modified : /RPT/Unprocessed_Reports/Vehicle_GPS_Location_Report.rpt Modified : /RPT/Unprocessed_Reports/Vehicle_Location_Report.rpt Modified : /RPT/Unprocessed_Reports/Video_Switch_Report.rpt Modified : /RPT/Unprocessed_Reports/VisioPaD_Summary_Report.rpt Revision: 869 Author: britchson Date: 9:37:29 AM, Tuesday, November 15, 2011 Message: ---- Deleted : /RPT/SunGuide_Reports Added : /RPT/Unprocessed_Reports/Detector_List_Report.rpt (Copy from path: /RPT/SunGuide_Reports/DetectorList.rpt, Revision, 866) Deleted : /RPT/Unprocessed_Reports/VisioPaD_Summary_2009.11.02.rpt Added : /RPT/Unprocessed_Reports/QAR_DMS_Safety_Message_Campaign.rpt (Copy from path: /RPT/QAR/QAR_DMS_Safety_Message_Campaign.rpt, Revision, 866) Added : /RPT/Unprocessed_Reports/Road_Ranger_Duplicate_Activity_Report.rpt (Copy from path: /RPT/RoadRangers/Road_Ranger_Duplicate_Activity_Report.rpt, Revision, 866) Deleted : /RPT/CRTemplate.rpt Deleted : /RPT/PM Deleted : /RPT/QAR Deleted : /RPT/RoadRangers Deleted : /RPT/TrafficDetection Deleted : /RPT/TvtReliability Added : /RPT/Unprocessed_Reports/VisioPaD_Summary_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/VisioPaD_Summary_2009.11.02.rpt, Revision, 866) Deleted : /RPT/VisioPaD Added : /RPT/old/CRTemplate.rpt (Copy from path: /RPT/CRTemplate.rpt, Revision, 866) Added : /RPT/old/PM (Copy from path: /RPT/PM, Revision, 866) Added : /RPT/old/RoadRangers (Copy from path: /RPT/RoadRangers, Revision, 866) Deleted : /RPT/old/RoadRangers/Road_Ranger_Duplicate_Activity_Report.rpt Added : /RPT/old/SunGuide_Reports (Copy from path: /RPT/SunGuide_Reports, Revision, 866) Deleted : /RPT/old/SunGuide_Reports/DetectorList.rpt Added : /RPT/old/TrafficDetection (Copy from path: /RPT/TrafficDetection, Revision, 866) Added : /RPT/old/TvtReliability (Copy from path: /RPT/TvtReliability, Revision, 866) Added : /RPT/old/VisioPaD (Copy from path: /RPT/VisioPaD, Revision, 866) Revision: 866 Author: britchson Date: 9:11:41 AM, Tuesday, November 15, 2011 Message: ---- Added : /RPT/Unprocessed_Reports Added : /RPT/Unprocessed_Reports/DMS_Report.rpt Added : /RPT/Unprocessed_Reports/DMS_Messages.rpt Added : /RPT/Unprocessed_Reports/DMS_Usage_Report.rpt Added : /RPT/Unprocessed_Reports/511_Message_and_Travel_Time_Report.rpt Added : /RPT/Unprocessed_Reports/Agency_Response_Times_Report.rpt Added : /RPT/Unprocessed_Reports/Average_Speed_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Bar_Graph_of_Total_Volume_By_Direction_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Basic_Safety_Messages.rpt Added : /RPT/Unprocessed_Reports/Beat_Coverage_Summary.rpt Added : /RPT/Unprocessed_Reports/CCTV_Report.rpt Added : /RPT/Unprocessed_Reports/Camera_Usage_Report.rpt Added : /RPT/Unprocessed_Reports/Central_Computer_System_Report.rpt Added : /RPT/Unprocessed_Reports/Daily_Chronology.rpt Added : /RPT/Unprocessed_Reports/Detector_Data_Detail.rpt Added : /RPT/Unprocessed_Reports/Detector_Speed_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Detector_Speed_Tabular.rpt Added : /RPT/Unprocessed_Reports/Detector_Volume_Bar_Graph.rpt Added : /RPT/Unprocessed_Reports/Detector_Volume_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Detector_Volume_Tabular.rpt Added : /RPT/Unprocessed_Reports/Event_Chronology.rpt Added : /RPT/Unprocessed_Reports/Event_Details.rpt Added : /RPT/Unprocessed_Reports/Event_Lane_Blockage_Report.rpt Added : /RPT/Unprocessed_Reports/Event_Level_Report.rpt Added : /RPT/Unprocessed_Reports/Event_List.rpt Added : /RPT/Unprocessed_Reports/Event_Response_Times_Report.rpt Added : /RPT/Unprocessed_Reports/Event_Summary_Report.rpt Added : /RPT/Unprocessed_Reports/FHP_Request.rpt Added : /RPT/Unprocessed_Reports/IDS_Alert_Types_Summary.rpt Added : /RPT/Unprocessed_Reports/Incident_Management_Monthly_Report.rpt Added : /RPT/Unprocessed_Reports/Notifier_Contact_Summary.rpt Added : /RPT/Unprocessed_Reports/Probe_Vehicle_Data_Messages.rpt Added : /RPT/Unprocessed_Reports/Ramp_Meters_Report.rpt Added : /RPT/Unprocessed_Reports/Regional_Floodgate_Messages.rpt Modified : /RPT/DetectorReliability/DetectorCalibration.rpt Added : /RPT/Unprocessed_Reports/AVL_Report.rpt Added : /RPT/Unprocessed_Reports/Annual_Incident_Duration_Summary.rpt Added : /RPT/Unprocessed_Reports/DMS_FilteredMessages_for_Safety.rpt Added : /RPT/Unprocessed_Reports/FAT2_Report_Generic_Template.rpt Added : /RPT/Unprocessed_Reports/FAT2_Report_Parameter_List.xls Added : /RPT/Unprocessed_Reports/FDOT_Logo.jpg Added : /RPT/Unprocessed_Reports/Incident_Duration_Flagged_Events.rpt Added : /RPT/Unprocessed_Reports/Incident_Duration_Full_Detail.rpt Added : /RPT/Unprocessed_Reports/Monthly_Performance_Measures_Report.rpt Added : /RPT/Unprocessed_Reports/QA_Report.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Flagged_Events.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Full_Detail.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Performance_Report.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Summary.rpt Added : /RPT/Unprocessed_Reports/RSE_Device_Status_History.rpt Added : /RPT/Unprocessed_Reports/RWIS_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Details_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Summary_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Administration.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Administration_Summary.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Assists.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Cost_Savings_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Status_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Void_Activity_Report.rpt Added : /RPT/Unprocessed_Reports/SIRV_Assists.rpt Added : /RPT/Unprocessed_Reports/Safety_Barriers_Report.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Speed.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Speed_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_and_Speed_Tabular.rpt Added : /RPT/Unprocessed_Reports/Segment_Travel_Time_Detail_For_Last_Hour.rpt Added : /RPT/Unprocessed_Reports/Segment_Travel_Time_and_Speed.rpt Added : /RPT/Unprocessed_Reports/Speeds_at_Detector.rpt Added : /RPT/Unprocessed_Reports/SunGuide_Logo.jpg Added : /RPT/Unprocessed_Reports/Suspect_Data_Report.rpt Added : /RPT/Unprocessed_Reports/TSS_Report.rpt Added : /RPT/Unprocessed_Reports/Total_Volume_By_Direction_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Traffic_Flow_Report.rpt Added : /RPT/Unprocessed_Reports/Traffic_Volumes_Report.rpt Added : /RPT/Unprocessed_Reports/Traveler_Advisory_Messages.rpt Added : /RPT/Unprocessed_Reports/Typical_Volumes_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Variable_Speed_Limits_Posted.rpt Added : /RPT/Unprocessed_Reports/Vehicle_GPS_Location_Report.rpt Added : /RPT/Unprocessed_Reports/Vehicle_Location_Report.rpt Added : /RPT/Unprocessed_Reports/Video_Switch_Report.rpt Added : /RPT/Unprocessed_Reports/VisioPaD_Summary_2009.11.02.rpt Added : /RPT/Unprocessed_Reports/Weekly_Performance_Measures_Report.rpt Added : /RPT/Unprocessed_Reports/Yearly_Performance_Measures_Report.rpt