Created
January 7, 2015 19:32
-
-
Save lukecampbell/7950483b376b56754651 to your computer and use it in GitHub Desktop.
OOI Data Stuff
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- PostgreSQL database dump | |
| -- | |
| SET statement_timeout = 0; | |
| SET lock_timeout = 0; | |
| SET client_encoding = 'UTF8'; | |
| SET standard_conforming_strings = on; | |
| SET check_function_bodies = false; | |
| SET client_min_messages = warning; | |
| -- | |
| -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - | |
| -- | |
| CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; | |
| -- | |
| -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: - | |
| -- | |
| COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | |
| -- | |
| -- Name: postgis; Type: EXTENSION; Schema: -; Owner: - | |
| -- | |
| CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; | |
| -- | |
| -- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: - | |
| -- | |
| COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions'; | |
| SET search_path = public, pg_catalog; | |
| -- | |
| -- Name: f_concat_rd(text, text, text, text, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| -- | |
| CREATE FUNCTION f_concat_rd(array_type text, array_name text, site text, platform text, assembly text, instrument_name text) RETURNS text | |
| LANGUAGE plpgsql | |
| AS $$ | |
| BEGIN | |
| IF assembly IS NOT NULL AND instrument_name IS NOT NULL THEN | |
| RETURN concat(array_type, ' ', array_name, ' ', site, ' ', platform, ' - ', assembly, ' - ', instrument_name); | |
| ELSIF assembly IS NOT NULL AND instrument_name IS NULL THEN | |
| RETURN concat(array_type, ' ', array_name, ' ', site, ' ', platform, ' - ', assembly); | |
| ELSE | |
| RETURN concat(array_type, ' ', array_name, ' ', site, ' ', platform); | |
| END IF; | |
| END | |
| $$; | |
| -- | |
| -- Name: f_display_name(text); Type: FUNCTION; Schema: public; Owner: - | |
| -- | |
| CREATE FUNCTION f_display_name(reference_designator text) RETURNS text | |
| LANGUAGE plpgsql | |
| AS $_$ | |
| DECLARE | |
| p_n platformnames%rowtype; | |
| i_n instrumentnames%rowtype; | |
| assy TEXT; | |
| inst TEXT; | |
| platform_text TEXT; | |
| rd_len INT; | |
| BEGIN | |
| rd_len := char_length(reference_designator); | |
| IF NOT reference_designator ~ 'MOAS' THEN | |
| SELECT * INTO p_n FROM platformnames WHERE platformnames.reference_designator ~ SUBSTRING($1 FROM 0 FOR 15) LIMIT 1; | |
| ELSE | |
| SELECT * INTO p_n FROM platformnames WHERE platformnames.reference_designator ~ SUBSTRING($1 FROM 0 FOR 9) LIMIT 1; | |
| END IF; | |
| IF NOT FOUND THEN | |
| RETURN reference_designator; | |
| END IF; | |
| IF rd_len = 8 THEN | |
| RETURN f_concat_rd(p_n.array_type, p_n.array_name, p_n.site, p_n.platform, NULL, NULL); | |
| ELSIF rd_len = 14 THEN | |
| assy := SUBSTRING(reference_designator FROM 10 FOR 5); | |
| IF assy ~ 'AV[0-9]{3}' THEN | |
| platform_text := 'AUV ' || SUBSTRING(assy FROM 4 FOR 3); | |
| ELSIF assy ~ 'GL[0-9]{3}' THEN | |
| platform_text := 'Glider ' || SUBSTRING(assy FROM 4 FOR 3); | |
| ELSE | |
| platform_text := p_n.assembly; | |
| END IF; | |
| RETURN f_concat_rd(p_n.array_type, p_n.array_name, p_n.site, p_n.platform, platform_text, NULL); | |
| ELSIF rd_len = 27 THEN | |
| inst := SUBSTRING(reference_designator FROM 19 FOR 5); | |
| assy := SUBSTRING(reference_designator FROM 10 FOR 5); | |
| IF assy ~ 'AV[0-9]{3}' THEN | |
| platform_text := 'AUV ' || SUBSTRING(assy FROM 4 FOR 3); | |
| ELSIF assy ~ 'GL[0-9]{3}' THEN | |
| platform_text := 'Glider ' || SUBSTRING(assy FROM 4 FOR 3); | |
| ELSE | |
| platform_text := p_n.assembly; | |
| END IF; | |
| SELECT * INTO i_n FROM instrumentnames WHERE instrumentnames.instrument_class = inst; | |
| IF NOT FOUND THEN | |
| RETURN f_concat_rd(p_n.array_type, p_n.array_name, p_n.site, p_n.platform, platform_text, inst); | |
| END IF; | |
| RETURN f_concat_rd(p_n.array_type, p_n.array_name, p_n.site, p_n.platform, platform_text, i_n.display_name); | |
| END IF; | |
| RETURN NULL; | |
| END | |
| $_$; | |
| SET default_tablespace = ''; | |
| SET default_with_oids = false; | |
| -- | |
| -- Name: arrays; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE arrays ( | |
| id integer NOT NULL, | |
| array_code text, | |
| description text, | |
| geography geography(Polygon,4326), | |
| name text | |
| ); | |
| -- | |
| -- Name: arrays_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE arrays_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: arrays_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE arrays_id_seq OWNED BY arrays.id; | |
| -- | |
| -- Name: deployments; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE deployments ( | |
| id integer NOT NULL, | |
| start_date date, | |
| end_date date, | |
| cruise_id integer | |
| ); | |
| -- | |
| -- Name: deployments_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE deployments_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: deployments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE deployments_id_seq OWNED BY deployments.id; | |
| -- | |
| -- Name: instrument_deployments; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE instrument_deployments ( | |
| id integer NOT NULL, | |
| display_name text, | |
| start_date date, | |
| end_date date, | |
| platform_deployment_id integer, | |
| instrument_id integer, | |
| reference_designator text, | |
| lat real, | |
| lon real, | |
| depth real, | |
| deployment_id integer | |
| ); | |
| -- | |
| -- Name: instrument_deployments_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE instrument_deployments_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: instrument_deployments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE instrument_deployments_id_seq OWNED BY instrument_deployments.id; | |
| -- | |
| -- Name: instrumentnames; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE instrumentnames ( | |
| id integer NOT NULL, | |
| instrument_class text, | |
| display_name text | |
| ); | |
| -- | |
| -- Name: instrumentnames_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE instrumentnames_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: instrumentnames_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE instrumentnames_id_seq OWNED BY instrumentnames.id; | |
| -- | |
| -- Name: instruments; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE instruments ( | |
| id integer NOT NULL, | |
| name text, | |
| description text, | |
| location text, | |
| manufacturer text, | |
| series text, | |
| serial_number text, | |
| display_name text, | |
| model_id integer NOT NULL, | |
| asset_id integer NOT NULL, | |
| depth_rating real | |
| ); | |
| -- | |
| -- Name: instruments_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE instruments_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: instruments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE instruments_id_seq OWNED BY instruments.id; | |
| -- | |
| -- Name: platform_deployments; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE platform_deployments ( | |
| id integer NOT NULL, | |
| start_date date, | |
| end_date date, | |
| platform_id integer, | |
| reference_designator text NOT NULL, | |
| lat real, | |
| lon real, | |
| array_id integer, | |
| deployment_id integer, | |
| display_name text | |
| ); | |
| -- | |
| -- Name: platform_deployments_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE platform_deployments_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: platform_deployments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE platform_deployments_id_seq OWNED BY platform_deployments.id; | |
| -- | |
| -- Name: platformnames; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE platformnames ( | |
| id integer NOT NULL, | |
| reference_designator text, | |
| array_type text, | |
| array_name text, | |
| site text, | |
| platform text, | |
| assembly text | |
| ); | |
| -- | |
| -- Name: platformnames_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE platformnames_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: platformnames_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE platformnames_id_seq OWNED BY platformnames.id; | |
| -- | |
| -- Name: platforms; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE platforms ( | |
| id integer NOT NULL, | |
| name text, | |
| description text, | |
| location text, | |
| manufacturer text, | |
| series text, | |
| is_mobile boolean NOT NULL, | |
| serial_no text, | |
| asset_id integer NOT NULL | |
| ); | |
| -- | |
| -- Name: platforms_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE platforms_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: platforms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE platforms_id_seq OWNED BY platforms.id; | |
| -- | |
| -- Name: stream_parameters; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE stream_parameters ( | |
| id integer NOT NULL, | |
| stream_id integer, | |
| name text, | |
| short_name text, | |
| long_name text, | |
| standard_name text, | |
| units text, | |
| data_type text | |
| ); | |
| -- | |
| -- Name: stream_parameters_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE stream_parameters_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: stream_parameters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE stream_parameters_id_seq OWNED BY stream_parameters.id; | |
| -- | |
| -- Name: streams; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE streams ( | |
| id integer NOT NULL, | |
| name text, | |
| instrument_id integer, | |
| description text | |
| ); | |
| -- | |
| -- Name: streams_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| CREATE SEQUENCE streams_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| CACHE 1; | |
| -- | |
| -- Name: streams_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| ALTER SEQUENCE streams_id_seq OWNED BY streams.id; | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY arrays ALTER COLUMN id SET DEFAULT nextval('arrays_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY deployments ALTER COLUMN id SET DEFAULT nextval('deployments_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY instrument_deployments ALTER COLUMN id SET DEFAULT nextval('instrument_deployments_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY instrumentnames ALTER COLUMN id SET DEFAULT nextval('instrumentnames_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY instruments ALTER COLUMN id SET DEFAULT nextval('instruments_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY platform_deployments ALTER COLUMN id SET DEFAULT nextval('platform_deployments_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY platformnames ALTER COLUMN id SET DEFAULT nextval('platformnames_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY platforms ALTER COLUMN id SET DEFAULT nextval('platforms_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY stream_parameters ALTER COLUMN id SET DEFAULT nextval('stream_parameters_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY streams ALTER COLUMN id SET DEFAULT nextval('streams_id_seq'::regclass); | |
| -- | |
| -- Data for Name: arrays; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| INSERT INTO arrays VALUES (1, 'CP', NULL, NULL, 'Coastal Pioneer'); | |
| INSERT INTO arrays VALUES (2, 'GP', NULL, NULL, 'Global Station Papa'); | |
| -- | |
| -- Name: arrays_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('arrays_id_seq', 2, true); | |
| -- | |
| -- Data for Name: deployments; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| -- | |
| -- Name: deployments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('deployments_id_seq', 1, false); | |
| -- | |
| -- Data for Name: instrument_deployments; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| INSERT INTO instrument_deployments VALUES (173, 'Engineering Data', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (174, 'Engineering Data', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (175, '2-Wavelength Fluorometer', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (176, 'Dissolved Oxygen Stable Response', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (177, 'CTD Profiler', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (178, 'Engineering Data', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (179, '2-Wavelength Fluorometer', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (180, 'Dissolved Oxygen Stable Response', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (181, 'CTD Profiler', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (182, 'Engineering Data', NULL, NULL, 13, NULL, 'CP02PMCI-SBS01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (183, 'Velocity Profiler (short range)', NULL, NULL, 14, NULL, 'CP02PMCI-RII01-01-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (184, 'Engineering Data', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (185, '2-Wavelength Fluorometer', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (186, 'Dissolved Oxygen Stable Response', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (187, 'CTD Profiler', NULL, NULL, 33, NULL, 'GI05MOAS-GL001-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (188, 'Engineering Data', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (189, '2-Wavelength Fluorometer', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (190, 'Dissolved Oxygen Stable Response', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (99, 'Engineering Data', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (100, 'Engineering Data', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (101, 'Engineering Data', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (106, 'Engineering Data', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (107, 'Engineering Data', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (108, 'Engineering Data', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (128, 'Engineering Data', NULL, NULL, 40, NULL, 'CP04OSPM-SBS01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (115, 'Engineering Data', NULL, NULL, 16, NULL, 'CP02PMCO-SBS01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (116, 'Engineering Data', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (117, 'Engineering Data', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (118, 'Engineering Data', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (121, 'Engineering Data', NULL, NULL, 7, NULL, 'CP02PMUI-SBS01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (124, 'Engineering Data', NULL, NULL, 10, NULL, 'CP02PMUO-SBS01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (125, 'Engineering Data', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (126, 'Engineering Data', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (127, 'Engineering Data', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (130, 'Engineering Data', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (131, 'Engineering Data', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (132, 'Engineering Data', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (137, 'Engineering Data', NULL, NULL, 34, NULL, 'GI05MOAS-GL002-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (138, 'Engineering Data', NULL, NULL, 34, NULL, 'GI05MOAS-GL002-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (142, 'Engineering Data', NULL, NULL, 27, NULL, 'GP05MOAS-GL001-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (143, 'Engineering Data', NULL, NULL, 27, NULL, 'GP05MOAS-GL001-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (146, 'Engineering Data', NULL, NULL, 31, NULL, 'GP05MOAS-GL002-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (147, 'Engineering Data', NULL, NULL, 31, NULL, 'GP05MOAS-GL002-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (151, 'Engineering Data', NULL, NULL, 32, NULL, 'GP05MOAS-GL003-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (152, 'Engineering Data', NULL, NULL, 32, NULL, 'GP05MOAS-GL003-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (1, 'Velocity Profiler (short range)', NULL, NULL, 14, NULL, 'CP02PMCI-RII01-02-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (3, 'Engineering Data', NULL, NULL, 13, NULL, 'CP02PMCI-SBS01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (4, '3-Axis Motion Package', NULL, NULL, 13, NULL, 'CP02PMCI-SBS01-01-MOPAK0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (5, 'Engineering Data', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (149, 'Dissolved Oxygen Stable Response', NULL, NULL, 31, NULL, 'GP05MOAS-GL002-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (154, 'Dissolved Oxygen Stable Response', NULL, NULL, 32, NULL, 'GP05MOAS-GL003-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (133, 'CTD Profiler', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-03-CTDGV0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (134, 'CTD Profiler', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-03-CTDGV0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (191, 'CTD Profiler', NULL, NULL, 35, NULL, 'GI05MOAS-GL003-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (192, 'Engineering Data', NULL, NULL, 13, NULL, 'CP02PMCI-SBS01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (193, 'Velocity Profiler (short range)', NULL, NULL, 14, NULL, 'CP02PMCI-RII01-01-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (194, 'Engineering Data', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-00-STCENG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (135, 'CTD Profiler', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-03-CTDGV0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (136, 'CTD Profiler', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-03-CTDGV0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (139, '2-Wavelength Fluorometer', NULL, NULL, 34, NULL, 'GI05MOAS-GL002-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (148, '2-Wavelength Fluorometer', NULL, NULL, 31, NULL, 'GP05MOAS-GL002-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (153, '2-Wavelength Fluorometer', NULL, NULL, 32, NULL, 'GP05MOAS-GL003-01-FLORDM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (141, 'CTD Profiler', NULL, NULL, 34, NULL, 'GI05MOAS-GL002-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (145, 'CTD Profiler', NULL, NULL, 27, NULL, 'GP05MOAS-GL001-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (150, 'CTD Profiler', NULL, NULL, 31, NULL, 'GP05MOAS-GL002-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (155, 'CTD Profiler', NULL, NULL, 32, NULL, 'GP05MOAS-GL003-04-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (113, 'Velocity Profiler (short range)', NULL, NULL, 17, NULL, 'CP02PMCO-RII01-01-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (114, 'Velocity Profiler (short range)', NULL, NULL, 17, NULL, 'CP02PMCO-RII01-01-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (119, 'Velocity Profiler (short range)', NULL, NULL, 8, NULL, 'CP02PMUI-RII01-01-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (120, 'Velocity Profiler (short range)', NULL, NULL, 8, NULL, 'CP02PMUI-RII01-01-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (122, 'Velocity Profiler (short range)', NULL, NULL, 11, NULL, 'CP02PMUO-RII01-01-ADCPSL000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (123, 'Velocity Profiler (short range)', NULL, NULL, 11, NULL, 'CP02PMUO-RII01-01-ADCPSL000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (52, 'CTD Profiler AUV', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-03-CTDAVN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (57, 'CTD Profiler AUV', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-03-CTDAVN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (6, 'Photosynthetically Available Radiation', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-05-PARADK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (7, '3-Wavelength Fluorometer', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-04-FLORTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (8, 'CTD Profiler', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-03-CTDPFK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (9, 'Dissolved Oxygen Fast Response', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-02-DOFSTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (10, '3-D Single Point Velocity Meter', NULL, NULL, 15, NULL, 'CP02PMCI-WFP01-01-VEL3DK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (11, 'Velocity Profiler (short range)', NULL, NULL, 17, NULL, 'CP02PMCO-RII01-02-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (13, 'Engineering Data', NULL, NULL, 16, NULL, 'CP02PMCO-SBS01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (14, '3-Axis Motion Package', NULL, NULL, 16, NULL, 'CP02PMCO-SBS01-01-MOPAK0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (15, 'Dissolved Oxygen Fast Response', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-02-DOFSTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (16, 'Engineering Data', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (17, '3-D Single Point Velocity Meter', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-01-VEL3DK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (18, 'CTD Profiler', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-03-CTDPFK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (19, '3-Wavelength Fluorometer', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-04-FLORTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (20, 'Photosynthetically Available Radiation', NULL, NULL, 18, NULL, 'CP02PMCO-WFP01-05-PARADK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (22, 'Velocity Profiler (short range)', NULL, NULL, 8, NULL, 'CP02PMUI-RII01-02-ADCPTG000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (23, '3-Axis Motion Package', NULL, NULL, 7, NULL, 'CP02PMUI-SBS01-01-MOPAK0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (24, 'Engineering Data', NULL, NULL, 7, NULL, 'CP02PMUI-SBS01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (25, 'Dissolved Oxygen Fast Response', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-02-DOFSTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (26, 'Engineering Data', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (27, 'Photosynthetically Available Radiation', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-05-PARADK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (28, '3-Wavelength Fluorometer', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-04-FLORTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (29, 'CTD Profiler', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-03-CTDPFK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (30, '3-D Single Point Velocity Meter', NULL, NULL, 9, NULL, 'CP02PMUI-WFP01-01-VEL3DK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (31, 'Velocity Profiler (short range)', NULL, NULL, 11, NULL, 'CP02PMUO-RII01-02-ADCPSL000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (33, 'Engineering Data', NULL, NULL, 10, NULL, 'CP02PMUO-SBS01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (34, '3-Axis Motion Package', NULL, NULL, 10, NULL, 'CP02PMUO-SBS01-01-MOPAK0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (35, 'CTD Profiler', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-03-CTDPFK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (172, 'Temp H2 H2S pH', NULL, NULL, 39, NULL, 'RS01BATH-XX00X-00-THSPHA100', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (168, 'Velocity Point', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-VELPTD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (169, 'Velocity Point', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-VELPTD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (170, 'Velocity Point', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-VELPTD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (171, 'Velocity Point', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-VELPTD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (36, 'Engineering Data', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (37, '3-Wavelength Fluorometer', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-04-FLORTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (102, 'Photosynthetically Available Radiation', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-01-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (109, 'Photosynthetically Available Radiation', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-01-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (103, '3-Wavelength Fluorometer', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (110, '3-Wavelength Fluorometer', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (104, 'Dissolved Oxygen Stable Response', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (111, 'Dissolved Oxygen Stable Response', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (105, 'CTD Profiler', NULL, NULL, 36, NULL, 'CE05MOAS-GL320-05-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (112, 'CTD Profiler', NULL, NULL, 38, NULL, 'CE05MOAS-GL381-05-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (129, '3-Axis Motion Package', NULL, NULL, 40, NULL, 'CP04OSPM-SBS01-01-MOPAK0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (59, 'Velocity Profiler (short range)', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-05-ADCPAN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (60, 'Photosynthetically Available Radiation', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-06-PARADN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (61, 'Engineering Data', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (62, 'Dissolved Oxygen Stable Response', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-02-DOSTAN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (63, '3-Wavelength Fluorometer', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (64, 'Engineering Data', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (65, 'Photosynthetically Available Radiation', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-05-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (38, 'Photosynthetically Available Radiation', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-05-PARADK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (39, 'Dissolved Oxygen Fast Response', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-02-DOFSTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (40, '3-D Single Point Velocity Meter', NULL, NULL, 12, NULL, 'CP02PMUO-WFP01-01-VEL3DK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (41, 'Engineering Data', NULL, NULL, 5, NULL, 'CP04OSPM-SBS11-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (42, '3-Axis Motion Package', NULL, NULL, 5, NULL, 'CP04OSPM-SBS11-02-MOPAK0000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (43, '3-D Single Point Velocity Meter', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-01-VEL3DK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (44, 'CTD Profiler', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-03-CTDPFK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (45, 'Engineering Data', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (46, '3-Wavelength Fluorometer', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-04-FLORTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (47, 'Photosynthetically Available Radiation', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-05-PARADK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (48, 'Dissolved Oxygen Fast Response', NULL, NULL, 6, NULL, 'CP04OSPM-WFP01-02-DOFSTK000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (49, 'Engineering Data', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (50, 'Photosynthetically Available Radiation', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-06-PARADN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (51, 'Nitrate', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-04-NUTNRN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (53, '3-Wavelength Fluorometer', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-01-FLORTN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (54, 'Dissolved Oxygen Stable Response', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-02-DOSTAN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (55, 'Velocity Profiler (short range)', NULL, NULL, 25, NULL, 'CP05MOAS-AV001-05-ADCPAN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (56, '3-Wavelength Fluorometer', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-01-FLORTN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (58, 'Nitrate', NULL, NULL, 26, NULL, 'CP05MOAS-AV002-04-NUTNRN000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (66, 'Dissolved Oxygen Stable Response', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (67, 'CTD Profiler', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-03-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (68, 'Velocity Profiler (short range)', NULL, NULL, 19, NULL, 'CP05MOAS-GL001-01-ADCPAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (69, 'Velocity Profiler (short range)', NULL, NULL, 20, NULL, 'CP05MOAS-GL002-01-ADCPAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (70, 'Photosynthetically Available Radiation', NULL, NULL, 20, NULL, 'CP05MOAS-GL002-05-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (71, 'Dissolved Oxygen Stable Response', NULL, NULL, 20, NULL, 'CP05MOAS-GL002-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (72, 'CTD Profiler', NULL, NULL, 20, NULL, 'CP05MOAS-GL002-03-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (73, '3-Wavelength Fluorometer', NULL, NULL, 20, NULL, 'CP05MOAS-GL002-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (74, 'Engineering Data', NULL, NULL, 20, NULL, 'CP05MOAS-GL002-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (75, 'CTD Profiler', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-03-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (76, 'Dissolved Oxygen Stable Response', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (77, 'Velocity Profiler (short range)', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-01-ADCPAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (78, 'Engineering Data', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (79, 'Photosynthetically Available Radiation', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-05-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (80, '3-Wavelength Fluorometer', NULL, NULL, 21, NULL, 'CP05MOAS-GL003-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (81, 'Photosynthetically Available Radiation', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-05-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (82, 'Velocity Profiler (short range)', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-01-ADCPAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (83, '3-Wavelength Fluorometer', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (84, 'CTD Profiler', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-03-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (85, 'Dissolved Oxygen Stable Response', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (86, 'Engineering Data', NULL, NULL, 22, NULL, 'CP05MOAS-GL004-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (87, 'Photosynthetically Available Radiation', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-05-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (156, 'CTD Bottom Pumped', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-CTDBPN001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (157, 'CTD Bottom Pumped', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-CTDBPN001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (158, 'CTD Bottom Pumped', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-CTDBPN001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (159, 'CTD Bottom Pumped', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-CTDBPN001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (160, 'CTD Bottom Pumped', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-CTDBPN001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (161, 'CTD Bottom Pumped', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-CTDBPN001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (165, 'Photosynthetically Available Radiation', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-PARADA001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (166, 'Photosynthetically Available Radiation', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-PARADA001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (162, '3-Wavelength Fluorometer', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-FLORDD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (163, '3-Wavelength Fluorometer', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-FLORDD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (164, '3-Wavelength Fluorometer', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-FLORDD001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (167, 'Temp H2 H2S pH', NULL, NULL, 37, NULL, 'RS00ENGC-XX00X-00-THSPHA001', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (88, 'Dissolved Oxygen Stable Response', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (89, 'Engineering Data', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (90, 'CTD Profiler', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-03-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (91, '3-Wavelength Fluorometer', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (92, 'Velocity Profiler (short range)', NULL, NULL, 23, NULL, 'CP05MOAS-GL005-01-ADCPAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (93, '3-Wavelength Fluorometer', NULL, NULL, 24, NULL, 'CP05MOAS-GL006-02-FLORTM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (94, 'Dissolved Oxygen Stable Response', NULL, NULL, 24, NULL, 'CP05MOAS-GL006-04-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (95, 'Photosynthetically Available Radiation', NULL, NULL, 24, NULL, 'CP05MOAS-GL006-05-PARADM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (96, 'Engineering Data', NULL, NULL, 24, NULL, 'CP05MOAS-GL006-00-ENG000000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (97, 'CTD Profiler', NULL, NULL, 24, NULL, 'CP05MOAS-GL006-03-CTDGVM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (98, 'Velocity Profiler (short range)', NULL, NULL, 24, NULL, 'CP05MOAS-GL006-01-ADCPAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (140, 'Dissolved Oxygen Stable Response', NULL, NULL, 34, NULL, 'GI05MOAS-GL002-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| INSERT INTO instrument_deployments VALUES (144, 'Dissolved Oxygen Stable Response', NULL, NULL, 27, NULL, 'GP05MOAS-GL001-02-DOSTAM000', NULL, NULL, NULL, NULL); | |
| -- | |
| -- Name: instrument_deployments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('instrument_deployments_id_seq', 194, true); | |
| -- | |
| -- Data for Name: instrumentnames; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| INSERT INTO instrumentnames VALUES (1, 'ADCPA', 'Velocity Profiler (short range) for mobile assets'); | |
| INSERT INTO instrumentnames VALUES (2, 'ADCPS', 'Velocity Profiler (long range)'); | |
| INSERT INTO instrumentnames VALUES (3, 'ADCPT', 'Velocity Profiler (short range)'); | |
| INSERT INTO instrumentnames VALUES (4, 'BOTPT', 'Bottom Pressure and Tilt'); | |
| INSERT INTO instrumentnames VALUES (5, 'CAMDS', 'Digital Still Camera with Strobes'); | |
| INSERT INTO instrumentnames VALUES (6, 'CAMHD', 'HD Digital Video Camera with Strobes'); | |
| INSERT INTO instrumentnames VALUES (7, 'CTDAV', 'CTD AUV'); | |
| INSERT INTO instrumentnames VALUES (8, 'CTDBP', 'CTD Pumped'); | |
| INSERT INTO instrumentnames VALUES (9, 'CTDGV', 'CTD Glider'); | |
| INSERT INTO instrumentnames VALUES (10, 'CTDMO', 'CTD Mooring (Inductive)'); | |
| INSERT INTO instrumentnames VALUES (11, 'CTDPF', 'CTD Profiler'); | |
| INSERT INTO instrumentnames VALUES (12, 'DOFST', 'Dissolved Oxygen Fast Response'); | |
| INSERT INTO instrumentnames VALUES (13, 'DOSTA', 'Dissolved Oxygen Stable Response'); | |
| INSERT INTO instrumentnames VALUES (14, 'FDCHP', 'Direct Covariance Flux'); | |
| INSERT INTO instrumentnames VALUES (15, 'FLOBN', 'Benthic Fluid Flow'); | |
| INSERT INTO instrumentnames VALUES (16, 'FLORD', '2-Wavelength Fluorometer'); | |
| INSERT INTO instrumentnames VALUES (17, 'FLORT', '3-Wavelength Fluorometer'); | |
| INSERT INTO instrumentnames VALUES (18, 'HPIES', 'Horizontal Electric Field, Pressure and Inverted Echo Sounder'); | |
| INSERT INTO instrumentnames VALUES (19, 'HYDBB', 'Broadband Acoustic Receiver (Hydrophone)'); | |
| INSERT INTO instrumentnames VALUES (20, 'HYDLF', 'Low Frequency Broadband Acoustic Receiver (Hydrophone) on Seafloor'); | |
| INSERT INTO instrumentnames VALUES (21, 'MASSP', 'Mass Spectrometer'); | |
| INSERT INTO instrumentnames VALUES (22, 'METBK', 'Bulk Meteorology Instrument Package'); | |
| INSERT INTO instrumentnames VALUES (23, 'NUTNR', 'Nitrate'); | |
| INSERT INTO instrumentnames VALUES (24, 'OBSBB', 'Broadband Ocean Bottom Seismometer'); | |
| INSERT INTO instrumentnames VALUES (25, 'OBSBK', 'Broadband Ocean Bottom Seismometer'); | |
| INSERT INTO instrumentnames VALUES (26, 'OBSSP', 'Short-Period Ocean Bottom Seismometer'); | |
| INSERT INTO instrumentnames VALUES (27, 'OPTAA', 'Absorption Spectrophotometer'); | |
| INSERT INTO instrumentnames VALUES (28, 'OSMOI', 'Osmosis-Based Water Sampler'); | |
| INSERT INTO instrumentnames VALUES (29, 'PARAD', 'Photosynthetically Available Radiation'); | |
| INSERT INTO instrumentnames VALUES (30, 'PCO2A', 'pCO2 Air-Sea'); | |
| INSERT INTO instrumentnames VALUES (31, 'PCO2W', 'pCO2 Water'); | |
| INSERT INTO instrumentnames VALUES (32, 'PHSEN', 'Seawater pH'); | |
| INSERT INTO instrumentnames VALUES (33, 'PPSDN', 'Particulate DNA Sampler'); | |
| INSERT INTO instrumentnames VALUES (34, 'PRESF', 'Seafloor Pressure'); | |
| INSERT INTO instrumentnames VALUES (35, 'PREST', 'Tidal Seafloor Pressure'); | |
| INSERT INTO instrumentnames VALUES (36, 'RASFL', 'Hydrothermal Vent Fluid Interactive Sampler'); | |
| INSERT INTO instrumentnames VALUES (37, 'SPKIR', 'Spectral Irradiance'); | |
| INSERT INTO instrumentnames VALUES (38, 'THSPH', 'Hydrothermal Vent Fluid In-situ Chemistry'); | |
| INSERT INTO instrumentnames VALUES (39, 'TMPSF', 'Diffuse Vent Fluid 3-D Temperature Array'); | |
| INSERT INTO instrumentnames VALUES (40, 'TRHPH', 'Hydrothermal Vent Fluid Temperature and Resistivity'); | |
| INSERT INTO instrumentnames VALUES (41, 'VADCP', '5-Beam, 600 kHz Acoustic Doppler Current Profiler (= 50 m range)'); | |
| INSERT INTO instrumentnames VALUES (42, 'VEL3D', '3-D Single Point Velocity Meter'); | |
| INSERT INTO instrumentnames VALUES (43, 'VELPT', 'Single Point Velocity Meter'); | |
| INSERT INTO instrumentnames VALUES (44, 'WAVSS', 'Surface Wave Spectra'); | |
| INSERT INTO instrumentnames VALUES (45, 'ZPLSC', 'Bio-acoustic Sonar (Coastal)'); | |
| INSERT INTO instrumentnames VALUES (46, 'ZPLSG', 'Bio-acoustic Sonar (Global)'); | |
| INSERT INTO instrumentnames VALUES (47, 'ENG00', 'Engineering Data'); | |
| INSERT INTO instrumentnames VALUES (48, 'STCEN', 'Engineering Data'); | |
| INSERT INTO instrumentnames VALUES (49, 'MOPAK', '3-Axis Motion Pack'); | |
| -- | |
| -- Name: instrumentnames_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('instrumentnames_id_seq', 49, true); | |
| -- | |
| -- Data for Name: instruments; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| -- | |
| -- Name: instruments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('instruments_id_seq', 1, false); | |
| -- | |
| -- Data for Name: platform_deployments; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| INSERT INTO platform_deployments VALUES (5, NULL, NULL, NULL, 'CP04OSPM-SBS11', 39.9333, -70.8784027, 1, NULL, 'Pioneer Offshore Profiler Mooring - Surface Buoy'); | |
| INSERT INTO platform_deployments VALUES (6, NULL, NULL, NULL, 'CP04OSPM-WFP01', 39.9333, -70.8784027, 1, NULL, 'Pioneer Offshore Profiler Mooring - Wire-Following Profiler'); | |
| INSERT INTO platform_deployments VALUES (7, NULL, NULL, NULL, 'CP02PMUI-SBS01', 40.8973999, -70.685997, 1, NULL, 'Pioneer Upstream Inshore Profiler Mooring - Surface Buoy'); | |
| INSERT INTO platform_deployments VALUES (8, NULL, NULL, NULL, 'CP02PMUI-RII01', 40.8973999, -70.685997, 1, NULL, 'Pioneer Upstream Inshore Profiler Mooring - Mooring Riser'); | |
| INSERT INTO platform_deployments VALUES (9, NULL, NULL, NULL, 'CP02PMUI-WFP01', 40.8973999, -70.685997, 1, NULL, 'Pioneer Upstream Inshore Profiler Mooring - Wire-Following Profiler'); | |
| INSERT INTO platform_deployments VALUES (10, NULL, NULL, NULL, 'CP02PMUO-SBS01', 39.9430008, -70.7699966, 1, NULL, 'Pioneer Upstream Offshore Profiler Mooring - Surface Buoy'); | |
| INSERT INTO platform_deployments VALUES (11, NULL, NULL, NULL, 'CP02PMUO-RII01', 39.9430008, -70.7699966, 1, NULL, 'Pioneer Upstream Offshore Profiler Mooring - Surface Buoy'); | |
| INSERT INTO platform_deployments VALUES (12, NULL, NULL, NULL, 'CP02PMUO-WFP01', 39.9430008, -70.7699966, 1, NULL, 'Pioneer Upstream Offshore Profiler Mooring - Wire-Following Profiler'); | |
| INSERT INTO platform_deployments VALUES (13, NULL, NULL, NULL, 'CP02PMCI-SBS01', 40.2265015, -70.8779984, 1, NULL, 'Pioneer Central Inshore Profiler Mooring - Surface Buoy'); | |
| INSERT INTO platform_deployments VALUES (14, NULL, NULL, NULL, 'CP02PMCI-RII01', 40.2265015, -70.8779984, 1, NULL, 'Pioneer Central Inshore Profiler Mooring - Mooring Riser'); | |
| INSERT INTO platform_deployments VALUES (15, NULL, NULL, NULL, 'CP02PMCI-WFP01', 40.2265015, -70.8779984, 1, NULL, 'Pioneer Central Inshore Profiler Mooring - Wire-Following Profiler'); | |
| INSERT INTO platform_deployments VALUES (16, NULL, NULL, NULL, 'CP02PMCO-SBS01', 40.1012001, -70.8877029, 1, NULL, 'Pioneer Central Offshore Profiler Mooring - Surface Buoy'); | |
| INSERT INTO platform_deployments VALUES (17, NULL, NULL, NULL, 'CP02PMCO-RII01', 40.1012001, -70.8877029, 1, NULL, 'Pioneer Central Offshore Profiler Mooring - Mooring Riser'); | |
| INSERT INTO platform_deployments VALUES (18, NULL, NULL, NULL, 'CP02PMCO-WFP01', 40.1012001, -70.8877029, 1, NULL, 'Pioneer Central Offshore Profiler Mooring - Wire-Following Profiler'); | |
| INSERT INTO platform_deployments VALUES (19, NULL, NULL, NULL, 'CP05MOAS-GL001', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile Glider 001'); | |
| INSERT INTO platform_deployments VALUES (20, NULL, NULL, NULL, 'CP05MOAS-GL002', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile Glider 002'); | |
| INSERT INTO platform_deployments VALUES (21, NULL, NULL, NULL, 'CP05MOAS-GL003', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile Glider 003'); | |
| INSERT INTO platform_deployments VALUES (22, NULL, NULL, NULL, 'CP05MOAS-GL004', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile Glider 004'); | |
| INSERT INTO platform_deployments VALUES (23, NULL, NULL, NULL, 'CP05MOAS-GL005', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile Glider 005'); | |
| INSERT INTO platform_deployments VALUES (24, NULL, NULL, NULL, 'CP05MOAS-GL006', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile Glider 006'); | |
| INSERT INTO platform_deployments VALUES (25, NULL, NULL, NULL, 'CP05MOAS-AV001', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile AUV #1'); | |
| INSERT INTO platform_deployments VALUES (26, NULL, NULL, NULL, 'CP05MOAS-AV002', 40.0833015, -70.25, 1, NULL, 'Pioneer Mobile AUV #2'); | |
| INSERT INTO platform_deployments VALUES (27, NULL, NULL, NULL, 'GP05MOAS-GL001', 50.2289009, -144.348007, NULL, NULL, 'Station Papa Mobile Glider 001'); | |
| INSERT INTO platform_deployments VALUES (31, NULL, NULL, NULL, 'GP05MOAS-GL002', NULL, NULL, NULL, NULL, 'Station Papa Mobile Glider 002'); | |
| INSERT INTO platform_deployments VALUES (32, NULL, NULL, NULL, 'GP05MOAS-GL003', NULL, NULL, NULL, NULL, 'Station Papa Mobile Glider 003'); | |
| INSERT INTO platform_deployments VALUES (33, NULL, NULL, NULL, 'GI05MOAS-GL001', 59.9300766, -39.3083687, NULL, NULL, 'Irminger Sea Mobile Glider 001'); | |
| INSERT INTO platform_deployments VALUES (34, NULL, NULL, NULL, 'GI05MOAS-GL002', 59.8968544, -39.5404854, NULL, NULL, 'Irminger Sea Mobile Glider 002'); | |
| INSERT INTO platform_deployments VALUES (35, NULL, NULL, NULL, 'GI05MOAS-GL003', 59.9926414, -39.3607292, NULL, NULL, 'Irminger Sea Mobile Glider 003'); | |
| INSERT INTO platform_deployments VALUES (36, NULL, NULL, NULL, 'CE05MOAS-GL320', NULL, NULL, NULL, NULL, 'Endurance Mobile Glider 320'); | |
| INSERT INTO platform_deployments VALUES (37, NULL, NULL, NULL, 'RS00ENGC-XX00X', NULL, NULL, NULL, NULL, 'Testing Platform'); | |
| INSERT INTO platform_deployments VALUES (38, NULL, NULL, NULL, 'CE05MOAS-GL381', NULL, NULL, NULL, NULL, 'Endurance Mobile Glider 381'); | |
| INSERT INTO platform_deployments VALUES (39, NULL, NULL, NULL, 'RS01BATH-XX00X', NULL, NULL, NULL, NULL, 'Cabled Bathtub Instrument'); | |
| INSERT INTO platform_deployments VALUES (40, NULL, NULL, NULL, 'CP04OSPM-SBS01', NULL, NULL, NULL, NULL, 'Pioneer Offshore Profiler Mooring - Surface Buoy'); | |
| -- | |
| -- Name: platform_deployments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('platform_deployments_id_seq', 40, true); | |
| -- | |
| -- Data for Name: platformnames; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| INSERT INTO platformnames VALUES (108, 'CE01ISSM', 'Coastal', 'Endurance', 'OR Inshore', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (109, 'CE01ISSM-SBD17', 'Coastal', 'Endurance', 'OR Inshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (110, 'CE01ISSM-RID16', 'Coastal', 'Endurance', 'OR Inshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (111, 'CE01ISSM-MFD35', 'Coastal', 'Endurance', 'OR Inshore', 'Surface Mooring', 'MFN Base/Anchor'); | |
| INSERT INTO platformnames VALUES (112, 'CE01ISSM-MFD37', 'Coastal', 'Endurance', 'OR Inshore', 'Surface Mooring', 'MFN Base/Anchor'); | |
| INSERT INTO platformnames VALUES (113, 'CE01ISSM-MFD00', 'Coastal', 'Endurance', 'OR Inshore', 'Surface Mooring', 'MFN Base/Anchor'); | |
| INSERT INTO platformnames VALUES (114, 'CE01ISSP', 'Coastal', 'Endurance', 'OR Inshore', 'Surface-Piercing Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (115, 'CE01ISSP-SP001', 'Coastal', 'Endurance', 'OR Inshore', 'Surface-Piercing Profiler Mooring', 'Surface-Piercing Profiler'); | |
| INSERT INTO platformnames VALUES (116, 'CE02SHBP', 'Coastal', 'Endurance', 'OR Shelf', 'Benthic Experiment Package', NULL); | |
| INSERT INTO platformnames VALUES (117, 'CE02SHBP-MJ01C', 'Coastal', 'Endurance', 'OR Shelf', 'Benthic Experiment Package', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (118, 'CE02SHBP-LJ01D', 'Coastal', 'Endurance', 'OR Shelf', 'Benthic Experiment Package', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (119, 'CE02SHSM', 'Coastal', 'Endurance', 'OR Shelf', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (120, 'CE02SHSM-SBD11', 'Coastal', 'Endurance', 'OR Shelf', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (121, 'CE02SHSM-SBD12', 'Coastal', 'Endurance', 'OR Shelf', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (122, 'CE02SHSM-RID26', 'Coastal', 'Endurance', 'OR Shelf', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (123, 'CE02SHSM-RID27', 'Coastal', 'Endurance', 'OR Shelf', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (124, 'CE02SHSP', 'Coastal', 'Endurance', 'OR Shelf', 'Surface-Piercing Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (125, 'CE02SHSP-SP001', 'Coastal', 'Endurance', 'OR Shelf', 'Surface-Piercing Profiler Mooring', 'Surface-Piercing Profiler'); | |
| INSERT INTO platformnames VALUES (126, 'CE04OOPI', 'Coastal', 'Endurance', 'OR Offshore', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (127, 'CE04OOPI-PN01C', 'Coastal', 'Endurance', 'OR Offshore', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (128, 'CE04OSBP', 'Coastal', 'Endurance', 'OR Offshore', 'Benthic Experiment Package', NULL); | |
| INSERT INTO platformnames VALUES (129, 'CE04OSBP-LV01C', 'Coastal', 'Endurance', 'OR Offshore', 'Benthic Experiment Package', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (130, 'CE04OSBP-LJ01C', 'Coastal', 'Endurance', 'OR Offshore', 'Benthic Experiment Package', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (131, 'CE04OPS', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (132, 'CE04OSPS-PC01B', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', 'Interface Controller'); | |
| INSERT INTO platformnames VALUES (133, 'CE04OSPS-SC03A', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', 'Profiler Controller'); | |
| INSERT INTO platformnames VALUES (134, 'CE04OSPS-SF01B', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', 'Profiler'); | |
| INSERT INTO platformnames VALUES (135, 'CE04OSPD', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (136, 'CE04OSPD-PD01B', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', 'Profiler Dock'); | |
| INSERT INTO platformnames VALUES (137, 'CE04OSPD-DP01B', 'Coastal', 'Endurance', 'OR Offshore', 'Profiler Mooring', 'Profiler'); | |
| INSERT INTO platformnames VALUES (138, 'CE04OSPI', 'Cabled', 'Endurance', 'OR Shelf', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (139, 'CE04OSPI-PN01D', 'Cabled', 'Endurance', 'OR Shelf', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (140, 'CE04OSSM', 'Coastal', 'Endurance', 'OR Offshore', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (141, 'CE04OSSM-SBD11', 'Coastal', 'Endurance', 'OR Offshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (142, 'CE04OSSM-SBD12', 'Coastal', 'Endurance', 'OR Offshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (143, 'CE04OSSM-RID26', 'Coastal', 'Endurance', 'OR Offshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (144, 'CE04OSSM-RID27', 'Coastal', 'Endurance', 'OR Offshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (146, 'CE06ISSM', 'Coastal', 'Endurance', 'WA Inshore', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (147, 'CE06ISSM-SBD17', 'Coastal', 'Endurance', 'WA Inshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (148, 'CE06ISSM-RID16', 'Coastal', 'Endurance', 'WA Inshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (149, 'CE06ISSM-MFD35', 'Coastal', 'Endurance', 'WA Inshore', 'Surface Mooring', 'MFN Base/Anchor'); | |
| INSERT INTO platformnames VALUES (150, 'CE06ISSM-MFD37', 'Coastal', 'Endurance', 'WA Inshore', 'Surface Mooring', 'MFN Base/Anchor'); | |
| INSERT INTO platformnames VALUES (151, 'CE06ISSM-MFD00', 'Coastal', 'Endurance', 'WA Inshore', 'Surface Mooring', 'MFN Base/Anchor'); | |
| INSERT INTO platformnames VALUES (152, 'CE06ISSP', 'Coastal', 'Endurance', 'WA Inshore', 'Surface-Piercing Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (153, 'CE06ISSP-SP001', 'Coastal', 'Endurance', 'WA Inshore', 'Surface-Piercing Profiler Mooring', 'Surface-Piercing Profiler'); | |
| INSERT INTO platformnames VALUES (154, 'CE07SHSM', 'Coastal', 'Endurance', 'WA Shelf', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (155, 'CE07SHSM-SBD11', 'Coastal', 'Endurance', 'WA Shelf', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (156, 'CE07SHSM-SBD12', 'Coastal', 'Endurance', 'WA Shelf', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (157, 'CE07SHSM-RID26', 'Coastal', 'Endurance', 'WA Shelf', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (158, 'CE07SHSM-RID27', 'Coastal', 'Endurance', 'WA Shelf', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (159, 'CE07SHSP', 'Coastal', 'Endurance', 'WA Shelf', 'Surface-Piercing Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (160, 'CE07SHSP-SP001', 'Coastal', 'Endurance', 'WA Shelf', 'Surface-Piercing Profiler Mooring', 'Surface-Piercing Profiler'); | |
| INSERT INTO platformnames VALUES (161, 'CE09OSPM', 'Coastal', 'Endurance', 'WA Offshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (162, 'CE09OSPM-WF001', 'Coastal', 'Endurance', 'WA Offshore', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (163, 'CE09OSSM', 'Coastal', 'Endurance', 'WA Offshore', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (164, 'CE09OSSM-SBD11', 'Coastal', 'Endurance', 'WA Offshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (165, 'CE09OSSM-SBD12', 'Coastal', 'Endurance', 'WA Offshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (166, 'CE09OSSM-RID26', 'Coastal', 'Endurance', 'WA Offshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (167, 'CE09OSSM-RID27', 'Coastal', 'Endurance', 'WA Offshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (168, 'CP01CNSM', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (169, 'CP01CNSM-SBD11', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (170, 'CP01CNSM-SBD12', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (171, 'CP01CNSM-RID26', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (172, 'CP01CNSM-RID27', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (173, 'CP01CNSM-MFD35', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (174, 'CP01CNSM-MFD37', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (175, 'CP01CNSM-MFD00', 'Coastal', 'Pioneer', 'Central', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (176, 'CP01CNSP', 'Coastal', 'Pioneer', 'Central', 'Surface-Piercing Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (177, 'CP01CNSP-SP001', 'Coastal', 'Pioneer', 'Central', 'Surface-Piercing Profiler Mooring', 'Surface-Piercing Profiler'); | |
| INSERT INTO platformnames VALUES (178, 'CP02PMCI', 'Coastal', 'Pioneer', 'Central Inshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (179, 'CP02PMCI-SBS01', 'Coastal', 'Pioneer', 'Central Inshore', 'Profiler Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (180, 'CP02PMCI-RII01', 'Coastal', 'Pioneer', 'Central Inshore', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (181, 'CP02PMCI-WFP01', 'Coastal', 'Pioneer', 'Central Inshore', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (182, 'CP02PMCO', 'Coastal', 'Pioneer', 'Central Offshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (183, 'CP02PMCO-SBS01', 'Coastal', 'Pioneer', 'Central Offshore', 'Profiler Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (321, 'CE05MOAS', 'Coastal', 'Pioneer', 'Mobile', '(Coastal)', 'Glider'); | |
| INSERT INTO platformnames VALUES (184, 'CP02PMCO-RII01', 'Coastal', 'Pioneer', 'Central Offshore', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (185, 'CP02PMCO-WFP01', 'Coastal', 'Pioneer', 'Central Offshore', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (186, 'CP02PMUI', 'Coastal', 'Pioneer', 'Upstream Inshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (187, 'CP02PMUI-SBS01', 'Coastal', 'Pioneer', 'Upstream Inshore', 'Profiler Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (188, 'CP02PMUI-RII01', 'Coastal', 'Pioneer', 'Upstream Inshore', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (189, 'CP02PMUI-WFP01', 'Coastal', 'Pioneer', 'Upstream Inshore', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (190, 'CP02PMUO', 'Coastal', 'Pioneer', 'Upstream Offshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (191, 'CP02PMUO-SBS01', 'Coastal', 'Pioneer', 'Upstream Offshore', 'Profiler Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (192, 'CP02PMUO-RII01', 'Coastal', 'Pioneer', 'Upstream Offshore', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (193, 'CP02PMUO-WFP01', 'Coastal', 'Pioneer', 'Upstream Offshore', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (194, 'CP03ISSM', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (195, 'CP03ISSM-SBD11', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (196, 'CP03ISSM-SBD12', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (197, 'CP03ISSM-RID26', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (198, 'CP03ISSM-RID27', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (199, 'CP03ISSM-MFD35', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (200, 'CP03ISSM-MFD37', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (201, 'CP03ISSM-MFD00', 'Coastal', 'Pioneer', 'Inshore', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (202, 'CP03ISSP', 'Coastal', 'Pioneer', 'Inshore', 'Surface-Piercing Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (203, 'CP03ISSP-SP001', 'Coastal', 'Pioneer', 'Inshore', 'Surface-Piercing Profiler Mooring', 'Surface-Piercing Profiler'); | |
| INSERT INTO platformnames VALUES (204, 'CP04OSPM', 'Coastal', 'Pioneer', 'Offshore', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (205, 'CP04OSPM-SBS11', 'Coastal', 'Pioneer', 'Offshore', 'Profiler Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (206, 'CP04OSPM-WFP01', 'Coastal', 'Pioneer', 'Offshore', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (207, 'CP04OSSM', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (208, 'CP04OSSM-SBD11', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (209, 'CP04OSSM-SBD12', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (210, 'CP04OSSM-RID26', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (211, 'CP04OSSM-RID27', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (212, 'CP04OSSM-MFD35', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (213, 'CP04OSSM-MFD37', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (322, 'CP05MOAS', 'Coastal', 'Pioneer', 'Mobile', '(Coastal)', 'Glider/AUV'); | |
| INSERT INTO platformnames VALUES (323, 'GA05MOAS', 'Global', 'Argentine Basin', 'Mobile', '(Open Ocean)', 'Glider'); | |
| INSERT INTO platformnames VALUES (324, 'GI05MOAS', 'Global', 'Irminger Sea', 'Mobile', '(Open Ocean)', 'Glider'); | |
| INSERT INTO platformnames VALUES (325, 'GP05MOAS', 'Global', 'Station Papa', 'Mobile', '(Open Ocean)', 'Glider'); | |
| INSERT INTO platformnames VALUES (326, 'GS05MOAS', 'Global', 'Southern Ocean', 'Mobile', '(Open Ocean)', 'Glider'); | |
| INSERT INTO platformnames VALUES (327, 'RS00ENGC-XX00X', 'Cabled', 'or', 'Testing', 'Platform', NULL); | |
| INSERT INTO platformnames VALUES (328, 'RS01BATH-XX00X', 'Cabled', 'Bathtub', 'Testing', 'Platform', NULL); | |
| INSERT INTO platformnames VALUES (214, 'CP04OSSM-MFD00', 'Coastal', 'Pioneer', 'Offshore', 'Surface Mooring', 'Multi-Function Node'); | |
| INSERT INTO platformnames VALUES (215, 'RS01HSPI', 'Cabled', 'Continental Margin', 'Slope Base', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (216, 'RS01HSPI-PN01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (217, 'RS01SBPS', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (218, 'RS01SBPS-LV01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (219, 'RS01SBPS-PC01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Interface Controller'); | |
| INSERT INTO platformnames VALUES (220, 'RS01SBPS-SC01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Profiler Controller'); | |
| INSERT INTO platformnames VALUES (221, 'RS01SBPS-SF01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Profiler'); | |
| INSERT INTO platformnames VALUES (222, 'RS01SBPS-LJ01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (223, 'RS01SBPD', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (224, 'RS01SBPD-PD01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Profiler Dock'); | |
| INSERT INTO platformnames VALUES (225, 'RS01SBPD-DP01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Profiler Mooring', 'Profiler'); | |
| INSERT INTO platformnames VALUES (226, 'RS01SLBS', 'Cabled', 'Continental Margin', 'Slope Base', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (227, 'RS01SLBS-MJ01A', 'Cabled', 'Continental Margin', 'Slope Base', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (228, 'RS01SUM1', 'Cabled', 'Continental Margin', 'Southern Hydrate Ridge Summit', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (229, 'RS01SUM1-LV01B', 'Cabled', 'Continental Margin', 'Southern Hydrate Ridge Summit', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (230, 'RS01SUM1-LJ01B', 'Cabled', 'Continental Margin', 'Southern Hydrate Ridge Summit', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (231, 'RS01SUM2', 'Cabled', 'Continental Margin', 'Southern Hydrate Ridge Summit', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (232, 'RS01SUM2-MJ01B', 'Cabled', 'Continental Margin', 'Southern Hydrate Ridge Summit', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (233, 'RS02HRPI', 'Cabled', 'Continental Margin', 'Hydrate Ridge', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (234, 'RS02HRPI-PN01B', 'Cabled', 'Continental Margin', 'Hydrate Ridge', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (235, 'RS03ABPI', 'Cabled', 'Axial Seamount', 'Axial Base', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (236, 'RS03ABPI-PN03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (237, 'RS03ASHS', 'Cabled', 'Axial Seamount', 'ASHES', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (238, 'RS03ASHS-MJ03B', 'Cabled', 'Axial Seamount', 'ASHES', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (239, 'RS03ASHS-ID03A', 'Cabled', 'Axial Seamount', 'ASHES', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (240, 'RS03AXBS', 'Cabled', 'Axial Seamount', 'Axial Base', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (241, 'RS03AXBS-MJ03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (242, 'RS03AXPS', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (243, 'RS03AXPS-LV03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (244, 'RS03AXPS-PC03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Interface Controller'); | |
| INSERT INTO platformnames VALUES (245, 'RS03AXPS-SC03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Profiler Controller'); | |
| INSERT INTO platformnames VALUES (246, 'RS03AXPS-SF03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Profiler'); | |
| INSERT INTO platformnames VALUES (247, 'RS03AXPS-LJ03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (248, 'RS03AXPD', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (249, 'RS03AXPD-PD03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Profiler Dock'); | |
| INSERT INTO platformnames VALUES (250, 'RS03AXPD-DP03A', 'Cabled', 'Axial Seamount', 'Axial Base', 'Profiler Mooring', 'Profiler'); | |
| INSERT INTO platformnames VALUES (251, 'RS03CCAL', 'Cabled', 'Axial Seamount', 'Central Caldera', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (252, 'RS03CCAL-MJ03F', 'Cabled', 'Axial Seamount', 'Central Caldera', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (253, 'RS03ECAL', 'Cabled', 'Axial Seamount', 'Eastern Caldera', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (254, 'RS03ECAL-MJ03E', 'Cabled', 'Axial Seamount', 'Eastern Caldera', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (255, 'RS03INT1', 'Cabled', 'Axial Seamount', 'International District', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (256, 'RS03INT1-MJ03C', 'Cabled', 'Axial Seamount', 'International District', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (257, 'RS03INT2', 'Cabled', 'Axial Seamount', 'International District', 'Junction Box', NULL); | |
| INSERT INTO platformnames VALUES (258, 'RS03INT2-MJ03D', 'Cabled', 'Axial Seamount', 'International District', 'Junction Box', 'Junction Box'); | |
| INSERT INTO platformnames VALUES (259, 'RS04ASPI', 'Cabled', 'Axial Seamount', 'Axial Summit', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (260, 'RS04ASPI-PN03B', 'Cabled', 'Axial Seamount', 'Axial Summit', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (261, 'RS05MPPI', 'Cabled', 'Mid Plate', 'Primary Infrastructure', 'Primary Node', NULL); | |
| INSERT INTO platformnames VALUES (262, 'RS05MPPI-PN05A', 'Cabled', 'Mid Plate', 'Primary Infrastructure', 'Primary Node', 'Primary Node'); | |
| INSERT INTO platformnames VALUES (263, 'GA01SUMO', 'Global', 'Argentine Basin', 'Apex', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (264, 'GA01SUMO-SBD11', 'Global', 'Argentine Basin', 'Apex', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (265, 'GA01SUMO-SBD12', 'Global', 'Argentine Basin', 'Apex', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (266, 'GA01SUMO-RID16', 'Global', 'Argentine Basin', 'Apex', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (267, 'GA01SUMO-RII11', 'Global', 'Argentine Basin', 'Apex', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (268, 'GA02HYPM', 'Global', 'Argentine Basin', 'Apex', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (269, 'GA02HYPM-MPC04', 'Global', 'Argentine Basin', 'Apex', 'Profiler Mooring', 'Submerged Buoy'); | |
| INSERT INTO platformnames VALUES (270, 'GA02HYPM-RIS01', 'Global', 'Argentine Basin', 'Apex', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (271, 'GA02HYPM-WFP02', 'Global', 'Argentine Basin', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (272, 'GA02HYPM-WFP03', 'Global', 'Argentine Basin', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (273, 'GA03FLMA', 'Global', 'Argentine Basin', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (274, 'GA03FLMA-RIS01', 'Global', 'Argentine Basin', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (275, 'GA03FLMA-RIS02', 'Global', 'Argentine Basin', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (276, 'GA03FLMB', 'Global', 'Argentine Basin', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (277, 'GA03FLMB-RIS01', 'Global', 'Argentine Basin', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (278, 'GA03FLMB-RIS02', 'Global', 'Argentine Basin', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (279, 'GI01SUMO', 'Global', 'Irminger Sea', 'Apex', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (280, 'GI01SUMO-SBD11', 'Global', 'Irminger Sea', 'Apex', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (281, 'GI01SUMO-SBD12', 'Global', 'Irminger Sea', 'Apex', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (282, 'GI01SUMO-RID16', 'Global', 'Irminger Sea', 'Apex', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (283, 'GI01SUMO-RII11', 'Global', 'Irminger Sea', 'Apex', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (284, 'GI02HYPM', 'Global', 'Irminger Sea', 'Apex', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (285, 'GI02HYPM-MPC04', 'Global', 'Irminger Sea', 'Apex', 'Profiler Mooring', 'Submerged Buoy'); | |
| INSERT INTO platformnames VALUES (286, 'GI02HYPM-RIS01', 'Global', 'Irminger Sea', 'Apex', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (287, 'GI02HYPM-WFP02', 'Global', 'Irminger Sea', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (288, 'GI03FLMA', 'Global', 'Irminger Sea', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (289, 'GI03FLMA-RIS01', 'Global', 'Irminger Sea', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (290, 'GI03FLMA-RIS02', 'Global', 'Irminger Sea', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (291, 'GI03FLMB', 'Global', 'Irminger Sea', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (292, 'GI03FLMB-RIS01', 'Global', 'Irminger Sea', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (293, 'GI03FLMB-RIS02', 'Global', 'Irminger Sea', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (294, 'GP02HYPM', 'Global', 'Station Papa', 'Apex', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (295, 'GP02HYPM-MPC04', 'Global', 'Station Papa', 'Apex', 'Profiler Mooring', 'Submerged Buoy'); | |
| INSERT INTO platformnames VALUES (296, 'GP02HYPM-RIS01', 'Global', 'Station Papa', 'Apex', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (297, 'GP02HYPM-WFP02', 'Global', 'Station Papa', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (298, 'GP02HYPM-WFP03', 'Global', 'Station Papa', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (299, 'GP03FLMA', 'Global', 'Station Papa', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (300, 'GP03FLMA-RIS01', 'Global', 'Station Papa', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (301, 'GP03FLMA-RIS02', 'Global', 'Station Papa', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (302, 'GP03FLMB', 'Global', 'Station Papa', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (303, 'GP03FLMB-RIS01', 'Global', 'Station Papa', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (304, 'GP03FLMB-RIS02', 'Global', 'Station Papa', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (305, 'GS01SUMO', 'Global', 'Southern Ocean', 'Apex', 'Surface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (306, 'GS01SUMO-SBD11', 'Global', 'Southern Ocean', 'Apex', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (307, 'GS01SUMO-SBD12', 'Global', 'Southern Ocean', 'Apex', 'Surface Mooring', 'Surface Buoy'); | |
| INSERT INTO platformnames VALUES (308, 'GS01SUMO-RID16', 'Global', 'Southern Ocean', 'Apex', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (309, 'GS01SUMO-RII11', 'Global', 'Southern Ocean', 'Apex', 'Surface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (310, 'GS02HYPM', 'Global', 'Southern Ocean', 'Apex', 'Profiler Mooring', NULL); | |
| INSERT INTO platformnames VALUES (311, 'GS02HYPM-MPC04', 'Global', 'Southern Ocean', 'Apex', 'Profiler Mooring', 'Submerged Buoy'); | |
| INSERT INTO platformnames VALUES (312, 'GS02HYPM-RIS01', 'Global', 'Southern Ocean', 'Apex', 'Profiler Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (313, 'GS02HYPM-WFP02', 'Global', 'Southern Ocean', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (314, 'GS02HYPM-WFP03', 'Global', 'Southern Ocean', 'Apex', 'Profiler Mooring', 'Wire-Following Profiler'); | |
| INSERT INTO platformnames VALUES (315, 'GS03FLMA', 'Global', 'Southern Ocean', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (316, 'GS03FLMA-RIS01', 'Global', 'Southern Ocean', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (317, 'GS03FLMA-RIS02', 'Global', 'Southern Ocean', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (318, 'GS03FLMB', 'Global', 'Southern Ocean', 'Flanking', 'Subsurface Mooring', NULL); | |
| INSERT INTO platformnames VALUES (319, 'GS03FLMB-RIS01', 'Global', 'Southern Ocean', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| INSERT INTO platformnames VALUES (320, 'GS03FLMB-RIS02', 'Global', 'Southern Ocean', 'Flanking', 'Subsurface Mooring', 'Mooring Riser'); | |
| -- | |
| -- Name: platformnames_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('platformnames_id_seq', 328, true); | |
| -- | |
| -- Data for Name: platforms; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| -- | |
| -- Name: platforms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('platforms_id_seq', 1, false); | |
| -- | |
| -- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| -- | |
| -- Data for Name: stream_parameters; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| -- | |
| -- Name: stream_parameters_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('stream_parameters_id_seq', 1, false); | |
| -- | |
| -- Data for Name: streams; Type: TABLE DATA; Schema: public; Owner: - | |
| -- | |
| -- | |
| -- Name: streams_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | |
| -- | |
| SELECT pg_catalog.setval('streams_id_seq', 1, false); | |
| -- | |
| -- Name: arrays_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY arrays | |
| ADD CONSTRAINT arrays_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: deployments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY deployments | |
| ADD CONSTRAINT deployments_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: instrument_deployments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY instrument_deployments | |
| ADD CONSTRAINT instrument_deployments_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: instrumentnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY instrumentnames | |
| ADD CONSTRAINT instrumentnames_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: instruments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY instruments | |
| ADD CONSTRAINT instruments_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: platform_deployments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY platform_deployments | |
| ADD CONSTRAINT platform_deployments_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: platformnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY platformnames | |
| ADD CONSTRAINT platformnames_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: platforms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY platforms | |
| ADD CONSTRAINT platforms_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: stream_parameters_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY stream_parameters | |
| ADD CONSTRAINT stream_parameters_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: streams_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY streams | |
| ADD CONSTRAINT streams_pkey PRIMARY KEY (id); | |
| -- | |
| -- Name: instrument_deployments_deployment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY instrument_deployments | |
| ADD CONSTRAINT instrument_deployments_deployment_id_fkey FOREIGN KEY (deployment_id) REFERENCES deployments(id); | |
| -- | |
| -- Name: instrument_deployments_instrument_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY instrument_deployments | |
| ADD CONSTRAINT instrument_deployments_instrument_id_fkey FOREIGN KEY (instrument_id) REFERENCES instruments(id); | |
| -- | |
| -- Name: instrument_deployments_platform_deployment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY instrument_deployments | |
| ADD CONSTRAINT instrument_deployments_platform_deployment_id_fkey FOREIGN KEY (platform_deployment_id) REFERENCES platform_deployments(id); | |
| -- | |
| -- Name: platform_deployments_array_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY platform_deployments | |
| ADD CONSTRAINT platform_deployments_array_id_fkey FOREIGN KEY (array_id) REFERENCES arrays(id); | |
| -- | |
| -- Name: platform_deployments_deployment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY platform_deployments | |
| ADD CONSTRAINT platform_deployments_deployment_id_fkey FOREIGN KEY (deployment_id) REFERENCES deployments(id); | |
| -- | |
| -- Name: platform_deployments_platform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY platform_deployments | |
| ADD CONSTRAINT platform_deployments_platform_id_fkey FOREIGN KEY (platform_id) REFERENCES platforms(id); | |
| -- | |
| -- Name: stream_parameters_stream_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY stream_parameters | |
| ADD CONSTRAINT stream_parameters_stream_id_fkey FOREIGN KEY (stream_id) REFERENCES streams(id); | |
| -- | |
| -- Name: streams_instrument_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| ALTER TABLE ONLY streams | |
| ADD CONSTRAINT streams_instrument_id_fkey FOREIGN KEY (instrument_id) REFERENCES instruments(id); | |
| -- | |
| -- Name: public; Type: ACL; Schema: -; Owner: - | |
| -- | |
| REVOKE ALL ON SCHEMA public FROM PUBLIC; | |
| REVOKE ALL ON SCHEMA public FROM luke; | |
| GRANT ALL ON SCHEMA public TO luke; | |
| GRANT ALL ON SCHEMA public TO PUBLIC; | |
| -- | |
| -- PostgreSQL database dump complete | |
| -- | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment