Laserfiche WebLink
• • <br />11.H.1. WATER AND FORCEMAIN VALVES - DATABASE <br />MANAGEMENT SERVICES FOR INVENTORY - CAMP <br />DRESSER MCKEE - WORK AUTHORIZATION #1 <br />The Board reviewed a Memorandum of January 22, 2002: <br />DATE: <br />TO: <br />FROM: <br />PREPARED <br />A\D STAFFED <br />BY: <br />SUBJECT: <br />JANUARY 22, 2002 <br />JAMES E. CHANDLER <br />COUNTY ADMINISTRAATOR <br />W. ERIK OLSEN <br />DIRECTOR OF UTILITY SERVIC <br />KEVIN OSTHUS <br />GIS COORDINATOR <br />INDIAN RIVER COO TY UTILITIES <br />ASSIST COL'TY STAFF WITH DATABASE MANAGEMENT <br />SERVICES FOR INVENTORY OF WATER & FORCEMAF\ <br />VALVES <br />BACKGROUND & ANALYSIS <br />In 1993 the Department of Utility Services developed a GIS/IMS division and purchased <br />an IBM RISC 6000 server to house an ORACLE data -base (a UNIX base operating <br />system) to be used with a software program called HANSEN which was purchased in <br />1994. The annual system maintenance agreement for HANSEN for the fiscal year1999- <br />2000 was $10,800 (Attachment 1). This maintenance agreement with HANSEN was <br />canceled for the fiscal year 1999-2000. <br />The purpose for purchasing HANSEN and the Oracle database was to give the Utilities <br />an inventory of all the water and sewer lines and associated appurtenances within the <br />County. Also, the Utilities wanted to have a complete inventory of all items located <br />within Ixora warehouse and all other sites where inventory was located. The Utilities <br />also wanted to have customer service use HANSEN to create work orders, so customer <br />service could assign work orders to certain individuals. assign pans issued to work orders <br />and be able to track the work orders until they where completed. Vv ith the changing of <br />personnel within the Utility Department, this program neer got under way. The one use <br />that we used HANSEN for was for tire hydrant inventory and for tracking fire hydrant <br />maintenance. <br />To improve efficiency and cut cost. we transferred all fire hydrant inventory and fire <br />hydrant maintenance from the Oracle database within the Unix environment to a <br />Windows N/T environment using a Microsoft Access database <br />FEBRUARY 5, 2002 <br />-91- <br />u <br />