HomeMy WebLinkAboutIndependence Enterprises - Land Loader Upgrade -2005 09 12
..
W-:--."-;.
,
f~ECEIVED
OCT 0 5
CITY OF WINITiR SPRINGS
OFFICE OF THE CITY CLERK
4381 W Dogwood Lane, Cedar Hills, UT 84062
801-796-6148
Winter Springs, Florida - Land Loader Upgrade
DATE:
September 12,2005
It is our pleasure to offer the following proposal to assist you with your addressing interface.
I. General Description of project.
independence enterprises is to assist the City of Winter Springs in evaluating and re-
writing the KivalP AO data upload routines. The work performed is to include the
following:
· Update the landrunxxx.bat batch program to execute the Oracle data loader "sqlldr",
execute the landprepa.sql, landprepb.sql and landload.sql script files, and perform the
necessary housekeeping as appropriate. The changes need to incorporate any
procedural differences between updating an Oracle 8.1.7 database versus an Oracle
9.2 database.
· Modify the process to accommodate differences in the handling of rollback segments
between Oracle 8.1. 7 and 9.2 release levels.
· Ensure PL/SQL scripts generate consistent results when updating the Oracle 9.2
database in both a Kiva 6.2 and Kiva 7.2+ environment.
· Review the manner in which the PL/SQL scripts deal with the updating of master
address entries, the use of sequence numbers in generating key identifiers, etc.
· Review the use of the 'location description' field for providing additional address detail
versus using an alias address in those cases where a single parcel has multiple
addresses that are not maintained at the county level
· Any other modifications necessary to ensure that the data is loaded from the P AO files
into Kiva.
II. Cost Estimate
All work done will be billed on an hourly basis at a rate of$130.00 per hour. A
minimum of 8 hours per day will be billed for on-site work. Off-site work will be
billed by the hour. Travel expenses will be billed at actual cost. Travel expenses
include airfare, car rental, hotel, and $46.00 per Diem. Time for travel will not be
billed, however the per diem will be billed for all on-site and travel days.
The following is a cost estimate for this project:
r--..
Item Quantity Cost
Off-Site work 8 hours $1,040.00
Total $1,040.00
III. Assumptions
Winter Springs will provide:
· Personnel assistance wherever necessary.
· Perform the final test of the completed scripts against a test database.
independence enterprises:
· Complete the script modifications and test them against a local copy of the
Winter Springs database.
· Deliver the scripts to the City for final testing.
IV. Payment Schedule
· All time will be billed on a time and materials basis.
· All invoices are due net 30 days from the date the invoice is received. Interest
will be charged for all invoices past due at an annual interest charge of 24%.
All payments are to be made in U.S. funds.
V. General Notes
1. The client is responsible for expenses incurred at the client's site. They
include, but are not limited to, air and ground transportation, lodging, and per
diem. All expenses will be reimbursed as submitted from actual receipts.
2. Programming will be scheduled within one month of receipt by independence
enterprises, the original signed Agreement.
3. All scripts and procedures not part of the original Accela upgrade routines are
and will remain the property independence enterprises, Inc.
4. This project is governed by any licensing agreements currently in affect
between Accela and the Winter Springs, Florida.
5. independence enterprises does not guarantee the performance or functionality
of any form or report that is delivered by Accela to the Winter Springs as part
of the licensing agreement between Accela and Winter Springs.
4
./ '
//,
Stephen iC'.'Ro'berts, resident
independence enterprises, Inc.
AGREEMENT ACCEPTANCE
1/2C/v'1
Date
~o.4'v--t ~~
. y of Winter Springs, Florida
c;'-I'-(- OJ-
Date
2