HomeMy WebLinkAbout241034 MINER MINER - CONTRACT - CONTRACT - 3307970 P916 GISPROFESSIONAL SERVICES AGREEMENT
THIS AGREEMENT made and entered into the day and year set forth below, by and
between THE CITY OF FORT COLLINS, COLORADO, a Municipal Corporation, hereinafter referred
to as the "City" and Miner & Miner, Consulting Engineers, Inc. hereinafter referred to as
"Professional".
WITNESSETH:
In consideration of the mutual covenants and obligations herein expressed, it is agreed by
and between the parties hereto as follows:
1. Scope of Services. The Professional agrees to provide services in accordance with
the scope of services attached hereto as Exhibit "A", consisting of nine (9) pages, and incorporated
herein by this reference.
2. Time of Commencement and Completion of Services. The services to be performed
pursuant to this Agreement shall be initiated within one -hundred -twenty (120) days following
execution of this Agreement. Services shall be completed no later than September 30, 2004. Time
is of the essence. Any extensions of the time limit set forth above must be agreed upon in writing by
the parties hereto.
3. Early Termination by City. Notwithstanding the time periods contained herein, the
City may terminate this Agreement at any time without cause by providing written notice of
termination to the Professional. Such notice shall be delivered at least fifteen (15) days prior to the
termination date contained in said notice unless otherwise agreed in writing by the parties.
All notices provided under this Agreement shall be effective when mailed, postage prepaid and sent
to the following addresses:
PSA 05/01
1
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 tiles will be QAed in the geodatabase.
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.
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 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 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 DWG/DXF 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 geodatabase as
defined in the requirements document.
I Deliverable: Prototype Address QA tool (M&M) I
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.
I Deliverable: Prototype Parcel OA tool (M&M) I
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
aeodatabase as defined in the requirements document.
I Deliverable: Prototype Topolop-v OA tool (M&M) I
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.
Optionally, the City may travel to M&M for the demonstration.
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 site acceptance
testing (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 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 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 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 DWG/DXF 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)
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 geodatabase as
defined in the requirements 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.
I Deliverable: Final Parcel OA tool (M&M) I
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 Tovolo¢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 User Training
This training will be done through a user workshop setting in support of the on -
site acceptance testing. An M&M Analyst will work with City employees to
ensure -that the City has a through understanding of the tool functionality and how
to make use of that functionality.
1.5.3.3 Deliverable Rejected
Shall be defined as a deliverable failing to conform to the Statement of
Work or to meet specification, in ways that indicate that major
improvements in performance and/or procedure are needed to avoid
recurrence. The Contractor shall rework the deliverable generally,
including all quality checks, and resubmit to the Client within 30 days, at
which time the Client will rerun its acceptance check and reclassify the
work.
1.5.3.4 Client Delays
Client must exercise due diligence and shall ensure that factors beyond
the control of the Contractor, such as Client delays and failure to fulfill
Client responsibilities, will not interfere with Contractor's ability to
complete the services. Client shall notify Contractor of any such factors
that may cause delays in the completion of tasks or changes to the scope
of work, and both parties will mutually determine required modifications
to this Agreement.
1.5.3.5 Final Acceptance and Certification
At the conclusion of project acceptance, Contractor will request that
Client sign an acceptance certificate. Client production use of any given
application prior to receipt of an acceptance certificate shall constitute
acceptance on part of the Client. Production use shall be defined as the
use of the application in an environment that includes Client's system of
record database. Once final acceptance is given on any deliverable, any
further modifications required of Contractor for that accepted deliverable
shall result in a change in scope. Changes to scope must be agreed to in
writing by both parties.
Optional Tasks
1.6 Formal 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.6.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.
Deliverable: Training materials for the Parcel Maintenance Tools (M&M)
1.6.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.6.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)
EXHIBIT "B11
10
OUXrte
Ntmber
Task Name
Drawn
Cost
Imaw
JAWUSI
4MO f {2b I 5/2 1 6r9 1 5116 Sf29 5730 e!8 W13 aQ0 827 7/4 7ry1 m6 725
8/1 &8
1
1
Path Monlenaaa ToWs
S4.5 days
searomoo
',^ -.
pry0TRC6Mns '.
.
LMAM Chy oRCONWA
LMW ,dryof RCWMns
Lmu of Copies .
�Fi' of Cowin
Cpof R Comas
of RCoNmc
:,. LWM ,ply of R Cowles
;k spry of R CoYNf
PM,pFj o R Comes
we,pry oR Cam"
PM,Cayo RComnr
PM
ofRCOfts
ale PM
-
of R Cow"
M DMebw Anaryel
Atlelyel. P1 25%J -
„��'� idiM PM[28%J
W Pmps%J
Aeelyr,MSM Paq=%J
of Ft ommne
LMMaM Amdyo.(hy of R Casles
PM
$
-.
at RComm
PH:
of R COpbn
`6R2
.
Ans/yt,MSM PWIS%)
2
IA
Dsel" Phssa(Phan 1)
Tdays
i11.44M
3
1.1.1
Project KW"MesWV
026days
$340.00
4
1.12
... PAVIsw Crr"nl Proesd0ees
f day
st,s"
5
1.1.2.1
Rwv CWWK DWWXF Fcrmr
0.12 days
t16320
6
1.122
ilevlew QA
0.19drys
$176,W
7
1.1,
Revew DWGIDXF to CoversOo Proce
025 days
$moo
8
1.t
Mvinw Add'us OAProcoas
0.13dap
$17GAD
9
1.1.2.5
Rewiew Parole OA Process
0.12 dry"
16920
10
1.12.6
Review T0Po bWQA Prooeas
025 days
$340,00
tt
1.1.9
OelkN ArcW66 Proctors
STS drp
53.740AO
12
1.1.3.1
Do**DW OA Frooeaaee
025 dry"
sMOO
13
1132
Defe DXF to Geodetsbue process
026 Days
S3W.Oo
14
1.1.3.3
DOM Address OA Procen
025 dys
t3{0.00
ib
Prow OA Procew
025daya
s340.00
16
1.1.3.5
��OpooifoWOAProons
025 dell
.00
17
1.1.3.6
Dxunrd FMCU W RWAw merda
t day
$1.360.00
t8
1137
FtngbrW Repukrnerda Doc
3days
59.00
19
�- 1.1.3.8
-t.tDe--
Modty f rftW RegWremerW Dos
OS days
SSW..OD
2o
Dolew FWa;eWml fwgWremeWs boa
Odays
50.00
21
1.2
Pvaollype Phase (P'baae 2)
2S dolls
sm720.Do
1z1
Prepare Dswlop"1wd Eavlrwmand
aays
fr,2q.00
23
1.21.1
Package Data for Deevery
Stalls
s6.00
24
_ 1112
�.�.. LOW dra o1b Oevelagere Emhelrvr
i day
1.20.00
25
12.2
DOW" Plato" TCelS
16 days
26
122.1
DWCvDXFMGWcaaeaaalnVW
ad"
37¢00.00
27
1.2.2.2
Addesa OA Process
3
S4AWAO
26
1,2.2.3
Part* iM Process
dqa
3days
S{.6WA0
29
1.22.4
�.-.'rMakbgyQProcess
4clays
SOA0000
30
121
Pmlot A" DWwrdvrion �
O.6 dap
$I.Mo0
31
1,2.4.
Review Farm MekfOsweOe ads U
3dm
S0.00
12.5
"- MONY Parcel MaiWxance TWda Requean
udays
o0
39
12A
ver
OekFurf Parcel MBidWwlq TOOM Re
0 dal"
W
34
1.3
Owsiop and Deploy Remy P11lese 3)
1f.8dsys
it2.WM
35
1.&1
Develop TM PWM
4.5 clays
$MOO
38
13,1,11
DWAft Ter Farm based an RapWe
3daya
fOOO
37
1.31.2
Review TeQ Pans
Os days
$Woo
38
1.3.1 3
Rov%e Teo Pisns
t day
SDOO
99
1.31.1
Oefvr Firal ToRru
Odys
1 $0,00
40
1.&21
Develop FIRM Togh
40 days
s1:.a40.40
1
1.32,1
DWGXW le GDOW&Ine WMort
.. 3days
34Aa2.00
Proloot: Parcel Meineensnte_ v2
Dale-. Man 122sw
Tank Mkowle ♦ EXWMI TWu .. ,. ;•
SD" ... Summary ^ EAWW mbsiorm
Progress f leG Swwnary ^ Deafer .
Peps 1
10
Dtaagm
CastNmw
.gs1e
1
4/18 472i 5R 5rB Sr18 6/23 550 6f
f✓13 BY20 6Q7 714 Titt 7H8 Tab 8l1 gre
<2Ad*
M Pm
2aya
,72&00
_
AMFM��1f%l
U&M Apyyao"m PWS%l
AnOyO A W PM(18%)
ArA41A "PU48Ib
UM Aaslp%Cky of R CooMs
.7112 .
_
Trsirr~Pow%I
AMTrs%w Clfyofpfc"kw
43Parcel
OA PrOcaas
--2 �Ys
.72800
4fTap0logy
DA fto"s
=N=
3 02W
f4,OB2.00
4btoryAWeptW"
Taira
2Nya
fb.OW00
ACwPOZa Too"
2dWf
f2WO—DafRCWIMa,WMMYystr
Trairp
1day
f/,1t10.00
48
1.4j
FMW Oeyrary Caspbts
00m
$O.OD
40
50
1STJ-
Optl WT."s
4dgi
SICAM.00
61
15.1
E UWa Tro"
f days
10A00.80
52
1S.i,t
OeseloPCud" Tn"VMeWW
♦dM
,4 00
53
1.b.12
WMwv MataWrdtr CUy
1t
f2.8WA0
61
1.B.1.3
User TratrYrp CWn
10ay
57,280.OD
MllM hairx.Cfy ofRCOMM
Task
Pnta EftWTa
Rojoa Paco MWpero -w
Dm: MM 12rAW
w ..... I ..... , 1 , .
3—may
aumw Mks"* `
Pmgr mmmw�
Rojacl &--W y ^ Dssawd t11
Page 2
EXHIBIT "C$$
SPECIAL PROVISIONS: INTELLECTURAL PROPERTY RIGHTS
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 and City, subject to the terms of this Agreement, agree to joint ownership of
Deliverables. The City further agrees not to market, or sell said Deliverables or prevent
Professional from marketing and selling said product. The City reserves the right to share
Deliverables, at no cost to others, with public agencies within Larimer County.
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
Professionals internal business organization the Deliverables.
d. 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.
e. 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.
f. 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.
Professional:
City:
With Copy to:
Miner & Miner
City of Fort Collins
City of Fort Collins
4701 Royal Vista Circle
Attn: City Clerk
Attn: Marcus Bodig
Fort Collins, CO 80522
PO Box 580
PO Box 580
Fort Collins, CO 80522
Fort Collins, CO 80522
In the event of any such early termination by the City, the Professional shall be paid for services
rendered prior to the date of termination, subject only to the satisfactory performance of the
Professional's obligations under this Agreement. Such payment shall be the Professional's sole right
and remedy for such termination.
4. Design. Project Indemnity and Insurance Responsibility. The Professional shall be
responsible for the professional quality, technical accuracy, timely completion and the coordination
of all services rendered by the Professional, including but not limited to designs, plans, reports,
specifications, and drawings and shall, without additional compensation, promptly remedy and
correct any errors, omissions, or other deficiencies. The Professional shall indemnify, save and hold
harmless the City, its officers and employees in accordance with Colorado law, from all damages
whatsoever claimed by third parties against the City; and for the City's costs and reasonable
attorneys fees, arising directly or indirectly out of the Professional's negligent performance of any of
the services furnished under this Agreement. The Professional shall maintain commercial general
liability insurance in the amount of $500,000 combined single limits, and errors and omissions
insurance in the amount of N/A .
5. Compensation. In consideration of the services to be performed pursuant to this
Agreement, the City agrees to pay Professional on a time and reimbursable direct cost basis
according to Exhibit "B", consisting of two (2) pages, and incorporated herein by this reference;
with maximum compensation (for both Professional's time and reimbursable direct costs) not to
exceed Sixty -Four Thousand Four Hundred Dollars ($64,400). Monthly partial payments based
PSA 05/01
2
upon the Professional's billings and itemized statements of reimbursable direct costs are
permissible. The amounts of all such partial payments shall be based upon the Professional's
City -verified progress in completing the services to be performed pursuant hereto and upon the
City's approval of the Professional's reimbursable direct costs. Final payment shall be made
following acceptance of the work by the City. Optional Tasks must be authorized by the City
Representative before proceeding.
6. City Representative. The City will designate, prior to commencement of work, its
project representative who shall make, within the scope of his or her authority, all necessary and
proper decisions with reference to the project. All requests for contract interpretations, change
orders, and other clarification or instruction shall be directed to the City Representative.
7. Monthly Report. Commencing thirty (30) days after the date of execution of this
Agreement and every thirty (30) days thereafter, Professional is required to provide the City
Representative with a written report of the status of the work with respect to the Scope of Services,
Work Schedule, and other material information. Failure to provide any required monthly report may,
at the option of the City, suspend the processing of any partial payment request.
8. Independent Contractor. The services to be performed by Professional are those of
an independent contractor and not of an employee of the City of Fort Collins. The City shall not be
responsible forwithholding any portion of Professional's compensation hereunder forthe payment of
FICA, Workers' Compensation, other taxes or benefits or for any other purpose.
9. Personal Services. It is understood that the City enters into this Agreement based on
the special abilities of the Professional and that this Agreement shall be considered as an
agreement for personal services. Accordingly, the Professional shall neither assign any
responsibilities nor delegate any duties arising under this Agreement without the prior written
consent of the City.
PSA 05/01
3
10. Acceptance Not Waiver. The City's approval of drawings, designs, plans,
specifications, reports, and incidental work or materials fumished hereunder shall not in any way
relieve the Professional of responsibility for the quality or technical accuracy of the work. The City's
approval or acceptance of, or payment for, any of the services shall not be construed to operate as a
waiver of any rights or benefits provided to the City under this Agreement.
11. Default. Each and every term and condition hereof shall be deemed to be a material
element of this Agreement. In the event either party should fail or refuse to perform according to the
terms of this agreement, such party may be declared in default.
12. Remedies. In the event a party has been declared in default, such defaulting party
shall be allowed a period often (10) days within which to cure said default. In the event the default
remains uncorrected, the party declaring default may elect to (a) terminate the Agreement and seek
damages; (b) treat the Agreement as continuing and require specific performance; or (c) avail
himself of any other remedy at law or equity. If the non -defaulting party commences legal or
equitable actions against the defaulting party, the defaulting party shall be liable to the
non -defaulting party for the non -defaulting parry's reasonable attorney fees and costs incurred
because of the default.
13. Binding Effect. This writing, together with the exhibits hereto, constitutes the entire
agreement between the parties and shall be binding upon said parties, their officers, employees,
agents and assigns and shall inure to the benefit of the respective survivors, heirs, personal
representatives, successors and assigns of said parties.
14. Law/Severability. The laws of the State of Colorado shall govern the construction,
interpretation, execution and enforcement of this Agreement. In the event any provision of this
Agreement shall be held invalid or unenforceable by any court of competent jurisdiction, such
holding shall not invalidate or render unenforceable any other provision of this Agreement.
PSA 05/01
4
15. Special Provisions. Special provisions or conditions relating to the services to be
performed pursuant to this Agreement are set forth in Exhibit "C", consisting of one (1) page,
attached hereto and incorporated herein by this reference.
APPROA,D T FORM:
Assists City Attorney
THE CITY OF FORT COLLINS, COLORADO
S
Johr(f. Fischbach
City Manager
By: r..e .
J es B. O'Neill II, CPPO, FNIGP
Direct r f Purchasing & Risk Management
DATE: 0 y
By:
Title:
ineers,
RESIbENT OR VICEdPRESIDENT
Date:
ATT ST:
JM(Corporate Seal)
Corpor Secretary
PSA 05/01
5
EXHIBIT "K
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 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.
The Project will take an AutoCAD DWG or DXF file and update the Geodatabase components. The
tools will be written to run on the windows operating system and it will be written in a modular
fashion to allow for individual modules to be updated or replaced. The tools will be written using
ESRI Arc Objects and will integrate with ArcMap.
At a minimum, the parcel Geodatabase components that will need to be updated are:
• Parcel framework polygon feature classes
• Boundary arc feature class
• Tax parcel polygon feature class, as modified. Tax parcel polygon feature class will have
a unique id assigned automatically. Tables related to it will also have their unique id's
assigned automatically.
• Several annotations will be incorporated into the Geodatabase including feature linked
Geodatabase annotation.
• Easements will be incorporated as an arc feature class
At a minimum, the address Geodatabase components that will need to be updated are:
• Address point feature class
• Subaddress point feature class
• Street arc feature class
• Address range tables, and name tables
• Several annotations will be incorporated into the Geodatabase
• Address and subaddress point feature classes will have a unique id assigned
automatically.
The tools developed must have QC processes to ensure that the same standard of data quality that
now exists is maintained. Input data must be checked to determine that it is correct and all there and
it also must check that the final data has no errors and that it will integrate into the existing dataset.
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.
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.
1.1.1 Project Kickoff Meeting
M&M will hold a two hour 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/DXF Format
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 laver.
Deliverables: On -Site review of conversion process (M&M_ Citv)
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 OA of Address information.
I Deliverables: On -Site review of Address OA process (M&M, City) I
1.1.2.5 Review Parcel QA Process
In this task, the M&M PM and the City will review the current
requirements the Citv has in place for the OA of Parcel data.
I Deliverables: On -Site review of Parcel OA process (M&M. Citv) I
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 laver.
I Deliverables: On -Site review of tonoloQv OA process (M&M, Citv) I
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)