"California State Well Numbering (SWN) system wells are assigned a unique identifier without using a computer." - Yolo County Flood Control & Water Conservation District Manager
This video underscores how backwards some of our state agencies are with their internal workflows. Putting aside making data available to the public, the perpetuation of inefficient and outdated workflows circa 1970 is borderline scandelous in today's digital era.
I had the privilege of attending the Department of Water Resources's Water Plan Plenary this year. The Water Plan is a comprehensive planning framework that invites all stakeholders and interested parties to participate in forming future directives for California water. This year, the plenary was held at the Red Lion Woodlake Conference Center in Sacramento. Amidst the sounds of clinking chips from the in-house casino, and the three story spray of a massive courtyard fountain, there was much discussion about the future of water in our changing state.
This is part 2 in a series of posts that chronicle our work with groundwater elevation data. Using California's Department of Water Resources's CASGEM system, we were able to retrieve 30 years worth of well readings for the entire state, but not without headache.
Who: Folks in the Bay Area and beyond.
What: Help us design a public-friendly map of groundwater in California - for Californians.
When: Event: August 1, 2013 6:30 - 9 p.m.
Where: Stamen Offices 2017 Mission Street, San Francisco.
RSVP: E-mail email@example.com or tweet @chachasikes to RSVP.
Twitters: #cawater, #groundwater #datenight @maptimesf @stamen @CAWaterAtlas
What we are doing
Join us at @MapTimeSF at @stamen.
Our adventures in groundwater data reconnaissance has brought us to the gates of CASGEM. The Department of Water Resources (DWR) has provided a mapping and data portal for groundwater elevation data. CASGEM or "California Statewide Groundwater Elevation Monitoring" was launched in December of 2010 to help local agencies comply with Water Code Section 10927.
This summer we are doing the "Summer of Groundwater." We are working to make groundwater more understandable for Californians.
We are looking for volunteer user researchers to help make this project really valuable and easy-to-use for all Californians.
Why is matters
This is especially important because important regulations are in the process of going into place because our groundwater aquifers are being depleted in an unsustainable manner (because we are in a drought, among other reasons.)
After we launched the Water Rights Atlas in Sacramento, we had further conversations with Phil Crader from the State Water Resource Control board about how we can improve the accuracy and contextual understanding of the water rights dataset for web developers and water researchers.
To facilitate this, I created this github repository for documenting the dataset, with an extensive README file.
Notes from our Birds of a Feather session. Transcribed (as best as I could) by Chach Sikes
not wanting to do any kinds of mass imports
- no good datasets of amazon river basin -- idea to trace into OSM -- has big gaps & stuff missing - interested in how modeled in OSM - what kind of metadata? -- how to extract it and use in different ways -- has been cleaning up data & making detailed river networks -- is ism a good way to do it & how? what's best data model
We went to the State of the Map US 2013 conference this weekend in San Francisco.
This is the annual conference for the Open Street Map project (OSM)
We (myself and Laci) attended this conference because we view Open Street Map as an important project with a lot of potential for how we can improve public understanding of water in California.
6/10/2013 -- still editing this but you can read my draft that is in progress -- Chach
This collaborative platform is built using Mukurtu. Mukurtu is an installation of Drupal built with indigenous communities to manage cultural heritage.
The National Hydrography Data Set is a rich data model that describes many elements of surface water such as cartographic features, flow direction, elevation, and stream reach characteristics. The power of the NHD is when it is paired with data from stream gauges to forecast flooding, contamination, or habitat health. This vector data set is maintained by the USGS and has many concurrent lives within platforms both professional and academic.
An NHD Primer:
This is a first in a series of posts that chronicle our experiences discovering, compiling, and making groundwater data understandable in California.
A myriad of agencies at the local, state, and federal level collect data on groundwater quality and quantity. As expected, data formats vary and methods for retrieving data vary similarly. One agency often leads to another, and there is a high volume of what appear to be redundant data sets. (we will verify redundancy where we find it and update this post).