database.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 17.4
-- Dumped by pg_dump version 17.4

-- Started on 2025-09-09 11:10:48

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 7 (class 2615 OID 78758)
-- Name: bioprotect; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA bioprotect;


ALTER SCHEMA bioprotect OWNER TO postgres;

--
-- TOC entry 2 (class 3079 OID 78759)
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA bioprotect;


--
-- TOC entry 5913 (class 0 OID 0)
-- Dependencies: 2
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry and geography spatial types and functions';


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 225 (class 1259 OID 79847)
-- Name: drawingitems; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.drawingitems (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    color character varying(7) NOT NULL,
    description text,
    type character varying(20) NOT NULL
);


ALTER TABLE bioprotect.drawingitems OWNER TO postgres;

--
-- TOC entry 224 (class 1259 OID 79846)
-- Name: drawingitems_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.drawingitems_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.drawingitems_id_seq OWNER TO postgres;

--
-- TOC entry 5914 (class 0 OID 0)
-- Dependencies: 224
-- Name: drawingitems_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.drawingitems_id_seq OWNED BY bioprotect.drawingitems.id;


--
-- TOC entry 238 (class 1259 OID 86094)
-- Name: f_0180cf2e87f04e0bb787088fdb3e37; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.f_0180cf2e87f04e0bb787088fdb3e37 (
    euniscombd text,
    msfd_bbht text,
    unique_eun text,
    density numeric,
    geometry bioprotect.geometry,
    id integer NOT NULL
);


ALTER TABLE bioprotect.f_0180cf2e87f04e0bb787088fdb3e37 OWNER TO postgres;

--
-- TOC entry 239 (class 1259 OID 86100)
-- Name: f_0180cf2e87f04e0bb787088fdb3e37_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.f_0180cf2e87f04e0bb787088fdb3e37_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.f_0180cf2e87f04e0bb787088fdb3e37_id_seq OWNER TO postgres;

--
-- TOC entry 5915 (class 0 OID 0)
-- Dependencies: 239
-- Name: f_0180cf2e87f04e0bb787088fdb3e37_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.f_0180cf2e87f04e0bb787088fdb3e37_id_seq OWNED BY bioprotect.f_0180cf2e87f04e0bb787088fdb3e37.id;


--
-- TOC entry 236 (class 1259 OID 86077)
-- Name: f_5acb5ff68f12410e8997d3b7a3c123; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.f_5acb5ff68f12410e8997d3b7a3c123 (
    euniscombd text,
    msfd_bbht text,
    unique_eun text,
    density numeric,
    geometry bioprotect.geometry,
    id integer NOT NULL
);


ALTER TABLE bioprotect.f_5acb5ff68f12410e8997d3b7a3c123 OWNER TO postgres;

--
-- TOC entry 237 (class 1259 OID 86083)
-- Name: f_5acb5ff68f12410e8997d3b7a3c123_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.f_5acb5ff68f12410e8997d3b7a3c123_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.f_5acb5ff68f12410e8997d3b7a3c123_id_seq OWNER TO postgres;

--
-- TOC entry 5916 (class 0 OID 0)
-- Dependencies: 237
-- Name: f_5acb5ff68f12410e8997d3b7a3c123_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.f_5acb5ff68f12410e8997d3b7a3c123_id_seq OWNED BY bioprotect.f_5acb5ff68f12410e8997d3b7a3c123.id;


--
-- TOC entry 234 (class 1259 OID 86060)
-- Name: f_752dc8b4e0804d5299511d74552476; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.f_752dc8b4e0804d5299511d74552476 (
    euniscombd text,
    msfd_bbht text,
    unique_eun text,
    density numeric,
    geometry bioprotect.geometry,
    id integer NOT NULL
);


ALTER TABLE bioprotect.f_752dc8b4e0804d5299511d74552476 OWNER TO postgres;

--
-- TOC entry 235 (class 1259 OID 86066)
-- Name: f_752dc8b4e0804d5299511d74552476_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.f_752dc8b4e0804d5299511d74552476_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.f_752dc8b4e0804d5299511d74552476_id_seq OWNER TO postgres;

--
-- TOC entry 5917 (class 0 OID 0)
-- Dependencies: 235
-- Name: f_752dc8b4e0804d5299511d74552476_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.f_752dc8b4e0804d5299511d74552476_id_seq OWNED BY bioprotect.f_752dc8b4e0804d5299511d74552476.id;


--
-- TOC entry 230 (class 1259 OID 86026)
-- Name: f_82b2978fca7a45a9867edc061fb40c; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.f_82b2978fca7a45a9867edc061fb40c (
    euniscombd text,
    msfd_bbht text,
    unique_eun text,
    density numeric,
    geometry bioprotect.geometry,
    id integer NOT NULL
);


ALTER TABLE bioprotect.f_82b2978fca7a45a9867edc061fb40c OWNER TO postgres;

--
-- TOC entry 231 (class 1259 OID 86032)
-- Name: f_82b2978fca7a45a9867edc061fb40c_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.f_82b2978fca7a45a9867edc061fb40c_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.f_82b2978fca7a45a9867edc061fb40c_id_seq OWNER TO postgres;

--
-- TOC entry 5918 (class 0 OID 0)
-- Dependencies: 231
-- Name: f_82b2978fca7a45a9867edc061fb40c_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.f_82b2978fca7a45a9867edc061fb40c_id_seq OWNED BY bioprotect.f_82b2978fca7a45a9867edc061fb40c.id;


--
-- TOC entry 240 (class 1259 OID 86111)
-- Name: f_9f4a332f05804a328a75598d642f96; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.f_9f4a332f05804a328a75598d642f96 (
    euniscombd text,
    msfd_bbht text,
    unique_eun text,
    density numeric,
    geometry bioprotect.geometry,
    id integer NOT NULL
);


ALTER TABLE bioprotect.f_9f4a332f05804a328a75598d642f96 OWNER TO postgres;

--
-- TOC entry 241 (class 1259 OID 86117)
-- Name: f_9f4a332f05804a328a75598d642f96_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.f_9f4a332f05804a328a75598d642f96_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.f_9f4a332f05804a328a75598d642f96_id_seq OWNER TO postgres;

--
-- TOC entry 5919 (class 0 OID 0)
-- Dependencies: 241
-- Name: f_9f4a332f05804a328a75598d642f96_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.f_9f4a332f05804a328a75598d642f96_id_seq OWNED BY bioprotect.f_9f4a332f05804a328a75598d642f96.id;


--
-- TOC entry 232 (class 1259 OID 86043)
-- Name: f_facde20eef164f64bbfc07ad4871cd; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.f_facde20eef164f64bbfc07ad4871cd (
    euniscombd text,
    msfd_bbht text,
    unique_eun text,
    density numeric,
    geometry bioprotect.geometry,
    id integer NOT NULL
);


ALTER TABLE bioprotect.f_facde20eef164f64bbfc07ad4871cd OWNER TO postgres;

--
-- TOC entry 233 (class 1259 OID 86049)
-- Name: f_facde20eef164f64bbfc07ad4871cd_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.f_facde20eef164f64bbfc07ad4871cd_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.f_facde20eef164f64bbfc07ad4871cd_id_seq OWNER TO postgres;

--
-- TOC entry 5920 (class 0 OID 0)
-- Dependencies: 233
-- Name: f_facde20eef164f64bbfc07ad4871cd_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.f_facde20eef164f64bbfc07ad4871cd_id_seq OWNED BY bioprotect.f_facde20eef164f64bbfc07ad4871cd.id;


--
-- TOC entry 228 (class 1259 OID 85962)
-- Name: metadata_interest_features_unique_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.metadata_interest_features_unique_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.metadata_interest_features_unique_id_seq OWNER TO postgres;

--
-- TOC entry 229 (class 1259 OID 85963)
-- Name: metadata_interest_features; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.metadata_interest_features (
    unique_id integer DEFAULT nextval('bioprotect.metadata_interest_features_unique_id_seq'::regclass) NOT NULL,
    feature_class_name text,
    alias text,
    description text,
    creation_date timestamp without time zone,
    _area double precision,
    tilesetid text,
    extent bioprotect.box2d,
    source text,
    created_by text
);


ALTER TABLE bioprotect.metadata_interest_features OWNER TO postgres;

--
-- TOC entry 5921 (class 0 OID 0)
-- Dependencies: 229
-- Name: TABLE metadata_interest_features; Type: COMMENT; Schema: bioprotect; Owner: postgres
--

COMMENT ON TABLE bioprotect.metadata_interest_features IS 'Holds metadata information on the Marxan interest features';


--
-- TOC entry 5922 (class 0 OID 0)
-- Dependencies: 229
-- Name: COLUMN metadata_interest_features.feature_class_name; Type: COMMENT; Schema: bioprotect; Owner: postgres
--

COMMENT ON COLUMN bioprotect.metadata_interest_features.feature_class_name IS 'The name of the feature class that the spatial data is held in';


--
-- TOC entry 5923 (class 0 OID 0)
-- Dependencies: 229
-- Name: COLUMN metadata_interest_features.alias; Type: COMMENT; Schema: bioprotect; Owner: postgres
--

COMMENT ON COLUMN bioprotect.metadata_interest_features.alias IS 'An alias or display name for the data';


--
-- TOC entry 5924 (class 0 OID 0)
-- Dependencies: 229
-- Name: COLUMN metadata_interest_features.tilesetid; Type: COMMENT; Schema: bioprotect; Owner: postgres
--

COMMENT ON COLUMN bioprotect.metadata_interest_features.tilesetid IS 'Mapbox tilesetId if the feature class has been uploaded to Mapbox';


--
-- TOC entry 5925 (class 0 OID 0)
-- Dependencies: 229
-- Name: COLUMN metadata_interest_features.source; Type: COMMENT; Schema: bioprotect; Owner: postgres
--

COMMENT ON COLUMN bioprotect.metadata_interest_features.source IS 'How the feature was created';


--
-- TOC entry 227 (class 1259 OID 79869)
-- Name: users; Type: TABLE; Schema: bioprotect; Owner: postgres
--

CREATE TABLE bioprotect.users (
    id integer NOT NULL,
    username text NOT NULL,
    password text NOT NULL
);


ALTER TABLE bioprotect.users OWNER TO postgres;

--
-- TOC entry 226 (class 1259 OID 79868)
-- Name: users_id_seq; Type: SEQUENCE; Schema: bioprotect; Owner: postgres
--

CREATE SEQUENCE bioprotect.users_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE bioprotect.users_id_seq OWNER TO postgres;

--
-- TOC entry 5926 (class 0 OID 0)
-- Dependencies: 226
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: bioprotect; Owner: postgres
--

ALTER SEQUENCE bioprotect.users_id_seq OWNED BY bioprotect.users.id;


--
-- TOC entry 5695 (class 2604 OID 79850)
-- Name: drawingitems id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.drawingitems ALTER COLUMN id SET DEFAULT nextval('bioprotect.drawingitems_id_seq'::regclass);


--
-- TOC entry 5702 (class 2604 OID 86101)
-- Name: f_0180cf2e87f04e0bb787088fdb3e37 id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_0180cf2e87f04e0bb787088fdb3e37 ALTER COLUMN id SET DEFAULT nextval('bioprotect.f_0180cf2e87f04e0bb787088fdb3e37_id_seq'::regclass);


--
-- TOC entry 5701 (class 2604 OID 86084)
-- Name: f_5acb5ff68f12410e8997d3b7a3c123 id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_5acb5ff68f12410e8997d3b7a3c123 ALTER COLUMN id SET DEFAULT nextval('bioprotect.f_5acb5ff68f12410e8997d3b7a3c123_id_seq'::regclass);


--
-- TOC entry 5700 (class 2604 OID 86067)
-- Name: f_752dc8b4e0804d5299511d74552476 id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_752dc8b4e0804d5299511d74552476 ALTER COLUMN id SET DEFAULT nextval('bioprotect.f_752dc8b4e0804d5299511d74552476_id_seq'::regclass);


--
-- TOC entry 5698 (class 2604 OID 86033)
-- Name: f_82b2978fca7a45a9867edc061fb40c id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_82b2978fca7a45a9867edc061fb40c ALTER COLUMN id SET DEFAULT nextval('bioprotect.f_82b2978fca7a45a9867edc061fb40c_id_seq'::regclass);


--
-- TOC entry 5703 (class 2604 OID 86118)
-- Name: f_9f4a332f05804a328a75598d642f96 id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_9f4a332f05804a328a75598d642f96 ALTER COLUMN id SET DEFAULT nextval('bioprotect.f_9f4a332f05804a328a75598d642f96_id_seq'::regclass);


--
-- TOC entry 5699 (class 2604 OID 86050)
-- Name: f_facde20eef164f64bbfc07ad4871cd id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_facde20eef164f64bbfc07ad4871cd ALTER COLUMN id SET DEFAULT nextval('bioprotect.f_facde20eef164f64bbfc07ad4871cd_id_seq'::regclass);


--
-- TOC entry 5696 (class 2604 OID 79872)
-- Name: users id; Type: DEFAULT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.users ALTER COLUMN id SET DEFAULT nextval('bioprotect.users_id_seq'::regclass);


--
-- TOC entry 5891 (class 0 OID 79847)
-- Dependencies: 225
-- Data for Name: drawingitems; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.drawingitems (id, name, color, description, type) FROM stdin;
1	Coral Reef	#FF6666	A diverse underwater ecosystem found in warm ocean waters.	Features
2	Fresh Water	#8A2BE2	A habitat of rivers, lakes, and ponds that are low in salt content.	Features
3	Kelp Forest	#32CD32	A coastal underwater forest of giant kelp plants, home to many species.	Features
6	Overfishing	#FF4500	The depletion of fish species due to excessive fishing.	Activities
7	Pollution	#2E8B57	The introduction of harmful substances into the environment.	Activities
8	Rain	#4169E1	Precipitation in the form of water droplets falling from the sky.	Activities
9	Wind	#FFD700	The movement of air from high to low pressure areas.	Activities
13	Cultural and heritage sites	#365fb6	e.g. wrecks, sculptures, foundations etc.	Activities
15	Exploratory drilling	#6e5970	\N	Activities
16	Gas storage operations	#366846	carbon capture and natural gas storage	Activities
17	Line fishing	#9be537	\N	Activities
18	Physical Sampling	#05dab5	see also fishing and Extraction of genetic resources e.g. bioprospecting	Activities
19	Push nets	#e948ca	\N	Activities
20	Sea surface military activity	#82e628	\N	Activities
21	Seabed surface military activity	#0081af	\N	Activities
22	Set (fixed) net fishing	#558719	\N	Activities
23	Sonar	#0ca3d6	\N	Activities
24	Water column military activity	#9f334a	\N	Activities
25	Dredge and spoil disposal	#722231	\N	Activities
26	Oil and gas infrastructure: Construction	#f70c1e	see also piling and pipelines	Activities
27	Oil and gas infrastructure: Operation and maintenance	#adf7f0	\N	Activities
28	Oil spills including oil spill response	#d67aa5	\N	Activities
29	Purse Seining	#dc1878	\N	Activities
30	Salvage operations	#ed7057	\N	Activities
31	Sewage disposal	#519179	\N	Activities
35	Extraction of genetic resources	#2d5e42	e.g. bioprospecting (also see other related activities in fishing and dredging)	Activities
36	Harvesting - seaweed and other sea-based food	#176382	bird eggs, shellfish, etc.	Activities
37	Heat abstraction	#8fe8e6	\N	Activities
38	Marine archaeological research	#2d8d69	\N	Activities
39	Power station thermal and nuclear discharges	#e3e547	\N	Activities
40	Remote sensing	#79eb1e	\N	Activities
41	Seismic Surveys	#f18675	\N	Activities
42	Water abstraction	#1edba2	\N	Activities
45	Electrofishing	#641625	\N	Activities
46	Demersal trawling	#72f50e	\N	Activities
47	Traps	#f7bc21	\N	Activities
48	Pelagic fishing	#9d8492	or fishing activities that do not interact with sea bed	Activities
49	Strandline clearance	#d896e5	\N	Activities
50	Demersal seine netting	#bf9acb	\N	Activities
51	Tidal lagoon/impoundment: Operation and maintenance	#e219b8	\N	Activities
52	Hydraulic dredging	#b80393	\N	Activities
53	Wildfowling	#17d85d	\N	Activities
54	Dredging (shellfish)	#3e12c9	\N	Activities
55	Powerboating or sailing with an engine: Mooring and/or anchoring	#f71f2f	\N	Activities
56	Sand raking	#b5d1b9	\N	Activities
57	Diving	#b87d3b	incl. removal of living resources	Activities
58	Powerboating or sailing with an engine: Launching and recovery, participation	#abdfeb	\N	Activities
59	Horse riding and dog walking	#eb7320	\N	Activities
60	Non-motorised land craft	#2ff3ed	e.g. sand yachting, kite buggying	Activities
61	Non-motorised water craft	#1a905b	e.g. kayaks, windsurfing, dinghies	Activities
62	Leisure	#43defa	e.g. swimming, rock pooling	Activities
63	Herbicide spraying and vegetation removal	#120e62	\N	Activities
64	Sailing without an engine: Launching and recovery, participation	#5d6119	\N	Activities
65	Sailing without an engine: Mooring and/or anchoring	#d6a9d7	\N	Activities
66	Firework displays	#8cddae	\N	Activities
67	Light aircraft	#2f45f3	\N	Activities
68	Hovercraft	#2acb69	\N	Activities
70	test	#956f53	test	Activities
71	testing	#e2390b	ts	Features
\.


--
-- TOC entry 5904 (class 0 OID 86094)
-- Dependencies: 238
-- Data for Name: f_0180cf2e87f04e0bb787088fdb3e37; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.f_0180cf2e87f04e0bb787088fdb3e37 (euniscombd, msfd_bbht, unique_eun, density, geometry, id) FROM stdin;
\N	\N	\N	0	0103000020E610000001000000140000007E29239F327531BF000034EF382C403F7E29239F327531BF000034EF382C403F7C558AD9F9E731BF0000C47B7D2D403FDE17B96EBA8F32BF000098696A28403F40DAE7037B3733BF0000C8AE3D1E403FDBF5561EE4F033BF0000708EF005403FB7BB4A33EFF034BF00002069C0BB3F3FBDA2C2454C5F35BF0000401E759C3F3FC5F306BB459435BF0000F891A27F3F3F94EB0AAB96B735BF0000B885AE623F3F94EB0AAB96B735BF0000146430503F3F53D7B94D58AA35BF0000A89CA43D3F3FC8C79F807E2135BF000088FD54003F3FEB97DF08D75A34BF00009C4D09D83E3F801AA09B80B733BF00003CDD71C23E3F287D4E41F2D132BF0000403D09BD3E3F9B0368117C8232BF000030B9BDBF3E3F513406DCA77932BF000030B9BDBF3E3F513406DCA77932BF000030B9BDBF3E3F7E29239F327531BF000034EF382C403F	1
\.


--
-- TOC entry 5902 (class 0 OID 86077)
-- Dependencies: 236
-- Data for Name: f_5acb5ff68f12410e8997d3b7a3c123; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.f_5acb5ff68f12410e8997d3b7a3c123 (euniscombd, msfd_bbht, unique_eun, density, geometry, id) FROM stdin;
\N	\N	\N	0	0103000020E61000000100000012000000122D3553B66335BF0000C05F4653413F122D3553B66335BF0000C05F4653413F5B92CA25EEA535BF00008A9B6A54413F2165F1DA0C0736BF00008A9B6A54413F3AC28A9D956C36BF0000C05F4653413FB8169492D9F936BF00009235454B413FC367D807D32E37BF0000BECA6344413F1E438F8A366837BF0000FE86BA37413FD10961F2C59837BF00007E8E0E16413FE47F82A2F18F37BF0000287BC6F2403F1E438F8A366837BF00005E0BCED9403F8A7864E5C6E336BF00003253BDB5403F6860BA4AA88236BF00007E9018A1403F59BE3160B51836BF0000DCF6E194403FCEAE1793DB8F35BF00003E613591403F7C8E71E80D5235BF0000DCF6E194403F4CF0413BFB3B35BF000020585497403F122D3553B66335BF0000C05F4653413F	1
\.


--
-- TOC entry 5900 (class 0 OID 86060)
-- Dependencies: 234
-- Data for Name: f_752dc8b4e0804d5299511d74552476; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.f_752dc8b4e0804d5299511d74552476 (euniscombd, msfd_bbht, unique_eun, density, geometry, id) FROM stdin;
\N	\N	\N	1	0103000020E61000000100000013000000F53B6B947F8820BF00005A15D0C1403FF53B6B947F8820BF00005A15D0C1403F9057DAAEE84121BF0000A0B3A0C6403FEF3C4CF3958822BF0000A0B3A0C6403FBF8F9942D1B424BF0000DC8F51B3403F94B67F57456E26BF0000568FA893403FB9773CDCEBE927BF00008AFAED6F403F1CECA1E60E8029BF0000C4B8A93C403F21694D96CF272ABF000098696A28403F1644705B9D652ABF0000668E7911403F996C12161A802ABF0000D41667EA3F3F0EF32BE6A3302ABF0000180A8DC33F3F159B5D71154B29BF0000F4179C943F3F52EA980CCD8827BF000070607A553F3F81405EA7197726BF0000E03AFD3A3F3F8CE88F328B9125BF0000E03AFD3A3F3F72F5C2D29EF224BF0000E03AFD3A3F3FF0CC201822D824BF0000BC0799453F3FF53B6B947F8820BF00005A15D0C1403F	1
\.


--
-- TOC entry 5896 (class 0 OID 86026)
-- Dependencies: 230
-- Data for Name: f_82b2978fca7a45a9867edc061fb40c; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.f_82b2978fca7a45a9867edc061fb40c (euniscombd, msfd_bbht, unique_eun, density, geometry, id) FROM stdin;
\N	\N	\N	0	0103000020E6100000010000001200000093485739E68632BF0000B82C80DF423F32385F1988CD32BF0000B62E5AE3423FEB4F75F6103333BF0000068346E5423F866BE4107AEC33BF000070799BDC423F24F11F8E7F6C34BF000044F205D0423FAF6A06BEF5BB34BF0000860663C2423F86B34E23401435BF000008D7C7AC423F0ADCF0DDBC2E35BF00007EFBE0A3423F44353163654035BF00004801F694423FBE0C8FA8E82535BF0000BE36CE75423FC1765B0B85EC34BF00002C752E55423F2C42640379A134BF0000C8049641423FCBE901D154C033BF000084A89728423F371FD72BE53B33BF0000C2F15923423F1EC23D695CD632BF0000B6866624423F9B0368117C8232BF00009C81AF2A423F18DBC556FF6732BF0000F0ED4839423F93485739E68632BF0000B82C80DF423F	1
\.


--
-- TOC entry 5906 (class 0 OID 86111)
-- Dependencies: 240
-- Data for Name: f_9f4a332f05804a328a75598d642f96; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.f_9f4a332f05804a328a75598d642f96 (euniscombd, msfd_bbht, unique_eun, density, geometry, id) FROM stdin;
\N	\N	\N	38	0103000020E6100000010000001600000015D2A13D759123BF000022E06EB1413F6E4CB0E816D823BF00004CA9EDB6413F789DF45D100D24BF0000F0851FB9413FD031222DC41E25BF000058B381BD413FC4C79FF2CE1E26BF000058B381BD413FADA94CB7310D27BF0000F0851FB9413F586744BC8D3028BF0000202F07AD413FEC316F61FDB428BF0000B49416A3413F0F4A19FC1B1629BF0000B6A4BD8B413F874DDE7B666E29BF00008A9B6A54413F159B5D71154B29BF00001C15F431413FF282B3D6F6E928BF00007C83E41B413F45F1220C623928BF0000FA28A605413FD8123BC749A327BF0000006C68FD403F32D2EE71AE2727BF0000B0F7AFF8403F0118BCEC9C5C26BF0000B0F7AFF8403F1662766201E125BF000028710CFB403F2CAC30D8656525BF000028710CFB403F4D098072470425BF0000487F3AFC403FF0CC201822D824BF0000403096FE403F14B9637879C624BF0000403096FE403F15D2A13D759123BF000022E06EB1413F	1
\.


--
-- TOC entry 5898 (class 0 OID 86043)
-- Dependencies: 232
-- Data for Name: f_facde20eef164f64bbfc07ad4871cd; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.f_facde20eef164f64bbfc07ad4871cd (euniscombd, msfd_bbht, unique_eun, density, geometry, id) FROM stdin;
\N	\N	\N	0	0103000020E610000001000000140000006CBF5F6555AC2CBF000006A99F8A413FA89E6F2599392DBF00000C006F92413FB840F80F8CA32DBF000070BAE296413FCC5F2CAA3FB52EBF0000348A709C413FD46B2B9AD65130BF00000221A994413F1C67F40972CD30BF0000B8E64487413F6462BD790D4931BF000006A14D75413F00E8F8F612C931BF000074CB875D413F0A393D6C0CFE31BF0000CC8CFD50413FD830415C5D2132BF0000F4B08945413FCF753084C72532BF000090767B2E413F84109BB18FE331BF0000785DE314413FAEC7524C458B31BF000028710CFB403FD19792D49DC430BF00006EBDFFDA403F047427AA852E30BF00000A5A6ED1403FD1DCD759005D2FBF00000A5A6ED1403F545C672AF55C2EBF000076309CD8403F1ECE9BDFAA042EBF0000124427E2403FAC1B1BD559E12DBF000006114AE9403F6CBF5F6555AC2CBF000006A99F8A413F	1
\.


--
-- TOC entry 5895 (class 0 OID 85963)
-- Dependencies: 229
-- Data for Name: metadata_interest_features; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.metadata_interest_features (unique_id, feature_class_name, alias, description, creation_date, _area, tilesetid, extent, source, created_by) FROM stdin;
4	f_82b2978fca7a45a9867edc061fb40c	Coral Reef		2025-08-26 13:59:31.92636	9.816059476463526	bioprotect.f_82b2978fca7a45a9867edc061fb40c	BOX(-0.000324272873688 0.000553530614994,-0.00028085693227 0.000576648168177)	testing	test
5	f_facde20eef164f64bbfc07ad4871cd	Coral Reef		2025-08-26 13:59:59.888212	12.553433895654265	bioprotect.f_facde20eef164f64bbfc07ad4871cd	BOX(-0.000276910028505 0.000513247378038,-0.000218758987728 0.000537447882749)	testing	test
6	f_752dc8b4e0804d5299511d74552476	Coral Reef	testing	2025-08-26 13:59:59.967242	18.7236706417118	bioprotect.f_752dc8b4e0804d5299511d74552476	BOX(-0.000202181991914 0.000476538490034,-0.000126138280584 0.000511959521873)	testing	test
7	f_5acb5ff68f12410e8997d3b7a3c123	Fresh Water		2025-08-26 14:00:00.228641	8.22543998842989	bioprotect.f_5acb5ff68f12410e8997d3b7a3c123	BOX(-0.000360058142523 0.000505591453916,-0.00032400973874 0.000528862051468)	testing	test
8	f_0180cf2e87f04e0bb787088fdb3e37	Fresh Water		2025-08-26 14:00:00.305277	12.56150836927454	bioprotect.f_0180cf2e87f04e0bb787088fdb3e37	BOX(-0.000331377300465 0.00046903110092,-0.000266384943768 0.000493704100819)	testing	test
9	f_9f4a332f05804a328a75598d642f96	Fresh Water		2025-08-26 14:00:00.561776	10.255086142177522	bioprotect.f_9f4a332f05804a328a75598d642f96	BOX(-0.000194025049436 0.000517927095075,-0.00014929348146 0.000541389780381)	testing	test
\.


--
-- TOC entry 5694 (class 0 OID 79081)
-- Dependencies: 220
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) FROM stdin;
\.


--
-- TOC entry 5893 (class 0 OID 79869)
-- Dependencies: 227
-- Data for Name: users; Type: TABLE DATA; Schema: bioprotect; Owner: postgres
--

COPY bioprotect.users (id, username, password) FROM stdin;
2	test	$2b$12$DwyKqr.5ZDebn7tRFEmJnOoZg2qQLfGv.Auv3QjWtWG2Es85AzdN.
\.


--
-- TOC entry 5927 (class 0 OID 0)
-- Dependencies: 224
-- Name: drawingitems_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.drawingitems_id_seq', 71, true);


--
-- TOC entry 5928 (class 0 OID 0)
-- Dependencies: 239
-- Name: f_0180cf2e87f04e0bb787088fdb3e37_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.f_0180cf2e87f04e0bb787088fdb3e37_id_seq', 1, true);


--
-- TOC entry 5929 (class 0 OID 0)
-- Dependencies: 237
-- Name: f_5acb5ff68f12410e8997d3b7a3c123_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.f_5acb5ff68f12410e8997d3b7a3c123_id_seq', 1, true);


--
-- TOC entry 5930 (class 0 OID 0)
-- Dependencies: 235
-- Name: f_752dc8b4e0804d5299511d74552476_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.f_752dc8b4e0804d5299511d74552476_id_seq', 1, true);


--
-- TOC entry 5931 (class 0 OID 0)
-- Dependencies: 231
-- Name: f_82b2978fca7a45a9867edc061fb40c_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.f_82b2978fca7a45a9867edc061fb40c_id_seq', 1, true);


--
-- TOC entry 5932 (class 0 OID 0)
-- Dependencies: 241
-- Name: f_9f4a332f05804a328a75598d642f96_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.f_9f4a332f05804a328a75598d642f96_id_seq', 1, true);


--
-- TOC entry 5933 (class 0 OID 0)
-- Dependencies: 233
-- Name: f_facde20eef164f64bbfc07ad4871cd_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.f_facde20eef164f64bbfc07ad4871cd_id_seq', 1, true);


--
-- TOC entry 5934 (class 0 OID 0)
-- Dependencies: 228
-- Name: metadata_interest_features_unique_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.metadata_interest_features_unique_id_seq', 9, true);


--
-- TOC entry 5935 (class 0 OID 0)
-- Dependencies: 226
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: bioprotect; Owner: postgres
--

SELECT pg_catalog.setval('bioprotect.users_id_seq', 2, true);


--
-- TOC entry 5708 (class 2606 OID 79858)
-- Name: drawingitems drawingitems_color_key; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.drawingitems
    ADD CONSTRAINT drawingitems_color_key UNIQUE (color);


--
-- TOC entry 5710 (class 2606 OID 79856)
-- Name: drawingitems drawingitems_name_key; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.drawingitems
    ADD CONSTRAINT drawingitems_name_key UNIQUE (name);


--
-- TOC entry 5712 (class 2606 OID 79854)
-- Name: drawingitems drawingitems_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.drawingitems
    ADD CONSTRAINT drawingitems_pkey PRIMARY KEY (id);


--
-- TOC entry 5735 (class 2606 OID 86103)
-- Name: f_0180cf2e87f04e0bb787088fdb3e37 f_0180cf2e87f04e0bb787088fdb3e37_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_0180cf2e87f04e0bb787088fdb3e37
    ADD CONSTRAINT f_0180cf2e87f04e0bb787088fdb3e37_pkey PRIMARY KEY (id);


--
-- TOC entry 5732 (class 2606 OID 86086)
-- Name: f_5acb5ff68f12410e8997d3b7a3c123 f_5acb5ff68f12410e8997d3b7a3c123_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_5acb5ff68f12410e8997d3b7a3c123
    ADD CONSTRAINT f_5acb5ff68f12410e8997d3b7a3c123_pkey PRIMARY KEY (id);


--
-- TOC entry 5729 (class 2606 OID 86069)
-- Name: f_752dc8b4e0804d5299511d74552476 f_752dc8b4e0804d5299511d74552476_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_752dc8b4e0804d5299511d74552476
    ADD CONSTRAINT f_752dc8b4e0804d5299511d74552476_pkey PRIMARY KEY (id);


--
-- TOC entry 5723 (class 2606 OID 86035)
-- Name: f_82b2978fca7a45a9867edc061fb40c f_82b2978fca7a45a9867edc061fb40c_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_82b2978fca7a45a9867edc061fb40c
    ADD CONSTRAINT f_82b2978fca7a45a9867edc061fb40c_pkey PRIMARY KEY (id);


--
-- TOC entry 5738 (class 2606 OID 86120)
-- Name: f_9f4a332f05804a328a75598d642f96 f_9f4a332f05804a328a75598d642f96_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_9f4a332f05804a328a75598d642f96
    ADD CONSTRAINT f_9f4a332f05804a328a75598d642f96_pkey PRIMARY KEY (id);


--
-- TOC entry 5726 (class 2606 OID 86052)
-- Name: f_facde20eef164f64bbfc07ad4871cd f_facde20eef164f64bbfc07ad4871cd_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.f_facde20eef164f64bbfc07ad4871cd
    ADD CONSTRAINT f_facde20eef164f64bbfc07ad4871cd_pkey PRIMARY KEY (id);


--
-- TOC entry 5718 (class 2606 OID 85972)
-- Name: metadata_interest_features metadata_interest_features_fcn_unique_key; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.metadata_interest_features
    ADD CONSTRAINT metadata_interest_features_fcn_unique_key UNIQUE (feature_class_name);


--
-- TOC entry 5720 (class 2606 OID 85970)
-- Name: metadata_interest_features metadata_interest_features_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.metadata_interest_features
    ADD CONSTRAINT metadata_interest_features_pkey PRIMARY KEY (unique_id);


--
-- TOC entry 5714 (class 2606 OID 79876)
-- Name: users users_pkey; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- TOC entry 5716 (class 2606 OID 79878)
-- Name: users users_username_key; Type: CONSTRAINT; Schema: bioprotect; Owner: postgres
--

ALTER TABLE ONLY bioprotect.users
    ADD CONSTRAINT users_username_key UNIQUE (username);


--
-- TOC entry 5727 (class 1259 OID 86048)
-- Name: idx_1e14fa35d7514fe18646eabfd55059b7; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX idx_1e14fa35d7514fe18646eabfd55059b7 ON bioprotect.f_facde20eef164f64bbfc07ad4871cd USING gist (geometry);


--
-- TOC entry 5730 (class 1259 OID 86065)
-- Name: idx_47400f17781046958df006e613ba0032; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX idx_47400f17781046958df006e613ba0032 ON bioprotect.f_752dc8b4e0804d5299511d74552476 USING gist (geometry);


--
-- TOC entry 5724 (class 1259 OID 86031)
-- Name: idx_939e7f0a637a4e19b947127cb47cd701; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX idx_939e7f0a637a4e19b947127cb47cd701 ON bioprotect.f_82b2978fca7a45a9867edc061fb40c USING gist (geometry);


--
-- TOC entry 5733 (class 1259 OID 86082)
-- Name: idx_c67d2f6a25dc4b7195d074a5206728b4; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX idx_c67d2f6a25dc4b7195d074a5206728b4 ON bioprotect.f_5acb5ff68f12410e8997d3b7a3c123 USING gist (geometry);


--
-- TOC entry 5736 (class 1259 OID 86099)
-- Name: idx_cf578743f7cd443bb8a36d89f3320d9f; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX idx_cf578743f7cd443bb8a36d89f3320d9f ON bioprotect.f_0180cf2e87f04e0bb787088fdb3e37 USING gist (geometry);


--
-- TOC entry 5739 (class 1259 OID 86116)
-- Name: idx_e1cbb1abb7274da9ae4662895d9cd447; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX idx_e1cbb1abb7274da9ae4662895d9cd447 ON bioprotect.f_9f4a332f05804a328a75598d642f96 USING gist (geometry);


--
-- TOC entry 5721 (class 1259 OID 85973)
-- Name: mif_01; Type: INDEX; Schema: bioprotect; Owner: postgres
--

CREATE INDEX mif_01 ON bioprotect.metadata_interest_features USING btree (feature_class_name);


-- Completed on 2025-09-09 11:10:49

--
-- PostgreSQL database dump complete
--