Laserfiche WebLink
<br /> <br /> STAFF REPORT <br /> <br /> <br /> <br />TO: Mayor Keis and Members of City Council <br /> <br />FROM: Bill Dircks, Public Works Director <br /> <br />DATE: September 8, 2016 <br /> <br />RE: Database Upgrade for Meter Reading System <br /> <br />As you know, the City upgraded its water meters in 2012 to a fixed-network meter reading system. <br />The meters send the readings to two data collectors in the City and the collectors export the readings <br />into a database where they can be read and managed by staff. <br /> <br />We were using a free version of the SQL database and it served us well but we have now filled it up to <br />capacity so the readings that are being collected cannot be stored in the database. We can upgrade to a <br />bigger database and it should take care of our reading collection issues. The database we would <br />upgrade to is large enough to last us many years and we should no longer have any issues. It’s hard to <br />ballpark a number of years but Roseville IT said there would likely be a technological end-of-life of <br />some component of the system before we ran out of storage. We have also taken measures to reduce <br />the amount of data by keeping hourly reads for only 15 months, daily reads for another month, and <br />then monthly reads prior to that. <br /> <br />The cost of the database is $1,141.00, including $205 for a 32 month license. The license will need to <br />be renewed in 32 months. Roseville IT estimates the renewal to be approximately $285 in 2019, which <br />would again cover 32 months. <br /> <br />Staff recommends purchasing the upgraded database at a cost of $1,141.00 using funds from the <br />water/sewer capital improvement budget. <br /> <br />