locationevent_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    location_id integer NOT NULL,

    locationevent_id integer NOT NULL,

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

--

CREATE TABLE location (

    location_id integer NOT NULL,

    sourceid character varying(30),

    reference_id integer,

    parent_id integer,

    reallatitude double precision,

    reallongitude double precision,

    locationaccuracy double precision,

    confidentialitystatus integer NOT NULL,

    confidentialityreason character varying(200),

    latitude double precision,

    longitude double precision,

    authore character varying(20),

    authorn character varying(20),

    authorzone character varying(20),

    authordatum character varying(20),

    authorlocation character varying(200),

    locationnarrative text,

    azimuth double precision,

    dsgpoly text,

    shape character varying(50),

    area double precision,

    standsize character varying(50),

    placementmethod character varying(50),

    permanence boolean,

    layoutnarrative text,

    elevation double precision,

    elevationaccuracy double precision,

    elevationrange double precision,

    slopeaspect double precision,

    minslopeaspect double precision,

    maxslopeaspect double precision,

    slopegradient double precision,

    minslopegradient double precision,

    maxslopegradient double precision,

    topoposition character varying(90),

    landform character varying(50),

    surficialdeposits character varying(90),

    rocktype character varying(90),

    stateprovince character varying(55),

    country character varying(100),

    submitter_surname character varying(100),

    submitter_givenname character varying(100),

    submitter_email character varying(100),

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    dateentered timestamp with time zone DEFAULT now(),

    emb_location integer,

    locationrationalenarrative text,

    accessioncode character varying(255),

    sublocationxposition double precision,

    sublocationyposition double precision,

    namedplace_id integer

);

--

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

--

CREATE SEQUENCE location_location_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE location_location_id_seq OWNED BY location.location_id;

--

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

--

CREATE TABLE locationevent (

    locationevent_id integer NOT NULL,

    previous_id integer,

    location_id integer NOT NULL,

    project_id integer,

    sourceid character varying(30),

    dateaccuracy character varying(30),

    covermethod_id integer,

    coverdispersion character varying(30),

    autotaxoncover boolean,

    stratummethod_id integer,

    methodnarrative text,

    taxonoccurrencearea double precision,

    stemsizelimit double precision,

    stemarea double precision,

    stemsamplemethod character varying(30),

    originaldata text,

    effortlevel character varying(30),

    locationvalidationlevel integer,

    floristicquality character varying(30),

    bryophytequality character varying(30),

    lichenquality character varying(30),

    locationeventnarrative text,

    landscapenarrative text,

    homogeneity character varying(50),

    phenologicaspect character varying(30),

    representativeness character varying(255),

    standmaturity character varying(50),

    successionalstatus text,

    basalarea double precision,

    hydrologicregime character varying(30),

    soilmoistureregime character varying(30),

    soildrainage character varying(30),

    watersalinity character varying(30),

    waterdepth double precision,

    shoredistance double precision,

    soildepth double precision,

    organicdepth double precision,

    soiltaxon_id integer,

    soiltaxonsrc character varying(200),

    percentbedrock double precision,

    percentrockgravel double precision,

    percentwood double precision,

    percentlitter double precision,

    percentbaresoil double precision,

    percentwater double precision,

    percentother double precision,

    nameother character varying(30),

    treeht double precision,

    shrubht double precision,

    fieldht double precision,

    nonvascularht double precision,

    submergedht double precision,

    treecover double precision,

    shrubcover double precision,

    fieldcover double precision,

    nonvascularcover double precision,

    floatingcover double precision,

    submergedcover double precision,

    dominantstratum character varying(40),

    growthform1type character varying(40),

    growthform2type character varying(40),

    growthform3type character varying(40),

    growthform1cover double precision,

    growthform2cover double precision,

    growthform3cover double precision,

    totalcover double precision,

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    obsstartdate timestamp with time zone,

    obsenddate timestamp with time zone,

    dateentered timestamp with time zone DEFAULT now(),

    emb_locationevent integer,

    interp_orig_ci_id integer,

    interp_orig_cc_id integer,

    interp_orig_sciname text,

    interp_orig_code text,

    interp_orig_party_id integer,

    interp_orig_partyname text,

    interp_current_ci_id integer,

    interp_current_cc_id integer,

    interp_current_sciname text,

    interp_current_code text,

    interp_current_party_id integer,

    interp_current_partyname text,

    interp_bestfit_ci_id integer,

    interp_bestfit_cc_id integer,

    interp_bestfit_sciname text,

    interp_bestfit_code text,

    interp_bestfit_party_id integer,

    interp_bestfit_partyname text,

    toptaxon1name character varying(255),

    toptaxon2name character varying(255),

    toptaxon3name character varying(255),

    toptaxon4name character varying(255),

    toptaxon5name character varying(255),

    numberoftaxa integer,

    accessioncode character varying(255)

);

--

-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON TABLE locationevent IS 'VegBank''s observation table.';

--

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

--

CREATE SEQUENCE locationevent_locationevent_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationevent_locationevent_id_seq OWNED BY locationevent.locationevent_id;

--

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

--

CREATE TABLE locationeventcontributor (

    locationeventcontributor_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    contributiondate timestamp with time zone

);

--

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

--

CREATE SEQUENCE locationeventcontributor_locationeventcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationeventcontributor_locationeventcontributor_id_seq OWNED BY locationeventcontributor.locationeventcontributor_id;

--

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

--

CREATE TABLE locationeventsynonym (

    locationeventsynonym_id integer NOT NULL,

    synonymlocationevent_id integer NOT NULL,

    primarylocationevent_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    synonymcomment text,

    classstartdate timestamp with time zone DEFAULT now() NOT NULL,

    classstopdate timestamp with time zone,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE locationeventsynonym_locationeventsynonym_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationeventsynonym_locationeventsynonym_id_seq OWNED BY locationeventsynonym.locationeventsynonym_id;

--

    locationplace_id integer NOT NULL,

    location_id integer NOT NULL,

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

CREATE SEQUENCE place_locationplace_id_seq

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

ALTER SEQUENCE place_locationplace_id_seq OWNED BY place.locationplace_id;

    d_lastlocationaddeddate timestamp with time zone,

    locationevent_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    locationevent_id integer NOT NULL,

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

--

ALTER TABLE location ALTER COLUMN location_id SET DEFAULT nextval('location_location_id_seq'::regclass);

--

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

--

ALTER TABLE locationevent ALTER COLUMN locationevent_id SET DEFAULT nextval('locationevent_locationevent_id_seq'::regclass);

--

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

--

ALTER TABLE locationeventcontributor ALTER COLUMN locationeventcontributor_id SET DEFAULT nextval('locationeventcontributor_locationeventcontributor_id_seq'::regclass);

--

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

--

ALTER TABLE locationeventsynonym ALTER COLUMN locationeventsynonym_id SET DEFAULT nextval('locationeventsynonym_locationeventsynonym_id_seq'::regclass);

--

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

ALTER TABLE place ALTER COLUMN locationplace_id SET DEFAULT nextval('place_locationplace_id_seq'::regclass);

    ADD CONSTRAINT commclass_keys UNIQUE (locationevent_id, classnotes);

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

--

ALTER TABLE ONLY location

    ADD CONSTRAINT location_keys UNIQUE (reference_id, parent_id, sourceid);

--

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

--

ALTER TABLE ONLY location

    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);

--

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

--

ALTER TABLE ONLY locationevent

    ADD CONSTRAINT locationevent_keys UNIQUE (location_id, project_id, sourceid);

--

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

--

ALTER TABLE ONLY locationevent

    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);

--

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

--

ALTER TABLE ONLY locationeventcontributor

    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);

--

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

--

ALTER TABLE ONLY locationeventsynonym

    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);

--

    ADD CONSTRAINT place_keys UNIQUE (location_id, namedplace_id);

    ADD CONSTRAINT place_pkey PRIMARY KEY (locationplace_id);

    ADD CONSTRAINT soilobs_keys UNIQUE (locationevent_id);

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

CREATE INDEX commclass_locationevent_id_x ON commclass USING btree (locationevent_id);

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

CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs USING btree (locationevent_id);

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

CREATE INDEX emb_location_idx ON location USING btree (emb_location);

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

CREATE INDEX emb_locationevent_idx ON locationevent USING btree (emb_locationevent);

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

CREATE INDEX embargo_location_id_x ON embargo USING btree (location_id);

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

CREATE INDEX fki_location_namedplace_id ON location USING btree (namedplace_id);

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

CREATE INDEX graphic_locationevent_id_x ON graphic USING btree (locationevent_id);

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

CREATE UNIQUE INDEX location_accessioncode_index ON location USING btree (accessioncode);

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

CREATE INDEX location_parent_id_x ON location USING btree (parent_id);

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

CREATE INDEX location_reference_id_x ON location USING btree (reference_id);

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

CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent USING btree (accessioncode);

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

CREATE INDEX locationevent_covermethod_id_x ON locationevent USING btree (covermethod_id);

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

CREATE INDEX locationevent_location_id_x ON locationevent USING btree (location_id);

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

CREATE INDEX locationevent_previousobs_id_x ON locationevent USING btree (previous_id);

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

CREATE INDEX locationevent_project_id_x ON locationevent USING btree (project_id);

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

CREATE INDEX locationevent_soiltaxon_id_x ON locationevent USING btree (soiltaxon_id);

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

CREATE INDEX locationevent_stratummethod_id_x ON locationevent USING btree (stratummethod_id);

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

CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor USING btree (locationevent_id);

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

CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor USING btree (party_id);

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

CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor USING btree (role_id);

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

CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym USING btree (accessioncode);

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

CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym USING btree (party_id);

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

CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym USING btree (primarylocationevent_id);

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

CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym USING btree (role_id);

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

CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym USING btree (synonymlocationevent_id);

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

CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace USING btree (accessioncode);

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

CREATE INDEX namedplace_reference_id_x ON namedplace USING btree (reference_id);

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

CREATE UNIQUE INDEX note_accessioncode_index ON note USING btree (accessioncode);

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

CREATE INDEX note_notelink_id_x ON note USING btree (notelink_id);

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

CREATE INDEX note_party_id_x ON note USING btree (party_id);

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

CREATE INDEX note_role_id_x ON note USING btree (role_id);

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

CREATE UNIQUE INDEX party_accessioncode_index ON party USING btree (accessioncode);

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

CREATE INDEX party_currentname_id_x ON party USING btree (currentname_id);

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

CREATE INDEX partymember_childparty_id_x ON partymember USING btree (childparty_id);

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

CREATE INDEX partymember_parentparty_id_x ON partymember USING btree (parentparty_id);

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

CREATE INDEX partymember_role_id_x ON partymember USING btree (role_id);

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

CREATE INDEX place_location_id_x ON place USING btree (location_id);

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

CREATE INDEX place_namedplace_id_x ON place USING btree (namedplace_id);

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

CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept USING btree (accessioncode);

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

CREATE INDEX plantconcept_dobscount_x ON plantconcept USING btree (d_obscount);

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

CREATE INDEX plantconcept_plantname_id_x ON plantconcept USING btree (plantname_id);

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

CREATE INDEX plantconcept_reference_id_x ON plantconcept USING btree (reference_id);

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

CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation USING btree (plantconcept_id);

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

CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation USING btree (plantstatus_id);

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

CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage USING btree (childplantstatus_id);

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

CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage USING btree (parentplantstatus_id);

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

CREATE INDEX plantname_plantname_x ON plantname USING btree (plantname);

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

CREATE INDEX plantname_reference_id_x ON plantname USING btree (reference_id);

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

CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus USING btree (accessioncode);

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

CREATE INDEX plantstatus_party_id_x ON plantstatus USING btree (party_id);

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

CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus USING btree (plantconcept_id);

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

CREATE INDEX plantstatus_plantlevel_x ON plantstatus USING btree (plantlevel);

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

CREATE INDEX plantstatus_plantparent_id_x ON plantstatus USING btree (plantparent_id);

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

CREATE INDEX plantstatus_reference_id_x ON plantstatus USING btree (reference_id);

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

CREATE INDEX plantusage_classsystem_x ON plantusage USING btree (classsystem);

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

CREATE INDEX plantusage_party_id_x ON plantusage USING btree (party_id);

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

CREATE INDEX plantusage_plantconcept_id_x ON plantusage USING btree (plantconcept_id);

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

CREATE INDEX plantusage_plantname_id_x ON plantusage USING btree (plantname_id);

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

CREATE INDEX plantusage_plantname_x ON plantusage USING btree (plantname);

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

CREATE INDEX plantusage_plantstatus_id_x ON plantusage USING btree (plantstatus_id);

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

CREATE INDEX soilobs_locationevent_id_x ON soilobs USING btree (locationevent_id);

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