ERDDAP Access

This page provides a few examples of some of the most common ERDDAP queries.
Detailed documentation on how to construct URL queries for ERDDAP datasets may be found in the official ERDDAP tabledap documentation.



Example Queries

LIST ALL AVAILABLE DATASETS
To view all available CORIOLIX ERDDAP data and metadata endpoints (as an HTML page):

https://sav-coriolix-shore.taani.oregonstate.edu/erddap/info/index.html


SENSOR METADATA
To get metadata for a specific data set (such as the list of variables and their attributes), use a URL like:

https://sav-coriolix-shore.taani.oregonstate.edu/erddap/info/datasetID/index.fileType

where fileType can be: .csv, .htmlTable, .itx, .json, .jsonlCSV1, .jsonlCSV, .jsonlKVP, .mat, .nc, .nccsv, .tsv, or .xhtml.


FULL RESOLUTION DATA
To retrieve data from a specific datetime interval at full resolution (as an HTML table):

https://sav-coriolix-shore.taani.oregonstate.edu/erddap/tabledap/tsg_flth_archive.htmlTable?time_raw%2Ctime%2Cconductivity%2Cconductivity_flags%2Csalinity%2Csalinity_flags%2Ctemperature%2Ctemperature_flags&time%3E=2021-06-01T12%3A45%3A00Z&time%3C=2021-06-01T14%3A45%3A00Z


NUMBER OF DATA RECORDS
To retrieve the number of data points within a specific time interval (as CSV) use orderByCount:

https://sav-coriolix-shore.taani.oregonstate.edu/erddap/tabledap/tsg_flth_archive.csv?time&time%3E=2021-06-01T12%3A45%3A00Z&time%3C=2021-06-01T14%3A45%3A00Z&orderByCount(%22%22)


DECIMATION
To retrieve every data point closest to the hour (as CSV) use orderByClosest:

https://sav-coriolix-shore.taani.oregonstate.edu/erddap/tabledap/tsg_flth_archive.csv?time_raw%2Ctime%2Cconductivity%2Cconductivity_flags%2Csalinity%2Csalinity_flags%2Ctemperature%2Ctemperature_flags&time%3E=2021-06-01T12%3A45%3A00Z&time%3C=2021-06-03T12%3A45%3A00Z&orderByClosest(%22time/hour%22)


CRUISE TRACK KML
To download the cruise track (1-minute bins) as kml over a specific date range:

https://sav-coriolix-shore.taani.oregonstate.edu/erddap/tabledap/binned_default_nav_rolling.kml?time%2Clatitude%2Clongitude&latitude%3E=-90&latitude%3C=90&longitude%3E=-180&longitude%3C=180&time%3E=2024-07-25T00%3A00%3A00Z&time%3C=2024-07-29T00%3A00%3A00Z&orderBy(%22time%22)

 
 
OSU logo NSF logo RCRV logo
RCRV Datapresence and Engineering Support Center
Oregon State University
Corvallis, OR 97331, USA