HomeMy WebLinkAbout5.B.1. Authorize Purchase of Computer Software and Hardware for GIS System
CITY OF SHAKOPEE
Memorandum
~ 8. I,
TO:
Mayor & City Council
Mark McNeill, City Administrator
C,o~"sr"'T"
lit ,tai
FROM: Bruce Loney, Public Works Director
SUBJECT: Authorize Purchase of Computer Software and
Hardware for GIS System
DATE: November 20,2007
INTRODUCTION:
This agenda item is for the City Council of Shakopee to authorize the purchase of
computer software and hardware to support the Public Works GIS System.
BACKGROUND:
At the September 12, 2007 Telecommunication Advisory Commission (T.A.C.), the
Commission approved a motion to recommend to the City Council to spend up to
$10,650.00 in 2007 and up to $12,650.00 in 2008 for software and hardware for the
City's GIS system. Attached is a memo dated September 5, 2007 that was reviewed by
the T.A.C.
For 2007, it is recommended by Carrie Duckett, IT Coordinator and John Mackiewicz,
Consultant GIS Coordinator to purchase the following:
..1lli!1 2008
Hardware $16,074.00
Software $10,650.00 $10,650.00
Set-up $ 2.000.00 $ 2.000.00
TOTAL $28,724.00 $12,650.00
The additional software and hardware will provide the necessary computer configuration
to support the GIS system and to transmit and receive data through the use of wireless
technology.
Staffis requesting from Council authorization for T.A.C. funds up to $10,650.00 in 2007
and for T.A.C. funds up to $12,650.00 in 2008 towards the computer software and
hardware purchases to upgrade the GIS system.
The remaining amount of $18,074.00 for 2007 purchases would be funded out of
available funds in engineering, street, park maintenance, sanitary sewer and storm
drainage. Sufficient funds exist in the budget with most of the funding to be from the
utility funds, as the increased hard drive space is needed for the utility systems.
ALTERNATIVES:
1. Authorize the software and hardware purchases for the GIS system up to
$28,729.00 in 2007 and up to $12,650.00 in 2008, with $10,650.00 from 2007
T.A.C. funds and $12,650.00 from the 2008 T.A.C. funds and $18,074.00 from
street maintenance ($2,000.00), park maintenance ($2,000.00), sanitary sewer
($7,037.00) and storm drainage ($7,037.00).
2. Do not authorize funding for GIS system upgrades.
3. Table for additional information.
RECOMMENDATION:
Staff recommends Alternative No. I.
ACTION REOUESTED:
Authorize the software and hardware purchases for the GIS system up to $28,729.00 in
2007 and up to $12,650.00 in 2008, with $10,650.00 from 2007 T.A.C. funds and
$12,650.00 from the 2008 T.A.C. funds and $18,074.00 from street maintenance
($2,000.00), park maintenance ($2,000.00), sanitary sewer ($7,037.00) and storm
drainage ($7,037.00).
$t~ ct~.
Bruce Loney
Public Works D ctor
BUpmp
ENGRl2007PROJECTS/2007-COUNCIllGIS-PURCHASES
City of Shakopee
Memorandum
TO:
Bruce Loney, Director of Public Works/City Engineer
FROM:
John Mackiewicz, GIS Coordinator
Carrie Duckett, Information Technology Coordinator
SUBJECT:
GIS Server
DATE:
November 13,2007
Introduction
The purpose of this memorandum is to provide a recommendation for the purchase of hardware
and software for the GIS Server.
Background
GIS applications are used by many departments within the city to access property data, utility
locations, maintenance information, and increase the quality of service provided to residents.
This information can be accessed in a variety of ways including the use of desktop GIS software
and internet mapping applications.
The Public Works department has been working over the last year to develop a GIS that will
accomplish the following:
. Centralize GIS data resources in the City
. Increase the efficiency of operations
. Quickly provide accurate information to office and field staff
. Increase the level of service provided to the public
. Minimize long term maintenance costs
A key element of the Pubic Works plan is to begin the deployment of field laptops to access and
update the available GIS resources. The planned system relies on the use of wireless technology
and Virtual Private Network (VPN) connections to deliver spatial and attribute data quickly and
reliably to field staff. Because of the large size of GIS databases and bandwidth limitations of
VPN connections the Public Works and Information Technology Department examined possible
solutions to overcome the challenges that are presented.
After reviewing hardware and software configurations for the GIS server, it is our
recommendation that the City purchase a stand alone GIS Server and add an additional 750GB of
hard drive space to the City's SAN. This solution will provide the best combination of
performance, data redundancy, and expandability.
Budget Impact
The estimated cost for 2007 and 2008 is shown below in Table 1.
Hardware
Software
Setu
$16,074
$10,650 $10,650
$2,000 $2,000
$28,724 $12,650
Table 1. Estimated Cost
The Telecommunications Advisory Commission has agreed to pay up to $10,650 of this cost in
2007 and $12,650 of the cost in 2008. The Public Works Department has the remaining $18,074
available in 2007.
Requested Action
Authorize appropriate city staff to purchase the GIS server hardware, software, and SAN storage
at a cost not to exceed $28,724 in 2007 and $12,650 in 2008.
City of Shakopee
Memorandum
TO:
Telecommunications Advisory Commission
FROM:
Bruce Loney, Director of Public Works/City Engineer
John Mackiewicz, GIS Coordinator / Consultant, WSB Associates
SUBJECT:
GIS Server
DATE:
September 5, 2007
Introduction
The Commission is asked to recommend to the City Council that funds be allocated from the
Telecommunications Fund to support the purchase of Geographic Information System (GIS)
server software and hardware.
Background
GIS applications are used by many departments within the city to access property data, utility
locations, maintenance information, and increase the quality of service provided to residents.
This information can be accessed in a variety of ways including the use of desktop GIS software
and internet mapping applications.
The Public Works department has been working over the last year to develop a GIS that will
accomplish the following:
. Centralize GIS data resources in the City
. Increase the efficiency of operations
. Quickly provide accurate information to office and field staff
. Increase the level of service provided to the public
. Minimize long term maintenance costs
A key element of the Pubic Works plan is to begin the deployment of field laptops to access and
update the available GIS resources. The planned system relies on the use of wireless technology
and Virtual Private Network (VPN) connections to deliver spatial and attribute data quickly and
reliably to field staff. Because of the large size of GIS databases and bandwidth limitations of
VPN connections the Public Works Department is examining possible solutions to overcome the
challenges that are presented. Options to address these issues are outlined below:
Option A - Purchase ArcGIS Server Basic
ArcGIS Server is a complete and integrated server-based GIS. It uses advanced GIS technology
to provide:
. Better data management
. Data replication
. Lower bandwidth data delivery
. Integration with other enterprise systems
. Lower cost of ownership
This solution utilizes the latest server-based GIS database technology to reduce bandwidth
requirements and automatically replicate most of the data required for field applications. This
eliminates time that is often wasted performing data replication and validation for field use. This
option also provides the hardware and software framework needed for future web based GIS
applications.
Server Hardware
ArcGIS ServerlSQL Server Software
Server Setu
$12,541
$10,650
$2 000
$25,191
Table 1: Option A Costs
Option B - Purchase ArcGIS Server Standard
This option would provide all of the advantages of Option A and provide the following
additional features:
. The ability to provide internet based mapping applications to City staff and the public
. The ability to provide a City wide tightly integrated GIS based Service Orientated
Architecture (SOA)
. Future cost savings by replacing LOGIS Map
Server Hardware
ArcGIS ServerlSQL Server Software
Server Setu
$12,541
$21,300
$4,000
$37,841
Table 1: Option B Costs
The ability to provide internet based GIS mapping and services would streamline the existing
GIS operations within the city saving time and work replication. Long term maintenance costs
could be realized by replacing LOGIS Map with a locally hosted GIS web application. This
would decrease the existing annual maintenance paid by IT from $32,400 to $5,000.
Option C - Purchase scaled down Arc GIS Server Basic
This option would provide the short term advantages of Option A but would require the purchase
of additional hardware in the future support the delivery of web applications.
Server Hardware
ArcGIS ServerlSQL Server Software
Server Setu
$7,535
$10,650
$2 000
$20,185
Table 3: Option C Costs
This option differs from Option A in that it does not include the hardware platform required to
support Option B. If the City decides to proceed with Option B in the future, additional
hardware would be required and additional costs would be incurred as the servers would need to
be reconfigured.
Requested Action
If it concurs, the Commission should offer a motion to recommend to the City Council that
$10,650 from the 2007 Telecom R&D fund be allocated for the purchase of GIS Server software
so the Public Works Department can proceed with the implementation of Option A. The Public
Works Department has funds available to finance the remaining $14,541 for hardware and server
setup. This action would provide the Public Works Department with a cutting edge GIS and the
hardware platform required to move forward with Option B if necessary in the future.
~o~..^ )
Public W or~ector