Oxygen Exposure Of Southern California Megafauna by Kaggle | Other

About this Dataset

Oxygen Exposure Of Southern California Megafauna

Oxygen Exposure of Southern California Megafauna

Spatial and Temporal Variations of Species Tolerance and Habitat Affinity

About this dataset

This dataset provides a valuable glimpse into the varying levels of oxygen exposure experienced by 53 different species of common benthic megafauna living off the coast of San Diego, CA, between 2012 and 2014. When collected, these data were recorded during one of the lowest periods for oxygen production in 30 years - making them invaluable for gleaning insight into how shifts in available oxygen can affect migrating and/or endemic species. The dataset includes not only records on depths and levels of underwater oxygen concentration but also details on taxa, mobility type and habitat preference. With this information we can gain an understanding not only on a species' tolerance to changing conditions in their local environment but also look at patterns more widely with respect to spatial distributions as well as temporal events

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

All files are avaible in the downloads tab of the dataset.

Unzip the files provided in the Downloads tab on Kaggle

To analyze oxygen concentrations of common benthic megafauna with respect to their spatial and temporal distributions, open ROVObservationData.csv

To explore taxonomy, mobility level and habitat preferences of 53 observed species, open SpeciesMetadata.csv

Research Ideas

This dataset could be used to analyze the impacts of changing ocean temperatures and oxygen levels on species composition and distribution - particularly with areas where man-made climate change is more severe or pronounced.

This dataset could be used to model the effects of increased fishing pressure, nutrient inputs, and other coastal human activities on species tolerance thresholds for different oxygen levels over time.

This dataset can also be used to connect measurable environmental factors such as temperature or oxygen levels as predictors of habitat preference for certain species or groups of species over time in an area

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: ROVObservationData.csv

File: SpeciesMetadata.csv

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Rovobservationdata

@kaggle.thedevastator_oxygen_exposure_of_southern_california_megafauna.rovobservationdata

185.94 KB
2404 rows
120 columns


CREATE TABLE rovobservationdata (
  "datetime" TIMESTAMP,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "depth" DOUBLE,
  "temp" DOUBLE,
  "sal" DOUBLE,
  "oxy" DOUBLE,
  "grain" VARCHAR,
  "bedform" VARCHAR,
  "ac" BIGINT,
  "ae" BIGINT,
  "an" BIGINT,
  "ap" BIGINT,
  "as" BIGINT,
  "ba" BIGINT,
  "bas" BIGINT,
  "bc" BIGINT,
  "bgo" BIGINT,
  "bgu" BIGINT,
  "bi" BIGINT,
  "bo" BIGINT,
  "br" BIGINT,
  "bs" BIGINT,
  "ca" BIGINT,
  "cc" BIGINT,
  "cd" BIGINT,
  "cg" BIGINT,
  "ch" BIGINT,
  "com" BIGINT,
  "cp" BIGINT,
  "cr" BIGINT,
  "cs" BIGINT,
  "cu" BIGINT,
  "de" BIGINT,
  "dp" BIGINT,
  "eo" BIGINT,
  "ep" BIGINT,
  "eu" BIGINT,
  "fej" BIGINT,
  "fl" BIGINT,
  "fo" BIGINT,
  "fr" BIGINT,
  "go" BIGINT,
  "ha" BIGINT,
  "hal" BIGINT,
  "hb" BIGINT,
  "hl" BIGINT,
  "ii" BIGINT,
  "io" BIGINT,
  "ir" BIGINT,
  "jde" BIGINT,
  "jm" BIGINT,
  "kb" BIGINT,
  "kw" DOUBLE,
  "lc" BIGINT,
  "lcom" BIGINT,
  "li" BIGINT,
  "ln" BIGINT,
  "lo" BIGINT,
  "ls" BIGINT,
  "lss" BIGINT,
  "lu" BIGINT,
  "ly" BIGINT,
  "lz" BIGINT,
  "mc" BIGINT,
  "mr" DOUBLE,
  "ms" BIGINT,
  "mse" BIGINT,
  "ol" BIGINT,
  "ow" BIGINT,
  "pa" BIGINT,
  "pc" BIGINT,
  "pem" BIGINT,
  "pg" BIGINT,
  "ph" BIGINT,
  "pi" BIGINT,
  "pl" BIGINT,
  "po" BIGINT,
  "pp" BIGINT,
  "ppl" BIGINT,
  "ps" BIGINT,
  "pt" BIGINT,
  "pyr" BIGINT,
  "ra" BIGINT,
  "rb" BIGINT,
  "rh" BIGINT,
  "ro" BIGINT,
  "ru" BIGINT,
  "rw" BIGINT,
  "sa" BIGINT,
  "sb" BIGINT,
  "sc" BIGINT,
  "scom" BIGINT,
  "sd" BIGINT,
  "se" BIGINT,
  "sec" BIGINT,
  "sh" BIGINT,
  "shc" BIGINT,
  "sl" BIGINT,
  "sm" BIGINT
);

Speciesmetadata

@kaggle.thedevastator_oxygen_exposure_of_southern_california_megafauna.speciesmetadata

10.02 KB
111 rows
7 columns


CREATE TABLE speciesmetadata (
  "speciescode" VARCHAR,
  "mobility" VARCHAR,
  "speciesname" VARCHAR,
  "commonname" VARCHAR,
  "majortaxa" VARCHAR,
  "group" VARCHAR,
  "quantscale" VARCHAR
);