|
FINANCE AND ADMINISTRATION COMMITTEE |
||||
|
|
||||
|
4. |
CONSIDER APPROVING A CCONTRACT
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 7, 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 ________________. |
||||
|
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 4-A) to complete the same
style web portal for the District as they had for Valley Water.
RECOMMENDATION: The Finance and Administration Committee should
recommend 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
4-A Surface Water Portal Proposed Project Plan for the Monterey
Peninsula Water Management District (MPWMD)
U:\staff\Board_Committees\FAC prev Admin\2022\20221107\04\Item-4.docx