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.

Transportation Program Management System, HR-394, 2003

HR-394 was a software and database development project. Via funding provided by the Iowa Highway Research Board, the Iowa County Engineer's Association Service Bureau oversaw the planning and implementation of an Internet based application that supports two major local-government transportation project activities: Project programming and Development tracking. The goals were to reduce errors and inconsistencies, speed up the processes, link people to both project data and each other, and build a framework that could eventually support a 'paperless' work flow. The work started in 1999 and initial development was completed by the fall of 2002. Since going live, several 'piggy back' applications have been required to make the Programming side better fit actual work procedures. This part of the system has proven adequate but will be rewritten in 2004 to make it easier to use. The original development side module was rejected by the users and so had to be rewritten in 2003. The second version has proven much better, is heavily used, and is interconnected with Iowa DOT project data systems. Now that the system is in operation, it will be maintained and operated by the ICEA Service Bureau as an ongoing service function.

Report on a review of selected general and application controls over the Iowa Department of Transportation’s Resource Management System for the period May 5, 2006 through August 4, 2006.

Report on a review of selected general and application controls over the Iowa Department of Transportation’s Resource Management System for the period May 5, 2006 through August 4, 2006.

Issue review : electronic document management system or EDMS.

This issue review provides an overview of the electronic documents management system, or EDMS project.

Issue review : electronic document management system, or EDMS.

This issue review provides an overview of the electronic document management system, or EDMS, project, withing the judicial branch and courts.

Report and Specification for Transportation Program Management System, HR-394, 1997

TPMS is proposed as a distributed, PC-based system for automating two processes required for road improvements in Iowa: a) the annual preparation, submission, and approval of road improvement programs. b) the ongoing process of developing plans and obtaining approval for projects to be let for bids.

Development of LRFD Procedures for Bridge Pile Foundations in Iowa, Volume I: An Electronic Database for PIle LOad Tests (PILOT), TR-573, 2011

For well over 100 years, the Working Stress Design (WSD) approach has been the traditional basis for geotechnical design with regard to settlements or failure conditions. However, considerable effort has been put forth over the past couple of decades in relation to the adoption of the Load and Resistance Factor Design (LRFD) approach into geotechnical design. With the goal of producing engineered designs with consistent levels of reliability, the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000, requiring all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. Likewise, regionally calibrated LRFD resistance factors were permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy of bridge foundation elements. Thus, projects TR-573, TR-583 and TR-584 were undertaken by a research team at Iowa State University’s Bridge Engineering Center with the goal of developing resistance factors for pile design using available pile static load test data. To accomplish this goal, the available data were first analyzed for reliability and then placed in a newly designed relational database management system termed PIle LOad Tests (PILOT), to which this first volume of the final report for project TR-573 is dedicated. PILOT is an amalgamated, electronic source of information consisting of both static and dynamic data for pile load tests conducted in the State of Iowa. The database, which includes historical data on pile load tests dating back to 1966, is intended for use in the establishment of LRFD resistance factors for design and construction control of driven pile foundations in Iowa. Although a considerable amount of geotechnical and pile load test data is available in literature as well as in various State Department of Transportation files, PILOT is one of the first regional databases to be exclusively used in the development of LRFD resistance factors for the design and construction control of driven pile foundations. Currently providing an electronically organized assimilation of geotechnical and pile load test data for 274 piles of various types (e.g., steel H-shaped, timber, pipe, Monotube, and concrete), PILOT (http://srg.cce.iastate.edu/lrfd/) is on par with such familiar national databases used in the calibration of LRFD resistance factors for pile foundations as the FHWA’s Deep Foundation Load Test Database. By narrowing geographical boundaries while maintaining a high number of pile load tests, PILOT exemplifies a model for effective regional LRFD calibration procedures.

Report on a review of selected general and application controls over the Iowa Department of Human Services’ Targeted Case Management System (TCM) for the period March 31, 2014 through April 18, 2014

Report on a review of selected general and application controls over the Iowa Department of Human Services’ Targeted Case Management System (TCM) for the period March 31, 2014 through April 18, 2014

Planning, Developing, and Implementing the Iowa Pavement Marking Management System (IPMMS): Phases I and II, 2006

With an annual pavement marking program of approximately $2 million and another $750 thousand invested in maintenance of durable markings each year, the Iowa DOT is seeking every opportunity to provide all-year markings staying in acceptable condition under all weather conditions. The goal of this study is to analyze existing pavement marking practices and to develop a prototype Pavement Marking Management System (PMMS). This report documents the first two phases of a three-phase research project. Phase I includes an overview of the Iowa DOT’s existing practices and a literature review regarding pavement marking practices in other states. Based on this information, a work plan was developed for Phases II and III of this study. Phase II organized the key components necessary to develop a prototype PMMS for the Iowa DOT. The two primary components are (1) performance/life cycle curves for pavement marking products, and (2) an application matrix tailored to the pavement marking products and roadway and environmental conditions faced by the Iowa DOT. Both components will continue to be refined and tailored to Iowa materials and conditions as more performance data becomes available.

Document Management System: Strategic Plan, 1996

This Strategic Plan provides the Iowa Department of Transportation with guidelines for defining the acquisition and implementation of a document management system to automate current manual methods of document handling and distribution. In preparation for the production of the Strategic Plan, the USI Team conducted a series of user interviews at the DOT Ames and East Central Iowa Transportation Region facilities, and reviewed various documents relating to day-to-day operations.

Records Management System: Indexing Standard, Document Standard, Technology Standard, Laboratory Configuration, 1997

Purpose of Records Management Sysytem indexing standards document is to develop indexing standards that will best support Iowa DOT's effort to build an agency-wide Records Management System

Records Management System: Pilot Projects Functional Report, 1998

The Iowa Department of Transportation began preparation for the acquisition of an electronic document management system in 1996. The first phase was development of a strategic plan. The plan provided guidelines for defining the acquisition and implementation of a document management system to automate document handling and distribution. Phase 2 involved developing draft standards (document, indexing and technology) for planning and implementation of a document management system. These standards were to identify existing industry standards and determine which standards would best support the specific requirements of the Iowa Department of Transportation. During development of these standards, the decision was made to enlarge the scope of this effort from a document management system to a records management system (RMS). Phase .3 identified business processes that were to be further developed as pilot projects of a much larger agency-wide records management system.

Development of LRFD Procedures for Bridge Pile Foundations in Iowa Final Report, June 2010

For well over 100 years, the Working Stress Design (WSD) approach has been the traditional basis for geotechnical design with regard to settlements or failure conditions. However, considerable effort has been put forth over the past couple of decades in relation to the adoption of the Load and Resistance Factor Design (LRFD) approach into geotechnical design. With the goal of producing engineered designs with consistent levels of reliability, the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000, requiring all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. Likewise, regionally calibrated LRFD resistance factors were permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy of bridge foundation elements. Thus, projects TR-573, TR-583 and TR-584 were undertaken by a research team at Iowa State University’s Bridge Engineering Center with the goal of developing resistance factors for pile design using available pile static load test data. To accomplish this goal, the available data were first analyzed for reliability and then placed in a newly designed relational database management system termed PIle LOad Tests (PILOT), to which this first volume of the final report for project TR-573 is dedicated. PILOT is an amalgamated, electronic source of information consisting of both static and dynamic data for pile load tests conducted in the State of Iowa. The database, which includes historical data on pile load tests dating back to 1966, is intended for use in the establishment of LRFD resistance factors for design and construction control of driven pile foundations in Iowa. Although a considerable amount of geotechnical and pile load test data is available in literature as well as in various State Department of Transportation files, PILOT is one of the first regional databases to be exclusively used in the development of LRFD resistance factors for the design and construction control of driven pile foundations. Currently providing an electronically organized assimilation of geotechnical and pile load test data for 274 piles of various types (e.g., steel H-shaped, timber, pipe, Monotube, and concrete), PILOT (http://srg.cce.iastate.edu/lrfd/) is on par with such familiar national databases used in the calibration of LRFD resistance factors for pile foundations as the FHWA’s Deep Foundation Load Test Database. By narrowing geographical boundaries while maintaining a high number of pile load tests, PILOT exemplifies a model for effective regional LRFD calibration procedures.

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.

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.