/ - Diff - BIEN 3 - NCEAS Projects

                 </userdefined_id>
                 <definedvalue>10</definedvalue>
             </definedvalue>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
                 <catalognumber_dwc>14598</catalognumber_dwc>
                 <verbatimcollectorname>Vasquez</verbatimcollectorname>
                 <sourceaccessioncode>607771</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
             <taxondetermination>
                 <role_id>
                     <role>
-...
                 </userdefined_id>
                 <definedvalue>100</definedvalue>
             </definedvalue>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
                 <catalognumber_dwc>14669</catalognumber_dwc>
                 <verbatimcollectorname>Vasquez</verbatimcollectorname>
                 <sourceaccessioncode>607722</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
             <taxondetermination>
                 <role_id>
                     <role>

                 <isoriginal>true</isoriginal>
                 <iscurrent>true</iscurrent>
             </taxondetermination>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
                 <sourceaccessioncode>1</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
         </taxonoccurrence>
         <taxonoccurrence id="1">
             <locationevent_id>
-...
                 <isoriginal>true</isoriginal>
                 <iscurrent>true</iscurrent>
             </taxondetermination>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
                 <sourceaccessioncode>2</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
         </taxonoccurrence>
     </VegBIEN>

                     <authorplantcode>816590</authorplantcode>
                 </individualplant>
             </aggregateoccurrence>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
-...
                 </museum_id>
                 <collectioncode_dwc>Herbarium</collectioncode_dwc>
                 <sourceaccessioncode>816590</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
             <taxondetermination>
                 <role_id>
                     <role>
-...
                     <obsstartdate>1994-01-17</obsstartdate>
                 </locationevent>
             </locationevent_id>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
-...
                 </museum_id>
                 <collectioncode_dwc>Herbarium</collectioncode_dwc>
                 <sourceaccessioncode>220541</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
             <taxondetermination>
                 <role_id>
                     <role>

     </authorplantcode>
                 </individualplant>
             </aggregateoccurrence>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
-...
                 <collectioncode_dwc>Herbarium</collectioncode_dwc>
                 <sourceaccessioncode>816590
 </sourceaccessioncode>
             </specimen>
             </specimenreplicate>
             <taxondetermination>
                 <role_id>
                     <role>
-...
                     <obsstartdate>1994-01-17</obsstartdate>
                 </locationevent>
             </locationevent_id>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
-...
                 <collectioncode_dwc>Herbarium</collectioncode_dwc>
                 <sourceaccessioncode>220541
 </sourceaccessioncode>
             </specimen>
             </specimenreplicate>
             <taxondetermination>
                 <role_id>
                     <role>

     PlantFungusDescription,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]:[@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,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]:[@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,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]:[@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?"
     FieldNumber,/specimen:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
     CollectorNumber,/specimen:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX"
     Collector,/specimen:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?
     InstitutionCode,/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/first},
     CollectionCode,"/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
     FieldNumber,/specimenreplicate:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
     CollectorNumber,/specimenreplicate:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX"
     Collector,/specimenreplicate:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?
     InstitutionCode,/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname/_name/first},
     CollectionCode,"/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
     Sex,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
     IdentifiedDate,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_*/date",
     DayIdentified,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day",
-...
     Species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     Phylum,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     Subspecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",
     UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","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"
     UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate:[*_id/reference]/sourceaccessioncode}","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"

                 <isoriginal>true</isoriginal>
                 <iscurrent>true</iscurrent>
             </taxondetermination>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
                 <sourceaccessioncode>1</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
         </taxonoccurrence>
         <taxonoccurrence id="1">
             <locationevent_id>
-...
                 <isoriginal>true</isoriginal>
                 <iscurrent>true</iscurrent>
             </taxondetermination>
             <specimen>
             <specimenreplicate>
                 <reference_id>
                     <reference/>
                 </reference_id>
                 <sourceaccessioncode>2</sourceaccessioncode>
             </specimen>
             </specimenreplicate>
         </taxonoccurrence>
         <stem id="0">
             <individualplant_id>

     Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
     Ind,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
     DetType,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]:[@fkey=tableRecord_ID]/definedvalue","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
     coll_number,/specimen:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     census_date,/specimen:[*_id/reference]/collectiondate/_*/date,
     coll_firstname,/specimen:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,/specimen:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     coll_number,/specimenreplicate:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     census_date,/specimenreplicate:[*_id/reference]/collectiondate/_*/date,
     coll_firstname,/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
     Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
-...
     Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes",
     OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","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."
     PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate:[*_id/reference]/sourceaccessioncode}","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."

       CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode )
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
     CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
+    (
       specimen_id int(11) NOT NULL AUTO_INCREMENT,
       specimenreplicate_id int(11) NOT NULL AUTO_INCREMENT,
       reference_id int(11) NOT NULL,
       collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
       collectioncode_dwc character varying(255), -- The code for the collection that the specimenreplicate is from.
       catalognumber_dwc character varying(255),
       collectiondate timestamp NULL,
       museum_id int(11),
-...
       accessioncode character varying(255),
       taxonoccurrence_id int(11) NOT NULL,
       verbatimcollectorname character varying(255),
       collectionnumber character varying(255), -- The number of the specimen within the collection.
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
       CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
       collectionnumber character varying(255), -- The number of the specimenreplicate within the collection.
       CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id ),
       CONSTRAINT specimenreplicate_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id)
       CONSTRAINT specimenreplicate_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
       CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),
       CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ),
       CONSTRAINT specimen_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber ),
       CONSTRAINT specimen_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id )
       CONSTRAINT specimenreplicate_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),
       CONSTRAINT specimenreplicate_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ),
       CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber ),
       CONSTRAINT specimenreplicate_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id )
     );
     CREATE TABLE voucher
+    (
       voucher_id int(11) NOT NULL AUTO_INCREMENT,
       taxonoccurrence_id int(11) NOT NULL,
       specimen_id int(11) NOT NULL,
       specimenreplicate_id int(11) NOT NULL,
       accessioncode character varying(255),
       CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id ),
       CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id)
           REFERENCES specimen (specimen_id) MATCH SIMPLE
       CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id)
           REFERENCES specimenreplicate (specimenreplicate_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id , specimen_id )
       CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id , specimenreplicate_id )
     );
     CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table.

       sourceaccessioncode character varying(100),
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
     CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
+    (
       specimen_id serial NOT NULL,
       specimenreplicate_id serial NOT NULL,
       reference_id integer NOT NULL,
       collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
       collectioncode_dwc character varying(255), -- The code for the collection that the specimenreplicate is from.
       catalognumber_dwc character varying(255),
       collectiondate timestamp with time zone,
       museum_id integer,
-...
       accessioncode character varying(255),
       taxonoccurrence_id integer NOT NULL,
       verbatimcollectorname character varying(255),
       collectionnumber character varying(255), -- The number of the specimen within the collection.
       collectionnumber character varying(255), -- The number of the specimenreplicate within the collection.
     );
     CREATE TABLE voucher
+    (
       voucher_id serial NOT NULL,
       taxonoccurrence_id integer NOT NULL,
       specimen_id integer NOT NULL,
       specimenreplicate_id integer NOT NULL,
       accessioncode character varying(255),
     );

     TRUNCATE sizeclass CASCADE;
     TRUNCATE soilobs CASCADE;
     TRUNCATE soiltaxon CASCADE;
     TRUNCATE specimen CASCADE;
     TRUNCATE specimenreplicate CASCADE;
     TRUNCATE stem CASCADE;
     TRUNCATE stratum CASCADE;
     TRUNCATE stratummethod CASCADE;

       CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode )
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
     CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
+    (
       specimen_id serial NOT NULL,
       specimenreplicate_id serial NOT NULL,
       reference_id integer NOT NULL,
       collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
       collectioncode_dwc character varying(255), -- The code for the collection that the specimenreplicate is from.
       catalognumber_dwc character varying(255),
       collectiondate timestamp with time zone,
       museum_id integer,
-...
       accessioncode character varying(255),
       taxonoccurrence_id integer NOT NULL,
       verbatimcollectorname character varying(255),
       collectionnumber character varying(255), -- The number of the specimen within the collection.
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
       CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
       collectionnumber character varying(255), -- The number of the specimenreplicate within the collection.
       CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id ),
       CONSTRAINT specimenreplicate_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id)
       CONSTRAINT specimenreplicate_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
       CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),
       CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ),
       CONSTRAINT specimen_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber ),
       CONSTRAINT specimen_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id )
       CONSTRAINT specimenreplicate_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),
       CONSTRAINT specimenreplicate_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ),
       CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber ),
       CONSTRAINT specimenreplicate_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id )
     );
     CREATE TABLE voucher
+    (
       voucher_id serial NOT NULL,
       taxonoccurrence_id integer NOT NULL,
       specimen_id integer NOT NULL,
       specimenreplicate_id integer NOT NULL,
       accessioncode character varying(255),
       CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id ),
       CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id)
           REFERENCES specimen (specimen_id) MATCH SIMPLE
       CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id)
           REFERENCES specimenreplicate (specimenreplicate_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id , specimen_id )
       CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id , specimenreplicate_id )
     );
     CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table.

     SET default_with_oids = false;
     --
     -- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace:
     -- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
     CREATE TABLE specimen (
         specimen_id integer NOT NULL,
     CREATE TABLE specimenreplicate (
         specimenreplicate_id integer NOT NULL,
         reference_id integer NOT NULL,
         collectioncode_dwc character varying(255),
         catalognumber_dwc character varying(255),
-...
     --
     -- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
     -- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON TABLE specimen IS 'A herbarium specimen. Contains Darwin Core specimen data.';
     COMMENT ON TABLE specimenreplicate IS 'A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.';
     --
     -- Name: COLUMN specimen.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN specimen.collectioncode_dwc IS 'The code for the collection that the specimen is from.';
     COMMENT ON COLUMN specimenreplicate.collectioncode_dwc IS 'The code for the collection that the specimenreplicate is from.';
     --
     -- Name: COLUMN specimen.collectionnumber; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN specimen.collectionnumber IS 'The number of the specimen within the collection.';
     COMMENT ON COLUMN specimenreplicate.collectionnumber IS 'The number of the specimenreplicate within the collection.';
     --
     -- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
     CREATE SEQUENCE specimen_specimen_id_seq
     CREATE SEQUENCE specimenreplicate_specimenreplicate_id_seq
         START WITH 1
         INCREMENT BY 1
         NO MINVALUE
-...
     --
     -- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
     -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
     --
     ALTER SEQUENCE specimen_specimen_id_seq OWNED BY specimen.specimen_id;
     ALTER SEQUENCE specimenreplicate_specimenreplicate_id_seq OWNED BY specimenreplicate.specimenreplicate_id;
     SET default_with_oids = true;
-...
     CREATE TABLE voucher (
         voucher_id integer NOT NULL,
         taxonoccurrence_id integer NOT NULL,
         specimen_id integer NOT NULL,
         specimenreplicate_id integer NOT NULL,
         accessioncode character varying(255)
     );
-...
     --
     -- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
     -- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
     --
     ALTER TABLE specimen ALTER COLUMN specimen_id SET DEFAULT nextval('specimen_specimen_id_seq'::regclass);
     ALTER TABLE specimenreplicate ALTER COLUMN specimenreplicate_id SET DEFAULT nextval('specimenreplicate_specimenreplicate_id_seq'::regclass);
     --
-...
     --
     -- Name: specimen_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: specimenreplicate_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id, collectioncode_dwc, sourceaccessioncode);
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_keys_accessioncode UNIQUE (reference_id, collectioncode_dwc, sourceaccessioncode);
     --
     -- Name: specimen_keys_catalognumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: specimenreplicate_keys_catalognumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id, collectioncode_dwc, catalognumber_dwc);
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_keys_catalognumber UNIQUE (reference_id, collectioncode_dwc, catalognumber_dwc);
     --
     -- Name: specimen_keys_collectionnumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: specimenreplicate_keys_collectionnumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_keys_collectionnumber UNIQUE (reference_id, collectioncode_dwc, collectionnumber);
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (reference_id, collectioncode_dwc, collectionnumber);
     --
     -- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
     --
     -- Name: specimen_taxonoccurrence_id_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: specimenreplicate_taxonoccurrence_id_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id);
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id);
     --
-...
     --
     ALTER TABLE ONLY voucher
         ADD CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id, specimen_id);
         ADD CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id, specimenreplicate_id);
     --
-...
     --
     -- Name: fki_specimen_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     -- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX fki_specimen_museum_id ON specimen USING btree (museum_id);
     CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate USING btree (museum_id);
     --
     -- Name: fki_specimen_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace:
     -- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX fki_specimen_reference_id_fkey ON specimen USING btree (reference_id);
     CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate USING btree (reference_id);
     --
-...
     --
     -- Name: specimen_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: specimen_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: specimen_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
-...
     --
     -- Name: voucher_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY voucher
         ADD CONSTRAINT voucher_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --

     Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
     Ind,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
     DetType,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]:[@fkey=tableRecord_ID]/definedvalue","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
     coll_number,/specimen:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     census_date,/specimen:[*_id/reference]/collectiondate/_*/date,
     coll_firstname,/specimen:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,/specimen:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     coll_number,/specimenreplicate:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     census_date,/specimenreplicate:[*_id/reference]/collectiondate/_*/date,
     coll_firstname,/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
     Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
-...
     Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes",
     OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","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."
     PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate:[*_id/reference]/sourceaccessioncode}","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=habit]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue"
     /simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]:[@fkey=tableRecord_ID]/definedvalue"
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode,/specimen:[*_id/reference]/catalognumber_dwc
     /simpleUserdefined[name=collectionDate]/value,/specimen:[*_id/reference]/collectiondate
     /simpleUserdefined[name=collectionDate]/value/_*/date,/specimen:[*_id/reference]/collectiondate/_*/date
     /simpleUserdefined[name=collectorNumberDwc]/value,/specimen:[*_id/reference]/collectornumber_dwc
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}",/specimen:[*_id/reference]/verbatimcollectorname
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName",/specimen:[*_id/reference]/verbatimcollectorname/_name/first
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/specimen:[*_id/reference]/verbatimcollectorname/_name/last
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/specimen:[*_id/reference]/{museum_id/party/organizationname,collectioncode_dwc/_namePart/last}"
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first,/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/first}
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last,"/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}"
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode,/specimenreplicate:[*_id/reference]/catalognumber_dwc
     /simpleUserdefined[name=collectionDate]/value,/specimenreplicate:[*_id/reference]/collectiondate
     /simpleUserdefined[name=collectionDate]/value/_*/date,/specimenreplicate:[*_id/reference]/collectiondate/_*/date
     /simpleUserdefined[name=collectorNumberDwc]/value,/specimenreplicate:[*_id/reference]/collectornumber_dwc
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}",/specimenreplicate:[*_id/reference]/verbatimcollectorname
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName",/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/first
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/last
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname,collectioncode_dwc/_namePart/last}"
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first,/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname/_name/first}
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last,"/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
-...
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
     "/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname"
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}"
     /*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate:[*_id/reference]/sourceaccessioncode}"

     Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
     Ind,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
     DetType,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]/definedvalue","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
     coll_number,//specimen/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     census_date,//specimen/collectiondate/_*/date,
     coll_firstname,//specimen/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,//specimen/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     coll_number,//specimenreplicate/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     census_date,//specimenreplicate/collectiondate/_*/date,
     coll_firstname,//specimenreplicate/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,//specimenreplicate/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     auth,"/taxondetermination[rolecode=computer,plantlevel=Authority]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
     Family,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
     Genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
-...
     Notes,/taxondetermination[rolecode=identifier]/notes,
     OrigFamily,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     OrigSpecies,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen/sourceaccessioncode}","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."
     PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate/sourceaccessioncode}","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=habit]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue"
     /simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue"
     //*s/taxonDetermination[role=collector]/groupType,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]/definedvalue"
     //taxonNameUsageConcept/authorCode,//specimen/catalognumber_dwc
     /simpleUserdefined[name=collectionDate]/value,//specimen/collectiondate
     /simpleUserdefined[name=collectionDate]/value/_*/date,//specimen/collectiondate/_*/date
     /simpleUserdefined[name=collectorNumberDwc]/value,//specimen/collectornumber_dwc
     "//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}",//specimen/verbatimcollectorname
     //individualName/givenName,//specimen/verbatimcollectorname/_name/first
     //individualName/surName,//specimen/verbatimcollectorname/_name/last
     //party/organizationName,"/specimen/{museum_id/party/organizationname,collectioncode_dwc/_namePart/last}"
     //party/organizationName/_name/first,/specimen/{museum_id/party/organizationname/_name/first}
     //party/organizationName/_name/last,"/specimen/{museum_id/party/organizationname/_name/last,collectioncode_dwc}"
     //taxonNameUsageConcept/authorCode,//specimenreplicate/catalognumber_dwc
     /simpleUserdefined[name=collectionDate]/value,//specimenreplicate/collectiondate
     /simpleUserdefined[name=collectionDate]/value/_*/date,//specimenreplicate/collectiondate/_*/date
     /simpleUserdefined[name=collectorNumberDwc]/value,//specimenreplicate/collectornumber_dwc
     "//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}",//specimenreplicate/verbatimcollectorname
     //individualName/givenName,//specimenreplicate/verbatimcollectorname/_name/first
     //individualName/surName,//specimenreplicate/verbatimcollectorname/_name/last
     //party/organizationName,"/specimenreplicate/{museum_id/party/organizationname,collectioncode_dwc/_namePart/last}"
     //party/organizationName/_name/first,/specimenreplicate/{museum_id/party/organizationname/_name/first}
     //party/organizationName/_name/last,"/specimenreplicate/{museum_id/party/organizationname/_name/last,collectioncode_dwc}"
     //*s/taxonConcept[@code=auth]/Name,"/taxondetermination[rolecode=computer,plantlevel=Authority]/*_id/plantconcept/*_id/*/plantname"
     //*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname"
     //*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname"
-...
     //*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname"
     //*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname"
     //*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname"
     //taxonNameUsageConcept/voucher,"/{aggregateoccurrence/individualplant/authorplantcode,specimen/sourceaccessioncode}"
     //taxonNameUsageConcept/voucher,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate/sourceaccessioncode}"

     PlantFungusDescription,"//stem/definedvalue[*_id/userdefined[tablename=stem,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,"//stem/definedvalue[*_id/userdefined[tablename=stem,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,"//stem/definedvalue[*_id/userdefined[tablename=stem,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?"
     FieldNumber,//specimen/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
     CollectorNumber,//specimen/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX"
     Collector,//specimen/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?
     InstitutionCode,/specimen/{museum_id/party/organizationname/_name/first},
     CollectionCode,"/specimen/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
     FieldNumber,//specimenreplicate/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
     CollectorNumber,//specimenreplicate/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX"
     Collector,//specimenreplicate/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?
     InstitutionCode,/specimenreplicate/{museum_id/party/organizationname/_name/first},
     CollectionCode,"/specimenreplicate/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
     Sex,"/taxondetermination[rolecode=identifier]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
     DayIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/day,
     MonthIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/month,
-...
     Species,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",
     Phylum,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname",
     Subspecies,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",
     UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimen/sourceaccessioncode}","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"
     UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate/sourceaccessioncode}","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"

     habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
     individual_code,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
     det_type,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]/definedvalue","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
     coll_number,//specimen/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     coll_firstname,//specimen/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,//specimen/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     coll_number,//specimenreplicate/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     coll_firstname,//specimenreplicate/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,//specimenreplicate/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     specific_authority,"/taxondetermination[rolecode=computer,plantlevel=Authority]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
     family,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
     genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
-...
     notes,/taxondetermination[rolecode=identifier]/notes,
     orig_family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     orig_species,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     OBSERVATION_ID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen/sourceaccessioncode}","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."
     OBSERVATION_ID,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate/sourceaccessioncode}","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."

     PlantFungusDescription,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=plantFungusDescription]]:[@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,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=substrate]]:[@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,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]:[@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?"
     FieldNumber,/specimen:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
     CollectorNumber,/specimen:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX"
     Collector,/specimen:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?
     InstitutionCode,/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/first},
     CollectionCode,"/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
     FieldNumber,/specimenreplicate:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
     CollectorNumber,/specimenreplicate:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX"
     Collector,/specimenreplicate:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?
     InstitutionCode,/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname/_name/first},
     CollectionCode,"/specimenreplicate:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
     Sex,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
     DayIdentified,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day",
     MonthIdentified,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month",
-...
     Species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     Phylum,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     Subspecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",
     UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","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"
     UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate:[*_id/reference]/sourceaccessioncode}","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"

     habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
     individual_code,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
     det_type,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]:[@fkey=tableRecord_ID]/definedvalue","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
     coll_number,/specimen:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     coll_firstname,/specimen:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,/specimen:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     coll_number,/specimenreplicate:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
     coll_firstname,/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
     coll_lastname,/specimenreplicate:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
     specific_authority,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
     family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
     genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
-...
     notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes",
     orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
     OBSERVATION_ID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","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."
     OBSERVATION_ID,"/{aggregateoccurrence/individualplant/authorplantcode,specimenreplicate:[*_id/reference]/sourceaccessioncode}","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."

Project

General

Profile

Revision 668

Added by Aaron Marcuse-Kubitza almost 13 years ago