HomeMy WebLinkAbout15.D.1. Software Programming and Training for Pavement, Sewer and Sign Maintenance
CITY OF SHAKOPEE / j-' O. ,.
Memorandum
TO: Mayor & City Council
Mark McNeill, City Administrator
FROM: Bruce Loney, Public Works Director
SUBJECT: Authorize Purchase of Software Program and Training for
Pavement, Sewer and Sign Maintenance
DATE: December 2, 2003
INTRODUCTION:
Attached to this memo is a proposal from GoodPointe Technology of St. Paul, MN, an
infrastructure consultant on infrastructure management systems for an additional software
program, training and support for the pavement, sewer and sign maintenance systems for
the City of Shakopee. The purpose of this memo is to request Council authorization to
purchase the software program support and training.
BACKGROUND:
The City of Shakopee does currently have a Pavement Management System from
GoodPoint Technology for the past several years. The City of Shakopee recently
completed an Organizational Study for the City on its Public Works Department and had
a list of 17 recommendations for the Public Works Department to consider for improving
its performance and efficiencies.
In meeting with GoodPointe Technology on the City's Pavement Management System,
the City's needs were for an upgrade of the system with training on operation of the
systems for public works employees and support for the coming year. Also, during these
discussions, the City discussed the interfacing of other systems with the pavement
management program, such as sanitary sewer, storm sewer and sign maintenance.
GoodPointe Technology has developed other programs to be used with this pavement
management program for sign maintenance, sanitary sewer and storm sewer maintenance,
which could be interfaced with GIS mapping and forecasting and reports for better
reflection ofthe current infrastructure asset inventory and condition of the systems.
Attached to this memo is a description of the Infrastructure Consultant Program (ICON),
which is a relational data management system which is linked together through a
common referencing system based on inventory segments. The ICON program can assist
the Public Works Department and the asset inventory of its systems and better
management of those systems, which is a user-friendly computer program. The total
cost of the software support and additional programs for sanitary sewer and sign
management is $9,725.00. There may be additional costs for the set-up of the sewer
management model, which is yet to be determined, and that cost can be paid out of the
Sanitary Sewer Fund. Of the $9,725.00 cost, $3,000.00 would be paid out ofthe Sanitary
Sewer Fund and $6,725.00 cost would be paid out of Professional Services in the Street
Division budget. There are ample funds in the Street Division accounts for 2003 for this
expenditure. Staff has also budgeted for software support for 2004 for these programs.
Also attached to this memo is an e-mail from Tony Kadlick of GoodPointe Technology to
staff on the compelling reasons for purchase of the ICON system at this time. Staff
believes that this is a good first step in modernizing the Public Works Department and
computerizing the information for the infrastructure systems in which the Public Works
Department is responsible for managing and operating. By purchasing this software
support and training, the Public Works Department will be better to account for the
infrastructure asset inventory, the asset condition of the pavement, sign and infrastructure
assets and better coordinate the maintenance of these systems with other improvement
projects, so that the City can receive their maximum return of their investment of these
resources. Ultimately, these programs can work with the GIS system, which enables the
City to be more responsive to its customers and citizens as this can be tied to the property
address data base of the City.
Staff would recommend the purchase of the software programs with support and training
to address the recommendations within the Organizational Study for the City of Shakopee
and to begin to modernize its capabilities in maintaining and operating the pavement, sign
and sewer systems for the City of Shakopee.
ALTERNATIVES:
1. Approve a motion authorizing the purchase of additional software support and
training, as outlined on Exhibit A in the agreement between GoodPointe
Technology and the City at a cost of$9,725.00.
2. Do not authorize the purchase of additional software support and training at this
time.
3. Table for additional information.
RECOMMENDATION:
Staff would recommend Alternative No.1, for the City to upgrade its computer programs
for the Public Works Department in maintaining and operating its pavement, sign and
sewer systems. It should be noted that of the $9,725.00, $3,000.00 would be paid out of
the Sanitary Sewer Fund and the remaining $6,725.00 would be paid out of the Street
Division, Professional Services account.
ACTION REQUESTED:
Approve a motion authorizing the purchase of additional software support and training,
as outlined on Exhibit A in the agreement between GoodPointe Technology and the City
at a cost of$9,725.00.
~~'1
Bruce Loney
Public Works Director
BUpmp
SOFTWARE
,
i
Underground
Uti I ity
i Management
.n.......... '.." " ......,.....--.,........ .... . "., .... .~_. ......." . ......... ~....- ..
.. '~'..'-. . "...~"'" ". .~'" "''''h"
! ,,"..--,.~
;
--.........-_....... .......,.,~.._.. ", ,......,....
Infrastructure CONsultant (ICON)
Infrastructure Management System
In this document, you will find:
. Brief bescription of the ICON Software
. ICoN System Features and User Benefits
. Information Stored in the ICON Sewer Module
. Information Stored in the ICON Water Module
. Hardware and Software Requirements
. Adaptability of Software
Please contact us with your questions or comments:
GoodPointe Technology
287 E. 6th Street, Suite 200
St. Paul, MN 55101
Phone (651) 726-2555 Fax: 651.726.2545
Internet: www.goodpointe.com Email: info@qoodpointe.com
ICON Underground Utility Management
Introduction
The Infrastructure CONsultant (ICON) program is a relational database management
system that consists of approximately 120 attribute tables, which are linked together
through a common referencing system based on inventory segments that comprise your
infrastructure network. IGON works as a multi-user, multi-access system so that the staff
from various groups within your organization can manage the information that is relevant
to them. The following diagram shows the ICON management modules:
S{$~~ r- - .. .,
W""f~ OHI",
- ICON
:- '. ~. :,:' ". .: .,~
Key to the Above Diagram
The ICON Infrastructure Management System is composed of multiple modules. The
GIS Mapping, Budget Forecasting, Reports, and WorkOrder modules work with all the
modules in the center of the diagram. The information stored in the Sign module and
Right of Way Module are entirely dependent on the inventory definitions in the Pavement
module. The inventory stored in the Sewer- and Water modules may be managed
independently from the inventory stored in the Pavement Management Module and/or
may be integrated with the pavement module based on the needs of your agency.
For Pavement Management Users
The ICON Pavement module is used to set up each inventory unit (section) of pavement
(e.g. street block), which is referenced by its official street name and its 'From' and 'To'
streets: for example: Broadway From Brooklyn Avenue to 8th Street. In other words, the
pavement management system is built on a linear referencing system, where all
infrastructure data (e.g. condition surveys, curb and gutter features, etc.) is associated to
a given inventory section in the pavement network.
,"!
For Sign Management Users
The ICON Sign module is used to track inventory features for each sign, sign post, post
base, location, sign condition, ~tc. in your sign network. Essentially, each sign may be
thought of as a point attribute, which is associated to each linear pavement management
inventory section.
For Sewer and Water Management Users
The ICON Sewer and Water Modules allow the user to store information on sewers
(sanitary- and storm-sewers) and water mains. You can enter specific reference names
for your pipe sections and. as an option reference them to pavement management
sections.
Copyright 2D03 GoodPointe Technology Corporation All Rights Reserved Page 1 of 13
ICON Underground Utility Management
ICON System Features
Our system provides:
. Intuitive mapping interface integrated with today's latest ArcView™ GIS Technology.
. Relevant forecasting models built on accepted civil engineering practices and
standards, including GASB 34 Compliance for applying the Modified Approach.
. Complete inventory of Storm-, Sanitary-, and Water Main systems that can be
associated with pavement management inventory or not.
. Distress condition of sewers based on user-defined lists.
. Storage of other utility information related to pavements, such as sewer structures,
sidewalks, curb and gutter, culverts, guardrails, signs and signals, and others.
. Access to existing condition history information and related surveys.
. Operates with limited data available for an inventory segment.
. Projected condition forecasting based on site-specific performance models (1st, 2nd,
3rd, and 4th order curves) that you can customize.
. User-defined strategies and deterioration curves specific to each sewer type and
material classification.
. Optimized pavement rehabilitation methods and ability to prioritize them based on
user-definable criteria such as annual funding, rank, capacity, historical project data,
minimum selected condition level, and others.
. Analysis of budgets, maintenance programs, and impacts of postponing scheduled
maintenance.
. Ability to save multiple"What If' scenarios without affecting working database files.
. Runs on MS Access or MS SQL Server or Oracle platforms.
. Utilizes Crystal Reports™ program for generating customized system reports and
exporting to standard third-party data formats (MS Excel, MS Word, etc.).
. Detailed rehabilitation backlog reduction programs.
. The ability to include or exclude streets based on utility holds or priorities based on
Capital Improvement Project (CIP) Lists, which you can develop in ICON.
. Maintenance and repair cost tracking and work order generation.
. Integrated with ICON Pavement Management, Right-of-Way Management, and Sign
management modules.
. Projection of annual expenditures and life-cycle cost analysis up to 75 years.
. Additional scenario analysis tools that enable you to regroup your optimal multi-year
maintenance, repair, and rehabilitation plans into more logistically feasible plans in
pre-determined geographic work zones.
. High-impact intuitive color graphics, charts and map presentations.
The following text (in black) overviews the information that is stored and retrieved in
ICON. Features indicated in red text are system enhancements currently in progress to
be delivered shortly. Please contact your local ICON support representative for more
details.
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 2 of 13
ICON Sewer Management Module
The following sewer management information is stored in ICON:
(1) Type of Flow: ICON stores what type of flow the pipe is designed for. The
options are
a. Sanitary Sewer
b. Storm Sewer
c. Combined Sanitary/Storm Sewer
ai'tpe Type WlWmailtloo _ ^" ,,~.:~Ji{J'#r,wK:~' " 11r~~~\~~Wt:iii!!v:~W:'~;: :~X;;;~~:~'~;':.-:'.:
FiI3!!> . "'!iO~~ '. .
T;"PIi.Ol F1toW I B~~hilr~nlotQ~1 Tl4'~o)l~e J.
S~iOllr'(iI."L:',,~\'t: N-)1t:.l'ull,\(1 t.,V:. N .ro~.l
. .." ...~,Ct~j
. ..
· i- S&li\~'seWer
'.
'. . . . ..
.. . ." .'
. . . . ..
. . ','
". . .. - . . .
". .~,!,.~~..,.I'i!.'l'l:~~W~_<~~~~_~''''''''''~.e'...._,~_. ~...'
riNQ(lt~eIS\lef!: .... < . .... ". .' . .. ..' .... ..... .
~ &n..aQ:lllll~llsl?'(h'~!li:~' ;, .;.;.;\. .,. Ne:)~ . t fti~1y i ., CIII'lle
(2) Location of Pipe: ICON stores the beginning and ending stationing information
for the pipe. The following attributes are stored for pipe stations:
a. Type of Station (Manhole, Catch Basin, etc) along with attributes for that
station. The following is just a partial list of some of the information
collected for station types:
i. Outlet Elevation of a manhole
ii. Rim Elevation of a manhole
iii. Depth of a manhole
iv. Pond Volume
v. Pond Name
vi. Fenced or not fenced
vii. Wet or Dry Pond
viii. Lift Station information
b. Actual location of that station
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 3 of 13
,'I,
ICON Sewer Management Module
~Pipe Type Infornlation > ~,4~; ~"' %:;;i:i~~$1=~~.<~~ ~ 1I1'~~111~i~A~~1}~j~~rJi,iit~~tt(;~ i\\;~:.;.,.~/".:;'J-.~J]J.
Pipe 13 . . . . . .:dfi be'~t~T .
Type of Flow Stationlnformation]Type.OfPipe I
. rBeginStetion. . .' . . . .' 1....
. I . .. .' '. .
. BeginstetionTypelManhole .=:1'.' ..' .... ..... ... .... ........ .... ........ .
BeginstationLocationl........ . .10. .... 3' createStatiOh\ ~Refreshll
. ...tg Stationlnf6rmationl. .... .1.
~:::::T>Pe--luft8mtions' ~J .......~.
. EndStationLocation! . 352 ::1 createStatiOf,lIi!.Refreshl'
'. . QStation Information \. .'.
r'NotlJnderStreet ... ....< . ". ............ .' .... . .......q '.'
IIJ SEllViceConnedionsl?{ivalvesl.PreViousf.. NeXt ..I....~APp~ .l~ Close '.1
(3) Type of Pipe: ICON stores the type of pipe that is being inventoried, along with
specific inventory for that type. Currently, there are four (4) main types of pipe:
Main, Drainage, Interceptor, and Channel. A channel pipe has different
information collected than the other three. That information is outlined as
follows:
a. MAIN, DRAINAGE, AND INTERCEPTOR
i. Diameter
ii. Length
iii. Material
iv. Shape
v. Upstream Invert
vi. Downstream Invert
vii. Surface type above pipe
viii. Drainage Basin
ix. Friction Factor
x. Slope
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 4 of 13
ICON Sewer Management Module
Pipe-13 . .:J . =,i Oete1e 1
T)'Pt\!QfF~'1 ~liQlI.lrd~~\11i T.vpi!oilF~ I
Pip~TM:t~ro;;~~qe ~~'---::J
'~Oiamel:~r:11D ~~.
\1:le. LElf!9l~I:~l1 co'
. . !=1P~ Ml:Iillllicl 'j':'Dl1crl:'Xl .:J
~~~F--'-~ .'
liil~et!ru tn:.i!!(~ Illl Z5 - .' ,
.. ~~~~
tlJ:iM1~&'i!ii"1' 1ft'1e1113C 69
SllIf&3T~ .IAC .:J
Dr(lilli:Xgeao~i!'l :ft';:::t't<, ;] .
. FritJiQraf~r IU121
'. . Slope ~if!~~~.t. ':;'":j~'..;:;;';;:,"'" ...,.....,..., ....;.~..
l'/'ktWnderStIiilitt .....
f!I. Si!!r.;ifi!b:l~tim ' . ~. Clmlii!
b. CHANNEL
i. Coordinates
ii. Station
Hi. Type
iv. Material
v. Creek Name
vi. Bank Height
vii. Width
viii. Length
ix. Shape
x. Elevation
xi. Access point information (type, address, width, height, and length)
(4) ImagesNideos: ICON will allow multiple images and/or videos to be stored in
association with a specific pipe.
(5) Projects: ICON will allow the entry of projects to document the maintenance
activities logged for each sewer section. The following information can be
entered for a project:
a. Date of project
b. Time of project
c, Type of project, which is user defined
d. Location of project, based on stationing
e. Description of project
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 5 of 13
ICON Sewer Management Module
f. Visual display of project: This is a diagram that will show the location of
the project that was just entered on the pipe, in reference to the beginning
and ending stationing of the pipe and the location of the project (S.d)
g. Comments for the project
(6) Condition Surveys: ICON will allow the entry of surveys for each sewer. The
following information can be entered for a survey:
a. Date of survey
b. Time of survey
c. Location of survey, based on stationing
d. Distresses Noted (from a user-defined list)
e. Distress Quantity
f. Reference Condition Index (CI)
g. Visual display of project: This is a diagram that will show the location of
the project that was just entered on the pipe, in reference to the beginning
and ending stationing of the pipe and the location of the survey (B.c)
h. Comments for the survey (address referencing)
(7) Service Connectors: In addition to storing information based on the pipe itself,
ICON also stores information on service connectors. Service Connectors are
pipes that run from the pipe itself to other locations (residential houses, fire
hydrants, commercial buildings, etc). The following information is stored for
Service Connectors:
a. Coordinates
b. Station
c. Pipe type
d. Pipe size
e. Address
f. PIN #
g. City Permit #
(8) Valves: In addition to storing information based on the pipe itself, ICON also
stores information on valves connected to the pipes. The following information is
stored for Valves:
a. Coordinates
b. Station
c. Type
d. Size
e. Depth
f. Status (Open, Closed, etc)
g. Manufacturer
(9) Graphs and Reports: ICON will include the ability to view the sewer data
through graphs and reports. The following graphs and reports will be available to
the user (hard coded) at any time through the program:
a. Age of Pipe graph and report
b. Diameter of Pipe graph and report
c. Pipe Type graph and report
d. Project graph and report
e. Repair graph and report
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 6 of 13
ICON Water Management Module
The following sewer management information is stored in ICON:
(1) Location of Water Pipe: ICON stores the beginning and ending stationing
information for the pipe. The following attributes are stored for pipe stations:
a. Type of Station (Manhole, Catch Basin, etc) along with attributes for that
station. The following is just a partial list of some of the information
collected for station types:
i. Manhole's Outlet Elevation
ii. Manhole's Rim Elevation
iii. Manhole's Depth
iv. Pond Volume
v. Pond Name
vi. Fenced or not fenced
vii. Wet or Dry Pond
viii. Lift Station information
b. Actual location of that station
Depth ..132.50
.... Flow Depth ..10.00
Dropf:Aanhole lr. No'
'. anholeSte.tion 10.00 InVe.rts 0.00 I
OlltletElevation' 0.00 Cover Type Neenah R-1642 I
"Rim Elevation 908.65 Cover Diameter 27 I
." .' '. . I
Manhole Type I Eccentric ..!.l". !
~-'~'---""""""'~~-":-'.'-"''''---'-'-~-'-'---~-/f~:.;~r-"~rlr"'''~.:-a~;~--".I
__7.a......p..p...y._
(2) Pipe Information: The following water pipe information is stored in ICON:
a. Stationing
b. Type
c. Size
d. Length
e. Depth
1. Soil Type around pipe
g. Reference Number
h. Pressure Zone
i. Coordinates
(3) ImagesNideos: ICON will allow multiple images and/or videos to be stored in
association with a specific water pipe.
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 7 of 13
ICON Water Management Module
(4) Projects: ICON will allow the entry of projects to document the maintenance
activities logged for each section of water pipe. The following information can be
entered for a project:
a. Date of project
b. Time of project
c. Type of project, which is user defined
d. Location of project, based on stationing
e. Description of project
f. Visual display of project: This is a diagram that will show the location of
the project that was just entered on the pipe, in reference to the beginning
and ending stationing of the pipe and the location of the project (5.d)
g. Comments for the project
(5) Condition Surveys: ICON will allow the entry of surveys for each sewer. The
following information can be entered for a survey:
a. Date of survey
b. Time of survey
c. Location of survey, based on stationing
d. Distresses Noted (from a user-defined list)
e. Distress Quantity
f. Reference Condition Index (Cl)
g. Visual display of survey: This is a diagram that will show the location of
the project that was just entered on the pipe, in reference to the beginning
and ending stationing of the pipe and the location of the project (5.c)
h. Comments for the survey (address referencing)
(6) Service Connectors: In addition to storing information based on the pipe itself,
ICON also stores information on service connectors. The following information is stored
for Service Connectors:
a. Type
b. Diameter
c. Length
d. Depth
e. Freeze Level
f. Account Number
g. Customer Name
h. Customer Number
i. Customer Address
j. Service Application Number
k. District
I. Reference Number
m. Pressure Zone
n. Location of water tap
o. Location of curb stop
p. Meter information
(7) Hydrants: In addition to storing information based on the pipe itself, ICON also
stores information on the hydrants connected to the pipes. The following information is
stored for hydrants:
a. Reference Number
b. Type
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 8 of 13
ICON Water Management Module
c. Manufacturer
d. Model Number
e. Main Size
f. Cap Color
'g. Branch Size
h. Static Pressure
i. Serial Number
j. Gates (yes or no)
k. Dead End (yes or no)
I. Pump After User (yes or no)
(8) Graphs and Reports: ICON will include the ability to view the water data through
graphs and reports. The following graphs and reports will be available to the user (hard
coded) at any time through the program:
a. Age of Pipe graph and report
b. Diameter of Pipe graph and report
c. Pipe Type graph and report
d. Project graph and report
e. Repair graph and report
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 9 of 13
ICON Underground Utility Management
Recommended Hardware and Software Requirements
To ensure the optimal operation of the ICON program at your organization, GoodPointe
Technology presents the following hardware/system specifications:
NETWORK SERVER:
Recommended Minimum Requirement
CPU Type Pili 400 Pentium 233
RAM 128M 32M
Disk Storale 20G 4G
Operating . ystem Windows NT Server Windows 98
CLIENT WORKSTATION PC:
Recommended Minimum Requirement
CPU Type Pili 233 Pentium 133
RAM 64M 16M
Disk Storage 5G 2G
Operating System Windows NT Workstation Windows 95 or Above
Additional Hardware CDR/W CD ROM
For Digital Image Storage
NETWORK:
Recommended Minimum Requirement
Speed 100Mbps 10 Mbps
INTERNET AND EMAIL ACCESS IS REQUIRED
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 10 of 13
ICON Underground Utility Management
Chances are, your agency has already implemented a GIS for your infrastructure
network; if so, the purchase of an additional third-party software package is not required.
A digital centerline map (e.g. ArcView shape file) comprised of segments which is linked
to and corresponds to the management sections of your ICON sewer or pavement
network, however, is required to integrate your map to ICON.
The ICON infrastructure management system is written as an open object-oriented C++
application. The system operates in the Graphical User Interface (GUI) environment,
developed to provide an open, integrated partnership with today's industry standard
software. ICON is installed at your organization like any other Windows program that
you purchase. The ICON package comes with an installation CD, easy-to-follow
instructions, and a continually updated program user guide for ongoing use. With the
Live Update feature of ICON, software updates and enhancements can be automatically
downloaded to the correct file locations on your computers with a click of your mouse.
System Adaptability
Our software system has been continually improving according to new client needs and
the availability of new technology. The result is a comprehensive, yet flexible
infrastructure management system. ICON's graphical user interface is easy to operate
and provides unmatched customization capabilities. As needs change, agencies will be
able to make adjustments to the system.
The data collection equipment and technology used by GoodPointe Technology is state-
of-tha-art, yet is easy to understand and apply. Our system is not a closed black box; it
is based on an open, intuitive approach that provides agencies with a number of options
when updating the infrastructure management database.
Our software is built on rules that provide the ability to change a number of the aspects
of ICON just by changing certain tables. If your agency would like additional
modifications to the program that are not developed by the users group then GoodPointe
Technology can work with you to integrate these changes in ICON.
Additional Information
Thank you for your interest in the ICON Infrastructure management system. Additional
information on GoodPointe Technology software products and services are available on
our website at www.qoodoointe.com.
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 11 of 13
EXHIBIT A Shakopee Update Project October 3, 2003
Task 1. ICON Software Support Agreement
The Standard Support Agreement covers: ICON telephone support, admission to the
ICON user's group meetings held at least twice per year, passwords to
the GoodPointe online bulletin board system and Live Update feature through the
ICON program, plus all software upgrades and enhancements for the current support
period of June 1, 2003 through May 31, 2004.
Annual Maintenance Fee: $1,500.00 (due on 6/1/2003)
Task 2. ICON Premium Support Upgrade (80 Hour Package)
Under the Premium Support Upgrade GoodPointe proposes to:
. Update the City's ICON pavement management inventory database to reflect
today's current inventory. GoodPointe will do all the manual data entry tasks
and database query work to ensure that ICON program is up to date.
. Enter historical projects from hardcopy maps (supplied by the City), into the
ICON database and then register the associated pavement condition (PCI)
benefit of these projects.
. Provide ICON system training to City staff to ensure that everyone is
comfortable with their roles with managing and maintaining the ICON
database.
. Work the City to define its current pavement maintenance, repair, and
rehabilitation policy, unit costs, and pavement performance curves into the
ICON software.
. Assist the City with running budget analysis scenarios to show the projected
budgetary and deferred maintenance requirements of the growing City
network for pavements and/or underground utility (sewer) networks.
. Load the City's current Capital Improvement Projects (CIP) list into the ICON
software for use in generating budget analysis scenarios
. Associate the City's sign management spreadsheet (XLS) to the City's PMS
database and then load it into the sign management tables of the ICON
system for ongoing use at the City.
. Work with the City to define and create multiple system reports (Crystal
Reports) to be used by the City for presentation to the City Council, including:
0 Pavement condition reports by inventory section, etc.
0 GIS street maps of current pavement condition and projected
pavement condition with other 'what if scenario runs.
0 Pavement age maps and distribution charts to show the age of the
pavement and/or sewer networks across the different areas of the
City.
0 Developing a report to establish a sewer inspection rotation for the
City network.
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 1 of4
EXHIBIT A Shakopee Update Project October 3,2003
0 Any other reports requested by the City.
The completed reports will be installed at the City so that staff can refresh,
regenerate and print the reports as new data is continually added to the
system.
Cost: $3,600.00 One Time Fee to cover 80 hours.
Task 3. ICON Sign Management Module License
The ICON Sign Management module is integrated with the pavement inventory
database of the ICON 4.0 Infrastructure Management Program in use at the City and
allows the storage and retrieval of the following information:
. Administration of Multiple Sign Management Users. The sign program
administrator can control the data access, readlwrite rights of additional users on
a per dialog box basis.
. Like all ICON modules, the sign program features the use of customized data
lists, to match the unique needs of your sign network and organization.
. Inventory Information. Sign location, sign type, sign material, configuration on
post, post type, post base, sign category type, comment field, visual image file.
. Condition Information. Date of survey, maintenance action, sign condition, sign
post condition. The condition information may include qualitative (e.g.
good/fair/poor) ratings or quantitative (e.g. retro-reflectivity) ratings. Digital photos
and movie files can be stored to document condition information in the field.
. Sign History. Date of installation, date of removal, and work order activity over
the life of the sign. This historical information may be written to an archive file for
future reference in liability cases.
. Dynamic Association. Your ICON sign data will be dynamically associated with
your pavement management inventory database so that when your pavement
network segments are updated, modified, added, or deleted, your sign data and
station reference information will change accordingly. This eliminates the need to
maintain two separate inventory databases.
. Data Checkout Feature. The sign program data can be checked out and taken
out in the field for data collection and entry operations. All sign attribute data is
time stamped and the collected data is automatically updated to the server the
next time the user logs into the server database.
The ICON Sign Module license is an unlimited-seat license, which allows the City to
install the program on as many machines as necessary. The annual support cost of the
ICON Sign Module provides support for one authorized user and includes all software
upgrades during the support period.
Note: the cost to setup the sign program will be covered by the ICON Premium Support
Upgrade of Task 2.
One Time Fee: $2,500.00
50% Discount (offered June 20(3) ($1,125.00)
Sign License Price after discount: $1,125.00
Annual Maintenance Fee: $500.00
Software Support of Additional Users: $250/user
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 2 of 4
EXHIBIT A Shakopee Update Project October 3, 2003
Task 4. ICON Sewer Management Module License
The ICON Sewer Management module is integrated with the pavement inventory
database of the ICON 4.0 Infrastructure Management Program in use at the City that
includes the following features:
. Administration of Multiple Sewer Management Users. The sewer program
administrator can control the data access, read/write rights of additional users on
a per dialog box basis.
. Like all ICON moqules, the Sewer program features the use of customized data
lists, to match the unique needs of your sewer network and organization.
. Dynamic Association. Since a good portion ICON sewer data will be dynamically
associated with your pavement management inventory database, when your
pavement network segments are updated, modified, added, or deleted, your
sewer data and station reference information will change accordingly. This
eliminates the need to maintain two separate inventory databases.
Please see "Exhibit B ICON Utility Management" for more details on the
information managed in the ICON Sewer and Water modules.
ICON Sewer module license is an unlimited-seat license which allows the City to install
the program on as many machines as necessary. The annual support cost of the ICON
Sewer Module provides support for one authorized user and includes all software
upgrades during the support period.
One Time Fee: $2,500.00
Annual Maintenance Fee: $500.00
Software Support of Additional Users: $250/user
Task 5. Setup of the ICON Sewer Management Module
Scope of Work To be determined. If the City can send GoodPointe a copy of the data
managed in its current sewer management system (including a copy of an ArcView
centerline shapefile) then we will provide a not-to-exceed, lump sum cost estimate to
import this data into the ICON Sewer Module.
Estimated Cost: To Be Determined
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 3 of 4
EXHIBIT A Shakopee Update Project October 3, 2003
Summary of Proposed Costs
Task Units Unit Cost Subtotal
1. ICON Software Support Aqreement 1 $1,500.00 $1,500.00
2. ICON Premium Support Upgrade 1 $3,600.00 $3,600.00
(80 Hour Package)
3. ICON Sian Manaaement Module License
One time Unlimited Seat License Fee 1 $2,500.00 $2,500.00
50% Discount Offered in June 2003 1 (-1,125.00) (-1,125.00)
Annual Support Fee (includes all 1 $500.00 $500.00
software upgrades and support for one
user)
OPTIONAL Additional User Support Fee
(per-user, per year charae): $250
4. ICON Sewer Manaaement Module License
One time Unlimited Seat License Fee 1 $2,500.00 $2,500.00
Annual Support Fee (includes all 1 $500.00 $500.00
software upgrades and support for one
user)
OPTIONAL Additional User Support Fee
(per-user, per year charae): $250
5. Setup of the ICON Sewer Management To Be To Be
Module Determined Determined
Total 2003 Project Budget $9,725.00
(Not Including Task 5)
Annual ICON Software Support Fee: .
To budget for period of June 1, 2004 $2,500.00
through Mav 31,2005.
Copyright 2003 GoodPointe Technology Corporation All Rights Reserved Page 4 of 4
Page 1 of2
Bruce Loney
From: Tony Kadlec [tkadlec@goodpointe.com]
Sent: Wednesday, November 12,20032:53 PM
To: Bruce Loney
Cc: Mike Hullander; Amy Grothaus
Subject: ShakopeellCON Update Project
Importance: High
Bruce:
As a follow~up to our meeting earlier today, here are six compelling reasons to upgrade the City's ICON program
for the pavement network, sign network, and sewer network:
A) To reflect the true and current infrastructure asset inventory of the City, for financial accounting purposes and
for the public work's staff to know for management purposes.
B) To reflect the true and current infrastructure asset condition of the City's pavement, sign, and underground
infrastructure assets captured in point (A).
C) To promote the intelligent coordination of maintenance/improvement projects for these multiple infrastructure
networks so that the City can plan and implement the right projects at the right time (and minimize the risk of
promoting projects that conflict with each other).
D) To maximize the return on investment (ROI) of the resources that the City invests in these infrastructure
networks. In other words, getting the most 'bang for the buck' on the resources put forth by the Citizens of
Shako pee with respect to the City's current infrastructure maintenance, repair, and rehabilitation projects. .
E) To minimize the amount of effort that public works staff puts into their maintenance management activities. We
take a lot of pride in the fact that ICON is a user-friendly system that will make it easier to maintain the system
information on a day to day basis.
F) To keep better track of where these assets are, integrated with the City GIS. Above all this will enable the City
to be even more responsive to your customers, the citizens, as they call in with service requests, since the GIS is
tied to the property address database of the city.
To this end, we recommend that the City purchase the following computer hardware to be used by the Public
Works staff under the direction of Mike Hullander:
1) One (1) laptop to be used for use in the field for running the ICON sign management program and ICON Sewer
module;
2) Two (2) desktop computer to be used in the office for data entry, retrieval, and reporting operations.
The above three (3) computers will need to be networked to the City's Local Area Network (LAN) so that all staff is
tied into the same ICON infrastructure management database, which is currently installed at the City. It is our
understanding that the City's IT/lS department will be procuring this hardware and we have not budgeted for this
hardware purchase in our proposed scope of work. Once these machines are setup to access the City LAN,
we can install the ICON program on these machines under the proposed scope of work. Please refer to the
Hardware System Requirements (page 10 of 12) of the handout we provided to your staff earlier today for more
details.
We look forward to receiving approval to proceed with this project after your December 2 council meeting. In the
meantime, let me know if there is anything else I can do to help.
11124/2003
Page 2 of2
Best regards,
Tony
Tony Kadlec, VP
GoodPointe Technology
287 E. 6th Street, Suite 200
St. Paul, MN 55101
Phone: (651) 726-2555
Fax: (651) 726-2545
Email: tkqql~J:@gQQqpQlnt~,GQm
Internet: WWW:.goodp-Qinte.com
11/24/2003
$'_.~~
TECHNOLOGV
Meeting with the City of Shakopee
Thursday October 2, 2003
,,'1;~~~~!~'~,.i '\.IJ'
The ICON Pavement module is used to set up each inventory unit (section) of pavement (e.g.
street block). which is referenced by its official street name and its 'From' and 'To' streets: for
example: Broadway From Brooklyn Avenue to 8th Street. In other words, the pavement
management system is built on a linear referencing system. where all infrastructure data (e.g.
condition surveys, curb and gutter features. etc.) is associated to a given inventory section in the
pavement network.
ICON Database Summary as of 10/1/2003:
Basic Section Information (Required by ICON for inclusion in the Budget Analysis)
. 4 sections have no surface type or functional class defined.
. 5 sections have no section dimension information. These need to be measured and
entered into ICON for proper mileage counts.
Pavement Condition Surveys
. 6 sections have never been surveyed. A Pavement Condition Index (PCI) is needed for
these sections for them to be included in the budget analysis.
. 5 sections have not been surveyed since 1995. GASB recommendations are to survey
every 3 years.
. 676 sections have not been surveyed since 1999.
. 243 sections have not been surveyed since 2000.
. 34 were surveyed in 2001.
The entire network has 972 pavement management sections. This means that 95% of the
network is due for a condition survey.
Historical Project/Maintenance Data
. The last maintenance projects entered into ICON were for 2002 (there were only 10 of
them entered for this year).
. No 2003 project information exists.
. Only 15 projects were entered for 2001.
. Most projects entered have been reconstruction projects or overlays. There have
been no seal coats entered into the system since 1998. Is this correct?
Action Items