Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1036/4/7fa0cd6a570a1307dc7e5546aeb7cb0e | Name: | DWR Benthic raw count data 1975-2023 | Description: | Benthic invertebrate raw data from upper San Francisco Estuary, monitored by the Environmental Monitoring Program, 1975-2023. This data file is too large to open in most spreadsheet programs, and is most easily handled with a coding language like R or Python. The count data are the original counts of organisms per 0.052 m2 Ponar dredge sample. | Number of Records: | 7427280 | Number of Columns: | 18 |
| Table Structure |
---|
Object Name: | DWR Benthic raw count data 1975-2023.csv | Size: | 1502608045 byte | Authentication: | 0d90ecfa394358ef635e9fc1bbaac0cd
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | SampleDate | StationCode | LabSampleNumber | Grab | Year | Month | OrganismCode | Count | Phylum | Class_level | Order_level | Family_level | Genus | Species | Common_name | Location | Latitude | Longitude |
---|
Column Name: | SampleDate
| StationCode
| LabSampleNumber
| Grab
| Year
| Month
| OrganismCode
| Count
| Phylum
| Class_level
| Order_level
| Family_level
| Genus
| Species
| Common_name
| Location
| Latitude
| Longitude
| Definition: | Date sample was collected | Name of station where sample was collected; -C, -L, and -R denote the center, left bank, and right bank of the channel facing downstream. | Unique sample/grab identifier, assigned by taxonomists. | Identifying replicate grab number within a sampling event (one station, one date); assigned at random. Number of replicate grabs started at one in 1975, increased to three from 1976-1995, and has been four since 1996. | Year in which sample was collected | Month of year that the sample represents; a few samples were taken in the first or last days of adjoining months due to sampling logistics but are counted as the month of record. | Unique species identifier, which remains constant through data record regardless of taxonomic name changes. Number changes (i.e. when two species are merged into one, or misidentifications are corrected) are retroactively updated through data record, and synonyms are not preserved. | Number of organisms collected per Ponar grab sample (0.052 m2 of benthic sediment surface). In original data from taxonomists, only the species present are recorded; the zero (non-present) data points for all other species found through the data record are added to this datafile to allow for accurate averaging. | Phylum of organism; accurate to ITIS.gov | Class-type level of organism; not necessarily accurate according to ITIS.gov (may be superorder or subclass) but provided as a convenient second level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are updated and retroactively corrected in data record, and past synonyms are not preserved. | Order-type level of organism; not necessarily accurate according to ITIS.gov (may be superfamily or suborder) but provided as a convenient third level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Family-type level of organism; not necessarily accurate according to ITIS.gov (may be supergenus or subfamily) but provided as a convenient fourth level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Genus of organism; accurate to ITIS.gov and kept up to date as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Species of organism; accurate to ITIS.gov and kept up to date as much as possible. When species is listed as "sp. A" or similar, identification of organism was only possible to a higher taxonomic level and the species is a particular morphotype identified by our taxonomists (e.g. "Hyalella sp. A"). Name changes are retroactively updated in data record, and synonyms are not preserved. | Common name of organism, if known; many organisms have no common name. Not exhaustive, provided as a point of interest. Additions welcome to future versions of data. | Description of location and channel position where sample was taken. | WGS84 decimal degrees of latitude | WGS84 decimal degrees of longitude | Storage Type: | dateTime
| string
| string
| string
| string
| string
| string
| float
| string
| string
| string
| string
| string
| string
| string
| string
| float
| float
| Measurement Type: | dateTime | nominal | nominal | nominal | nominal | nominal | nominal | ratio | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | ratio | ratio | Measurement Values Domain: | Format | YYYY-MM-DDThh:mm:ssZ | Precision | |
| | | | | | | | | | | | | | | | | | Missing Value Code: | | | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1036/4/cd7a52aa283d8d9dd8e806537bd5772f | Name: | DWR Benthic CPUE data 1975-2023 | Description: | Benthic invertebrate CPUE data from upper San Francisco Estuary, monitored by the Environmental Monitoring Program, 1975-2023. This data is intended for a more casual user, and is condensed from the raw dataset to be more tractable for spreadsheet programs. The data have been converted to CPUE (organisms/m2), replicate grabs have been averaged for each site visit, and all non-occurrence (zero) data for a site visit has been removed (but can be re-added by pivoting to wide format). | Number of Records: | 78512 | Number of Columns: | 17 |
| Table Structure |
---|
Object Name: | DWR Benthic CPUE data 1975-2023.csv | Size: | 16631434 byte | Authentication: | 06d9c92c005a22d4e125056c4a6e0127
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | SampleDate | StationCode | Year | Month | OrganismCode | MeanCPUE | TotalGrabs | Phylum | Class_level | Order_level | Family_level | Genus | Species | Common name | Location | Latitude | Longitude |
---|
Column Name: | SampleDate
| StationCode
| Year
| Month
| OrganismCode
| MeanCPUE
| TotalGrabs
| Phylum
| Class_level
| Order_level
| Family_level
| Genus
| Species
| Common_name
| Location
| Latitude
| Longitude
| Definition: | Date sample was collected | Name of station where sample was collected; -C, -L, and -R denote the center, left bank, and right bank of the channel facing downstream. | Year in which sample was collected | Month of year that the sample represents; a few samples were taken in the first or last days of adjoining months due to sampling logistics but are counted as the month of record. | Unique species identifier, which remains constant through data record regardless of taxonomic name changes. Number changes (i.e. when two species are merged into one, or misidentifications are corrected) are retroactively updated through data record, and synonyms are not preserved. | Number of organisms collected per square meter of benthic sediment, averaged per sampling event. Estimated as (total number of organisms in all replicate grabs/number of replicate grabs)/(0.052 m2 per grab). | Number of replicate samples that were averaged to create the mean CPUE. Provided to give a sense of relative reliability of CPUE. Note that lower numbers of grabs is correlated with lower total biodiversity observed, so temporal trends of diversity should be corrected for sampling effort. Numbers range from 1 in 1975, to 3 from 1976-1995, to 4 from 1996 to present. Lower numbers of grabs relative to adjacent sampling events indicate missing data. | Phylum of organism; accurate to ITIS.gov | Class-type level of organism; not necessarily accurate according to ITIS.gov (may be superorder or subclass) but provided as a convenient second level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are updated and retroactively corrected in data record, and past synonyms are not preserved. | Order-type level of organism; not necessarily accurate according to ITIS.gov (may be superfamily or suborder) but provided as a convenient third level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Family-type level of organism; not necessarily accurate according to ITIS.gov (may be supergenus or subfamily) but provided as a convenient fourth level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Genus of organism; accurate to ITIS.gov and kept up to date as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Species of organism; accurate to ITIS.gov and kept up to date as much as possible. When species is listed as "sp. A" or similar, identification of organism was only possible to a higher taxonomic level and the species is a particular morphotype identified by our taxonomists (e.g. "Hyalella sp. A"). Name changes are retroactively updated in data record, and synonyms are not preserved. | Common name of organism, if known; many organisms have no common name. Not exhaustive, provided as a point of interest. Additions welcome to future versions of data. | Description of location and channel position where sample was taken. | WGS84 decimal degrees of latitude | WGS84 decimal degrees of longitude | Storage Type: | dateTime
| string
| float
| string
| string
| float
| float
| string
| string
| string
| string
| string
| string
| string
| string
| float
| float
| Measurement Type: | dateTime | nominal | nominal | nominal | nominal | ratio | ratio | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | ratio | ratio | Measurement Values Domain: | Format | YYYY-MM-DDThh:mm:ssZ | Precision | |
| | | | | Unit | numberPerMeterSquared | Type | real |
| | | | | | | | | | | | Missing Value Code: | | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | DWR benthic monitoring, active and historic site locations.csv | Size: | 4896 byte | Authentication: | cb8295750a36d92105ba9f47d98e3133
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | Site Code | Location and channel position facing downstream | Latitude | Longitude | Period of Record (From) | Period of Record (To) | Missing | Status |
---|
Column Name: | StationCode
| Location
| Latitude
| Longitude
| Period_of_Record_From
| Period_of_Record_To
| Missing
| Status
| Definition: | Name of station where sample was collected; -C, -L, and -R denote the center, left bank, and right bank of the channel facing downstream. | Description of waterbody and position within waterbody where site is located | WGS84 decimal degrees of latitude | WGS84 decimal degrees of longitude | Earliest years during which sampling occurred | Latest years during which sampling occurred | Years in which there was a hiatus in sampling at the site. A more precise accounting of which time points are missing data for each site can be found in the "DWR benthic monitoring, missing data" table. | "Active" indicates site is currently sampled; "Historic" indicates site was only sampled in the past | Storage Type: | string
| string
| float
| float
| string
| string
| string
| string
| Measurement Type: | nominal | nominal | ratio | ratio | nominal | nominal | nominal | nominal | Measurement Values Domain: | | | | | | | | | Missing Value Code: | | | | | | | | | Accuracy Report: | | | | | | | | | Accuracy Assessment: | | | | | | | | | Coverage: | | | | | | | | | Methods: | | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1036/4/d0f0dd3c1835fe5b669342f8c8e77024 | Name: | DWR benthic monitoring, organism keylist | Description: | This data table lists all species that have been found, or were expected to be found, in the course of the Environmental Monitoring Program's mandated monitoring and special studies, including work outside the geographic bounds of this sampling program. Not all species listed here are found in the sampling data, and this data table is neither a definitive species list detected by our program, nor a metric of species richness. This data table is provided as a convenience to data users and sampling staff about what species might conceivably be found by benthic sampling in the upper San Francisco Estuary. | Number of Records: | 472 | Number of Columns: | 8 |
| Table Structure |
---|
Object Name: | Benthic organism keylist 2023.csv | Size: | 38286 byte | Authentication: | 3f9af417cad7e28f17d7564cfccc200a
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | OrganismCode | Phylum | Class_level | Order_level | Family_level | Genus | Species | Common name |
---|
Column Name: | OrganismCode
| Phylum
| Class_level
| Order_level
| Family_level
| Genus
| Species
| Common_name
| Definition: | Unique species identifier, which remains constant through data record regardless of taxonomic name changes. Number changes (i.e. when two species are merged into one, or misidentifications are corrected) are retroactively updated through data record, and synonyms are not preserved. | Phylum of organism; accurate to ITIS.gov | Class-type level of organism; not necessarily accurate according to ITIS.gov (may be superorder or subclass) but provided as a convenient second level of taxonomic organization; kept up to current taxonomic definitions as much as possible | Order-type level of organism; not necessarily accurate according to ITIS.gov (may be superfamily or suborder) but provided as a convenient third level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Family-type level of organism; not necessarily accurate according to ITIS.gov (may be supergenus or subfamily) but provided as a convenient fourth level of taxonomic organization; kept up to current taxonomic definitions as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Genus of organism; accurate to ITIS.gov and kept up to date as much as possible. Name changes are retroactively updated in data record, and synonyms are not preserved. | Species of organism; accurate to ITIS.gov and kept up to date as much as possible. When species is listed as "sp. A" or similar, identification of organism was only possible to a higher taxonomic level and the species is a particular morphotype identified by our taxonomists (e.g. "Hyalella sp. A"). Name changes are retroactively updated in data record, and synonyms are not preserved. | Common name of organism, if known; many organisms have no common name. Not exhaustive, provided as a point of interest. Additions welcome to future versions of data. | Storage Type: | string
| string
| string
| string
| string
| string
| string
| string
| Measurement Type: | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | Measurement Values Domain: | | | | | | | | | Missing Value Code: | | | | | | | | | Accuracy Report: | | | | | | | | | Accuracy Assessment: | | | | | | | | | Coverage: | | | | | | | | | Methods: | | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1036/4/a3d2580164bf06b94f1ff3145b819ade | Name: | DWR Benthic monitoring, total annual site visits, 1975-2023 | Description: | This data table documents how many site visits were conducted at each site in each year. It is provided as a convenience to data users who want to understand the structure of the data record, and compare levels of sampling effort at different times through the period of record. Since many sites were visited for only part of the period of EMP's sampling and there are many more historic than active sites, documenting the site visits in data table form was more precise than writing a narrative description. | Number of Records: | 2597 | Number of Columns: | 3 |
| Table Structure |
---|
Object Name: | DWR Benthic monitoring, total annual site visits, 1975-2023.csv | Size: | 35976 byte | Authentication: | 8e3a244221ebfcba0a362ce23bf9f748
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | StationCode | Year | Number of site visits |
---|
Column Name: | StationCode
| Year
| Number of site visits
| Definition: | Name of station where sample was collected; -C, -L, and -R denote the center, left bank, and right bank of the channel facing downstream. | Year of site visit | Total number of visits to a site in a year. Used as a way of understanding data structure and sampling effort over period of monitoring. | Storage Type: | string
| string
| float
| Measurement Type: | nominal | nominal | ratio | Measurement Values Domain: | | | | Missing Value Code: | | | | Accuracy Report: | | | | Accuracy Assessment: | | | | Coverage: | | | | Methods: | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1036/4/84539dd9c541ca53ee195330368dc531 | Name: | DWR Benthic monitoring, total annual grab samples, 1975-2023 | Description: | This data table documents how many total grab samples were collected at each site in each year. It is provided as a convenience to data users who want to understand the structure of the data record, and compare levels of sampling effort at different times through the period of record. Since many sites were visited for only part of the period of EMP's sampling and there are many more historic than active sites, documenting the number of grab samples in data table form was more precise than writing a narrative description. | Number of Records: | 2597 | Number of Columns: | 3 |
| Table Structure |
---|
Object Name: | DWR Benthic monitoring, total annual grab samples, 1975-2023.csv | Size: | 36028 byte | Authentication: | 8c29841c2be5806a7cedeff1e12fb969
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | StationCode | Year | Number of grab samples |
---|
Column Name: | StationCode
| Year
| Number of grab samples
| Definition: | Name of station where sample was collected; -C, -L, and -R denote the center, left bank, and right bank of the channel facing downstream. | Year in which samples were collected | Total number of grab samples taken at a site in a year. Used as a way of understanding data structure and sampling effort over period of monitoring. | Storage Type: | string
| string
| float
| Measurement Type: | nominal | nominal | ratio | Measurement Values Domain: | | | | Missing Value Code: | | | | Accuracy Report: | | | | Accuracy Assessment: | | | | Coverage: | | | | Methods: | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1036/4/da6092b805cb0d6379c4b61c774331d2 | Name: | DWR Benthic monitoring, missing data | Description: | This data table compiles the occasions on which benthic invertebrate data does not exist for a survey site in a given month. It was was compiled by reviewing the data record of site visits and grab totals. Data was designated as missing all grabs on a given date if the site had been sampled at dates both earlier and later than the date in question; many of the early "missing" dates may not be truly missing, since since the sampling design from 1975-mid 1979 was still being settled. Data was counted as missing some grab samples when the total grabs taken at a site in a given month was smaller than the number taken at other sites in in that month. | Number of Records: | 249 | Number of Columns: | 6 |
| Table Structure |
---|
Object Name: | DWR Benthic monitoring, missing data 1975-2023.csv | Size: | 18238 byte | Authentication: | 1723e963e3d71ef39abde966fb440aa4
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | Station | Year | Month | Number of grab samples missing | All potential grabs missing | Notes |
---|
Column Name: | Station
| Year
| Month
| Number of grab samples missing
| All potential grabs missing
| Notes
| Definition: | Name of station where sample was collected; -C, -L, and -R denote the center, left bank, and right bank of the channel facing downstream. | Year in which samples were expected to be collected | Month of year that samples were expected to be collected. | The number of grab samples for which there is no data, which were expected to be collected at that site and date. | Identifies whether the missing data constitutes all of the data expected for that site and date ("Yes") or whether some data exists for that site and date but the number of total grabs is lower than expected ("No"). | Any notes or comments about the reason behind the missing data. For many dates pre-2000, the reasons for the lack of data are not known. | Storage Type: | string
| string
| string
| float
| string
| string
| Measurement Type: | nominal | nominal | nominal | ratio | nominal | nominal | Measurement Values Domain: | | | | | | | Missing Value Code: | | | | | | | Accuracy Report: | | | | | | | Accuracy Assessment: | | | | | | | Coverage: | | | | | | | Methods: | | | | | | |
|
|