Excel · dataset · 2025
Suisun Marsh Salinity Control Gates Log
Listed in California Open Data
This log of operations includes: flashboard installation and removal dates, when tidal operations were started and stopped, and notes any technical issues.
Description
This current document is an Excel file that contains the data as a Table. The Table can be sorted or filtered, and can be read by scripting languages such as Python or R. The date and time are stored together in the DATETIME field.
The GATE 1, GATE 2, and GATE 3 fields state whether each gate is operating in Tidal Mode, set to Open, or set to Closed. The ACTION field states what operational change has occurred. The timestamped records go back to May 5, 2018.
Read the rest (2 more)
If prior dates are needed, refer to the Historical (Archived) Suisun Marsh Salinity Control Gates Log PDF, which contains records going back to November 1, 1998. This document replaces the Archived version because the Archived version did not contain a timestamp for every record. For the records that did have a timestamp, the timestamps were placed in the REMARKS field.
This issue, along with the document being a PDF file, created a problem for reading the data into time-series analysis software.
Links
Get the data
- Suisun Marsh Salinity Control Gates Log data.cnra.ca.gov/dataset/e76622ca-b6e9-4e78-a08e-deb9580d49b3/resource/265729e9… ↗
download · from data ca gov
- data.cnra.ca.gov /dataset/e76622ca-b6e9-4e78-a08e-deb9580d49b3/resource/7b3ab962… ↗
Historical (Archived) Suisun Marsh Salinity Control Gates Log
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/suisun-marsh-salinity-control-gates-log ↗
landing page · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=03a91d5f-77a0-434b-8aa9-66670cf1c… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Natural Resources · Water
- From keywords
- Earth & Environmental Science
- Inferred from text
- Tabular 65%
Provenance · 1 source records, 9 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 03a91d5f-77a0-434b-8aa9-66670cf1c1fc | 13 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| concepts[field].local:field:earth-environmental | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[modality].local:modality:tabular | enrichment · data ca gov | keyword-concept-rules@1.0.0 | title+description (65%) |
| concepts[topic].ckan_group:data_ca_gov:natural-resources | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:water | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |