BERRYMAN AND HENIGAR 3 - 2004 - Laserfiche WebLink

Home Browse Search

TASK 1: GENERAL SUPPORT General support services will involve the following: set -up of electronic PDA forms using Visual CE and one year of unlimited pavement data upload and database population (a $2,000 value). Data upload involves advanced database knowledge of both Microsoft Access and MicroPAVER database table structure and relationships. We have perfected this system through years of trial and error. Based on our own project estimates, data entry takes about 40% as much time and labor to complete as does the field inspection when using paper forms. So, for example, if it takes 1000 man -hours to do field inspections with paper forms, it will take roughly 400 man -hours to do the data entry. The way this support service works is simple. Our staff will set up the custom form and database for the City for a given project. City staff will collect data in the field and upload that data on a regular basis (backup on a daily basis is highly recommended). At regular intervals (the frequency of which will be discussed at Project Kick -off) the database(s) at the City are zipped and emailed to Berryman & Henigar. Our staff then combines this data and populates it into the database of choice, which would be MicroPAVER in this case. This task will be provided on a time - and - materials basis with a budget cap of $8,000. TASK 2: GIS SEGMENTATION- MAPPING With the complete survey and verification of all GIS street intersection node points, our staff will create the one- to-one match with the pavement dataset and the City's GIS centerline shapefile. This will enable City staff to perform multiple queries related to pavement data and existing City data such as neighborhood zones, for example. Geographic Information Systems (GIS) Implementation Berryman & Henigar will provide GIS linkages, operational and support services for this project where we will work closely with GIS group to establish the necessary PMS -GIS functionality for the City of Santa Ana. Most pavement management systems have the capability of interfacing GIS datasets through the use of ArcView, AutoCAD or other GIS compatible software. Specifically, our staff has developed several pavement data links to GIS using MicroPAVER data (i.e., City of Carlsbad, Temecula, and Moreno Valley in the past year). Berryman & Henigar will develop pavement "layers" that represent the City's MicroPAVER dataset. These typically include a PCI, work history, CIP report recommendations, and scheduled project layers. For example, the City will be able to filter for specific records (e.g., sections with PCI's < 40, or sections to be slurry sealed in 2002 - 2003). Those individual records will be highlighted on the map or record table (or filtered for). By querying within the GIS, those selected pavement records will be filtered on the map and can then be exported for further analyses and/or inclusion into a report. TASK 3: SOFTWARE PURCHASE Arcview software will allow City staff to open and edit map data and analyze and produce maps related to data that is contained in the GIS. ArcIMS will enable the City to display GIS data over the internet for viewing by anyone who has an internet connection. Both of these programs will provide great benefit and value to the City in the time savings associated with data manipulation, analyzing, and presentation.