<plotevent id="0">

        <plot_id>

            <plot>

            </plot>

        </plot_id>

    </plotevent>

    <plotevent id="1">

        <plot_id>

            <plot>

            </plot>

        </plot_id>

    </plotevent>

        <plotevent_id>

            <plotevent>

                <plot_id>

                    <plot>

                            <plot>

                            </plot>

                    </plot>

                </plot_id>

            </plotevent>

        </plotevent_id>

        <plotevent_id>

            <plotevent>

                <plot_id>

                    <plot>

                            <plot>

                            </plot>

                    </plot>

                </plot_id>

            </plotevent>

        </plotevent_id>

    <plotevent id="0">

        <plot_id>

            <plot>

            </plot>

        </plot_id>

                    <tablename>plotevent</tablename>

    </plotevent>

    <plotevent id="1">

        <plot_id>

            <plot>

            </plot>

        </plot_id>

                    <tablename>plotevent</tablename>

                    <tablename>plotevent</tablename>

    </plotevent>

        <plotevent_id>

            <plotevent>

                <plot_id>

                    <plot>

                    </plot>

                </plot_id>

            </plotevent>

        </plotevent_id>

        <plotevent_id>

            <plotevent>

                <plot_id>

                    <plot>

                    </plot>

                </plot_id>

            </plotevent>

        </plotevent_id>

        <plotevent_id>

            <plotevent>

                <plot_id>

                    <plot>

                    </plot>

                </plot_id>

            </plotevent>

        </plotevent_id>

        <plotevent_id>

            <plotevent>

                <plot_id>

                    <plot>

                    </plot>

                </plot_id>

            </plotevent>

        </plotevent_id>

plot_area_ha,/*_id/plot/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"

Elev,/*_id/plot/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.

Country,"/*_id/plot/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename",

PolDiv1,"/*_id/plot/place(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince

MajorGeo,/*_id/plot/place(/*_id/namedplace[placesystem=continent])/placename,

pol2,/*_id/plot/place(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish

Locality_Description,/*_id/plot/place/*_id/namedplace/placedescription,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"

LatDec,/*_id/plot/reallatitude,

LongDec,/*_id/plot/reallongitude,

slope_aspect,/*_id/plot/slopeaspect,

slope_gradient,/*_id/plot/slopegradient,

elev_max_m,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",

elev_min_m,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",

project_id,/*_id/project/projectname,

life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,

life_zone,/commclass/commdetermination/*_id/commconcept/commdescription,

Precip,"/definedvalue[*_id/userdefined[tablename=plotevent,userdefinedname=precipitationMm]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

Temp,"/definedvalue[*_id/userdefined[tablename=plotevent,userdefinedname=temperatureC]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

PlotMethod,/methodnarrative,

date_finish,/obsenddate/_date/date,

date_start,/obsstartdate/_date/date,

soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_base,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_Ca,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_C,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCarbon]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_cation_cap,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCationCap]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_conductivity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilConductivity]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_Mg,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilMagnesium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_N,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilNitrogen]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_P,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPhosphorus]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_K,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPotassium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

soil_Na,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilSodium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue",

clay_percent,/soilobs:[soilhorizon=unknown]/soilclay,

organic_percent,/soilobs:[soilhorizon=unknown]/soilorganic,

pH,/soilobs:[soilhorizon=unknown]/soilph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."

sand_percent,/soilobs:[soilhorizon=unknown]/soilsand,

silt_percent,/soilobs:[soilhorizon=unknown]/soilsilt,

soil_texture,/soilobs:[soilhorizon=unknown]/soiltexture,

PlotID,/sourceid/_alt/1,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."

SiteCode,"/{*_id/plot:[confidentialitystatus=0]/sourceid/_alt/2,sourceid/_alt/2}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)

PlotID,/*_id/plotevent/sourceid/_alt/1,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."

PlotObsID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen:[*_id/reference]/sourceaccessionnumber,*_id/plotevent/sourceid/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/sourceid/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."

TRUNCATE plot CASCADE;

TRUNCATE plotevent CASCADE;

TRUNCATE ploteventcontributor CASCADE;

TRUNCATE ploteventsynonym CASCADE;

    plotevent_id integer NOT NULL,

    plotevent_id integer NOT NULL,

    plot_id integer NOT NULL,

    plotevent_id integer NOT NULL,

    plotplace_id integer NOT NULL,

    plot_id integer NOT NULL,

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

CREATE SEQUENCE place_plotplace_id_seq

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

ALTER SEQUENCE place_plotplace_id_seq OWNED BY place.plotplace_id;

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

--

CREATE TABLE plot (

    plot_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_plot integer,

    plotrationalenarrative text,

    accessioncode character varying(255),

    subplotxposition double precision,

    subplotyposition double precision,

    namedplace_id integer

);

--

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

--

CREATE SEQUENCE plot_plot_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE plot_plot_id_seq OWNED BY plot.plot_id;

--

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

--

CREATE TABLE plotevent (

    plotevent_id integer NOT NULL,

    previous_id integer,

    plot_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),

    plotvalidationlevel integer,

    floristicquality character varying(30),

    bryophytequality character varying(30),

    lichenquality character varying(30),

    ploteventnarrative 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_plotevent 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 plotevent; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

CREATE SEQUENCE plotevent_plotevent_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE plotevent_plotevent_id_seq OWNED BY plotevent.plotevent_id;

--

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

--

CREATE TABLE ploteventcontributor (

    ploteventcontributor_id integer NOT NULL,

    plotevent_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    contributiondate timestamp with time zone

);

--

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

--

CREATE SEQUENCE ploteventcontributor_ploteventcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE ploteventcontributor_ploteventcontributor_id_seq OWNED BY ploteventcontributor.ploteventcontributor_id;

--

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

--

CREATE TABLE ploteventsynonym (

    ploteventsynonym_id integer NOT NULL,

    synonymplotevent_id integer NOT NULL,

    primaryplotevent_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: ploteventsynonym_ploteventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE ploteventsynonym_ploteventsynonym_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE ploteventsynonym_ploteventsynonym_id_seq OWNED BY ploteventsynonym.ploteventsynonym_id;

--

    d_lastplotaddeddate timestamp with time zone,

    plotevent_id integer NOT NULL,

    plotevent_id integer NOT NULL,

    plotevent_id integer NOT NULL,

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

ALTER TABLE place ALTER COLUMN plotplace_id SET DEFAULT nextval('place_plotplace_id_seq'::regclass);

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

--

ALTER TABLE plot ALTER COLUMN plot_id SET DEFAULT nextval('plot_plot_id_seq'::regclass);

--

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

--

ALTER TABLE plotevent ALTER COLUMN plotevent_id SET DEFAULT nextval('plotevent_plotevent_id_seq'::regclass);

--

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

--

ALTER TABLE ploteventcontributor ALTER COLUMN ploteventcontributor_id SET DEFAULT nextval('ploteventcontributor_ploteventcontributor_id_seq'::regclass);

--

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

--

ALTER TABLE ploteventsynonym ALTER COLUMN ploteventsynonym_id SET DEFAULT nextval('ploteventsynonym_ploteventsynonym_id_seq'::regclass);

--

    ADD CONSTRAINT commclass_keys UNIQUE (plotevent_id, classnotes);

    ADD CONSTRAINT place_keys UNIQUE (plot_id, namedplace_id);

    ADD CONSTRAINT place_pkey PRIMARY KEY (plotplace_id);

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

--

ALTER TABLE ONLY plot

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

--

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

--

ALTER TABLE ONLY plot

    ADD CONSTRAINT plot_pkey PRIMARY KEY (plot_id);

--

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

--

ALTER TABLE ONLY plotevent

    ADD CONSTRAINT plotevent_keys UNIQUE (plot_id, project_id, sourceid);

--

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

--

ALTER TABLE ONLY plotevent

    ADD CONSTRAINT plotevent_pkey PRIMARY KEY (plotevent_id);

--

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

--

ALTER TABLE ONLY ploteventcontributor

    ADD CONSTRAINT ploteventcontributor_pkey PRIMARY KEY (ploteventcontributor_id);

--

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

--

ALTER TABLE ONLY ploteventsynonym

    ADD CONSTRAINT ploteventsynonym_pkey PRIMARY KEY (ploteventsynonym_id);

--

    ADD CONSTRAINT soilobs_keys UNIQUE (plotevent_id);

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

CREATE INDEX commclass_plotevent_id_x ON commclass USING btree (plotevent_id);

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

CREATE INDEX disturbanceobs_plotevent_id_x ON disturbanceobs USING btree (plotevent_id);

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

CREATE INDEX emb_plot_idx ON plot USING btree (emb_plot);

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

CREATE INDEX emb_plotevent_idx ON plotevent USING btree (emb_plotevent);

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

CREATE INDEX embargo_plot_id_x ON embargo USING btree (plot_id);

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

CREATE INDEX fki_plot_namedplace_id ON plot USING btree (namedplace_id);

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

CREATE INDEX graphic_plotevent_id_x ON graphic USING btree (plotevent_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: