Project

General

Profile

« Previous | Next » 

Revision 1203

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Moved taxonoccurrence.verbatimcollectorname to specimenreplicate and aggregateoccurrence so that it can be used in specimenreplicate duplicate elimination

View differences:

inputs/NYBG/test/VegBIEN.specimens.xml.ref
158 158 
                    <isoriginal>true</isoriginal>
159 159 
                    <iscurrent>true</iscurrent>
160 160 
                </taxondetermination>
161 
                <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
162 161 
            </taxonoccurrence>
163 162 
        </taxonoccurrence_id>
164 163 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
165 164 
        <description>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</description>
165 
        <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
166 166 
        <datasource_id><party><organizationname>NYBG</organizationname></party></datasource_id>
167 167 
        <catalognumber_dwc>00682023</catalognumber_dwc>
168 168 
        <collectionnumber>9877</collectionnumber>
......
269 269 
                    <isoriginal>true</isoriginal>
270 270 
                    <iscurrent>true</iscurrent>
271 271 
                </taxondetermination>
272 
                <verbatimcollectorname>J. B. Walker</verbatimcollectorname>
273 272 
            </taxonoccurrence>
274 273 
        </taxonoccurrence_id>
275 274 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
275 
        <verbatimcollectorname>J. B. Walker</verbatimcollectorname>
276 276 
        <datasource_id><party><organizationname>NYBG</organizationname></party></datasource_id>
277 277 
        <catalognumber_dwc>200996</catalognumber_dwc>
278 278 
        <collectionnumber>545</collectionnumber>
inputs/NYBG/maps/VegBIEN.specimens.csv
63 63 
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
64 64 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
65 65 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
66 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
67 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
68 66 
CollectionCode,/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,12
69 67 
collectionCode,/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,12
70 68 
fieldNotes,/description,,
71 69 
Notes,/description/_merge/1,,
72 70 
PlantFungusDescription,"/description/_merge/2/_label[label=""plant fungus""]/value",,
71 
Collector,/verbatimcollectorname,,23
72 
recordedBy,/verbatimcollectorname,,23
73 73 
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
74 74 
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
75 75 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
inputs/SALVIAS/maps/VegBIEN.organisms.csv
17 17 
intercept_cm,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@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."
18 18 
liana_infestation,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=lianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue",Brad: Should also be userDefined for VegBank.
19 19 
Notes,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue",
20 
coll_firstname,/aggregateoccurrence/verbatimcollectorname/_name/first,Brad: See comment above
21 
coll_lastname,/aggregateoccurrence/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."
20 22 
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
21 23 
Habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=growthForm]]:[@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."
22 24 
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."
......
34 36 
OrigGenus,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",
35 37 
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
36 38 
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
37 
coll_firstname,/verbatimcollectorname/_name/first,Brad: See comment above
38 
coll_lastname,/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."
39 39 
GenAuth,,
40 40 
IsMorpho,,
41 41 
OrigAuth,,
inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref
158 158 
                    <isoriginal>true</isoriginal>
159 159 
                    <iscurrent>true</iscurrent>
160 160 
                </taxondetermination>
161 
                <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
162 161 
            </taxonoccurrence>
163 162 
        </taxonoccurrence_id>
164 163 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
165 164 
        <description>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</description>
165 
        <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
166 166 
        <datasource_id><party><organizationname>NYBG-CSV</organizationname></party></datasource_id>
167 167 
        <catalognumber_dwc>00682023</catalognumber_dwc>
168 168 
        <collectionnumber>9877</collectionnumber>
......
269 269 
                    <isoriginal>true</isoriginal>
270 270 
                    <iscurrent>true</iscurrent>
271 271 
                </taxondetermination>
272 
                <verbatimcollectorname>J. B. Walker</verbatimcollectorname>
273 272 
            </taxonoccurrence>
274 273 
        </taxonoccurrence_id>
275 274 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
275 
        <verbatimcollectorname>J. B. Walker</verbatimcollectorname>
276 276 
        <datasource_id><party><organizationname>NYBG-CSV</organizationname></party></datasource_id>
277 277 
        <catalognumber_dwc>200996</catalognumber_dwc>
278 278 
        <collectionnumber>545</collectionnumber>
inputs/NYBG-CSV/maps/VegBIEN.specimens.csv
63 63 
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
64 64 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
65 65 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
66 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
67 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
68 66 
CollectionCode,/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,12
69 67 
collectionCode,/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,12
70 68 
fieldNotes,/description,,
71 69 
Notes,/description/_merge/1,,
72 70 
PlantFungusDescription,"/description/_merge/2/_label[label=""plant fungus""]/value",,
71 
Collector,/verbatimcollectorname,,23
72 
recordedBy,/verbatimcollectorname,,23
73 73 
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
74 74 
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
75 75 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
inputs/SALVIAS-CSV/test/VegBIEN.organisms.xml.ref
33 33 
                </plantobservation>
34 34 
            </plantobservation_id>
35 35 
            <count>1</count>
36 
            <verbatimcollectorname>Vasquez</verbatimcollectorname>
36 37 
        </aggregateoccurrence>
37 38 
        <definedvalue fkey="tableRecord_ID">
38 39 
            <userdefined_id>
......
142 143 
            <isoriginal>true</isoriginal>
143 144 
            <iscurrent>true</iscurrent>
144 145 
        </taxondetermination>
145 
        <verbatimcollectorname>Vasquez</verbatimcollectorname>
146 146 
    </taxonoccurrence>
147 147 
    <taxonoccurrence id="1">
148 148 
        <locationevent_id>
......
177 177 
                </plantobservation>
178 178 
            </plantobservation_id>
179 179 
            <count>1</count>
180 
            <verbatimcollectorname>Vasquez</verbatimcollectorname>
180 181 
        </aggregateoccurrence>
181 182 
        <definedvalue fkey="tableRecord_ID">
182 183 
            <userdefined_id>
......
286 287 
            <isoriginal>true</isoriginal>
287 288 
            <iscurrent>true</iscurrent>
288 289 
        </taxondetermination>
289 
        <verbatimcollectorname>Vasquez</verbatimcollectorname>
290 290 
    </taxonoccurrence>
291 291 
</VegBIEN>
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
23 23 
cover_percent,/aggregateoccurrence/cover,
24 24 
intercept_cm,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@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."
25 25 
notes,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue",
26 
coll_firstname,/aggregateoccurrence/verbatimcollectorname/_name/first,Brad: See comment above
27 
coll_lastname,/aggregateoccurrence/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."
26 28 
census_no,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
27 29 
habit,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=growthForm]]:[@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."
28 30 
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."
......
38 40 
cf_aff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
39 41 
orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
40 42 
orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
41 
coll_firstname,/verbatimcollectorname/_name/first,Brad: See comment above
42 
coll_lastname,/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."
43 43 
collector_code,,Brad: OMIT
44 44 
comments,,Brad: OMIT
45 45 
fam_status,,Brad: OMIT. This will be determined later by using TNRS.
schemas/vegbien.my.sql
110 110 
    coverindex_id int(11),
111 111 
    occurrencestatus_dwc text DEFAULT 'present',
112 112 
    method_id int(11),
113 
    linecover double precision
113 
    linecover double precision,
114 
    verbatimcollectorname text
114 115 
);
115 116 

  		




  116
  117
  
    

  		




  ......




  2000
  2001
  
    
    taxonoccurrence_id int(11) NOT NULL,


  		




  2001
  2002
  
    
    collectionnumber text,


  		




  2002
  2003
  
    
    specimen_id int(11),


  		




  2003
  
  
    
    description text


  		




  
  2004
  
    
    description text,


  		




  
  2005
  
    
    verbatimcollectorname text


  		




  2004
  2006
  
    
);


  		




  2005
  2007
  
    

  		




  2006
  2008
  
    

  		




  ......




  2228
  2230
  
    
    taxonoccurrence_id int(11) NOT NULL,


  		




  2229
  2231
  
    
    locationevent_id int(11),


  		




  2230
  2232
  
    
    emb_taxonoccurrence int(11),


  		




  2231
  
  
    
    accessioncode text,


  		




  2232
  
  
    
    verbatimcollectorname text


  		




  
  2233
  
    
    accessioncode text


  		




  2233
  2234
  
    
);


  		




  2234
  2235
  
    

  		




  2235
  2236
  
    

  		












  

    
      schemas/vegbien.sql
    
  





  176
  176
  
    
    occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL,


  		




  177
  177
  
    
    method_id integer,


  		




  178
  178
  
    
    linecover double precision,


  		




  
  179
  
    
    verbatimcollectorname text,


  		




  179
  180
  
    
    CONSTRAINT aggregateoccurrence_plantobservation_count_1 CHECK (((plantobservation_id IS NULL) OR (NOT (count IS DISTINCT FROM 1))))


  		




  180
  181
  
    
);


  		




  181
  182
  
    

  		




  ......




  2347
  2348
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  2348
  2349
  
    
    collectionnumber text,


  		




  2349
  2350
  
    
    specimen_id integer,


  		




  2350
  
  
    
    description text


  		




  
  2351
  
    
    description text,


  		




  
  2352
  
    
    verbatimcollectorname text


  		




  2351
  2353
  
    
);


  		




  2352
  2354
  
    

  		




  2353
  2355
  
    

  		




  ......




  2605
  2607
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  2606
  2608
  
    
    locationevent_id integer,


  		




  2607
  2609
  
    
    emb_taxonoccurrence integer,


  		




  2608
  
  
    
    accessioncode text,


  		




  2609
  
  
    
    verbatimcollectorname text


  		




  
  2610
  
    
    accessioncode text


  		




  2610
  2611
  
    
);


  		




  2611
  2612
  
    

  		




  2612
  2613
  
    

  		












  

    
      mappings/VegX-VegBIEN.organisms.csv
    
  





  82
  82
  
    
/simpleUserdefined[name=interceptCm]/value,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]:[@fkey=tableRecord_ID]/definedvalue",


  		




  83
  83
  
    
/simpleUserdefined[name=lianaInfestation]/value,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=lianaInfestation]]:[@fkey=tableRecord_ID]/definedvalue",


  		




  84
  84
  
    
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue",


  		




  
  85
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName",/aggregateoccurrence/verbatimcollectorname/_name/first,


  		




  
  86
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/aggregateoccurrence/verbatimcollectorname/_name/last,


  		




  85
  87
  
    
/simpleUserdefined[name=censusNo]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]:[@fkey=tableRecord_ID]/definedvalue",


  		




  86
  88
  
    
/simpleUserdefined[name=growthForm]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=growthForm]]:[@fkey=tableRecord_ID]/definedvalue",


  		




  87
  89
  
    
/simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue",


  		




  ......




  106
  108
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  107
  109
  
    
"/*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/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  108
  110
  
    
"/*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/*_id/plantname/rank=Subspecies]/*_id/plantconcept/*_id/*/plantname",


  		




  109
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName",/verbatimcollectorname/_name/first,


  		




  110
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/verbatimcollectorname/_name/last,


  		












  

    
      mappings/DwC.self.specimens.csv
    
  





  60
  60
  
    
phylum,phylum


  		




  61
  61
  
    
Subspecies,Subspecies


  		




  62
  62
  
    
infraspecificEpithet,infraspecificEpithet


  		




  63
  
  
    
Collector,Collector


  		




  64
  
  
    
recordedBy,recordedBy


  		




  65
  63
  
    
CollectionCode,CollectionCode


  		




  66
  64
  
    
collectionCode,collectionCode


  		




  67
  65
  
    
Notes,Notes


  		




  68
  66
  
    
fieldNotes,fieldNotes


  		




  
  67
  
    
Collector,Collector


  		




  
  68
  
    
recordedBy,recordedBy


  		




  69
  69
  
    
CatalogNumber,CatalogNumber


  		




  70
  70
  
    
catalogNumber,catalogNumber


  		




  71
  71
  
    
CollectorNumber,CollectorNumber


  		












  

    
      mappings/for_review/VegX-VegBIEN.organisms.csv
    
  





  82
  82
  
    
/simpleUserdefined[name=interceptCm]/value,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=interceptCm]]/definedvalue",


  		




  83
  83
  
    
/simpleUserdefined[name=lianaInfestation]/value,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=lianaInfestation]]/definedvalue",


  		




  84
  84
  
    
//note/text,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=notes]]/definedvalue",


  		




  
  85
  
    
//individualName/givenName,//aggregateoccurrence/verbatimcollectorname/_name/first,


  		




  
  86
  
    
//individualName/surName,//aggregateoccurrence/verbatimcollectorname/_name/last,


  		




  85
  87
  
    
/simpleUserdefined[name=censusNo]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=censusNo]]/definedvalue",


  		




  86
  88
  
    
/simpleUserdefined[name=growthForm]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=growthForm]]/definedvalue",


  		




  87
  89
  
    
/simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue",


  		




  ......




  106
  108
  
    
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,rank=Order]/*_id/plantconcept/*_id/*/plantname",


  		




  107
  109
  
    
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,rank=Subkingdom]/*_id/plantconcept/*_id/*/plantname",


  		




  108
  110
  
    
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,rank=Subspecies]/*_id/plantconcept/*_id/*/plantname",


  		




  109
  
  
    
//individualName/givenName,/verbatimcollectorname/_name/first,


  		




  110
  
  
    
//individualName/surName,/verbatimcollectorname/_name/last,


  		












  

    
      mappings/for_review/DwC2-VegBIEN.specimens.csv
    
  





  30
  30
  
    
specificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Species]/*_id/plantconcept/*_id/*/plantname",,149


  		




  31
  31
  
    
phylum,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Subkingdom]/*_id/plantconcept/*_id/*/plantname",,143


  		




  32
  32
  
    
infraspecificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Subspecies]/*_id/plantconcept/*_id/*/plantname",,150


  		




  33
  
  
    
recordedBy,//taxonoccurrence/verbatimcollectorname,,23


  		




  34
  33
  
    
collectionCode,/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,12


  		




  35
  34
  
    
fieldNotes,/description,,


  		




  
  35
  
    
recordedBy,/verbatimcollectorname,,23


  		




  36
  36
  
    
catalogNumber,/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  37
  37
  
    
recordNumber,/collectionnumber/_alt/1,,22


  		




  38
  38
  
    
collectionID,/collectionnumber/_alt/2,,9


  		












  

    
      mappings/DwC-VegBIEN.specimens.csv
    
  





  60
  60
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143


  		




  61
  61
  
    
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150


  		




  62
  62
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150


  		




  63
  
  
    
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  64
  
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  65
  63
  
    
CollectionCode,/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,12


  		




  66
  64
  
    
collectionCode,/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,12


  		




  67
  65
  
    
Notes,/description,,


  		




  68
  66
  
    
fieldNotes,/description,,


  		




  
  67
  
    
Collector,/verbatimcollectorname,,23


  		




  
  68
  
    
recordedBy,/verbatimcollectorname,,23


  		




  69
  69
  
    
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  70
  70
  
    
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  71
  71
  
    
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22


  		












  

    
      mappings/DwC2-VegBIEN.specimens.csv
    
  





  30
  30
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149


  		




  31
  31
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143


  		




  32
  32
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150


  		




  33
  
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  34
  33
  
    
collectionCode,/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,12


  		




  35
  34
  
    
fieldNotes,/description,,


  		




  
  35
  
    
recordedBy,/verbatimcollectorname,,23


  		




  36
  36
  
    
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  37
  37
  
    
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22


  		




  38
  38
  
    
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9


  		












Also available in:  Unified diff