• Skip to main content
  • Skip to Navigation
Skip to content
Help Data Portal NSF Logo
Ocean Observatories Initiative
  • About OOI
    • The Vision
    • Leadership
    • For Mariners
    • Glossary
    • Subscribe
    • Contact
  • The Observatory
    • Arrays
      • Global Argentine Basin Array
      • Global Irminger Sea Array
      • Global Southern Ocean Array
      • Global Station Papa Array
      • Coastal Endurance Array
      • Coastal Pioneer Array
      • Regional Cabled Array Overview
      • Cabled Continental Margin Array
      • Cabled Axial Seamount Array
      • Cabled Endurance Array
    • Infrastructure
      • Cabled Infrastructure
      • Moorings
      • Profilers
      • AUVs
      • Gliders
      • Cyberinfrastructure
    • Instruments
    • Sites
    • Data Products
      • Complete List
  • Data Access
    • How to Access Data
      • Data Explorer
      • Data Portal
      • Analytical Data Archive
      • Axial Seamount Live Video
      • CAM HD
      • Cruise Data
      • ERDDAP
      • M2M
      • PI-Added Instruments
      • Raw Data Archive
      • Python, Jupyter Notebooks
      • Data Status
    • Observation and Sampling Approaches
    • Ensuring Quality
      • Data Status
      • Quality Control
    • Partner Data Sites
    • How to Use and Cite Data
  • Data Tools
    • Community Tools and Datasets
    • Need Help?
      • Tutorials
      • Resources
      • Webinars
      • FAQs (Knowledge Base)
  • How to Participate
    • Adding Instruments or Platforms
    • Propose Modifications to Sampling
    • Deploying in OOI Areas
    • Cruise Participation
    • Loaning of OOI Equipment
    • Proposals
  • Science
    • Science Highlights
    • Science Questions
    • Projects and Related Research
    • Publications
  • What’s New
    • Expeditions & Program Updates
    • OOI In The News
    • Newsletter
    • Upcoming Events
    • Webinars
    • Workshops/Conferences
  • For Educators
  • Gallery
    • Image Gallery
    • Video Gallery
Home :: What's New ::New Discrete Water Sampling Spreadsheets Available

New Discrete Water Sampling Spreadsheets Available

Comparison of pCO2 data from the PCO2W instrument on the Pioneer Central Surface Mooring seafloor Multi-Function Node with water sampling data from Pioneer Cruises AT27 and AT31.

To provide context and comparison for data collected by OOI instrumentation, OOI collects and disseminates data collected by shipboard underway sensors and from water samples from CTD casts. Shipboard underway data are posted to the OOI Alfresco Document Management System, organized by cruise.  Each cruise folder contains a Ship Data folder in the format provided by the ship operators and a Water Sampling subfolder. The Water Sampling subfolder includes scanned and digitized versions of the CTD logs, as well as, discrete water sample analyses in the formats provided by the labs which conducted the analyses. To access Alfresco, users need to sign using “guest” for user name and password.

Collecting water samples from the CTD rosette on the Pioneer 8 cruise aboard the R/V Neil Armstrong. ©WHOI.

To make these data more easily accessible to the science community, we have developed a common template to provide a full set of discrete water sample data from a cruise. These “Discrete_Sample_Summary” spreadsheets include the details for each Niskin bottle fired on a CTD cast, the CTD instrument rosette data from the time of bottle closure, and the water sample data and quality flags based on World Ocean Circulation Experiment (WOCE) standards.

These CSV files with common data formats can easily be read and manipulated in MATLAB, Python, or other computing programs and languages. Because water analysis data are received at different times from different labs, these spreadsheets are updated as data become available.  An accompanying README file contains version history, general notes, and a description of the quality flags. The original spreadsheets from labs, which may contain additional data and methodology, will also be posted.

An example of how to read and use this discrete sample data can be found in this Jupyter notebook. Discrete_Sample_Summary spreadsheets have been posted for the Regional Cabled Array cruises 6-10, the Coastal Endurance Array cruises 1-13, and the Global Irminger Sea Array cruises 1-6.  We will continue to work on completing spreadsheets for past cruises as well as cruises going forward.

Comparison of dissolved oxygen data on the Washington Shelf Surface Mooring with water sampling data from Endurance Cruise 13. Data from Deployment 10 and Deployment 11 are plotted together, and overlap during 5-7 July.

Share this:

  • Facebook
  • Twitter
  • LinkedIn
  • Pocket
  • About OOI
    • The Vision
    • Leadership
    • For Mariners
    • Glossary
    • Subscribe
    • Contact
  • The Observatory
    • Arrays
      • Global Argentine Basin Array
      • Global Irminger Sea Array
      • Global Southern Ocean Array
      • Global Station Papa Array
      • Coastal Endurance Array
      • Coastal Pioneer Array
      • Regional Cabled Array Overview
      • Cabled Continental Margin Array
      • Cabled Axial Seamount Array
      • Cabled Endurance Array
    • Infrastructure
      • Cabled Infrastructure
      • Moorings
      • Profilers
      • AUVs
      • Gliders
      • Cyberinfrastructure
    • Instruments
    • Sites
    • Data Products
      • Complete List
  • Data Access
    • How to Access Data
      • Data Explorer
      • Data Portal
      • Analytical Data Archive
      • Axial Seamount Live Video
      • CAM HD
      • Cruise Data
      • ERDDAP
      • M2M
      • PI-Added Instruments
      • Raw Data Archive
      • Python, Jupyter Notebooks
      • Data Status
    • Observation and Sampling Approaches
    • Ensuring Quality
      • Data Status
      • Quality Control
    • Partner Data Sites
    • How to Use and Cite Data
  • Data Tools
    • Community Tools and Datasets
    • Need Help?
      • Tutorials
      • Resources
      • Webinars
      • FAQs (Knowledge Base)
  • How to Participate
    • Adding Instruments or Platforms
    • Propose Modifications to Sampling
    • Deploying in OOI Areas
    • Cruise Participation
    • Loaning of OOI Equipment
    • Proposals
  • Science
    • Science Highlights
    • Science Questions
    • Projects and Related Research
    • Publications
  • What’s New
    • Expeditions & Program Updates
    • OOI In The News
    • Newsletter
    • Upcoming Events
    • Webinars
    • Workshops/Conferences
  • For Educators
  • Gallery
    • Image Gallery
    • Video Gallery

NSF Logo

OOI Logo

Sign up for our newsletter to get the latest news from Ocean Observatories Initiative

Subscribe now

© 2020 Ocean Observatories Initiative. All Rights Reserved.

Funding for the Ocean Observatories Initiative is provided by the National Science Foundation through a Cooperative Agreement with Woods Hole Oceanographic Institution. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Internal | PMO/MIO Log in