About this Dataset

Oceanographic Context For Characterization And Future Evaluation, California North Coast MPA Baseline Study, 2014 To 2016

Marine ecosystems along the North Coast of California exist in a highly energetic and variable oceanographic environment that strongly influences the dynamics and structure of the diverse marine populations that call this region home (Barth and Checkley 2009). Understanding the effect of marine protected areas (MPAs) implemented in this region therefore requires information on how oceanographic conditions vary over space and time. Baseline observations collected before or soon after implementation of MPAs depend in part on the oceanographic history of the region, and ongoing ocean observations can inform analysis of ecological and economic responses to MPAs over time (White et al. 2010). This report synthesizes a diverse suite of observations to provide this essential oceanographic context for baseline ecosystem studies (BES) in the North Coast Study Region (NCSR) and to establish a foundation for integrative studies, ongoing monitoring, and adaptive management of marine resources in the region. The primary intent of this work is to inform analysis of data collected during the BES and to the extent possible, to inform the design of future monitoring programs.

Our foremost purpose is to provide historical perspective on conditions occurring during the 2014‐2016 Baseline Study Period (BSP). A great deal of this effort has been directed towards developing information specific to the NCSR that captures region‐specific responses to the unprecedented, persistent 2014‐2016 North Pacific marine heatwave (NPMHW) (Di Lorenzo and Mantua 2016) and associated ecosystem responses (including an equally unprecedented, massive, and persistent harmful algal bloom during 2015) (Leising et al. 2015, McClatchie et al. 2016).
Organization: State of California
Last updated: 2021-09-08T16:17:45.831239
Tags: 2014, 2015, 2016, baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, marine-protected-area, monitoring, mpa, north-coast, oceanography, oceans

Tables

Mean Chlorophyll 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_chlorophyll_2016

32.04 kB
271 rows
23 columns

CREATE TABLE mean_chlorophyll_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mchl" VARCHAR,
  "jan_mchl" DOUBLE,
  "feb_mchl" DOUBLE,
  "mar_mchl" DOUBLE,
  "apr_mchl" DOUBLE,
  "may_mchl" DOUBLE,
  "jun_mchl" VARCHAR,
  "jul_mchl" VARCHAR,
  "aug_mchl" VARCHAR,
  "sep_mchl" VARCHAR,
  "oct_mchl" VARCHAR,
  "nov_mchl" VARCHAR,
  "dec_mchl" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Cross Shelf Flows 2003 - 2013

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_cross_shelf_flows_2003_2013

52.11 kB
271 rows
23 columns

CREATE TABLE mean_cross_shelf_flows_2003_2013 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mxsh" DOUBLE,
  "jan_mxsh" DOUBLE,
  "feb_mxsh" DOUBLE,
  "mar_mxsh" DOUBLE,
  "apr_mxsh" DOUBLE,
  "may_mxsh" DOUBLE,
  "jun_mxsh" DOUBLE,
  "jul_mxsh" DOUBLE,
  "aug_mxsh" DOUBLE,
  "sep_mxsh" DOUBLE,
  "oct_mxsh" DOUBLE,
  "nov_mxsh" DOUBLE,
  "dec_mxsh" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Cross Shelf Flows 2014

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_cross_shelf_flows_2014

52.13 kB
271 rows
23 columns

CREATE TABLE mean_cross_shelf_flows_2014 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mxsh" DOUBLE,
  "jan_mxsh" DOUBLE,
  "feb_mxsh" DOUBLE,
  "mar_mxsh" DOUBLE,
  "apr_mxsh" DOUBLE,
  "may_mxsh" DOUBLE,
  "jun_mxsh" DOUBLE,
  "jul_mxsh" DOUBLE,
  "aug_mxsh" DOUBLE,
  "sep_mxsh" DOUBLE,
  "oct_mxsh" DOUBLE,
  "nov_mxsh" DOUBLE,
  "dec_mxsh" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Cross Shelf Flows 2015

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_cross_shelf_flows_2015

52.18 kB
271 rows
23 columns

CREATE TABLE mean_cross_shelf_flows_2015 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mxsh" DOUBLE,
  "jan_mxsh" DOUBLE,
  "feb_mxsh" DOUBLE,
  "mar_mxsh" DOUBLE,
  "apr_mxsh" DOUBLE,
  "may_mxsh" DOUBLE,
  "jun_mxsh" DOUBLE,
  "jul_mxsh" DOUBLE,
  "aug_mxsh" DOUBLE,
  "sep_mxsh" DOUBLE,
  "oct_mxsh" DOUBLE,
  "nov_mxsh" DOUBLE,
  "dec_mxsh" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Cross Shelf Flows 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_cross_shelf_flows_2016

32.03 kB
271 rows
23 columns

CREATE TABLE mean_cross_shelf_flows_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mxsh" VARCHAR,
  "jan_mxsh" DOUBLE,
  "feb_mxsh" DOUBLE,
  "mar_mxsh" DOUBLE,
  "apr_mxsh" DOUBLE,
  "may_mxsh" DOUBLE,
  "jun_mxsh" VARCHAR,
  "jul_mxsh" VARCHAR,
  "aug_mxsh" VARCHAR,
  "sep_mxsh" VARCHAR,
  "oct_mxsh" VARCHAR,
  "nov_mxsh" VARCHAR,
  "dec_mxsh" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Meridional Flows 2015

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_meridional_flows_2015

52.21 kB
271 rows
23 columns

CREATE TABLE mean_meridional_flows_2015 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mvvel" DOUBLE,
  "jan_mvvel" DOUBLE,
  "feb_mvvel" DOUBLE,
  "mar_mvvel" DOUBLE,
  "apr_mvvel" DOUBLE,
  "may_mvvel" DOUBLE,
  "jun_mvvel" DOUBLE,
  "jul_mvvel" DOUBLE,
  "aug_mvvel" DOUBLE,
  "sep_mvvel" DOUBLE,
  "oct_mvvel" DOUBLE,
  "nov_mvvel" DOUBLE,
  "dec_mvvel" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Meridional Flows 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_meridional_flows_2016

32.13 kB
271 rows
23 columns

CREATE TABLE mean_meridional_flows_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mvvel" VARCHAR,
  "jan_mvvel" DOUBLE,
  "feb_mvvel" DOUBLE,
  "mar_mvvel" DOUBLE,
  "apr_mvvel" DOUBLE,
  "may_mvvel" DOUBLE,
  "jun_mvvel" VARCHAR,
  "jul_mvvel" VARCHAR,
  "aug_mvvel" VARCHAR,
  "sep_mvvel" VARCHAR,
  "oct_mvvel" VARCHAR,
  "nov_mvvel" VARCHAR,
  "dec_mvvel" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Sea Level Anomaly 2003 - 2013

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sea_level_anomaly_2003_2013

52.19 kB
271 rows
23 columns

CREATE TABLE mean_sea_level_anomaly_2003_2013 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msla" DOUBLE,
  "jan_msla" DOUBLE,
  "feb_msla" DOUBLE,
  "mar_msla" DOUBLE,
  "apr_msla" DOUBLE,
  "may_msla" DOUBLE,
  "jun_msla" DOUBLE,
  "jul_msla" DOUBLE,
  "aug_msla" DOUBLE,
  "sep_msla" DOUBLE,
  "oct_msla" DOUBLE,
  "nov_msla" DOUBLE,
  "dec_msla" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Sea Level Anomaly 2014

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sea_level_anomaly_2014

52.15 kB
271 rows
23 columns

CREATE TABLE mean_sea_level_anomaly_2014 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msla" DOUBLE,
  "jan_msla" DOUBLE,
  "feb_msla" DOUBLE,
  "mar_msla" DOUBLE,
  "apr_msla" DOUBLE,
  "may_msla" DOUBLE,
  "jun_msla" DOUBLE,
  "jul_msla" DOUBLE,
  "aug_msla" DOUBLE,
  "sep_msla" DOUBLE,
  "oct_msla" DOUBLE,
  "nov_msla" DOUBLE,
  "dec_msla" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Sea Level Anomaly 2015

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sea_level_anomaly_2015

51.7 kB
271 rows
23 columns

CREATE TABLE mean_sea_level_anomaly_2015 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msla" DOUBLE,
  "jan_msla" DOUBLE,
  "feb_msla" DOUBLE,
  "mar_msla" DOUBLE,
  "apr_msla" DOUBLE,
  "may_msla" DOUBLE,
  "jun_msla" DOUBLE,
  "jul_msla" DOUBLE,
  "aug_msla" DOUBLE,
  "sep_msla" DOUBLE,
  "oct_msla" DOUBLE,
  "nov_msla" DOUBLE,
  "dec_msla" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Sea Level Anomaly 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sea_level_anomaly_2016

31.7 kB
271 rows
23 columns

CREATE TABLE mean_sea_level_anomaly_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msla" VARCHAR,
  "jan_msla" DOUBLE,
  "feb_msla" DOUBLE,
  "mar_msla" DOUBLE,
  "apr_msla" DOUBLE,
  "may_msla" DOUBLE,
  "jun_msla" VARCHAR,
  "jul_msla" VARCHAR,
  "aug_msla" VARCHAR,
  "sep_msla" VARCHAR,
  "oct_msla" VARCHAR,
  "nov_msla" VARCHAR,
  "dec_msla" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST 2003 - 2013

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_2003_2013

51.18 kB
271 rows
23 columns

CREATE TABLE mean_sst_2003_2013 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msst" DOUBLE,
  "jan_msst" DOUBLE,
  "feb_msst" DOUBLE,
  "mar_msst" DOUBLE,
  "apr_msst" DOUBLE,
  "may_msst" DOUBLE,
  "jun_msst" DOUBLE,
  "jul_msst" DOUBLE,
  "aug_msst" DOUBLE,
  "sep_msst" DOUBLE,
  "oct_msst" DOUBLE,
  "nov_msst" DOUBLE,
  "dec_msst" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST 2014

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_2014

51.65 kB
271 rows
23 columns

CREATE TABLE mean_sst_2014 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msst" DOUBLE,
  "jan_msst" DOUBLE,
  "feb_msst" DOUBLE,
  "mar_msst" DOUBLE,
  "apr_msst" DOUBLE,
  "may_msst" DOUBLE,
  "jun_msst" DOUBLE,
  "jul_msst" DOUBLE,
  "aug_msst" DOUBLE,
  "sep_msst" DOUBLE,
  "oct_msst" DOUBLE,
  "nov_msst" DOUBLE,
  "dec_msst" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST 2015

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_2015

51.2 kB
271 rows
23 columns

CREATE TABLE mean_sst_2015 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msst" DOUBLE,
  "jan_msst" DOUBLE,
  "feb_msst" DOUBLE,
  "mar_msst" DOUBLE,
  "apr_msst" DOUBLE,
  "may_msst" DOUBLE,
  "jun_msst" DOUBLE,
  "jul_msst" DOUBLE,
  "aug_msst" DOUBLE,
  "sep_msst" DOUBLE,
  "oct_msst" DOUBLE,
  "nov_msst" DOUBLE,
  "dec_msst" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_2016

31.74 kB
271 rows
23 columns

CREATE TABLE mean_sst_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msst" VARCHAR,
  "jan_msst" DOUBLE,
  "feb_msst" DOUBLE,
  "mar_msst" DOUBLE,
  "apr_msst" DOUBLE,
  "may_msst" DOUBLE,
  "jun_msst" VARCHAR,
  "jul_msst" VARCHAR,
  "aug_msst" VARCHAR,
  "sep_msst" VARCHAR,
  "oct_msst" VARCHAR,
  "nov_msst" VARCHAR,
  "dec_msst" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST Front 2003 - 2013

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_front_2003_2013

51.83 kB
271 rows
23 columns

CREATE TABLE mean_sst_front_2003_2013 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msstfi" DOUBLE,
  "jan_mfi" DOUBLE,
  "feb_mfi" DOUBLE,
  "mar_mfi" DOUBLE,
  "apr_mfi" DOUBLE,
  "may_mfi" DOUBLE,
  "jun_mfi" DOUBLE,
  "jul_mfi" DOUBLE,
  "aug_mfi" DOUBLE,
  "sep_mfi" DOUBLE,
  "oct_mfi" DOUBLE,
  "nov_mfi" DOUBLE,
  "dec_mfi" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST Front 2014

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_front_2014

49.47 kB
271 rows
23 columns

CREATE TABLE mean_sst_front_2014 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msstfi" DOUBLE,
  "jan_mfi" DOUBLE,
  "feb_mfi" BIGINT,
  "mar_mfi" DOUBLE,
  "apr_mfi" DOUBLE,
  "may_mfi" DOUBLE,
  "jun_mfi" DOUBLE,
  "jul_mfi" DOUBLE,
  "aug_mfi" DOUBLE,
  "sep_mfi" DOUBLE,
  "oct_mfi" DOUBLE,
  "nov_mfi" DOUBLE,
  "dec_mfi" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST Front 2015

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_front_2015

52.03 kB
271 rows
23 columns

CREATE TABLE mean_sst_front_2015 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msstfi" DOUBLE,
  "jan_mfi" DOUBLE,
  "feb_mfi" DOUBLE,
  "mar_mfi" DOUBLE,
  "apr_mfi" DOUBLE,
  "may_mfi" DOUBLE,
  "jun_mfi" DOUBLE,
  "jul_mfi" DOUBLE,
  "aug_mfi" DOUBLE,
  "sep_mfi" DOUBLE,
  "oct_mfi" DOUBLE,
  "nov_mfi" DOUBLE,
  "dec_mfi" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST Front 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_front_2016

24.5 kB
271 rows
23 columns

CREATE TABLE mean_sst_front_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "msstfi" VARCHAR,
  "jan_mfi" BIGINT,
  "feb_mfi" BIGINT,
  "mar_mfi" BIGINT,
  "apr_mfi" DOUBLE,
  "may_mfi" DOUBLE,
  "jun_mfi" VARCHAR,
  "jul_mfi" VARCHAR,
  "aug_mfi" VARCHAR,
  "sep_mfi" VARCHAR,
  "oct_mfi" VARCHAR,
  "nov_mfi" VARCHAR,
  "dec_mfi" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST Gradient 2003 - 2013

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_gradient_2003_2013

52.24 kB
271 rows
23 columns

CREATE TABLE mean_sst_gradient_2003_2013 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mgradsst" DOUBLE,
  "jan_mgsst" DOUBLE,
  "feb_mgsst" DOUBLE,
  "mar_mgsst" DOUBLE,
  "apr_mgsst" DOUBLE,
  "may_mgsst" DOUBLE,
  "jun_mgsst" DOUBLE,
  "jul_mgsst" DOUBLE,
  "aug_mgsst" DOUBLE,
  "sep_mgsst" DOUBLE,
  "oct_mgsst" DOUBLE,
  "nov_mgsst" DOUBLE,
  "dec_mgsst" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean SST Gradient 2014

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_sst_gradient_2014

52.28 kB
271 rows
23 columns

CREATE TABLE mean_sst_gradient_2014 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "mgradsst" DOUBLE,
  "jan_mgsst" DOUBLE,
  "feb_mgsst" DOUBLE,
  "mar_mgsst" DOUBLE,
  "apr_mgsst" DOUBLE,
  "may_mgsst" DOUBLE,
  "jun_mgsst" DOUBLE,
  "jul_mgsst" DOUBLE,
  "aug_mgsst" DOUBLE,
  "sep_mgsst" DOUBLE,
  "oct_mgsst" DOUBLE,
  "nov_mgsst" DOUBLE,
  "dec_mgsst" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Zonal Flows 2003 - 2013

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_zonal_flows_2003_2013

52.33 kB
271 rows
23 columns

CREATE TABLE mean_zonal_flows_2003_2013 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "muvel" DOUBLE,
  "jan_muvel" DOUBLE,
  "feb_muvel" DOUBLE,
  "mar_muvel" DOUBLE,
  "apr_muvel" DOUBLE,
  "may_muvel" DOUBLE,
  "jun_muvel" DOUBLE,
  "jul_muvel" DOUBLE,
  "aug_muvel" DOUBLE,
  "sep_muvel" DOUBLE,
  "oct_muvel" DOUBLE,
  "nov_muvel" DOUBLE,
  "dec_muvel" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Zonal Flows 2014

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_zonal_flows_2014

52.3 kB
271 rows
23 columns

CREATE TABLE mean_zonal_flows_2014 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "muvel" DOUBLE,
  "jan_muvel" DOUBLE,
  "feb_muvel" DOUBLE,
  "mar_muvel" DOUBLE,
  "apr_muvel" DOUBLE,
  "may_muvel" DOUBLE,
  "jun_muvel" DOUBLE,
  "jul_muvel" DOUBLE,
  "aug_muvel" DOUBLE,
  "sep_muvel" DOUBLE,
  "oct_muvel" DOUBLE,
  "nov_muvel" DOUBLE,
  "dec_muvel" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Zonal Flows 2015

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_zonal_flows_2015

52.34 kB
271 rows
23 columns

CREATE TABLE mean_zonal_flows_2015 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "muvel" DOUBLE,
  "jan_muvel" DOUBLE,
  "feb_muvel" DOUBLE,
  "mar_muvel" DOUBLE,
  "apr_muvel" DOUBLE,
  "may_muvel" DOUBLE,
  "jun_muvel" DOUBLE,
  "jul_muvel" DOUBLE,
  "aug_muvel" DOUBLE,
  "sep_muvel" DOUBLE,
  "oct_muvel" DOUBLE,
  "nov_muvel" DOUBLE,
  "dec_muvel" DOUBLE,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

Mean Zonal Flows 2016

@usgov.ca_gov_oceanographic_context_for_characterization_and__fbd3d296.mean_zonal_flows_2016

32.18 kB
271 rows
23 columns

CREATE TABLE mean_zonal_flows_2016 (
  "nc_project_short_code" VARCHAR,
  "start_year" BIGINT,
  "start_month" BIGINT,
  "start_day" BIGINT,
  "end_year" BIGINT,
  "end_month" BIGINT,
  "end_day" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "muvel" VARCHAR,
  "jan_muvel" DOUBLE,
  "feb_muvel" DOUBLE,
  "mar_muvel" DOUBLE,
  "apr_muvel" DOUBLE,
  "may_muvel" DOUBLE,
  "jun_muvel" VARCHAR,
  "jul_muvel" VARCHAR,
  "aug_muvel" VARCHAR,
  "sep_muvel" VARCHAR,
  "oct_muvel" VARCHAR,
  "nov_muvel" VARCHAR,
  "dec_muvel" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);