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

--

CREATE TABLE locationcoords (

    locationcoords_id int(11) NOT NULL,

    location_id int(11) NOT NULL,

    latitude_deg double precision,

    longitude_deg double precision,

    verbatimlatitude text,

    verbatimlongitude text,

    verbatimcoordinates text,

    footprintgeometry_dwc text,

    coordsaccuracy_deg double precision,

    identifier_id int(11),

    determinationdate date,

    isoriginal int(1) DEFAULT false NOT NULL,

    iscurrent int(1) DEFAULT false NOT NULL,

    calculated int(1)

);

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

ALTER TABLE locationcoords

    ADD CONSTRAINT locationcoords_pkey PRIMARY KEY (locationcoords_id);

--

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

--

--

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

--

--

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

--

ALTER TABLE locationcoords

    ADD CONSTRAINT locationcoords_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

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

--

CREATE TABLE locationcoords (

    locationcoords_id integer NOT NULL,

    location_id integer NOT NULL,

    latitude_deg double precision,

    longitude_deg double precision,

    verbatimlatitude text,

    verbatimlongitude text,

    verbatimcoordinates text,

    footprintgeometry_dwc text,

    coordsaccuracy_deg double precision,

    identifier_id integer,

    determinationdate date,

    isoriginal boolean DEFAULT false NOT NULL,

    iscurrent boolean DEFAULT false NOT NULL,

    calculated boolean

);

--

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

--

COMMENT ON COLUMN locationcoords.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 locationcoords.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN locationcoords.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: locationcoords_locationcoords_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE locationcoords_locationcoords_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationcoords_locationcoords_id_seq OWNED BY locationcoords.locationcoords_id;

--

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

--

ALTER TABLE locationcoords ALTER COLUMN locationcoords_id SET DEFAULT nextval('locationcoords_locationcoords_id_seq'::regclass);

--

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

--

ALTER TABLE ONLY locationcoords

    ADD CONSTRAINT locationcoords_pkey PRIMARY KEY (locationcoords_id);

--

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

--

CREATE UNIQUE INDEX locationcoords_unique ON locationcoords USING btree (location_id, (COALESCE(identifier_id, 2147483647)));

--

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

--

ALTER TABLE ONLY locationcoords

    ADD CONSTRAINT locationcoords_identifier_id_fkey FOREIGN KEY (identifier_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

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

--

ALTER TABLE ONLY locationcoords

    ADD CONSTRAINT locationcoords_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;

--