-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE coordinates (

    coordinates_id int(11) NOT NULL,

    creator_id int(11) NOT NULL,

    latitude_deg double precision NOT NULL,

    longitude_deg double precision NOT NULL,

    verbatimlatitude text,

    verbatimlongitude text,

    verbatimcoordinates text,

    footprintgeometry_dwc text,

    coordsaccuracy_deg double precision

);

--

-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE coordinates

    ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id);

--

-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: coordinates_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

--

-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE coordinates (

    coordinates_id integer NOT NULL,

    creator_id integer NOT NULL,

    latitude_deg double precision NOT NULL,

    longitude_deg double precision NOT NULL,

    verbatimlatitude text,

    verbatimlongitude text,

    verbatimcoordinates text,

    footprintgeometry_dwc text,

    coordsaccuracy_deg double precision

);

--

-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN coordinates.footprintgeometry_dwc IS 'DwC''s footprintWKT field. "A Well-Known Text (WKT) representation of the shape (footprint, geometry) that defines the Location" (http://rs.tdwg.org/dwc/terms/#footprintWKT).';

--

-- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN coordinates.coordsaccuracy_deg IS 'Accuracy of latitude/longitude or footprint geometry, in meters. This should generally be at least 1 m, which is the accuracy of the best GPSes.';

--

-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE coordinates_coordinates_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE coordinates_coordinates_id_seq OWNED BY coordinates.coordinates_id;

--

-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -

--

ALTER TABLE coordinates ALTER COLUMN coordinates_id SET DEFAULT nextval('coordinates_coordinates_id_seq'::regclass);

--

-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY coordinates

    ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id);

--

-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (creator_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\\N'::text)), (COALESCE(verbatimlongitude, '\\N'::text)), (COALESCE(verbatimcoordinates, '\\N'::text)), (COALESCE(footprintgeometry_dwc, '\\N'::text)));

--

-- Name: coordinates_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY coordinates

    ADD CONSTRAINT coordinates_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;

--