GCOOS Data Portal: Utilities & Downloads

This page contains some utilities developed by GCOOS that can be downloaded and used (please cite GCOOS when a GCOOS product is used).

GCOOS Assets

GCOOS MAP OF ASSETS

This is the URL,http://data.gcoos.org/fullView.php, to plot a map with GCOOS assets in full resolution. This page refreshes every 24 hours.

GCOOS Data Sources

PIE CHART SHOWING COUNTS FROM DATA SOURCES

This is the URL,http://data.gcoos.org/dataSourceFull.php, to plot a pie chart on the count of data in GCOOS repository by data source. This page refreshes every 24 hours.

Piechart of GCOOS Data Variable

PIE CHART SHOWING COUNTS PER PHENOMENON IN RECORD

This is the URL, http://data.gcoos.org/phenomenonFull.php, to plot a pie chart on the count of data in GCOOS repository by phenomenon observed. This page refreshes every 24 hours.

CUMMULATIVE TIME SERIES PLOT OF ATMOSPHERIC DATA IN GCOOS REPOSITORY

This is the URL, http://data.gcoos.org/drawChartAtmFull.php, to plot a cummulative time series plot of atmospheric data in GCOOS repository. This page refreshes every 24 hours.

CUMMULATIVE TIME SERIES PLOT OF OCEANOGRAPHIC DATA IN GCOOS REPOSITORY

This is the URL, http://data.gcoos.org/drawChartOcnFull.php, to plot a cummulative time series plot of oceanographic data in GCOOS repository. This page refreshes every 24 hours.

MONITORING INCOMING DATA FROM SOURCES

This module allows for a full screen display of the monitoring tabs. The general syntax is

http://data.gcoos.org/gcoos_displayR.php?org=<organization>&mono=1

where <organization> can either be TABS || TCOON || COMPS || LUMCON || WAVCIS || DISL || CenGOOS || NDBC || NOS || NERRS || ADCP || SCCF RECON || COAPS || FWRI

The variable mono is defaulted to 1 and it is a reserved variable for future use and activation. When loaded, this page will refres every hour. A timer (indicator) is shown to alert the refresh time.

 

Generate OWL files from SQLite table of Vocabularies

NOTE: The Marine Metadata Interoperability Project (MMI), of which GCOOS is an active participant, has developed a number of utilities to facilitate themapping of ontologies for data providers. The Resource Description Framework (RDF), a lightweight ontology system and fully compatible to Web Ontology Language (OWL), is the common framework employed by MMI. The following is an alternative to the Voc2RDF (developed by the Marine Metadata Interoperability Project) utility that you may use. This utility is use by GCOOS to auto-generate the RDF/OWL files required by the MMI registry as changes are made in the lists. PHP and SQLite3.x are required to successfully install this utility. The following is a step-by-step procedure on how to install this facility.

It will be noted that these package does not include modules to encode or manipulate data in the database. There are a nuber of freeware that can do the data encoding and manipulation job with great efficiency. The SQLite Manager is the author's choice (this one is an add-on to FireFox).

Click here to view a demonstration of this utility.

  1. Download the package by clicking here and expand the file onto a folder accessible by the web server. It should have the following:

    Item
    Description

    (1) srv_gcoos_voc.cfg

    This is the configuration file that contains the header parameters for the OWL generation.

    (2) srv_gcoos_generateOWL.php Module to generate the OWL files from data on the srv_gcoos_voc.cfg and the data in the SQLite database, gcoos_voc.sqlite.
    (3) srv_gcoos_generateCSV.php Module to generate the CSV files from data in the SQLite database, gcoos_voc.sqlite.
    (4) gcoos_voc.sqlite This is an SQLite database template and it contains some data for sample runs if needed. The updated database may also be download from: http://data.gcoos.org/data/gcoos_voc.sqlite
    (5) gcoos_vocabulary.php The core script used in the demonstration page (http://data.gcoos.org/gcoos_vocabulary.php).

  2. As is, you are ready to test the utility by accessing gcoos_vocabulary.php. However, if you want to configure the system to your needs, please proceed with the remaining steps outlined in this guide.
  3. Open the srv_gcoos_voc.cfg using any text editor and make the necessary changes and save the file as a simple text file. The file has the following structure:

    Line 1: This is the base URL for the OWL file (i.e. where you intent to save the output).
    Line 2: This is the title of the listing/compilation
    Line 3: This is a short description of what this collection contains
    Line 4: This is the name of the primary author
    Line 5: This is the general category (one word) for the collection (e.g. parameters, qaqc_flags)

    Please note that the entries are enclosed on double-qoutes.

  4. Open the SQLite database and make necessary edits to the listing/compilation as you see fit.
  5. If you want to change the location of the database for whatever reason, please edit the srv_gcoos_generateOWL.php and srv_gcoos_generateCSV.php, and change the $db values to connect to the right database. Also, in srv_gcoos_generateCSV.php, you may change the "Content-type" header to read header("Content-type: application/vnd.ms-excel") if you want to activate the save to file command.
  6. You are now ready to publish the scripts and test run the facility by accessing gcoos_vocabulary_example.php.

 

PLOTTING GCOOS Data

The following describes how to use the plotting routine of the GCOOS data portal. The link in the 'Monitoring' tab to list the GCOOS assets (http://data.gcoos.org/admin/get_gcoos_assets.php) provides a comperehensive list of possible values (hereafter referred to as simply 'Assets'). The 'Assets' table changes as the portal is upgraded, data sources added or removed.

The general syntax of the HTTP command to plot GCOOS Data is:

http://data.gcoos.org/plotData.php?network=<organization>&station=<station or platform name>&obs=<phenomena measured or observation type>{&sensorNumber=<sensor number>&rec=<24h || 7d || 30d>&width=<width in pixel>&height=<height in pixel>}

where <organization> can either be TABS || TCOON || COMPS || LUMCON || WAVCIS || DISL || CenGOOS || NDBC || NOS || NERRS || ADCP || SCCF RECON || COAPS || FWRI

NOTES:

  • 'rec' (default is '24h'), 'header' (default is 'yes'), width (default is 170px) and 'height' (default is 129px) are optional parameters.
  • In some cases, a platform may have more than one sensor to measure a phenomenon (e.g. currents). The 'sensorNumber' is in reference to the depth (refer to the 'Assets' table) at which the observation was made. The default value for this is '1', i.e. the first sensor as listed.
  • The rec' parameter can only be: (1) '24h' to plot the data collected in the last 24 hours, (2) '7d' to plot the week long data or (3) '30d' to plot the data collected in the last 30 days. The default is '24h'.

EXAMPLE:

To plot the 'airTemperature' data from '42039' station of NDBC for the last 24h, in a 300px by 200px plot:

http://data.gcoos.org/plotData.php?network=NDBC&station=42039&obs=airTemperature&sensorNumber=1&rec=24h&width=300&height=200