03/14/2012 - Packet Intergovernmental Water Board Agenda
SERVING TIGARD,KING CITY,DURHAM AND TIGARD WATER DISTRICT
MEETING DATE: Wednesday, March 14, 2012, 5:30 p.m.
MEETING LOCATION: Tigard Public Works Building
8777 SW Burnham Street
Tigard, OR 97223
1. Call to Order, Roll Call and Introductions
2. Approval of Minutes — February 8, 2012
Action: Motion to approve the February 8, 2012 minutes.
3. Public Comments
Call for comments from the public.
4. Water Supply Update -John Goodrich
No action required.
5. Member-At-Large Interviews — Dennis Koellermeier
■ 5:45 p.m. - Mr. Andrew Barrett
■ 6 p.m. - Mr. Bradley Anderson
Action: No action required; the board will consider appointing a member-at-large at its next meeting.
6. Update on the Status of the Draft Intergovernmental Agreement for Delivery of Water Service —
Dennis Koellermeier
No action required.
7. Informational Items
8. Non-Agenda Items
Call for non-agenda items from the Board.
9. Next Meeting:
■ April 11, 2012 at 5:30 p.m.
Public Works Auditorium, 8777 SW Burnham Street, Tigard, Oregon
10. Adjournment
Action: Motion for adjournment.
INTERGOVERNMENTAL WATER BOARD AGENDA— March 14, 2012
City of Tigard 1 13125 SW Hall Blvd.,Tigard,OR 97223 1 503-718-2591 1 www.tigard-or.gov I Page 1 of2
Executive Session
The Intergovernmental Water Board may go into Executive Session. If an Executive Session is called to
order, the appropriate ORS citation will be announced identifying the applicable statute. All discussions
are confidential and those present may disclose nothing from the Session. Representatives of the news
media are allowed to attend Executive Sessions, as provided by ORS 192.660(4), but must not disclose
any information discussed. No Executive Session may be held for the purpose of taking any final action or
making any final decision. Executive Sessions are closed to the public.
INTERGOVERNMENTAL WATER BOARD AGENDA— March 14, 2012
City of Tigard 1 13125 SW Hall Blvd.,Tigard,OR 97223 1 503-718-2591 1 www.tigard-or.gov I Page 2 oft
Agenda Item No.: �-
IWB Meeting Date: f fiRC ly. 20lL _
Intergovernmental Water Board JWB) Minutes
SERVING TIGARD, KING CITY,DURHAM AND TIGARD WATER DISTRICT
MEETING DATE: Wednesday, February 8, 2012 5:30 p.m.
MEETING LOCATION: Tigard Public Works Building
8777 SW Burnham Street
Tigard, OR 97223
Members Present:
Gretchen Buchner Representing the City of Tigard
Ken Henschel Representing the Tigard Water District
Chris Hadfield Alternate - Representing the City of Durham
Dick Winn Representing the City of King City
Vacant Member-At-Large
Members Absent:
Keith Jehnke Representing the City of Durham
City of Tigard Staff Present:
Dennis Koellermeier Public Works Director
John Goodrich Utility Division Manager
Greer Gaston IWB Recorder
1. Call to Order, Roll Call and Introductions
Commissioner Winn called the meeting to order at 5:30 p.m.
2. Approval of Minutes —December 14, 2011
Commissioner Buehner moved to approve the December 14, 2011 minutes.
Commissioner Henschel seconded the motion. The motion passed by unanimous vote
of the commissioners present, with Commissioners Buehner, Hadfield, Henschel and
Winn voting yes.
3. Public Comments
There were no comments from the public.
4. Water Supply Update
Mr. Goodrich reported:
■ Average water use for the month of January was about 4 million gallons per day
(mgd). This is comparable to usage during the same time period last year.
■ 167 million gallons of water are stored in two aquifer storage and recovery (ASR)
wells. Tigard has started injection into ASR well #2.
■ Increased turbidity in the Bull Run Watershed forced Portland to switch to its
well fields for a time. The turbidity may have resulted from a slide caused by
heavy rain.
■ Portland wholesale water costs will increase 11 percent next year. Tigard
budgeted for a 10 percent increase and also has a contingency; funds should be
sufficient to cover costs.
5. David Guardino Credit for Leak Request
Mr. Goodrich provided background information on this credit for leak request. Credits
over $500 must be approved by the board.
Commissioner Buehner moved to approve the credit as noted on the request form.
Commissioner Henschel seconded the motion. The motion passed by unanimous vote
of the commissioners present, with Commissioners Buehner, Hadfield, Henschel and
Winn voting yes.
6. Election of Chair and Vice-Chair— Dennis Koellermeier
Mr. Koellermeier informed the commissioners that they were required to appoint a Chair
and Vice-Chair at their February meeting each year.
Commissioner Buehner nominated Commissioner Winn to serve as Chair.
Commissioner Henschel seconded the nomination. Commissioner Winn was appointed
to serve as the Chair by unanimous vote of the commissioners present, with
Commissioners Buehner, Hadfield, Henschel and Winn voting yes.
Commissioner Winn nominated Commissioner Buehner for Vice-Chair. Commissioner
Henschel seconded the nomination. Commissioner Buehner was appointed to serve as
the Vice-Chair by a unanimous vote of the commissioners present, with Commissioners
Buehner, Hadfield, Henschel and Winn voting yes.
7. Update on Member-At-Large Position Recruitment
Ms. Gaston reported two people had submitted applications to date. The deadline for
applications is February 13. She summarized how the position was advertised. Once the
position has closed, the applications and a scoring matrix will be sent to board members.
Provided the number of candidates is small, board consensus was to interview each
candidate. The board discussed possible interview questions and how interviews might
be conducted.
8. Briefing on a Grant Application to Partially Fund ASR #3 Well Head
Improvements
Mr. Goodrich summarized a memo in the board's packet materials. He provided the
following additional information.
■ The grant is through the Bureau of Reclamation.
■ It is a competitive grant available for projects in western states.
■ Total grant funds are $18 million; $750,000 was the maximum award Tigard could
apply for.
The Tigard City Council has to approve the submission of grant applications.
Commissioner Buehner suggested the board could provide a recommendation to the
council regarding its support of the grant application.
Commissioner Henschel moved for the I" to recommend that the City of Tigard
applies for the $750,000 grant. Commissioner Winn seconded the motion. The motion
passed by unanimous vote of the commissioners present, with Commissioners Buehner,
Hadfield, Henschel and Winn voting yes.
9. Update on the Lake Oswego-Tigard Water Partnership
Mr. Koellermeier provided the following information on the water partnership.
■ Six design firms are working on various water partnership projects.
■ All design work is underway and will hopefully be at the 30 percent level in late
February or early March. Cost updates will follow.
■ Once 30-percent designs are completed, an Oversight Committee meeting will
take place, likely in April. This will be followed by a joint Lake Oswego-Tigard
City Council meeting in late April or May.
■ The land use application for the water treatment plant was submitted to the City
of West Linn.
■ Projects are not as far along on the spending curve as anticipated, so the
partnership is currently under budget.
■ A full update from the partnership will be provided to the IWB in the spring or
early summer.
■ Outcomes from the pilot treatment plant testing will be available soon.
■ The case with WaterWatch is on schedule to proceed through the court of
appeals. Commissioner Buehner added that the date the case will be argued
should be determined in April.
■ Following the submission of the land use application, which included the good
neighbor plan, the partnership will let the land use process run its course and see
what conditions are required with regard to the Robinwood neighborhood. This
will help identify what improvements are appropriate, given the treatment plant's
impact on the neighborhood.
■ The City of Lake Oswego passed resolution of necessity to remove a sentence
from the Robinwood Neighborhood's Covenants, Conditions and Restrictions
(CC&Rs) pertaining to the treatment plant property. Two appraisers have said the
dollar value of the change to the CC&Rs is zero.
■ In late March Tigard staff will travel to San Francisco to obtain its municipal
bond rating. Bonds will be used to fund the Lake Oswego-Tigard Water
Partnership projects.
10. Informational Items
■ Update from Commissioner Buchner on Lake Oswego/City of Tigard Oversight
Committee activities.
- There was a problem with the water intake along the Clackamas River, and
West Linn's water supply shut down. Lake Oswego supplied West Linn with
emergency water during the shutdown.
- The committee's next meeting is Monday, February 13 in the West End
Building.
■ Update from Commissioner Buchner on the Willamette River Water Coalition
(WRWC) and the Regional Water Providers Consortium (RV/TC).
- Commissioner Buchner noted she received two memos prepared for the
RWPC on interties. She forwarded the memos for Ms. Gaston to distribute to
the board. These memos are also on file in the IWB record.
- The WRWC is trying to obtain an easement to run a pipeline through Graham
Oaks Nature Park. The Metro-owned park is located near Wilsonville. Mr.
Koellermeier explained the pipeline will transmit water from the Wilsonville
treatment plant to the Beaverton and Tualatin Valley Water District service
areas. Generally, the pipeline will be routed along Roy Rogers Road. If Metro
requires the pipeline be constructed now, Tigard would need to decide
whether it wants to share in the cost of construction.
11. Non-Agenda Items
Commissioner Henschel inquired how customers contacted Tigard regarding water
issues or problems that occurred outside regular business hours. Mr. Koellermeier said
customers should call 911 for water-related security issues. For other problems,
customers should call the Public Works Department after-hours phone number
(503.639.1554). The number is staffed during non-business hours and is published in
customers'water bills and in the KnowH2O newsletter.
Commissioner Henschel inquired about the status of the intergovernmental agreement.
Mr. Koellermeier said he would update the I" on the agreement at the next meeting.
Commissioner Buchner invited the commissioners to attend the joint Lake Oswego-
Tigard council meeting. A meeting date has not been determined. The commissioners
asked to be notified of upcoming meeting dates.
12. Next Meeting
March 14, 2012 at 5:30 p.m.
Public Works Auditorium, 8777 SW Burnham Street, Tigard, Oregon
Mr. Koellermeier said the water system budget and the water system portion of Tigard's
Capital Improvement Plan will be presented at the board's upcoming March or April
meeting. Scheduling these items between Tigard Budget Committee meetings and Tigard
City Council meetings is always a challenge. The board's advice and recommendations
will be forwarded to the committee and the Tigard City Council.
Commissioner Buehner said she will not attend next IVB meeting, as she will be at a
conference.
13. Adjournment
At 7:03 p.m. Commissioner Henschel moved to adjourn the meeting. Commissioner
Buehner seconded the motion. The meeting adjourned by unanimous vote of the
commissioners present, with Commissioners Buehner, Hadfield, Henschel, and Winn
voting yes.
Dick Winn, IWB Chair Greer Gaston, IWB Recorder
Date: Date:
Intergovernmental Water Board JWB) Minute s
SERVING TIGARD,KING CITY,DURHAM AND TIGARD WATER DISTRICT
MEETING DATE: Wednesday, February 8, 2012 5:30 p.m.
MEETING LOCATION: Tigard Public Works Building
8777 SW Burnham Street
Tigard, OR 97223
Members Present:
Gretchen Buehner Representing the City of Tigard
Ken Henschel Representing the Tigard Water District
Chris Hadfield Alternate - Representing the City of Durham
Dick Winn Representing the City of King City
Vacant Member-At-Large
Members Absent:
Keith Jehnke Representing the City of Durham
City of Tigard Staff Present:
Dennis Koellermeier Public Works Director
John Goodrich Utility Division Manager
Greer Gaston IWB Recorder
1. Call to Order, Roll Call and Introductions
Commissioner Winn called the meeting to order at 5:30 p.m.
2. Approval of Minutes — December 14, 2011
Commissioner Buehner moved to approve the December 14, 2011 minutes.
Commissioner Henschel seconded the motion. The motion passed by unanimous vote
of the commissioners present,with Commissioners Buehner, Hadfield, Henschel and
Winn voting yes.
3. Public Comments
There were no comments from the public.
4. Water Supply Update
Mr. Goodrich reported:
■ Average water use for the month of January was about 4 million gallons per day
(mgd). This is comparable to usage during the same time period last year.
■ 167 million gallons of water are stored in two aquifer storage and recovery (ASR)
wells. Tigard has started injection into ASR well #2.
■ Increased turbidity in the Bull Run Watershed forced Portland to switch to its
well fields for a time. The turbidity may have resulted from a slide caused by
heavy rain.
■ Portland wholesale water costs will increase 11 percent next year. Tigard
budgeted for a 10 percent increase and also has a contingency; funds should be
sufficient to cover costs.
5. David Guardino Credit for Leak Request
Mr. Goodrich provided background information on this credit for leak request. Credits
over $500 must be approved by the board.
Commissioner Buchner moved to approve the credit as noted on the request form.
Conunissioner Henschel seconded the motion. The motion passed by unanimous vote
of the commissioners present, with Commissioners Buchner, Hadfield, Henschel and
Winn voting yes.
6. Election of Chair and Vice-Chair—Dennis Koellermeier
Mr. Koellermeier informed the commissioners that they were required to appoint a Chair
and Vice-Chair at their February meeting each year.
Commissioner Buchner nominated Commissioner Winn to serve as Chair.
Commissioner Henschel seconded the nomination. Commissioner Winn was appointed
to serve as the Chair by unanimous vote of the commissioners present, with
Commissioners Buchner, Hadfield, Henschel and Winn voting yes.
Commissioner Winn nominated Commissioner Buchner for Vice-Chair. Commissioner
Henschel seconded the nomination. Commissioner Buchner was appointed to serve as
the Vice-Chair by a unanimous vote of the commissioners present, with Commissioners
Buchner, Hadfield, Henschel and Winn voting yes.
7. Update on Member-At-Large Position Recruitment
Ms. Gaston reported two people had submitted applications to date. The deadline for
applications is February 13. She summarized how the position was advertised. Once the
position has closed, the applications and a scoring matrix will be sent to board members.
Provided the number of candidates is small, board consensus was to interview each
candidate. The board discussed possible interview questions and how interviews might
be conducted.
8. Briefing on a Grant Application to Partially Fund ASR #3 Well Head
Improvements
Mr. Goodrich summarized a memo in the board's packet materials. He provided the
following additional information.
0 The grant is through the Bureau of Reclamation.
■ It is a competitive grant available for projects in western states.
■ Total grant funds are $18 million; $750,000 was the maximum award Tigard could
apply for.
The Tigard City Council has to approve the submission of grant applications.
Commissioner Buehner suggested the board could provide a recommendation to the
council regarding its support of the grant application.
Commissioner Henschel moved for the IWB to recommend that the City of Tigard
applies for the $750,000 grant. Commissioner Winn seconded the motion. The motion
passed by unanimous vote of the commissioners present, with Commissioners Buehner,
Hadfield, Henschel and Winn voting yes.
9. Update on the Lake Oswego-Tigard Water Partnership
Mr. Koellermeier provided the following information on the water partnership.
■ Six design firms are working on various water partnership projects.
■ All design work is underway and will hopefully be at the 30 percent level in late
February or early March. Cost updates will follow.
■ Once 30-percent designs are completed, an Oversight Committee meeting will
take place, likely in April. This will be followed by a joint Lake Oswego-Tigard
City Council meeting in late April or May.
■ The land use application for the water treatment plant was submitted to the City
of West Linn.
■ Projects are not as far along on the spending curve as anticipated, so the
partnership is currently under budget.
■ A full update from the partnership will be provided to the IWB in the spring or
early summer.
■ Outcomes from the pilot treatment plant testing will be available soon.
■ The case with WaterWatch is on schedule to proceed through the court of
appeals. Commissioner Buehner added that the date the case will be argued
should be determined in April.
■ Following the submission of the land use application,which included the good
neighbor plan, the partnership will let the land use process run its course and see
what conditions are required with regard to the Robinwood neighborhood. This
will help identify what improvements are appropriate, given the treatment plant's
impact on the neighborhood.
■ The City of Lake Oswego passed resolution of necessity to remove a sentence
from the Robinwood Neighborhood's Covenants, Conditions and Restrictions
(CC&Rs) pertaining to the treatment plant property. Two appraisers have said the
dollar value of the change to the CC&Rs is zero.
■ In late March Tigard staff will travel to San Francisco to obtain its municipal
bond rating. Bonds will be used to fund the Lake Oswego-Tigard Water
Partnership projects.
10. Informational Items
■ Update from Commissioner Buchner on Lake Oswego/City of Tigard Oversight
Committee activities.
- There was a problem with the water intake along the Clackamas River, and
West Linn's water supply shut down. Lake Oswego supplied West Linn with
emergency water during the shutdown.
- The committee's next meeting is Monday, February 13 in the West End
Building.
• Update from Commissioner Buchner on the Willamette River Water Coalition
(WRWC) and the Regional Water Providers Consortium (RWPC).
- Commissioner Buchner noted she received two memos prepared for the
RWPC on interties. She forwarded the memos for Ms. Gaston to distribute to
the board. These memos are also on file in the IWB record.
- The WRWC is trying to obtain an easement to run a pipeline through Graham
Oaks Nature Park. The Metro-owned park is located near Wilsonville. Mr.
Koellermeier explained the pipeline will transmit water from the Wilsonville
treatment plant to the Beaverton and Tualatin Valley Water District service
areas. Generally, the pipeline will be routed along Roy Rogers Road. If Metro
requires the pipeline be constructed now, Tigard would need to decide
whether it wants to share in the cost of construction.
11. Non-Agenda Items
Commissioner Henschel inquired how customers contacted Tigard regarding water
issues or problems that occurred outside regular business hours. Mr. Koellermeier said
customers should call 911 for water-related security issues. For other problems,
customers should call the Public Works Department after-hours phone number
(503.639.1554). The number is staffed during non-business hours and is published in
customers'water bills and in the KnowH2O newsletter.
Commissioner Henschel inquired about the status of the intergovernmental agreement.
Mr. Koellermeier said he would update the IWB on the agreement at the next meeting.
Commissioner Buchner invited the commissioners to attend the joint Lake Oswego-
Tigard council meeting. A meeting date has not been determined. The commissioners
asked to be notified of upcoming meeting dates.
12. Next Meeting
March 14, 2012 at 5:30 p.m.
Public Works Auditorium, 8777 SW Burnham Street, Tigard, Oregon
Mr. Koellermeier said the water system budget and the water system portion of Tigard's
Capital Improvement Plan will be presented at the board's upcoming March or April
meeting. Scheduling these items between Tigard Budget Committee meetings and Tigard
City Council meetings is always a challenge. The board's advice and recommendations
will be forwarded to the committee and the Tigard City Council.
Commissioner Buehner said she will not attend next IWB meeting, as she will be at a
conference.
13. Adjournment
At 7:03 p.m. Commissioner Henschel moved to adjourn the meeting. Commissioner
Buehner seconded the motion. The meeting adjourned by unanimous vote of the
commissioners present, with Commissioners Buehner, Hadfield, Henschel, and Winn
voting yes.
Dick Winn, IWB Chair Greer Gaston, IWB Recorder
Date: Date:
Agenda Item No.:
IWB Meeting Date: 2UlZ---
- City of Tigard
Memorandum
To: Intergovernmental Water Board (IWB) Commissioners
From: Office Manager Greer Gaston
Re: Selection of the Member-At-Large
Date: March 6, 2012
At the IWB's February 8, 2012, meeting, the board outlined the following process to fill the
IWB's member-at-large position.
Task Date Completed
or Scheduled
Via email, applications, draft interview questions and scoring February 21, 2012
matrix sent to commissioners.
Deadline for commissioners to submit edits/additions to draft February 27, 2012
interview questions and scoring matrix. No comments received.
Interview and rank candidates using interview questions and March 14, 2012
—
scoring matrix.
Staff will total candidate scores and inform the commissioners of March 15, 2012
their selection.
Staff will inform candidates of the board's selection. March 15, 2012
Selected candidate formally appointed to the board as the April 11, 2012
member-at-large.
Intergovernmental Water Board
Member-At-Large Interview Questions/Scoring Matrix
Wednesday, March 14, 2012 IWB Commissioner:
Interviewee: Mr. Andrew Barrett— 5:45 p.m.
Criteria Interview Questions Rating
Vision 1. Why are you interested in serving on the board and are there any (10 Points Max)
particular water-related issues you are interested in?
Availability 2. Are you able to attend IWB meetings held at 5:30 p.m. on the (10 Points Max)
second Wednesday of each month?
Knowledge/ 3. Please describe your knowledge and/or experience as it pertains (10 Points Max)
Experience to:
- Water system operations.
- City government.
- Serving on a board or committee.
Interviewee: Mr. Bradley Anderson — 6 p.m.
Criteria Interview Questions Rating
Vision 1. Why are you interested in serving on the board and are there any (10 Points Max)
particular water-related issues you are interested in?
Availability 2. Are you able to attend IWB meetings held at 5:30 p.m. on the (10 Points Max)
second Wednesday of each month?
Knowledge/ 3. Please describe your knowledge and/or experience as it pertains (10 Points Max)
Experience to:
- Water system operations.
- City government.
- Serving on a board or committee.
INTERGOVERNMENTAL WATER BOARD (IWB) COMMISSIONER
AT-LARGE MEMBER VOLUNTEER POSITION DESCRIPTION
(2-year term)
IWB Background: The Tigard Water Service Area (TWSA) includes the cities of Durham,
King City, two-thirds of Tigard and unincorporated areas of Washington County to the
south and west of Tigard. The latter area is represented by the Tigard Water District. The
City of Tigard is the water provider for the TWSA and entities within this partnership are
represented by the Intergovernmental Water Board (IWB). Collectively, the board represents
almost 60,000 water customers.
Pu ose: The IWB makes recommendations and advises the Tigard City Council on drinking
water issues.
Members: The IWB consists of five members. Each jurisdiction (Durham, King City,Tigard,
and the Tigard Water District) is represented by one member, and one member is appointed
at-large. The at-large member is selected by a majority vote of the other members.
Knowledge, Skills and Abilities: Applicants need to be available and willing to attend IWB
meetings. IWB Commissioners receive packets of information to review before meetings.
Commissioners should expect to spend between two and 10 hours a month preparing for
and attending meetings. A basic knowledge of water system operations and prior experience
as a member of a board or committee is desirable.
Meeting Frequency and Location: The IWB generally meets on the second Wednesday of
the month at 5:30 p.m. in the Tigard Public Works Building, 8777 SW Burnham Street,
Tigard, Oregon. IWB members sometimes tour water facilities, and participate in joint
meetings with the Tigard City Council and other jurisdictions on an as-needed basis, typically
one or two times a year. IWB Commissioners may be asked to serve as liaisons to other
boards and committees and to attend additional meetings.
To Anpply: Interested individuals who would like to be considered for the at-large position
must complete and submit an application by 5 p.m.,Monday, February 13, 2012.
For more information, or to obtain an application, contact Tigard Public Works Director
Dennis Koellermeier at 503-718-2596 or dennis@tigard-or.gov.
Applications can be Applications can be Applications can be
mailed to: delivered to: e-mailed to:
Dennis Koellermeier Dennis Koellermeier dennis@tigard-or.gov
City of Tigard City of Tigard
13125 SW Hall Blvd. Public Works Building
Tigard, OR 97223 8777 SW Burnham St.
Tigard, OR 97223
City & Tigard
p PUBLIC WORKS DEPARTI4IENT
Citizen Committee Interest Application
Please check which Board/Committee you are interested in serving on:
Budget Committee ❑City Center Advisory Committee ❑Neighborhood Involvement Committee
❑Library Board ❑Parks and Recreation Advisory Board ❑Planning Commission
❑Tigard Youth Advisory Council ❑Transportation Advisory Committee ❑Tree Board
Intergovernmental Water Board Other
Name: And=Barrett Date: -2012
Address(Res.): 9675 SW M onald Sigel Res.Phone: 971-409-4440.
City: xwtd zip Code: 97224 Bus. Phone: 503-M-2
Address (Bus.) E-mail: andrew.barrettl7t g naitcom
City: Everton Zip Code: 97076 � Suggested by:
How long have you lived in the Tigard Water Service Area? �
Where did you live previously?
Educational Background: BS Civil Engineering
Occupational Status and Background: Fjoject Engineer:Engineer hgftgound since 2002 _
How long have you been employed with this firm: AM 2009
Previous Community Activity:
Organizations and Offices: PMfg,ssional Engineer since 2007
Other Information(General Remarks): I would like to give back to the community,
Any other pertinent information you want to share?I current work at the City of Beaverton
Person to notify in case of emergency: Jamie Banett
Address:9675 5X Mr.Dgnald S=t City:Tigard State/Zip: ORa(97224
Contact Phones:
I acknowledge that any photograph or videotape taken of me participating in this activity may be used for
outreach,education or documentation purposes,without compensation,by the City of Tigard,
Signature of Applicant: 1^c L 6VV�V- Date:
City of Tigard
Y PUBLIC WORKS DEPARTMENT
Citizen Committee Interest Application
• r
Please check which Board/Committee you are interested in serving on:
❑Budget Committee ❑ City Center Advisory Committee ❑ Neighborhood Involvement Committee
❑Library Board ❑ Parks and Recreation Advisory Board ❑ Planning Commission
❑Tigard Youth Advisory Council ❑ 'Transportation Advisory Committee ❑'free Board
® Intergovernmental Water Board Other
t
Name: Date:
L
� :� � �---
Address Res.): 153 f>e) j2.V-n1" a• T er—r Res. Phone:
City: Zip Code: 2--Z.3 Bus. Phone: ) " 1
Address Bus.). E-mail: 4bM VV.. ID IV hdf YO i 0_1
City: " 7 Zip Code: Suggested by:
c
How long have you lived in the'I`igard Water Service Area? � ..
Where did you live previously? ve-
Educational Background: 6' 1. Ili v/� ,V
Occupational Status and Background: re -l- 5 r`
How long have you been employee{with this firm: -5 Z_ �
Previous Community Activity: ( rU N
^
Organizations and Offices: t 1kA 1 Av d 1f-r
h40 k
Other Information (General Remarks):
Any other p ent inform oiywshe? 1- Sm
✓� i ilA MAIM3.
Person to notify in case of emergency:
Address " �1 I rf -IC
City: f State/Zip: G` �� �m
Contact Phones:, 6c "
I acknowledge that any. hotograph or videotape taken of me participating in this activity may be used for
outreach,education or en t t` u p s,without compensation,by the Citv of Tigard.
Signature of Applicant: Date: 1 }.Z_
Please return this form to: Public W s Director Dennis Koellermeier
City of Tigard
13125 SW Hall Blvd
Tigard, OR 97223
Fax—503.684.8840
E-mail—dennis@tigard-or.gov
Updeled:4112/1 t
Distributed to IWB Members
Via: __.'F-mailMail ❑In-person at meeting
14 City of Tigard
oil
S1 Memorandum
To: Intergovernmental Water Board Commissioners
From: Office Manager Greer Gaston
Re: Regional Water Providers Consortium (RWPQ Memos Regarding
Interconnections
Date: March 5, 2012 •
At the IWB's February 8, 2012, meeting, Commissioner Buehner described two RWPC memos
related to interconnections. She asked that copies of the memos be forwarded to each of the
IWB commissioners. The memos are attached.
zww
�1117"dJ�lIll[�14C!1S�Ciales,lliG.
M n T5W1'11ll1CIS 121 SK Salmon,Suite 900 a Portland,Oregon 97292919 s PHONE 503225.9010 FAX 503,225.9022
MEMORANDUM
DATE: January 16, 2012
PROJECT: Interconnections Map and Evaluation—Phase 3
Develop Preliminary Hydraulic Model
TO: Regional Water Providers Consortium—Technical Committee
FROM: Joe Foote, P.E.
Brian Ginter, P.E.
REVIEWED: David Stangel, P.E.
RE: Hydraulic Model Development Assessment and Recommendations
Introduction
The Regional Water Providers Consortium(Consortium) is a group of 22 water providers in
the Portland, Oregon metropolitan area. These water providers serve approximately 90
percent of the urban metropolitan area from five major water sources; the Bull Run
Watershed, the Trask& Tualatin River system, the Clackamas River,the Willamette River,
and groundwater. The Consortium's Strategic Plan identifies the need to encourage
partnerships between providers to facilitate and support reliable back-up water supplies for
all water providers should one or more sources or a transmission facility become unavailable
due to an emergency or natural disaster. In order to develop a tool to aid the Consortium's
evaluation of emergency water supplies through existing water system interconnections; the
Portland Water Bureau(PWB) authorized Murray, Smith&Associates, Inc. (MSA) to
conduct the Regional Water Interconnections Map and Evaluation(Interconnections project)
project in 2009. This memorandum documents Task 4 of Phase 3 of the Interconnections
Project.
This document was prepared under a grant from the Office of Grants and Training,United
States Department of Homeland Security. Points of view or opinions expressed in this
document are those of the authors and do not necessarily represent the official position of
09-1086.504 Page 1 of 10 Interconnections Map and Evaluation
January 2012 City of Portland Water Bureau
r
f
policies of the Office of Grants and Training or the United States Department of Homeland
Security.
Project Purpose and Outcome
On September 22, 2011, the Consortium authorized Phase 3 of the Interconnections project.
Task 4 of this phase of the project involved an evaluation of the effort required to develop a
preliminary regional hydraulic model based on the data contained in the geodatabase. This
technical memorandum (TM) documents those efforts and the resulting recommendations
and next steps should the Consortium elect to pursue actual development of a regional
hydraulic model. A separate memorandum was prepared which describes the Task 1-3 work
elements, findings and recommendations.
The hydraulic model development assessment element's focus was to determine if a
skeletonized hydraulic model of the interconnected regional water systems could be
developed. Though this phase did include the partial development of a preliminary regional
hydraulic model as a "pilot", the main focus was to perform a Gap Analysis of the ArcGIS
geodatabase information and provide recommendations for the development of a regional
hydraulic model. The effort is intended to identify critical facilities that are required for a
functioning regional water distribution system hydraulic model.
A regional hydraulic model is one of the potential next steps in meeting the following
objectives that the Consortium has set for the Interconnections Map and Evaluation project.
• Provide the foundation for a strong, flexible and redundant regional water supply
system
• Identify, within the region and on a sub-regional basis, options available for
conveying water during an emergency
• Provide a framework to inform local decision-making regarding priorities for
infrastructure improvements
• Support funding opportunities for future interconnection projects
• Identify future regional and sub-regional water system interconnections to strengthen
the overall water system reliability and resiliency
Hydraulic Model Development Assessment
The previous efforts of the ArcGIS geodatabase development(Phases 1 and 2 of the
Interconnection project) included all of the existing water system facilities and piping in the
Consortium's members service areas. A next potential step could include the development of
a regional hydraulic model. There is still considerable work that must be completed prior to
the development of functional hydraulic model. One of the major questions remaining is that
of whether some level of"skeletonization" should be implemented. The resulting number of
elements in a regional model that includes every pipe in all 22 of the consortium member's
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 2 of 10 City of Portland Water Bureau
G:\PDX_Projects\09\1086.Open\RWPC Interconnections Phase 3 Task 4 Final Mena-01.16-12.doc
systems, would be extremely complex and potentially difficult to analyze. It would also
include many areas that are not important from a regional water supply perspective. A
regional hydraulic model could be developed that incorporates "only"the hydraulically
significant elements and would exclude the others. The skeletonization effort would be
performed on a system by system basis. Each system would be evaluated to determine what
areas and or.facilities should be included or excluded. This effort would also provide an
additional level of validation to ensure that the operation of each system was clearly
understood prior to inclusion in a regional model. In general, any service area or pressure
zone that could receive or convey "regional" supply would be included in the overall model.
Regardless of the level of skeletonization,the overall goal would be to develop a hydraulic
model that would be mathematically stable allowing convergence under steady state and
extended period simulation(EPS) simulations in a reasonable amount of time.
The development of a hydraulic model requires accurate information for the following:
• Spatial information(element location and elevation)
• Connectivity and diameter of system piping
• Demand distribution
• Facility information(tank dimensions, pump curves and automated valve settings)
• The collection of field and/or SCADA to enable the model to be calibrated
Hydraulic Model Development Assessment Summary
The development of a regional hydraulic model will require extensive effort to incorporate
the critical details from each of the Consortium's interconnected water systems. To assist in
determining these details,the development of a"pilot"hydraulic model was undertaken to
evaluate the overall process. This allowed for review of the ArcGIS geodatabase information
in detail to find data gaps and identify a recommended approach for the future development
of a regional hydraulic model. The extent of the preliminary model development to date
included the Regional Transmission Mains layer developed for illustrative purposes in Phase
2 of the Interconnections Project and associated critical facilities. The following discussion
gives a summary of the model development assessment,which leads to the recommendations
that are based on the findings from this preliminary work.
Regional Hydraulic Profile
An important initial step in understanding the regional system hydraulics was to develop a
hydraulic profile and mass balance. This provided an overall understanding of the flow of
water within, and between each of the water systems. The hydraulic profile developed for
this phase of the project is attached to this memorandum as Figure 1. An initial mass balance
was developed to determine the overall flow consumed and transferred between each of the
water systems on an overall average basis. Limited information was available regarding the
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 3 of 10 City of Portland Water Bureau
G:\PDX_Projects\09U 086.Open\RWPC Interconnections Phase 3 Task 4 Final Memo-01.16-12.docx
1 �
PNW ARLINGTON
HEIGHTS N0.1,2 e 3 Tywp-wESr xIL15
NESE ROPE MO RESFAVOIRS WIP
RESERVOIRS 2&3
OE-6 IBz
CA wTP
0
• OE•BZtl OEC k6C
OE•B00'
TVWO t YISWO
M C1tt a 5ATw1Y P M B'MD
,q �•�' YEIER xo.1 e z
IX•730
-7100
700- I YILTIPIE PUYPINO MM.TICONNECTIONS
FACILI TIE$
PIIS (NS'-5]3'-810')
PWW NESTWOW
at43 M
OE•653' . L�Ap�
ITI�
600_ MPu:AtwrNOYE—T.—
PWB M CONNECTIMS
�qEy PONfl1 BUTTE
wC COIWM
FFM HILL 1 k 2
WASMINCfON Cp.NTY ARRV LINE OE•63tl ERESNAM
®- GRANT BuiTE
OREGON CITY
OE•S2tl MIN YIEW -SDG
500- ( TICMO I or.506'
0w
OEm 19V R91 w V A
OE 47S Tvwo-WEST xILLS KW
TSN I BELLA IBTA M
flKE16H
�� LVE- RESEM0IRS -9—>WATER DISTRICT i
GNMM NCYE MAm 388' OE•14W
! ' SE%fON YTN 'fWILSMYILLE �� TABOR N0.I k 5
1.2 REARVOIRS
OE-1y6' FTLICSM REB M
OE•4ffi B-12
TWUTIN M MW 2
.-.. 400g,. ^1 OE-411Y B�� ME-410- M W o k51N5ET I FYFRmItY M OEm 4Tt' 0 I,2l3 -400
N (IWFR SYSfDI)( E•3BB. INTERTIE
� OAN 1000E MO iAIRVIEW
of M0..3Ba 1VNO'IICIf CMLI ITEm3 'OE vAIIEY VIM RES I k 3
pESENVOIR3 M 3' 1 1._.._ • REB 1 BWO WELLS
i I DIVISIM p
x CITY d'FOREST I r, i S'TIWEf F5 C1tt K ..._.. SWA
p OiOYE M __.__ .__._1 GiE00N Cltt/QOw OE•2TS
M0..35C OE-3W M J'.- KIMYMT'B' M0. BIB'
y --.., LANE OAIEGO i -....._....___.._..._..._. __ .... .__..._....__.-, (YATIFR PS) �•�• .
--- MKUOA
M WTP
WA911NGTG1 M
y
.y ( YILWAUNIE
ry JG(J- M MCO1NlECTIONS TUNALL THIN PNE(N0.] 1 IGS OE•31S WA B IInP aEVATDT FRW YATHER M�1)� -JOU
n ._I��._. I ROFXW000 F.ILITY M
TA 3w
OEm?8T' FACI__! mWATER
S �• —M�...L3 OE•ffi' OE•1YL BOTx 5fMET TMATYMT
U i PS
TUKAT'N PWB-WEST SIDE SLPPLY LINE p '. PNB
WTP
PWS-SE APPLY LINE FACWTpCIIL T'
_ � s NCCWC
� � u � Ma Ba FAIRVIEW Wnle
U I iICMO
$
j A9t 1 61 XFRMOW ONAZ Figure 1
... p...._...
< zo0- fMW _ g
BEAVFRTM O' l 4.6 t 8 IN TIE .9�
I YFIP ASR 1.1 k 4 WA911N6TOM (.AflQ 11U PS pT
o PAKK PS d•BI'
vM'MTP FL.IBY Y/IP WILD VILE
CITY a WIDAYETTE RIVER rITP
i Q--�FGI[sr rnovE D.•Iia pq�
NOIa 3S1'
—0%r
WTP NILWUNt1E Yg.m
1 fLLTM PS EU Izr CRVI VRp
FL•N' EL.100'
INTERCONNECTIONS MAP&ELEVATION PROJECT
LEGEND ABBREVIATIONS
PUMP STATION ASR AOUIFER STORAGE&RECOVERY PWB PORTLAND WATER BUREAU REGIONAL WATER SUPPLY SYSTEM
WATER SUPPLY LINE Bwo BORING WATER DISTRICT PS PUMP STATION HYDRAULIC SCHEMATIC
n RESERVOIR/TANK ® NORMALLY CLOSED CONNECTION CSSWF COLUMBIA SOUTH SHORE WELL FIELD RES RESERVOIR
EMERGENCY INTERTIE PIPING
CRW CLACKAMAS RIVER WATER DISTRICT SWA SUNRISE WATER AUTHORITY
❑M MASTER METER EL ELEVATION WSWO WEST SLOPE WATER DISTRICT
.II {� WATER TREATMENT PLANT WELL -- - January 2012
CONTROL VALVE MG MILLION GALLONS W7P WATER TREATMENT PLANT
i OE OVERFLOW ELEVATION
y
flow rates through interties between each of the water systems, reducing the ability to
determine (on an overall average basis) how much water is conveyed through the different
water systems. As highlighted in the recommendation section, a detailed mass balance and
operational strategy should be developed in subsequent phases of the project to assist with
complete regional hydraulic model development.
Model Skeletonization
In order to keep the hydraulic model manageable, skeletonization was used to remove
facilities that do not have a regionally hydraulic significance. The skeletonization of the
entire regional water system included the Regional Transmission Mains and additional pipes
within each of the water systems that are required from a regional network perspective.
Critical facilities where identified, which includes water supply sources, reservoirs and a
limited number of booster pump stations. These facilities are tabulated in Table 1.
Connectivity between pipes and facilities was reviewed and corrected based on available
information.
Table 1
Critical Regional Facilities
Sources Reservoi>:rs cgnfd Reservoirs cont d).
Bella Vista(Rockwood Water Seaton Mountain No. 1,2
Bull Run Supply PUD) (Beaverton)
Clackamas River Water WTP Bolton Reservoir West Linn Springville No. 1,2 TVWD
Burlingame Tank No. 2,3,4 Sunset Reservoir No 1,2
'WC
WTP (PWB) (Sherwood)
Elligsen Reservoir B-1,2
Lake Oswego WTP Wilsonville Tabor Reservoir No. 1, 5
Fern Hill No. 1, 2(JWC) Valley View Res No. 1,2
Portland Wellfield Treatment Florence Lane(TVWD) Walu a OLWD)
Facility Thompson TVWD Westwood Tank
Rockwood Groundwater Grabhorn TVWD
Treatment Facility Grant Butte(Gresham) Pump Stations
South Fork WTP Hyde Park TVWD Carolina PS
Willamette River WTP In lewood TVWD) Fulton PS
Ma er(CR Washington Park Station 2 PS
Mo tainview Reservoir
10 MG(Tigard) fOfegon Ci Washington Park Station 3 PS
0. 1 ,2,3
(PWB) Otty No.1,2, 3 (CRW)
Powell Butte Reservoir
Ave Tualatin North/South PWB
During the review of the Regional Transmission Mains network(a subset of piping from
provider's GIS piping data that includes large diameter transmission facilities and piping
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 5 of 10 City of Portland Water Bureau
G.\PDX Projects\09\1086-Open\RWPC Interconnections Phase 3 Task 4 Final Memo-01-16-12.docx
connecting sources and storage elements), it was identified that key connections were
missing in many areas, particularly within individual water systems, that could be utilized for
the regional conveyance of water. Additionally, it was found through working with this data
that the pipe GIS layer requires further refinement to determine the accurate connectivity of
the pipes (particularly between systems). There are numerous locations where pipes either
terminate near each other and are not connected, or one pipe crosses another where they
should be connected. To update this information and correct the connectivity, requires a
coordinated effort between the hydraulic model and the GIS. Where the model is not
skeletonized, it is preferable that a one-to-one relationship between the model and GIS be
maintained. Ultimately this will require each utility to update their GIS to correct areas
where pipe and facility discrepancies were found. In some areas, relatively small mains (8-
12 inches)running in parallel serve as a"transmission" system conveying water between
various systems. This illustrates that the regional system is comprised of more than just the
large diameter Regional Transmission Mains. After reviewing this process, the
recommended approach would be to systematically work_with each water utility and develop
a partially skeletonized hydraulic model that includes the hydraulically significant elements,
subsequently combining them into one overall regional model.
System Demands
Initial demand evaluations reviewed the Average Day Demand(ADD) and Maximum Day
Demand (MDD)for the 22 water service areas that comprise the Consortium and an
additional six non-consortium members: Rivergrove Water District, Valley View Water
District, Boring Water District, Palatine Hill Water District, Cities of Troutdale and Wood
Village, included in the geodatabase. The reduction of the hydraulic model to the Regional
Transmission Mains resulted in point demands representing each of the water systems. A
more accurate distribution of demands within each respective utility will be required to more
accurately model regional system conditions. This would be particularly important to
conduct extended period hydraulic simulation, which evaluates how water moves in the
system over time.
Facility Information
A review of the facilities indicated that hydraulically significant parameters in the
geodatabase are missing at many locations. For a complete hydraulic model to be developed,
the information in Table 2 will need to be gathered and incorporated into the geodatabase, for
all facilities to be included.
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 6 of 10 City of Portland Water Bureau
G:\PDX_Projects\09\1086-Open\RWPC Intermnnections Phase 3 Task 4 Pinel Memo-01-16-12.doe
Table 2
Required Model Facility Information
Type Elevation (ft) Valve Type
Base Elevation(ft) Diameter(in) Elevation(ft)
Minimum Level (ft) Shutoff Head(ft) Diameter(in)
Maximum Level (ft) Design Head (ft) Pressure,Elevation
Initial Level(ft) Design Flow(gpm) or Flow Setting
Diameter (ft) Low Head(ft)
High Flow( m)
Summary and Next Steps
Phase 3 of the Regional Water Interconnections Map and Evaluation project resulted in an
improvement in the overall understanding of the regional system and identified where
additional investment is required. The objective of this effort was to outline the steps for the
development of a regional hydraulic model,to be considered for completion in future phases.
This process evaluated skeletonization options, including which facilities are required, and if
there were other data gaps.
The following is a summary of recommendations needed to complete the development of a
regional hydraulic model:
• Initially create an overall "steady state"regional model. This effort would be
completed by developing skeletonized(excluding areas not hydraulically significant
to the movement of regional water) hydraulic models for each of the individual water
systems using the available GIS data. These models would then be merged to create
an overall regional model.
• Include a distribution of demand that is representative of actual conditions across the
system, for demand scenarios relevant to regional water supply and emergency supply
evaluation (ADD, MDD, Peak Season and Winter Average Demand).
• Ensure that facility information including reservoirs,pumps and automated valves is
complete and accurate. The existing geodatabase has been updated as part of this
Phase 3 work to validate facility information with each water provider. Automated
valves are not currently included in the geodatabase. In order to manage the volume
and complexity of automated valves, only those valves related to supply transmission
should be included in the model and,identified after the initial system by system
skeletonization is complete.
• Calibrate the steady state model. Calibration is critical to the overall model
development to ensure that the users ultimately have confidence in the results it
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 7 of 10 City of Portland Water Bureau
G:\PDX_Projects\09\1086-Open\RWPC Interconnections Phase 3 Task 4 Final Memo-01-16.12.docx
produces. As part of this step, developing a mass balance for the flow of water within
the regional system would be required under various conditions to use as a reality
check to the hydraulic model. This calibration effort will focus on primary
r intersystem water transmission facilities and major emergency supply/transmission
facilities. Individual system calibration would likely be comprised of both flow and
pressure testing along with SCADA for facilities.
• Develop a extended period simulation model (EPS). Once the steady state model has
been developed and calibrated an EPS model could be developed. This would require
the collection of additional information on diurnal demand patterns and facility
operations.
• An EPS calibration effort would be required that would compare modeled flows and
tank levels to those collected with the regional and system specific SCADA.
• A regular updating process should also be identified to ensure the hydraulic model
and the GIS are regularly synchronized. In some systems this may result in a one-to-
one relationship between the model and GIS.
The next steps for the regional hydraulic model development are defined below. This along
with the information provided in Table 3 provides an overall strategy for developing a
hydraulic model that offers an appropriate level of confidence for regional and sub-regional
emergency supply analysis. Table 3 gives a summary of the each of the individual water
systems and assumptions related to developing a steady-state regional integrated hydraulic
model. The table also includes the estimate for the effort required to complete this task.
Based on our understanding of the 22 Consortium member systems and the status of existing
hydraulic models, a level of effort in the range of 2,500 to 3,000 hours is estimated to
develop a fully functioning steady state regional hydraulic model.
Outline of Potential Next Steps
1. Identify sub-regions based on major supply sources
• PWB and East County
• Clackamas River Water Users
• JWC Members
• Other Washington County Suppliers
2. Skeletonize each sub-region area's individual systems verifying:
• Connection of pipe network
• Inclusion of critical facilities
• Demand distribution
• Calibration at individual system and sub-regional level
3. Incorporate sub-regional models into a single regional model
4. Collect field and SCADA and calibrate under steady state conditions
5. Use model for specific steady state "what if' scenario evaluations
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 8 of 10 City of Portland Water Bureau
G:\PDX_Ptojects\09\1086-Open\RWPC Interconnections Phase 3 Task 4 Final Memo•01.16.12.dom
6. Collect additional diurnal demand information and facility operations set points
7. Calibrate model under specific EPS conditions
8. Use model for specific EPS "what if' scenario evaluations
Develop model and GIS maintenance and update protocols
The development of a calibrated regional hydraulic model would allow for evaluation
opportunities for additional interconnections, and further opportunities for back-up supply
options between each water system.
This effort provides some proposed steps for developing a regional pipe network hydraulic
model that would be used to identify pathways for routing water in emergency situations and
to develop corresponding operational strategies.
Lastly,.this hydraulic model would require a protocol to be developed for managing the
access of information to ensure that sensitive water system information is protected while
being available to water providers for planning and evaluation purposes.
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 9 of 10 City of Portland Water Bureau
G\PDX_Projects\0%1086-Open\RWPC Intercomiections Phase 3 Task 4 Final Memo-01-16-12.docs
Table 3
Individual Water Systems Hydraulic Model Development Summary and Assumptions
Ci of Beaverton 2 I40 Supply from JWC and ASR to base zones 410,470 and 550. Interties primarily in these service Existing Calibrated Steady State Model. Opportunity to skeletonize and remove high level pressure zones. 150
City Update control valves at JWC connections and Tigard intertie.
zones. Connection to JWC transmission mains.
Boring Water District 250 Small system with groundwater supply and no existing interties Inclusion could be delayed until development of interties with neighboring water providers is achieved. 120
Model to include limited facilities:sources Groundwater wells),storage and limited piping.
Clackamas River Water 2,950 Complex system served from multiple sources with numerous interties with neighboring water Existing steady state hydraulic model,calibration unknown. Some opportunity to skeletonize upper zones 200
providers. Upper level pressure zones have limited regional connectivity in South system.
tDevveloospment of a new hydraulic model required to link major storage,groundwater supply wells and 100
City of Fairview 870 No information provided.
City of Forest Grove 610 Base level system with storage supplied from City's WTP and JWC WTP. Interties with Hillsboro Existing Calibrated Steady State model. 100
Upper System and City of Cornelius.
of Gresham 5,340 PWB wholesale supply and joint groundwater facilities with RWPUD. Many upper level pressure Existing Calibrated Steady State and EPS model. Successfully integrated into a sub-regional model with 100
City zones have limited/no regional connectivity. Rockwood Water PUD system. Some opportunity to skeletonize and remove upper pressure zones.
City of Gladstone _ No information provided. Supply connections to NCCWC WTP and transmission mains. Interties Key facilities to be identified and included in the regional model,if no individual hydraulic model exists. 60
with neighboring water providers.
Ci of Hillsboro L7,460
70 JWC supplied system with ground level storage and pumped supply. Interties with TV WD and Hydraulic model will likely require full inclusion to capture interconnect of distribution system between 150
Beaverton. su I oints and interties.
City of Lake Oswego Key facilities include WTP,transmission and Waluga service level. Major interties with West Linn Existing calibrated hydraulic model.Opportunity to skeletonize and remove.upper level pressure zones. 100
and Ti ard.City of Milwaukie 00 Groundwater supplied system with major interties to CRW and PWB. Hydraulic model development recently completed with Water System Master Plan. May be limited 100
0 ortunity for sketetonization even distribution of sources and interties.
Oak Lodge Water District 60 NCCWC supplied system with major transmission and interties to Gladstone and CRW. Existing steady stare hydraulic model. Limited opportunity for skeletonization. 100
City of Portland 95,830' Largest water system with complex transmission and distribution network. Many upper pressure Existing steady state hydraulic model. Only include"base system",upper pressure zones(with no 280
zones have no/limited interties regional transmission or large capacity interties)to be skeletonized and removed to the extent possible.
Raleigh Water District 330 PWB supplied system from WCSL. Limited regionally important facilities and transmission capacity Existing calibrated steady state hydraulic model. Could be represented as a demand node on the 60
to others stems.
Rockwood Water PUD 2 060 PWB wholesale supply and joint groundwater facilities with Gresham. Interties with Gresham, Existing Calibrated Steady State model. Successfully integrated into a sub-regional model with City of 100
Portland and Fairview. Gresham system. Some opportunity to skeletonize and remove one small upper pressure zone.
340 Local WTP supplied stem current) isolated from other providers. Development of a hydraulic model to reflect integration of future PWB wholesale supply recommended 80
City of Sandy pP system Y for inclusion in regional model.
West Linn(South Fork Water Board) 1,560 SFWB supplied system with major transmission and interties to Oregon City and Lake Oswego. Existing calibrated steady state hydraulic model. Opportunity to skeletonize upper pressure zones. 100
Oregon City(South Fork Water Board) 6,280 SFWB supplied system with major transmission and interties to CRW and West Linn. Existing calibrated hydraulic model. Opportunity to skeletonize and remove upper pressure zones. 100
Sunrise Water Authority 2,530 NCCWC/groundwater supplied with major transmission and interties to OLWD,CRW and SFWB. Existing calibrated hydraulic model. Opportunity to skeletonize and remove upper pressure zones. 150
City of Sherwood 1,050 Three pressure zones with storage in 2 zones. Groundwater well supply to main zone,intertie to Existing calibrated steady state hydraulic model. Opportunity to skeletonize/remove upper pressure zones. 80
Tualatin,transmission from PWB and transmission from Willamette River Water Treatment Plant.
City of Tigard 8,800 Supply from PWB,Lake Oswego and ASR with major interties with TV WD(Metzger),Beaverton Existing calibrated steady state hydraulic model. Opportunity to skeletonize and remove upper pressure 120
and Lake Oswego. Isolated upper pressure zone areas on Bull Mountain. zones(550's and 713).
City of Tualatin 1,160 PWB wholesale at and of WCSL. Interties with all neighboring water providers. Existing calibrated steady stare hydraulic model. Include whole system. 80
of Wilsonville 1,550 Willamette River WTP supplied through high pressure transmission main into 3 service zones. B Existing calibrated steady state hydraulic model. Could skeletonize to WTP transmission piping at a 100
City level service zone critical,others could be skeletonized. minimum...would not include limited capacity emergency intertie with Tualatin.
West Slope Water District 600 PWB wholesale customer supplied from Arlington Heights. Parallel and intertied transmission with Existing calibrated steady-state hydraulic model. Opportunity to skeletonize/remove isolated sub-zones. 100
TVWD from Arlin on He,
ts.
Tualatin Valley Water District(Wolf 6,550
Creek Large,complex system with multiple sources:JWC,PWB,ASR Interties with all adjacent water Existing calibrated hydraulic model. Level effort estimated to be similar to PWB with extensive effort to 240
Tualatin Valley Water District 1,020 providers including WSWD,Beaverton,Hillsboro,PWB,Tigard. determine the extent of skeletonization that is feasible.
(Metzger)
1. Estimated Effort based on MSA's understanding of existing systems,status of existing hydraulic models and overall water system knowledge. Estimated effort does not include individual water system stafftime to support hydraulic model development,skeletonizing,
update,calibration and integration into the regional model
2. Number of Pipes based on known hydraulic model data,or number of pipe segments included in GIS data provided for the geodatabase.
3. PWB—Number of Pipes based on GIS data. PWB's existing hydraulic model contains less than 15,000 pipes.
09-1086.504 Murray,Smith&Associates,Inc. Interconnections Map and Evaluation
January 2012 Page 10 of 10 City of Portland Water Bureau
NDq W UsklB,1 c
Eil$tlteCfS1P iltit't5 121 S.11 Sahmn Suite 90 ■ Porfland,then 972114-2919 ■PHO E 543225.91110 FAX5503.215.9422
MEMORANDUM
DATE: January 16, 2012
PROJECT: Regional Water Providers Consortium (RWPC) Interconnections Map and
Evaluation Project Phase 3
TO: Rebecca Geisen, Project Manager
Portland Water Bureau—Regional Water Providers Consortium
FROM: Brian Ginter, P.E.
Heidi Springer, P.E.
Murray, Smith& Associates, Inc.
RE: RWPC Geodatabase Refinement, Data Model Development and
Recommendations for Geodatabase Update and Use
Introduction
The Regional Water Providers Consortium(Consortium) is a group of 23 water providers in
the Portland metropolitan area of Oregon. These water providers serve approximately 90
percent of the urban metropolitan area from five (5) major water sources: the Bull Run
watershed, the Trask &Tualatin River system,the Clackamas River,the Willamette River
and groundwater. The Consortium's Strategic Plan identifies the need to encourage
partnerships between providers and facilitate and support reliable back-up water supplies for
all water providers should one (1) or more sources or transmission facilities become
unavailable due to an emergency or natural disaster. In order to develop a tool to aid the
Consortium's evaluation of emergency water supplies through existing water system
interconnections;the Portland Water Bureau(PWB) authorized Murray, Smith&Associates,
Inc. (MSA)to conduct the Regional Water Interconnections Map and Evaluation project.
The project was funded by the Department of Homeland Security.
Prior Work
The first two (2) phases of this project resulted in the creation of an ArcGIS geodatabase of
all existing water system facilities within the region including existing water system
interconnections and a pipe network overlay that may be used to:
• Identify pathways for routing water in emergency situations
09-1086.503 Page 1 of 15 Interconnections Map and Eva].Phase 3
January 2012 Portland Water Bureau
' s
• Identify system vulnerabilities
• Develop emergency operational strategies
Phase 1 of the project focused on data collection and development of the geodatabase
mapping layers needed to allow for more detailed analysis of system interconnections. Phase
2 work involved incorporation of water provider system review comments as well as
exploratory use of the geodatabase for evaluating regional connectivity.
Phase 3 Objectives
Phase 3 of the Regional Interconnections project was funded by a grant from the Urban Areas
Security Initiative (UASI). This grant required that Phase 3 work be completed by October
31, 2011, approximately one (1) month after MSA was directed by the PWB to begin work.
With such a narrow project window, Phase 3 objectives focused on refining existing data.
Major objectives of the Phase 3 work include:
• Meet with Consortium providers and participating water systems to clarify specific
discrepancies in their system data which could not be resolved in prior phases
• Organize the geodatabase developed in prior phases into a standard ArcGIS data
model to improve data handling and quality
• Conduct staff training for Consortium members on the components and potential
applications of the regional database
Phase 3 also included a feasibility study to assess development of a regional hydraulic model.
This work is documented in independent separate technical memorandum.
Map Corrections and Data Refinement
Geographic Information System(GIS) data quality control completed in Phase 1 relied on
general water provider comments to ArcGIS maps created using the provider's water system
data. The level of detail provided in Phase 1 comments varied and left unresolved
discrepancies in the geodatabase such as overlapping facilities and pressure zones between
systems as well as incomplete facility information. Through meetings with each water
provider,work under Phase 3 endeavored to correct and complete existing GIS data and to
obtain GIS data from Consortium providers who did not participate in prior phases.
Map and Documentation Review
In order to correct and complete the existing geodatabase information in Phase 3, each water
system's facilities were reviewed and compared with available planning documents to
identify specific questions for system managers and operators. Each water system was
provided with a map of their system's GIS data and tables showing the associated
information for each pressure zone, source facility,reservoir and intertie on the map.
Inconsistencies and missing information were highlighted to elicit input from the water
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 2 of 15 Portland Water Bureau
GAPDX Projects\09\1086\503-Enhanced geodatabase\Phase 3 Mertp\RWPC Geodatabase Phase 3 Metno.doc
provider's staff. Data tables were e-mailed to each provider in advance of a scheduled
meeting and maps were made available on MSA's ftp site.
Provider Meetings
MSA met with water provider staff throughout the region to discuss and resolve incomplete
data and overlapping facilities within the Regional Interconnections geodatabase.
Participating water system meetings are summarized in Table 1.
Table 1
Water Provider Data Review Meetings
Beaverton, City of 10/7/2011 Sandy, City of 10/10/2011
Boring Water District 10/17/2011 Sherwood, City of 10/12/2011
Clackamas River Water 10/7/2011 South Fork Water Board 10/25/2011
Gresham, City of 10/6/2011 Sunrise Water Authority 10/12/2011
Hillsboro, City of 10/17/2011 Tigard, City of 10/13/2011
Joint Water Commission 10/17/2011 Tualatin Valley Water 10/13/2011
District
Lake Oswego, City of 10/7/2011 Tualatin, City of 10/11/2011
Milwaukie, City of 10/14/2011 West Linn, City of 10/25/2011
Oregon City, City of 10/12/2011 West Slope Water District 10/12/2011
Portland Water Bureau 10/19/2011 Wilsonville, City of 10/10/2011
Rockwood Water PUD 10/6/2011 Wood Village, City of 10/13/2011
The non-Consortium member water systems Boring Water District, Rivergrove Water
District, Valley View Water District and the City of Wood Village, contributed data to the
Regional Interconnections geodatabase. Boring and Wood Village also participated in
meetings to review their system data. For Palatine Hill Water District, a non-Consortium
member, pressure zones are included in the regional geodatabase. This District did not
provide any additional water facility information.
Consortium member City of Gladstone did not provide GIS data for inclusion in the Regional
Interconnections geodatabase. Pressure zone GIS data was not available for Consortium
members City of Fairview and City of Sandy. Consortium members City of Fairview and
Oak Lodge Water District did not respond to meeting requests.
Provider Feedback and Geodatabase Editing
Information and comments provided by water system staff in response to MSA's map and
documentation reviews were manually incorporated into the geodatabase using ArcGIS 10
software. In addition to comment, the Cities of Milwaukie, Oregon City, Sandy and Tualatin
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 3 of 15 Portland Water Bureau
GAPDX_Projects\09\1086\503-Enhanced geodatabase\Phase 3 Memo\RWPC Geodatabase Phase 3 Memo.doc
provided new or updated GIS shapefiles to replace facilities incorrectly shown or missing
from the geodatabase developed in Phases 1 and 2.
The following general procedures and assumptions were used for adjusting service area and
pressure zone boundaries. It is recommended that the Consortium ultimately come to
consensus on how service areas and pressure zones should be represented in the geodatabase.
• Due to Phase 3 time constraints, areas where adjacent water providers indicated
conflicting service area boundaries were left to be resolved in future work
• Pressure zone boundaries were adjusted to reflect the water system that is physically
serving an area rather than the water system within whose political boundary the area
lies.
The geodatabase service area boundary data should not be relied upon as an accurate
representation of the legal boundary of each water system.
Potential Database Enhancements
Feedback from water provider meetings indicated that the following additional information
would be beneficial if collected and appended to the existing data. Phase 3 provided
insufficient time to collect these additional data items and add them to the geodatabase
region-wide. It is recommended that the Consortium reach consensus on which of these
additional data fields should be included in the geodatabase as well as collecting and
appending the data.
1. Intertie valve exercise date
2. Intertie condition rating (i.e. 1=Excellent, 2=Satisfactory, 3=Poor, 4=Unknown)
3. Links to detailed facility maps, such as vault details or intersection cards
Data Model
The geodatabase developed in Phases 1 and 2 was adapted into a standard Esri Water
Utilities Data Model. A Data Model is a pre-defined geodatabase template that helps to
streamline and standardize data acquisition while accommodating all existing data. The
spatial and non-spatial information for type of water facility was reorganized as described in
this section.
Featurg Classes,Attributes and Domains
The data model is composed of feature classes(also called object classes)that define a type
of water facility, such as storage reservoirs or water mains, as well as that facility's spatial
information. Each feature class is composed of a specific set of attributes that describe that
feature. For example the wMain feature class describes water mains. The wMain feature
class attributes include characteristics like pipe diameter and material.
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 4 of 15 Portland Water Bureau
G:\PDX_Projects\09\1086\503-Enhanced geodatabase\Phase 3 Mem%WPC Geodatabase Phase 3 Memo.doc
To further improve standardization, domains can be established for each attribute. A domain
is a pre-defined set of values that the user entering data must choose from. This constrained
set of values is not appropriate for every attribute, for instance,you would not want the name
of a reservoir constrained to a list of pre-determined values but it may be useful to have a pre-
defined list of pipe materials. The user entering data would choose Ductile Iron from the
domain of pipe materials rather than entering the acronyms DI or DIP. Although DI and DIP
are generally understood industry-wide abbreviations for ductile iron pipe,the database will
interpret these as distinct and thus different values, thereby making it more difficult to
identify or group water mains by pipe material. Domains also help eliminate anomalies in
the data caused by typing errors. The AssetOwner domain is used to define standard water
provider names in all feature classes of the geodatabase. The domain values are shown in
Table 2 below.
Table 2.
AssetOwner Domain (Water Provider Standard Names)
Beaverton Milwaukie South Fork WB
Boring WD NCCWC Sunrise Water Authority
Clackamas River Water NCCWC/SFWB/CRW Tigard
Cornelius Oak Lode WD Troutdale
Fairview Oregon City Tualatin
Forest Grove Palatine Hill WD Tualatin Valley WD
Gladstone Portland Water Bureau Valley View WD
Washington County Supply
Gresham Raleigh WD Line
Joint Water Commission River rove WD West Linn
Hillsboro Rockwood Water PUD West Slope WD
Lake Oswego Sandy Wilsonville
Lusted WD Sherwood Wood Village
Each feature class and its associated attributes are described in the following tables. Where a
domain has been established for an attribute,the key values and a brief explanation are
provided.
Some additional attributes that are available in the Water Utilities Data Model are not shown
in the tables below because there was no existing data for these attributes. The Consortium
may ultimately decide to populate-these attributes with data collected from its members or
eliminate the attributes from the data model template. It is recommended that the Consortium
reach consensus on the necessary attributes and refine the data model to include only this
information.
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 5 of 15 Portland Water Bureau
G\PDX_Projects\09\1086\503-Enhanced geodatabaseThase 3 Menw\RWPC Geodatabase Phase 3 Mem.doc
wMain Feature Class
The wMain feature class describes both distribution and transmission piping for individual
water provider systems and region-wide facilities such as the Washington County Supply
Line. Table 3 presents the wMain feature class and Tables 3A and 3B present the wMaterial
and wMainDistributionDiameter domains,respectively.
Table 3
Water Main Attributes
An ID number for the pipe provided with the
FACILITYID String original GIS data from each waters stem
INSTALLYEAR Integer Year of installation ifprovided)
MATERIAL String The pipe material ifprovided) wMaterial
DESCRIPTION String Pipe location description ifprovided)
COMMENTS String Any comments pertaining to the pipe
DIAMETER Double The nominal pipe diameter inches wMainDistributionDiameter
SEGMENTLENGTH Double The approximate length of pipe feet
Hazen-Williams roughness coefficient from
ROUGHNESS Double hydraulic model ifprovided)
ISTRANMAIN Small The type of water main. wMainType
Integer
1 -Distribution,2-Transmission
3-PWB Conduit
4-Washington County Sully Line
5-JWC Transmission
OWNEDBY String The waters stem provider that owns the facility AssetOwner
The source file of the data or plan where the
DATASOURCE String information may be found
Identifies the pipe as significant to potential
region-wide water transmission,domain values
ISREGTRANMAIN String are yes or no wYesNo
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 6 of 15 Portland Water Bureau
G:kPDX_Projecul09110961503-Enhanced geodatabaseThese 3 MerwkRWPC Geodatabase Phase 3 Memo.doc -
Table 3A
Pipe Material Domain
Asbestos Cement High Density Polyethylene
HDPE
Cast Iron Polyvinyl Chloride(PVC)
Concrete Cylinder Steel
Copper Wrought Iron
Ductile Iron Unknown
Galvanized Steel
Table 3B
Pipe Diameter Domain
411
4211
611
48011
8" 54"
10" 60"
12" 66"
14" 72"
16" 78"
18" 84"
20" 90"
24" 96"
30"
Unknown(stored in
36" the database as 99)
wReservoir Feature Class
The wReservoir feature class describes finished water storage reservoirs and tanks throughout
the region. Where necessary and available, electronic data from providers was supplemented
with information from the provider's Water System Master Plan. Table 4 presents the
wReservoir feature class.
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 7 of 15 Portland Water Bureau
G,APDX_Projects\09\1086\503-Enhanced geodatabase\Phase 3 Memo\RWPC Geodatabase Phase 3 Memo.doc
Table 4
Reservoir Attributes
An ID number for the reservoir provided
with the original GIS data from each
FACILITYID String waters stem
.INSTALLYEAR Integer Year of installation ifprovided)
Year of seismic improvements(if
UPGRADEYEAR Integerprovided)
Reservoir location description(if
LOCDESC String provided)
STRUCTTYPE String Reservoir construction style wRsvrStructureType
Buried
.....Partially Buried_...............-,_...-....._._........._....
Above Ground
Elevated_
Standpipe
The water system provider that owns the
OWNEDBY String facility AssetOwner
Does the reservoir have seismic
SEISMIC String improvements?-yes,no or unknown wSeismic
OVERFLOWELEV Double Reservoir overflow elevation feet
MATERIAL String Reservoir construction material wRsvrMaterial
Concrete
Steel
COMMENTS String Any comments pertaining to the reservoir
FACILITYNAME String Common facility name or description
The source file of the data or plan where
DATASOURCE String the information may be found
wPump Feature Class
The wPump feature class describes finished water pump stations. Provided pump station data
varied from stations with a single pump to those with multiple pumps providing water to
more than one (1) pressure zone. Pump stations were divided into three (3) "Function"
categories:
1. Pump to Distribution with Gravity Storage: supply water to pressure zones with
finished water storage reservoirs serving the zone by gravity
2. Constant Pressure: supply pressure zones without the benefit of gravity storage
3. Pump to Terminal Storage: directly supply a water system's terminal finished water
storage reservoir through transmission mains. A terminal reservoir is defined as the
primary supply reservoir receiving a water system's source water prior to distribution
to customers. Not all systems are configured with a terminal reservoir.
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 8 of 15 Portland Water Bureau
GAPM—Projects\09\1086\503-Enhanced geodatabaseThase 3 Memo\RWPC Geodatabase Phase 3 Memo.doc
This classification system provides information beneficial to identifying relevant facilities
when performing analysis with the geodatabase. Overall station capacity is listed by pressure
zone served. When available, individual pump capacities and discharge pressures were also
included. Table 5 presents the wPump feature class.
Table 5
Pump Station Attributes
An ID number for the pump station provided with
FACILITYID String the original GIS data from each waters stem
INSTALLYEAR Integer Year of installation ifprovided)
FUNCTION String Pump station function: wPumpFunction
w Pump to Distribution with Gravity
Constant Pressure
___...._..__.._._.._..._..._.....__..._._.._.._....__._...._.____.__...._..........
__....__....._....
Pump to Terminal Storage
Small
BUPPWRKW Integer Kilowatts of backup ower if any,if known
LOCDESC String Pump station location description ifprovided)
Pump station description including number of
DESCRIPTION String pumps ifprovided)
COMMENTS String Any comments pertaining to the pump station
Station capacity(gallons per minute)serving
STA CAP 1 Integer pressure zone at discharge head STA HGL 1
Station capacity(gallons per minute)serving
STA CAP 2 Integer pressure zone at discharge head STA HGL 2
Discharge hydraulic grade(feet)at station
STA HGL 1 Integer capacity STA CAP 1
Discharge hydraulic grade(feet)at station
STA HGL 2 Integer capacity STA CAP 2
CAP TYPE String NOMINAL or FIRM capacity asprovided) wPumpCapType
Station capacity(million gallons per day)serving
STA CAP 1MGD Double pressure zone at discharge head STA HGL 1
Station capacity(million gallons per day)serving
STA CAP 2MGD Double pressure zone at discharge head STA HGL 2
Individual pump capacity(gallons per minute),#
P CAP # Integer represents the individual pump number up to 6
Individual pump discharge grade(feet),#
P HGL # Integer represents the individual pump number up to 6
ELEVATION Double Pump station elevation feet,ifprovided)
NAME String Common facility name or description
OWNEDBY String The waters stem provider that owns the facility AssetOwner
The source file of the data or plan where the
DATASOURCE String information ma be found
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 9 of 15 Portland Water Bureau
G:\PDX_Projects\09\1086\503-Enhanced geodatabase\Phase 3 Metno\RATC Geodatabase Phase 3 Memo.doc
wlntertie Feature Class
Water system interconnections are included in the geodatabase where identified in electronic
mapping,hydraulic models or through meetings with water providers about their system data.
Interties are identified as either emergency or source interties. The emergency intertie type
represents typically unmetered emergency connections between two (2) adjacent water
systems. Source interties represent wholesale supply or other metered supply connections
between a water supply system or agency and a system receiving a wholesale or metered
water supply. Table 6 presents the wlntertie feature class.
Table 6
Intertie Attributes
An ID number for the intertie provided with
FACILITYID String the original GIS data from each waters stem
LOCDESC String Intertie location description ifprovided)
PIPESIZE Double Nominal size of pipe or valve inches wMainDistributionDiameter
Small If metered intertie,nominal size of meter
METERSIZE Integer inches wMeterSize
Common name for water system 1 (SYS_1)
ZONE 1 String pressure zone
Common name for water system 2(SYS 2i
ZONE 2 String pressure zone
Hydraulic grade of water system 1 pressure
HGL I Double zone
Hydraulic grade of water system 2 pressure
HGL 2 Double zone
SYS 1 String Waters stem 1 wIntertieSystems
SYS 2 String Waters stem 2 wIntertieSystems
Intertie capacity from water system 1 to
CAP 1 2 Integer waters stem 2 m,if known
Intertie capacity from water system 2 to
CAP 2 1 Integer waters stem 1 (gpm,if known
DESCRIPTION String Intertie description ifprovided)
COMMENTI String Any comments pertaining to the intertie
COMMENT2 String Any comments pertaining to the intertie
Type of intertie:emergency,source or wIntertieType
INTTYPE String unknown
INSTALLYEAR Integer Year of installation ifprovided)
The source file of the data or plan where the
DATASOURCE String information may be found
NAME String Common facility name or description
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 10 of 15 Portland Water Bureau
G:\PDX_Projects\09\1086\503-Enhanced geodatabase\Phase 3 Memo\RWPC Geodatabase Phase 3 Merno.doc
The water system domain wlntertieSystems used in the SYS_#attribute of the wlntertie
feature class is different than the AssetOwner list of water systems. There are several small
water districts included in the wlntertieSystems domain that have connections to other
regional water providers but are not members of the Consortium and their facilities are not
included in other feature classes of the geodatabase. Table 6A presents the wlntertieSystems
domain and Table 6B presents the wMeterSize domain.
Table 6A
Intertied Water Systems Domain
Beaverton Lusted WD Southwood Park WD
Burlington WD Milwaukie Sunrise Water Authority
Clackamas River Water NCCWC Sk lands Water Co
Fairview North Plains Tigard
Forest Grove Oregon City Troutdale
Glenmorie Palatine Hill WD Tualatin
Green Valley& GNR Water Pleasant Home WD Tualatin Valley WD
Gresham Portland Water Bureau Two Rivers Water Assoc.
Hideaway Hills Water Co Raleigh WD Valley View WD
Hillsboro Rivergrove WD West Linn
Joint Water Commission Rockwood Water PUD West Sloe WD
Lake Grove WD Sherwood Wilsonville
Lake Oswego South Fork WB Wood Village
Lorna Water Co
Table 613
Intertie Meter Size Domain
Unknown(stored in
the database as -1) 12"
2" 16"
3" 11811
4" 20"
6't 24"
Bit 30"
None (stored in the
10" database as 0
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 11 of 15 Portland Water Bureau
G:\PDX_Projects\09\1 086\503-Enhanced geodatabsse\Phase 3 Memo\RWPC Geodatabase Phase 3 Memo.doc
wSourceFacility Feature Class
Attributes for water system source facilities include source type and capacity, and water
quality information that is pertinent to a blending analysis of water from multiple sources,
such as the disinfection method and presence of fluoride. Table 7 presents the
wSourceFacility feature class.
Table 7
Source Facility Attributes
An ID number for the source facility provided
with the original GIS data from each water
FACILITYID String system
INSTALLYEAR Integer Year of installation ifprovided)
LOCDESC String Source location description ifprovided)
COMMENTS String Any comments pertaining to the source facility
NAME String Common facility name or description
FACILITYTYPE String The type of source facility: wFacilityType
WTP=water treatment plant treating ground
or surface water
.................._...................._._........__.............._......................._.._.................._...............__..
Well=groundwater well
................_........................,...._..........................._._....._.._......_..,...........
..........._.............._.._..,.....
ASR=aquifer storage and recovery well
TREATMENTTYPE String Water treatmentprocess: wTreatmentType
Conventional Filtration
......................................._.................._..................__..._.._..__...._.._...._..._......_...__....................._......
Green Sand Filter
_.__......................_........._...._._...._.._.._............._..___..........................__...._......................._..................
..
Membrane
........................_._.......................,......_..__.............-...................---..._.........................................._......................_..._............
None
....._...............................___..._......_...._............_......._.............._.._....._.............................
__.._._.........
Unknown
.................................................._...................._._.._........................._..._....._........_._.........................._............
Aeration tower
DISINFECTMETHOD String Residual disinfection method: wDisinfectMethod
Chloramine
Chlorine
_.....__......._..................._....._..._..._..__....._..._._......_...... _..._..._......_.__._.....
None
Unknown
CAPACITYMGD Double Nominal capacity million gallons per da
ISFLUORIDATED String Is the source fluoridated? wYesNo
Hydraulic grade line of the source discharge to
HGL Double the distributions stem feet,if known
ISMAJORSOURCE String Is the source's capacity eater than 1 m d? wYesNo
OWNEDBY String The waters stem provider that owns the facility AssetOwner
The source file of the data or plan where the
DATASOURCE ::tStringinformation may be found
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 12 of 15 Portland Water Bureau
GAPDX_Prcjects\09\1086\503-Enhanced geodatabase\Phase 3 MermAWPC Geodatabase Phase 3 Memo.doc
wWaterServiceArea Feature Class
The water service area feature class is composed of polygons showing the boundary of each
water system's service area based on provider data, Metro's Regional Land Information
System(RLIS) dataset and meetings with water providers to resolve overlapping data. As
stated previously, areas where adjacent water providers indicated conflicting service area
boundaries were left to be resolved by the Consortium in future work.
The most recently reported population and water demand data are included in the
wWaterServiceArea feature class attributes. Population and water demand information was
summarized in Phase 1 primarily from current.water system master plans or other
documented water demand forecast updates. Consortium members Clackamas River Water
and Tualatin Valley Water District have divided their water system boundaries and water
demand data into hydraulically separate sub-areas as discussed in their respective planning
documents and this has been reflected in the geodatabase. Table 8 presents the
wWaterServiceArea feature class.
Table 8
Water Service Area Attributes
WATERSYS String The water provider name AssetOwner
EXPOP Double The current service area population
EXPOPYR Double 'The year of the current service area population value
FUTPOP Double The future planned service area population
FUTPOPYR Double The year of the future planned service area population
POPDATASRC String The data source of the service area population value
EXADD Double Existing annual average day demand
EXMDD Double Existing peak day demand
EXYR Double Year of the existing demand data
EXSRC String Source of the existing demand data
FUTADD Double Future annual average day demand
FUTMDD Double Future peak day demand
FUTYR Double Year of the future demand data
FUTSRC String Source of the future demand data
Name of the non-wholesale water treatment facility
WTP String serving the waters stem
Does the water system operate aquifer storage and
ASR String recovery facilities? wYesNo
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 13 of 15 Portland Water Bureau
Cr\PDX Projects\09\1086\503-Enhanced geodatabase\Phase 3 Memu\RWPC Geodatabase Phase 3 Mew.doc
COMMENTS String An comments pertaining to the waters stem
Name of any wholesale water provider serving the
WHOLESALE String system
WELLS String Does the waters stem operate wells? wYesNo
wPressureZones Feature Class
The pressure zone feature class is composed of polygons showing the boundary of each
pressure zone as provided by the individual water systems. For the purposes of the Regional
Interconnections geodatabase, pressure zone boundaries were adjusted to reflect the water
system that is physically serving an area rather than the water system within whose political
boundary the area lies. Table 9 presents the wPressureZone feature class.
Table 9
Pressure Zone Attributes
ZONENAME String The common pressure zone name
OWNEDBY String The waters stem provider that owns the pressure zone Asset!!er
HGL Double The h draulic grade line of the pressure zone feet
Staff Training
Staff training provided an overview of basic GIS concepts and use of ArcGIS software, an
introduction to the information available in the Regional Interconnections geodatabase and
examples of thematic mapping and queries based on this information. The trainings were .
designed to be identical with some flexibility depending on the GIS skill of each group of
participants.
Staff training was conducted in two (2)three-hour sessions:
1. Thursday, October 27, 2011 from 9 am to 12 pm at the City of Gresham
2. Friday, October 28, 2011 from 1 pm to 4 pm at the Portland Water Bureau
Training sessions were attended by the following water system providers:
• City of Beaverton • City of Sandy
• Clackamas River Water • Sunrise Water Authority
• City of Gresham • City of Tigard
• City of Hillsboro • City of Tualatin
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 14 of 15 Portland Water Bureau
GAPDX_Projects\09\10861503-Enhanced geodatabaseThase 3 Merm\RWPC Geodatabsse Phase 3 Mew.doc
• City of Lake Oswego • Tualatin Valley Water District
• Portland Water Bureau
Feedback from these training events indicate that GIS professionals from participating water
agencies see potential in continuing to compile region-wide water system data although
additional review and standardization of the data will likely be needed. Many of the GIS
professionals in attendance had no, or limited, prior knowledge of this database project from
their organizations.
Conclusions and Recommendations for Future Work
Phase 3 of the Regional Interconnections project brought the geodatabase developed in
Phases 1 and 2 into a standard Esri Water Utilities Data Model, further refined the existing
data and improved data processing by establishing attribute domains. Data quality was also
improved by meeting with water providers to elicit feedback on specific water system
questions. Phase 3 identified additional attributes to enhance the utility of the geodatabase as
an analysis tool. Staff training conducted as part of Phase 3 allowed Consortium water
provider GIS professionals to explore information available in the latest version of the
geodatabase.
Through the Phase 3 work, including meetings with individual water providers and round-
table discussions during the training sessions, a number of recommendations and next steps
have been developed for the Consortium's consideration. A brief description of each is
presented below:
Finalize data sharing agreement to facilitate regional and sub-regional use of the
geodatabase. While creation of the Regional.Interconnections geodatabase has been
primarily a technical effort, it is recommended that the next steps taken by the Consortium in
the development of this tool be matters of policy and procedure. It is recommended that the
Consortium come to consensus on the means of distribution, updating and maintenance for
the geodatabase in order to maintain its integrity and usefulness as an analysis tool. The first
step in this task is to obtain authorization from each of the member agencies to allow access
to the geodatabase for analysis.
Establish a working group to manage geodatabase use, update and distribution. Once
member agency authorization has been obtained, a working group consisting of managers
and GIS professionals from member water systems should be established to review the
content and form of the geodatabase relative to individual water system GIS data and
establish protocols and standards to streamline future updates. This should be considered a
high priority item for the Consortium in order to preserve the investment made to date in the
geodatabase.
BMG:has
09-1086.503 Murray,Smith&Associates,Inc. Interconnections Map and Eval.Phase 3
January 2012 Page 15 of 15 Portland Water Bureau
GAPDX Projects\09\1086\503-Enhanced geodatabase\Phase 3 Memo\RWPC Geodatabase Phase 3 Memo.doc