Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
1736 lines (1295 sloc) 90.2 KB
--
-- TAGBASE v1.0 for PostgreSQL & eTUFF (electronic Tag Universal File Format): Complete database definition schema, including Tag metadata and variable Code tables
-- Product of the Oceanographic In-situ Data Interoperability Project (OIIP) funded under NASA/ACCESS-15 Program, June 2018
--
-- By executing this script you will be able to create virgin Tagbase database with the necessary information populated in key code tables to be able ingest electronic tagging data in the eTUFF format
-- PostgreSQL database dump
--
-- Dumped from database version 9.6.3
-- Dumped by pg_dump version 10.1
-- Started on 2018-06-12 18:25:22
CREATE ROLE tagbase WITH SUPERUSER LOGIN;
CREATE DATABASE tagbase WITH OWNER = 'tagbase';
\connect tagbase
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 195 (class 1259 OID 184670)
-- Name: data_histogram_bin_data; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE data_histogram_bin_data (
submission_id bigint NOT NULL,
tag_id bigint NOT NULL,
bin_id bigint NOT NULL,
bin_class integer NOT NULL,
date_time timestamp(6) with time zone NOT NULL,
variable_value double precision NOT NULL,
position_date_time timestamp(6) with time zone,
variable_id bigint NOT NULL
);
ALTER TABLE data_histogram_bin_data OWNER TO tagbase;
--
-- TOC entry 2230 (class 0 OID 0)
-- Dependencies: 195
-- Name: TABLE data_histogram_bin_data; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE data_histogram_bin_data IS 'Conatins the frequency for corresponding summary data binning schemes (migrated from proc_observations)';
--
-- TOC entry 2231 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2232 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.tag_id IS 'Unique numeric Tag ID associated with the ingested tag data file';
--
-- TOC entry 2233 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.bin_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.bin_id IS 'Unique bin ID for the summary bin-frequency class';
--
-- TOC entry 2234 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.bin_class; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.bin_class IS 'Sequential numeric bin class identifier';
--
-- TOC entry 2235 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.date_time IS 'Date/time stamp of the tag summarized bin-frequency data record';
--
-- TOC entry 2236 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.variable_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.variable_value IS 'Aggregate measure for the given bin-interval of the geophysical value of the observed tag variable record';
--
-- TOC entry 2237 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.position_date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.position_date_time IS 'Date/time stamp of nearest matched associated positional record';
--
-- TOC entry 2238 (class 0 OID 0)
-- Dependencies: 195
-- Name: COLUMN data_histogram_bin_data.variable_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_data.variable_id IS 'Unique variable identifier for the data record from the source eTUFF file ingested. The variable_id is based on observation or measurment variables listed in the observation_types table. Note that records in this table are NOT expected to be equivalent to those in the variable_id column of the data_histogram_bin_info table';
--
-- TOC entry 194 (class 1259 OID 184660)
-- Name: data_histogram_bin_info; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE data_histogram_bin_info (
bin_id bigint NOT NULL,
bin_class integer NOT NULL,
min_value double precision NOT NULL,
max_value double precision NOT NULL,
variable_id bigint NOT NULL
);
ALTER TABLE data_histogram_bin_info OWNER TO tagbase;
--
-- TOC entry 2239 (class 0 OID 0)
-- Dependencies: 194
-- Name: TABLE data_histogram_bin_info; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE data_histogram_bin_info IS 'Contains definitions of binning schemes for summary tag data (migrated from proc_observations)';
--
-- TOC entry 2240 (class 0 OID 0)
-- Dependencies: 194
-- Name: COLUMN data_histogram_bin_info.bin_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_info.bin_id IS 'Unique bin ID for the summary bin-frequency class';
--
-- TOC entry 2241 (class 0 OID 0)
-- Dependencies: 194
-- Name: COLUMN data_histogram_bin_info.bin_class; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_info.bin_class IS 'Sequential numeric bin class identifier';
--
-- TOC entry 2242 (class 0 OID 0)
-- Dependencies: 194
-- Name: COLUMN data_histogram_bin_info.min_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_info.min_value IS 'Value of minimum/lower bound of bin interval';
--
-- TOC entry 2243 (class 0 OID 0)
-- Dependencies: 194
-- Name: COLUMN data_histogram_bin_info.max_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_info.max_value IS 'Value of maximum/upper bound of bin interval';
--
-- TOC entry 2244 (class 0 OID 0)
-- Dependencies: 194
-- Name: COLUMN data_histogram_bin_info.variable_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_histogram_bin_info.variable_id IS 'Unique variable identifier for the data record from the source eTUFF file ingested. The variable_id is based on observation or measurment variables listed in the observation_types table. Note that records in this table are NOT expected to be equivalent to those in the variable_id column of the data_histogram_bin_data table';
--
-- TOC entry 192 (class 1259 OID 184628)
-- Name: data_position; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE data_position (
date_time timestamp(6) with time zone NOT NULL,
lat double precision NOT NULL,
lon double precision NOT NULL,
lat_err double precision,
lon_err double precision,
submission_id bigint NOT NULL,
tag_id bigint NOT NULL
);
ALTER TABLE data_position OWNER TO tagbase;
--
-- TOC entry 2245 (class 0 OID 0)
-- Dependencies: 192
-- Name: TABLE data_position; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE data_position IS 'Contains the tag positional data series with associated Lat/Lon error estimates where available (migrated from proc_observations)';
--
-- TOC entry 2246 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.date_time IS 'Date/time stamp of the tag positional data record';
--
-- TOC entry 2247 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.lat; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.lat IS 'Latitude in decimal degrees of the positional data tag record';
--
-- TOC entry 2248 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.lon; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.lon IS 'Longitude in decimal degrees of the positional data tag record';
--
-- TOC entry 2249 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.lat_err; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.lat_err IS 'Error associated with the tag record Laitudiinal positional estimate';
--
-- TOC entry 2250 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.lon_err; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.lon_err IS 'Error associated with the tag record Longitudinal positional estimate';
--
-- TOC entry 2251 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2252 (class 0 OID 0)
-- Dependencies: 192
-- Name: COLUMN data_position.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_position.tag_id IS 'Unique numeric Tag ID associated with the ingested tag data file';
--
-- TOC entry 196 (class 1259 OID 184683)
-- Name: data_profile; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE data_profile (
submission_id bigint NOT NULL,
tag_id bigint NOT NULL,
variable_id bigint NOT NULL,
date_time timestamp(6) with time zone NOT NULL,
depth double precision NOT NULL,
variable_value double precision NOT NULL,
position_date_time timestamp(6) with time zone
);
ALTER TABLE data_profile OWNER TO tagbase;
--
-- TOC entry 2253 (class 0 OID 0)
-- Dependencies: 196
-- Name: TABLE data_profile; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE data_profile IS 'Contains the summarized bin profile tag observations (migrated from proc_observations)';
--
-- TOC entry 2254 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2255 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.tag_id IS 'Unique numeric Tag ID associated with the ingested tag data file';
--
-- TOC entry 2256 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.variable_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.variable_id IS 'Unique variable identifier for the data record from the source eTUFF file ingested. The variable_id is based on observation or measurment variables listed in the observation_types table';
--
-- TOC entry 2257 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.date_time IS 'Date/time stamp of the tag data record';
--
-- TOC entry 2258 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.depth; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.depth IS 'Depth of the tag data record';
--
-- TOC entry 2259 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.variable_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.variable_value IS 'Geophysical value of the observed tag variable record';
--
-- TOC entry 2260 (class 0 OID 0)
-- Dependencies: 196
-- Name: COLUMN data_profile.position_date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_profile.position_date_time IS 'Date/time stamp of nearest matched associated positional record';
--
-- TOC entry 193 (class 1259 OID 184636)
-- Name: data_time_series; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE data_time_series (
date_time timestamp(6) with time zone NOT NULL,
variable_id bigint NOT NULL,
variable_value double precision NOT NULL,
submission_id bigint NOT NULL,
tag_id bigint NOT NULL,
position_date_time timestamp(6) with time zone
);
ALTER TABLE data_time_series OWNER TO tagbase;
--
-- TOC entry 2261 (class 0 OID 0)
-- Dependencies: 193
-- Name: TABLE data_time_series; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE data_time_series IS 'Contains the continuous measurement archival time series of tag geophysical measurments (migrated from proc_observations)';
--
-- TOC entry 2262 (class 0 OID 0)
-- Dependencies: 193
-- Name: COLUMN data_time_series.date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_time_series.date_time IS 'Date/time stamp of the tag data record';
--
-- TOC entry 2263 (class 0 OID 0)
-- Dependencies: 193
-- Name: COLUMN data_time_series.variable_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_time_series.variable_id IS 'Unique variable identifier for the data record from the source eTUFF file ingested. The variable_id is based on observation or measurment variables listed in the observation_types table';
--
-- TOC entry 2264 (class 0 OID 0)
-- Dependencies: 193
-- Name: COLUMN data_time_series.variable_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_time_series.variable_value IS 'Geophysical value of the observed tag variable record';
--
-- TOC entry 2265 (class 0 OID 0)
-- Dependencies: 193
-- Name: COLUMN data_time_series.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_time_series.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2266 (class 0 OID 0)
-- Dependencies: 193
-- Name: COLUMN data_time_series.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_time_series.tag_id IS 'Unique numeric Tag ID associated with the ingested tag data file';
--
-- TOC entry 2267 (class 0 OID 0)
-- Dependencies: 193
-- Name: COLUMN data_time_series.position_date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN data_time_series.position_date_time IS 'Date/time stamp of nearest matched associated positional record';
--
-- TOC entry 191 (class 1259 OID 184612)
-- Name: metadata; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE metadata (
submission_id bigint NOT NULL,
attribute_id bigint NOT NULL,
attribute_value text NOT NULL,
tag_id bigint NOT NULL
);
ALTER TABLE metadata OWNER TO tagbase;
--
-- TOC entry 2268 (class 0 OID 0)
-- Dependencies: 191
-- Name: TABLE metadata; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE metadata IS 'Contains the ingested tag metadata consistent with the eTUFF specification';
--
-- TOC entry 2269 (class 0 OID 0)
-- Dependencies: 191
-- Name: COLUMN metadata.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2270 (class 0 OID 0)
-- Dependencies: 191
-- Name: COLUMN metadata.attribute_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata.attribute_id IS 'Unique numeric metadata atttribute ID based on the eTUFF metadata specification';
--
-- TOC entry 2271 (class 0 OID 0)
-- Dependencies: 191
-- Name: COLUMN metadata.attribute_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata.attribute_value IS 'Value associated with the given eTUFF metadata attribute';
--
-- TOC entry 2272 (class 0 OID 0)
-- Dependencies: 191
-- Name: COLUMN metadata.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata.tag_id IS 'Unique numeric Tag ID associated with the ingested tag data file';
--
-- TOC entry 190 (class 1259 OID 184604)
-- Name: metadata_types; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE metadata_types (
attribute_id bigint NOT NULL,
category character varying(1024) NOT NULL,
attribute_name character varying(1024) NOT NULL,
type character varying(1024) NOT NULL,
description text NOT NULL,
example text,
comments text,
necessity character varying(1024) NOT NULL
);
ALTER TABLE metadata_types OWNER TO tagbase;
--
-- TOC entry 2273 (class 0 OID 0)
-- Dependencies: 190
-- Name: TABLE metadata_types; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE metadata_types IS 'Contains descriptive information on tag metadata based on the eTUFF specification';
--
-- TOC entry 2274 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.attribute_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.attribute_id IS 'Unique numeric metadata atttribute ID based on the eTUFF metadata specification';
--
-- TOC entry 2275 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.category; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.category IS 'Metadata attribute category or group based on the eTUFF metadata specification';
--
-- TOC entry 2276 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.attribute_name; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.attribute_name IS 'Name of metadata attribute based on the eTUFF metadata specification';
--
-- TOC entry 2277 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.type; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.type IS 'Metadata attribute format type based on the eTUFF metadata specification';
--
-- TOC entry 2278 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.description; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.description IS 'Description of metadata attribute based on the eTUFF metadata specification';
--
-- TOC entry 2279 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.example; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.example IS 'Example value of metadata attribute on the eTUFF metadata specification';
--
-- TOC entry 2280 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.comments; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.comments IS 'Comments or notes relating to the metadata attribute based on the eTUFF metadata specification';
--
-- TOC entry 2281 (class 0 OID 0)
-- Dependencies: 190
-- Name: COLUMN metadata_types.necessity; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN metadata_types.necessity IS 'Deisgnation of the metadata attribute as Required, Recommended, or Optional based on the eTUFF metadata specification';
--
-- TOC entry 188 (class 1259 OID 184580)
-- Name: observation_types; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE observation_types (
variable_id bigint NOT NULL,
variable_name character varying(255) NOT NULL,
standard_name character varying(255),
variable_source character varying(255),
variable_units character varying(255),
notes text,
standard_unit character varying(255)
);
ALTER TABLE observation_types OWNER TO tagbase;
--
-- TOC entry 2282 (class 0 OID 0)
-- Dependencies: 188
-- Name: TABLE observation_types; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE observation_types IS 'Contains listings and descriptions of observation variable types based on the eTUFF specification';
--
-- TOC entry 2283 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.variable_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.variable_id IS 'Unique variable identifier based on the eTUFF tag data file specification';
--
-- TOC entry 2284 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.variable_name; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.variable_name IS 'Variable name based on the eTUFF tag data file specification';
--
-- TOC entry 2285 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.standard_name; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.standard_name IS 'CF Standard name for observation variable, if available';
--
-- TOC entry 2286 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.variable_source; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.variable_source IS 'Source authority for the given variables';
--
-- TOC entry 2287 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.variable_units; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.variable_units IS 'Units of the variable based on the eTUFF tag data file specification';
--
-- TOC entry 2288 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.notes; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.notes IS 'Notes or comments relating to the variable';
--
-- TOC entry 2289 (class 0 OID 0)
-- Dependencies: 188
-- Name: COLUMN observation_types.standard_unit; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN observation_types.standard_unit IS 'CF canonical standard unit for observation variable, if available';
--
-- TOC entry 187 (class 1259 OID 184578)
-- Name: observation_types_variable_id_seq; Type: SEQUENCE; Schema: public; Owner: tagbase
--
CREATE SEQUENCE observation_types_variable_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE observation_types_variable_id_seq OWNER TO tagbase;
--
-- TOC entry 2290 (class 0 OID 0)
-- Dependencies: 187
-- Name: observation_types_variable_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: tagbase
--
ALTER SEQUENCE observation_types_variable_id_seq OWNED BY observation_types.variable_id;
--
-- TOC entry 189 (class 1259 OID 184591)
-- Name: proc_observations; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE proc_observations (
date_time timestamp(6) with time zone NOT NULL,
variable_id bigint NOT NULL,
variable_value double precision NOT NULL,
submission_id bigint NOT NULL,
tag_id bigint NOT NULL
);
ALTER TABLE proc_observations OWNER TO tagbase;
--
-- TOC entry 2291 (class 0 OID 0)
-- Dependencies: 189
-- Name: TABLE proc_observations; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE proc_observations IS 'Contains staged source tag eTUFF data imported into Tagbase';
--
-- TOC entry 2292 (class 0 OID 0)
-- Dependencies: 189
-- Name: COLUMN proc_observations.date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN proc_observations.date_time IS 'Date/time stamp of data record from source eTUFF file ingested';
--
-- TOC entry 2293 (class 0 OID 0)
-- Dependencies: 189
-- Name: COLUMN proc_observations.variable_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN proc_observations.variable_id IS 'Unique variable identifier for the data record from the source eTUFF file ingested. The variable_id is based on observation or measurment variables listed in the observation_types table';
--
-- TOC entry 2294 (class 0 OID 0)
-- Dependencies: 189
-- Name: COLUMN proc_observations.variable_value; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN proc_observations.variable_value IS 'Geophysical value of the given measured variable for the eTUFF data record';
--
-- TOC entry 2295 (class 0 OID 0)
-- Dependencies: 189
-- Name: COLUMN proc_observations.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN proc_observations.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2296 (class 0 OID 0)
-- Dependencies: 189
-- Name: COLUMN proc_observations.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN proc_observations.tag_id IS 'Unique numeric Tag ID associated with the ingested tag data file';
--
-- TOC entry 186 (class 1259 OID 184571)
-- Name: submission; Type: TABLE; Schema: public; Owner: tagbase
--
CREATE TABLE submission (
submission_id bigint NOT NULL,
tag_id bigint NOT NULL,
dmas_granule_id bigint,
date_time timestamp(6) with time zone DEFAULT now() NOT NULL,
filename character varying(255) NOT NULL,
version character varying(50)
);
ALTER TABLE submission OWNER TO tagbase;
--
-- TOC entry 2297 (class 0 OID 0)
-- Dependencies: 186
-- Name: TABLE submission; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON TABLE submission IS 'Contains information on source tag eTUFF files submitted for ingest into Tagbase';
--
-- TOC entry 2298 (class 0 OID 0)
-- Dependencies: 186
-- Name: COLUMN submission.submission_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN submission.submission_id IS 'Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase';
--
-- TOC entry 2299 (class 0 OID 0)
-- Dependencies: 186
-- Name: COLUMN submission.tag_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN submission.tag_id IS 'Unique numeric Tag ID associated with the ingested tag eTUFF data file';
--
-- TOC entry 2300 (class 0 OID 0)
-- Dependencies: 186
-- Name: COLUMN submission.dmas_granule_id; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN submission.dmas_granule_id IS 'Unique numeric file identifier in the PODAAC DMAS catalog for the ingested tag eTUFF data file';
--
-- TOC entry 2301 (class 0 OID 0)
-- Dependencies: 186
-- Name: COLUMN submission.date_time; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN submission.date_time IS 'Local datetime stamp at the time of eTUFF tag data file ingestion';
--
-- TOC entry 2302 (class 0 OID 0)
-- Dependencies: 186
-- Name: COLUMN submission.filename; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN submission.filename IS 'Full name and extension of the ingested eTUFF tag data file';
--
-- TOC entry 2303 (class 0 OID 0)
-- Dependencies: 186
-- Name: COLUMN submission.version; Type: COMMENT; Schema: public; Owner: tagbase
--
COMMENT ON COLUMN submission.version IS 'Version identifier for the eTUFF tag data file ingested';
--
-- TOC entry 185 (class 1259 OID 184569)
-- Name: submission_submission_id_seq; Type: SEQUENCE; Schema: public; Owner: tagbase
--
CREATE SEQUENCE submission_submission_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE submission_submission_id_seq OWNER TO tagbase;
--
-- TOC entry 2304 (class 0 OID 0)
-- Dependencies: 185
-- Name: submission_submission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: tagbase
--
ALTER SEQUENCE submission_submission_id_seq OWNED BY submission.submission_id;
--
-- TOC entry 197 (class 1259 OID 184696)
-- Name: submission_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: tagbase
--
CREATE SEQUENCE submission_tag_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE submission_tag_id_seq OWNER TO tagbase;
--
-- TOC entry 2046 (class 2604 OID 184583)
-- Name: observation_types variable_id; Type: DEFAULT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY observation_types ALTER COLUMN variable_id SET DEFAULT nextval('observation_types_variable_id_seq'::regclass);
--
-- TOC entry 2044 (class 2604 OID 184574)
-- Name: submission submission_id; Type: DEFAULT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY submission ALTER COLUMN submission_id SET DEFAULT nextval('submission_submission_id_seq'::regclass);
--
-- TOC entry 2222 (class 0 OID 184670)
-- Dependencies: 195
-- Data for Name: data_histogram_bin_data; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY data_histogram_bin_data (submission_id, tag_id, bin_id, bin_class, date_time, variable_value, position_date_time, variable_id) FROM stdin;
\.
--
-- TOC entry 2221 (class 0 OID 184660)
-- Dependencies: 194
-- Data for Name: data_histogram_bin_info; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY data_histogram_bin_info (bin_id, bin_class, min_value, max_value, variable_id) FROM stdin;
\.
--
-- TOC entry 2219 (class 0 OID 184628)
-- Dependencies: 192
-- Data for Name: data_position; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY data_position (date_time, lat, lon, lat_err, lon_err, submission_id, tag_id) FROM stdin;
\.
--
-- TOC entry 2223 (class 0 OID 184683)
-- Dependencies: 196
-- Data for Name: data_profile; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY data_profile (submission_id, tag_id, variable_id, date_time, depth, variable_value, position_date_time) FROM stdin;
\.
--
-- TOC entry 2220 (class 0 OID 184636)
-- Dependencies: 193
-- Data for Name: data_time_series; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY data_time_series (date_time, variable_id, variable_value, submission_id, tag_id, position_date_time) FROM stdin;
\.
--
-- TOC entry 2218 (class 0 OID 184612)
-- Dependencies: 191
-- Data for Name: metadata; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY metadata (submission_id, attribute_id, attribute_value, tag_id) FROM stdin;
\.
--
-- TOC entry 2217 (class 0 OID 184604)
-- Dependencies: 190
-- Data for Name: metadata_types; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY metadata_types (attribute_id, category, attribute_name, type, description, example, comments, necessity) FROM stdin;
1 instrument instrument_name string Append an identifer that is unique within your organization. This is essential if a device is recycled. 16P0100-Refurb2 Devices might be reused, so the serial number will be the same. The only way to distinguish is by providing a unique name for the recycled product. required
2 instrument instrument_type string Type of instrument archival, popup, satellite, acoustic tag, or acoustic receiver Should be restricted to the examples provided. required
3 instrument firmware string Version number of the firmware used to build the device \N \N required
4 instrument manufacturer string Name of manufacturer Wildlife Computers, Microwave Telemetry, Lotek Wireless, Desert Star Systems, CEFAS, StarOddi, Sea Mammal Research Unit, Vemco, Loggerhead Instruments, Biologging Solutions, Little Leonardo, Teleonics etc. \N required
5 instrument model string Model name MiniPAT \N required
6 instrument owner_contact string Contact email/ telephone/ address \N \N required
7 instrument person_owner string Researcher/ organization owning the device \N PI/scientist/organization is used interchargably here. But best to have a first-last name specified here. required
8 instrument serial_number string Serial number 16P0100 \N required
9 instrument date_shipment string Date (yyyy-mm-dd) of receiving the device from manufacturer 2017-07-11T18:24:23+00:00 The device can be fresh off the production line or refurnished with some parts replaced. recommended
10 instrument project string Name or identifer for project/ grant number \N \N recommended
11 instrument ptt string Platform Transmitting Terminal (PTT) number for Argos transmission. \N \N recommended
12 instrument ptt_hex string PTT in hexadecimal \N \N recommended
13 instrument specs string Specification document name/ URL/ file (e.g., in xml) \N Need input from manufacturer. May allow attachment or upload. Or grab it from an online archive. recommended
14 instrument code_map string Placeholder for acoustic tags \N Refer to ATN spec. no
15 instrument ping_code string Placeholder for acoustic tags \N Refer to ATN spec. no
100 programming programming_report string File/ URL to a report listing the details of programming \N Need input from manufacturer. May allow attachment or upload. Or grab it from an online archive. required
101 programming programming_software string Programming software with version number \N \N required
102 programming days_constantdepth string Days at a constant depth before release is initiated 1 This represents a time lag in days after the tag is floating/ detached/ sunk before the release procedure will be initiated. recommended
103 programming days_mission string Programmed mission length in days 365 \N recommended
104 programming minutes_summary string Interval in minutes during when data are summarized for that period 1440 Data are summarized because of Argos transmission constraint. recommended
105 programming person_programmer string Person responsible for the programming \N \N recommended
106 programming seconds_sampling string Sampling rate (seconds) for sensor sampling 15 For basic sensors, e.g., pressure, temperature, light recommended
107 programming seconds_writingdata string Time interval in seconds when sampled data are written to onboard storage memory 300 This specifies how frequent data will be stored, and subsequently available for download or summarizing. recommended
108 programming seconds_sampling_highfreq string Sampling rate (seconds) for sensor sampling at a higher frequency \N For sensors that sample in Hertz (Hz), e.g., accelerometer, magnetometer optional
200 attachment attachment_method string Method used to put the tag on/ in the animal tow, glue, suction, anchor, mount, implant, harness, backpack Should be restricted to the examples provided. Tow includes tethered for popup or towed for satellite tags . Glue is using adhensive or epoxy. Mount is using screw, bolt, button, sleeve or backpack. Anchor is equivalent to applying a conventional tag or using a gun (air, spear etc.). Implant implies surgery, ingestion or insertion. required
201 attachment anchor_depth_cm string How deep (centimeter) should the anchor be in the animal? 8 May be used for cetacean tagging. recommended
202 attachment anchor_dimensions_mm string Dimensions (millimeter) as length, width, thichkness or diameter. 20 L x 14 W Can be used loosely as size: small, medium and large. recommended
203 attachment anchor_material string Material of anchor nylon, urethane, stainless steel, titanium \N recommended
204 attachment anchor_type string Type of anchor Domeier, Wilton, Titanium \N recommended
205 attachment attachment_product string Brand name and/ product for attachment materials used VetBond, Peel Ply, tesa® Brand and product name of suture, stainless steel wire, monofilament, bolt, tape, adhesive, epoxy, suction cup, air gun, speargun, pole, applicator and tip. recommended
206 attachment mount_type string Type of mount Fin, tail, carapacial ridge \N recommended
207 attachment release_method string Method to get a tag detached from the animal/ anchor corrosive burn wire, oxidative/ explosive, galavanizing metal, acoustic release \N recommended
208 attachment tether_assembly string Materials and methods in constructing a tether heat-shrink or silicon tubing Use brand name and/ product when possible. recommended
209 attachment tether_length_cm string End to end length (centimeter) of a tether \N \N recommended
210 attachment tether_material string Tether material for a towed tag stainless steel wire, monofilament Use brand name and/ product when possible. recommended
211 attachment anesthetic_product string Brand name and/ product of anesthesia used during the attachment metomidate, Aqua-S \N optional
212 attachment antifouling_product string Brand name and/ product of antifoluling paint or coating applied PropSpeed \N optional
213 attachment antiseptic_product string Brand name and/ product of antiseptic or sterilizing agent used during the attachment Iodine, Cicatrin \N optional
214 attachment float_additional string Specify any additional floation used \N Float might be added to archival tags for external use. optional
215 attachment release_forced string If a mechanical release is engaged at depth (too avoid crushing the tag), specify the mechanism and depth at which the release is engaged. Wildlife Computers RD1800 \N optional
300 deployment geospatial_lat_start string Latitude (decimal degree) of release/ deployment \N \N required
301 deployment geospatial_lon_start string Longitude (decimal degree) of release/ deployment \N \N required
302 deployment person_tagger_capture string Person responsible for tagging or surgery \N Can be the name of vet, observer, crew, spear fisherman or scientist required
303 deployment time_coverage_start string Local date time (yyyy-mm-dd hh:mm:ss) of release/ deployment 2017-07-11T18:24:23+00:00 http://en.wikipedia.org/wiki/ISO_8601 required
304 deployment location_capture string Name or standard identifer of location \N \N recommended
305 deployment method_capture string Type of gear used to catch the animal Longline, purse seine, troll, trawl, rod and reel, handline, set net, trap, gillnet, harpoon, hoop net, anesthesia, tangle net, dip net, vertical line entanglement (commercial fisheries, aquaculture, mooring), dredge, pound net/weir (for turtles) \N recommended
306 deployment baitlure_capture string Bait, chum, lure or decoy used sardine Use brand name and/ product when possible. optional
307 deployment cruise_capture string Name or standard identifer of cruise \N \N optional
308 deployment depth_m_capture string Depth (meters) at which the animal was caught \N Can use estimated depth from hook number on longline optional
309 deployment flag_capture string The vessel’s country of registration \N \N optional
310 deployment hook_capture string Type of hook used 18/0 circle Use brand name and/ product when possible. optional
311 deployment method_aboard string how was animal put aboard the vessel net, sling, lifted \N optional
312 deployment othertags_capture string List tag IDs for conventional, acoustic, PIT, band or satellite tags for multi-tagged situation, photoID, photo/video footage file names Hallprint PAR007007 \N optional
313 deployment person_angler_capture string Person responsible for angling \N \N optional
314 deployment school_capture string Type of school in which the animal was caught Free school, log, anchored FAD, drifting FAD Include FAD number if possible. optional
315 deployment seastate_capture string World Meteorological Organization sea state code (0-9) \N Similar to Douglas Sea Scale optional
316 deployment set_float_capture string If caught on longline, include set number and float number \N It''s very unlikely to tag turtle, bird/ mammal off longline. optional
317 deployment station_capture string Name or standard identifer of station \N \N optional
318 deployment temp_degC_capture string Air or sea surface temperature (Celcius) when the animal was caught \N \N optional
319 deployment vessel_capture string Name or standard identifer of vessel \N \N optional
320 deployment wind_knots_capture string Wind speed (knots) when the animal was caught \N \N optional
400 animal condition_capture string Description of condition/ injury. Or specify scoring system and a score. good Can be generic: good, bad, gut hooked, eye hooked, bleeding. Scoring system fof fish/ shark: reflex action mortality predictor (RAMP), Kerstetter''s lab ACES. Measurement: Bioelectrical Impedance Analysis (BIA) gives phase angle and composition index. Fat: Distell Fatmeter required
401 animal length_capture string Length of the animal 300 \N required
402 animal length_method_capture string Method used to obtain the measurement measured caliper, measured tape, estimated, calculated Calculated means it's calculated from length-weight relationships or other conversions. required
403 animal length_type_capture string Type of length measurement Curved fork length, Straight fork length, total length. for turtle the standard measurements are Curved Carapace Length (CCL), Straight Carapace Length (SCL), Curved Carapace Width (CCW) and Straight Carapace Width (SCW), and researchers occasionally measure girth as well. May need to compile a list of types and abbreviations required
404 animal length_unit_capture string Unit of length measurement centimeter May need to compile a list of types and abbreviations required
405 animal platform string Common name(s) or FAO code for species name \N Refer to www.itis.gov or FAO species list required
406 animal taxonomic_serial_number string Taxononomic Serial Number (TSN) from Integrated Taxonomic Information System \N https://www.itis.gov required
500 animal condition_recapture string Description of condition/ injury. Or specify scoring system and a score. \N Can be generic: good, bad, gut hooked, eye hooked, bleeding. Scoring system fof fish/ shark: reflex action mortality predictor (RAMP), Kerstetter''s lab ACES. Measurement: Bioelectrical Impedance Analysis (BIA) gives phase angle and composition index. Fat: Distell Fatmeter recommended
501 animal fate_recapture string Fate of the animal upon recapture harvested, released, tag and release, missing, unknown; observed/ photo ID \N recommended
502 animal length_method_recapture string Method used to obtain the measurement measured Caliper, measured tape, estimated, calculated Calculated means it's calculated from length-weight relationships or other conversions recommended
503 animal length_recapture string Length of the animal \N \N recommended
504 animal length_type_recapture string Type of length measurement SFL, CFL, TL, etc… May need to compile a list of types and abbreviations recommended
505 animal length_unit_recapture string Unit of length measurement \N May need to compile a list of types and abbreviations recommended
407 animal lifestage_capture string Life stage of the animal adult, juvenile, subadult, weaner \N recommended
506 animal lifestage_recapture string Life stage of the animal \N \N recommended
408 animal tag_placement string Description of where the tag was placed. second dorsal fin \N recommended
507 animal age_recapture string Age from direct aging methods if available year-of-young, 3 y.o. etc. Can be used to back calculate age of the individual at capture optional
409 animal hours_soaktime_capture string If caught on longline, specify soak time In hours \N \N optional
508 animal hours_soaktime_recapture string If caught on longline, specify soak time In hours \N \N optional
410 animal implant_numsuture string Number of suture used to close the wound \N Internal archival only optional
411 animal minutes_fighttime_capture string If caught on rod and wheel or handline, specify fight time \N \N optional
509 animal minutes_fighttime_recapture string If caught on rod and wheel or handline, specify fight time \N \N optional
412 animal minutes_operation string Time used (minutes) in carrying out the attachment or surgical procedure. \N \N optional
413 animal minutes_revival string If the animal is revived, specify revival time in minutes \N Can be time used in swimming the animal before release optional
414 animal mount_numbolts string Number of bolts used for mounting \N \N optional
415 animal sex string Sex of the animal male, female, unknown Likely only applicable to sharks upon visual confirmation optional
416 animal stock string Stock origin if known East, West, unknown etc. \N optional
417 animal tissue_sample_capture string List other sample types and sample IDs if collected Blood-ID02101 Tissue can be any issue: fin clip, blood, scale, biopsy etc. optional
510 animal tissue_sample_recapture string List other sample types and sample IDs if collected \N Tissue can be any issue: fin clip, blood, scale, hard parts, stomach, muscle, biopsy etc. optional
418 animal weight_capture string Weight of the animal 1200 \N optional
419 animal weight_method_capture string Method used to obtain the measurement measured, estimated, calculated Calculated means it's calculated from length-weight relationships or other conversions optional
511 animal weight_method_recapture string Method used to obtain the measurement measured, estimated, calculated Calculated means it's calculated from length-weight relationships or other conversions optional
512 animal weight_recapture string Weight of the animal \N \N optional
420 animal weight_type_capture string Type of weight measurement whole May need to compile a list of types and abbreviations: whole, dressed, gilled & gutted optional
513 animal weight_type_recapture string Type of weight measurement \N May need to compile a list of types and abbreviations: whole, dressed, gilled & gutted optional
421 animal weight_unit_capture string Unit of weight measurement pound \N optional
514 animal weight_unit_recapture string Unit of weight measurement \N \N optional
600 end_of_mission time_coverage_end string End date time (yyyy-mm-dd hh:mm:ss) or date range (BETWEEN yyyy-mm-dd AND yyyy-mm-dd) if estimated/ guessed. 2017-07-11T18:24:23+00:00 http://en.wikipedia.org/wiki/ISO_8601 required
601 end_of_mission end_details string TODO GPS, Argos, estimated, calculated, modeled, recovered on animal, floater at sea, animal died and sank, recovered on land, recovered by fishing fleet, recovered in port, transfer in transshipment, found in well number X, recovered in processing plant \N required
602 end_of_mission end_type string Description of how the end point is derived for the device. first reported, recaptured, last transmission, recovered \N required
603 end_of_mission geospatial_lat_end string End latitude \N \N required
604 end_of_mission geospatial_lon_end string End longitude \N \N required
605 end_of_mission locationclass_end string Argos location class for popup location or satellite transmission \N \N recommended
606 end_of_mission datetime_death string If mortality occurs before end datetime, specify date time (yyyy-mm-dd hh:mm:ss) 2017-07-11T18:24:23+00:00 http://en.wikipedia.org/wiki/ISO_8601 optional
700 recovery location_recapture string Name or standard identifer of location \N \N recommended
701 recovery method_recapture string Type of gear used to catch the animal Longline, purse seine, troll, trawl, rod and reel, handline, set net, trap, gillnet, harpoon, hoop net, anesthesia, tangle net, dip net, vertical line entanglement (commercial fisheries, aquaculture, mooring), dredge, pound net/weir (for turtles) \N recommended
702 recovery person_recapture string Person responsible for the recapture \N Name of angler, observer, scientist, fisher, beach comber etc. recommended
703 recovery baitlure_recapture string Bait, chum, lure or decoy used \N Use brand name and/ product when possible optional
704 recovery cruise_recapture string Name or standard identifer of cruise \N \N optional
705 recovery depth_m_recapture string Depth (meters) at which the animal was caught \N Can use estimated depth from hook number on longline optional
706 recovery flag_capture string The vessel’s country of registration \N \N optional
707 recovery hook_recapture string Type of hook used \N Use brand name and/ product when possible. optional
708 recovery person_tagger_recapture string Person responsible for tag-and-release \N Very unlikely to re-tag turtle or mammal optional
709 recovery retagged_recapture string List tag IDs for conventional, acoustic, PIT, band or satellite tags for multi-tagged situation, photoID, photo/video footage file names \N \N optional
710 recovery school_recapture string Type of school in which the animal was caught Free school, log, anchored FAD, drifting FAD Include FAD number if possible optional
711 recovery seastate_recapture string World Meteorological Organization sea state code (0-9) \N Similar to Douglas Sea Scale optional
712 recovery set_float_recapture string If caught on longline, include set number and float number \N \N optional
713 recovery station_recapture string Name or standard identifer of station \N \N optional
714 recovery temp_degC_recapture string Air or sea surface temperature (Celcius) when the animal was caught \N \N optional
715 recovery vessel_recapture string Name or standard identifer of vessel \N \N optional
716 recovery wind_knots_recapture string Wind speed (knots) when the animal was caught \N \N optional
1000 waypoints waypoints_source string State the source for waypoints Argos, GPS, acoustic detections, manufacturer, modeled Waypoints are 'points'" along the trajectory of the tagged animal between the start and end dates." required
1001 waypoints geolocation_parameters string List of Geocorrection Parameters and associated values implemented. Comma seperated list in format ''parameter1:value'', ''parameter2:value'',.. eg. ''diffusion_coefficien:0.3'', ''satellite_sst'': https://podaac.jpl.nasa.gov/dataset/NCDC-L4LRblend-GLOB-AVHRR_OI'', ... Assuming only 1 set of waypoints per tag data file. recommended
1002 waypoints interpolation_method string None if no interpolation. Otherwise, specify method/ software used. None, crawl, Bézier curves, Hermite splines and cubic splines \N recommended
1003 waypoints interpolation_time string Specify the time interval for interpolation 0, 1 hour, gap filling Use 0 for no interpolation or gap filling for data points without any coordinates. recommended
1004 waypoints waypoints_method string If 'waypoints_source'" = '"modeled'" specify the method used to estimate the positions. Include citation/ reference/ url if available" kftrack, ukfsst, trackit, tripEstimation, SSM, GPE3, Track & Loc, GeoLight, BASTrack, IKNOS recommended
1005 waypoints waypoints_software string Software packages used with version number \N \N recommended
1006 waypoints geolocation_output string URL/URI to any relevant geocorrection output file(s) produced eg. ftp://myserver/myfiles.zip \N optional
1100 ancillary_positions ancillary_position_source string List available source(s) for other known position(s) Acoustic detections If an animal is tagged and then released again, this can be included here as well optional
1101 ancillary_positions ancillary_position_instrumentid string List chronologically the instruments collecting the ancillary position(s) receiverID1003, receiverID1008, receiverID1121 \N optional
1102 ancillary_positions datetime_ancillary_position string List chronologically the datetime (yyyy-mm-dd hh:mm:ss) for ancillary position(s) 2016-01-04 22:32:21, 2016-02-01 02:41:11, 2016-03-29 09:15:31 http://en.wikipedia.org/wiki/ISO_8601 optional
1103 ancillary_positions ancillary_position_lon string List chronologically the longitude for ancillary position(s) -153.42,-152.42,-152.49 \N optional
1104 ancillary_positions ancillary_position_lat string List chronologically the latitude for ancillary position(s) 42.131,41.135,42.422 \N optional
1105 ancillary_positions ancillary_position_quality string List chronologically the quality (location class/ accuracy/ range etc.) for ancillary position(s). Can be qualitative. LC0,LC1,LCA Can be Argos location class or general descriptions optional
1200 quality found_problem string Is there any problem found in this dataset? One of 3 responses: yes, no, unexamined. yes \N required
1201 quality person_qc string Person responsible for quality control \N \N required
1202 quality problem_affecteddates string Date range (BETWEEN yyyy-mm-dd AND yyyy-mm-dd) in which data quality is in doubt \N \N recommended
1203 quality problem_details string Provide details for the problem(s) Daily drift after sunset by 1.5 degC \N recommended
1204 quality problem_numof string Number of problems found 1 Hard to cover all problems here, e.g., date of post-release mortality/ predation, broken light stalk, broken hardware, tag failure modes recommended
1205 quality problem_summary string List short description(s) for the problem(s) Temperature sensor drift \N recommended
1206 quality calibration_file string Files/ URLs used for calibration of sensors \N \N optional
\.
--
-- TOC entry 2215 (class 0 OID 184580)
-- Dependencies: 188
-- Data for Name: observation_types; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY observation_types (variable_id, variable_name, standard_name, variable_source, variable_units, notes, standard_unit) FROM stdin;
1 datetime \N common time Date time stamp, usually understood to be in GMT time zone when time zone is not specified. Ideally, format after ISO8601 as yyyy-mm-dd hh:mm:ss \N
2 longitude longitude common degree Decimical degree degree_east
3 latitude latitude common degree Decimical degree degree_north
4 pressure sea_water_pressure common psi Pressure expressed as pound-force per square inch dbar
5 depth depth common meter Depth in meter, usually converted from pressure measurements meter
6 temperature sea_water_temperature common Celsius External sensor temperature, usually water temperature in Celsius K
7 internal temperature \N common Celsius Internal sesnor temperature, usually body cavity temperature in Celsius \N
8 light \N common unitless Measured blue or green light on a logarithmic scale. Usually expressed as unitless by Wildlife Computers (light sensor in W cm-2), Lotek and Microwave Telemetry (light sensor in Lux) tags. Also termed as relative light levels. \N
9 accelX \N common G Acceleration in the X-axis expressed as gravitational force (1 G ~ 9.8 ms-2) \N
10 accelY \N common G Acceleration in the Y-axis expressed as gravitational force (1 G ~ 9.8 ms-2) \N
11 accelZ \N common G Acceleration in the Z-axis expressed as gravitational force (1 G ~ 9.8 ms-2) \N
12 accelM \N common G Magnitude of acceleration expressed as gravitational force (1 G ~ 9.8 ms-2) \N
13 accelMdelta \N common G Change in magnitude of acceleration \N
14 magX \N common nT Magnetic field strength in the X-axis as nanotesla \N
15 magY \N common nT Magnetic field strength in the Y-axis as nanotesla \N
16 magZ \N common nT Magnetic field strength in the Z-axis as nanotesla \N
17 oxygen mole_concentration_of_dissolved_molecular_oxygen_in_sea_water common ml L-1 Dissolved oxygen expressed in milliter per liter mol m-3
18 OxySat fractional_saturation_of_oxygen_in_sea_water common Percent Oxygen saturation in percent 1
19 longitudeError \N common degree Confidence interval is bound by +/- this number \N
20 latitudeError \N common degree Confidence interval is bound by +/- this number \N
21 salinity \N common PSU Salinity expressed as Practical Salinity Unit, which is is equivalent to per thousand or (o/00) or to g/kg \N
22 conductivity \N common S m-1 Conductivity expresed as Siemens (S) per meter, which is equivalent to mS/cm \N
23 sst sea_surface_temperature common Celsius Sea surface temperature K
24 solarVoltage \N Desert Star volts For Desert Star tags, mean Solar Panel Voltage in SDPT_3DSN2 packet. (light intensity ~100 Lux/V) \N
25 heartrate \N Star Oddi BPM Heart rate measured as beats per minute, BPM \N
26 tiltX \N Star Oddi degree Tilt in the X-axis \N
27 tiltY \N Star Oddi degree Tilt in the Y-axis \N
28 tiltZ \N Star Oddi degree Tilt in the Z-axis \N
29 pitch \N Wildlife Computers degree Counterclockwise rotation of the tag about its Y axis. This value is given in degrees from -90 to +90 (where a horizontal tag reads 0 degrees). \N
30 roll \N Wildlife Computers degree Counterclockwise rotation of the tag about its X axis. This value is given in degrees from -180 to +180 (where a tag flat on its base reads 0 degrees). \N
31 heading \N Wildlife Computers degree Direction in which the nose of the tag is pointing. The value is expressed in degrees on a scale from 0 to 360. Magnetic North corresponds to a reading of 0 with a clockwise rotation increasing the value (consistent with navigational headings). \N
32 magDip \N Wildlife Computers degree angle at which the earth’s magnetic flux lines enter the earth’s surface. This value is given in degrees, from -90 to +90 with 0 being completely horizontal to the earth’s surface. +90 corresponds to the tag resting directly over the magnetic north pole while a -90 reading means the tag is over the magnetic south pole. \N
33 stomach temperature \N Wildlife Computers Celsius Stomach temperature, usually measured by an ingested logger \N
1001 frequency \N aggregation unitless Frequency takes only a value between 0 and 1 \N
1002 percentage \N aggregation percent Takes a value between 0 and 100 \N
1003 count \N aggregation number Total number of times this particular data item was received, verified, or successfully decoded. \N
1004 depthMin \N aggregation meter Mean depth in a series of measurements \N
1005 depthMax \N aggregation meter Maximum depth in a series of measurements \N
1006 depthMean \N aggregation meter Minimum depth in a series of measurements \N
1007 depthMedian \N aggregation meter Median depth in a series of measurements \N
1008 depthStDev \N aggregation meter Standard deviation of depth measurements \N
1009 depthSunrise \N Microwave Telemetry meter Depth occupied at sunset. Light levels are analyzed onboard the tag with manufacturer algorithm to determine the time of sunrise and sunset each day. \N
1010 depthSunset \N Microwave Telemetry meter Depth occupied at sunrise. Light levels are analyzed onboard the tag with manufacturer algorithm to determine the time of sunrise and sunset each day. \N
1011 depthDelta \N Microwave Telemetry meter Delta value represents the resolution of a transmitted depth measurement after applying data compression. See manufacturer's website for details. \N
1012 lightMin \N Microwave Telemetry unitless Minimum light level recorded in a given day. Useful for detecting a mortality event. \N
1013 lightMax \N Microwave Telemetry unitless Maximum light level recorded in a given day. Useful for detecting a mortality event. \N
1014 tempDelta \N Microwave Telemetry Celsius Delta value represents the resolution of a transmitted temperature measurement after applying data compression. See manufacturer's website for details. \N
1015 tempMin \N aggregation Celsius Mean temperature in a series of measurements \N
1016 tempMax \N aggregation Celsius Maximum temperature in a series of measurements \N
1017 tempMean \N aggregation Celsius Mean temperature in a series of measurements \N
1018 tempMedian \N aggregation Celsius Median temperature in a series of measurements \N
1019 tempStDev \N aggregation Celsius Standard deviation of temperature measurements \N
1020 sstMin \N aggregation Celsius Mean sea surface temperature in a series of measurements \N
1021 sstMax \N aggregation Celsius Maximumsea surface temperature in a series of measurements \N
1022 sstMean \N aggregation Celsius Mean sea surface temperature in a series of measurements \N
1023 sstMedian \N aggregation Celsius Median sea surface temperature in a series of measurements \N
1024 sstStDev \N aggregation Celsius Standard deviation of sea surface temperature measurements \N
1025 sstDepth \N Wildlife Computers meter Depth, in meters, when the sea surface temperature was sampled. This value needs to be doubled for a 2000 meter instrument. \N
1026 sstDateTime \N Wildlife Computers time Time of day when the sea surface temperature was sampled \N
101 PdtDepth01 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
102 PdtTempMin01 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
103 PdtTempMax01 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
104 PdtDepth02 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
105 PdtTempMin02 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
106 PdtTempMax02 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
107 PdtDepth03 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
108 PdtTempMin03 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
109 PdtTempMax03 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
110 PdtDepth04 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
111 PdtTempMin04 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
112 PdtTempMax04 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
113 PdtDepth05 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
114 PdtTempMin05 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
115 PdtTempMax05 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
116 PdtDepth06 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
117 PdtTempMin06 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
118 PdtTempMax06 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
119 PdtDepth07 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
120 PdtTempMin07 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
121 PdtTempMax07 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
122 PdtDepth08 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
123 PdtTempMin08 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
124 PdtTempMax08 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
125 PdtDepth09 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
126 PdtTempMin09 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
127 PdtTempMax09 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
128 PdtDepth10 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
129 PdtTempMin10 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
130 PdtTempMax10 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
131 PdtDepth11 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
132 PdtTempMin11 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
133 PdtTempMax11 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
134 PdtDepth12 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
135 PdtTempMin12 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
136 PdtTempMax12 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
137 PdtDepth13 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
138 PdtTempMin13 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
139 PdtTempMax13 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
140 PdtDepth14 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
141 PdtTempMin14 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
142 PdtTempMax14 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
143 PdtDepth15 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
144 PdtTempMin15 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
145 PdtTempMax15 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
146 PdtDepth16 \N Wildlife Computers meter For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
147 PdtTempMin16 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
148 PdtTempMax16 \N Wildlife Computers Celsius For Wildlife Computers tags, profile-depth-temperature (PDT) output in PDTs.csv \N
301 HistDepthBinMin01 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
302 HistDepthBinMax01 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
303 HistDepthBinMin02 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
304 HistDepthBinMax02 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
305 HistDepthBinMin03 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
306 HistDepthBinMax03 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
307 HistDepthBinMin04 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
308 HistDepthBinMax04 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
309 HistDepthBinMin05 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
310 HistDepthBinMax05 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
311 HistDepthBinMin06 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
312 HistDepthBinMax06 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
313 HistDepthBinMin07 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
314 HistDepthBinMax07 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
315 HistDepthBinMin08 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
316 HistDepthBinMax08 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
317 HistDepthBinMin09 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
318 HistDepthBinMax09 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
319 HistDepthBinMin10 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
320 HistDepthBinMax10 \N Wildlife Computers, Desert Star meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
321 HistDepthBinMin11 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
322 HistDepthBinMax11 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
323 HistDepthBinMin12 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
324 HistDepthBinMax12 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
325 HistDepthBinMin13 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
326 HistDepthBinMax13 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
327 HistDepthBinMin14 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
328 HistDepthBinMax14 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
329 HistDepthBinMin15 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
330 HistDepthBinMax15 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
331 HistDepthBinMin16 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
332 HistDepthBinMax16 \N Wildlife Computers meter For Wildlife Computers tags, bin definition for time-at-depth output in Histos.csv \N
333 HistTempBinMin01 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
334 HistTempBinMax01 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
335 HistTempBinMin02 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
336 HistTempBinMax02 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
337 HistTempBinMin03 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
338 HistTempBinMax03 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
339 HistTempBinMin04 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
340 HistTempBinMax04 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
341 HistTempBinMin05 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
342 HistTempBinMax05 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
343 HistTempBinMin06 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
344 HistTempBinMax06 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
345 HistTempBinMin07 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
346 HistTempBinMax07 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
347 HistTempBinMin08 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
348 HistTempBinMax08 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
349 HistTempBinMin09 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
350 HistTempBinMax09 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
351 HistTempBinMin10 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
352 HistTempBinMax10 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
353 HistTempBinMin11 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
354 HistTempBinMax11 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
355 HistTempBinMin12 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
356 HistTempBinMax12 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
357 HistTempBinMin13 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
358 HistTempBinMax13 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
359 HistTempBinMin14 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
360 HistTempBinMax14 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
361 HistTempBinMin15 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
362 HistTempBinMax15 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
363 HistTempBinMin16 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
364 HistTempBinMax16 \N Wildlife Computers Celsius For Wildlife Computers tags, bin definition for time-at-temperature output in Histos.csv \N
365 TimeAtDepthBin01 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
366 TimeAtDepthBin02 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
367 TimeAtDepthBin03 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
368 TimeAtDepthBin04 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
369 TimeAtDepthBin05 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
370 TimeAtDepthBin06 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
371 TimeAtDepthBin07 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
372 TimeAtDepthBin08 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
373 TimeAtDepthBin09 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
374 TimeAtDepthBin10 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
375 TimeAtDepthBin11 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
376 TimeAtDepthBin12 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
377 TimeAtDepthBin13 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
378 TimeAtDepthBin14 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
379 TimeAtDepthBin15 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
380 TimeAtDepthBin16 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
381 TimeAtTempBin01 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
382 TimeAtTempBin02 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
383 TimeAtTempBin03 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
384 TimeAtTempBin04 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
385 TimeAtTempBin05 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
386 TimeAtTempBin06 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
387 TimeAtTempBin07 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
388 TimeAtTempBin08 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
389 TimeAtTempBin09 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
390 TimeAtTempBin10 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
391 TimeAtTempBin11 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
392 TimeAtTempBin12 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
393 TimeAtTempBin13 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
394 TimeAtTempBin14 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
395 TimeAtTempBin15 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
396 TimeAtTempBin16 \N Wildlife Computers frequency Time spent at bin during a sampling period (e.g., 1-24 hours), expressed as a value between 0 and 1 in Histos.csv \N
\.
--
-- TOC entry 2216 (class 0 OID 184591)
-- Dependencies: 189
-- Data for Name: proc_observations; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY proc_observations (date_time, variable_id, variable_value, submission_id, tag_id) FROM stdin;
\.
--
-- TOC entry 2213 (class 0 OID 184571)
-- Dependencies: 186
-- Data for Name: submission; Type: TABLE DATA; Schema: public; Owner: tagbase
--
COPY submission (submission_id, tag_id, dmas_granule_id, date_time, filename, version) FROM stdin;
\.
--
-- TOC entry 2305 (class 0 OID 0)
-- Dependencies: 187
-- Name: observation_types_variable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tagbase
--
SELECT pg_catalog.setval('observation_types_variable_id_seq', 1, false);
--
-- TOC entry 2306 (class 0 OID 0)
-- Dependencies: 185
-- Name: submission_submission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tagbase
--
SELECT pg_catalog.setval('submission_submission_id_seq', 1, false);
--
-- TOC entry 2307 (class 0 OID 0)
-- Dependencies: 197
-- Name: submission_tag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tagbase
--
SELECT pg_catalog.setval('submission_tag_id_seq', 1, false);
--
-- TOC entry 2073 (class 2606 OID 185000)
-- Name: data_histogram_bin_data data_histogram_bin_data_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_data
ADD CONSTRAINT data_histogram_bin_data_pkey PRIMARY KEY (submission_id, tag_id, bin_id, bin_class, date_time, variable_id) WITH (fillfactor='100');
--
-- TOC entry 2068 (class 2606 OID 184664)
-- Name: data_histogram_bin_info data_histogram_bin_info_bin_id_bin_class_key; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_info
ADD CONSTRAINT data_histogram_bin_info_bin_id_bin_class_key UNIQUE (bin_id, bin_class);
--
-- TOC entry 2070 (class 2606 OID 184996)
-- Name: data_histogram_bin_info data_histogram_bin_info_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_info
ADD CONSTRAINT data_histogram_bin_info_pkey PRIMARY KEY (variable_id, bin_id, bin_class) WITH (fillfactor='100');
--
-- TOC entry 2062 (class 2606 OID 184728)
-- Name: data_position data_position_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_position
ADD CONSTRAINT data_position_pkey PRIMARY KEY (submission_id, tag_id, date_time);
--
-- TOC entry 2077 (class 2606 OID 185002)
-- Name: data_profile data_profile_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_profile
ADD CONSTRAINT data_profile_pkey PRIMARY KEY (submission_id, tag_id, date_time, depth, variable_id) WITH (fillfactor='100');
--
-- TOC entry 2065 (class 2606 OID 184720)
-- Name: data_time_series data_time_series_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_time_series
ADD CONSTRAINT data_time_series_pkey PRIMARY KEY (submission_id, tag_id, variable_id, date_time);
--
-- TOC entry 2058 (class 2606 OID 184716)
-- Name: metadata metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY metadata
ADD CONSTRAINT metadata_pkey PRIMARY KEY (submission_id, attribute_id);
--
-- TOC entry 2056 (class 2606 OID 184611)
-- Name: metadata_types metadata_types_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY metadata_types
ADD CONSTRAINT metadata_types_pkey PRIMARY KEY (attribute_id);
--
-- TOC entry 2050 (class 2606 OID 184588)
-- Name: observation_types observation_types_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY observation_types
ADD CONSTRAINT observation_types_pkey PRIMARY KEY (variable_id);
--
-- TOC entry 2052 (class 2606 OID 184590)
-- Name: observation_types observation_types_variable_name_key; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY observation_types
ADD CONSTRAINT observation_types_variable_name_key UNIQUE (variable_name);
--
-- TOC entry 2054 (class 2606 OID 184761)
-- Name: proc_observations proc_observations_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY proc_observations
ADD CONSTRAINT proc_observations_pkey PRIMARY KEY (date_time, variable_id, submission_id);
--
-- TOC entry 2048 (class 2606 OID 184577)
-- Name: submission submission_pkey; Type: CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY submission
ADD CONSTRAINT submission_pkey PRIMARY KEY (submission_id);
--
-- TOC entry 2071 (class 1259 OID 184701)
-- Name: data_histogram_bin_data_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_histogram_bin_data_date_time_index ON data_histogram_bin_data USING btree (date_time);
--
-- TOC entry 2074 (class 1259 OID 184702)
-- Name: data_histogram_bin_data_pos_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_histogram_bin_data_pos_date_time_index ON data_histogram_bin_data USING btree (position_date_time);
--
-- TOC entry 2059 (class 1259 OID 184698)
-- Name: data_position_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_position_date_time_index ON data_position USING btree (date_time);
--
-- TOC entry 2060 (class 1259 OID 184822)
-- Name: data_position_latlontime_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_position_latlontime_index ON data_position USING btree (date_time, lat, lon, submission_id, tag_id);
--
-- TOC entry 2075 (class 1259 OID 184703)
-- Name: data_profile_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_profile_date_time_index ON data_profile USING btree (date_time);
--
-- TOC entry 2078 (class 1259 OID 184704)
-- Name: data_profile_pos_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_profile_pos_date_time_index ON data_profile USING btree (position_date_time);
--
-- TOC entry 2063 (class 1259 OID 184699)
-- Name: data_time_series_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_time_series_date_time_index ON data_time_series USING btree (date_time);
--
-- TOC entry 2066 (class 1259 OID 184700)
-- Name: data_time_series_pos_date_time_index; Type: INDEX; Schema: public; Owner: tagbase
--
CREATE INDEX data_time_series_pos_date_time_index ON data_time_series USING btree (position_date_time);
--
-- TOC entry 2088 (class 2606 OID 184673)
-- Name: data_histogram_bin_data data_histogram_bin_data_submission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_data
ADD CONSTRAINT data_histogram_bin_data_submission_id_fkey FOREIGN KEY (submission_id) REFERENCES submission(submission_id) ON DELETE CASCADE;
--
-- TOC entry 2087 (class 2606 OID 185018)
-- Name: data_histogram_bin_info data_histogram_bin_info; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_info
ADD CONSTRAINT data_histogram_bin_info FOREIGN KEY (variable_id) REFERENCES observation_types(variable_id);
--
-- TOC entry 2083 (class 2606 OID 184631)
-- Name: data_position data_position_submission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_position
ADD CONSTRAINT data_position_submission_id_fkey FOREIGN KEY (submission_id) REFERENCES submission(submission_id) ON DELETE CASCADE;
--
-- TOC entry 2084 (class 2606 OID 184639)
-- Name: data_time_series data_time_series_variable_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_time_series
ADD CONSTRAINT data_time_series_variable_id_fkey FOREIGN KEY (variable_id) REFERENCES observation_types(variable_id);
--
-- TOC entry 2091 (class 2606 OID 185013)
-- Name: data_histogram_bin_data datahistogrambindata_observationtypes_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_data
ADD CONSTRAINT datahistogrambindata_observationtypes_fkey FOREIGN KEY (variable_id) REFERENCES observation_types(variable_id);
--
-- TOC entry 2093 (class 2606 OID 184990)
-- Name: data_profile dataprofile_dataposition_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_profile
ADD CONSTRAINT dataprofile_dataposition_fkey FOREIGN KEY (submission_id, tag_id, position_date_time) REFERENCES data_position(submission_id, tag_id, date_time);
--
-- TOC entry 2094 (class 2606 OID 185008)
-- Name: data_profile dataprofile_observationtypes_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_profile
ADD CONSTRAINT dataprofile_observationtypes_fkey FOREIGN KEY (variable_id) REFERENCES observation_types(variable_id);
--
-- TOC entry 2092 (class 2606 OID 184802)
-- Name: data_profile dataprofile_submission_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_profile
ADD CONSTRAINT dataprofile_submission_fkey FOREIGN KEY (submission_id) REFERENCES submission(submission_id);
--
-- TOC entry 2086 (class 2606 OID 184787)
-- Name: data_time_series datatimeseries_procobservations_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
-- ALTER TABLE ONLY data_time_series
-- ADD CONSTRAINT datatimeseries_procobservations_fkey FOREIGN KEY (date_time, variable_id, submission_id) REFERENCES proc_observations(date_time, variable_id, submission_id) ON DELETE CASCADE;
--
-- TOC entry 2085 (class 2606 OID 184782)
-- Name: data_time_series datetimeseries_datapositions_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_time_series
ADD CONSTRAINT datetimeseries_datapositions_fkey FOREIGN KEY (submission_id, tag_id, position_date_time) REFERENCES data_position(submission_id, tag_id, date_time);
--
-- TOC entry 2089 (class 2606 OID 184812)
-- Name: data_histogram_bin_data histogrambindata_dataposition_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_data
ADD CONSTRAINT histogrambindata_dataposition_fkey FOREIGN KEY (submission_id, tag_id, position_date_time) REFERENCES data_position(submission_id, tag_id, date_time);
--
-- TOC entry 2090 (class 2606 OID 184817)
-- Name: data_histogram_bin_data histogrambindata_histogrambininfo_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY data_histogram_bin_data
ADD CONSTRAINT histogrambindata_histogrambininfo_fkey FOREIGN KEY (bin_id, bin_class) REFERENCES data_histogram_bin_info(bin_id, bin_class);
--
-- TOC entry 2082 (class 2606 OID 184623)
-- Name: metadata metadata_attribute_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY metadata
ADD CONSTRAINT metadata_attribute_id_fkey FOREIGN KEY (attribute_id) REFERENCES metadata_types(attribute_id);
--
-- TOC entry 2081 (class 2606 OID 184618)
-- Name: metadata metadata_submission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY metadata
ADD CONSTRAINT metadata_submission_id_fkey FOREIGN KEY (submission_id) REFERENCES submission(submission_id) ON DELETE CASCADE;
--
-- TOC entry 2080 (class 2606 OID 184599)
-- Name: proc_observations proc_observations_submission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY proc_observations
ADD CONSTRAINT proc_observations_submission_id_fkey FOREIGN KEY (submission_id) REFERENCES submission(submission_id) ON DELETE CASCADE;
--
-- TOC entry 2079 (class 2606 OID 184594)
-- Name: proc_observations proc_observations_variable_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: tagbase
--
ALTER TABLE ONLY proc_observations
ADD CONSTRAINT proc_observations_variable_id_fkey FOREIGN KEY (variable_id) REFERENCES observation_types(variable_id);
-- Completed on 2018-06-12 18:25:24
--
-- PostgreSQL database dump complete
--
You can’t perform that action at this time.