40 resultados para Spatial Database Management System (SDBMS)
Resumo:
The objective of this research was to develop a methodology for transforming and dynamically segmenting data. Dynamic segmentation enables transportation system attributes and associated data to be stored in separate tables and merged when a specific query requires a particular set of data to be considered. A major benefit of dynamic segmentation is that individual tables can be more easily updated when attributes, performance characteristics, or usage patterns change over time. Applications of a progressive geographic database referencing system in transportation planning are vast. Summaries of system condition and performance can be made, and analyses of specific portions of a road system are facilitated.
Resumo:
Advances in communication, navigation and imaging technologies are expected to fundamentally change methods currently used to collect data. Electronic data interchange strategies will also minimize data handling and automatically update files at the point of capture. This report summarizes the outcome of using a multi-camera platform as a method to collect roadway inventory data. It defines basic system requirements as expressed by users, who applied these techniques and examines how the application of the technology met those needs. A sign inventory case study was used to determine the advantages of creating and maintaining the database and provides the capability to monitor performance criteria for a Safety Management System. The project identified at least 75 percent of the data elements needed for a sign inventory can be gathered by viewing a high resolution image.
Resumo:
Federal and state policy makers increasingly emphasize the need to reduce highway crash rates. This emphasis is demonstrated in Iowa’s recently released draft Iowa Strategic Highway Safety Plan and by the U.S. Department of Transportation’s placement of “improved transportation safety” at the top of its list of strategic goals. Thus, finding improved methods to enhance highway safety has become a top priority at highway agencies. The objective of this project is to develop tools and procedures by which Iowa engineers can identify potentially hazardous roadway locations and designs, and to demonstrate the utility of these tools by developing candidate lists of high crash locations in the State. An initial task, building an integrated database to facilitate the tools and procedures, is an important product, in and of itself. Accordingly, the Iowa Department of Transportation (Iowa DOT) Geographic Information Management System (GIMS) and Geographic Information System Accident Analysis and Location System (GIS-ALAS) databases were integrated with available digital imagery. (The GIMS database contains roadway characteristics, e.g., lane width, surface and shoulder type, and traffic volume, for all public roadways. GIS-ALAS records include data, e.g., vehicles, drivers, roadway conditions, and the crash severity, for crashes occurring on public roadways during then past 10 years.)
Resumo:
Tillage systems play a significant role in agricultural production throughout Iowa and the Midwest. It has been well documented that increased tillage intensities can reduce soil organic matter in the topsoil due to increased microbial activity and carbon (C ) oxidation. The potential loss of soil organic matter due to tillage operations is much higher for high organic matter soils than low organic matter soils. Tillage effects on soil organic matter can be magnified through soil erosion and loss of soil productivity. Soil organic matter is a natural reservoir for nutrients, buffers against soil erosion, and improves the soil environment to sustain soil productivity. Maintaining soil productivity requires an agriculture management system that maintains or improves soil organic matter content. Combining cropping systems and conservation tillage practices, such as no-tillage, strip-tillage, or ridge-tillage, are proven to be very effective in improving soil organic matter and soil quality.
Resumo:
This phase of the electronic collaboration project involved two major efforts: 1) implementation of AEC Sync (formerly known as Attolist), a web-based project management system (WPMS), on the Broadway Viaduct Bridge Project and the Iowa Falls Arch Bridge Project and 2) development of a web-based project management system for bridge and highway construction projects with less than $10 million in contract value. During the previous phase of this project (fiscal year 2010), the research team helped with the implementation process for AEC Sync and collected feedback from the Broadway Viaduct project team members before the start of the project. During the 2011 fiscal year, the research team collected the post-project surveys from the Broadway Viaduct project members and compared them to the pre-project survey results. The results of the AEC Sync implementation on the Broadway project were positive. The project members were satisfied with the performance of the AEC Sync software and how it facilitated document management and its transparency. In addition, the research team distributed, collected, and analyzed the pre-project surveys for the Iowa Falls Arch Bridge Project. The implementation of AEC Sync for the Iowa Falls Arch Bridge Project appears to also be positive, based on the pre-project surveys. The fourth phase of this electronic collaboration project involves the identification and implementation of a WPMS solution for smaller bridge and highway projects. The workflow for the shop drawing approval process for sign truss projects was documented and used to identify possible WPMS solutions. After testing and evaluating several WPMS solutions, Microsoft SharePoint Foundation’s site pages were selected to be pilot-tested on sign truss projects. Due to the limitation on the SharePoint license that the Iowa Department of Transportation (DOT) has, a file transfer protocol (FTP) site will be developed alongside this site to allow contractors to upload shop drawings to the Iowa DOT. The SharePoint site pages are expected to be ready for implementation during the 2012 calendar year.
Resumo:
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.
Resumo:
The varying title of this manual is : Coordinated Transportation Analysis and Management System. It gives instructions on how to use GeoMedia in order to integrate data from multiple sources and formats into one environment, perform sophisticated queries and spatial analyses, and quickly produce complex maps.
Resumo:
This phase of the research project involved two major efforts: (1) Complete the implementation of AEC-Sync (formerly known as Attolist) on the Iowa Falls Arch Bridge project and (2) develop a web-based project management system (WPMS) for projects under $10 million. For the first major effort, AEC-Sync was provided for the Iowa Department of Transportation (DOT) in a software as a service agreement, allowing the Iowa DOT to rapidly implement the solution with modest effort. During the 2010 fiscal year, the research team was able to help with the implementation process for the solution. The research team also collected feedback from the Broadway Viaduct project team members before the start of the project and implementation of the solution. For the 2011 fiscal year, the research team collected the post-project surveys from the Broadway Viaduct project members and compared them to the pre-project survey results. The result of the AEC-Sync implementation in the Broadway Viaduct project was a positive one. The project members were satisfied with the performance of AEC-Sync and how it facilitated document management and transparency. In addition, the research team distributed, collected, and analyzed the pre-project surveys for the Iowa Falls Arch Bridge project. During the 2012 fiscal year, the research team analyzed the post-project surveys for the Iowa Falls Arch Bridge project AEC-Sync implementation and found a positive outcome when compared to the pre-project surveys. The second major effort for this project involved the identification and implementation of a WPMS solution for smaller bridge and highway projects. During the 2011 fiscal year, Microsoft SharePoint was selected to be implemented on these smaller highway projects. In this year, workflows for the shop/working drawings for the smaller highway projects specified in Section 1105 of the Iowa DOT Specifications were developed. These workflows will serve as the guide for the development of the SharePoint pages. In order to implement the Microsoft SharePoint pages, the effort of an integrated team proved to be vital because it brought together the expertise required from researchers, programmers, and webpage developers to develop the SharePoint pages.
Resumo:
The work described in this report documents the activities performed for the evaluation, development, and enhancement of the Iowa Department of Transportation (DOT) pavement condition information as part of their pavement management system operation. The study covers all of the Iowa DOT’s interstate and primary National Highway System (NHS) and non-NHS system. A new pavement condition rating system that provides a consistent, unified approach in rating pavements in Iowa is being proposed. The proposed 100-scale system is based on five individual indices derived from specific distress data and pavement properties, and an overall pavement condition index, PCI-2, that combines individual indices using weighting factors. The different indices cover cracking, ride, rutting, faulting, and friction. The Cracking Index is formed by combining cracking data (transverse, longitudinal, wheel-path, and alligator cracking indices). Ride, rutting, and faulting indices utilize the International Roughness Index (IRI), rut depth, and fault height, respectively.
Resumo:
The Iowa Department of Transportation's Access Management Task Force was established as part of the Iowa Department of Transportation's overall Safety Management System (SMS) effort. The goal of the Access Management Task Force is to develop a program designed to educate and market the concept and benefits of access management to landowners and developers, professional planners and engineers, planning and zoning staff members, appointed and elected officials, and motorists. Access management is pursued through the design and control of driveways, curb cuts, turning movements, interior circulation of parking lots, and public street connections and intersections. Usually, state highways or major urban and suburban arterial streets are the targets of access management projects. Access management is also a concern on main county roads when there is a transition from a rural environment to a town or city.
Resumo:
The benefits of pavement management system when fully implemented are well known and the history of successful implementation is rich. Implementation occurs, for purposes of this paper, when the pavement management system is the critical component for making pavement decisions. This paper addresses the issues that act as barriers to full implementation of pavement management systems. Institutional barriers, not technical and financial barriers, are more commonly responsible for a pavement management systems falling short of full implementation. The paper groups these institutional issues into a general taxonomy. In general, more effort needs to be put forth by highway agencies to overcome institutional issues. Most agencies approach pavement management as a technical process, but more commonly, institutional issues become more problematic and thus require more attention paid to institutional issues. The paper concludes by summarizing the implementation process being taken by the Iowa Department of Transportation. The process was designed to overcome institutional barriers and facilitate the complete and full implementation of their pavement management system.
Resumo:
This document briefly summarizes the pavement management activities under the existing Iowa Department of Transportation (DOT) Pavement Management System. The second part of the document provides projected increase in use due to the implementation of the Iowa DOT Pavement Management Optimization System. All estimates of existing time devoted to the Pavement Management System and project increases in time requirements are estimates made by the appropriate Iowa DOT office director or function manager. Included is the new Pavement Management Optimization Structure for the three main offices which will work most closely with the Pavement Management Optimization System (Materials, Design, and Program Management).
Resumo:
The purpose of the proposed Highway Location Reference Procedure is stated in the contract as follows: "Establishment of a highway network locational reference process that will primarily allow for the proper correlation of pavement management data, and secondarily provide the basis for other existing and future data base integration and for the planned Iowa DOT Geographic Information System. In addition, the locational reference process will be able to correlate network applications with a statewide spatial location method to facilitate the relationship of Iowa DOT data to that of other agencies and to allow for the graphic display of the network in map form." The Design Specifications and Implementation Plan, included in this Final Report, are intended to provide the basis for proceeding with immediate development and implementation of the pavement management system. These specifications will also support the future Iowa DOT implementation of other integrated data bases and/or the planned Geographic Information System.
Resumo:
Tillage and manure application practices significantly impact surface and ground water quality in Iowa and other Midwestern states. Tillage and manure application that incorporates residue and disturbs soil result in higher levels of soil erosion and surface runoff. Phosphorus and sediment loading are closely linked to the increase in soil erosion and surface water runoff. Manure application (i.e., injection or incorporation) reduces surface residue cover, which can worsen soil erosion regardless of the tillage management system being used. An integrated system approach to manure and tillage management is critical to ensure effi cient nutrient use and improvement of soil and water quality. This approach, however, requires changes in manure application technology and tillage system management to ensure the success of an integrated
Resumo:
Producers continually strive for high yielding soybeans. The state-wide average yield for Iowa is now more than 50 bu./acre. The “yield plateau” reported by many producers does not exist, and is a perception largely brought on by misuse of an oversimplified management system. High yielding soybeans are achieved through improved and targeted management decisions. Improved agronomic decisions for soybeans are critical since soybean is very sensitive to stresses that influence soybean growth, development and yield.