Installation and Training for the District 21 (Pharr) Pavement Management System
Description:... This project pertains to the design and implementation of a microcomputer database system to interface with the current TxDOT statewide mainframe PMIS system. Persons interested in the statewide PMIS system should direct inquiries to the Pavement Management Section Design Division, Texas Department of Transportation. This effort, conducted over a five-year period, has produced a now operational DOS/Windows-based system to download data and pavement scores from the TxDOT mainframe system in Austin, Texas. The system's design is based on the DOS-based DataEase relational database system. Collected pavement data and associated scores are down loaded from Austin to Pharr via 3270 communications link. The import data file is produced by a SAS-JCL job that produces an ASCII file suitable for importation into the district's microcomputer PMIS. Importing at the district level is accomplished by matching the reference marker location fields in the import files to the district level database receiving file's reference marker location fields. The district-level system is then used to assist district personnel in retrieving, sorting, and presenting information (pavement scores) in a timely manner. The system possesses the capability to adjust/modify the data summarization reports and plots to suit individual situations with short time intervals. The current design consists of 10 separate database files, one for each county comprising District 21. The files are structured to store location collected pavement data and associate pavement scores based upon 0.1 mile increments. The current design stores ride, skid, falling weight, and visual data. An additional database file supports the temporary archiving of critical highway segments based upon prespecified critical score values. This file can be sorted in numerous ways in order to rank segments as required and to aid in the formulation of maintenance/rehabilitation strategies within the district.
Show description