HomeMy WebLinkAboutRESPONSE - RFP - P916 GIS RELATED APPLICATION DEVELOPMENTrw+
Yr..
Response to Request for Proposal
GIS-Related Application Development
Proposal # P-916
� P
R �
pr
�,11Pa Er'7 ffi. V 114 E it. C 0
S t 1, 1P1 VGi'VE£d9-i'AI G.
Provided by. -
Miner & Miner, Consulting Engineers, Inc,
4701 Royal Vista Circle
Fort Collins, CO 80528
Phone; 970-223-1888
Fax: 970-223-5577
http;//www.miner. com
November 26, 2003
Jeff B. Meyers, Strategic Account Manager
Phone; (970) 223-1888 Extension 251
Email. jeff.b.meyers@miner.com
El
Miner & Miner in a unique position to assist the City in the implementation of their GIS
system.
Project Team Resumes
The following are resumes of Miner & Miner employees proposed for the project. If, due
to unforeseen circumstances, the employees listed cannot be available for this project,
Miner & Miner will assign equally qualified personnel. Miner & Miner resumes are
included in Appendix A.
Section 5 — Proposed Services and Pricing
Please see Appendix C, City of Fort Collins Scope of Work and Project Plan for detailed
descriptions of proposed services and associated pricing.
Section 6 — Terms & Conditions
City of Fort Collins Proposal Number P916
Exceptions for Professional Services Agreement Terms and Conditions
Article 6, Both Versions
Please delete the following sentence: "Upon final payment, all designs, plans, reports,
specifications, drawings and other services rendered by the Professional shall become the
sole property of the City."
Please add an article 18. Intellectual Property Rights, containing the following:
a. Each party reserves the right to use, for any purpose, any programming tools, skills,
and techniques previously acquired, developed or used in the performance of the services
described herein. Nothing in this Agreement shall be construed as restraining either
party, their employees, or agents in the use of the techniques and skills of computer
programming and design which may be utilized or acquired in the course of performance
of this Agreement.
b. Professional grants to the City, subject to the terms of this Agreement, a personal,
nontransferable, nonexclusive license to use and copy the Deliverables solely for the
City's internal business purposes. The City shall include Professional's copyright notice
-7-
and any other legend of ownership on all copies of the Deliverables as such notice
appears on the originals. The Services and Deliverables delivered hereunder are not
"work for hire" and Professional owns of all right, title, and interest to such Services and
Deliverables. The ownership of all data supplied to the Professional by the City will
remain with the City.
c. The City shall not make, sell, translate, export, license, sublicense, localize, use with
any time-sharing or for service bureau arrangements, or transmit to any person outside of
Professional's internal business organization the Deliverables.
d. The City shall not reverse engineer, decompile, disassemble or apply any process,
technique, or procedure or make any attempt to ascertain or derive the source code of the
Deliverables.
e. Any patentable or unpatentable discoveries, ideas, including methods, techniques,
know-how, concepts, or products ("Invention"); or any works fixed in any medium of
expression, including copyright and mask work rights ("Works of Authorship"); or any
other intellectual property created by Professional during the course of the Services and
provision of Deliverables shall be the sole and exclusive property of Professional.
f. Except as set forth in Section a. above, no direct or indirect ownership interest or
license rights in Inventions, Works of Authorship or other intellectual property including
software or patents are granted or created by implication in this Agreement.
g. Professional may perform the same or similar Services for others, including providing
the same or similar conclusions and recommendations, provided that the City's
Confidential Information is not disclosed.
M
Appendix A - Miner & Miner Resumes
Richard G. Arata
Director of Project Management
Mr. Arata joined Miner & Miner in March 1993 as an Application
Analyst. His responsibilities have included project planning,
requirements analysis, object modeling, and project management for
major AM/FM implementations. In addition, he managed design,
development, implementation, and integration of application software.
Mr. Arata has served as Project Manager for several large projects,
including implementation and deployment of integrated, enterprise -
wide solutions. Mr. Arata currently serves as Director of Project
Management for Miner & Miner.
Prior to joining Miner & Miner, Mr. Arata served in the U. S. Air
Force as a Project Officer, managing weapon system development,
testing, and deployment. He accomplished program planning for the
Advanced Tactical Fighter development program, established GIS
capability for Utah Test and Training Range, and managed the
improvements of ground station software for the Defense Support
Program, a space -based early warning system.
Experience Project Manager — Xcel Energy, Minneapolis, Minnesota. Project
initiation, requirements assessment, and object modeling for Miner &
Miner component of migration to ArcFM 8.0. Provided object
modeling and consulting, schema generation, system configuration,
and implementation consulting.
Project Manager — Consumers Energy, Lansing, Michigan.
Project initiation, requirements assessment, and object modeling for
Miner & Miner component of migration to ArcFM 8.0. Provided
object modeling and consulting, schema generation, system
configuration, implementation consulting, and development of custom
ArcFM extensions.
Project Manager — City of Anaheim, California. Project initiation,
requirements assessment, and object modeling for Miner & Miner
component of migration to ArcFM 8.0. Provided object modeling and
consulting, schema generation, system configuration, implementation
consulting, and development of interface to Customer Information
System and implementation of custom Circuit Map Plotting Tool.
Miner & Miner
Richard G. Arata
Object Modeling/Project Consultant. Provided project initiation and
object modeling for ArcFM Energy to AGL Resources (Atlanta,
Georgia), Montana -Dakota Utilities, Arizona Public Service, Lincoln
Electric System (Nebraska), and Rochester Public Utilities
(Minnesota). Also provided training in object modeling and utility
data issues to various clients.
Project Manager — New York State Electric and Gas, Binghamton,
New York. Project initiation, requirements assessment, and database
design for ARC/INFO Rev 7.0 applications. Managed transition from
Rev 6.0 to Rev 7.0 applications, associated data conversion, and
implementation of editing, mapping, and analysis applications. Also
co -managed development of Responder, a trouble call (outage)
management system co -developed with NYSEG. Managed overall
project scope, cost, and schedule.
Project Manager — Pennsylvania Power & Light, Allentown,
Pennsylvania. Project initiation, requirements assessment, and
database design for ARC/INFO Rev 7.0 applications. Participated in
software demonstration lab and work process analysis. Managed
development, integration, and implementation of applications
including Job Planning/Design Environment. Managed overall project
scope, cost, and schedule. Provided consulting and application tools
for conversion process.
Project Manager — Arizona Public Service Company, Phoenix,
Arizona. Project initiation, requirements assessment, process analysis,
and database design for set of ARC/RNFO Rev 7.0 applications.
Managed scope, cost, and schedule for application development,
installation, and follow-up support. Directed development of
documentation and provided user training. Directed APS migration to
ArcFM 7.2 and SDE and provided planning and consulting for
transition to ArcFM 8.0 and ArcSDE.
Consultant — Energy Company EDON, Zoelle, Netherlands.
Provided on -site database design and ArcFM 7.2 configuration and
consulting support for replacement to existing gas facilities
management system.
Project Manager — Turlock Irrigation District, Turlock,
California. Project initiation, requirements assessment, and
implementation of MM PowerTools and DistOps for NT environment.
Miner & Miner
Richard G. Arata
Application Analyst — Northern States Power Company,
Minneapolis, Minnesota. Assessment and documentation of
functional requirements, database design, system design, test and
acceptance planning, software development and testing, and support of
proposed Northern States Power Corporate Data Model.
Project Manager — City of Greeley Department of Water
Resources, Greeley, Colorado. Project initiation, requirements
assessment, process analysis, and database design for Water Rights
Implementation. Also managed project scope, cost, and schedule.
Product Manager — ArcFM 7.2. Developed Software Requirements
Specification, managed product schedule and component integration,
provided P-party developer and implementation support, co -wrote
documentation, debugged and modified product code in Visual Basic.
Assistant System Administrator. Co -managed Unix network.
Provided day-to-day system administration and user support for
network of Sun, DEC, IBM, HP, and DG workstations, Apple
Macintoshes, and PCs. Performed periodic backups and restorations.
Application Analyst — Miner & Miner AMIFM Software
Development. Developed user documentation and database design
documents for standard Miner & Miner software products. Produced
customized documentation in support of specific project requirements.
Consultant — Ministry of Electricity and Water, Sultanate of
Oman. Analyzed requirements of existing MEW operations and how
these could be supported through the implementation of an
AM/FM/GIS system.
Trainer — Egyptian Electrical Authority. Trained EEA users in the
operation of MM Power Tools applications. Installed and set up
system in support of training.
Education Master of Social Science in Economics
Utah State University, 1988
Bachelor of Arts in Economics
UCLA, 1979
Miner & Miner
Richard G. Arata
Presentations "Migrating the Enterprise to Arc 8," ESRI User Conference, 2001
"Managing the Provider -Customer Model," GITA 2001
"Project Management Planning," Project Management Seminar, GITA
2000
"Migrating Data from ArcInfo 7 into ArcFM 7.2," ESRI Electric and
Gas User Group, 1999
"Modeling Underground Systems," GIS in The Rockies, 1996
"Modeling Underground Systems," ESRI Electric and Gas User
Group, 1995
E2
Miner & Miner
Scott A. Koehler
Project Manager, Applications
Scott Koehler joined Miner & Miner in March 2002 as a Project
Manager. His responsibilities have included proposal writing,
requirements analysis, object modeling, and project management for
AM/FM implementations. In addition, he has managed design,
development, implementation, and integration of application software.
Mr. Koehler has served as Project Manager for large and small
projects, including implementation and deployment of integrated,
enterprise -wide solutions.
Prior to joining Miner & Miner, Mr. Koehler had over ten years of
experience as a project/product manager in multiple technological
industries comprised of power, telecommunications, and controls.
During that period of time he acquired an excellent history of
project/product development from the concept paper and design
proposal stage up through product launch and construction completion.
This experience includes: leading cross -functional teams in delivering
quality products and services on schedule and within budget; managing
product strategy, financial models, pricing structures, and network
forecasts; preparing project status and milestone reports; delivering
presentations and organizing meetings; conducting frequent on -site
customer consultations and managing vendor relations; offering
training seminars; creating design drawings and schematics;
researching contracts and adhering to local, state, and federal
regulations; supervising staff engineers, drafters, and technicians.
Experience
M&M Project Manager — City of Ruston Electric Department, Ruston,
Louisiana. Developed a statement of work to provide consulting
services for the migration of data to ArcFM 8.3 utilizing the ArcFM
MultiSpeak data model. Managing design and development for
implementation services for the migration of GPS collected utility
data.
Project Manager — CoSery Electric Cooperative, Corinth, Texas.
Serving as primary point of contact for the implementation of ArcFM
8.3 utilizing the ArcFM MultiSpeak data model.
Miner & Miner
Scott A. Koehler
Product Manger — MultiSpeak Initiative. Serving as primary Miner
& Miner point of contact for the MultiSpeak initiative regarding both
business and technical issues. Developed the ArcFM MultiSpeak data
model and continuing to function as lead presenter at ArcFM Solution
Seminars for electric co-ops and municipalities.
Project Manager — CNFL, San Jose, Costa Rica. Developed a
statement of work to provide consulting services for the
implementation of ArcFM 8.2. Managed requirements analysis, object
data modeling, schema generation, and general consulting services.
Project Manager — City of Burbank Water and Power, Burbank,
California. Developed a statement of work and finalized contract
negotiations to provide consulting services for the migration of data to
ArcFM 8.2. Managed requirements analysis, object data modeling,
schema generation, data migration, and general consulting services.
Project Manager — Poudre Valley REA, Fort Collins, Colorado.
Drafted proposal for consulting services to assist in 3-year GIS
implementation plan. Managed requirements analysis, object data
modeling, schema generation, data migration, and general consulting
services.
Project Manager — GeoNIS and Viken, Oslo, Norway. Coordinated
development completion of custom interface between ArcFM 8.1.3
and engineering analysis package (CymPSAF). Streamlined
communication process and became subject matter expert for business
partner relationship with GEODATA.
Project Manager — South Carolina Electric and Gas, Columbia,
South Carolina. Managed the implementation of Network Adapter
8.1.3, supplying an interface between ArcFM 8.1.3 SP1 and the
engineering analysis software CYMDIST 3.04E. Finalized contract
negotiations, gathered requirements, and developed design.
Experience
Previous Product Manager, New Product Development — Inflow, Denver,
CO. Product subject matter expert and primary point of contact for
InflowNet, a multi -homed Internet access service, for Internet Data
Center (IDC) business. Drove product revenue over $5M in I" half of
2001which exceeded product revenue for the year 2000 and
represented over 25% of company revenue. Increased customer
Miner & Miner
Scott A. Koehler
penetration from 75% to 90% in 9-month period. Completed
deployment of InflowNet 3.0 ahead of schedule and under budget.
Developed internal and external communication materials including
data sheets, website content, white papers, training videos,
presentations, etc. Responsibility for product development life cycle
covering the following phases: Definition (Concept Paper),
Assessment (Business Case), Development, Verification,
Launch/Deployment, and Maintenance/Management.- Matched
strategic business needs to technical solutions via the nitiation,
prioritization, and on -going development of a set of 10 data
connectivity products. Created product financial model and network
forecasting tool for use in budget analysis (product revenue, CapEx,
network COGS) for 2001. Negotiated an agreement for the return of
over $1.6M worth of equipment as part of the responsibilities for
vendor relations with Cisco Systems.
Product Manager — Jato Communications, Denver, Colorado.
Managed Data Connectivity Services for Dayton Power and Light,
Dayton, Ohio. Managed new products through development cycle:
departmental requirements and impact assessments, implementation,
controlled introduction, product launch, general availability, and life
cycle management. Responsible for 3 product services: DSL layer 2
private network services, T-1 point-to-point access, and Service Level
Agreements for ISP customer segment. Developed the `Individual
Case Basis' process used to review specific Sales' requests for non-
standard services such as non-standard products, network
configurations, pricing, promotions, billing schedules _Acted as
connectivity technical representative for Product Management
department.Provided product training content and presentations to
Sales Engineers. Prepared progress reports and presentations for the
New Product Review Committee as well as weekly status reports for
the Director and VP of Product Management. Created project plans
and milestone reports with the use of MS Project. Coordinated task
force meetings and led cross -functional teams to ensure product
success.
Project Engineer — ADP Marshall, Tucson, Arizona.
Direct project responsibility for conceptual design, electrical systems
requirements (power, telecom, security), equipment specifications, and
construction documents for architectural/engineering firm. Organized
and delivered client presentations and information lectures; prepared
design proposals, budget estimates, and project timelines. Coordinated
design efforts with clients, city officials, and equipment
Miner & Miner
November 26, 2003
City of Fort Collins
Purchasing Division
215 North Mason St., 2nd Floor
Fort Collins, Colorado 80524
Subject: Response to the City of Fort Collins' Request for Proposal for GIS-Related
Application Development (Proposal # P-916)
As a duly authorized representative at Miner & Miner, I am pleased to submit the enclosed
response to City of Fort Collins' Request for Proposal for GIS-Related Application Development.
This offering will remain valid for a period of 90 days following the submission of this response.
Miner & Miner brings unparalleled experience and expertise in the area of GIS planning,
applications development, implementation, and consulting services. We have designed our
solutions with the objective to lower costs, provide better customer service and to facilitate the
distribution of information across the enterprise.
We appreciate the opportunity to participate in this process, and to present our qualifications for
GIS application development services. If you or any of your team members should have any
further questions or need assistance in any way from us, please contact me at (970) 223-1888.
Miner & Miner, Consulting Engineers, Inc.
4701 Royal Vista Circle
Fort Collins, CO 80528
970-223-1888
Scott A. Koehler
representatives. Developed graphically based, object -oriented database
program for semiconductor facility preventative maintenance program.
Proficient with AutoCAD r.14. Supervised and coordinated the work
of designers and drafters.
Power Engineer — America Municipal Power, Columbus, Ohio.
Coordinated transmission of power among various electric utilities and
power groups. Developed and presented demand —side management
strategies to city officials and their industrial customers for the purpose
of municipal community growth. Modified existing SCADA system
and programmed Remote Terminal PC boards.
Electrical Engineering Co-op Student — Dayton Power and Light,
Dayton, Ohio. Planned and coordinated primary service extensions
for a local distribution service center. Performed analyses for three-
phase and capacitor assessments and developed a database of switches
for a storm order restoration program.
Education Bachelor of Science in Electrical Engineering, Ohio University, 1991
Power Systems, Automatic Controls, Power Electronics, Engineering
Economics Business Management, Interpersonal Communications,
Spanish
It]
Miner & Miner
Chris Nightingale
Senior Analyst
Mr. Nightingale joined Miner and Miner in August of 1999 as a
Project Analyst. His responsibilities have included programming
customizations, requirements gathering and analysis, and helping with
object modeling and problem solving for major ArcFM and Designer
implementations. In addition, he has helped develop, implement and
integrate application software with Oracle databases, and assisted the
M&M marketing team with strategic accounts.
Mr. Nightingale has served as Project Analyst for several projects,
including implementation and deployment of integrated, enterprise -
wide solutions. He currently serves as Senior Analyst for Miner and
Miner
Prior to joining Miner & Miner, Mr. Nightingale worked as a GIS
Applications Developer for 3001, Inc. in Gainesville, FL.
Responsibilities there included development of applications for local
and municipal customers using ESRI products such as ArcInfo,
ArcView, and MapObjects, utilizing various programming
environments such as AML, Avenue, Visual Basic, and Unix shell
scripting. In addition, Mr. Nightingale was involved with numerous
data creation/conversion projects as well as application of
orthophotography and GPS.
Experience Senior Analyst — Colorado Springs Utilities, Colorado Springs,
CO. Designed and implemented custom components to integrate the
CSU data model with the M&M Network Adapter product, for
analysis with the Advantica Stoner SynerGEE Electric software.
Senior Analyst — Dominion Resources, Richmond, VA. Co -
designed and implemented custom components to support an
implementation of the M&M Designer product. This implementation
involved integrating the Designer product with the WMIS work
management system from Logica. Support for this project included
development of utilities to import compatible unit information from
WMIS to the Designer geodatabase, as well as creating workflows and
software to import/export facility design data between the two
systems. Custom tools for the ArcMap Designer environment were
also implemented.
Senior Analyst — Keyspan Energy, Long Island, NY. Designed and
implemented custom components to integrate the Keyspan data model
Chris Nightingale
with the M&M Network Adapter product, for analysis with the
Cymdist Distribution Analysis software package
Senior Analyst — Southern Companies. Designed and implemented
custom solutions to support the M&M ArcFM product.
Customizations included business rules and version management
utilities. The components designed for this project needed to be
flexible enough to support differing workflows used by each utility in
the Southern Companies that used ArcFM.
Project Analyst — South Carolina Electric and Gas, Columbia, SC.
Designed and implemented customizations for the M&M ArcFM and
Designer products. Custom business rules, version management and
display utilities were constructed for the ArcFM implementation.
Implementing Designer involved integrating with the CSR work
management system to allow users to access service order information
for facility design within GIS. Assisted with the development of user
workflow for the system, and created COM based components as well
as Oracle stored procedures to support the integration.
Project Analyst — Virginia Power, Richmond, VA. Provided
maintenance services for an existing implementation of the MM
PowerTools and JPDE products. Added new functionality as
requested by the customer and fixed bugs within a UNIX/ArcInfo 7.2
environment.
Education Bachelor of Science in Natural Resources
University of Florida, 1996
Continuing
Education Successful Project Management For IT Professionals, Techlink
Training, 2002
Enterprise DBA Part 1A, Oracle, 2001
Programming ArcGIS, ESRI, 2000
Computer Skills Languages: Visual Basic, AML, Avenue, SQL, Unix Shell Scripting
Operating Systems: Windows, UNIX
Databases: Oracle 8i, Microsoft Access
GIS Software: Arc/Info 7.x, ArcGIS 8.x, Intergraph Geomedia
Other Software: XML, CymDist, Microstation, Citrix
El
Miner & Miner
Appendix B — Project Profiles
Project Profile
M]NEF&4]NER
Colorado Springs Utilities
111. S Cascade, Suite #302
Colorado Springs, CO 80903
http://www.csu.orp/
Randy Scott
Manager of Facility Information
Management Systems (FIMS)
Ph. (719) 668-5767
rscott@csu.org
Founded in 1924 as a community owned and
operated utility, Colorado Springs Utilities
today serves nearly 570,000 retail customers
with electric, gas, water, and wastewater
services. Generating 82% of its own
electricity, its electric distribution service area
encompasses 470 square miles around the
Colorado Springs area and consumes more
than 4 million megawatt hours annually.
During the 1990s, CSU was one of the first
utilities to select ESRI's ArcInfo and deploy it in
a UNIX environment. They maintained their
electric data using Miner & Miner's utility GIS
application, MMPowerTools.
In September 2001, seeking to upgrade their
system and achieve greater cost savings, CSU
made the decision to migrate to Miner &
Miner's ArcFM 8 technology. Their existing
legacy system was no longer supported and did
not provide all of the functionality available in
ArcFM 8. As part of the project, CSU sought to
form a basis for migrating and integrating the
maintenance of their gas, water, and wastewater
GIS data to the most current GIS software. CSU
was looking for a fully supported GIS solution
that would consolidate their disparate systems
on a unified platform and provide the ability to
share information across the organization,
improving data maintenance, map production
Miner & Miner Consulting Engineers, Inc.
4701 Royal Vista Circle, Fort Collins, CO 80528
www.miner.com
Colorado Springs Utilities
and other business requirements. Additionally,
they sought a system that would ultimately be
able to integrate with their in-house Outage
Management System (OMS ).
CSU selected the ArcGIS/ArcFM solution to
support their business needs. Miner & Miner
provided implementation and data conversion
services for the project, and configured the
software to fit CSU's business rules.
In addition to consolidating to the latest
technology on a single, supported platform, a
key goal for CSU's migration was to create a
more responsive workforce, where a group of
editors could edit and maintain multiple utilities
(electric, water, gas) within the organization.
With the new system, CSU is now able to
represent data in more robust ways. As an
example, ArcFM allows editors to place
complex switch cabinet features that represent
the switches, fuses and busbars within the
cabinet. This provides CSU with the
functionality to operate switches and open points
on a per phase basis within switch cabinets.
As part of the data conversion, M&M developed
several automated routines to correct problems
in CSU's existing data, including an automated
routine that consolidated three transformer unit
point features into a single banked transformer
feature with three related unit records.
The migration of CSU's electric data was
completed in just over six months using a
phased implementation approach. CSU serves
as a model for a rapid enterprise GIS
implementation performed in three stages of
design, develop, and deploy, following M&M's
Building Your ArcFM Methodology.
Telephone: 970-223-1888
FAX. 970-223-5577
Page 1 of 2
0
MINEP&MINER
Because ArcFM was developed using standard
technology, CSU was able to complete a
straightforward implementation of their GIS, yet
the open architecture of the solution has enabled
them to make customizations to better suit their
utilities' business needs. For instance, M&M
assisted CSU's electric utility in developing an
edited features tracking tool, which enables
users to track every feature that has been added,
updated or changed. In addition, a Service
Point to Transfer Relationship Tool allows
editors to easily relate customers to the
transformers they are served from, providing
CSU with information that is useful for outages
and assigning load to transformers.
CSU's data has now been fully migrated and the
utility is currently preparing to upgrade to the
ArcFM 8.3 platform. There are six users editing
and maintaining data at CSU, with more than
200 additional users accessing the system to
view and query the data. Editors are also able to
produce timesaving map books for field
personnel and linemen. In addition, the system
is able to provide the OMS with timely system
information.
Future plans for Colorado Springs Utilities
include implementation of Session Manager to
automate and streamline workflow, automating
post and reconcile procedures, implementation
of Conduit Manager, and conversion of their
wastewater, water, and gas systems to
ArcGIS/ArcFM.
Miner & Miner Consulting Engineers, Inc.
4701 Royal Vista Circle, Fort Collins, CO 80528
www.miner.com
Projectr file
Telephone: 970-223 -1888
FAX.- 970-223-5577
Page 2 of 2
M1NER"INER
Gwinnett County Department of Public Utilities (GA)
Gwinnett County
Department of Public Utilities
75 Langley Drive
Lawrenceville, GA 30045
Jodi O'Brien, GIS/Records Manager
Ph.: (678) 376-7115
obrienJo@co.gwinnett.ga.us
Gwinnett County Department of Public Utilities
is a municipal water, wastewater, and
stormwater agency that serves approximately
190,000 customers in the suburban area of
Atlanta, Georgia. The county has been an ESRI
customer for quite some time and, in 2000,
elected to purchase Miner & Miner's ArcFM to
maintain and manage its utility network
information. Miner & Miner began the project in
August 2000 and Gwinnett County has been in
production since August 2001. Miner & Miner
also converted GIS water, wastewater and
stormwater data for the county. Gwinnett
County DPU currently has 15 editors of ArcFM
and two ArcFM Viewer seats to maintain and
query their network data.
The ArcFM implementation at Gwinnett County
is in production and has been upgraded to the
ArcGIS/ArcFM 8.1.2 release. The
implementation included several key benefits to
the county and its constituents. Data
maintenance processes are now standardized,
and include mass updates from Trimble GPS
field data collection, through the use of a custom
data loader developed to read the Trimble data
output into the utility's Geometric Network. In
the future, customer information will also be
related to the assets stored in the ArcFM
GeoDatabase for use in Water and Sewer
modeling. Consumption information is
Miner & Miner Consulting Engineers, Inc.
4701 Royal Vista Circle, Fort Collins, CO 80528
www.miner.com
associated to load points and that information is
then passed onto the WaterCad and SewerCad
Models developed by Haestad Methods.
In addition to these enhancements, the FileNet
Document Management System was installed at
the county department of public utilities.
Gwinnett DPU is currently scanning in all of
their as -built drawings and other important
documentation and associating it to the network
assets using ArclDM. ArcIDM is a product that
integrates the ArcFM GeoDatabase with the
FileNet document management system to
provide a seamless interface for the retrieval of
information related to both the utility networks
in place and those under construction within the
Gwinnett County service territory.
Future and planned enhancements to the system
include the implementation of a work order
management system integrated with the ArcFM
GeoDatabase as well as the expansion of data
being carried into the field. Currently, Gwinnett
DPU is evaluating the use of ArcFM Viewer for
this purpose. Finally, as a method to provide
better customer service, the county is also
planning to implement several customer kiosks
throughout the county, based on the ArcIMS
technology. This technology will allow
customers to view information related to their
accounts, geographic location, and to view
enhancements or projects planned, or under
construction, in their area.
Telephone: 970-223-1888
FAX. 970-223-5577
Page 1 of 1
Project Profe
MINEWINER
Poudre Valley REA
PO Box 272550
P.O. Box 3270
Fort Collins, CO 80527-2550
http://www.i)vrea.com/
Mike Mansour,
Ph: (970) 226-1234
mmansour@pvrea.com
Poudre Valley REA is an electric
cooperative serving consumers in Boulder,
Larimer, and Weld counties.
Miner & Miner (M&M) and Poudre Valley
REA (PVREA) have been working closely
together in the development of an enterprise
GIS based on ESRI's ArcGIS and M&M's
ArcFM GIS product lines. PVREA's
ArcGIS / ArcFM will act as core technology
for the management of PVREA's electrical
distribution network and will enable the
utility to add on a graphic design application
that models the work flow of building new
facilities, from design to material
procurement and finally the installation and
as -built phases of construction.
The ArcGIS / ArcFM GIS project at
PVREA has been very successful. PVREA
has retained M&M's services for a number
of tasks including database tuning, system
configuration, custom application
programming and data modeling. Of
significance is the consultative approach that
M&M and PVREA have taken to make this
project a success. Given limited resources
Miner & Miner Consulting Engineers, Inc.
4701 Royal Vista Circle, Fort Collins, CO 80528
www.miner.com
Poudre Valley REA (CO)
and tight budgets, M&M and PVREA have
combined efforts that have resulted in a solid
foundation for the ongoing management of
the utilities assets in a seamless, enterprise
GIS environment. Future project plans
include the deployment of M&M's Designer
product.
Miner & Miner's primary role in the project
has been to provide data modeling, database
tuning and application development expertise.
M&M has been involved in an initiative
known as MultiSpeak, a consortium of
software developers, consultants and vendors
who work together to agree upon a data
model specification that enables system
interoperability simplifies the development of
complex interfaces. Our extensive knowledge
of the MultiSpeak specification, combined
with our extensive knowledge of ArcGIS and
SDE, has resulted in an equitable and
effective GIS for PVREA.
As the ArcGIS / ArcFM GIS becomes more
mature, M&M expects to play a larger role in
assisting PVREA in developing MultiSpeak
based interfaces to other corporate systems
such as the AS400 Customer Information
System and the Materials Management
datasbase.
Telephone: 970-223-1888
FAX: 970-223-5577
Page 1 of 1
Appendix C — Scope of Work, Project Plan, and Pricing
Scope of Work
SmartTrips GIS Tools for
The City of Fort Collins
TM
Provided by. -
Miner and Miner, Consulting Engineers, Inc.
Phone 970-223-1888
Fax 970-223-5577
E-�,�-
Y plc« i 4 M1C4lJ�S31. 4( F �!=1 NG G45 ..�
Table of Contents
Section 1 — Executive Summary ......................................................................................... 1
Section 2 — Company Overview......................................................................................... 2
Name, Address, and Contact Information....................................................................... 2
BriefHistory ................................................................................................................... 2
Ownership....................................................................................................................... 3
OfficeLocations.............................................................................................................. 3
OrganizationStructure.................................................................................................... 3
Section 3 — Qualifications and Experience......................................................................... 3
ProjectExpertise......................................................................................................... 3
Related Project Experience......................................................................................... 5
ProjectReferences...................................................................................................... 6
Section 4 — Staffing and Resumes...................................................................................... 6
Project Team Resumes.................................................................................................... 7
Section 5 — Proposed Services and Pricing......................................................................... 7
Section6 — Terms & Conditions......................................................................................... 7
Appendix A — Miner & Miner Resumes
Appendix B — Project Profiles
Appendix C — Scope of Work, Project Plan, and Pricing
City of Fort Collins Scope of WorK SmartTrips GIS Tools
Introduction........................................................................................................................... I
Background...........................................................................................................................1
ProjectScope
.........................................................................................................................1
ItemsOutside
of Project Scope.............................................................................................2
ProjectTasks
.........................................................................................................................2
1.1 Design Phase..................................................................................................................................
2
1.1.1
Project Kickoff Meeting........................................................................................................3
1.1.2
Review Current Carpool Programs........................................................................................
3
1.1.2.1
Review Applications..........................................................................................................
3
1.1.2.2
Review Methods................................................................................................................
3
1.1.3
Define SmartTrips Requirements...........................................................................................
3
1.1.3.1
Database Requirements......................................................................................................
3
1.1.3.2
Geocoding Requirements...................................................................................................
4
1.1.3.3
Map Production Requirements...........................................................................................
4
1.1.3.4
Reporting Requirements....................................................................................................
4
1.1.3.5
Document Functional Requirements..................................................................................4
1.1.3.6
Review Functional Requirements Document.....................................................................
4
1.1.3.7
Revise Functional Requirements Document......................................................................4
1.1.3.8
Deliver Functional Requirements Document.....................................................................
5
1.2 Prototype Phase.............................................................................................................................
5
1.2.1
Prepare Development Environment.......................................................................................
5
1.2.1.1
Package Data for Delivery .................................................................................................
5
1.2.1.2
Load Data into Development Environment.......................................................................
5
1.2.2
Perform Database Changes....................................................................................................
5
1.2.3
Develop Prototype Tools.......................................................................................................
5
1.2.3.1
Data Entry Tools................................................................................................................
5
1.2.3.2
Create Geocoding Services................................................................................................
6
1.2.3.3
Develop Map Production Tool...........................................................................................
6
1.2.3.4
Develop Reporting Tool....................................................................................................
6
1.2.4
Prototype Demonstration.......................................................................................................
6
1.2.5
Review SmartTrips Tools Requirements Document..............................................................
6
1.2.6
Revise SmartTrips Tools Requirements Document...............................................................
6
1.2.7
Deliver Final SmartTrips Tools Requirements Document .....................................................
7
1.3 Develop and Deploy Phase............................................................................................................
7
1.3.1
Develop Final Tools...............................................................................................................
7
1.3.1.1
Finalize Data Entry Tools..................................................................................................
8
1.3.1.2
Finalize Geocoding Services..............................................................................................
8
1.3.1.3
Finalize Map Production Tool...........................................................................................
8
1.3.1.4
Finalize Reporting Tool.....................................................................................................
8
1.3.2
Factory Acceptance Testing...................................................................................................
8
1.3.3
On -Site Acceptance Testing..................................................................................................
9
1.3.4
End User Training..................................................................................................................
9
1.3.5
Rollout to End Users..............................................................................................................
9
1.3.6
Final Delivery Complete........................................................................................................9
Miner and Miner, Consulting Engineers, Inc.
City of Fort Collins Scope of WorK SmartTrips GIS Tools
Introduction
Miner and Miner (M&M) is pleased to provide a proposal for the development of
customized GIS Tools for the SmartTrips program of the City of Fort Collins (the City).
This proposal covers the creation of tools to allow the SmartTrips staff to quickly enter
carpool information and find potential carpool partners for interested citizens. The
structure of this document will reflect the Project Schedule, provided separately. As this is
a joint effort, this document will identify responsibilities for individual tasks as
appropriate. M&M and the City will complete the tasks detailed in the following sections.
Should the City request M&M perform services beyond those specified, a contract change
order will be required.
This project plan provides a three -phased solution to the City's request for customized
SmartTrips tools. The first phase is the design phase, where the project's functional
requirements are fully specified and documented. The second phase is the prototype
phase. In this phase a working prototype is developed of all of the tools required for the
SmartTrips project, based on the defined requirements from phase 1. These tools are then
demonstrated for City personnel, and requirements are modified based on comments from
the City. The final stage is the development and deployment phase. In this phase the final
requirements are programmed and the tools are fully tested. The tools are then fully tested
by the City in a site acceptance test. Finally, the software is installed and end -users are
trained.
Background
SmartTrips is a City -run program that assists residents in finding trip -sharing partners.
This involves carpooling on an ad -hoc basis, targeted campaigns at major employers
within the city, and school -based trip sharing. To facilitate this service the City maintains
a database of potential carpoolers and provides people interested in carpooling with a list
of carpoolers that have similar source and destination locations. Additionally, the list
comes with a map showing these source and destination points.
The current process to maintain this system is inefficient, involving multiple steps and
duplicate data entry. Additionally, the process is not `user-friendly' making the process
much more difficult than necessary. The City would like to streamline this process by
creating some custom tools within ArcMap that eliminates the duplicate data entry, assists
in the geocoding of source and destination locations, and standardizes the production of
maps and reports that are delivered to potential carpoolers. The new process should be
simpler to follow and not require a detailed knowledge of GIS technology to complete.
Project Scope
The goal of the SmartTrips Custom Tools project (the Project) is to provide the City with
the necessary tools to streamline the data maintenance effort of the SmartTrips database
and delivery of information about potential carpoolers to interested city residents.
To accomplish this goal, the Project will consist of three distinct phases. In the Design
Phase, M&M and the City will work together to define and document the functional
Miner and Miner, Consulting Engineers, Inc. Page 1
City of Fort Collins Scope of WorK SmartTrips GIS Tools
requirements that the SmartTrips tools must perform. This effort will begin with a review
of current applications and methods, what one might term the `As -Is' environment. The
next step will be to define requirements for the `To -Be' environment, including specific
requirements for the GIS database design, for geocoding functionality, for map production
and for reporting. For example, a redesign of SmartTrips data storage to incorporate the
SmartTrips data into the GIS database may help eliminate data redundancy; therefore a
thorough database review will be performed. Finally, all tools that will be developed will
be fully defined including the address matching tools and geocoding services, the user
interfaces that will be necessary to view and modify carpooler information, and the map
and report production tools.
In the Prototype Phase, M&M will work from the functional requirements defined in the
Design Phase to build prototype tools that meet the City's needs. These tools will be
demonstrated to the City in a daylong review session. The City will have time to provide
feedback to help clarify the requirements of the tools at this time. These clarifications will
be incorporated into the requirements document.
In the Develop and Deploy Phase, M&M will work from the revised functional
requirements document to finalize the SmartTrips tools. Once completed and fully tested
at M&M, the tools will be delivered to the City. The City will then perform their Site
Acceptance Tests, with support from M&M. After the tools pass testing, they will be
installed and user training will be provided through a demonstration and question and
answer session. Documentation of the tools will also be provided to the users with step-
by-step instructions for maintaining the database and producing maps and reports.
Items Outside of Project Scope
To clarify the scope of the Project, this section provides a list of items that are not included
in the scope of this Project. M&M would require a Change Order to this Agreement for
any work to be performed in regards to these issues.
1. Database Modeling issues unrelated to SmartTrips
The City has a variety of GIS data. The scope of this project is limited to the
SmartTrips data in GIS and MS Access.
2. Data Quality of Existing Data
M&M is not responsible for any data cleanup effort that may arise from the review of
the existing SmartTrips data both within the GIS and in the Access database.
Project Tasks
1.1 Design Phase
The initial phase for the Project will involve a series of tasks to flesh out and
document the functional requirements of the SmartTrips Tools.
Miner and Miner, Consulting Engineers, Inc. Page 2
City of Fort Collins Scope of WorK SmartTrips GIS Tools
1.1.1 Project Kickoff Meeting
M&M will hold a half day Project Kickoff Meeting on -site at the City. The
team will review, discuss, and make sure all participants fully understand
the goals and methodology for the project. We will also review the project
plan to review the tasks, responsibilities, and dependencies. The team will
then cover the administrative framework for managing the project. We will
establish communication processes, business processes (for example,
configuration control and access control), and change control processes.
Deliverable: Project Kickoff Meeting (M&M, City), Conference facilities
(including a digital projector) (City)
1.1.2 Review Current Carpool Programs
This series of tasks allows M&M to fully understand the current processes
used by the SmartTrips staff and properly define the requirements of the
project.
1.1.2.1 Review Applications
In this task, the M&M PM and the City will review how the City
uses the current applications in regards to the SmartTrips
program.
Deliverables: On -Site review of current applications (M&M,
City)
1.1.2.2 Review Methods
In this task, the M&M PM and the City will review the current
work processes the City has in place for maintaining the
SmartTrips data and producing reports for Carpoolers.
Deliverables: On -Site review of current methods (M&M. Citv)
1.1.3 Define SmartTrips Requirements
With a firm understanding of the current process and the business drivers
behind them, the next step is to define how those business requirements will
be met with new SmartTrips GIS Tools.
1.1.3.1 Database Requirements
In this task, the M&M PM and the City will define the data
requirements of the project and the storage and access
requirements. If new tables are required in the GIS to store
SmartTrips information, M&M will provide the appropriate
table structures to the City.
Deliverables: On -Site requirements gathering data tables and
storage (M&M, City)
Miner and Miner, Consulting Engineers, Inc. Page 3
City of Fort Collins Scope of WorK SmartTrips GIS Tools
1.1.3.2 Geocoding Requirements
In this task, the M&M PM and the City will define how the two
geocoding services will work. This includes samples of user
interfaces, defining which datasets in the GIS will be used for
geocoding, and data storage of the results.
Deliverables: On -Site requirements gathering of geocoding
tools (M&M, City)
1.1.3.3 Map Production Requirements
In this task, the M&M PM and the City will define the Map
Production requirements for the SmartTrips project. This
includes preparing a based map, assigning responsibility for
symbology of features, and creating a map production user
interface that allows the user to quickly produce maps for
1.1.3.4
1.1.3.5
1.1.3.6
1.1.3.7
Carpoolers.
Deliverables: On -Site requirements gathering of Map
Production tools (M&M, City)
Reporting Requirements
In this task, the M&M PM and the City will define the reporting
requirements for the SmartTrips project. This will include a
review of the existing reports, defining which data fields are
used to create the reports, and providing a user interface to
produce the reports.
Deliverables: On -Site requirements gathering of Reporting
tools (M&M, City)
Document Functional Requirements
In this task, the M&M PM will gather all of the requirements
gathered into the SmartTrips Tools requirements document.
Deliverables: SmartTrips Tools requirements document
(M&M)
Review Functional Requirements Document
In this task, the City will review the requirements document and
provide comments back to M&M on them.
Deliverables: Comments on the SmartTrips Tools requirements
document (City)
Revise Functional Requirements Document
In this task, the M&M PM will revise the requirements
document based upon the comments received from the City.
Deliverables: Revised SmartTrips Tools requirements
document (M&M)
Miner and Miner, Consulting Engineers, Inc. Page 4
City of Fort Collins Scope of Work SmartTrips GIS Tools
1.1.3.8 Deliver Functional Requirements Document
This Milestone marks the end of the Design Phase of the Project.
This milestone is reached with the delivery of the revised
SmartTrips Tools requirements document to the City.
1.2 Prototype Phase
This series of tasks will produce a set of SmartTrips Tools that adhere to the
requirements specification defined in the Design Phase. These tools will be
demonstrated to the City on -site. Comments from the City will be incorporated
into the requirements document after the demonstration.
1.2.1 Prepare Development Environment
This task allows both the City and M&M to prepare the development
environment in which the tools will be built. M&M will build and test the
tools using the City's GIS data ensuring that upon delivery the tools will
work as specified in the requirements document.
1.2.1.1 Package Data for Delivery
In this task, the City will prepare all necessary data to develop
the SmartTrips Tools into a package and deliver the package to
M&M.
Deliverables: Deliver data to M&M (City)
1.2.1.2 Load Data into Development Environment
In this task, an M&M Database Analyst will load all data
delivered from the City into the development environment.
Deliverables: Development environment ready for use at M&M
(M&M)
1.2.2 Perform Database Changes
In this task M&M will perform all database schema changes identified in
the database requirements gathering task that relate to the SmartTrips
project.
Deliverable: Modified Geodatabase with SmartTrips data requirements
incorporated into schema (M&M)
1.2.3 Develop Prototype Tools
During this series of tasks M&M will develop the prototype tools of the
SmartTrips project.
1.2.3.1 Data Entry Tools
This set of tools will provide the City with easy to use tools to
insert and update SmartTrips information. These tools will be
designed so no redundant data entry is required.
Miner and Miner, Consulting Engineers, Inc. Page 5
City of Fort Collins Scope of WorK SmartTrips GIS Tools
Deliverable: Prototype data entry tools (M&M)
1.2.3.2 Create Geocoding Services
This set of tools will allow the City to easily geocode SmartTrips
source locations and destination locations using either the
regional street centerline dataset or the citywide address location
dataset.
Deliverable: Prototype Geocoding Tools (M&M)
1.2.3.3 Develop Map Production Tool
This tool will allow the City to easily print SmartTrips map
products based upon whether the Carpooler is an individual
carpooler, a campaign carpooler from a specific company, or a
school pooler. Maps will only contain realistic potential
matches.
Deliverable: Prototype map production tool (M&M)
1.2.3.4 Develop Reporting Tool
This tool will allow the City to create a report containing all
relevant contact information from the set of potential matches.
This information will be attached to the map and sent to the
I Deliverable: Prototvne renortine tool (M&M) I
1.2.4 Prototype Demonstration
M&M will travel to the City and demonstrate the tools to City staff. The
demonstration will clearly outline how the tools meet the functional and
business requirements and allow the City to provide feedback on the
development effort.
Deliverable: Demonstration of Prototype SmartTrips Tools (M&M)
Conference Facilities (including digital projector) (City)
1.2.5 Review SmartTrips Tools Requirements Document
The City will review the SmartTrips Tools requirements document after the
demonstration of the prototype tools. This review will be accomplished
with the M&M Project Manager, allowing for the City to provide feedback
on the prototype tools and refine the requirements as necessary.
Deliverable: Review of Requirements Document (M&M, City)
Conference Facilities (including digital projector) (City)
1.2.6 Revise SmartTrips Tools Requirements Document
In this task, the M&M Project Manager will update the requirements
document to reflect the results of the requirements review meeting.
Deliverable: Revised Requirements Document (M&M)
Miner and Miner, Consulting Engineers, Inc. Page 6
City of Fort Collins Scope of Work SmartTrips GIS Tools
1.2.7 Deliver Final SmartTrips Tools Requirements Document
This milestone marks the completion of the Prototype Phase. The
Milestone occurs when the revised SmartTrips Tools requirements
document is delivered to the City.
1.3 Develop and Deploy Phase
This series of tasks will produce the final SmartTrips Tools adhering to the revised
requirements specification from the Prototype Phase. These tools will be fully
tested and documented with end -user documentation at M&M during the FAT
tests. Final acceptance of the tools by the City will occur after the tools have
passed SAT at the City.
1.3.1 Develop Final Tools
During this series of tasks the City and M&M will development a series of
test plans to ensure the SmartTrips Tools meet all required functionality.
1.3.1.1 Develop Test Plans based on Requirements Document
Using the Functional Requirements document as a guide, the
City will develop a series of test plans that will be used to test
the SmartTrips tools. These plans will be used in the factory
acceptance testing and the site acceptance testing. Once the
tools pass these tests at the city, both parties will consider the
tools acceptable.
Deliverable: Draft Test Plans (City)
1.3.1.2 Review Test Plans
M&M will review and provide feedback on the test plans. This
review will ensure that the test plans are focused on the specific
functionality of the SmartTrips tools, while not disabling other
GIS functions.
Deliverable: Comments on Test Plans (M&M)
1.3.1.3 Revise Test Plans
The City will incorporate comments from M&M into the final
version of the test plans and provide them to M&M.
I Deliverable: Revised Test Plans (City) I
1.3.1.4 Deliver Final Test Plans
This Milestone marks the completion of the test plan
development. The milestone is reached when the City delivers
the final test Dlans for the SmartTrips tools to M&M.
I Deliverable: Final Test Plans (City) I
Miner and Miner, Consulting Engineers, Inc. Page 7
City of Fort Collins Scope of Work SmartTrips GIS Tools
1.3.2 Develop Final Tools
During this series of tasks M&M will finish the development and end -user
documentation of the SmartTrips Tools for maintaining the dataset and
producing maps and reports of potential carpoolers.
1.3.2.1 Finalize Data Entry Tools
This set of tools will provide the City with easy to use tools to
insert and update SmartTrips information based upon the final
functional requirements document. These tools will be designed
so no redundant data entry is required.
Deliverable: Final data entry tools (M&M)
1.3.2.2 Finalize Geocoding Services
This set of tools will allow the City to easily geocode SmartTrips
source locations and destination locations based upon the final
functional requirements document. The tools will make use of
the regional street centerline dataset and the citywide address
location dataset.
Deliverable: Final Geocoding Tools (M&M)
1.3.2.3 Finalize Map Production Tool
This tool will allow the City to easily print SmartTrips map
products based upon the final functional requirements document.
The tool will allow the user to select whether the Carpooler is an
individual carpooler, a campaign carpooler from a specific
company, or a school pooler. Maps will only contain realistic
potential matches.
Deliverable: Final map production tool (M&M)
1.3.2.4 Finalize Reporting Tool
This tool will allow the City to create a report containing all
relevant contact information from the set of potential matches
based upon the final functional requirements document. This
information will be attached to the map and sent to the
Deliverable: Final reporting tool (M&M)
1.3.3 Factory Acceptance Testing
M&M will perform Factory Acceptance Testing (FAT) on all tools
developed. This testing will be performed according to a set of documented
test plans, agreed to by both the City and M&M. M&M will resolve issues
as they appear during the FAT.
Deliverable: Factory Acceptance Testing (performed at M&M) (M&M)
Documentation of Test Results (M&M)
Miner and Miner, Consulting Engineers, Inc. Page 8
City of Fort Collins Scope of Work SmartTrips GIS Tools
1.3.4 On -Site Acceptance Testing
M&M will support the City in the performance of Site Acceptance Testing
(SAT) on all tools developed. This testing will be performed according to
the documented test plans, agreed to by both the City and M&M. M&M
will resolve issues as they appear during the SAT.
Deliverable: Support Site Acceptance Testing (performed at the City)
(M&M)
Documentation of Test Results (City)
1.3.5 End User Training
In this task an M&M Analyst will perform end -user training for the
SmartTrips Tools. The training will consist of written documentation of
each function available to the end user, along with sample use cases.
Additionally, an on -site demonstration of the software along with a question
and answer session will be held for end -users of the SmartTrips tools.
Deliverable: Documented instructions for the use of the tools (M&M)
Demonstration Session with a Question and Answer portion
for end -users (M&M)
Conference Facilities (including digital projector) (City)
1.3.6 Rollout to End Users
M&M will support the City in the rollout of the SmartTrips Tools to the
end -users. The software will be delivered in an easy to install package,
complete with installation instructions. Additionally, an M&M Analyst will
be on -site to help troubleshoot the installation process.
Deliverable: Documented Installer for custom tools (M&M)
Install on client machines (performed at the City) (M&M)
1.3.7 Final Delivery Complete
This Milestone marks the completion of the Project. The Milestone occurs
when the rollout task is completed.
Miner and Miner, Consulting Engineers, Inc. Page 9
El
Section 1 — Executive Summary
Miner & Miner proposes our tested and proven "Design, Develop and Deploy"
methodology for the successful delivery of the Parcel Maintenance Tools and the
SmartTrips Custom Tools as specified by the City of Fort Collins RFP for GIS-Related
Application Development # P-916. The goal of the Parcel Maintenance Tools portion of
the project is to provide the City with a tool that will migrate existing CAD based files
into the City's GIS database. The goals of the SmartTrips Custom Tools portion of the
project are to provide the City with: (1) a tool to streamline data maintenance efforts on
the SmartTrips database and (2) delivery of information about potential carpoolers to
interested City residents.
Miner & Miner has a long history in Northern Colorado. More importantly,
M&M has a long-standing history of being the world's leading developer of ESRI based
GIS applications for several types of users including electric utilities, gas companies, and
municipal governments. An example of M&M's local presence, and an extremely
successful GIS project, is at Colorado Springs Utilities, a Miner & Miner customer since
the early 1990's. Today, CSU uses Miner & Miner products to manage all of its electric,
water, waste water, fiber optics and gas facilities. Over the years CSU has engaged the
services of Miner & Miner for a multitude of ESRI GIS-based application development
proj ects.
Miner and Miner has been developing ESRI based applications since 1989 and has
gained significant and unique expertise in successfully delivering GIS products and
services. We believe that our track record over the last 15 years of work in the world of
GIS has clearly reinforced our commitment to the community and to the industry.
Using GIS means that all of the investments in techniques, databases, and advanced
methods can be published and made available to a new class of users. This will also mean
that the results and effectiveness of the work done by the professionals at The City of
Fort Collins will become more widely accepted and integrated into various other
activities that the City is engaged in —an environment most cities are striving to achieve
today. M&M's philosophy is to work closely with the City to build a partnership that
ensures the successful deployment of these tools.
In summary, Miner & Miner is recognized as the leading developer of GIS applications
for organizations such as the City of Fort Collins, and we would like to build a successful
relationship to support the City's GIS vision. M&M's complete understanding of the
requirements for the City's custom components positions our team to be the best -suited
organization for The City of Fort Collins GIS application development needs.
- 1 -
ID
Name
Duration
Cost
Janua
FebMarch April
12/2112/28 114 1/11 1/18 1/25
2/1rua 2/8 2/15 2/22 12129 1 3/7 3/14 3/21 13128 1 4/4
1
SmartTrtps Custom Tools
46.5 days
$59,234.00
1 MAN I PM,City of Ft Collins
�M& I PM,City of Ft Collins
Cit of Ft Collins,M&M PM
L Cit of Ft Collins,M&M PM
Cil of Ft Collins,M&M PM
L Ci of Ft Collins,M&M PM
Cl of Ft Collins,M&M PM
M M PM
City of Ft Collins
L M&M PM
�i 1/13
C ly of Ft Collins
&M Database Analyst
M&M PM[10Y.],M&M Analyst
&M Analys ,M&M PM[40°/.]
ELM
M&MAr alyst,M&M PM[40Y.]
&M alyst,M&M PM[40'7.]
1 &M Analyst,M&M PM[40-/.]
City of Ft Collins,M&M PM,M&M Analyst
City of Ft Collins
M&M PM
2/18 .
2
Design Phase (Phase 1)
7 days
$5,440.00
3
Project Kickoff Meeting
0.5 days
$680.00
4
Review Current Carpool Programs
1 day
$1,360.00
5
Review Applications
0.5 days
$680.00
6
Review Methods
0.5 days
$680.00
7
Define SmartTrips Requirements
5.5 days
$3,400.00
8
Database Requirements
0.25 days
$340.00
9
Geocoding Requirements
0.25 days
$340.00
10
Map Production Requirements
0.25 days
$340.00
11
Reporting Requirements
0.25 days
$340.00
12
Document Functional Requirements
1 day
$1,360.00
13
Review Functional Requirements Documen
3 days
$0.00
14
Revise Functional Requirements Document
0.5 days
$680.00
15
Deliver Functional Requirements Document
0 days
$0.00
16
Prototype Phase (Phase 2)
25.5 days
$29,224.00
17
Prepare Development Environment
6 days
$1,280.00
18
Package Data for Delivery
5 days
$0.00
19
Load data into Development Environment
1 day
$1,280.00
20
Perform Database Changes
2 days
$2,592.00
21
Develop Prototype Tools
13 days
$22,152.00
22
Data Entry Tools
4 days
$6,816.00
23
Create Geocoding Services
3 days
$5,112.00
24
Develop Map Production Tool
3 days
$5,112.00
25
Develop Reporting Tool
3 days
$5,112.00
26
Prototype Demonstration
1 day
$2,520.00
27
Review SmartTrip Functional Requirements Doc
3 days
$0.00
28
Revise SmartTrip Functional Requirements DoG
0.5 days
$680.00
29
Deliver Final SmartTrip Functional Requirement:
0 days
$0.00
30
Develop and Deploy Phase (Phase 3)
14 days
$24,570.00
31
Develop Test Plans
4.5 days
$680.00
Project: Carpool (Project 2)
Date: Wed 11/26/03
Task Milestone ♦ External Tasks
Split Summary ^ External Milestone
ry
Progress Project Summary ^ Deadline
Page 1
ID
Name
Duration
Cost
I January
February
March ril
12/2112/28 114 1/11 1/18 1/25
1 2/1 2/8 2/15
2/22 2/29 1 Y7 3/14 3/21 3/28 4/4
32
Develop Test Plans based on Requirement
3 days
$0.00
City of Ft Collins
4 M&M PM
City of Ft Collins
2124
M&M Analyst,M&M PM[25°/.]
M M Analyst,M&M PM[254b]
&M Analyst,M&M PM[25°/a]
M&M Analyst,M&M PM[25%]
M&M Analyst,M&M PM
City of Ft Collins,M&M PM,M&
ty of Ft Collins,M&M Analyst
City of Ft Collins,M&M An
♦ 3/9
33
Review Test Plans
0.5 days
$680.00
34
Revise Test Plans
1 day
$0.00
35
Deliver Final Test Plans
0 days
$0.00
36
Develop Final Tools
6.5 days
$9,750.00
37
Finalize Data Entry Tools
2 days
$3,000.00
38
Finalize Geocoding Services
1.5 days
$2,250.00
39
Finalize Map Production Tool
1.5 days
$2,250.00
40
Finalize Reporting Tool
1.5 days
$2,250.00
41
Factory Acceptance Testing
2 days
$5,040.00
42
On -Site Acceptance Testing
2 days
$5,040.00
43
End User Training
0.5 days
$580.00
44
Rollout to End Users
3 days
$3,480.00
45
Final Delivery Complete
0 days
$0.00
Project: Carpool (Project 2)
Date: Wed 11/26/03
Task Milestone .
Split Summary
„.........., "
Progress Project Summary
External Tasks
^ External Milestone
^ Deadline
Page 2
Scope of Work
Parcel Maintenance Tools for
The City of Fort Collins
TM
Provided by;
Miner and Miner, Consulting Engineers, Inc,
Phone 970-223-1888
Fax 970-223-5577
Introduction...........................................................................................................................1
Backeround...........................................................................................................................I
ProjectScope.........................................................................................................................1
Items Outside of Project Scone.............................................................................................2
ProjectTasks
.........................................................................................................................2
1.1 Design Phase..................................................................................................................................
2
1.1.1
Project Kickoff Meeting........................................................................................................
3
1.1.2
Review Current Procedures...................................................................................................
3
1.1.2.1
Review Current DWG/DXF Format..................................................................................
3
1.1.2.2
Review DWG/DXF QA Processes....................................................................................
3
1.1.2.3
Review DWG/DXF to Coverage Process..........................................................................
3
1.1.2.4
Review Address QA Process.............................................................................................
3
1.1.2.5
Review Parcel QA Process................................................................................................
4
1.1.2.6
Review Topology QA Process...........................................................................................
4
1.1.3
Define ArcGIS 8 Process.......................................................................................................
4
1.1.3.1
Define DWG/DXF QA Processes......................................................................................4
1.1.3.2
Define DWG/DXF to Geodatabase Process......................................................................
4
1.1.3.3
Define Address QA Process...............................................................................................
4
1.1.3.4
Define Parcel QA Process..................................................................................................
5
1.1.3.5
Define Topology QA Process............................................................................................
5
1.1.3.6
Document Functional Requirements..................................................................................
5
1.1.3.7
Review Functional Requirements Document.....................................................................
5
1.1.3.8
Revise Functional Requirements Document......................................................................
5
1.1.3.9
Deliver Functional Requirements Document.....................................................................
5
1.2 Prototype Phase.............................................................................................................................
5
1.2.1
Prepare Development Environment.......................................................................................
6
1.2.1.1
Package Data for Delivery .................................................................................................
6
1.2.1.2
Load Data into Development Environment.......................................................................
6
1.2.2
Develop Prototype Tools.......................................................................................................
6
1.2.2.1
DWG/DXF to Geodatabase Import ....................................................................................
6
1.2.2.2
Address QA Tools.............................................................................................................
6
1.2.2.3
Parcel QA Tools.................................................................................................................
6
1.2.2.4
Topology QA Tools...........................................................................................................
7
1.2.3
Prototype Demonstration.......................................................................................................7
1.2.4
Review Parcel Maintenance Tools Requirements Document ................................................
7
1.2.5
Revise Parcel Maintenance Tools Requirements Document .................................................
7
1.2.6
Deliver Final Parcel Maintenance Tools Requirements Document .......................................
7
1.3 Develop and Deploy Phase............................................................................................................
7
1.3.1
Develop Final Tools...............................................................................................................
8
1.3.1.1
DWG/DXF to Geodatabase Import ....................................................................................
8
1.3.1.2
Address QA Tools.............................................................................................................
9
1.3.1.3
Parcel QA Tools.................................................................................................................
9
1.3.1.4
Topology QA Tools...........................................................................................................
9
1.3.2
Factory Acceptance Testing...................................................................................................
9
1.3.3
On -Site Acceptance Testing..................................................................................................
9
1.3.4
End User Training..................................................................................................................
9
1.3.4.1
Develop Custom Training Material...................................................................................
9
1.3.4.2
Review Material with the City.........................................................................................
10
1.3.4.3
User Training Class.........................................................................................................
10
1.3.5
Rollout to End Users............................................................................................................10
1.3.6
Final Delivery Complete......................................................................................................10
Miner and Miner, Consulting Engineers, Inc.
City of Fort Collins Scope of WorK Parcel Maintenance Tools
Introduction
Miner & Miner is pleased to provide a proposal for the development of Parcel Maintenance
tools for the City of Fort Collins (the City). This proposal covers the creation of tools to
load CAD -based files into an ArcGIS Geodatabase and perform a series of quality
assurance steps on the new data. The structure of this document will reflect the Project
Schedule, provided separately. As this is a joint effort, this document will identify
responsibilities for individual tasks as appropriate. M&M and the City will complete the
tasks detailed in the following sections. Should the City request M&M perform services
beyond those specified, a contract change order will be required.
This project plan provides a three -phased solution to the City's request for Parcel
Maintenance tools. The first phase is the design phase, where the project's functional
requirements are fully specified and documented. The second phase is the prototype
phase. In this phase a working prototype is developed of all of the tools required for Parcel
Maintenance, based on the defined requirements from phase 1. These tools are then
demonstrated for City personnel, and requirements are modified based on comments from
the City. The final stage is the development and deployment phase. In this phase the final
requirements are programmed and the tools are fully tested by Miner and Miner. The tools
are then fully tested by the City in a site acceptance test. Finally, the software is installed
and end -users are trained.
Background
The City currently maintains Parcel information in an ESRI coverage format stored within
ESRI's Librarian data storage module. When new parcel information comes into the City,
a series of AML programs are run to convert the file from CAD format and incorporate it
into the Parcel Librarian layer.
The City would like to take advantage of the latest data storage format from ESRI, the
Geodatabase, and is planning for the move from the Librarian format into Geodatabase
format. A part of this move is to have in place ArcObject-based routines to perform the
necessary conversion routines to incorporate the CAD file -based parcel information into
the Geodatabase.
Project Scope
The goal of the Parcel Maintenance Tools project (the Project) is to provide the City with
the necessary tools to move parcel data from CAD based files into Geodatabase's Parcel
and Address feature classes.
The Project consists of three phases. In the Design Phase M&M and the City will review
the current, `As -Is' procedures for loading CAD data into the GIS. Once this is complete,
the requirements for a new, `To -Be' process in the ArcGIS 8 environment will be defined.
This process will cover both the data loading and QA processes necessary to ensure correct
attribute and topology information. It will not necessarily be the case that the `To -Be'
solution follows the exact same steps as the `As -Is' procedures. M&M will work with the
City to identify how the data loading process can be streamlined to improve efficiency and
Miner and Miner, Consulting Engineers, Inc. Page 1
City of Fort Collins Scope of WorK Parcel Maintenance Tools
data quality. For example, given the functionality provided in the ArcGIS 8 environment it
may be possible to migrate data directly from AutoCAD drawing (DWG) files to
GeoDatabase feature classes rather than converting the drawings to DXFs, then migrating
the DXF file data.
In the Prototype Phase, M&M will work from the functional requirements defined in the
Design Phase to build prototype tools that meet the City's needs. These tools will be
demonstrated to the City in a daylong review session. The City will have time to provide
feedback to help clarify the requirements of the tools at this time. These clarifications will
be incorporated into the requirements document.
In the Develop and Deploy Phase, M&M will work from the revised functional
requirements document to finalize the Parcel Maintenance tools. Once completed and
fully tested at M&M, the tools will be delivered to the City. The City will then perform
their Site Acceptance Tests, with support from M&M. After the tools pass testing, they
will be installed and a daylong user training session will be held in a lecture and exercise
format, giving the City employees the knowledge to properly maintain the Parcel data.
Items Outside of Project Scope
To clarify the scope of the Project, this section provides a list of items that are not included
in the scope of this Project. M&M would require a Change Order to this Agreement for
any work to be performed in regards to these issues.
1. Database Modeling and Database Updates
The City has stated that the standard ESRI Parcel and Address data models will be used
for the storage of Parcel and Address information. It is assumed that any changes to be
made to these standard models will be performed by the City. These changes include,
but are not limited to, feature class additions and subtractions, field additions and
subtractions, domain value changes, relationship additions and subtractions, annotation
feature class additions and subtractions, and topology rules.
Additionally, assistance in the migration of existing data into these data models is
excluded from this scope of work.
2. Topology rules and Topology issues with existing data
Since M&M is not involved with any aspect of the data conversion, it is outside the
scope of work for this project to participate in any review of or corrections to existing
topology issues.
It is expected that the City will have all necessary topology rules defined when the
geodatabase is delivered to M&M to create the development environment
Project Tasks
1.1 Design Phase
The initial phase for the Project will involve a series of tasks to flesh out and
document the functional requirements of the Parcel Maintenance Tools.
Miner and Miner, Consulting Engineers, Inc. Page 2
City of Fort Collins Scope of WorK Parcel Maintenance Tools
1.1.1 Project Kickoff Meeting
M&M will hold a one-half day Project Kickoff Meeting on -site at the City.
The team will review, discuss, and make sure all participants fully
understand the goals and methodology for the project. We will also review
the project plan to review the tasks, responsibilities, and dependencies. The
team will then cover the administrative framework for managing the
project. We will establish communication processes, business processes
(for example, configuration control and access control), and change control
processes.
Deliverable: Project Kickoff Meeting (M&M, City), Conference facilities
(including a digital projector) (City)
1.1.2 Review Current Procedures
In order to fully understand the current process of loading data into the
Librarian parcel and address layers, a series of tasks to review this process
will be held. The goal of these tasks is to get a complete understanding of
the business requirements and functional requirements of the Project.
1.1.2.1 Review Current DWG/DXFFormat
In this task, the M&M PM and the City will review the current
requirements the City has in place for the delivery of CAD files
of parcel data.
Deliverables: On -Site review of Current DWG/DXF Format
(M&M, City)
1.1.2.2 Review DWG/DXF QA Processes
In this task, the M&M PM and the City will review the current
requirements the City has in place for QA of CAD files of parcel
data.
Deliverables: On -Site review of DWG/DXF QA Process
(M&M, City)
1.1.2.3 Review DWG/DXF to Coverage Process
In this task, the M&M PM and the City will review the current
requirements the City has in place for the conversion of the DXF
files into the Librarian layer.
Deliverables: On -Site review of conversion process (M&M,
City)
1.1.2.4 Review Address QA Process
In this task, the M&M PM and the City will review the current
requirements the City has in place for the QA of Address
information.
Miner and Miner, Consulting Engineers, Inc. Page 3
City of Fort Collins Scope of WorK Parcel Maintenance Tools
Deliverables: On -Site review of Address QA process (M&M,
City)
1.1.2.5 Review Parcel QA Process
In this task, the M&M PM and the City will review the current
requirements the City has in place for the QA of Parcel data.
Deliverables: On -Site review of Parcel QA process (M&M,
City)
1.1.2.6 Review Topology QA Process
In this task, the M&M PM and the City will review the current
requirements the City has in place for the QA topology within
the Parcel layer.
Deliverables: On -Site review of topology QA process (M&M,
City)
1.1.3 Define ArcGIS 8 Process
With a firm understanding of the current process and the business drivers
behind them, the next step is to define how those business requirements will
be met with the Parcel Maintenance Tools.
1.1.3.1 Define DWG/DXF QA Processes
In this task, the M&M PM and the City will define how the
CAD files of parcel data will be processed before loading into
the geodatabase.
Deliverables: On -Site requirements gathering of DXF QA
process (M&M, City)
1.1.3.2 Define DWG/DXF to Geodatabase Process
In this task, the M&M PM and the City will define how the
CAD files of parcel data will be loaded into the geodatabase,
including which DWG/DXF layers are associated with feature
classes in the geodatabase.
Deliverables: On -Site requirements gathering of DWG/DXF to
geodatabase process (M&M, City)
1.1.3.3 Define Address QA Process
In this task, the M&M PM and the City will define how the
Address information from the CAD files will be QAed in the
geodatabase.
Deliverables: On -Site requirements gathering of Address QA
process (M&M, City)
Miner and Miner, Consulting Engineers, Inc. Page 4
City of Fort Collins Scope of Work Parcel Maintenance Tools
1.1.3.4 Define Parcel QA Process
In this task, the M&M PM and the City will define how the
Parcel information from the CAD files will be QAed in the
eodatabase.
Deliverables: On -Site requirements gathering of Parcel QA
process (M&M, City)
1.1.3.5 Define Topology QA Process
In this task, the M&M PM and the City will define how the
topology of the Parcels from the CAD files will be QAed in the
geodatabase.
Deliverables: On -Site requirements gathering of topology QA
process (M&M, City)
1.1.3.6 Document Functional Requirements
In this task, the M&M PM will gather all of the requirements
gathered into the Parcel Maintenance Tools requirements
document.
Deliverables: Parcel Maintenance Tools requirements
document (M&M)
1.1.3.7 Review Functional Requirements Document
In this task, the City will review the requirements document and
provide comments back to M&M on them.
Deliverables: Comments on the Parcel Maintenance Tools
requirements document (City)
1.1.3.8 Revise Functional Requirements Document
In this task, the M&M PM will revise the requirements
document based upon the comments received from the City.
Deliverables: Revised Parcel Maintenance Tools requirements
document (M&M)
1.1.3.9 Deliver Functional Requirements Document
This Milestone marks the end of the Design Phase of the Project.
This milestone is reached with the delivery of the revised Parcel
Maintenance Tools requirements document to the City.
1.2 Prototype Phase
This series of tasks will produce a set of Parcel Maintenance Tools that closely
adhere to the requirements specification defined in the Design Phase. These tools
will be demonstrated to the City on -site. Comments from the City will be
incorporated into the requirements document after the demonstration.
Miner and Miner, Consulting Engineers, Inc. Page 5
City of Fort Collins Scope of Work Parcel Maintenance Tools
1.2.1 Prepare Development Environment
This task allows both the City and M&M to prepare the development
environment in which the tools will be built. M&M will build and test the
tools using the City's GIS data ensuring that upon delivery the tools will
work as specified in the requirements document.
1.2.1.1 Package Data for Delivery
In this task, the City will prepare all necessary data to develop
the Parcel Maintenance Tools into a package and deliver the
nackaee to M&M.
Deliverables: Deliver data to M&M (City)
1.2.1.2 Load Data into Development Environment
In this task, an M&M Database Analyst will load all data
delivered from the City into the development environment.
Deliverables: Development environment ready for use at M&M
(M&M)
1.2.2 Develop Prototype Tools
During this series of tasks M&M will develop the prototype tools for
loading parcel data into the Geodatabase and performing QA on the
resulting features.
1.2.2.1 DWGIDAY to Geodatabase Import
This set of tools will process the CAD file and import the
various layers into the Geodatabase as defined in the
requirements document. Parcel data will be loaded into the
Parcel Framework and TaxParcel polygon feature classes,
Boundary and Easement line feature classes, and City -defined
annotation classes. Address data will be loaded into the Address
and Subaddress point feature classes, the Street line feature
class, and the address range tables.
Deliverable: Prototype DWG/DXF to Geodatabase import tool
(M&M)
1.2.2.2 Address QA Tools
This set of tools will allow the City to perform QA checks on the
data that was imported into the Address dataset in the
¢eodatabase as defined in the requirements document.
Deliverable: Prototype Address QA tool (M&M)
1.2.2.3 Parcel QA Tools
This set of tools will allow the City to perform QA checks on the
data that was imported into the Parcel dataset in the geodatabase
as defined in the requirements document.
Miner and Miner, Consulting Engineers, Inc. Page 6
Section 2 — Company Overview
This brief section highlights the pertinent information regarding Miner & Miner in its
submittal to the City of Fort Collins.
Name, Address, and Contact Information
Firm Name: Miner and Miner, Consulting Engineers, Inc.
Address: 4701 Royal Vista Circle
Fort Collins, CO 80528
Web: www.miner.com
Contacts: Jeff B. Meyers
Phone: (970) 223-1888
E-mail: jeffb.meversAminer.com
Brief History
Miner and Miner, Consulting Engineers, Inc. (Miner & Miner, M&M), a privately held
firm with nearly 100 employees, has provided engineering services for the utility industry
since 1946, and has been an ArcInfo AM/FM/GIS developer and implementer since
1986. With over 57 years of experience, Miner & Miner brings an unparalleled depth of
expertise to the utility industry.
Miner & Miner has handled projects ranging from small installations to complex
AM/FM/GIS software solutions. Through its development work, in close partnership
with ESRI, M&M has become the world's leading developer of ArcGIS AM/FM/GIS
applications for the utility industry. Clients of the ArcFM Solution range from some of
the largest utilities in the world (Public Service Electric and Gas of New Jersey; AES-
Eletropaulo of Sao Paulo, Brazil) to many small cooperatives and municipal utilities
(Truckee Donner PUD of California; Rochester Public Utilities of Minnesota). This
range of diverse work experience enables M&M to remain in touch with a wide spectrum
of industry trends and needs.
Over Miner & Miner's 57+ years of service to the utility industry, the company has
offered a full range of consulting and implementation services to fit the needs of electric,
gas, and water/wastewater utilities throughout North America and the world.
-2-
City of Fort Collins Scope of Work Parcel Maintenance Tools
Deliverable: Prototype Parcel QA tool (M&M)
1.2.2.4 Topology QA Tools
This set of tools will allow the City to perform QA checks on the
topology of the data that was imported into the Parcel dataset in
the geodatabase as defined in the requirements document.
Deliverable: Prototype Topology QA tool (M&M)
1.2.3 Prototype Demonstration
M&M will travel to the City and demonstrate the tools to City staff. The
demonstration will clearly outline how the tools meet the functional and
business requirements and allow the City to provide feedback on the
development effort.
Deliverable: Demonstration of Prototype Parcel Maintenance Tools (M&M)
Conference Facilities (including digital projector) (City)
1.2.4 Review Parcel Maintenance Tools Requirements Document
The City will review the Parcel Maintenance Tools requirements document
after the demonstration of the prototype tools. This review will be
accomplished with the M&M Project Manager, allowing for the City to
provide feedback on the prototype tools and refine the requirements as
necessary.
Deliverable: Review of Requirements Document (M&M, City)
Conference Facilities (including digital projector) (City)
1.2.5 Revise Parcel Maintenance Tools Requirements Document
In this task, the M&M Project Manager will update the requirements
document to reflect the results of the requirements review meeting.
Deliverable: Revised Requirements Document (M&M)
1.2.6 Deliver Final Parcel Maintenance Tools Requirements
Document
This milestone marks the completion of the Prototype Phase. The
Milestone occurs when the revised parcel maintenance tools requirements
document is delivered to the City.
1.3 Develop and Deploy Phase
This series of tasks will produce the final Parcel Maintenance Tools adhering to the
revised requirements specification from the Prototype Phase. These tools will be
fully tested and documented at M&M during the factory acceptance tests (FAT).
Final acceptance of the tools by the City will occur after the tools have passed SAT
at the City.
Miner and Miner, Consulting Engineers, Inc. Page 7
City of Fort Collins Scope of Work Parcel Maintenance Tools
1.3.1 Develop Final Tools
During this series of tasks the City and M&M will development a series of
test plans to ensure the Parcel Maintenance Tools meet all required
functionality.
1.3.1.1 Develop Test Plans based on Requirements Document
Using the Functional Requirements document as a guide, the
City will develop a series of test plans that will be used to test
the Parcel Maintenance tools. These plans will be used in the
factory acceptance testing and the site acceptance testing. Once
the tools pass these tests at the city, both parties will consider the
tools acceptable.
Deliverable: Draft Test Plans (City)
1.3.1.2 Review Test Plans
M&M will review and provide feedback on the test plans. This
review will ensure that the test plans are focused on the specific
functionality of the Parcel Maintenance tools, while not
disabline other GIS functions.
Deliverable: Comments on Test Plans (M&M)
1.3.1.3 Revise Test Plans
The City will incorporate comments from M&M into the final
version of the test plans and provide them to M&M.
Deliverable: Revised Test Plans (City)
1.3.1.4 Deliver Final Test Plans
This Milestone marks the completion of the test plan
development. The milestone is reached when the City delivers
the final test plans for the Parcel Maintenance tools to M&M.
Deliverable: Final Test Plans (City)
1.3.2 Develop Final Tools
During this series of tasks M&M will finish the development and
documentation of the Parcel Maintenance Tools for loading parcel data into
the Geodatabase and performing QA on the resulting features.
1.3.2.1 DWGIDXF to Geodatabase Import
This set of tools will process the CAD file and import the
various layers into the geodatabase as defined in the
requirements document.
Deliverable: Final DWG/DXF to Geodatabase import tool
(M&M)
Miner and Miner, Consulting Engineers, Inc. Page 8
City of Fort Collins Scope of Work Parcel Maintenance Tools
1.3.2.2 Address QA Tools
This set of tools will allow the City to perform QA checks on the
data that was imported into the Address dataset in the
eeodatabase as defined in the reauirements document.
I Deliverable: Final Address OA tool (M&M) I
1.3.2.3 Parcel QA Tools
This set of tools will allow the City to perform QA checks on the
data that was imported into the Parcel dataset in the geodatabase
as defined in the requirements document.
Deliverable: Final Parcel OA tool (M&M)
1.3.2.4 Topology QA Tools
This set of tools will allow the City to perform QA checks on the
topology of the data that was imported into the Parcel dataset in
the geodatabase as defined in the requirements document.
Deliverable: Final Tonolo>;v OA tool (M&M)
1.3.3 Factory Acceptance Testing
M&M will perform Factory Acceptance Testing (FAT) on all tools
developed. This testing will be performed according to a set of documented
test plans, agreed to by both the City and M&M. M&M will resolve issues
as they appear during the FAT.
Deliverable: Factory Acceptance Testing (performed at M&M) (M&M)
Documentation of Test Results (M&M)
1.3.4 On -Site Acceptance Testing
M&M will support the City in the performance of Site Acceptance Testing
(SAT) on all tools developed. This testing will be performed according to
the documented test plans, agreed to by both the City and M&M. M&M
will resolve issues as they appear during the SAT.
Deliverable: Support Site Acceptance Testing (performed at the City)
(M&M)
Documentation of Test Results (City)
1.3.5 End User Training
This set of tasks allows for the creation of end -user training material, review
& revision of the material with the City, and training of the users.
1.3.5.1 Develop Custom Training Material
In this task an M&M Trainer will review the tools built and
create a series of lectures and exercises designed to teach the
end -user how to load parcel data into the geodatabase.
Miner and Miner, Consulting Engineers, Inc. Page 9
City of Fort Collins Scope of Work Parcel Maintenance Tools
Deliverable: Training materials for the Parcel Maintenance
Tools (M&M)
1.3.5.2 Review Material with the City
In this task an M&M Trainer will review the lectures and
exercises with City personnel and receive comments back on it.
The M&M Trainer will modify the training material based upon
mutually agreed upon alterations.
Deliverable: Review of training materials (M&M, City)
Final training materials for the Parcel Maintenance
Tools (M&M)
1.3.5.3 User Training Class
In this task an M&M Trainer will lead a series of lectures and
exercises with City personnel, training them in the use of the
Parcel Maintenance Tools.
Deliverable: User training class (M&M, City)
Conference Facilities (with a digital projector)
(City)
1.3.6 Rollout to End Users
M&M will support the City in the rollout of the Parcel Maintenance Tools
to the end -users. The software will be delivered in an easy to install
package, complete with installation instructions. Additionally, an M&M
Analyst will b on -site o help troubleshoot the installation process.
Deliverable: Documented Installer for custom tools (M&M)
Install on client machines (performed at the City) (M&M)
1.3.7 Final Delivery Complete
This Milestone marks the completion of the Project. The Milestone occurs
when the rollout task is completed.
Miner and Miner, Consulting Engineers, Inc. Page 10
ID
Task Name
Duration
cost
January February March
12/21 12/28 1 1/4 1 1/11 1 1/18 1 1/26 2/1 2/8 1 2/15 1 Z22 2/29 3/7 1 3/14 3/21 3128 1 4/4 4111 4118
1
Parcel Maintenance Tools
59.75 days
$77,984.00
^ _
,City of Ft Collins
:.
LM&M P ,City of Ft Collins
ity of Ft Collins
City of Ft Collins
City of Ft Collins
City of Ft Collins10
City of Ft Collins
4WIRM&M
: City of Ft Collins
City of Ft Collins14
,City of Ft Collins
,City of Ft Collins
M&K PM,CRy of Ft Collins',
M PM
City Of Ft Collins.
L_M&M PM
�i -.
City of Ft Collins
M&M Database Analyst
-
M&M Analys4M&M M[40%]
M&M Anal M&M PM[40%] .
M&M Iyst,M&M PM[40X]
- &M Analyst,M&M PM[40%]
M&M PM,M&M Analyst.City of Ft Collins
City of Ft Collins
M&M PM
- =0
City Ft Collins
[,M&M PM
City of Ft Collins
: . 2/26
M&M Anatyst,M&M PM[25%]
2
Design Phase (Phase 1)
7.75 days
$6,460.00
3
Project Kickoff Meeting
0.6 days
$680.00
4
Review Current Procedures
1.5 days
$2,040.00
5
Review Current DWG/DXF Format
0.25 days
$340.00
6
Review DWG/DXF QA Processes
0.25 days
$340.00
7
Review DWG/DXF to Coverage prose
0.25 days
$340.00
8
Review Address QA Process
0.25 days
$340.00
9
Reviiew Parcel QA Process
0.25 days
$34000
Review Topoology QA Process
0.25 days
$340.00
11
Define ArcGIS 8 Process
5.75 days
$3,740.00
12
Define DWG/DXF QA Processes
0.25 days
$340.00
13
Define DXF to Coverage process
0.25 days
$340.00
Define Address OA Process
0.25 days
$340.00
15
Define Parcel QA Process
0.25 days
$340.00
16
Define Topoology QA Process
0.25 days
$340.00
17
Document Functional Requirements
1 day
$1,360.00
18
Review Functional Requirements Doc
3 days
$0.00
19
Modify Functional Requirements Doa
0.5 days
$680.00
20
Deliver Functional Requirements Doei
0 days
$0.00
21
Prototype Phase (Phase 2)
26.5 days
$31,744.00
22
Prepare Development Environment
6 days
$1,280.00
23
Package Data for Delivery
5 days
$0.00
24
Load data into Development Erwironu
1 day
$1,280.00
25
Develop Prototype Tools
18 days
$27,284.00
26
DWG/DXF to Geodatabase Import
4 days
$6,816.00
27
Address QA Process
4 days
$6,816.00
28
Parcel GA Process
4 days
$6,816.00
29
Topology QA Process
4 days
$6,816.00
30
Prototype Demonstration
1 day
$2,520.00
31
Review Parcel Maintenance Tools Require
3 days
$0.00
32
Modify Parcel Maintenance Tools Requirer
0.5 days
$680.00
33
Deliver Final Parcel Maintenance Tools Re
0 days
$0.00
34
Develop and Deploy Phase (Phase 3)
25.5 days
$39,780.00
35
Develop Test Plans
4.5 days
$680.0o
36
Develop Test Plans based on Require
3 days
$0.00
37
Review Test Plans
0.5 days
$680.00
38
Revise Test Plans
1 day
$0.00
39
Deliver Final Test Planes
0 days
$0.00
40
Develop Final Tools
11 days
$16,Soo .00
41
DWG/DXF to Geodatabase Import
2 days
$3,000.00
Project: Parcel Maintenance_ v2
Date: Wed 11/26/03
Task Milestone 4, External Tasks
Split Summary ^ External Milestone
Progress Project Summary ^ Deadline
Page 1
ID
Task Name
Duration
Cost
Janus
Feixua
March it
12/21 12128 1l4 1/11 1/18 1/25
2/1 218
2/15 2122 2/29 3/7 3/14 3121 3/28 414 4/11 4/18
42
Address QA Process
3 days
$4.500.00
-
M&M Analyst,M&M PM[25%] .
M8M Analyst,M&M PM[25%]
Analyst,M&M PM[25X1
M8M Anatyst,M&M PM
City of Ft Collins,M&M Analyst
M&M Trainer,M&M PM[25%]
M&M Tratner,City, of Ft Collins,M&
&M Traine4City of Ft Collins
ity of Ft Collins,M&M Analyst
1:(
♦ 3126
43
Parcel QA Process
3 days
$4,500.00
44
Topology QA Process
3 days
E4,500.00
45
Factory Acceptance Testing
3 days
$7,560.00
46
Orr -Site Acceptance Testing
3 days
$3,480.00
47
End User Training
6days
f10A00.00
48
Develop Custom Training Material
4 days
$6.480.00
49
Review Material with City
1 day
$2,640.00
50
User Training Class
1 day
$1.280.00
51
Rollout to End -Users
1 day
$1,160.00
52
Final Delivery Complete
0 days
$0.00
Project: Parcel Maintenance_ v2
Date: Wed 11/26/03
Task
Sag
Progress
,,,,,,,,,,,,,,,
Milestone
Summary
Project Summary
External Tasks
External Milestone
Deadline
Page 2
M
Ownership
Miner & Miner has been a privately -held concern since its founding in 1946. Since 1992,
Miner & Miner has been owned by its Chairman, Charles W. Meyers, President Jeffrey
R. Meyers, and Director of Special Projects, Roger W. Meyers, and by its business
partners, Jack and Laura Dangermond, the sole proprietors of ESRI.
Office Locations
Miner & Miner, headquartered in Fort Collins, Colorado, maintains several regional
offices in the United States and internationally. Miner & Miner's United States regional
and sales offices include Gainesville, Florida; Philadelphia, Pennsylvania; and Atlanta,
Georgia. Significant industry and project development is carried out in Athens, Georgia
and Washington, D.C.
Organization Structure
Miner & Miner has a staff of a more than a hundred professionals. Of this group, over 80
team members are dedicated to the planning, design and implementation of ArcGIS based
solutions. The Applications Team has a staff of over 40 professionals, dedicated to
helping utilities of all sizes plan, design, and implement state-of-the-art solutions. This
group is composed of individuals with a vast array of expertise in the implementation of
GIS for utilities. The Miner & Miner professional team brings an unparalleled depth of
expertise to its customers.
Section 3 - Qualifications and Experience
Project Expertise
Miner & Miner offers a full range of GIS consulting and implementation services to fit
the needs of municipals, electric, gas, and water/wastewater utilities. From
implementation of complex enterprise GIS systems to consulting and training, to
developing value-added'functions, ranging from building a simple edit task to integration
of a legacy system such as CIS or ERP, Miner & Miner has a proven reputation as the
leading GIS provider in the utilities industry. Approximately 65% of M&M's revenue
comes from GIS Services work. The staffs of the Implementation Services (also known
as the Applications) group at Miner & Miner are experts in implementing production
systems based on the ArcFM Solution. We represent many years of experience in
working with utility companies and addressing the business needs raised by their staff
and public works departments. Our domain knowledge is supplemented by our extended
knowledge of ESRI and M&M core technologies.
Our primary area of expertise is in implementing and extending the core, off -the -shelf
components to meet the business needs of our customers. We have also built the
-3-
El
interfaces and provided the expertise in related areas necessary to make challenging
projects successful. For all projects, we recommend and use a structured implementation
methodology that reduces risk and ensures project requirements are fulfilled.
Miner & Miner provides a full range of project management and programming services.
These include:
• ESRI GIS Implementation Services
• ArcFM and ArcMap Implementations
• Designer Implementations
• Network Adapter Implementations to Engineering Analysis Packages
• Requirements Analysis and Definition
• Data Modeling and Creation of Physical UML Model
• Schema Generation and Database Optimization
• ESRI Geodatabase Configuration
• GIS Software Installation and Configuration
• Integration of Off -the -Shelf Software with Business Practices
• Specification, Design, and Programming for ArcFM Extensions and Custom
Tools
• Interface Specification, Design, and Programming
• Data Conversion Consulting and Quality Assurance
• AM/FM/GIS Consulting
• Project Management
• Education for Users and Technical Staff
Miner & Miner is an industry leader with an extensive background and a valued
reputation. Miner & Miner has successfully translated industry requirements into working
solutions for a large client base. Our experience enables us to provide the City with
solutions to industry -specific challenges and to solve them in ways that are complete,
comprehensive, and production ready. We understand the need for - and have provided
reliable systems that protect - the integrity of attribute and topological data.
-4-
Keeping system reliability high and service rates low is a key project driver for our client
base. The users of our tools have diverse human resources and are often geographically
dispersed. Our users need tools that are easy to use and protect the data. They need the
ability to access, as well as update, data from a variety of locations. They need to provide
access at a number of different levels, and they need to provide access to data through
different means, quite often for different purposes.
A GIS system must interface seamlessly with existing corporate information systems in
order to be a well -integrated system. Miner & Miner has extensive knowledge when it
comes to the successful design, development, and deployment of interfaces that support
the goal of an enterprise -wide implementation.
Our extensive experience in implementing enterprise GIS gives us that clear
understanding of the challenges and potential pitfalls that any IT project inherently owns.
Our management and implementation techniques are designed to provide the planning
and processes required to control risk and ensure the project's ultimate success. The
Miner & Miner programming staff have incorporated the best in software development
techniques and have sharpened their skills in the implementation of cutting edge
technology.
As a prime contractor, we have ensured the success of complete and integrated systems.
As a subcontractor to a system integrator, we have provided services that were required
to develop and integrate key components, in addition to providing consulting to
participating parties. As a consultant, Miner & Miner has assisted clients who are
managing their own implementation efforts. Over the years, Miner & Miner has filled a
variety of different roles in the implementation of corporate GIS systems and will
continue to do so based on client needs.
Related Project Experience
Miner & Miner has 124 licensed ArcFM Solution customer sites and is growing at a rate
of approximately one new user per week. The vast majority of these sites have also
engaged M&M to perform the implementation services for their various projects. Our
proven track record and commitment to each project's success has earned M&M the
reputation as the premier developer and implementer of GIS solutions for the utility
industry. M&M's customers are assured that in working with M&M, they have the
world's leading GIS company as a partner, a company that is totally focused on GIS
solutions and which has maintained its number one market position through continuously
high levels of customer commitment.
Specifically, M&M has demonstrated experience in the integration of data in AutoCAD
and ArcGIS GeoDatabase format through the course of several projects. For the Orlando
Utilities Commission (OUC) in Orlando, Florida M&M developed an ArcMap-based tool
to extract selected features from an ArcGIS GeoDatabase into one or a set of AutoCAD
-5-
DXF files. The tool accounts for mapping GIS geometry types (points, lines, polygons
and annotation) to AutoCAD entities (points, blocks, lines, polylines, polygons and text.)
The tool is fully configurable by the user so that different GIS features can be mapped to
different AutoCAD layers and entity types. This tool is also deployed at Public Service
Electric and Gas of New Jersey (PSE&G) and is being deployed at Gainesville Regional
Utilities in Gainesville, FL.
For CenterPoint Energy in Houston, TX M&M developed a tool to import selected
entities from AutoCAD drawings directly into ArcGIS GeoDatabase feature classes. This
tool allows the user to select a drawing file, select entities from the drawing to be
imported, map drawing entity and attribute definitions to feature classes and attributes
and to import the selected entities within the context of an ArcMap edit session. The tool
allows the user to save a configuration of AutoCAD entity to GIS feature mapping
definitions so that this may be re -used for subsequent imports of similarly structured
AutoCAD drawings. The tool has been in production since 2001 and is under evaluation
by other ArcGIS/AutoCAD users.
Project References
For detailed reference Project Profiles, please refer to Appendix B.
Section 4 - Staffing and Resumes
Miner & Miner has a staff of a nearly a hundred professionals. Of this group, over 80
team members are dedicated to the planning, design and implementation of ArcGIS based
solutions. The Applications Team has a staff of over 40 professionals, dedicated to
helping utilities of all sizes plan, design, and implement state-of-the-art solutions. This
group is composed of individuals with a vast array of expertise in the implementation of
GIS. The Miner & Miner professional team brings an unparalleled depth of expertise to
its customers.
Miner & Miner's Applications Team consists of project managers and
programmer/analysts who provide a variety of consulting and implementation services.
These services include user needs assessments, strategic planning, database design,
customization programming, prototyping, interface development, and training. The
Application group also comprises the Education Team and database administrators who
are available to help implementation configurations, system architectures, performance
tuning, etc.
The technical talents of the Miner & Miner Applications Team, coupled with strong
project management and GIS knowledge and specific implementation experience, places