HomeMy WebLinkAboutReg 2003-04-21 Item 8B - Agreement - North Quadrant GIS Inventory with Perteet Engineering for $269,715I ITEM INFORMATION
CAS Number: 03-057 I Original Agenda Date: April 21, 2003
Agenda Item Title: GIS -Based Public Works Infrastructure Inventory (North Quadrant)
Consultant's Agreement with Perteet Engineering, Inc.
Original Sponsor:
Timeline:
Sponsor's Summary:
Recommendations:
Sponsor:
Committee:
Administration:
Cost Impact (if known):
Fund Source (if known):
Meeting Date
4/21/03
I Meeting Date
4/21/03
COUNCIL AGENDA SYNOPSIS
Meeting Date
4121/03
Council
Initials
Prepared by 1 Mayor's review 1 Council review
I Zde e•
I I
I I
Admin. Public Works
Authorize the Mayor to sign the agreement with Perteet Engineering, Inc.
Forward to Regular Council
Same as Sponsor
$269,715.00
Surface Water 412 and Facilities 303 Fund
RECORD OF COUNCIL ACTION
Action
APPENDICES
Attachments
Information Memo dated March 26, 2003
Consultant's Agreement with Perteet Engineering, Inc.
Utilities Committee Meeting Minutes from April 8, 2003
ITEM NO.
R b.
The contract is, for the GIS inventory and mapping of the infrastructure in the northern
quadrant of the City. This will encompass the area north of S 115' St to the Seattle border and
include the Ryan Hill neighborhood. This first area has minimal infrastructure records and it
contains a mix of commercial and residential uses. Three consulting firms were interviewed,
with Perteet rating the highest.
1
1
INFORMATION MEMO
TO: Mayor Mullet
FROM: Public Works Directs: di
DATE: March 26, 2003
SUBJECT: GIS -Based Public Works Infrastructure Inventory
Project No. 02 -DRO1
ISSUE
Conduct the Northern Quadrant GIS Infrastructure Inventory.
BACKGROUND
The City has incomplete as -built infrastructure information and lacks a comprehensive inventory of all
City-owned utilities. The level of information that is currently available varies greatly, primarily
depending on when an area was incorporated into the City. In general, areas recently incorporated
from King County have little to no recorded as -built information, and areas developed or redeveloped
through the City have limited as -built information.
Reliable as -built information is important for the following reasons:
1. Allows the City to respond to property owner and developer requests concerning the
availability and location of existing utilities.
2. Allows our maintenance crews a method of tracking utilities for routine maintenance.
3. Allows our maintenance crews to more easily locate hidden features during emergencies.
4. Allows the engineering staff to more easily design upgrades and schedule replacement for
needed utility work.
In addition to these City needs, state and federal regulations require the City to have accurate and
complete as-built information. These requirements are as follows:
1. The National Pollution Discharge Elimination System (NPDES) requires the City to have
as-built infrastructure network drawings for all storm facilities.
2. The Capacity Management, Operation and Maintenance (CMOM), requires the City to
develop a program to address deficiencies leading to sanitary sewer overflows.
3. The Government Accounting Standards Board (GASB) Statement 34 requires the City to
annually track City assets either by depreciation of value or by reporting maintenance
outlays and providing periodic condition assessments.
Mayor Mullet
Page 2
March 26, 2003
ANALYSIS
The Engineering and Maintenance staff recognized the need to develop a complete as -built GIS record
for City -owned facilities and recommended the following features:
1. Compatible with the existing City GIS System.
2. Record field locations of all visible Survey Monuments and Storm Drainage, Sewer, Water,
and Traffic features.
3. Record available attribute information concerning type, material, condition, year installed
and other information for each feature recorded.
4. Provide a level of accuracy to within 0.3' horizontal and 0.5' vertical.
5. Construct a Microsoft Access database tied to the GIS mapping system. This will allow
changes to be made on the GIS or Access components with the corresponding changes
automatically recorded on the other component. The Access database will contain attribute
information and serve as an inventory listing for all utility components.
6. Phase the citywide inventory to spread the costs over several years.
The Northern Section of the City was selected as the first phase of this effort. The inventory and
mapping for the infrastructure will be performed north of S 115 St and include the entire Ryan Hill
neighborhood. This area was chosen as a "test" area since little infrastructure records are available
and it contains a mix of industrial and residential uses. Future phases may be modified based on
information learned during this phase.
Three consulting engineering firms, Perteet Engineering, PACE, and Earth Tech, were interviewed
with Perteet Engineering rating the highest.
BUDGET
The Storm Water component of this survey requires additional and more detailed information than the
other components of this effort. Therefore, it is recommended that of the $269,715 required for this
effort, $169,715 come from the 412 Fund and the remaining $100,000 come from the 303 Fund.
ALTERNATIVES
State and federal regulations necessitate the record keeping of reliable as -built information and the
tracking of infrastructure assets. These requirements could be met by two different approaches.
1. Minimal Approach
Complete the existing "paper" as -built records system by field inventorying and recording
features on maps, and updating the asset tracking sheets.
Pros
Less initial cost since efforts would be spent on areas where adequate records do not
exist.
Meets the basic needs of the various regulations.
Mayor Mullet
Page 3
March 26, 2003
Cons
Accuracy of the information would not allow for design.
Currently available information has not been kept up to date and contains errors.
Electronic copying, storing, and emailing would not be available since this would
require significantly larger file sizes.
Increased design costs for City as well as developer projects since information is not
readily available in a usable format.
2. GIS and Database Annroach
Conduct a GIS field inventory of the entire City and create an infrastructure database.
Pros
Meets the needs of the various regulations.
Information can be considered very reliable and used for design purposes.
Information can be easily transferred electronically.
1 Easy locating and printing of as -built information for both City and public use.
Cons
Added cost for the more extensive information that would be collected and the
necessity of completing the entire City.
RECOMMENDATION
Authorize a contract with Perteet Engineering, Inc., to provide the North Quadrant GIS Infrastructure
Inventory in the amount of $269,715.00.
RL:ad
file: 02- DR01.3
(P.PVymU -DR PMan\O2DROI'GIS -Bxe0 PW
CONSULTANT AGREEMENT FOR
PROFESSIONAL SERVICES
THIS AGREEMENT is entered into between the City of Tukwila, Washington,
hereinafter referred to as "the City", and Perteet Engineering, Inc. hereinafter referred
to as "the Consultant in consideration of the mutual benefits, terms, and conditions
hereinafter specified.
1. Project Designation. The Consultant is retained by the City to perform engineering
services in connection with the project designated Northern Quadrant GIS
Infrastructure Inventory.
2. Scope of Services. The Consultant agrees to perform the services, identified on
Exhibit "A" attached hereto, including the provision of all labor, materials, equipment
and supplies.
3. Time for Performance Work under this contract shall commence upon the giving
of written notice by the City to the Consultant to proceed. The Consultant shall
perform all services and provide all work product required pursuant to this Agreement
within 180 calendar days from notice to proceed, unless an extension of such time is
granted in writing by the City.
4. Payment. The Consultant shall be paid by the City for completed work and for
services rendered under this Agreement as follows:
A. Payment for the work provided by the Consultant shall be made as provided
on Exhibit `B" attached hereto, provided that the total amount of payment to
the Consultant shall not exceed $269,715 without written authorization.
B. The Consultant may submit vouchers to the City once per month during the
progress of the work for partial payment for that portion of the project
completed to date. Such vouchers will be checked by the City and, upon
approval thereof, payment shall be made to the Consultant in the amount
approved.
C. Final payment of any balance due the Consultant of the total contract price
earned will be made promptly upon its ascertainment and verification by the
City after the completion of the work under this Agreement and its acceptance
by the City.
D. Payment is provided in this section shall be full compensation for work
performed, services rendered, and for all materials, supplies, equipment and
incidentals necessary to complete the work.
E. The Consultant's records and accounts pertaining to this Agreement are to be
kept available for inspection by representatives of the City and state for a
Consultant Agreement for Professional .Services
'Northern Quadrant GIS Infrastructure Inventory
c- r &.uroJO:os GIS mvemocv Conimc.d«
Page I of I
period of three (3) years after final payments. Copies shall be made available
upon request.
5. Ownership and Use of Documents. All documents, drawings, specifications and
other materials produced by the Consultant in connection with the services rendered
under this Agreement shall be the property of the City whether the project for which
they are made is executed or not. The Consultant shall be permitted to retain copies,
including reproducible copies, of drawings and specifications for information,
reference and use in connection with the Consultant's endeavors. The Consultant
shall not be responsible for any use of the said documents, drawings, specifications or
other materials, by the City on any project other than the project specified in this
Agreement.
6. Compliance with Laws. The Consultant shall, in performing the services
contemplated by this A faithfully observe and comply with all federal, state,
and Local laws, ordinances and regulations, applicable to the services to be rendered
under this Agreement.
7. Indemnification. The Consultant shall indemnify, defend and hold harmless the
City, its officers, agents and employees, from and against any and all claims, Losses or
liability, including attorney's fees, arising from injury or death to persons or damage
to property occasioned by any act, omission or failure of the Consultant, its officers,
agents and employees, in performing the work required by this Agreement. With
respect to the performance of this Agreement and as to claims against the City, its
officers, agents and employees, the Consultant expressly waives its immunity under
Title 51 of the Revised Code of Washington, the Industrial Insurance Act, for injuries
to its employees, and agrees that the obligation to indemnify, defend and hold
harmless provided for in this paragraph extends to any claim brought by or on behalf
of any employee of the Consultant. This waiver is mutually negotiated by the parties.
This paragraph shall not apply to any damage resulting from the sole negligence of
the City, its agents and employees. To the extent any of the damages referenced by
this paragraph were caused by or resulted from the concurrent negligence of the City,
its agents or employees, this obligation to indemnify, defend and hold harmless is
valid and enforceable only to the extent of the negligence of the Consultant, its
officers, agents and employees.
8. Insurance. The Consultant shall secure and maintain in force throughout the
duration of this contract comprehensive general liability insurance, with a minimum
coverage of $500,000 per occurrence and $1,000,000 aggregate for personal injury;
and $500,000 per occurrence /aggregate for property damage, and professional
liability insurance in the amount of $1,000,000.
Said general liability policy shall name the City of Tukwila as an additional named
insured and shall include a provision prohibiting cancellation of said policy except
upon thirty (30) days prior written notice to the City. Certificates of coverage as
Consultant Agreement for Professional Services
Northern Quadrant GIS Infrastructure Inventory
C. •T:AIP030105 GIS /n.enmry Comrvndoc
Page 2 of I
required by this section shall be delivered to the City within fifteen (15) days of
execution of this Agreement.
9. Independent Contractor. The Consultant and the City agree that the Consultant is
an independent contractor with respect to the services provided pursuant to this
Agreement. Nothing in this Agreement shall be considered to create the relationship
of employer and employee between the parties hereto. Neither the Consultant nor any
employee of the Consultant shall be entitled to any benefits accorded City employees
by virtue of the services provided under this Agreement. The City shall not be
responsible for withholding or otherwise deducting federal income tax or social
security or for contributing to the state industrial insurance program, otherwise
assuming the duties of an employer with respect to the Consultant, or any employee
of the Consultant.
10. Covenant Against Contingent Fees. The Consultant warrants that he has not
employed or retained any company or person, other than a bonafide employee
working solely for the consultant, to solicit or secure this contract, and that he has not
paid or agreed to pay any company or person, other than a bonafide employee
working solely for the Consultant, any fee, commission, percentage, brokerage fee,
gifts, or any other consideration contingent upon or resulting from the award or
making of this contract. For breach or violation of this warrant, the City shall have
the right to annul this contract without Liability, or in its discretion to deduct from the
contract price or consideration, or otherwise recover, the full amount of such fee,
commission, percentage, brokerage fee, gift or contingent fee.
11. Discrimination Prohibited. The Consultant, with regard to the work performed by it
under this Agreement, will not discriminate on the grounds of race, color, national
origin, religion, creed, age, sex or the presence of any physical or sensory handicap in
the selection and retention of employees or procurement of materials or supplies.
12. Assignment. The Consultant shall not sublet or assign any of the services covered by
this Agreement without the express written consent of the City.
13. Non Waiver. Waiver by the City of any provision of this Agreement or any time
limitation provided for in this Agreement shall not constitute a waiver of any other
provision.
14. Termination.
A. The City reserves the right to terminate this Agreement at any time by giving ten
(10) days written notice to the Consultant.
B. In the event of the death of a member, partner or officer of the consultant, or any
of its supervisory personnel assigned to the project, the surviving members of the
consultant hereby agree to complete the work under the terms of the Agreement,
if requested to do so by the City. This section shall not be a bar to renegotiations
Consultant Agreement for .Professional Services
Northern Quadrant GIS Infrastructure Inventory
e::TEMP010103 GIS Invenm.v Comma.Joc
Page 3 of I I
15. Attorneys Fees and Costs. In the event either party shall bring suit against the other
to enforce any provision of this Agreement, the prevailing party in such suit shall be
entitled to recover its costs, including reasonable attomey's fees, incurred in such shit
from the losing party.
16. Notices. Notices to the City of Tukwila shall be sent to the following address:
17. Integrated Agreement. This agreement, together with attachments or addenda,
represents the entire and integrated Agreement between the City and the Consultant
and supersedes all prior negotiations, representations, or agreements written or oral.
This Agreement may be amended only by written instrument signed by both the City
and the Consultant.
DATED this
of this Agreement between surviving members of the Consultant and the City, if
the City so chooses.
City of Tukwila
6300 Southcenter Boulevard
Tulcwila, WA 98188
Notices to Consultant shall be sent to the following address:
Perteet Engineering, Inc.
2707 Colby Avenue, Suite 900
Everett, WA 98201
CITY OF TUKWILA
Steve Mullet, Mayor
Attest/Authenticated:
Jane E. Cantu, City Clerk
Consultant Agreement for Professional Services
Northern Quadrant GIS Infrastructure Inventory
C7£ItP1OI0:05 GIS Inventory Conrmn.Jnr
day of 20
CONSULTANT
By:
Approved as to Form:
Kevin E. Weed
President
Office of the City Attorney
Page 4 of I I
Exhibit "A"
Scone of Services
City of Tukwila
GIS Based Public Works Infrastructure Inventory
Northern Quadrant
(North of approx. S. 115 St.)
INTRODUCTION
The overall objective of Scope of Services is to provide an inventory and mapping of the
City of Tukwila's public works infrastructure within the northern quadrant of the City.
The inventory and mapping for the infrastructure will be performed in this area within the
public rights -of -way, west of I -5, east of I -5 and north of the Duwamish River.
Additional inventory and mapping east of I -5 will occur where permission for entry can
be obtained from private properties.
Like many agencies that have annexed highly urbanized areas that were formerly
operated and maintained by the county, Tukwila is having difficulties identifying the
Location and complexity of their acquired stormwater system. The stormwater systems in
these areas were previously controlled by King County, and mapping records for these
systems never existed, were lost, or never passed on to the City when annexation
occurred. This condition is the most prevalent in the area surrounding East Marginal Way
in the northem quadrant of the City. Due to the lack of good stormwater system mapping
and inventories in this area, it has been selected to be the first neighborhood to receive a
concerted stormwater system mapping and geographic information system (GIS)
development effort. The program developed for the north city area will set the foundation
for a citywide stormwater mapping and GIS. As the inventory of the stormwater system
is being performed in the study area, additional surface features within the right -of -way
such as the City's water, sanitary sewer, and street infrastructure system will be captured.
The additional mapping of these facilities will allow for detailed information for these
facilities to be added at a later date.
Key to the success of the project is the thorough design of a data capture and storage
system that will blend seamlessly with the City's existing GIS as well as be expandable
for integrating future information or integration with maintenance and management
software.
Consultant Agreement for Professional Services
Northern Quadrant GIS Infrastructure Inventory
C:. TEAP.o)o :os GIS Immrom Co.rman.oc
Page S of
The work under this agreement will be accomplished under the following elements of
work:
SCOPE OF SERVICES
1.0 Management Coordination /Administration
1.1. Provide continuous project management administration (billing invoices,
monthly progress reports) throughout the project's field data acquisition and GIS
development.
1.2. Develop project schedule. Schedule to be updated by the Consultant at the City's
direction as needed.
1.3. Attend twice monthly coordination meetings with City staff and prepare meeting
minutes. It is assumed that a total of 12 meetings will be required and additional
meetings, at the City's direction, will be considered additional work
1.4. Prepare independent QA/QC reviews.
1.5. Coordination of Sub consultants.
2.0 Project Planning
2.1. The Consultant analyst will schedule and lead the Project Kickoff and Planning
meeting prior to the start of field data collection. This session will focus on the
final identification of features and feature attributes to be collected by field
survey crews. In addition, planning for future uses of the utility and street
inventory will be discussed. From this session, the Consultant will prescribe a
database template that will be used in the GPS data dictionaries for seamless
transfer to the GIS via MS Access. This process will allow the Consultant to
develop a comprehensive geo- database structure that will support both short and
long term GIS database inventory needs of the City.
2.2. With the assistance of the City, a geographically bounded "test" area and four to
five additional product delivery sub -areas will be defined. The field inventory,
database /GIS, and output product for the test area will receive a QA/QC review
by the Consultant and then be submitted to the City for review and comment.
Upon receipt of the comments from the City modifications of the field inventory,
database /GIS and/or project output will be made prior to proceeding to the
subsequent geographic areas. Following the Consultant's QA/QC review
subsequent submittals to the City will be made as each geographic area is
completed.
2.3. The Consultant with input from the City will develop a custom "data dictionary"
that will provide systematic inventory data fields for the field survey crews to
complete during the field survey.
2.4. Survey "styles" that define the accuracy requirements for the specific inventory
items will be determined with the assistance of the City in conjunction of the data
dictionary.
2.5. Acquire from the City both a hard copy and electronic mapping that is readily
available from King County, WSDOT and Boeing that show the infrastructure
features that will be inventoried within their geographical areas. Electronic
mapped stormwater features and data from these agencies that are outside of the
Consultant Agreement for Professional Services
Northern Quadrant GIS Infrastructure Inventory
C.ITE..IP030201 GIS Inventory Conwadoc
Page 6 of 11
City's rights -of -way will be incorporated into the City's GIS based utility
inventory.
3.0 Field Data Acquisition
3.1. Assumptions:
3.1.1. Elevations will be referenced to NAVD "88" datum.
3.1.2. We estimate that 90% of inventory data will be acquired by GPS, the
remainder will be by traditional optical equipment based upon GPS control
points.
3.1.3. It is anticipated that the Consultant will not be required to enter confined
spaces in order to collect survey data. If the Consultant is required by the
City to enter confined spaces all labor and equipment for entry will be billed
as "extra work
3.1.4. Only visible or easily recovered features will be surveyed.
3.1.5. City of Tukwila will ensure access to all private properties required for the
survey.
3.2. Water System Survey:
3.2.1. The following visible water system appurtenances will be located by GPS
or Optical survey: center of main valve boxes, service valve boxes, and
hydrants; FDC (at base of wall), center of nut on PW, WIV (at base of wall),
Meter Box, water vaults, base of Air Relief Valve vent pipe and center of
manholes.
3.3. Sanitary Sewer System Survey:
3.3.1. The following visible Sanitary Sewer system appurtenances will be
located by GPS or Optical survey: center of manhole, manhole rim, center of
vault (access), invert elevation, pipe size and material, cleanouts, center of
pump station access point and base of any electrical service panels for the
sanitary system.
3.4. Storm System Survey:
3.4.1. The following visible Storm Sewer system appurtenances will be located
by GPS or Optical survey: manhole and catch basins, including invert
elevations, pipe sizes, material and direction of flow, culvert outfalls, ponds,
ditches and swales.
3.5. Traffic and lighting system Survey:
3.5.1. The following visible Traffic system appurtenances will be located by
GPS or Optical survey: base of signal poles, base of ped poles, base of ped
push- button posts, center of J boxes and signal vaults, base at front of signal
cabinet, base at front of electrical service cabinet, and base of pole for all
luminaires.
3.5.2. Field maps prepared by TerraLogic will be used to conduct a "windshield
survey" to determine the approximate length of the study area roadway
segments and classify them by their apparent material type and lane
configuration.
3.5.3. Field maps prepared by TerraLogic will be used to conduct a "windshield
survey" to determine the approximate length of the study area sidewalk
segments and classify them by their apparent material type and width.
Consultant Agreement for Professional Services Page 7 of II
Northern Quadrant GIS Infrastructure Inventory
C'SEt1P010701 a!S lnvrnrory Comrna+lx
3.6. Monument Survey:
3.6.1.. Perform Global Position System (GPS) Real -time Kinematic (RTK)
survey locating visible street monuments adjacent to utility inventory
locations. No exhaustive investigation, reconnaissance or research will be
performed to recover all of the street monuments.
3.7. Documentation:
3.7.1. NAD 83 (91) coordinates (accurate to 0.10') of all street monuments
recovered will be included in the geo- database.
4.0 GIS Data Development
4.1. Support Field Data Acquisition
4.1.1. Implement protocols for weekly transfer of field collected information
from GPS to GIS.
4.1.2. Ensure transfers are complete and conform to data dictionary design as
prescribed in the Project Planning phase.
4.2. Data Development and Drainage Network Construction
4.2.1. Feature locations and their attributes will be modeled as points for all
Water, Sewer, and Street features.
4.2.2. Stormwater features will be developed into a comprehensive drainage
network.
4.2.3. Convert two (2) digital CAD files of the Boeing Facility and one (1)
digital CAD file of the King County Airport into GIS for inclusion into the
geo database. These files will be geo- referenced based on the City's digital
orthophotos. Stormwater, water, sewer, and street features will be converted
and attributed with information readily available in the digital CAD files.
4.2.4. Computer automated and manual QA/QC procedures will be used to
detect flow anomalies, missing features, and other potential errors. These
errors will be fixed in GIS where possible or will be returned to the survey
team for further research.
4.2.5. Each sub -area data will be provided to City staff on a regular basis to
allow for a final tier of QA/QC. Data will be made available for download
off a secure web -site or provided to the City in an alternate fashion.
4.3. Geo- database Development
4.3.1. The Drainage Network and other point data constructed in Task 4.2 will
be compiled into a "Personal Geo database Format This format provides
several benefits in the use and long -term management of the Infrastructure
Inventory Data. The personal geo database will implement a MS Access
back -end and seamless access via ESRI products (ArcGIS, ArcView, and
ARCIMS).
NOTE ABOUT GEO- DATABASE: The ArcGIS v. 8.X already used by the City can easily
convert the delivered data products in geo database format to a shapefile format for use in
earlier versions of ArcView or for use in ArcExplorer (the free GIS software from ESRI). It
can also convert to AutoCAD format; however some of the attributes compiled in Geo
database may be lost. On the other hand, the geo database is NOT directly accessed by the
ArcReader free map viewer. ArcReader can only read a PMF (portable map file) that is
Consultant Agreement for Professional Services Page 8 of I I
Northern Quadrant GIS Infrastructure Inventory
C' TEMP 030.:01 GIS Imeneory Conemn.doe
created using the ArcPublisher extension. This extension is purchased separately by ArcGIS
users. The Consultant will provide PMF files of all its map product deliverables to the City;
however, for future internal development of maps, the City may consider purchasing the
ArcPublisher extension if the PMF format works well for them.
4.3.2. The Consultant will work directly with City staff to create fields and
records within the database that will assist the City in addressing the current
known reporting requirements of GASB -34 and NPDES Phase II. The
database will be designed with the ability to be modified/revised to
accommodate future requirements of these mandates.
4.3.3. TerraLogic will review the existing GIS road and sidewalk information
developed from existing planimetric drawings and the 1999 Triathlon aerial
photography. From these, we will extract number of road lanes, sidewalk
lengths, and significant changes to sidewalk width. The remaining attributes
of shoulder type and road/sidewalk materials will be verified by a
windshield survey. TerraLogic will convert the road centerline layer
currently used by the City into a linear referencing system. This allows the
City to track and query multiple layers of road information along individual
blocks or road lengths
4.3.4. In compiling the geo database, TerraLogic will develop the following geo
database parameters:
4.3.4.1.Network geometry will be defined to identify the real -world
coincidence of drainage network features (complex edges and
junctions).
4.3.4.2.Connectivity rules based on physical characteristics of the drainage
network will be defined (pipes must have catchments, at least on one
end, etc.).
4.3.4.3.Data domains and subtypes will be identified and programmed into
geo database. This means that the Consultant will identify all possible
values for each attribute type, and that List of possible values will be
coded into geo- database to ensure consistent data entry in the future,
and prevent the entry of illogical values. For instance, there may be
only four possible sewer pipe materials. Once these four types are
coded as the "domain" for the "material" field, then the user will not be
allowed to enter a material type not on that list. This is also handy in
preventing misspellings during data entry that can cause problems in
the City's later data queries.
4.3.4.4.Table relationship classes will be built to connect spatial features to
their attribute information. This suggests that several of the attributes
may be stored in tables separate from the attribute tables directly linked
to the spatial features. Therefore, the Consultant will code into the geo
database the relationship parameters to seamlessly link the remote
tables with the spatial attribute tables. This will allow the user to
quickly recreate these relationships in the ArcGIS environment, and be
able to perfonn spatial queries and create thematic maps using
attributes from the related table.
Consultant Agreement for Professional Services
Northern Quadrant GIS Infrastructure Inventory
C SJIPOlo:OJ CIS lmmmry Conmm.doc
Page 9 of I I
4.3.4.5.Attribute validation rules (coded values and data ranges) will be
identified by City and consultant staff and programmed into the geo-
database attribute tables by the Consultant.
4.3.4.5.1. TerraLogic will program a process to translate the data
inventoried in Tasks 3.5.2 3.5.3 to GIS features attached to the
referenced road centerline layer. The process will be semi
automated with some manual interpretation of feature locations by
an analyst. The road and sidewalk features will be organized into
the geodatabase created for the water /sewer inventory, thus
building the foundation for a fully integrated GIS for all public
works operations.
4.4. Map Production
4.4.1. Hard copy maps of the completed inventory will be developed in ArcMap.
This will include a basemap image of the project study area using GIS data
provided by the City. The map will depict the drainage network with as
many physical attributes that can be displayed without blurring the map
image. The map will be compiled in both a poster -size (E) as well as an
11x17 format. One (1) draft and one (1) final submission of each hardcopy
map will be provided to the City. Duplicate copies will be provided at an
additional cost.
4.5. Documentation and Delivery
4.5.1. FGDC Compliant metadata will be developed and will accompany every
feature dataset created in this scope of work. The metadata will outline the
creation process as well as the spatial and feature attribute definitions. The
form will be seamlessly linked to the layers in ArcGIS using the metadata kit
provided with the software.
4.5.2. A recommended data management strategy will be written and provided to
the City. This will offer suggestions on future expansion of the database.
4.5.3. The geo- database, including all GIS data layers created by the Consultant,
and ArcGIS project file, and digital metafiles of the map graphics, will be
placed on CD -ROM. A single copy of the CD will be sent to both the City
and Perteet as a final product.
Deliverables
Copies of field notes.
Infrastructure Geo- database including all GIS data layers created by the
Consultant, an ArcGIS project file, and digital metafiles of the map graphics.
One set of hardcopy maps in both Poster and 11 x 17 format.
A "PMF" version of each hardcopy map for general use by City Staff that use
the free ArcReader software.
Consultant Agreement for Professional Services
Northern Quadrant GIS Infrastructure Inventory.
C;TE. IrOJOJOS GIS Inventory Conrrvcadoc
Page 10 of I I
Project: GIS Infrastructure Inventory
Client: Tukwila
EXHIBIT B
CONSULTANT FEE DETERMINATION
Classification Hours Rate Cost
Principal -In- Charge 8 x $165.00 31,320
Sr. Associate 124 x $145.00 317,980
Project Engineer 8 x $120.00 3960
CPA 8 x 3110.00 3880
Principal Surveyor 90 x $140.00 512,600
Senior Professional Land Surveyor 90 x $130.00 511,700
Professional Land Surveyor 48 x $95.00 54,560
Two Person Survey Crew 380 x $145.00 555,100
Three Person Survey Crew 90 x $195.00 317,550
Project Surveyor 368 x $85.00 531,280
Survey Tech 8 x $70.00 3560
Clerical /Survey Assistant 68 x $60.00 54,080
TOTAL HOURLY COST 5158,570
REIMBURSABLES:
RTK GPS Receivers ($400 /day) $14,800
Total Station ($100 /day) $600
Misc. $1,006
Mileage 0.365/mi. $2,044
Attenuator Truck ($1,700 /mo) $2,200
Boat Rental ($300 /day) $900
REIMBURSABLES TOTAL
521,550
SUBCONSULTANT COSTS: $81,450
mark up 10% $8,145
SUBCONSULTANT TOTAL 589,595
Prepared By: Mt- lit- o or,mn n
MAXBNIUM COMPENSATION $269,715
Date: 2- I Sf -d
Utilities Committee
April 8, 2003
Present: Pam Linder, Chair; Joan Hernandez, Dave Fenton
Jim Morrow, Frank Iriarte, Brian Shelton, Ryan Larson, Gail Labanara, Tom
Pulford, Lucy Lauterbach
1. Public Works Trust Fund Loan The City submitted a $100,000 loan request to the Public
Works Trust Fund (PWTF). They have received that loan, and the City is being asked to accept
it. It will be used along with CDBG biock grant funding to design the needed drainage
improvements in Cascade View. They hope to get a loan to do construction next year. Ryan
drove to Olympia to turn in the loan application, finding out later he had even more time to do it.
Ryan gave information about his other project, TIB, which is going well. There have been some
complaints about debris on and off the road, and the work being done for storm water lines. The
work for the storm drains is 70% complete. When that's done, the power lines will go in.
Recommend City accent $100.000 PWTF loan.
2. GIS -based Infrastructure Inventory Public Works has agreed to a contract with Perteet to
do a global positioning study of the area north of S. 115` in Allentown, including Ryan Hill and
East Marginal Way. The annexed areas of the city don't have good drawings of the
infrastructure, and it makes building difficult for contractors. It will also let our crews know
where the outfalls and catch basins are for maintenance. $100,000 in funding will come from the
303 (Facility maintenance) fund and $169,715 will come from Surface Water. Dave asked if
connectivity could be part of this study, and was told it could not be as they're looking for metal
pipes only. A year ago the city called for consultants to present the information they would
gather in a study like this, and Perteet was the clear winner. The only disadvantage of doing this
is that it costs $269,715, and is only a small portion of the whole city. Move authorization for
contract with Perteet engineering to nrovide infrastructure inventory to Regular Meeting.
3. Lower City Hall Entrance Work The northwest entrance to city hall with the deck is rotted
and falling apart. The low bid did not include all the work that eventually needed to be done. It
turned out that with the change orders, the eventual cost equaled the two higher bidders. What
was first thought to be a small improvement turned in to a much larger job, with rot, previous
cheap work, and insect damage all beyond what was known up- front. The project will be paid
out of the 303 facility improvement fund. Dave and Joan wanted to know how this would affect
the project of updating Council chambers. Jim M explained that there is a list of action items, a
list of design items, and a list of needed but not scheduled items. The Council chamber is at the
top of the design list. Another item Jim mentioned was the possibility of hiring a reliable and
decent painting firm to do city projects for a year. Though it would cost more, it would result in
higher satisfaction with painting jobs rather than relying on low bids that often do unsatisfactory
work. Recommend change order to Council for aooroval.