10 resultados para Database As A Tool For Hospitality Management
em Iowa Publications Online (IPO) - State Library, State of Iowa (Iowa), United States
Resumo:
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.
Resumo:
Most local agencies in Iowa currently make their pavement treatment decisions based on their limited experience due primarily to lack of a systematic decision-making framework and a decision-aid tool. The lack of objective condition assessment data of agency pavements also contributes to this problem. This study developed a systematic pavement treatment selection framework for local agencies to assist them in selecting the most appropriate treatment and to help justify their maintenance and rehabilitation decisions. The framework is based on an extensive literature review of the various pavement treatment techniques in terms of their technical applicability and limitations, meaningful practices of neighboring states, and the results of a survey of local agencies. The treatment selection framework involves three different steps: pavement condition assessment, selection of technically feasible treatments using decision trees, and selection of the most appropriate treatment considering the return-on-investment (ROI) and other non-economic factors. An Excel-based spreadsheet tool that automates the treatment selection framework was also developed, along with a standalone user guide for the tool. The Pavement Treatment Selection Tool (PTST) for Local Agencies allows users to enter the severity and extent levels of existing distresses and then, recommends a set of technically feasible treatments. The tool also evaluates the ROI of each feasible treatment and, if necessary, it can also evaluate the non-economic value of each treatment option to help determine the most appropriate treatment for the pavement. It is expected that the framework and tool will help local agencies improve their pavement asset management practices significantly and make better economic and defensible decisions on pavement treatment selection.
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:
This User’s Guide serves as a reference for field personnel using the sign inventory data collection software tool. This tool was developed to simplify and standardize the collection and updating of sign inventory information. The software and collection methodology was developed by the Iowa DOT Sign Management Task Force and the Center for Transportation Research and Education at Iowa State University. Required Equipment -The data collection process requires both a portable computer and a global positioning system (GPS) device (connected via USB cable). Since computer battery performance varies, a DC power converter is recommended. A check-in/out process has also been established which allows updates to sign information from the central database.
Resumo:
Drilled shafts have been used in the US for more than 100 years in bridges and buildings as a deep foundation alternative. For many of these applications, the drilled shafts were designed using the Working Stress Design (WSD) approach. Even though WSD has been used successfully in the past, a move toward Load Resistance Factor Design (LRFD) for foundation applications began when the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000.The policy memorandum requires all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. This ensures compatibility between the superstructure and substructure designs, and provides a means of consistently incorporating sources of uncertainty into each load and resistance component. Regionally-calibrated LRFD resistance factors are permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy and competitiveness of drilled shafts. To achieve this goal, a database for Drilled SHAft Foundation Testing (DSHAFT) has been developed. DSHAFT is aimed at assimilating high quality drilled shaft test data from Iowa and the surrounding regions, and identifying the need for further tests in suitable soil profiles. This report introduces DSHAFT and demonstrates its features and capabilities, such as an easy-to-use storage and sharing tool for providing access to key information (e.g., soil classification details and cross-hole sonic logging reports). DSHAFT embodies a model for effective, regional LRFD calibration procedures consistent with PIle LOad Test (PILOT) database, which contains driven pile load tests accumulated from the state of Iowa. PILOT is now available for broader use at the project website: http://srg.cce.iastate.edu/lrfd/. DSHAFT, available in electronic form at http://srg.cce.iastate.edu/dshaft/, is currently comprised of 32 separate load tests provided by Illinois, Iowa, Minnesota, Missouri and Nebraska state departments of transportation and/or department of roads. In addition to serving as a manual for DSHAFT and providing a summary of the available data, this report provides a preliminary analysis of the load test data from Iowa, and will open up opportunities for others to share their data through this quality–assured process, thereby providing a platform to improve LRFD approach to drilled shafts, especially in the Midwest region.
Resumo:
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.
Resumo:
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.
Resumo:
Sufficient evidence was not discovered in this brief search to alter the general opinion that the Serviceability (Present Serviceability Index-PSI) - Performance Concepts developed by the AASHO Road Test provides the optimum engineering basis for pavement management. Use of these concepts in Iowa has the additional advantage in that we have a reasonable quantity of historical data over a period of time on the change in pavement condition as measured by PSI's. Some additional benefits would be the ability to better assess our needs with respect to those being recommended to Congress by AASHTO Committees. These concepts have been the basis used for developing policies on dimensions and weight of vehicles and highway needs which the AASHTO Transport Committees have recommended to the United States House Committee on Ways and Means. The first recommendation based on these concepts was made in the mid 1960's. Iowa's participation in the evaluation for this recommendation was under the direction of our present Director of Transportation, Mr. Raymond Kassel. PSI Indexes had to be derived from subjective surface ratings at that time. The most recent recommendation to Congress was made in November of 1977. Based on the rationale expressed above, a pilot study of the major part of the rural interstate system was conducted. The Objective of the study was to measure pavement performance through the use of the Present Serviceability Index (PSI) - Pavement Performance concepts as developed by the AASHO Road Test and to explore the usefulness of this type of data as a pavement management tool. Projects in the vicinity of the major urban centers were not included in this study due to the extra time that would be required to isolate accurate traffic data in these areas. Projects consisting of asphalt surface courses on crushed stone base sections were not included.
Resumo:
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.
Resumo:
This project resulted in the development of a framework for making asset management decisions on low-volume bridges. The research focused on low-volume bridges located in the agricultural counties of Iowa because recent research has shown that these counties have the greatest percentage of structurally deficient bridges in the nation. Many of the same counties also have the highest crop yields in the state, creating a situation where detours caused by deficient bridges on farm-to-market roads increase the cost to transport the crops. Thus, the research proposed the use of social return on investment (SROI), a tool used by international institutions such as the World Bank, as an asset management metric to gauge to the socioeconomic impact of structurally deficient bridges on the state in an effort to provide quantified justification to fund improvements on low-volume assets such as these rural bridges. The study found that combining SROI with current asset management metrics like average daily traffic (ADT) made it possible to prioritize the bridges in such a way that the limited resources available are allocated in a manner that promotes a more equitable distribution and that directly benefits the user, in this case Iowa farmers. The result is a system that more closely aligns itself with the spirit of MAP-21, in that infrastructure investments are used to facilitate economic growth for Iowa’s agricultural economy.