5. ESPERANZA DE VIDA LIBRE DE DISCAPACIDAD: 2004-2006
5.1. RESULTADOS A NIVEL NACIONAL
20. File Management
Introduction
Overview
This chapter describes the file structures for the ROMDAS data. It is divided into the following sections:
File Locations. The locations and types of files saved by ROMDAS.
File Structures – Survey Setup and Management Files. The structures of files and tables used for setting up and managing surveys.
File Structures – Headers and Survey Raw Data. The structures of files and tables storing raw survey data.
File Structures – Processed Data. The structures of files and tables containing processed survey data.
File Locations
Folders
As shown the right, the ROMDAS files are stored in the following folders:
Calibration: Files associated with instrument calibration.
Setup: Files associated with setting up the software.
Survey Data: Files from actual surveys. The survey data are stored in different folders depending upon the type of data:
Audio, Data, Photo or Videos.
Data Files
All survey data is recorded in a binary format file (rbf). The rbf files can be processed to produce Access .mdb files. The file names are taken from the Survey File field in the Survey Setup dialog. For example, a Survey File of SH16 would result in the file SH16.mdb. The various survey exported raw, header and processed information is stored in Access tables within the Access mdb database file.
Audio Files
Internally recorded audio files are stored as Microsoft Wave Sound .wav files. The file names are the Survey ID and the recording number. For example, the first recording for Survey ID of SH16 would result in the file SH16-1.wav; the second SH16-2.wav; etc.
File Structures – Survey Setup and Management Files
Overview
Survey management and setup files are files used to for storing survey parameters (e.g. keyboard rating files) or managing survey results.
Keycode.mdb Keycode rating events
Predefined Keycode Comments
Survey Definition.mdb Survey and Road definition data
Vehicles.mdb Odometer calibration data Vehicle calibration history
LRP.mdb LRP Predefinitions
Copy of all LRP Files
ADT Cal. Factors.mdb Moving traffic survey ADT factors
AADT Adj. Factors.mdb Moving traffic survey AADT factors Keycode Event
Function: Keyboard rating events Location: Setup folder
File Name: Keycode.mdb Table Name: Keycode
20 File Management
Odometer Calibration Factors
Function: Stores the odometer calibration factor for each vehicle Location: Calibration folder
File Name: Vehicles.mdb Table Name: Odo_Calibration
Vehicle Calibration Log
Function: Records when each vehicle was calibrated Location: Calibration folder
File Name: Vehicles.mdb Table Name: Vehicle
LRP Pre-Definition
Function: Provides shortcut key for entering LRPs during survey Location: Setup folder
File Name: LRP.mdb Table Name: LRP_Def
Survey Log
Function: To provide a permanent record of the options and surveys done each day Location: Survey Data folder
File Name: Survey Definition.mdb Table Names: Survey
ADT Calibration Factors
Function: To convert moving traffic survey hourly flows to AADT Location: Calibration folder
File Name: ADT Calibration Factors.mdb Table Names: User Defined
AADT Adjustment Factors
Function: To convert moving traffic survey ADT estimate to an AADT Location: Calibration folder
File Name: AADT Adjustment Factors.mdb Table Names: User Defined
Laser Elevation Test Header
Function: To record Laser Elevation Test Details Location: Calibration folder
File Name: Laser Calibration.mdb Table Names: Elev_Headers
20 File Management
Laser Elevation Test Data
Function: To record Laser Elevation Test Data Location: Calibration folder
File Name: Laser Calibration.mdb
Table Names: Elev_Data_User supplied name
Laser Elevation Test Packet Diagnostic Data
Function: To record Laser Elevation Test Packet Data. This table is for DCL diagnostics.
Location: Calibration folder File Name: Laser Calibration.mdb
Table Names: Elev_pkt_User supplied name
Laser Bounce Test
Function: To record Laser Bounce Test Data Location: Calibration folder
File Name: Laser Calibration.mdb
Table Names: Bounce_Profile_User supplied name
Table Structures – Headers and Raw Data
Overview
ROMDAS parameters for each instrument are processed into the Header tables for reference of the values used in the processing of the survey data.
Raw survey data output can also be processed for some instruments. Normally the raw data tables would not be processed unless additional information is required.
Survey Header Table
Function: Records key data for the survey Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Survey_Header (e.g. Survey_Header)
20 File Management
Raw BI Roughness Table
Function: Contains Roughness data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Roughness_Raw_Survey ID (e.g. Roughness_Raw_SH16)
GPS Header Table
Function: Contains GPS header data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: GPS_Header_Survey ID (e.g. GPS_Header_SH16) Height of GPS Antennae above road (m)
GPS Data Table
Function: Contains raw GPS data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: GPS_Raw_Survey ID (e.g. GPS_Raw_SH16)
Video Header Table
Function: Contains Video header data Location: Survey Data/Data folder
File Name: Survey ID.mdb (e.g. SH16.mdb)
Table Names: Video_Header_Survey ID (e.g. Video_ Header_SH16)
Video Data Table
Function: Contains Video raw data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Video_Raw_Survey ID (e.g. Video_Raw_SH16)
TPL Header Table
Function: Contains TPL header data Location: Survey Data/Data folder
File Name: Survey ID.mdb (e.g. SH16.mdb)
Table Names: TPL_Header_Survey ID (e.g. TPL_ Header_SH16)
20 File Management
TPL Data Table
Function: Contains TPL raw data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: TPL_Raw_Survey ID (e.g. TPL_Raw_SH16)
Geometry Header Table
Function: Contains Geometry header data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Geometry_Header_Survey ID (e.g. Geometry_Header_SH16)
Geometry Data Table
Function: Contains raw Geometry data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Geometry_Raw_Survey ID (e.g. Geometry_Raw_SH16)
TPL-LRMS Header Table
Function: Contains TPL-LRMS header data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LRMS_Header_Survey ID (e.g. LRMS_Header_SH16)
20 File Management
TPL-LRMS Raw Data Table
Function: Contains raw TPL-LRMS data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LRMS_Raw_Survey ID (e.g. LRMS_Raw_SH16)
LCMS Header Table
Function: Contains LCMS header data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LRMS_Header_Survey ID (e.g. LRMS_Header_SH16)
Travel Time Header Table
Function: Contains Travel Time header data Location: Survey Data/Data folder
File Name: Survey ID.mdb (e.g. SH16.mdb)
Table Names: TravelTime_Header_Survey ID (e.g. TravelTime_Header_SH16)
Travel Time Data Table
Function: Contains Travel Time raw data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: TravelTime_Raw_Survey ID (e.g. TPL_Raw_SH16)
20 File Management
Table Structures – Processed Data
Overview
The processed data tables contain the processed data. ROMDAS raw data collected in the surveys is processed under the Data Processing menu option.
Keyboard Rating Table
Function: Contains keyboard rating data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Keycode_Raw_Survey ID (e.g. Keycode_Raw_SH16)
Digital Photo Table
Function: Contains Digital Photo data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Digital_Camera_Picture_ Survey ID (e.g. Digital_Camera_Picture _SH16)
LRP Table
Function: Contains LRP data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LRP_Survey ID (e.g. LRP_SH16)
GPS Processed Data
Function: Contains processed GPS data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: GPS_Processed_Survey ID (e.g. GPS_Processed_SH16)
Video Processed Data
Function: Contains processed Video frame data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Video_Processed_Survey ID (e.g. GPS_Processed_SH16)
20 File Management
Roughness Processed Data
Function: Contains processed Roughness BI data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Roughness_Processed_Survey ID (e.g. Roughness_ Processed_SH16)
TPL Processed Data
Function: Contains processed TPL data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: TPL_Processed_Survey ID (e.g. TPL_ Processed_SH16)
Travel Time Processed Data
Function: Contains processed Travel Time data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: TravelTime_ Processed_Survey ID (e.g. Traveltime_processed_SH16)
TPL-LRMS Processed Data
Function: Contains processed TPL-LRMS or LCMS Rutting data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LRMS_Processed_Survey ID or LCMS_Rut_Processed_Survey ID (e.g. LRMS_Processed_SH16)
20 File Management
Geometry Processed Data
Function: Contains processed LRMS data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Geometry_Processed_Survey ID (e.g. Geometry_Processed_SH16)
Laser Profiler Processed Data
Function: Contains processed Laser Profilometer data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Plaser_IRI_Survey ID (e.g. Plaser_IRI_SH16)
Texture Processed Data (SMTD)
Function: Contains processed SMTD Texture data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: Plaser_SMTD_Survey ID (e.g. Plaser_SMTD_SH16)
LCMS Crack Processed Data
Function: Contains processed Crack data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_Crack_Processed_Survey ID (e.g. LCMS_Crack_Processed_SH16)
LCMS Pothole Processed Data
Function: Contains processed Pothole data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_Potholes_Processed_Survey ID (e.g. LCMS_Potholes_Processed_SH16)
20 File Management
LCMS Texture Processed Data (MPD)
Function: Contains processed MPD Texture data in Five longitudinal Bands (Central and Wheelpath band width is configurable)
Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_Texture_Processed_Survey ID (e.g. LCMS_Texture_Processed_SH16)
LCMS Rutting Processed Data
Function: Contains processed Rutting data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_Rut_Processed_Survey ID (e.g. LCMS_Rut_Processed_SH16)
LCMS Lane Width Processed Data
Function: Contains processed Lane Width data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_LaneWidth_Processed_Survey ID (e.g. LCMS_LaneWidth_Processed_SH16)
LCMS Ravelling Processed Data
Function: Contains processed Ravelling data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_Ravelling_Processed_Survey ID (e.g. LCMS_Ravelling_Processed_SH16)
20 File Management
LCMS Concrete Joint Faulting Processed Data
Function: Contains processed Concrete Joint and Faulting data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_LaneWidth_Processed_Survey ID (e.g. LCMS_LaneWidth_Processed_SH16)
LCMS Roughness Processed Data
Function: Contains processed Roughness data Location: Survey Data/Data folder
File Name: Survey File.mdb (e.g. SH16.mdb)
Table Names: LCMS_Rough_Processed_Survey ID (e.g. LCMS_Rough_Processed_SH16)
Other Processed Data Files
LCMS XML String File
Function: Contains all LCMS data in XML file. One file for each LCMS Road Section.
Location: LCMS Data folder
File Name: Survey File_Road Section Number.XML (e.g. SH16_000001.XML)
LCMS Roughness Profile Output
Function: Contains LCMS roughness profile in ProVal ppf file. One file for each Wheelpath.
Location: LCMS Data folder
File Name: Survey File_Road Section Number.ppf (e.g. SH16_000001.ppf)
LCMS Roughness csv Output
Function: Contains LCMS roughness data in csv file. One file for each Wheelpath.
Location: LCMS Data folder
File Name: Survey File_Road Section Number.csv (e.g. SH16_000001.csv)
LCMS Overlay Image File
Function: JPEG Intensity image of LCMS Crack data and Road Markings overlaid onto Road section Image. One file for each LCMS Road Section.
Location: LCMS Data folder
File Name: Survey File_Road Section Number.jpg (e.g. SH16_000001.jpg)
20 File Management
Laser profiler ERD file (Text or Binary)
Function: Contains road longitudinal profile data in ERD format that can be imported into ProVal or RoadRuf software for further analysis
Location: Survey Data/Data folder
File Name: Survey File.ERD (e.g. SH16.ERD)
Note: output of text or binary output file has the same name and will therefore overwrite each other.