<collectiveobservation>

                <individualplant>

                </individualplant>

        </collectiveobservation>

        <collectiveobservation>

                <individualplant>

                </individualplant>

        </collectiveobservation>

        <collectiveobservation>

        </collectiveobservation>

        <collectiveobservation>

        </collectiveobservation>

        <collectiveobservation>

                <individualplant>

                                <tableName>individualplant</tableName>

                                <tableName>individualplant</tableName>

                </individualplant>

        </collectiveobservation>

        <collectiveobservation>

        </collectiveobservation>

NoInd,/collectiveobservation/*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

cover_percent,/collectiveobservation/cover,

intercept_cm,"/collectiveobservation/definedValue[*_ID/userDefined[tableName=collectiveobservation,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

ht_first_branch_m,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob

tag2,/collectiveobservation/stemCount/individualplant/stemCode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."

tag1,/collectiveobservation/stemCount/individualplant/stemCode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."

x_position,/collectiveobservation/stemCount/individualplant/stemXPosition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."

y_position,/collectiveobservation/stemCount/individualplant/stemYPosition,Brad: See comment above for x_position

temp_dbh,/collectiveobservation/stemCount/stemDiameter,

height_m,/collectiveobservation/stemCount/stemHeight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob

PlotObsID,":[collectiveobservation/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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."

/simpleUserdefined[name=count]/value,/collectiveobservation/*/stemCount/_alt/1

/simpleUserdefined[name=coverPercent]/value,/collectiveobservation/cover

/simpleUserdefined[name=interceptCm]/value,"/collectiveobservation/definedValue[*_ID/userDefined[tableName=collectiveobservation,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=habitat]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=htFirstBranchM]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=plantFungusDescription]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/diameterBaseDistance[baseDistance=0]/diameter,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=stemCanopyForm]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=stemCanopyPosition]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=stemHeightFirstBranchM]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=stemLianaInfestation]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=substrate]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/simpleUserdefined[name=vegetation]/value,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"

/*ID->/*s/individualOrganism/identificationLabel,/collectiveobservation/stemCount/individualplant/stemCode

/*ID->/*s/individualOrganism/identificationLabel/_alt/1,/collectiveobservation/stemCount/individualplant/stemCode/_alt/1

/*ID->/*s/individualOrganism/identificationLabel/_alt/2,/collectiveobservation/stemCount/individualplant/stemCode/_alt/2

/simpleUserdefined[name=xPosition]/value,/collectiveobservation/stemCount/individualplant/stemXPosition

/simpleUserdefined[name=yPosition]/value,/collectiveobservation/stemCount/individualplant/stemYPosition

/diameterBaseDistance[baseDistance=1.37]/diameter,/collectiveobservation/stemCount/stemDiameter

/height,/collectiveobservation/stemCount/stemHeight

/simpleUserdefined[name=stemHeightM]/value,/collectiveobservation/stemCount/stemHeight

/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[collectiveobservation/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"

TRUNCATE individualplant CASCADE;

TRUNCATE stratum CASCADE;

TRUNCATE collectiveobservation CASCADE;

TRUNCATE taxonbin CASCADE;

    collectiveobservation_id integer NOT NULL,

-- Name: individualplant; Type: TABLE; Schema: public; Owner: bien; Tablespace: 

CREATE TABLE individualplant (

    individualplant_id integer NOT NULL,

ALTER TABLE public.individualplant OWNER TO bien;

ALTER SEQUENCE stemlocation_stemlocation_id_seq OWNED BY individualplant.individualplant_id;

-- Name: stratum; Type: TABLE; Schema: public; Owner: bien; Tablespace: 

CREATE TABLE stratum (

    stratum_id integer NOT NULL,

ALTER TABLE public.stratum OWNER TO bien;

ALTER SEQUENCE stratum_stratum_id_seq OWNED BY stratum.stratum_id;

-- Name: collectiveobservation; Type: TABLE; Schema: public; Owner: bien; Tablespace: 

CREATE TABLE collectiveobservation (

    collectiveobservation_id integer NOT NULL,

    stratum_id integer,

ALTER TABLE public.collectiveobservation OWNER TO bien;

ALTER SEQUENCE taxonimportance_taxonimportance_id_seq OWNED BY collectiveobservation.collectiveobservation_id;

    individualplant_id integer,

    SELECT taxonoccurrence.plotevent_id, taxonoccurrence.authorplantname AS plant, CASE WHEN (collectiveobservation.stratum_id IS NULL) THEN '-all-'::character varying ELSE (SELECT stratumtype.stratumname FROM stratumtype, stratum WHERE ((stratum.stratumtype_id = stratumtype.stratumtype_id) AND (stratum.stratum_id = collectiveobservation.stratum_id))) END AS stratum, collectiveobservation.cover, (SELECT min((coverindex.covercode)::text) AS min FROM coverindex WHERE (((coverindex.coverpercent = collectiveobservation.cover) AND (coverindex.covermethod_id = plotevent.covermethod_id)) AND (plotevent.plotevent_id = taxonoccurrence.plotevent_id))) AS covercode_exact, (SELECT min((coverindex.covercode)::text) AS min FROM coverindex WHERE ((((coverindex.upperlimit >= collectiveobservation.cover) AND (coverindex.lowerlimit <= collectiveobservation.cover)) AND (coverindex.covermethod_id = plotevent.covermethod_id)) AND (plotevent.plotevent_id = taxonoccurrence.plotevent_id))) AS covercode_byrange, collectiveobservation.basalarea, taxonoccurrence.accessioncode FROM taxonoccurrence, collectiveobservation, view_notemb_observation plotevent WHERE ((taxonoccurrence.taxonoccurrence_id = collectiveobservation.taxonoccurrence_id) AND (taxonoccurrence.plotevent_id = plotevent.plotevent_id));

    SELECT view_csv_taxonimportance_pre.plotevent_id, view_csv_taxonimportance_pre.plant, view_csv_taxonimportance_pre.stratum, view_csv_taxonimportance_pre.cover, CASE WHEN (view_csv_taxonimportance_pre.covercode_exact IS NULL) THEN view_csv_taxonimportance_pre.covercode_byrange ELSE view_csv_taxonimportance_pre.covercode_exact END AS covercode, view_csv_taxonimportance_pre.basalarea, view_csv_taxonimportance_pre.accessioncode FROM view_csv_taxonimportance_pre;

    SELECT stemcount.stemcount_id, stemcount.collectiveobservation_id, stemcount.stemdiameter, stemcount.stemdiameteraccuracy, stemcount.stemheight, stemcount.stemheightaccuracy, stemcount.stemcount, stemcount.stemtaxonarea, stemcount.emb_stemcount FROM stemcount WHERE (stemcount.emb_stemcount < 6);

    SELECT individualplant.individualplant_id, individualplant.stemcount_id, individualplant.stemcode, individualplant.stemxposition, individualplant.stemyposition, individualplant.stemhealth, individualplant.emb_stemlocation FROM individualplant WHERE (individualplant.emb_stemlocation < 6);

    SELECT collectiveobservation.collectiveobservation_id, collectiveobservation.taxonoccurrence_id, collectiveobservation.stratum_id, collectiveobservation.cover, collectiveobservation.basalarea, collectiveobservation.biomass, collectiveobservation.inferencearea, collectiveobservation.stratumbase, collectiveobservation.stratumheight, collectiveobservation.emb_taxonimportance, collectiveobservation.covercode FROM collectiveobservation WHERE (collectiveobservation.emb_taxonimportance < 6);

    SELECT taxondetermination.taxondetermination_id, taxondetermination.taxonoccurrence_id, taxondetermination.individualplant_id, taxondetermination.plantconcept_id, taxondetermination.plantname_id, taxondetermination.party_id, taxondetermination.role_id, taxondetermination.interpretationtype, taxondetermination.reference_id, taxondetermination.originalinterpretation, taxondetermination.currentinterpretation, taxondetermination.taxonfit, taxondetermination.taxonconfidence, taxondetermination.collector_id, taxondetermination.collectionnumber, taxondetermination.museum_id, taxondetermination.museumaccessionnumber, taxondetermination.grouptype, taxondetermination.notes, taxondetermination.notespublic, taxondetermination.notesmgt, taxondetermination.revisions, taxondetermination.interpretationdate, taxondetermination.collectiondate, taxondetermination.emb_taxoninterpretation, taxondetermination.accessioncode FROM taxondetermination WHERE (taxondetermination.emb_taxoninterpretation < 6);

    SELECT taxondetermination.taxondetermination_id, taxondetermination.taxonoccurrence_id, taxondetermination.individualplant_id, taxondetermination.plantconcept_id, taxondetermination.plantname_id, taxondetermination.party_id, taxondetermination.role_id, taxondetermination.interpretationtype, taxondetermination.reference_id, taxondetermination.originalinterpretation, taxondetermination.currentinterpretation, taxondetermination.taxonfit, taxondetermination.taxonconfidence, taxondetermination.collector_id, taxondetermination.collectionnumber, taxondetermination.museum_id, taxondetermination.museumaccessionnumber, taxondetermination.grouptype, taxondetermination.notes, taxondetermination.notespublic, taxondetermination.notesmgt, taxondetermination.revisions, taxondetermination.interpretationdate, taxondetermination.collectiondate, taxondetermination.emb_taxoninterpretation, taxondetermination.accessioncode, plantconcept.accessioncode AS pc_accessioncode, plantconcept.plantname AS pc_plantname, taxonoccurrence.plotevent_id FROM view_notemb_taxoninterpretation taxondetermination, taxonoccurrence, plantconcept WHERE ((taxonoccurrence.taxonoccurrence_id = taxondetermination.taxonoccurrence_id) AND (plantconcept.plantconcept_id = taxondetermination.plantconcept_id));

    SELECT taxonoccurrence.taxonoccurrence_id, taxonoccurrence.plotevent_id, taxonoccurrence.authorplantname, taxonoccurrence.reference_id, taxonoccurrence.taxoninferencearea, taxonoccurrence.emb_taxonobservation, taxonoccurrence.int_origplantconcept_id, taxonoccurrence.int_origplantscifull, taxonoccurrence.int_origplantscinamenoauth, taxonoccurrence.int_origplantcommon, taxonoccurrence.int_origplantcode, taxonoccurrence.int_currplantconcept_id, taxonoccurrence.int_currplantscifull, taxonoccurrence.int_currplantscinamenoauth, taxonoccurrence.int_currplantcommon, taxonoccurrence.int_currplantcode, taxonoccurrence.accessioncode, (SELECT max(collectiveobservation.cover) AS max FROM collectiveobservation WHERE (collectiveobservation.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id)) AS maxcover FROM view_notemb_taxonobservation taxonoccurrence;

-- Name: individualplant_id; Type: DEFAULT; Schema: public; Owner: bien

ALTER TABLE individualplant ALTER COLUMN individualplant_id SET DEFAULT nextval('stemlocation_stemlocation_id_seq'::regclass);

-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: bien

ALTER TABLE stratum ALTER COLUMN stratum_id SET DEFAULT nextval('stratum_stratum_id_seq'::regclass);

-- Name: collectiveobservation_id; Type: DEFAULT; Schema: public; Owner: bien

ALTER TABLE collectiveobservation ALTER COLUMN collectiveobservation_id SET DEFAULT nextval('taxonimportance_taxonimportance_id_seq'::regclass);

ALTER TABLE ONLY individualplant

    ADD CONSTRAINT stemlocation_pkey PRIMARY KEY (individualplant_id);

ALTER TABLE ONLY stratum

    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);

ALTER TABLE ONLY collectiveobservation

    ADD CONSTRAINT taxonimportance_pkey PRIMARY KEY (collectiveobservation_id);

CREATE INDEX emb_stemlocation_idx ON individualplant USING btree (emb_stemlocation);

CREATE INDEX emb_taxonimportance_idx ON collectiveobservation USING btree (emb_taxonimportance);

CREATE INDEX stemcount_taxonimportance_id_x ON stemcount USING btree (collectiveobservation_id);

CREATE INDEX stemlocation_stemcount_id_x ON individualplant USING btree (stemcount_id);

CREATE INDEX stratum_observation_id_x ON stratum USING btree (plotevent_id);

CREATE INDEX stratum_stratummethod_id_x ON stratum USING btree (stratummethod_id);

CREATE INDEX stratum_stratumtype_id_x ON stratum USING btree (stratumtype_id);

CREATE INDEX taxonimportance_stratum_id_x ON collectiveobservation USING btree (stratum_id);

CREATE INDEX taxonimportance_taxonobservation_id_x ON collectiveobservation USING btree (taxonoccurrence_id);

CREATE INDEX taxoninterpretation_stemlocation_id_x ON taxondetermination USING btree (individualplant_id);

    ADD CONSTRAINT r1stemcount_taxonimportance_id FOREIGN KEY (collectiveobservation_id) REFERENCES collectiveobservation(collectiveobservation_id);

ALTER TABLE ONLY individualplant

ALTER TABLE ONLY stratum

ALTER TABLE ONLY collectiveobservation

ALTER TABLE ONLY stratum

ALTER TABLE ONLY collectiveobservation

    ADD CONSTRAINT r2taxonimportance_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id);

    ADD CONSTRAINT r2taxoninterpretation_stemlocation_id FOREIGN KEY (individualplant_id) REFERENCES individualplant(individualplant_id);

ALTER TABLE ONLY stratum

CREATE TABLE taxonbin (

    taxonbin_id integer NOT NULL,

    label character varying(255) NOT NULL,

    stratum_id integer,

    sizeclass_id integer,

    coverindex_id integer

);

stemlocation,individualplant,

taxonimportance,collectiveobservation,

,,column moves

\Z,"CREATE TABLE taxonbin (

    taxonbin_id integer NOT NULL,

    label character varying(255) NOT NULL,

    stratum_id integer,

    sizeclass_id integer,

    coverindex_id integer

);

",

,,"column moves"

"\Z","CREATE TABLE taxonbin (

    taxonbin_id integer NOT NULL,

    label character varying(255) NOT NULL,

    stratum_id integer,

    sizeclass_id integer,

    coverindex_id integer

);

",

"stemlocation","individualplant",

"taxonimportance","collectiveobservation",

stemlocation,individualplant,

taxonimportance,collectiveobservation,

Habitat,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"

PlantFungusDescription,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX;  this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"

Substrate,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=substrate]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"

Vegetation,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=vegetation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"

UniqueNYInternalRecordNumber,":[collectiveobservation/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"

cover_percent,//collectiveobservation/cover,

intercept_cm,"//collectiveobservation/definedValue[*_ID/userDefined[tableName=collectiveobservation,userDefinedName=interceptCm]]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

ht_first_branch_m,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=heightFirstBranchM]]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob

tag2,//individualplant/stemCode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."

tag1,//individualplant/stemCode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."

x_position,//individualplant/stemXPosition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."

y_position,//individualplant/stemYPosition,Brad: See comment above for x_position

/simpleUserdefined[name=coverPercent]/value,//collectiveobservation/cover

/simpleUserdefined[name=interceptCm]/value,"//collectiveobservation/definedValue[*_ID/userDefined[tableName=collectiveobservation,userDefinedName=interceptCm]]/definedValue"

/simpleUserdefined[name=habitat]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=habitat]]/definedValue"

/simpleUserdefined[name=htFirstBranchM]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=heightFirstBranchM]]/definedValue"

/simpleUserdefined[name=plantFungusDescription]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=plantFungusDescription]]/definedValue"

/diameterBaseDistance[baseDistance=0]/diameter,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemBasalDiameter]]/definedValue"

/simpleUserdefined[name=stemCanopyForm]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyForm]]/definedValue"

/simpleUserdefined[name=stemCanopyPosition]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyPosition]]/definedValue"

/simpleUserdefined[name=stemHeightFirstBranchM]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemHeightFirstBranchM]]/definedValue"

/simpleUserdefined[name=stemLianaInfestation]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemLianaInfestation]]/definedValue"

/simpleUserdefined[name=substrate]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=substrate]]/definedValue"

/simpleUserdefined[name=vegetation]/value,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=vegetation]]/definedValue"

//individualOrganism/identificationLabel,//individualplant/stemCode

//individualOrganism/identificationLabel/_alt/1,//individualplant/stemCode/_alt/1

//individualOrganism/identificationLabel/_alt/2,//individualplant/stemCode/_alt/2

/simpleUserdefined[name=xPosition]/value,//individualplant/stemXPosition

/simpleUserdefined[name=yPosition]/value,//individualplant/stemYPosition

Habitat,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=habitat]]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"

PlantFungusDescription,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=plantFungusDescription]]/definedValue","Brad: Incorrect mapping to VB, also possibly to VX;  this is the specimenDescription field, as used by this institution (NOT a standard DwC element). Very important! Bob, Nick, where would this go in VB and VX?"

Substrate,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=substrate]]/definedValue","Brad: Incorrect mapping to VB and VX; refers to geological substrate or soils where specimen collected. Often concatenated with habitat, or included with specimen description. Bob, Nick, is there an element for this in VB/VX, or shall we just use userDefined?"

Vegetation,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=vegetation]]/definedValue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?"

cover_percent,//collectiveobservation/cover,

intercept_cm,"//collectiveobservation/definedValue[*_ID/userDefined[tableName=collectiveobservation,userDefinedName=interceptCm]]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

ht_first_branch_m,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=heightFirstBranchM]]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob

basal_diam,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemBasalDiameter]]/definedValue",

stem_canopy_form,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyForm]]/definedValue",Brad: Should also be userDefined for VegBank. 

stem_canopy_position,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyPosition]]/definedValue",Brad: Should also be userDefined for VegBank. 

stem_height_first_branch_m,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemHeightFirstBranchM]]/definedValue","Brad: Should also be userDefined for VegBank. Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."

stem_liana_infestation,"//individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemLianaInfestation]]/definedValue",Brad: Should also be userDefined for VegBank. 

stem_tag1,//individualplant/stemCode,"Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."

stem_tag2,//individualplant/stemCode,Brad: see above

tag2,//individualplant/stemCode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."

tag1,//individualplant/stemCode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."

x_position,//individualplant/stemXPosition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."

y_position,//individualplant/stemYPosition,Brad: See comment above for x_position

no_of_individuals,/collectiveobservation/*/stemCount/_alt/1,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

cover_percent,/collectiveobservation/cover,

intercept_cm,"/collectiveobservation/definedValue[*_ID/userDefined[tableName=collectiveobservation,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

ht_first_branch_m,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob

basal_diam,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemBasalDiameter]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",

stem_canopy_form,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyForm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Should also be userDefined for VegBank. 

stem_canopy_position,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemCanopyPosition]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Should also be userDefined for VegBank. 

stem_height_first_branch_m,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemHeightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue","Brad: Should also be userDefined for VegBank. Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."

stem_liana_infestation,"/collectiveobservation/stemCount/individualplant/definedValue[*_ID/userDefined[tableName=individualplant,userDefinedName=stemLianaInfestation]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue",Brad: Should also be userDefined for VegBank. 

stem_tag1,/collectiveobservation/stemCount/individualplant/stemCode,"Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."

stem_tag2,/collectiveobservation/stemCount/individualplant/stemCode,Brad: see above

tag2,/collectiveobservation/stemCount/individualplant/stemCode/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."

tag1,/collectiveobservation/stemCount/individualplant/stemCode/_alt/2,"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."

x_position,/collectiveobservation/stemCount/individualplant/stemXPosition,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."

y_position,/collectiveobservation/stemCount/individualplant/stemYPosition,Brad: See comment above for x_position

stem_dbh,/collectiveobservation/stemCount/stemDiameter,

height_m,/collectiveobservation/stemCount/stemHeight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob

stem_height_m,/collectiveobservation/stemCount/stemHeight,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."

OBSERVATION_ID,":[collectiveobservation/*/stemCount/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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."