Table 1 Projects data source, relevant attributes and description

DCIS

(Comma Separated Values - CSV)

• Project description

• Spatial (county, highway, reference markers, DFO)

• Temporal (fiscal year and letting dates)

• Cost (construction cost estimate)

This is a statewide automated information system which allows all district offices of TxDOT to manage projects data in a consistent common format. It mostly contains highway projects funded by all the 12 categories of funding by TxDOT.

COMPASS

(Hypertext markup language - Html)

• Activity description

• Spatial (county, highway)

• Temporal (fiscal year and letting dates)

• Cost (construction, equipment, labor, materials estimate)

The COMPASS system is the Maintenance Management Information System (MMIS) of TxDOT that allows districts to manage maintenance activities that are more routine and are usually of a smaller scope.

Highway Inventory Data - PMIS

(Excel spreadsheet - xls*)

• Spatial (county, highway, reference markers, DFO)

• Road condition data (distress, ride, skid, and condition scores)

• Pavement roadbed information (main lanes or frontage roads, single or divided roadbeds)

• Traffic data (AADT, etc.)

PMIS is a comprehensive database on the entire network of the state-maintained highway system. It contains extensive information for each pavement section in the entire network.

On-system Highway Network (Shapefile - shp)

• Spatial (county, highway, reference markers, DFO)

• Pavement roadbed information (main lanes or frontage roads, single or divided roadbeds)

This is a “polyline” shapefile which was used as the “route event” feature dataset on which events/projects were visualized. It contains all the relevant spatial attributes and features to visualize projects in GIS.

Auxiliary:

County Boundaries and Reference Markers

(Shapefile - shp)

• Spatial (county, reference markers, DFO)

• County polygons

These are “polygon” and “point” shapefiles that contain the county delineations and linear reference markers respectively.