|
ITEM: |
CONSENT CALENDAR |
||||
|
|
|||||
|
6. |
CONSIDER APPROVING A CONTRACT WITH
TIERRA PLAN IN AN AMOUNT NOT TO EXCEED $27,730 TO UPGRADE THE MPWMD STREAM
FLOW DATA PORTAL TO A PUBLIC FACING DATABASE WEB SERVER |
||||
|
|
|||||
|
Meeting Date: |
November 14, 2022 |
Budgeted: |
Yes, Partially |
||
|
|
|||||
|
From: |
Dave Stoldt |
Program/ |
2-5-3 A |
||
|
|
General Manager |
Line Item No.: |
|
||
|
|
|||||
|
Prepared By: |
Jonathan Lear |
Cost Estimate: |
$27,730 |
||
|
|
|||||
|
General
Counsel Approval: N/A |
|||||
|
Committee
Recommendation: The Finance and
Administration Committee reviewed this item on November 7, 2022 and
recommended approval. |
|||||
|
CEQA Compliance: This
action does not constitute a project as defined by the California
Environmental Quality Act Guidelines Section 15378. |
|||||
SUMMARY: Currently, the District maintains
15 stream gages, 3 weather stations, and 2 water level monitoring
stations. The stations collect 15-minute
data and store the data locally to the stations on their data loggers. There is telemetry to 5 of the streamflow
stations, 3 of the weather stations, and the lagoon level station. Data from these stations are remotely downloaded at an hourly time step and updated on the District
website at the same frequency. Here is
the link to the District streamgages: (https://www.mpwmd.net/environmental-stewardship/carmel-river-basin/carmel-river-flows/) The
tables are updated on a daily time step and plots are updated on an hourly time
step. The District has created this
website and data flow to share close to real time data with collaborators and
regulators. Past water years are
archived by water year.
While this is sufficient
for real time data sharing and water project operations, the files are flat and
do not provide any database capabilities to go back through older data. Data requests internally and from external
organizations require MPWMD Hydrologists to manually query the database to
provide data on a case-by-case basis. The Water Resources Division is currently
in a stream gage upgrade adding telemetry to the remaining 10 gages so those
data will be also available real time.
There is a desire from the Hydrology and Fish Biology Staff to have all
that data collected into a dashboard so that MPWMD staff can know current River conditions when planning
field work. When we were planning this
work last year, we came up with an estimate of $24,000 to create an internal
web database and dashboard displaying real time River conditions. As District Staff was planning to begin this
work this year, during backgrounding the Valley Water stream gage web facing
database was discovered. Here is a link
to the Valley Water data portal. https://alert.valleywater.org/map?p=map This web
interface allows for a scrolling zooming map and displays real time values on
the map. It also has a database function
that allows the user to download ranges of data with customizable reports. After discovering this web interface,
District Staff and Management approached Valley Water and inquired about the
web interface. The District was able to
obtain the estimate from Tierra Plan (Exhibit
6-A) to complete the same style web portal
for the District as they had for Valley Water.
RECOMMENDATION: The Finance and Administration Committee
recommends the Board authorize District staff to enter into a contract for an
amount not to exceed $27,730 with Tierra Plain to build a public facing
database web server for the District’s stream gage network and direct staff to
make a midyear budget adjustment of $3,730 to cover the difference between the
budgeted amount and the cost of the product.
BACKGROUND: The Water Resources Division is in
the middle of a 2-step upgrade to the District’s stream gage network. The first step is under process and includes
some upgrades to the gage data loggers and telemetry of the remaining gages in
the network. The second step is to
upgrade the interface with the data.
District staff had requested to have a dashboard built where real time
River conditions could be accessed to help inform fieldwork. During the process of beginning this work, it
was discovered that for $3,730 more than was budgeted the District could not
only create a web facing database that District staff could use, but we could
also create a public facing web database displaying all hydrologic data in one
location that provides an interactive experience. Users can also download customizable date
data tables from any of the District’s gages.
This will save staff time and get the data into the hands of the public
faster as currently District Hydrologists complete each data request when a
request is received as schedules allow.
IMPACT TO
STAFF/RESOURCES: District
Staff will be working with Tierra Plan to customize this tool to best fit the
District’s need.
EXHIBIT
6-A Surface Water Portal Proposed Project Plan for the Monterey
Peninsula Water Management District (MPWMD)
U:\staff\Boardpacket\2022\20221114\Consent
Calendar\06\Item-6.docx