Database Development for Load Zones in Texas

 

 Pithon Vithayasricharoen

Department of Civil Engineering

University of Texas at Austin

pithon@mail.utexas.edu

 

CE 394K: GIS in Water Resources

Dr. David R. Maidment

 



Introduction

 

There are more than 17,000 miles of load-restricted highways in Texas. These transportation infrastructure facilities were generally constructed prior to the late 1950s, and were designed for lighter wheel loads and axle configurations than are currently allowed by law. In addition, environmental effects have weakened some of these structures. In an effort to protect these facilities from accelerated deterioration, a provision exists in the state law whereby those transportation infrastructure facilities may be legally posted to restrict excessive loading, which means that trucks with the gross load, axle load, axle configuration, length, and width beyond the current size and weight laws cannot pass such road sections.

 

Currently, the Construction Division Pavements Section manages a database of load-restricted highways and bridge structures maintained by the Texas Department of Transportation (TxDOT). This database is currently not accessible to anyone outside of the Pavements Section. Moreover, the geographic location information of the restricted zones is not available in such database. It means that the database is only in tabular format, which is somewhat difficult for related people to understand the distribution of the load-restricted zones. As a result, TxDOT is interested to develop a database containing the spatial information of the load-restricted zones on the road system of Texas.

 

This term project focuses on the development of a procedure for projecting the load-restricted zones on a road map of Texas. It is an initial development of a GIS-integrated database of load-restricted zone on highway system.

 

 

Go to Top


Objectives

 

The objectives of this study are shown as follows:

 

 

Go to Top


Data Sources

 

There were five sets of data used in this project shown as follows:

 

1.   The polygon shapefile displaying the boundary of the state of Texas downloaded from the USGS web site.  

 

2.   The polygon shapefile of the counties of Texas. This file is also available in the USGS web site.  

 

3.   The street network shapefile of Travis County. This file is available in the Bureau of Transportation Statistics web site (BTS). It contains the information shown as follows:  

 

 

4.   The load-restricted zone database obtained from the Texas Department of Transportation (TxDOT). It contains the information as shown below: 

 

5.   The Milepoint Reference Marker database obtained from the Center for Transportation Research (CTR).  

 

 

Go to Top


Background Information

 

Texas Reference Marker System

 

The load-restricted location information of the road network in Texas are coded and referenced based on the Texas Reference Marker System. This system uses Reference Marker Group, which consists of the Reference Marker Number, Reference Marker Sign, and Reference Marker Displacement, to identify the locations of roadway data. The definitions of each component are given below:  

   

raster

 

Figure 1: An Example of the Reference Marker

 

 

 

 

Go to Top


Linear Referencing and Dynamic Segmentation

 

Highway, city streets, railroads, and rivers, as well as distribution networks such as telephone lines and water and sewer networks, are all examples of linear features. To model these features effectively, good understanding and ability to appropriately analyze them are needed.

 

Geographic information systems often represent spatial information with a two-dimensional x,y coordinate system. This is good for representing the locations of boundaries, water bodies, and road networks. However, only x,y coordinate system sometimes is not useful for representing linear features. Instead of using x,y measurements, the better way of representing linear features is to use the x,y,m coordinate system. In this coordinate system, each point along a linear feature has a measure value (m value) in addition to x,y coordinates. For example, route I-10, m = 23 kilometer, uniquely identifies a position in geographic space without having to express it in x,y coordinates or latitude-longitude terms. This is so called linear referencing. The measure values along a road network are useful to find out the distance between any two points on the network.

 

In this study, dynamic segmentation is the tool that is capable of projecting the load-restricted zone on the road network in Texas. Dynamic segmentation allows multiple sets of attributes to be associated with any portion of a linear feature. These attributes can be stored, displayed, queried, and analyzed without affecting the x,y coordinate data of linear features.

 

 

There are two components required to perform dynamic segmentation which are:

 

 

 

There are two requirements for performing dynamic segmentation, which are:

   

 

Go to Top 


Methodology

 

Pilot test was done for the Travis County in Texas in order to verify the effectiveness of the procedure developed in this project. Each step of the procedure is described as follows.

 

Create a Geodatabase, a Feature Dataset, Feature Classes

 

Because the objective of this study is to project the load-restricted zones on a road map of Texas based on the concepts of linear referencing and dynamic segmentation, all feature classes are needed to have the same spatial reference. This means that all feature classes should be stored in the same feature dataset within the Geodatabase. The tasks in this step are listed as follows:

 

Go to Top


Combine Features Based on an Attribute

 

In order to perform dynamic segmentation, each route must have a unique identifier as stated above. The identifier used in this project is the Highway Name because it is the only identifier that can be linked between load-restricted zone database and the street network shapefile. However, the shapefile obtained from BTS divides each highway into many sections as shown in the Figure 2.

 

 

 

Figure 2: An Example of a Highway with Many Sections

 

 

Therefore, Features that have the same Highway Name were aggregated into only one feature by following these steps.

 

 

Based on these steps, the new shape file, TravisRoad.shp, was created. This shapefile was used as a route in the dynamic segmentation process. This shapefile has a unique identifier which is the Highway Name.

 

 

   

Figure 3: Dissolve Features based on an Attribute Function within the Geoprocessing Wizard

   

Go to Top


Export the TravisRoad Shapefile to the Geodatabase

 

Feature classes existing in a Geodatabase cannot be modified to store measure values. When feature classes are migrated to a Geodatabase for dynamic segmentation process, they must already have measure values (M values) enabled or the ability to store M values must be set before exporting a shapefile to a Geodatabase. The tasks in this step are described as follows:

 

 

Figure 4: Shapefile to Geodatabase Dialog Box

 

 

 

Figure 5: Enable M values on the Output Checkbox in the Geometry Tab

 

 

 

Figure 6: M Domain Tab in the Spatial Reference Dialog Box.

 

 

 

After following these tasks, the TravisRoad feature class will have PolylineM geometry which can be used to stored measure values (M values).

 

 

Figure 7: TravisRoad Feature Class having the PolylineM Geometry

 

Go to Top


Assign Measure Values (M Values) to the New Polyline Feature Class (TravisRoad)

 

Considering the TravisRoad Feature Class, all the vertices of any single feature are visible if such feature is selected. An example of the sketch vertices of Ranch Road 620 feature along with its measure values (M values) is shown in Figure 8. It should be noted that the M values are Not a Number (NaN) because TravisRoad is a newly created feature class. Therefore, measure values have never been assigned to any feature of this feature class.  In order to see these vertices, the following tasks are needed.

 

   

   

Figure 8: The sketch vertices of Ranch Road 620 feature along with its measure values (M values) set to NaN.

 

 

The Measure Values (M Values) can be assigned to all features of the TravisRoad Feature Class following these steps:

 

   

 

Figure 9: Calculate Values function  within the Shape Field.

 

 

   

Figure 10: Field Calculator Dialog Box

 

 

The VBA script code will get the length of each feature based on the Shape_Length attribute to define the maximum Measure Values of that feature. Measure Values will be interpolated between 0 and the maximum Measure Values. It should be noted that IMSegmentation is the important interface which makes use of Dynamic Segmentation in ArcGIS. SetAndInterpolateMsBetween is the method associated with IMSegmentation. This method sets the Measure Values at the beginning and the end of the geometry and interpolates the M values between these values.

 

Eventually, the NaN values in the M column have been replaced by the Measure Values populated by the VBA script in the Field Calculator Dialog Box.

 

 

Figure 11: The sketch vertices of Ranch Road 620 feature along with its measure values (M values).

   

Go to Top


Create the Route Events Table

 

Load-restricted zone of the highways in Texas are coded and referenced based on the Texas Reference Marker System known as Milepoint Reference Marker. However, to perform the Dynamic Segmentation, the Measure Values (M Values) along linear features are needed. In order to convert the Milepoint Reference Marker to the Measure Values (M Values), the Distance from Origin attribute of the Milepoint Reference Marker database obtained from CTR is needed. It should be noted that the Load-restricted Zone database and the Milepoint Reference Marker database are in the Microsoft Access format.

 

Because there are more than 2500 records of load-restricted zone, it would be very hard to manually convert the Milepoint Reference Marker to the Measure Values (M Values). Therefore, source code was generated in the Microsoft Visual Basic, known as object-oriented programming, in order to create the Route Events Table for using in the dynamic segmentation process. This source code will read the Reference Marker Number, Reference Marker Sign, and Reference Marker Displacement of both the beginning and end of load-restricted zones from the load-restricted zone database. The Reference Marker Numbers will then be used to extract the Distance from Origin (miles) of each Reference Marker Number from the Milepoint Reference Marker database.  Eventually, Reference Marker Sign, and Reference Marker Displacement will be incorporated with the Distance from Origin obtained from the Milepoint Reference Marker in order to calculate the Measure Values (M values) of the beginning and end of load-restricted zones. It should be noted that the measure values obtained from this application have already been converted into units of meters.

 

   

Figure 12: Visual Basic Application for creating the Route Events Table of selected county.

 

 

This application is capable of creating the Route Events table for the load-restricted zones of each county. The Route Events Table created by this application will be automatically stored in Microsoft Access file. This access file will then be exported as a dBase file to be used as a Route Events Table in the Dynamic Segmentation process. In this study, the route events table of the load-restricted zones of Travis County was created as shown in Figure 13.

 

 

Figure 13: The Route Events Tables for the Load-restricted Zones of Travis Counties

   

Go to Top


Add Route Events Table in ArcGIS

 

In this step, events will be transformed into features that can be displayed and analyzed on a map. The Add Route Events Dialog Box is used to transform an event table in ArcMap. Each of the tasks in this step is listed as follows.

 

 

Figure 14 shows the Add Route Events Dialog Box and all specified attributes.

 

 

 

Figure 14: Add Route Events Dialog Box

 

Go to Top


Results

 

The following figure shows the Load-restricted Zone of the highways in Travis County.

 

 

 

Figure 15: Load-Restricted Zone of highways in Travis County

 

 

 Go to Top


Conclusions

   

  1. GIS is a powerful tool to manage information from different types of data.

  2. GIS can display the results of a complex analysis in a graphical format.

  3. The concepts of Linear Referencing and Dynamic Segmentation are very useful to model and analyze the linear features using routes and route events.

  4. GIS appears to be a tool that can help the analyst pinpoint locations that require further study.

  5. The GIS capabilities make better and more objective information available to the decision making process.

Go to Top


Future Work

 

The future work should consider the following tasks:

 

Go to Top


References

 

Go to Top


Acknowledgements

 

Go to Top


 

Go Back to Courses Page