HomeMy WebLinkAbout13.C.2. Extension Agreement for Consultant Services to Implement a GIS/Asset Management System
lo.C.:L.
CITY OF SHAKOPEE
Memorandum
TO: Mayor & City Council
Mark McNeill, City Administrator
FROM: Bruce Loney, Public Works Director
SUBJECT: Consider Proposal from WSB & Associates to Implement a
GIS/ AMS for the Shakopee Public Works Department
DATE: July 18, 2006
INTRODUCTION:
Attached is a proposal to implement a Geographic Information System (GIS) and Asset
Management System (AMS) for the City of Shakopee Public Works Department. This
agenda item is to consider approving this proposal and order the GIS/ AMS program for
the Public Works Department.
BACKGROUND:
In the 2006 Engineering Division of the Public Works Department budget, a GIS
specialist position was included in the Engineering staff. The total budget amount
including salaries and benefits is $48,308.00 for 2006. The Public Works and
Engineering management staff have met in order to begin the implementation and
development of a GIS and AMS for the Public Works Department. This committee
includes the Public Works Supervisor, Park Maintenance Supervisor, Street Maintenance
Supervisor, Assistant City Engineer, Project Engineer and the Public Works Director.
This committee did review two proposals, one from WSB & Associates, Inc. and one
from Logis to implement a GIS/AMSprogram. Two proposals can be summarized as
follows:
. The WSB & Associates, Inc. proposal, which has been done for Cities such as
Rosemount and Minnestrista, involves a high level GIS programmer and system
development person to review the Public W ork~ Departm~nt's needs in the
various areas of asset management. This person can review our existing programs
and make recommendations on utilization of these programs or consideration of
other programs that would function better and meet the needs of the Public Works
Department. Essentially, this proposal would "kick start" and develop the
GIS/ AMS for the Public Works Department and get the systems to a point where
a GIS specialist could then manage the day to day operations of asset
management.
. The Logis proposal essentially would be working with a GIS technician staff in
order to help develop the GIS/AMS program. In this proposal a GIS technician
would need to be hired and this person would work with Logis in developing the
program.
The committee did meet with both WSB & Associates and Logis representatives and the
unanimous opinion of the committee was that the WSB & Associates proposal would
provide the best services in a cost effective way in moving the City's, Public Works
Department ahead in GIS/AMS.
The proposal, as submitted, is $40,585.00 and would essentially run for the rest of this
year and get the systems of the pavement management, sanitary sewer, park maintenance,
storm drainage and sign maintenance up and running for a GIS technician to manage. In
the WSB proposal, it would be proposed that $26,145.00 be taken out of the Engineering
budget with the funds to be out of the salary of the GIS technician and $14,440.00 would
be taken out of Sanitary and Storm Drainage Utility Funds for work done in these
utilities.
Staff believes this a cost effective way in moving the Public Works Department in the
area of GIS and AMS, which is a goal for 2006 in the Public Works Department. The
action requested would be for Council to approve the proposal from WSB & Associates,
Inc. and enter into an extension agreement for consultant services.
ALTERNATIVES:
1. Approve a motion to execute an extension agreement with WSB & Associates,
Inc. for consultant services on implementing a GIS! AMS for the City of Shakopee
Public Works Department.
2. Do not authorize the WSB & Associates proposal.
3. Table for additional information.
RECOMMENDATION:
Staff recommends Alternative No.1, as this proposal would be cost effective in moving
the City of Shakopee Public Works Department ahead in the area of GIS! AMS for the
various areas, as listed in the proposal. Funds are available in the Engineering
Division budget as well as the Sanitary and Stonn Drainage Utility budgets for this work.
ACTION REQUESTED:
Approve a motion to execute an extension agreement with WSB & Associates, Inc. for
consultant services on implementing a GIS/ AMS for the City of Shakopee Public Works
Department, as per the attached proposal.
~~j
Public Works Department
BUpmp
ENGRlEFIPPENNINGTON/COUNCIUGIS-AMS
~
WSB
& Associates, Inc. Infrastructure I Engineering I Planning I Construction 701 Xenia Avenue South
Suite 300
Minneapolis, MN 55416
Tel: 763-541-4800
Fax: 763-541-1700
May 18, 2006
Mr. Bruce Loney
Public Works Director
City of Shakopee
129 Holmes Street South
Shakopee, MN 55379-1328
Re: Proposal to Implement a GIS!AMS for the City of Shakopee
Dear Mr. Loney:
I am pleased to submit this proposal on behalf of WSB & Associates, Inc. to implement a
Geographic Information System (GIS) and Asset Management System (AMS) for the City of
Shakopee Public Works Department. I have successfully helped several cities develop GIS! AMS
solutions and am enthusiastic about the opportunity to help Shakopee do the same. When this
project is completed the City of Shakopee will have made considerable progress in the following
areas:
. GIS Coordination - City staffwill be trained in the use of GIS software and the City's
GIS will be developed with the goal of integration with the AMS in mind.
. Park Maintenance Asset Management System - All City Parks and athletic fields will
be mapped and an AMS will be in place to be used to budget maintenance and track
inspections of playground equipment.
. Street Sign Asset Management System - Ongoing efforts tracking sign installation will
be directed with the long term asset management goals in mind.
. Sanitary and Storm Sewer GIS- The existing CAD based sanitary and storm sewer maps
will be converted to GIS format. Existing records regarding sewer blockages will be
integrated with this data.
. Sanitary and Storm Sewer AMS - A strategy to collect essential information and develop
a st0TI11 and sanitary sewer asset management system will be in place.
Please review the attached proposal and feel free to choose which items you would like pursue at
this time. If the City has staff available to perform any of the above tasks, we are prepared to
train and work with them in the completion of these tasks. If you have any questions, please
contact me at (763)287-7194.
Sincerely,
W B & Associates, Inc.
.~~
olm ackiewicz
GIS Consultant/Coordinator
Minneapolis I St Cloud
Equal Opportunity Employer
, PROJECT UNDERSTANDING
The City of Shakopee has requested a proposal to develop a Geographic Information
System (GIS) and Asset Management System (AMS) that will help the Public Works
and Engineering Department manage their assets more efficiently. It is our
understanding tbat The City of Shakopee would like to utilize the GIS/ AMS to better
manage:
. Storm Sewers
. Sanitary Sewers
. Parks & Playgrounds
. Trees
. Signs
. Turf
. Building Maintenance
. Pavement
The City has already invested human and capital resources in ICON pavement,
sanitary sewer, and sign management modules and would like to leverage this
investment as much as possible. It has been WSB's experience that AMS should be
incrementally implemented. Implementations should start small and will be built on
over time. Implementing all modules of an AMS at once can be cost prohibitive and
difficult to achieve. Considering this, the City's GISI AMS needs has been divided
into the following areas:
. Pavement Management
. Signs
. Park Maintenance
. Storm and Sanitary Sewer
Pavement Management The City already has a functioning Pavement Management System. Output from
ICON's Pavement Management module can easily be linked tD the GIS base map for
display and analysis.
Signs/Streets As signs are added, sign information is being entered into ICON's sign management
module. At this time, it is c1earthat ICON's program will not be able to meet the
reporting requirements of the City in the future without customization by ICON.
The extent of the customization and the costs associated with it are unknown at this
time. The City is currently considering Sign Tracker, which will meet these
requirements and provide integration with SignCAD. An examination of the future
reporting and GIS integration needs of the City including software costs and benefits
needs to be completed before. proceeding. City Staff have identified that these
reporting requirements do not need to be met for three to five years. Fortunately, if
the cost associated with customizing ICON is prohibitive, the information that is
cun'ently being stored in ICON will be portable to SignTracker or Sign View.
In addition to the Signs, the following general mapping requirements need to be
addressed.
. Snow Hauling
. Street Striping
. Handicap Parking Locations
...
WSB
& Associates, Inc. 1 PROPOSAL TO DEVELOP GIS AND AMS
CITY OF SHAKOPEE
PROJECT UNDERSTANDING
Park Maintenance There is immediate need for the development of a GIS! AMS for Park Maintenance.
The top priority is developing a GIS Map of cover types for parks and other areas,
such as athletic fields, managed by Park Maintenance. In addition to this, Park
Maintenance is seeking to purchase asset management software that will be used to
set budgets and track inspections of playground equipment. In the future, the Park
Maintenance component of the AMS will be expanded to include an inventory of
trees, parks, public grounds, and annual trails inspections.
Sanitary and Storm Sewer The City of Shakopee currently has an AutoCAD based Sanitary Sewer Map that is
relatively up-to-date, including unique ID's and links to scanned as-built documents.
The CAD map needs to be converted to GIS and linked to the database of sewer
blockages that currently exists in Microsoft Excel. In addition to sewer blockages,
City staff would like to incorporate the following into the GIS/AMS:
. Root Cutting
. Root Foaming
. Manhole Maintenance Records
. Televising
The AutoCAD based Storm Sewer Map does not contain unique ID's or links to
scanned as-builts. There is not an existing database that is tied to the stonn base
map. City staff would like to see the following activities tied to the GIS/ AMS.
. Pond Cleaning
. Pipe Maintenance
. Inspection
In addition to the information summarized above, there are general mapping
requirements.
The City currently owns the Sewer module for ICON. Like the Sign module,
customization by ICON staff will be required for ICON Sewer to provide the City
the long term functionality required by users.
SUMMARY Because of the different needs and implementation timelines for pavement, street
signs, park maintenance, storm sewer, and sanitary sewer, it is important to address
them individually. The requirements listed for the asset management system are not
an exhaustive list, as much more information has been collected from City staff that
will be included in the final system design.
..
WSB
& Associates. Inc. 2 PROPOSAL TO DEVELOP GIS AND AMS
CITY OF SHAKOPEE
'; WORK PLAN
DETAILED SCOPE OF WORK Based on discussions with the City Staff and our understanding of the City's needs,
we have developed a scope of work to complete the implementation of a GIS lAMS
for the City of Shakopee. The following detailed work plan is divided into a series
of tasks and sub tasks with deliverables and summarized by task. The costs to
complete these tasks are include in the Project Budget section of this proposal
TASK! Coordinating the development of the City of Shakopee GISI AMS consists of project
GIS! AMS COORDINATION management, providing on-site support, and overall system design. The following
subtasks will be included as part of the task.
1.1 Project Management At the onset of the project, a meeting will be held with City staff to review the work
plan and project schedule. Future progress update meetings will also be scheduled
with the staff at this time. It is anticipated that a total of five meetings with staff will
be held throughout the project.
1.2 Dedicated On-Site Support WSB has found that dedicated on-site support is essential in the successful
development of a GIS! AMS. Being on site gives staff greater access to the GIS
Coordinator and allows the GIS Coordinator to be more responsive to staff needs.
This time will be spent setting up and training staff in the use of the GIS! AMS and
will aide the GIS Coordinator in completing the other tasks required to deploy the
GIS/AMS. It is proposed that John Mackiewicz be on site at the City Public Works
building for approximately six to eight hours every Tuesday, with approximately
four hours of this time being spent in a support capacity. The rest of his time at the
Public Works building will be spent working on individual tasks identified in this
proposal.
1.3 System Design Because the interaction between GIS and other computer software such as an AMS
can be a complex environment, it is important to have a clear defmition of the
application and data requirements before implementing a GIS. Understanding the
available technology will be critical when finishing the system architecture design
and developing the detailed implementation plan in the early phases of the project.
1.3.1 GIS/AMS Needs Assessment - The detailed user needs assessment that has
already begun needs to be completed to develop an implementation strategy
for supporting user needs. This task has already been started but more
detailed workflow analysis needs to be completed to fmalize application
requirements.
1.3.2 System Architecture Design - The final system architecture will be defined in
the early stages of the project. Based on the requirements that have been
gathered from City staff tpe following software and hardware platforms will
be analyzed to determine the final system architecture that will be used for
the City's GIS! AMS.
1.3.2.1 Street Sign Software - Costlbenefit analysis of using ICON's Sign
Module vs. SignTracker or the Carte graph SignView module. The
City already owns ICON software but there will be a cost
associated with modifying the package so that the functionality
required by city staff is achieved. This task will consist of
generating final reporting requirements and analyzing the cost of
. meeting these requirements with each of the three software
WSB packages.
& Associates. Inc. 3 PROPOSAL TO DEVELOP GIS AND AMS
CITY OF SHAKO PEE
"" WORKPLAN
1.3.2.2 Sewer Software - Cost/benefit analysis of using ICON's Sewer
Module, the Cartegraph module, or proceeding using only GIS for
the time being. This task will consist of generating final reporting
requirements and analyzing the cost of meeting these requirements
with each of the three software packages.
1.3.2.3 Parks AMS - It is recommended that Cartegraph's Park template
be used for the Parks AMS.
1.3.2.4 ArcGIS - Existing and future Desktop GIS Software needs will be
determined. It is expected that the early implementation will
consist largely of free viewers for most staff.
1.3.2.5 Handheld GPS - Existing and future GPS hardware and software
needs will be examined.
1.3.2.6 Mobile GISIAMS -Workgroup needs for mobile GIS/AMS
applications will be reviewed.
1.3.2.7 Network Analysis - fuformation regarding the City's existing and
future network infrastructure will be analyzed to determine the
ideal system architecture. This task includes testing the network
environment for compatibility with remote desktop applications
that may be used for the wireless collection of field data.
Deliverables:
. GIS Needs Assessment
. Proven System Design Experience
. Detailed Implementation Plan arid Schedule
. Desktop GIS for All Users
. Training for All Users
TASK 2 Although final system specifications are not developed, there are a number of data
SYSTEM DEVELOPMENT development and data conversion activities that must take place to migrate existing
data sources to formats compatible with GIS/AMS. This includes:
2.1.1 Develop Base Maps - Snow hauling, street striping, and handicap parking
maps will be developed.
2.1.2 Parks Maintenance Asset Management System - The GIS Map of cover
types for parks and athletic fields will be developed. At the same time an
AMS will be deployed that meets the budgeting and data acquisition
requirements of staff. This subtask will include:
2.1.2.1 Installing the AMS
2.1.2.2 Customizing the software
2.1.2.3 Training in the use of the AMS
2.1.2.4 Setting up customized forms
2.1.2.5 Setting up units for field data acquisition (if applicable)
2.1.3 Street Sign Asset Management System - The development of the Street Sign
AMS will continue taking into account the software and requirements that
are identified in task 1.3.2.1.
~ 2.1.4 Storm and Sanitary Conversion - The existing Storm Sewer and Sanitary
WSB
& As:;oclmes, Inc. 4 PROPOSAL TO DEVELOP GIS AND l\MS '
CITY OF SHAKOPEE
(,. WORK PLAN
Sewer maps will be converted to GIS. The GIS databases will then be
developed so they are ready for integration with an AMS. This will include:
2.1.4.1 Sanitary Sewer
. Transferring any hotlinks that already exist
. Adding line directionality at the database level
. Adding manhole connectivity at the database level
. Adding manhole ill's at the database level
. Identifying areas that need to be updated
2.1.4.2 Storm Sewer
. Adding line directionality at the database level
. Adding manhole connectivity at the database level
. Adding manhole ill's at the database level
. Identifying areas that need to be updated
2.1.5 Storm and Sanitary Sewer AMS - After reviewing the costslbenefits
associated with implementing ICON's Sewer software, a plan will be
developed to either migrate the existing data to ICON or to utilize the
capabilities of GIS as an AMS. Regardless of the platform this task will
consist of:
2.1.5.1 Preparing the existing sewer blockage records for integration
2.1.5.2 Database design
2.1.5.3 Identifying areas that need to be updated
DeIiverables:
. Snow hauling, street striping, and handicap parking maps
. Park Cover Type GIS Mapping
. Park Maintenance AMS
. Sanitary and Storm Sewer GIS Mapping
. Utility Map Books
...
WSB
5 PROPOSAL TO DEVELOP GIS AND AMS
& Associates, fnc. CI1Y OF SHAKO PEE
, RELEVANT EXPERIENCE
WSB has broad experience with many other projects similar to this project for the
City of Shakopee. Below are listed a few examples of pertinent experience.
ROSEMOUNT GIS The City of Rosemount intended to update their existing CAD and GIS data sources
IMPLEMENTATION into more current software. They retained WSB to convert all existing files to a
format ready to be integrated with ICON and Carte graph Asset Management
Software. This included the design of the GIS/ AMS architecture, the development
of the system including all utility data, development of the final implementation
plan, and incorporating existing records from Public Works staff into the system.
MINNETRISTA GIS WSB is currently in the process of implementing an Enterprise GIS for the City of
IMPLEMENTATION Minnetrista. This GIS will be based on high accuracy survey data. The
implementation includes creating utility base mapping that is ready for integration
into Asset Management Software, field deployment, and access at multiple locations.
EASEMENT MAPPING, WSB staff is currently researching, mapping, and linking scanned easement
GOLDEN VALLEY, MN documents to the base map for the City of Golden Valley. The City had stored this
easement information in three separate locations within the City, which made it time
consuming and troublesome to access the information.
Easement mapping provides City staff with a single location where they can quickly
access all of its easement information and overlay it with other GIS and CAD data
sets as well as modernizing the update process. All documents on file at the County
Recorder office that identify a City interest (i.e. permanent easements, maintenance
agreements, vacations, etc.) are scanned, mapped, and linked to the City's GIS
system. This benefits City staff using easement data for R-O-W, permitting, plan
review, and improves overall customer service.
MONTICELLO PAVEMENT WSB prepared a feasibility report addressing rehabilitation and reconstruction of
MANAGEMENT existing City streets and utilities. This is a multi-year program and we have
completed three successful projects totaling $4.5 million in project costs. The
reconstruction consists of pavement reclamation, curb, and utility repair.
ROSEMOUNT PAVEMENT WSB imported existing GIS information into ICON and completed PCI ratings for
MANAGEMENT the City of Rosemount. This information was linked to the GIS and is currently
being used to prioritize streets for repaving.
ASSET MANAGEMENT
WSB has extensive experience in asset management, including street, sewer, tree,
park, and trail asset management. Projects have been undertaken for the Cities of
Sunfish Lake, Lonsdale, Victoria, Andover, Crystal, Lino Lakes, and mver Grove
Heights.
A
WSB
& Associates, Inc. 6 PROPOSAL TO DEVELOP GIS AND AMS
CITY OF SHAKO PEE
" PROJECT TEAM
We propose a team who has the focus and experience to develop the GIS and AMS
that the City of Shakopee requires. This team is prepared to bring the City a project
that is accurate, on time, and meets the needs the City has expressed to us. These
capsule descriptions introduce you to our team. Full resumes have been included
with the proposal, for your further information.
John Mackiewicz Mr. Mackiewicz will lead our project team. He will be the main contact for the City
GIS Coordinator and will be responsible for making sure the project is meeting its schedule and
budget goals. In addition, he will take an active part in the development of the GIS
and AMS. Mr. Mackiewicz's extensive Geographic Information Systems (GIS)
experience includes using ArcINFO and Arc View for hydrologic modeling, high
quality cartographic mapping, aerial photography interpretation, remote sensing,
regional planning, and integrating GIS with Asset Management systems. Mr.
Mackiewicz has extensive experience in the full suite of Arc products including
ArcINFO, ArcS DE, ArcPlot, ArcEdit, Arc Grid, ArcScan, 3D Analyst, Spatial
Analyst, and Image Analyst. Mr. Mackiewicz is experienced in custom application
development using Visual Basic and has conducted GIS training sessions for state
agencies, municipalities and private industry.
Bryan Pittman Mr. Pittman will assist Mr. Mackiewicz in the development of the GIS and AMS.
GIS Specialist He has five years of experience in the Geographic Information Systems field, using
ArcGIS, ArcInfo Workstation, ArcView, ArcIMS, and ArcSDE. His experience,
working with various cities, includes base mapping, geodatabase updates,
preparation for digitizing data, and creating GIS databases. He is also skilled in the
use of AutoCAD, Idrisi, Erdas Imagine, Trimble GPS, and Pathfinder.
Mike MaIszycki Mr. Malszycki will support the project in the area of asset management. He has 25
Asset Management years of experience in inspection services, drafting, and surveying. He has provided
field observation, field computations, record keeping, and construction staking for a
variety of projects. Mr. Malszycki is also knowledgeable in the use of ArcView,
AutoCAD, and Asset Management software. Mr. Malszycki is MnlDOT Certified in
five areas for Levels I and II.
~
WSB
& A.ssociates, inc. 7 PROPOSAL TO DEVELOP GIS AND AMS "',
CITY OF SHAKOPEE
PROJECT COSTS
WSB & Associates, Inc. will complete the basic scope of services outlined in this proposal for each project. Billing will
occur on a monthly basis based on our hourly rate schedule.
Task 1: GIS/AMS Coordination
Project Management 25 $89 $2,225
On Site Support 116 $89 $10,324
S stem Desi n 44 $89 $3,916
Subtotal 185 $16,465
Task 2: System Development
Develop Base Maps 16 $64 $1,024
Parks Maintenance AMS 70 $89 $6,230
Park Maps 24 $64 $1,536
Street Sign AMS 10 $89 $890
Sanitary Sewer Conversion 40 $64 $2,560
Add Connectivity To Sanitary Sewer 40 $64 $2,560
Storm Sewer Conversion 50 $64 $3,200
Add Connectivity To Storm Sewer 40 $64 $2,560
Storm and Sanitary Sewer AMS 40 $89 $3,560
Subtotal 330 $24,120
Total 515 $40,585
...
WSB
de Associates. Illc. 8 PROPOSAL TO DEVELOP GIS'AND AMS .
CITY OF SHAKO PEE
Bryan Pittman ~
GIS Specialist WSB
& A.ssociates. Inc.
Education: Experience:
Master of Geographic Mr. Pittman has five years of experience in the Geographic Information Systems field,
Information Systems using ArcGIS, Arclnfo Workstation, ArcView, ArcIMS, and ArcSDE. His experience,
University of Minnesota working with various cities, includes base mapping, geodatabase updates, preparation
for digitizing data, and creating GIS databases. He is also skilled in the use of
Bachelor of Science in AutoCAD, Idrisi, Erdas Imagine, Trimble GPS, and Pathfinder.
Environmental Science
Minor: Geography Selected Project Experience:
University of Delaware Establishe,d city GIS for the City of Golden Valley, including digital format
.
~"'""~"""''''"",,,;''1~!riEtm:mi~~... layers including lakes, buildings, parks, multi-unit parcels, and
miscellaneous utility structures
. Created digital access to water tie cards and quarter section map books
to enable easy access for all city departments
. Completed a historical wetlands study in the Lake Elmo area that found
an increase in wetland area from the 1950s to the present day
. Assisted in conversion of utility systems from AutoCAD to GIS for the City
of Eagan, including AutoCAD edits, transformation of CAD drawings, and
data export
. Automated several GIS processes, allowing easier and faster access to
geodatabases, map books, and shapefiles
. Created emergency preparedness application for Chester County, PA,
used to assist in emergencies, including chemical spills, evacuations,
notifying risk locations, transporting special needs population, nuclear
preparedness, and weather related emergencies
. Worked with hydrological modeling at Chester County to simulate
hazardous waste and chemical spills downstream for the emergency
preparedness application.
. Linked census data and voter registration data, using GIS, to aid Voter's
Services in registration analysis
Infrastructure I Engineering. Planning IConstruction
Michael D. Malsyzcki
Construction Services Coordinator W!S
& Associates. Inc.
Education: ; Experience:
St. Paul Technical College ! Mr. Malszycki has 25 years of experience in inspection services, drafting, and
! surveying. He has provided field observation, field computations, record keeping,
Mn/DOT Certifications: ! and construction staking for a variety of projects. Mr. Malszycki is also
Aggregate Production 1 knowledgeable in the use of ArcView, AutoCAD, and Asset Management
Concrete Field I & II \ software. Mr. Malszycki is Mn/DOT Certified in five areas for Levels I and /I.
Grading & Base f & /I i
Bituminous Street I & /I : Selected Project Experience:
Signal & Lighting I & /I !. .,
Er s'on Control Manager i Hennepin County Steam Line, Hennepin County, MN
o I, ! Construction observation on a $4.8 million steam heat, condensation line and
i chilled water line from the Hennepin County Energy Center to the new Hennepin
Associations: i County jail through downtown Minneapolis. Welded steel heat and condensation;
American Public Works : and 24" HDPE chilled water lines. Traffic control and street restoration were
Association i accomplished without major disruption and with compliments of businesses and
"",~'<'-'~<"~<""""l!la. i governments.
f Sanitary Sewer Improvements, Victoria, MN
i Construction observation on new sanitary sewer lines installed in a developed
\ area through street and backyard alignments. Streets were upgraded and yards
1 were restored to the satisfaction of the neighborhood.
: Helen Street Reconstruction, North St. Paul, MN
: Engineering design, construction documents, construction observation, and
! specifications for storm water, sanitary sewer, watermain, and street
I improvements.
i County Road 2 Signal and Traffic Improvements, Forest Lake, MN
j Construction observation for street improvements and signal project on County
, Road 2 in Forest Lake, MN.
i TH 52/111h Street Improvements, Rosemount and Inver Grove Heights, MN
Construction observation for highway and bridge improvements.
Lamplighter Pond Improvements - St. Louis Park, MN
TH 55/Lexington/Blue Gentian Road Improvements - Eagan, MN
Asset Management
Planning, training, and data collection for the following cities:
. Victoria . Lino Lakes
. Andover . Watertown
. Prior Lake . Sunfish Lake
, . Crystal . Lonsdale
Cartegraph Experience
. Andover - entire city street rating and staff training
. Victoria - city street rating
. Lino Lakes - city street rating
. Crystal - 80% of city street rating
. Sunfish Lake
. Lonsdale
. Redwing - city staff training
. Inver Grove Heights - trees, parks, trails
Infrastructure. Engineering. Planning .Construction
John Mackiewicz ~
Page 2 of 2 WSB
& Associates. Inc.
Cartographic Mapping - Mr. Mackiewicz has produced high quality cartographic
maps for a variety of purposes including regional planning, transportation engineering,
floodplain revisions, and water resource engineering. He has also worked with WSB's
Aviation Group to provide GIS base mapping support for the Fillmore County and Ely
Airports.
Monticello GIS - Mr. Mackiewicz has been involved in the development of base
mapping, pavement management, and GIS for the City of Monticello. This has
included extensive work developing methods to update base maps using high
accuracy survey.
Wetland Management - Mr. Mackiewicz has designed and developed
GIS- based wetland databases for multiple clients. This includes databases
containing spatial and attribute information regarding wetland quality, management
classification, and location for wetland management plans. Mr. Mackiewicz has also
designed GIS databases to track wetland impact as development occurs and has
extensive experience providing GIS support for wetland mitigation in numerous
counties in Minnesota.
Wetland and Floodplain Analysis/Mitigation, Golden Valley, MN - Mr. Mackiewicz
used GIS, CAD, HEC-RAS, and HydroCAD to design a dike system intended to
reduce flooding in the vicinity of the TH 55 and Boone Ave. intersection. As part ofthe
design, adjacent areas were evaluated for potential as floodplain and wetland
mitigation sites using soil, topography, and wetland data.
Comprehensive Storm Water Management Plans - Mr. Mackiewiczhas used GIS
as a pre-processor for hydrologic variables to be imported into HydroCAD during the
preparation of multiple comprehensive storm water management plans. This included
developing geodatabases containing key hydrologic variables, then linking the
geodatabase to output from the HydroCAD model, as-built information, and
photographs. This format gives novice users the ability to access hydrologic
information through an intuitive GIS interface.
Mississippi Valley Natural Wildlife Refuge - Mr. Mackiewicz used ArcView and
ArclNFO to evaluate parcels for potential refuge expansion. A natural resource
inventory was conducted by means Df site investigation, aerial photograph
interpretation, and review of land use, natural heritage, soil, topographic, land
stewardship, and parcel maps. This inventory was used to rank parcels for acquisition
as part of the potential refuge expansion.
Canisteo Mine Hydrology Study GIS, Grand Rapids, MN - Mr. Mackiewicz
completed all of the GIS data collection, creation, analysis, and distribution for the
Canisteo Mine Hydrology Study. In addition to creating base layers, Digital
Orthophoto Quadrangle (DOQ), Digital Elevation Model (OEM), AutoCAD, TechBase,
ArcINFO, and Access databases were combined into a single system. ArcView was
used to prepare watershed characteristics and evaluate numerous outlet channel
alternatives. Mr. Mackiewicz distributed this data to diverse sources such as the
United States Geological Survey, Army Corps of Engineers, and the Iron Range
Resource & Rehabilitation Board.
Watershed Modeling, Eagan, MN - Mr. Mackiewicz prepared watershed runoff
calculations based on land use and soil types for watershed modeling (HydroCAD and
XP-SWMM) for the Review of the City of Eagan's Comprehensive Storm Water
Management Plan.
Infrastructure I Engineering I Planning I Construction ~.. ~i~}
"'.. ~;:':~
John Mackiewicz ~
GIS Coordinator WSB
& ll.'!Soclates. Inc.
Education: Experience:
Master of Geographic Mr. Mackiewicz's extensive Geographic Information Systems (GIS) experience
Information Science includes using ArclNFO and ArcView for hydrologic modeling, high quality
University of Minnesota cartographic mapping, aerial photography interpretation, remote sensing, and regional
planning. Mr. Mackiewicz has extensive experience in the full suite of Arc products
Bachelor of Science in including ArcINFO, ArcSDE, ArcPlot, ArcEdit, ArcGrid, ArcScan, 3D Analyst, Spatial
Natural Resources and Analyst, and Image Analyst. Mr. Mackiewicz is experienced in custom application
Environmental Studies, development using Visual Basic and has conducted GIS training sessions for state
Emphasis in Hydrology and agencies, municipalities and private industry.
. GIS
University of Minnesota Selected Project Experience:
"'ti,!;,'f"'''''.ou, ""="""_._d'.{li:l~L'~<".'..-,....",,..,, """,-,,, ..~ .~ ,.."'~.^"_l , "....... ;' "..~ Rosemount GIS Implementation - Mr. Mackiewicz was instrumental in
converting existing CAD and GIS data sources to a format ready to be
integrated with ICON and Cartegraph Asset Management Software. This
included the design of the GIS/AMS architecture, the development of the system
including all utility data, development of the final implementation plan, and
incorporating existing records from Public Works staff into the system.
Minnetrista GIS Implementation - Mr. Mackiewicz is currently working on
, implementing an Enterprise GIS for the City of Minnetrista that is based on high
accuracy survey data. This implementation includes creating utility base
mapping that is ready for integration into Asset Management Software, field
deployment, and access at multiple locations.
Training - Mr. Mackiewicz has held training sessions for groups including the
Minnesota Department of Natural Resources Mine Land Reclamation Unit and the
City of Shorewood, as well as conducting all of our internal training at WSB.
GIS Consulting - Mr. Mackiewicz has provided consulting in a wide variety of areas
including natural resource planning, transportation, water resource, mining, and
aviation engineering.
Base Map Development - Mr. Mackiewicz has been instrumental in generating and
updating base mapping in numerous cities including Shorewood, Excelsior, Circle
Pines, Mahtomedi, and Rosemount, MN.
Geodatabase Development - Mr. Mackiewicz has had extensive experience
designing and working with ESRI's geodatabase model in hydrologic modeling and
utility management. This allows integration of existing databases into ArcG1S and third
party software suites such as XP-SWMM.
Enterprise GIS Design - Mr. Mackiewicz developed and manages WSB's internal
GIS and has assisted multiple cities in requirement gathering, architecture design,
database design, system implementation, and maintenance of their GIS.
Easement Mapping, Golden Valley, MN - Mr. Mackiewicz assisted in researching,
mapping, and linking scanned easement documents to the base map for the City of
Golden Valley. This provides 9ity staff with a single location where they can quickly
access all easement information and overlay it with other GIS and CAD data sets, as
well as modernizing the update process.
Mahtomedi GIS Development - Mr. Mackiewicz has been involved in the
migration of the City of Mahtomedi's utility mapping from CAD systems to GIS.
Infrastructure a Engineering a Planning I Construction ,',
Schedule - Shakopee GIS/AMS Implementation
10 0 Task Name Rnish Ju116, '06 Aug6,'06 Oc18,'06 Oc129,'05 Nov 19,'05 Dee 10,'06 Dec 31,'06 Jan 21,'07
--:-r:--' :::I::c:::';::~::-'-----------i Tue 7125'06 T::;::: ~~;7/:~;<i:' ,j!"",,?,';' T';F' ;';",""\"n"",;,[.,i,}""!,, . ;;~'" ;'''~~''~ ';" ''',':::':::,'::: \:",;~Hi';!'!Ei'" Pi'l; ,"'",'" ",,:,,::,,', ';';~'::.:,:;"nl'i' "';:;....::."t~,~";~'::"" ':~,,':i:;:'''::Hm:'; ":L;;;::m,, i:T':~",'1
_:"' ''':.::..._~ ::::i:::;: :'M"'~""""" .{ ? I I
5 System Architecture Design Man 8/28/06 Fri 9/8/06 I 1"'- 1 ~
6 13" '.. sign Tracker Man 8126106 ---'Thu'iliiiOri I i n::::mn,Hil :
7 Sew"rSonware Man 5128106 ".... l'ii'ji'ili7iiiii i : I'......':;;:':'d i i
1 ,
8 13 Part< Mainlenance AMS Man 8128/06 : Thu 9nJU5 I l~""~>;' I I
9 'ma ..... ......_'m.'ArcGiS ..,.--,.. ,.,.... ......,.... '....-...,... '. ....... ,..'... "'''''''Mon 5125/oii:-Thu-ai31io'5 ~ i
10 13' Handheld GPS .... MOn'SI26106: ,..,.. Tiluiliiiiiii 1"':'/';:/ I
11 13 MobUe GISJAMS Man 8125'06, "Fri'iiiiiiii'il 1:::""',,',:,':,','1 I
12 13 Nelwort< Analysis ' ,.... Man 8/26106 ,.... ....i'ri'iiiiiiiiii' I \',D:'"",,':I I
13 ~ "r'''Sl'siemArChUeciure'RevieW Meeiing . , "I" ... Tue 9/12/06 \ ..mrueili12iiiii i
. . .
14 j System Development ! Tue 9/12106 j Tue 2/6101 !
1 j .
15 {3 Street Sign Asse\ Management Development 1 Tue 9/12106 . "Tue '2ISiii7 I __
-::-: ::=:.. ! ==;:;: "iC~' l~
--lii.... Park Maps Thu 10/5106' 'Wedhi1i06 i I
19 Park Maintenance Asset Management System Thu 1112106: '-wecf1124i07 i '
.n.... ...! I
20 13 Projecl Updale MeaUng Tue 10117JU6 Tue 10117106 i. 10/17 i
'-21~ Sanitary Sewer Conversion Fri 1211106: Thu 1212810'6
22 t3 Convart CAD to GIS . Frl i2l1JU6 ,"iliJJ'i2il;Jiiiii' I
--, i
23 13 Add Line Conneclivity Frt 12115106 i Thu 12/28/05 ,g,; i
24 . . . '.. Convert Storm Sewer to GIS Fri 121Z9l06; -'.'Ti\-u-:i/"ZS;01 .
25 .......'ciiiiveifcAtiiOGis'.m..f.. F~ 12/29/06 ~,un;u'iJi1iiii
_.._.. ............ m.. ......... .... ............ ............... ............._...... ......... ............ ... ... """""". ..... ......_.....................
26 .. Add Une Connectivity I Fri 1/12/071 TIm 1/25/07
~7 Stann and Sanitary Sewer Asset Management Syslem 1 TUB 9/12/06 ~ Thu 11/30106
i :
28 G3! Project Wrap Up Meellng ! Tue 216107 :. ....Tu.2i6iO'f
Project: Tlmellna Task Ii: "'i''''!'':;::'F'',,') "~J Progress Summary "" ..... External Tasks I :'t'''/F},:~,;X' "Y'I
Dale: Wed 7/12/06 Split Ulllllu"""U""'I""I11"Ul" Milestone. Project Sumnuuy ..... ". External MUestone .
Page 1