BCO-DMO ERDDAP
Accessing BCO-DMO data
log in    
Brought to you by BCO-DMO    

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Cleaner and host species observed on Bahamian reefs under varying experimental
conditions in Eleuthera, Bahamas in 2012 (Lionfish Invasion project)
Subscribe RSS
Institution:  BCO-DMO   (Dataset ID: bcodmo_dataset_3907)
Information:  Summary ? | License ? | ISO 19115 | Metadata | Background (external link) | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ?
Optional
Constraint #2 ?
   Minimum ?
 
   Maximum ?
 
 site (text) ?          "DP_L10A"    "Twin_Peaks"
 latitude (degrees_north) ?          24.77438    24.81488
  < slider >
 longitude (degrees_east) ?          -76.34968    -76.32305
  < slider >
 station_descrip (text) ?          "Ma/Mh_on_S_side"    "large_Mc_inshore"
 treatment (text) ?          "CECR"    "PTVO"
 date (unitless) ?          "08/09/2012"    "08/31/2012"
 time_start (HHMM.mm) ?          1001.0    1657.77
 time_end (HHMM.mm) ?          1011.0    1707.77
 time_elapsed (MM:SS) ?          "00:01"    "17:14"
 sequence (dimensionless) ?          1    3
 species_cleaner1 (text) ?          "Bodianus rufus"    "none"
 species_code_cleaner1 (text (code)) ?          "BORU"    "none"
 len_tot_cleaner1 (cm) ?          1.0    7.0
 species_cleaner2 (text) ?          "Bodianus rufus"    "none"
 species_code_cleaner2 (text (code)) ?          "BORU"    "none"
 len_tot_cleaner2 (cm) ?          1.0    6.0
 species_cleaner3 (text) ?          "Bodianus_rufus"    "none"
 species_code_cleaner3 (text (code)) ?          "BORU"    "none"
 len_tot_cleaner3 (cm) ?          2.0    5.0
 species_client (text) ?          "Abudefduf_saxatilis"    "none"
 species_code_client (text (code)) ?          "ABSA"    "none"
 len_tot_client (cm) ?          4    40
 notes (text) ?          "NaN"    "Note: ~3m away"
 
Server-side Functions ?
 distinct() ?
? ("Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.")

File type: (more info)

(Documentation / Bypass this form ? )
 
(Please be patient. It may take a while to get the data.)


 

The Dataset Attribute Structure (.das) for this Dataset

Attributes {
 s {
  site {
    String bcodmo_name "site";
    String description "Name of reef on which the trial was run.";
    String long_name "Site";
    String units "text";
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue NaN;
    Float64 actual_range 24.77438, 24.81488;
    String axis "Y";
    String bcodmo_name "latitude";
    Float64 colorBarMaximum 90.0;
    Float64 colorBarMinimum -90.0;
    String description "Latitude of the experiment site.";
    String ioos_category "Location";
    String long_name "Latitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LATX/";
    String standard_name "latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 _FillValue NaN;
    Float64 actual_range -76.34968, -76.32305;
    String axis "X";
    String bcodmo_name "longitude";
    Float64 colorBarMaximum 180.0;
    Float64 colorBarMinimum -180.0;
    String description "Longitude of the experiment site.";
    String ioos_category "Location";
    String long_name "Longitude";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P09/current/LONX/";
    String standard_name "longitude";
    String units "degrees_east";
  }
  station_descrip {
    String bcodmo_name "site_descrip";
    String description "Identifying characteristics of cleaning station used in trial.";
    String long_name "Station Descrip";
    String units "text";
  }
  treatment {
    String bcodmo_name "unknown";
    String description 
"What the bottle contained during the observation period.
CECR = Cephalopholis cruentata (gatsby grouper)
PTVO = Pterois volitans (lionfish)";
    String long_name "Treatment";
    String units "text";
  }
  date {
    String bcodmo_name "date";
    String description "Date on which trial was run in mm/dd/YYYY format.";
    String long_name "Date";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/ADATAA01/";
    String source_name "date";
    String time_precision "1970-01-01";
    String units "unitless";
  }
  time_start {
    Float32 _FillValue NaN;
    Float32 actual_range 1001.0, 1657.77;
    String bcodmo_name "time_start";
    String description "Time when observation period began; 24-hour clock. Converted from HH:MM:SS format to hours, minutes, and decimal minutes.";
    String long_name "Time Start";
    String units "HHMM.mm";
  }
  time_end {
    Float32 _FillValue NaN;
    Float32 actual_range 1011.0, 1707.77;
    String bcodmo_name "time_end";
    String description "Time when observation period ended; 24-hour clock. Converted from HH:MM:SS format to hours, minutes, and decimal minutes.";
    String long_name "Time End";
    String units "HHMM.mm";
  }
  time_elapsed {
    String bcodmo_name "time_elapsed";
    String description "How long the observation period lasted, in minutes and seconds.";
    String long_name "Time Elapsed";
    String nerc_identifier "https://vocab.nerc.ac.uk/collection/P01/current/ELTMZZZZ/";
    String units "MM:SS";
  }
  sequence {
    Byte _FillValue 127;
    Byte actual_range 1, 3;
    String bcodmo_name "unknown";
    String description "Order in which the treatment was executed, in relation to other 2 treatments (either first=\"1\", second=\"2\", or third=\"3\").";
    String long_name "Sequence";
    String units "dimensionless";
  }
  species_cleaner1 {
    String bcodmo_name "species";
    String description "Name of first cleaner species observed.";
    String long_name "Species Cleaner1";
    String units "text";
  }
  species_code_cleaner1 {
    String bcodmo_name "taxon_code";
    String description "Species code of first cleaner organism.";
    String long_name "Species Code Cleaner1";
    String units "text (code)";
  }
  len_tot_cleaner1 {
    Float32 _FillValue NaN;
    Float32 actual_range 1.0, 7.0;
    String bcodmo_name "fish_len";
    String description "Estimated total length of first cleaner in centimeters.";
    String long_name "Len Tot Cleaner1";
    String units "cm";
  }
  species_cleaner2 {
    String bcodmo_name "species";
    String description "Name of second cleaner species observed.";
    String long_name "Species Cleaner2";
    String units "text";
  }
  species_code_cleaner2 {
    String bcodmo_name "taxon_code";
    String description "Species code of second cleaner organism.";
    String long_name "Species Code Cleaner2";
    String units "text (code)";
  }
  len_tot_cleaner2 {
    Float32 _FillValue NaN;
    Float32 actual_range 1.0, 6.0;
    String bcodmo_name "fish_len";
    String description "Estimated total length of second cleaner in centimeters.";
    String long_name "Len Tot Cleaner2";
    String units "cm";
  }
  species_cleaner3 {
    String bcodmo_name "species";
    String description "Name of third cleaner species observed.";
    String long_name "Species Cleaner3";
    String units "text";
  }
  species_code_cleaner3 {
    String bcodmo_name "taxon_code";
    String description "Species code of third cleaner organism.";
    String long_name "Species Code Cleaner3";
    String units "text (code)";
  }
  len_tot_cleaner3 {
    Float32 _FillValue NaN;
    Float32 actual_range 2.0, 5.0;
    String bcodmo_name "fish_len";
    String description "Estimated total length of third cleaner in centimeters.";
    String long_name "Len Tot Cleaner3";
    String units "cm";
  }
  species_client {
    String bcodmo_name "species";
    String description "Name of the client species.";
    String long_name "Species Client";
    String units "text";
  }
  species_code_client {
    String bcodmo_name "taxon_code";
    String description "Species code of client fish being cleaned by cleaner(s) in corresponding row.";
    String long_name "Species Code Client";
    String units "text (code)";
  }
  len_tot_client {
    Byte _FillValue 127;
    Byte actual_range 4, 40;
    String bcodmo_name "fish_len";
    String description "Estimated total length of client in centimeters.";
    String long_name "Len Tot Client";
    String units "cm";
  }
  notes {
    String bcodmo_name "comment";
    String description "Notes related to the observations or trial.";
    String long_name "Notes";
    String units "text";
  }
 }
  NC_GLOBAL {
    String access_formats ".htmlTable,.csv,.json,.mat,.nc,.tsv,.esriCsv,.geoJson";
    String acquisition_description 
"An experiment on Bahamian reefs was conducted in which cleaning stations were
observed after placing clear-plastic bottles in random sequence next to the
station: one with an invasive lionfish (Pterois volitans) inside, one with an
ecologically similar native predator (graysby grouper, Cephalopholis
cruentata), and one as an empty bottle control. For many 10-minute intervals
at each of 6 cleaning stations, all cleaners and clients within 2 m of the
bottle were recorded and their total lengths were estimated (to the nearest
cm). The time spent cleaning or being cleaned was also recorded.";
    String awards_0_award_nid "55160";
    String awards_0_award_number "OCE-0851162";
    String awards_0_data_url "http://www.nsf.gov/awardsearch/showAward.do?AwardNumber=0851162";
    String awards_0_funder_name "NSF Division of Ocean Sciences";
    String awards_0_funding_acronym "NSF OCE";
    String awards_0_funding_source_nid "355";
    String awards_0_program_manager "David L. Garrison";
    String awards_0_program_manager_nid "50534";
    String cdm_data_type "Other";
    String comment 
"Lionfish-cleaner bottle experiment 
 (From sub-project \"Lionfish Cleaner bottle expt 2012\") 
 Lead PI: Mark Hixon (OSU) 
 Sub-Project Lead: Lillian J. Tuttle (OSU) 
 Version: 03 April 2013";
    String Conventions "COARDS, CF-1.6, ACDD-1.3";
    String creator_email "info@bco-dmo.org";
    String creator_name "BCO-DMO";
    String creator_type "institution";
    String creator_url "https://www.bco-dmo.org/";
    String data_source "extract_data_as_tsv version 2.3  19 Dec 2019";
    String date_created "2013-04-08T15:35:40Z";
    String date_modified "2019-10-28T17:33:02Z";
    String defaultDataQuery "&amp;time&lt;now";
    String doi "10.1575/1912/bco-dmo.3907.1";
    Float64 Easternmost_Easting -76.32305;
    Float64 geospatial_lat_max 24.81488;
    Float64 geospatial_lat_min 24.77438;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -76.32305;
    Float64 geospatial_lon_min -76.34968;
    String geospatial_lon_units "degrees_east";
    String history 
"2021-10-18T16:52:36Z (local files)
2021-10-18T16:52:36Z https://erddap.bco-dmo.org/erddap/tabledap/bcodmo_dataset_3907.html";
    String infoUrl "https://www.bco-dmo.org/dataset/3907";
    String institution "BCO-DMO";
    String keywords "bco, bco-dmo, biological, chemical, cleaner1, cleaner2, cleaner3, client, code, data, dataset, date, descrip, dmo, elapsed, end, erddap, latitude, len, len_tot_cleaner1, len_tot_cleaner2, len_tot_cleaner3, len_tot_client, longitude, management, notes, oceanography, office, preliminary, sequence, site, species, species_cleaner1, species_cleaner2, species_cleaner3, species_client, species_code_cleaner1, species_code_cleaner2, species_code_cleaner3, species_code_client, start, station, station_descrip, time, time_elapsed, time_end, time_start, tot, treatment";
    String license "https://www.bco-dmo.org/dataset/3907/license";
    String metadata_source "https://www.bco-dmo.org/api/dataset/3907";
    Float64 Northernmost_Northing 24.81488;
    String param_mapping "{'3907': {'lat': 'master - latitude', 'lon': 'master - longitude'}}";
    String parameter_source "https://www.bco-dmo.org/mapserver/dataset/3907/parameters";
    String people_0_affiliation "Oregon State University";
    String people_0_affiliation_acronym "OSU";
    String people_0_person_name "Mark Hixon";
    String people_0_person_nid "51647";
    String people_0_role "Lead Principal Investigator";
    String people_0_role_type "originator";
    String people_1_affiliation "Oregon State University";
    String people_1_affiliation_acronym "OSU";
    String people_1_person_name "Lillian  J Tuttle";
    String people_1_person_nid "51662";
    String people_1_role "Scientist";
    String people_1_role_type "originator";
    String people_2_affiliation "Woods Hole Oceanographic Institution";
    String people_2_affiliation_acronym "WHOI BCO-DMO";
    String people_2_person_name "Shannon Rauch";
    String people_2_person_nid "51498";
    String people_2_role "BCO-DMO Data Manager";
    String people_2_role_type "related";
    String project "Lionfish Invasion";
    String projects_0_acronym "Lionfish Invasion";
    String projects_0_description 
"Invasive species are increasingly introduced by human activities to new regions of the world where those species have never existed previously. In the absence of natural enemies (predators, competitors, and diseases) from their homeland, invasives may have strong negative effects on invaded ecosystems, especially systems with fewer species (\"ecological release\"), and may even drive native species extinct. However, if native natural enemies can somehow control the invaders (\"ecological resistance\"), then ecological disruption can be prevented or at least moderated. Most of the many invasive species in the sea have been seaweeds and invertebrates, and the few documented invasive marine fishes have not caused major problems. However, this situation has recently changed in a stunning and ominous way. In the early 1990s, lionfish (Pterois volitans) from the Pacific Ocean were accidentally or intentionally released from aquaria to the ocean in the vicinity of Florida. Camouflaged by shape and color, protected by venomous spines, consuming native coral-reef fishes voraciously, and reproducing rapidly, lionfish have subsequently undergone a population explosion. They now range from the mid-Atlantic coast of the US to the Caribbean, including the Bahamas. Native Atlantic fishes have never before encountered this spiny, stealthy, efficient predator and seldom take evasive action. In fact, the investigator has documented that a single lionfish is capable of reducing the abundance of small fish on a small coral patch reef by nearly 80% in just 5 weeks. There is great concern that invasive lionfish may severely reduce the abundance of native coral-reef fishes important as food for humans (e.g., grouper and snapper in their juvenile stages) as well as species that normally maintain the integrity of coral reefs (e.g., grazing parrotfishes that can prevent seaweeds from smothering corals). There are far more species of coral-reef fish in the Pacific than the Atlantic, so this invasion may represent a case of extreme ecological release with minor ecological resistance. Dr. Hixon and colleagues will study the mechanisms of ecological release in lionfish, as well as examine potential sources of ecological resistance in the heavily invaded Bahamas. Because very little is known about the ecology and behavior of lionfish in their native Pacific range, he will also conduct comparative studies in both oceans, which may provide clues regarding the extreme success of this invasion. In the Bahamas, the investigator will document the direct and indirect effects on native species of the ecological release of lionfish, both as a predator and as a competitor. These studies will be conducted at various scales of time and space, from short-term experiments on small patch reefs, to long-term experiments and observations on large reefs. Whereas direct effects involve mostly changes in the abundance of native species, indirect effects can be highly variable. For example, lionfish may actually indirectly benefit some native species by either consuming or outcompeting the competitors of those natives. The project will explore possible ecological resistance to the invasion by determining whether any native Bahamian species are effective natural enemies of lionfish, including predators, parasites, and competitors of both juvenile and adult lionfish. Comparative studies of natural enemies, as well as lionfish ecology and behavior, in both the Atlantic and the Pacific may provide clues regarding the explosive spread of lionfish in the Atlantic.
Regarding broader impacts, this basic research will provide information valuable to coral-reef and fisheries managers fighting the lionfish invasion in the US, the Bahamas, and the greater Caribbean, especially if sources of native ecological resistance are identified. The study will fund the PhD research of U.S. graduate students, as well as involve assistance and participation by a broad variety of undergraduates and reef/fisheries managers, including women, minorities, native Bahamians, and native Pacific islanders. Participation in this project will promote education in marine ecology and conservation biology directly via Dr. Hixon's and graduate students' teaching and outreach activities, and indirectly via the experiences of undergraduate field assistants and various associates.";
    String projects_0_end_date "2012-11";
    String projects_0_geolocation "Bahamas; Cayman Islands; Mariana Islands; Philippines";
    String projects_0_name "Ecological Release and Resistance at Sea: Invasion of Atlantic Coral Reefs by Pacific Lionfish";
    String projects_0_project_nid "2256";
    String projects_0_project_website "http://hixon.science.oregonstate.edu/content/highlight-lionfish-invasion";
    String projects_0_start_date "2009-06";
    String publisher_name "Biological and Chemical Oceanographic Data Management Office (BCO-DMO)";
    String publisher_type "institution";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 24.77438;
    String standard_name_vocabulary "CF Standard Name Table v55";
    String summary "Cleaner and host species observed on Bahamian reefs under varying experimental conditions in Eleuthera, Bahamas in 2012 (Lionfish Invasion project).";
    String title "Cleaner and host species observed on Bahamian reefs under varying experimental conditions in Eleuthera, Bahamas in 2012 (Lionfish Invasion project)";
    String version "1";
    Float64 Westernmost_Easting -76.34968;
    String xml_source "osprey2erddap.update_xml() v1.3";
  }
}

 

Using tabledap to Request Data and Graphs from Tabular Datasets

tabledap lets you request a data subset, a graph, or a map from a tabular dataset (for example, buoy data), via a specially formed URL. tabledap uses the OPeNDAP (external link) Data Access Protocol (DAP) (external link) and its selection constraints (external link).

The URL specifies what you want: the dataset, a description of the graph or the subset of the data, and the file type for the response.

Tabledap request URLs must be in the form
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/datasetID.fileType{?query}
For example,
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/pmelTaoDySst.htmlTable?longitude,latitude,time,station,wmo_platform_code,T_25&time>=2015-05-23T12:00:00Z&time<=2015-05-31T12:00:00Z
Thus, the query is often a comma-separated list of desired variable names, followed by a collection of constraints (e.g., variable<value), each preceded by '&' (which is interpreted as "AND").

For details, see the tabledap Documentation.


 
ERDDAP, Version 2.02
Disclaimers | Privacy Policy | Contact