IowAccess Project 8 : statewide geographic information systems (GIS) support, 1998

This is the final report of the of IowAccess Project 8, which designed and implemented a geospatial data infrastructure for Iowa, including a formalized coordination body, a coordination staff, and enhanced data clearing house, and a statewide GIS training and education effort.

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.

Technology Transfer of As-Built and Preliminary Surveys Using GPS, Soft Photogrammetry, and Video Logging, 2002

This research involved two studies: one to determine the local geoid to obtain mean sea level elevation from a global positioning system (GPS) to an accuracy of ±2 cm, and the other to determine the location of roadside features such as mile posts and stop signs for safety studies, geographic information systems (GIS), and maintenance applications, from video imageries collected by a van traveling at traffic speed.

Field Data Acquisition Technologies for Iowa Transportation Agencies, HR-366 August 1994

This report describes the results of the research project investigating the use of advanced field data acquisition technologies for lowa transponation agencies. The objectives of the research project were to (1) research and evaluate current data acquisition technologies for field data collection, manipulation, and reporting; (2) identify the current field data collection approach and the interest level in applying current technologies within Iowa transportation agencies; and (3) summarize findings, prioritize technology needs, and provide recommendations regarding suitable applications for future development. A steering committee consisting oretate, city, and county transportation officials provided guidance during this project. Technologies considered in this study included (1) data storage (bar coding, radio frequency identification, touch buttons, magnetic stripes, and video logging); (2) data recognition (voice recognition and optical character recognition); (3) field referencing systems (global positioning systems [GPS] and geographic information systems [GIs]); (4) data transmission (radio frequency data communications and electronic data interchange); and (5) portable computers (pen-based computers). The literature review revealed that many of these technologies could have useful applications in the transponation industry. A survey was developed to explain current data collection methods and identify the interest in using advanced field data collection technologies. Surveys were sent out to county and city engineers and state representatives responsible for certain programs (e.g., maintenance management and construction management). Results showed that almost all field data are collected using manual approaches and are hand-carried to the office where they are either entered into a computer or manually stored. A lack of standardization was apparent for the type of software applications used by each agency--even the types of forms used to manually collect data differed by agency. Furthermore, interest in using advanced field data collection technologies depended upon the technology, program (e.g.. pavement or sign management), and agency type (e.g., state, city, or county). The state and larger cities and counties seemed to be interested in using several of the technologies, whereas smaller agencies appeared to have very little interest in using advanced techniques to capture data. A more thorough analysis of the survey results is provided in the report. Recommendations are made to enhance the use of advanced field data acquisition technologies in Iowa transportation agencies: (1) Appoint a statewide task group to coordinate the effort to automate field data collection and reporting within the Iowa transportation agencies. Subgroups representing the cities, counties, and state should be formed with oversight provided by the statewide task group. (2) Educate employees so that they become familiar with the various field data acquisition technologies.

Artificial-Intelligence-Based Optimization of the Management of Snow Removal Assets and Resources Final Report, October 2002

Geographic information systems (GIS) and artificial intelligence (AI) techniques were used to develop an intelligent snow removal asset management system (SRAMS). The system has been evaluated through a case study examining snow removal from the roads in Black Hawk County, Iowa, for which the Iowa Department of Transportation (Iowa DOT) is responsible. The SRAMS is comprised of an expert system that contains the logical rules and expertise of the Iowa DOT’s snow removal experts in Black Hawk County, and a geographic information system to access and manage road data. The system is implemented on a mid-range PC by integrating MapObjects 2.1 (a GIS package), Visual Rule Studio 2.2 (an AI shell), and Visual Basic 6.0 (a programming tool). The system could efficiently be used to generate prioritized snowplowing routes in visual format, to optimize the allocation of assets for plowing, and to track materials (e.g., salt and sand). A test of the system reveals an improvement in snowplowing time by 1.9 percent for moderate snowfall and 9.7 percent for snowstorm conditions over the current manual system.

GPS to LRM: Integration of Spatial Point Features with Linear Referencing Methods, 2001

Global positioning systems (GPS) offer a cost-effective and efficient method to input and update transportation data. The spatial location of objects provided by GPS is easily integrated into geographic information systems (GIS). The storage, manipulation, and analysis of spatial data are also relatively simple in a GIS. However, many data storage and reporting methods at transportation agencies rely on linear referencing methods (LRMs); consequently, GPS data must be able to link with linear referencing. Unfortunately, the two systems are fundamentally incompatible in the way data are collected, integrated, and manipulated. In order for the spatial data collected using GPS to be integrated into a linear referencing system or shared among LRMs, a number of issues need to be addressed. This report documents and evaluates several of those issues and offers recommendations. In order to evaluate the issues associated with integrating GPS data with a LRM, a pilot study was created. To perform the pilot study, point features, a linear datum, and a spatial representation of a LRM were created for six test roadway segments that were located within the boundaries of the pilot study conducted by the Iowa Department of Transportation linear referencing system project team. Various issues in integrating point features with a LRM or between LRMs are discussed and recommendations provided. The accuracy of the GPS is discussed, including issues such as point features mapping to the wrong segment. Another topic is the loss of spatial information that occurs when a three-dimensional or two-dimensional spatial point feature is converted to a one-dimensional representation on a LRM. Recommendations such as storing point features as spatial objects if necessary or preserving information such as coordinates and elevation are suggested. The lack of spatial accuracy characteristic of most cartography, on which LRM are often based, is another topic discussed. The associated issues include linear and horizontal offset error. The final topic discussed is some of the issues in transferring point feature data between LRMs.

Improved Employment Data for Transportation Planning, 1998

Transportation planners typically use census data or small sample surveys to help estimate work trips in metropolitan areas. Census data are cheap to use but are only collected every 10 years and may not provide the answers that a planner is seeking. On the other hand, small sample survey data are fresh but can be very expensive to collect. This project involved using database and geographic information systems (GIS) technology to relate several administrative data sources that are not usually employed by transportation planners. These data sources included data collected by state agencies for unemployment insurance purposes and for drivers licensing. Together, these data sources could allow better estimates of the following information for a metropolitan area or planning region: · Locations of employers (work sites); · Locations of employees; · Travel flows between employees’ homes and their work locations. The required new employment database was created for a large, multi-county region in central Iowa. When evaluated against the estimates of a metropolitan planning organization, the new database did allow for a one to four percent improvement in estimates over the traditional approach. While this does not sound highly significant, the approach using improved employment data to synthesize home-based work (HBW) trip tables was particularly beneficial in improving estimated traffic on high-capacity routes. These are precisely the routes that transportation planners are most interested in modeling accurately. Therefore, the concept of using improved employment data for transportation planning was considered valuable and worthy of follow-up research.

Black Hawk County Criminal Justice Information Systems, Independent Auditor's Reports, Financial Statement and Required Supplementary Information, Schedule of Findings, June 30, 2004

Other Audit Reports - 28E Organizations

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.

Soft Photogrammetry for Highway Engineering, HR-387, 1998

The SoftPlotter, a soft photogrammetric software and Silicon Graphics workstation, was used to evaluate the accuracy of soft photogrammetry and identify applications of this technology to highway engineering. A comparative study showed that SoftPlotter compares well with other software such as Socket and Integraph. The PC software TNTMips is inexpensive but needs further development to be comparable to SoftPlotter. The Campus Project showed that soft photogrammetry is accurate for traditional photogrammetric applications. It is also accurate for producing orthophoto and base maps for Geographic Information Systems (GISs). The Highway Project showed that soft photogrammetry is accurate for highway engineering and that the technical staff at the Iowa Department of Transportation (IA DOT) can be easily trained in this new technology. The research demonstrated that soft photogrammetry can be used with low-flight helicopter photography for large-scale mapping in highway engineering. The researchers recommend that research be conducted to test the use of digital cameras instead of the traditional aerial cameras in helicopter photography. Research that examines the use of soft photogrammetry with video logging imagery for inventory and GIS studies in highway maintenance is also recommended. Research is also warranted into the integration of soft photogrammetry with virtual reality, which can be used in three-dimensional designing and visualization of highways and subdivisions in real time. The IA DOT owns one analytical plotter and two analogue plotters. The analytical plotter is used for aerial triangulation, and the analogue plotters are used for plotting. However, neither is capable of producing orthophotos. Therefore, the researchers recommend that the IA DOT purchase soft photogrammetric workstations for orthophoto production, and if and when required, use it for aerial triangulation and plotting. In the future, the analogue plotters may become obsolete. At that time, the researchers recommend that the analogue plotters be phased out and replaced by soft photogrammetric workstations.

Report on a special investigation of the University of Iowa Hospitals and Clinics, Health Care Information Systems Department, for the period January 1, 2005 through July 5, 2013

Report on a special investigation of the University of Iowa Hospitals and Clinics, Health Care Information Systems Department, for the period January 1, 2005 through July 5, 2013

Maximizing the Use of Roadway Weather Information Systems: Final Report, TR-404, 1998

This project was proposed as Phase I of a 2-phase program to evaluate the present use of weather information by Iowa Department of Transportation (IaDOT) personnel, recommend revised procedures, and then implement the resulting recommendations. Midway through Phase I (evaluation phase) the FORETELL project was funded. This project is a multi-state venture that engages the National Weather Service (NWS) and the Forecast Systems Laboratory of the National Oceanic and Atmospheric Administration and proposes to supplant the current weather information-generation and distribution system with an advanced system based on state-of-the-art technologies. The focus of the present project was therefore refined to consider use of weather data by IaDOT personnel, and the training programs needed to more effectively use these data. Results of the survey revealed that two major areas - training of personnel on use of data from whatever source and more precise information of frost formation - are not addressed in the FORETELL project. These aspects have been the focus of the present project.

Report on a special investigation of the Cerro Gordo County Management Information Systems (MIS) Department for the period January 1, 2008 through July 31, 2013

Report on a special investigation of the Cerro Gordo County Management Information Systems (MIS) Department for the period January 1, 2008 through July 31, 2013

Our Common Ground, 2005-4

Iowa Department of Natural Resources fact sheet on Geographic Information Systems.

Watching Corn Grow: A Hedonic Study of the Iowa Landscape, april 2007

Landscape amenities can be scarce in places with large areas of open space. Intensely farmed areas with high levels of monocropping and livestock production are akin to developed open space areas and do not provide many services in terms of landscape amenities. Open space in the form of farmland is plentiful, but parks and their services are in short supply. This issue is of particular importance for public policy because it is closely linked to the impact of externalities caused by agricultural activities and to the indirect effects of land use dynamics. This study looks at the impact of landscape amenities on rural residential property values in five counties in North Central Iowa using a hedonic pricing model based on geographic information systems. The effect of cropland, pasture, forest, and developed land as land uses surrounding the property is considered, as well as the impact of proximity to recreational areas. The study also includes the effect of other disamenities, such as livestock facilities and quarries, which can be considered part of the developed open space and are a common feature of the Iowa landscape.