Report on a review of selected general and application controls over the University of Northern Iowa Facility Administration and Maintenance Information System for the period April 29, 2014 through June 5, 2014

Report on a review of selected general and application controls over the University of Northern Iowa Facility Administration and Maintenance Information System for the period April 29, 2014 through June 5, 2014

A Computer-Aided Decision Support System for Making Locational Decisions, 1990

This report is the product of a first-year research project in the University Transportation Centers Program. This project was carried out by an interdisciplinary research team at The University of Iowa's Public Policy Center. The project developed a computerized system to support decisions on locating facilities that serve rural areas while minimizing transportation costs. The system integrates transportation databases with algorithms that specify efficient locations and allocate demand efficiently to service regions; the results of these algorithms are used interactively by decision makers. The authors developed documentation for the system so that others could apply it to estimate the transportation and route requirements of alternative locations and identify locations that meet certain criteria with the least cost. The system was developed and tested on two transportation-related problems in Iowa, and this report uses these applications to illustrate how the system can be used.

Web-based Implementation of Winter Maintenance Decision Support System Using GIS and Remote Sensing, May 2005

Winter maintenance, particularly snow removal and the stress of snow removal materials on public structures, is an enormous budgetary burden on municipalities and nongovernmental maintenance organizations in cold climates. Lately, geospatial technologies such as remote sensing, geographic information systems (GIS), and decision support tools are roviding a valuable tool for planning snow removal operations. A few researchers recently used geospatial technologies to develop winter maintenance tools. However, most of these winter maintenance tools, while having the potential to address some of these information needs, are not typically placed in the hands of planners and other interested stakeholders. Most tools are not constructed with a nontechnical user in mind and lack an easyto-use, easily understood interface. A major goal of this project was to implement a web-based Winter Maintenance Decision Support System (WMDSS) that enhances the capacity of stakeholders (city/county planners, resource managers, transportation personnel, citizens, and policy makers) to evaluate different procedures for managing snow removal assets optimally. This was accomplished by integrating geospatial analytical techniques (GIS and remote sensing), the existing snow removal asset management system, and webbased spatial decision support systems. The web-based system was implemented using the ESRI ArcIMS ActiveX Connector and related web technologies, such as Active Server Pages, JavaScript, HTML, and XML. The expert knowledge on snow removal procedures is gathered and integrated into the system in the form of encoded business rules using Visual Rule Studio. The system developed not only manages the resources but also provides expert advice to assist complex decision making, such as routing, optimal resource allocation, and monitoring live weather information. This system was developed in collaboration with Black Hawk County, IA, the city of Columbia, MO, and the Iowa Department of transportation. This product was also demonstrated for these agencies to improve the usability and applicability of the system.

Review of State Comprehensive Computerized Highway Information System, HR-1053, 1987

This report presents an overview of where the computerized highway information system is now, and its status as a planning and programming tool for state highway agencies. A computerized highway information system is simply a computer linked system which can be used by many divisions of a transportation agency to obtain information to meet data reporting, analyses or other informational needs. The description of the highway information system includes: current use and status, applications, organization and system development, benefits and problems.

Deploying the Maintenance Decision Support System (MDSS) in Iowa, 2003

Adverse weather conditions dramatically affect the nation’s surface transportation system. The development of a prototype winter Maintenance Decision Support System (MDSS) is part of the Federal Highway Administration’s effort to produce a prototype tool for decision support to winter road maintenance managers to help make the highways safer for the traveling public. The MDSS is based on leading diagnostic and prognostic weather research capabilities and road condition algorithms, which are being developed at national research centers. In 2003, the Iowa Department of Transportation was chosen as a field test bed for the continuing development of this important research program. The Center for Transportation Research and Education assisted the Iowa Department of Transportation by collecting and analyzing surface condition data. The Federal Highway Administration also selected five national research centers to participate in the development of the prototype MDSS. It is anticipated that components of the prototype MDSS system developed by this project will ultimately be deployed by road operating agencies, including state departments of transportation, and generally supplied by private vendors.

Effective Shoulder Design and Maintenance, 2007

Granular shoulders are an important element of the transportation system and are constantly subjected to performance problems due to wind- and water-induced erosion, rutting, edge drop-off, and slope irregularities. Such problems can directly affect drivers’ safety and often require regular maintenance. The present research study was undertaken to investigate the factors contributing to these performance problems and to propose new ideas to design and maintain granular shoulders while keeping ownership costs low. This report includes observations made during a field reconnaissance study, findings from an effort to stabilize the granular and subgrade layer at six shoulder test sections, and the results of a laboratory box study where a shoulder section overlying a soft foundation layer was simulated. Based on the research described in this report, the following changes are proposed to the construction and maintenance methods for granular shoulders: • A minimum CBR value for the granular and subgrade layer should be selected to alleviate edge drop-off and rutting formation. • For those constructing new shoulder sections, the design charts provided in this report can be used as a rapid guide based on an allowable rut depth. The charts can also be used to predict the behavior of existing shoulders. • In the case of existing shoulder sections overlying soft foundations, the use of geogrid or fly ash stabilization proved to be an effective technique for mitigating shoulder rutting.

Evaluation of Bridge Replacement Alternatives for the County Bridge System, HR-365 August 1994

Recent reports have indicated that 23.5 percent of the nation's highway bridges are structurally deficient and 17.7 percent are functionally obsolete. A significant number of these bridges are on the Iowa county road system. The objective of the investigation described in this report was to identify, review and evaluate replacement bridges currently being used by various counties in Iowa and surrounding states. Iowa county engineers, county engineers in neighboring states as well as private manufacturers of bridge components, and regional precad prestressed concrete manufacturers were contacted to determine the most common replacement bridge types being used. Depending upon the findings of the review, possible improvements and/or new replacement bridge systems were to be proposed. A questionnaire was developed and sent to county engineers in Iowa and several counties in surrounding states. The results of the questionnaire showed that the most common replacement bridges in Iowa are the continuous concrete slab and prestressed concrete bridges. The primary reason these types are used is because of the availability of standard designs and because of their ease of maintenance. Counties seldom construct these types of bridges using their own labor forces, but instead contract the work. However, county forces are used to construct steel stringer, precast reinforced concrete and timber bridges. In general, 69 percent of the counties indicate an ability and willingness to use their own forces to design and construct relatively short span bridges (i.e., 40 A or less) provided the construction procedures are relatively simple. Several unique replacement bridge types used in Iowa that are constructed by county forces are documented and presented in this report. Sufficient details are provided to allow county engineers to determine if some of these bridges could be used to resolve some of their own replacement bridge problems. Where possible, cost information has also been provided. Each of these bridge types were evaluated for various criteria (e.g., cost effectiveness, conformance to AASI-ITO standards, range of sizes, etc.) by a panel of four Iowa county engineers; a summary of this critique is included. After evaluating the questionnaire responses from the counties and evaluating the various bridge replacement concepts currently in use, one new bridge replacement concept and one modification of a current Iowa county bridge replacement concept were developed. Both of these concepts would utilize county labor forces.

Automated Recording of Bridge Inspection Data in the Pontis Format Final Report, HR-364 April 1995

A large percentage of bridges in the state of Iowa are classified as structurally or fiinctionally deficient. These bridges annually compete for a share of Iowa's limited transportation budget. To avoid an increase in the number of deficient bridges, the state of Iowa decided to implement a comprehensive Bridge Management System (BMS) and selected the Pontis BMS software as a bridge management tool. This program will be used to provide a selection of maintenance, repair, and replacement strategies for the bridge networks to achieve an efficient and possibly optimal allocation of resources. The Pontis BMS software uses a new rating system to evaluate extensive and detailed inspection data gathered for all bridge elements. To manually collect these data would be a highly time-consuming job. The objective of this work was to develop an automated-computerized methodology for an integrated data base that includes the rating conditions as defined in the Pontis program. Several of the available techniques that can be used to capture inspection data were reviewed, and the most suitable method was selected. To accomplish the objectives of this work, two userfriendly programs were developed. One program is used in the field to collect inspection data following a step-by-step procedure without the need to refer to the Pontis user's manuals. The other program is used in the office to read the inspection data and prepare input files for the Pontis BMS software. These two programs require users to have very limited knowledge of computers. On-line help screens as well as options for preparing, viewing, and printing inspection reports are also available. The developed data collection software will improve and expedite the process of conducting bridge inspections and preparing the required input files for the Pontis program. In addition, it will eliminate the need for large storage areas and will simplify retrieval of inspection data. Furthermore, the approach developed herein will facilitate transferring these captured data electronically between offices within the Iowa DOT and across the state.

Maintenance Asset Management Project -- Phase II, July 31, 2013

Expanded abstract: Iowa Department of Transportation (IA DOT) is finalizing research to streamline field inventory/inspection of culverts by Maintenance and Construction staff while maximizing the use of tablet technologies. The project began in 2011 to develop some new best practices for field staff to assist in the inventory, inspection and maintenance of assets along the roadway. The team has spent the past year working through the complexities of identifying the most appropriate tablet hardware for field data collection. A small scale deployment of tablets occurred in spring of 2013 to collect several safety related assets (culverts, signs, guardrail, and incidents). Data can be collected in disconnected or connected modes and there is an associated desktop environment where data can be viewed and queried after being synced into the master database. The development of a deployment plan and related workflow processes are underway; which will eventually feed information into IA DOTs larger asset management system and make the information available for decision making. The team is also working with the IA DOT Design Office on Computer Aided Drafting (CAD) data processing and the IA DOT Construction office with a new digital As-Built plan process to leverage the complete data life-cycle so information can be developed once and leveraged by the Maintenance staff farther along in the process.

Development of a GPS-Based Sign Inventory Tool for Iowa’s Statewide Management System, May 2011

This report is on state-of-the-art research efforts specific to infrastructure inventory/data collection with sign inventory as a case study. The development of an agency-wide sign inventory is based on feature inventory and location information. Specific to location, a quick and simple location acquisition tool is critical to tying assets to an accurate location-referencing system. This research effort provides a contrast between legacy referencing systems (route and milepost) and global positioning system- (GPS-) based techniques (latitude and longitude) integrated into a geographic information system (GIS) database. A summary comparison of field accuracies using a variety of consumer grade devices is also provided. This research, and the data collection tools developed, are critical in supporting the Iowa Department of Transportation (DOT) Statewide Sign Management System development effort. For the last two years, a Task Force has embarked on a comprehensive effort to develop a sign management system to improve sign quality, as well as to manage all aspects of signage, from request, ordering, fabricating, installing, maintaining, and ultimately removing, and to provide the ability to budget for these key assets on a statewide basis. This effort supported the development of a sign inventory tool and is the beginning of the development of a sign management system to support the Iowa DOT efforts in the consistent, cost effective, and objective decision making process when it comes to signs and their maintenance.

Development of an Expert System for Forecasting Frost on Bridges and Roadways in Iowa, HR-305, 1991

An expert system has been developed that provides 24 hour forecasts of roadway and bridge frost for locations in Iowa. The system is based on analysis of frost observations taken by highway maintenance personnel, analysis of conditions leading to frost as obtained from meteorologists with experience in forecasting bridge and roadway frost, and from fundamental physical principles of frost processes. The expert system requires the forecaster to enter information on recent maximum and minimum temperatures and forecasts of maximum and minimum air temperatures, dew point temperatures, precipitation, cloudiness, and wind speed. The system has been used operationally for the last two frost seasons by Freese-Notis Associates, who have been under contract with the Iowa DOT to supply frost forecasts. The operational meteorologists give the system their strong endorsement. They always consult the system before making a frost forecast unless conditions clearly indicate frost is not likely. In operational use, the system is run several times with different input values to test the sensitivity of frost formation on a particular day to various meteorological parameters. The users comment. that the system helps them to consider all the factors relevant to frost formation and is regarded as an office companion for making frost forecasts.

The Economics of Reducing the County Road System: Three Case Studies in Iowa, HR-242, 1986

This research project looked at the economic benefits and costs associated with alternative strategies for abandoning low volume rural highways and bridges. Three test counties in Iowa were studied, each 100 square miles in size: Hamilton County having a high agricultural tax base and a high percentage of paved roads and few bridges; Shelby County having a relatively low agricultural tax base, hilly terrain and a low percentage of paved road and many bridges; and Linn County having a high agricultural tax base, a high percentage of paved roads and a large number of non-farm households. A questionnaire survey was undertaken to develop estimates of farm and household travel patterns. Benefits and costs associated with the abandonment of various segments of rural highway and bridge mileages in each county were calculated. "Benefits" calculated were reduced future reconstruction and maintenance costs, whereas "costs" were the added cost of travel resulting from the reduced mileage. Some of the findings suggest limited cost savings from abandonment of county roads with no property access in areas with large non-farm rural population; relatively high cost savings from the abandonment of roads with no property access in areas with small rural population; and the largest savings from the conversion of public dead-end gravel roads with property or residence accesses to private drives.

Solar Powered Highway Delineator System, HR-367, 1993

Currently, many drivers experience some difficulty in viewing the road ahead of them during times of reduced visibility, such as rain, snow, fog, or the darkness of night- Recent studies done by the National Safety Council provide a detailed contrast between fatal accidents occurring during the day and night. Revealed was that the motor vehicle night death rate (4.41 deaths per 100 million miles driven) was sharply higher than the corresponding death rate during daylight hours (1.21). By providing a delineating system powered by the natural resource of solar power, a constant source of visibility may be maintained throughout the evening. Along with providing enough light to trace the outline of the road, other major goals defined in producing this delineator system are as follows: 1. A strong and durable design that would protect the internal components and survive extreme weather conditions. 2. A low maintenance system where components need few repairs or replacements. 3. A design which makes all components accessible in the event that maintenance is needed, but also prevents vandalism. 4. A design that provides greater visibility to drivers and will not harm a vehicle or its passengers in the event of a collision. This solar powered highway delineator consists of an adjustable solar array, a light fixture, and a standard delineator pole. The solar array houses and protects the solar panels, and can be easily adjusted to obtain a maximum amount of sunlight. The light fixture primarily houses the battery, the circuit and the light assembly. Both components allow for easy accessibility and reduce vandalism using internal connections for bolts and wires. The delineator mounting pole is designed to extensively deform in the event of a collision, therefore reducing any harm caused to the vehicle and/or the passengers. The cost of a single prototype to be produced is approximately $70.00 excluding labor costs. However, these material and labor costs will be greatly reduced if a large number of delineators are produced. It is recommended that the Iowa Department of Transportation take full advantage of the research and development put into this delineator design. The principles used in creating this delineator can be used to provide an outline for drivers to follow, or on a larger scale, provide actual roadway lighting in areas where it was never before possible or economically feasible. In either event, the number of fatal accidents will be decreased due to the improved driver visibility in the evening.

Engineering Study for the Evaluation of Public Road Administration and Maintenance Alternatives, HR-265, 1985

Iowa's public road system of 112,000 miles is one of the largest and the best in the nation. It represents a considerable financial investment of taxpayer revenues over the years. And, it requires a sustained investment to preserve an economical level of transport service into the future. In 1982, a Governor's Blue Ribbon Transportation Task Force evaluated the effectiveness of Iowa's entire transportation system. Four important Task Force recommendations dealt with public road administrative issues in Iowa. These issues were related to: (1) Design criteria and levels of maintenance; (2) Consistency in the use of standards among jurisdictions; (3) Consolidation of maintenance operations at one jurisdiction level; and (4) Jurisdicational authority for roads; The issues formed the background for Research Project HR-265.

Construction and Maintenance Practices to Minimize the Potential Liability of Counties for Roads in Rural Subdivisions, HR-221, 1981

In an earlier research project, HR-204, the magnitude and nature of highway related tort claims against counties in Iowa were investigated. However, virtually all of the claims identified in that research resulted from incidents that occurred in areas with predominantly agricultural land use. With recent increases in the rural non-farm population, many traditionally urban problems are also appearing in built-up areas under county jurisdiction. This trend is expected to continue so that counties must anticipate a change in the nature of the tort claims they will encounter. Problems that heretofore have been unique to cities may become commonplace in areas for which counties are responsible. The research reported here has been directed toward an investigation of those problems in rural subdivisions that lead to claims growing out of the provision of highway services by counties. Lacking a sufficient database among counties for the types of tort claims of interest in this research, a survey was sent to 259 cities in Iowa in order to identify highway related problems leading to those claims. The survey covered claims during a five year period from 1975 to 1980. Over one-third of the claims reported were based on alleged street defects. Another 34 percent of the claims contained allegations of damages due to backup of sanitary sewers or defects in sidewalks. By expanding the sample from the 164 cities that responded to the survey, it was estimated that a total of $49,000,000 in claims had been submitted to all 259 cities. Over 34% of this amount resulted from alleged defects in the use of traffic signs, signals, and markings. Another 42% arose from claims of defects in streets and sidewalks. Payments in settlement of claims were about 13.4% of the amount asked for those claims closed during the period covered by the survey. About $9,000,000 in claims was pending on June 30, 1980 according to the information furnished. Officials from 23 cities were interviewed to provide information on measures to overcome the problems leading to tort claims. On the basis of this information, actions have been proposed that can be undertaken by counties to reduce the potential for highway-related claims resulting from their responsibilities in rural subdivisions and unincorporated communities. Suggested actions include the eight recommendations contained in the final report for the previous research under HR-204. In addition, six recommendations resulted from this research, as follows: 1. Counties should adopt county subdivision ordinances. 2. A reasonable policy concerning sidewalks should be adopted. 3. Counties should establish and implement a system for setting road maintenance priorities. 4. Counties should establish and implement a procedure for controlling construction or maintenance activities within the highway right of way. 5. Counties should establish and implement a system to record complaints that are received relating to highway maintenance and to assure timely correction of defective conditions leading to such complaints. 6. Counties should establish and implement a procedure to ensure timely advice of highway defects for which notice is not otherwise received.