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.
LIST ALL AVAILABLE DATASETS
To view all available CORIOLIX ERDDAP data and metadata endpoints (as an HTML page):
https://coriolix.ceoas.oregonstate.edu/endeavor/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://coriolix.ceoas.oregonstate.edu/endeavor/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://coriolix.ceoas.oregonstate.edu/endeavor/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://coriolix.ceoas.oregonstate.edu/endeavor/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://coriolix.ceoas.oregonstate.edu/endeavor/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://coriolix.ceoas.oregonstate.edu/endeavor/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)