Project

General

Profile

« Previous | Next » 

Revision 7407

Added by Aaron Marcuse-Kubitza almost 12 years ago

mappings/VegCore.csv: Regenerated from wiki. This adds Brad's DwC ID terms and their definitions in <https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx&gt;.

View differences:

inputs/NCU/Specimen/new_terms.csv
5 5 
CurrentScientificName,taxonName,,
6 6 
CurrentScientificNameWithAuthor,scientificName,,
7 7 
CollectionDate,dateCollected,,
8 
BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
9 8 
CatalogSeriesPrefix,institutionCode,/_alt/1,
10 9 
Description,fieldNotes,,
11 10 
CityLocality,verbatimLocality,/_alt/2,
inputs/U/Specimen/new_terms.csv
1 
Barcode,catalogNumber,,
2 1 
Number,recordNumber,,
3 2 
Addcoll,recordedBy,/_join/2,
4 3 
Colldd,dayCollected,,
inputs/UNCC/Specimen/new_terms.csv
1 
accession,catalogNumber,,"Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.
2 

  		




  3
  
  
    
[1] Using the following query:


  		




  4
  
  
    
-----


  		




  5
  
  
    
SELECT herbarium, accession, count(*)


  		




  6
  
  
    
FROM ""UNCC"".""Specimen""


  		




  7
  
  
    
GROUP BY herbarium, accession


  		




  8
  
  
    
HAVING count(*) > 1


  		




  9
  
  
    
-----"


  		




  10
  1
  
    
herbarium,institutionCode,,


  		




  11
  2
  
    
usdaRank,taxonRank,/_alt/1,


  		




  12
  3
  
    
infrarank,taxonRank,/_alt/2,


  		












  

    
      inputs/CVS/taxonObservation_/new_terms.csv
    
  





  2
  2
  
    
stemLocation_ID,stemID,,


  		




  3
  3
  
    
interpretationDate,dateIdentified,,


  		




  4
  4
  
    
collectionDate,dateCollected,,


  		




  5
  
  
    
museumAccessionNumber,catalogNumber,,


  		




  6
  5
  
    
givenName,recordedBy_givenName,,


  		




  7
  6
  
    
surName,recordedBy_surName,,


  		




  8
  7
  
    
plantname,taxonName,,


  		












  

    
      inputs/REMIB/Specimen/new_terms.csv
    
  





  1
  1
  
    
acronym,institutionCode,,


  		




  2
  
  
    
accession_number,catalogNumber,,"Not globally unique, only (usually) unique within the institution providing the data (""acronym""). Note that there are nevertheless 11,869 rows where an accession_number appears multiple times within the same institution. [1]


  		




  3
  
  
    

  		




  4
  
  
    
[1] Using the following query:


  		




  5
  
  
    
-----


  		




  6
  
  
    
SELECT acronym, accession_number, count(*)


  		




  7
  
  
    
FROM ""REMIB"".""Specimen""


  		




  8
  
  
    
GROUP BY acronym, accession_number


  		




  9
  
  
    
HAVING count(*) > 1


  		




  10
  
  
    
-----"


  		




  11
  2
  
    
long_deg,decimalLongitude,,


  		




  12
  3
  
    
lat_deg,decimalLatitude,,


  		




  13
  4
  
    
coll_day,dayCollected,,


  		












  

    
      inputs/VegBank/taxonobservation_/new_terms.csv
    
  





  1
  1
  
    
observation_id,eventID,,


  		




  2
  
  
    
museumaccessionnumber,catalogNumber,,


  		




  3
  2
  
    
interpretationdate,dateIdentified,,


  		




  4
  3
  
    
collectiondate,dateCollected,,


  		




  5
  4
  
    
givenname,recordedBy_givenName,,


  		












  

    
      mappings/VegCore.htm
    
  





  6
  6
  
    
<meta name="description" content="Redmine" />


  		




  7
  7
  
    
<meta name="keywords" content="issue,bug,tracker" />


  		




  8
  8
  
    
<meta content="authenticity_token" name="csrf-param" />


  		




  9
  
  
    
<meta content="C3qQ1qdeUsMWbOwAzhgHpkHnRAIHCsjDG5HxC+j4Ckg=" name="csrf-token" />


  		




  
  9
  
    
<meta content="5A0RN3J7hBDJ8H/G6xyEHSUGEoScW3xKHXhCWZsGLK8=" name="csrf-token" />


  		




  10
  10
  
    
<link rel='shortcut icon' href='/nceas/favicon.ico?1347421715' />


  		




  11
  11
  
    
<link href="/nceas/stylesheets/jquery/jquery-ui-1.8.21.css?1357775071" media="all" rel="stylesheet" type="text/css" />


  		




  12
  12
  
    
<link href="/nceas/stylesheets/application.css?1357775071" media="all" rel="stylesheet" type="text/css" />


  		




  ......




  146
  146
  
    
</li><li><a href="#accessRights">accessRights</a><ul><li><a href="#dcterms_accessRights">dcterms_accessRights</a></li></ul>


  		




  147
  147
  
    
</li><li><a href="#bibliographicCitation">bibliographicCitation</a><ul><li><a href="#dcterms_bibliographicCitation">dcterms_bibliographicCitation</a></li></ul>


  		




  148
  148
  
    
</li><li><a href="#references">references</a><ul><li><a href="#dcterms_references">dcterms_references</a></li></ul>


  		




  149
  
  
    
</li><li><a href="#institutionID">institutionID</a></li><li><a href="#collectionID">collectionID</a></li><li><a href="#datasetID">datasetID</a></li><li><a href="#institutionCode">institutionCode</a></li><li><a href="#collectionCode">collectionCode</a></li><li><a href="#datasetName">datasetName</a></li><li><a href="#ownerInstitutionCode">ownerInstitutionCode</a></li><li><a href="#basisOfRecord">basisOfRecord</a></li><li><a href="#informationWithheld">informationWithheld</a></li><li><a href="#dataGeneralizations">dataGeneralizations</a></li><li><a href="#dynamicProperties">dynamicProperties</a></li></ul>


  		




  
  149
  
    
</li><li><a href="#institutionID">institutionID</a></li><li><a href="#collectionID">collectionID</a></li><li><a href="#datasetID">datasetID</a></li><li><a href="#institutionCode">institutionCode</a></li><li><a href="#collectionCode">collectionCode</a></li><li><a href="#datasetName">datasetName</a><ul><li><a href="#dataset">dataset</a></li></ul>


  		




  
  150
  
    
</li><li><a href="#ownerInstitutionCode">ownerInstitutionCode</a></li><li><a href="#basisOfRecord">basisOfRecord</a></li><li><a href="#informationWithheld">informationWithheld</a></li><li><a href="#dataGeneralizations">dataGeneralizations</a></li><li><a href="#dynamicProperties">dynamicProperties</a></li></ul>


  		




  150
  151
  
    
</li><li><a href="#Method">Method</a><ul><li><ul><li><a href="#SamplingProtocol">SamplingProtocol</a></li></ul>


  		




  151
  152
  
    
</li><li><a href="#samplingProtocolID">samplingProtocolID</a></li><li><a href="#samplingProtocol">samplingProtocol</a></li><li><a href="#samplingEffort">samplingEffort</a></li><li><a href="#observationType">observationType</a></li><li><a href="#observationMeasure">observationMeasure</a><ul><li><a href="#SALVIAS_observationType">SALVIAS_observationType</a></li></ul>


  		




  152
  153
  
    
</li></ul>


  		




  ......




  192
  193
  
    
</li><li><a href="#Community">Community</a><ul><li><a href="#communityID">communityID</a></li><li><a href="#communityName">communityName</a><ul><li><a href="#communityConceptName">communityConceptName</a></li></ul>


  		




  193
  194
  
    
</li></ul>


  		




  194
  195
  
    
</li><li><a href="#Occurrence">Occurrence</a><ul><li><ul><li><a href="#Observation">Observation</a></li></ul>


  		




  195
  
  
    
</li><li><a href="#occurrenceID">occurrenceID</a></li><li><a href="#occurrenceRemarks">occurrenceRemarks</a></li><li><a href="#recordNumber">recordNumber</a></li><li><a href="#recordedBy">recordedBy</a></li><li><a href="#recordedBy_givenName">recordedBy_givenName</a></li><li><a href="#recordedBy_surName">recordedBy_surName</a></li><li><a href="#recordedBy_middleName">recordedBy_middleName</a></li><li><a href="#individualID">individualID</a></li><li><a href="#individualCount">individualCount</a></li><li><a href="#sex">sex</a></li><li><a href="#lifeStage">lifeStage</a></li><li><a href="#reproductiveCondition">reproductiveCondition</a><ul><li><a href="#phenology">phenology</a></li></ul>


  		




  
  196
  
    
</li><li><a href="#occurrenceID">occurrenceID</a></li><li><a href="#datasetRecordID">datasetRecordID</a></li><li><a href="#datasourceRecordID">datasourceRecordID</a></li><li><a href="#occurrenceRemarks">occurrenceRemarks</a></li><li><a href="#recordNumber">recordNumber</a></li><li><a href="#recordedBy">recordedBy</a></li><li><a href="#recordedBy_givenName">recordedBy_givenName</a></li><li><a href="#recordedBy_surName">recordedBy_surName</a></li><li><a href="#recordedBy_middleName">recordedBy_middleName</a></li><li><a href="#individualID">individualID</a></li><li><a href="#individualCount">individualCount</a></li><li><a href="#sex">sex</a></li><li><a href="#lifeStage">lifeStage</a></li><li><a href="#reproductiveCondition">reproductiveCondition</a><ul><li><a href="#phenology">phenology</a></li></ul>


  		




  196
  197
  
    
</li><li><a href="#behavior">behavior</a></li><li><a href="#establishmentMeans">establishmentMeans</a></li><li><a href="#cultivated">cultivated</a><ul><li><a href="#cultivated_bien">cultivated_bien</a></li></ul>


  		




  197
  198
  
    
</li><li><a href="#cultivatedBasis">cultivatedBasis</a><ul><li><a href="#cultivatedBasis_bien">cultivatedBasis_bien</a></li></ul>


  		




  198
  199
  
    
</li><li><a href="#occurrenceStatus">occurrenceStatus</a></li><li><a href="#previousIdentifications">previousIdentifications</a></li><li><a href="#associatedMedia">associatedMedia</a></li><li><a href="#associatedReferences">associatedReferences</a></li><li><a href="#associatedOccurrences">associatedOccurrences</a></li><li><a href="#associatedSequences">associatedSequences</a></li><li><a href="#associatedTaxa">associatedTaxa</a></li></ul>


  		




  ......




  246
  247
  
    
</li><li><a href="#diameterBreastHeight_cm">diameterBreastHeight_cm</a></li><li><a href="#diameterBreastHeight_in">diameterBreastHeight_in</a></li><li><a href="#diameterBreastHeight_m">diameterBreastHeight_m</a></li><li><a href="#diameterBreastHeightGentry">diameterBreastHeightGentry</a><ul><li><a href="#gentryDbh">gentryDbh</a></li></ul>


  		




  247
  248
  
    
</li><li><a href="#basalDiameter">basalDiameter</a><ul><li><a href="#basalDiam">basalDiam</a></li></ul>


  		




  248
  249
  
    
</li><li><a href="#stemNotes">stemNotes</a></li></ul>


  		




  249
  
  
    
</li><li><a href="#Specimen">Specimen</a><ul><li><a href="#catalogNumber">catalogNumber</a></li><li><a href="#preparations">preparations</a></li><li><a href="#disposition">disposition</a></li><li><a href="#otherCatalogNumbers">otherCatalogNumbers</a></li></ul>


  		




  
  250
  
    
</li><li><a href="#Specimen">Specimen</a><ul><li><a href="#barcode">barcode</a></li><li><a href="#catalogNumber">catalogNumber</a><ul><li><a href="#museumAccessionNumber">museumAccessionNumber</a></li><li><a href="#accessionNumber">accessionNumber</a></li><li><a href="#accession">accession</a></li></ul>


  		




  
  251
  
    
</li><li><a href="#preparations">preparations</a></li><li><a href="#disposition">disposition</a></li><li><a href="#otherCatalogNumbers">otherCatalogNumbers</a></li></ul>


  		




  250
  252
  
    
</li><li><a href="#Voucher">Voucher</a><ul><li><a href="#voucherType">voucherType</a><ul><li><a href="#detType">detType</a></li></ul>


  		




  251
  253
  
    
</li></ul>


  		




  252
  254
  
    
</li><li><a href="#Measurement">Measurement</a><ul><li><ul><li><a href="#MeasurementOrFact">MeasurementOrFact</a></li><li><a href="#TraitObservation">TraitObservation</a></li><li><a href="#Trait">Trait</a></li></ul>


  		




  ......




  255
  257
  
    
</li><li><a href="#measurementAccuracy">measurementAccuracy</a></li><li><a href="#measurementUnit">measurementUnit</a><ul><li><a href="#unit">unit</a></li></ul>


  		




  256
  258
  
    
</li><li><a href="#measurementDeterminedDate">measurementDeterminedDate</a></li><li><a href="#measurementDeterminedBy">measurementDeterminedBy</a></li><li><a href="#measurementMethod">measurementMethod</a></li><li><a href="#measurementRemarks">measurementRemarks</a></li></ul>


  		




  257
  259
  
    
</li><li><a href="#ResourceRelationship">ResourceRelationship</a><ul><li><a href="#resourceRelationshipID">resourceRelationshipID</a></li><li><a href="#resourceID">resourceID</a></li><li><a href="#relatedResourceID">relatedResourceID</a></li><li><a href="#relationshipOfResource">relationshipOfResource</a></li><li><a href="#relationshipAccordingTo">relationshipAccordingTo</a></li><li><a href="#relationshipEstablishedDate">relationshipEstablishedDate</a></li><li><a href="#relationshipRemarks">relationshipRemarks</a></li></ul>


  		




  258
  
  
    
</li><li><a href="#See-also">See also</a><ul><li><ul><li><a href="#Regenerating-the-VegCore-terms-list">Regenerating the VegCore terms list</a></li></ul></li></ul></li></ul>


  		




  
  260
  
    
</li><li><a href="#Changes-from-other-formats">Changes from other formats</a></li><li><a href="#See-also">See also</a><ul><li><ul><li><a href="#Regenerating-the-VegCore-terms-list">Regenerating the VegCore terms list</a></li></ul></li></ul></li></ul>


  		




  259
  261
  
    

  		




  260
  262
  
    

  		




  261
  263
  
    
	<a name="Namespaces"></a>


  		




  ......




  378
  380
  
    
<h2  style="padding-left:2em;"><a href="#datasource" class="wiki-page">datasource</a><a href="#datasource" class="wiki-anchor">&para;</a></h2>


  		




  379
  381
  
    

  		




  380
  382
  
    

  		




  
  383
  
    
	<p style="padding-left:5em;">"Internal BIEN string. Uniquely identifies the person on institution that provided the data to BIEN (the <strong>proximate</strong> data provider). This could be an aggregator (such as GBIF or SALVIAS) or an original source (a herbarium such as ARIZ)." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/datasource" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  384
  
    

  		




  
  385
  
    

  		




  381
  386
  
    
	<p style="padding-left:5em;">Synonyms:</p>


  		




  382
  387
  
    

  		




  383
  388
  
    

  		




  ......




  558
  563
  
    
<h2  style="padding-left:2em;"><a href="#institutionCode" class="wiki-page">institutionCode</a><a href="#institutionCode" class="wiki-anchor">&para;</a></h2>


  		




  559
  564
  
    

  		




  560
  565
  
    

  		




  
  566
  
    
	<p style="padding-left:5em;">"Identifies the institution where a specimen is held. For herbaria, this will be the acronym of the herbarium. In general, use the verbatim value provided by the data provider, unless this is incorrect. For an aggregator such as GBIF, this column will contain many values corresponding to different data providers. For a primary source (e.g., New York Botanical Garden), all values should be the same (e.g., "NY"). Some herbaria incorrectly list the acronym that sent them the specimen if it was an exchange or trade. This is incorrect. Only the acronym of the herbarium providing the data should be listed here, regardless of whether they collected the specimen themselves or received it as a duplicate from another herbarium." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/institutionCode" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  567
  
    

  		




  
  568
  
    

  		




  561
  569
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#institutionCode" class="external">DwC</a></p>


  		




  562
  570
  
    

  		




  563
  571
  
    

  		




  ......




  565
  573
  
    
<h2  style="padding-left:2em;"><a href="#collectionCode" class="wiki-page">collectionCode</a><a href="#collectionCode" class="wiki-anchor">&para;</a></h2>


  		




  566
  574
  
    

  		




  567
  575
  
    

  		




  
  576
  
    
	<p style="padding-left:5em;">"Identifies the collection within the institution where a specimen is held. This is not an important field for herbaria because the herbarium acronym (institutionCode) is already globally unique. Herbaria typically use a word describing the type of collection, such as "herbarium", although I have also seen the acronym repeated here. Needed for animal collections where institutionCode is the name of a university and collectionCode distinguishes one of several collections (e.g., institutionCode="University of Colorado", collectionCode="Mammals"). In general, use whatever the data provider provides, unless badly formed." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  577
  
    

  		




  
  578
  
    

  		




  568
  579
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#collectionCode" class="external">DwC</a></p>


  		




  569
  580
  
    

  		




  570
  581
  
    

  		




  ......




  572
  583
  
    
<h2  style="padding-left:2em;"><a href="#datasetName" class="wiki-page">datasetName</a><a href="#datasetName" class="wiki-anchor">&para;</a></h2>


  		




  573
  584
  
    

  		




  574
  585
  
    

  		




  
  586
  
    
	<p style="padding-left:5em;">"Internal BIEN string. Uniquely identifies a dataset belonging to a designated primary data owner, either a person or an institution. For a specimen record provided to BIEN by an aggregator, datasource<>(dataset=institutionCode). For a specimen record provided to BIEN by the herbarium which holds that specimen, datasource= dataset =institutionCode. For a plot provided by the data owner, datasource= dataset <>(institutionCode=NULL). For a plot provided by an aggregator, datasource<> dataset <>(institutionCode=NULL)." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/dataset" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  587
  
    

  		




  
  588
  
    

  		




  575
  589
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#datasetName" class="external">DwC</a></p>


  		




  576
  590
  
    

  		




  577
  591
  
    

  		




  
  592
  
    
	<p style="padding-left:5em;">Synonyms:</p>


  		




  
  593
  
    

  		




  
  594
  
    

  		




  
  595
  
    
	<a name="dataset"></a>


  		




  
  596
  
    
<h3  style="padding-left:7em;"><a href="#dataset" class="wiki-page">dataset</a><a href="#dataset" class="wiki-anchor">&para;</a></h3>


  		




  
  597
  
    

  		




  
  598
  
    

  		




  
  599
  
    
	<p style="padding-left:9em;">From: <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/dataset" class="external">Brad's DwC ID terms</a></p>


  		




  
  600
  
    

  		




  
  601
  
    

  		




  578
  602
  
    
	<a name="ownerInstitutionCode"></a>


  		




  579
  603
  
    
<h2  style="padding-left:2em;"><a href="#ownerInstitutionCode" class="wiki-page">ownerInstitutionCode</a><a href="#ownerInstitutionCode" class="wiki-anchor">&para;</a></h2>


  		




  580
  604
  
    

  		




  ......




  2413
  2437
  
    
<h3  style="padding-left:5em;"><a href="#Observation" class="wiki-page">Observation</a><a href="#Observation" class="wiki-anchor">&para;</a></h3>


  		




  2414
  2438
  
    

  		




  2415
  2439
  
    

  		




  2416
  
  
    
	<p style="padding-left:7em;">See also: <a href="#VegBank_Observation" class="wiki-page">VegBank_Observation</a></p>


  		




  
  2440
  
    
	<p style="padding-left:7em;">Compare to: <a href="#VegBank_Observation" class="wiki-page">VegBank_Observation</a></p>


  		




  2417
  2441
  
    

  		




  2418
  2442
  
    

  		




  2419
  2443
  
    
	<p style="padding-left:7em;">Name from: <a href="http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&#38;wparam=observation&#38;entity=dba_tabledescription&#38;where=where_tablename" class="external">VegBank</a></p>


  		




  ......




  2423
  2447
  
    
<h2  style="padding-left:2em;"><a href="#occurrenceID" class="wiki-page">occurrenceID</a><a href="#occurrenceID" class="wiki-anchor">&para;</a></h2>


  		




  2424
  2448
  
    

  		




  2425
  2449
  
    

  		




  
  2450
  
    
	<p style="padding-left:5em;">"A globally unique identifier for the specimen or observation, formed by combining the [...] unique identifier of the collection with the locally unique identifier of the specimen. For specimens, construct as follows: "urn:catalog:[institutionCode]:[collectionCode]:[catalogNumber]".  If a properly formed occurrenceID is provided by the data provider, use it. For plots, construct as follows: "urn:observation:[datasource]:[dataset]:[catalogNumber]. Replace any spaces in dataset name with hyphens." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/occurrenceID" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  2451
  
    

  		




  
  2452
  
    

  		




  2426
  2453
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#occurrenceID" class="external">DwC</a></p>


  		




  2427
  2454
  
    

  		




  2428
  2455
  
    

  		




  
  2456
  
    
	<a name="datasetRecordID"></a>


  		




  
  2457
  
    
<h2  style="padding-left:2em;"><a href="#datasetRecordID" class="wiki-page">datasetRecordID</a><a href="#datasetRecordID" class="wiki-anchor">&para;</a></h2>


  		




  
  2458
  
    

  		




  
  2459
  
    

  		




  
  2460
  
    
	<p style="padding-left:5em;">"Unique ID (database primary key) for the specimen or observation in the dataset, if provided." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/datasetRecordID" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  2461
  
    

  		




  
  2462
  
    

  		




  
  2463
  
    
	<p style="padding-left:5em;">From: <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/datasetRecordID" class="external">Brad's DwC ID terms</a></p>


  		




  
  2464
  
    

  		




  
  2465
  
    

  		




  
  2466
  
    
	<p style="padding-left:5em;">Related: <a href="#dataset" class="wiki-page">dataset</a></p>


  		




  
  2467
  
    

  		




  
  2468
  
    

  		




  
  2469
  
    
	<p style="padding-left:5em;">Named like: <a href="#recordNumber" class="wiki-page">recordNumber</a>, <a href="#occurrenceID" class="wiki-page">occurrenceID</a></p>


  		




  
  2470
  
    

  		




  
  2471
  
    

  		




  
  2472
  
    
	<a name="datasourceRecordID"></a>


  		




  
  2473
  
    
<h2  style="padding-left:2em;"><a href="#datasourceRecordID" class="wiki-page">datasourceRecordID</a><a href="#datasourceRecordID" class="wiki-anchor">&para;</a></h2>


  		




  
  2474
  
    

  		




  
  2475
  
    

  		




  
  2476
  
    
	<p style="padding-left:5em;">"Unique ID (primary key) within datasource database. Will be same as <a href="#datasetRecordID" class="wiki-page">datasetRecordID</a> if dataset and datasource are the same." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/datasourceRecordID" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  2477
  
    

  		




  
  2478
  
    

  		




  
  2479
  
    
	<p style="padding-left:5em;">From: <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/datasourceRecordID" class="external">Brad's DwC ID terms</a></p>


  		




  
  2480
  
    

  		




  
  2481
  
    

  		




  
  2482
  
    
	<p style="padding-left:5em;">Related: <a href="#datasource" class="wiki-page">datasource</a></p>


  		




  
  2483
  
    

  		




  
  2484
  
    

  		




  
  2485
  
    
	<p style="padding-left:5em;">Named like: <a href="#recordNumber" class="wiki-page">recordNumber</a>, <a href="#occurrenceID" class="wiki-page">occurrenceID</a></p>


  		




  
  2486
  
    

  		




  
  2487
  
    

  		




  2429
  2488
  
    
	<a name="occurrenceRemarks"></a>


  		




  2430
  2489
  
    
<h2  style="padding-left:2em;"><a href="#occurrenceRemarks" class="wiki-page">occurrenceRemarks</a><a href="#occurrenceRemarks" class="wiki-anchor">&para;</a></h2>


  		




  2431
  2490
  
    

  		




  ......




  2719
  2778
  
    
<h2  style="padding-left:2em;"><a href="#scientificName" class="wiki-page">scientificName</a><a href="#scientificName" class="wiki-anchor">&para;</a></h2>


  		




  2720
  2779
  
    

  		




  2721
  2780
  
    

  		




  
  2781
  
    
	<p style="padding-left:5em;">Taxonomic name <em>with</em> author</p>


  		




  
  2782
  
    

  		




  
  2783
  
    

  		




  2722
  2784
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#scientificName" class="external">DwC</a></p>


  		




  2723
  2785
  
    

  		




  2724
  2786
  
    

  		




  
  2787
  
    
	<p style="padding-left:5em;">Compare to: <a href="#taxonName" class="wiki-page">taxonName</a></p>


  		




  
  2788
  
    

  		




  
  2789
  
    

  		




  2725
  2790
  
    
	<a name="taxonName"></a>


  		




  2726
  2791
  
    
<h2  style="padding-left:2em;"><a href="#taxonName" class="wiki-page">taxonName</a><a href="#taxonName" class="wiki-anchor">&para;</a></h2>


  		




  2727
  2792
  
    

  		




  2728
  2793
  
    

  		




  2729
  
  
    
	<p style="padding-left:5em;">Taxonomic name without author</p>


  		




  
  2794
  
    
	<p style="padding-left:5em;">Taxonomic name <em>without</em> author</p>


  		




  2730
  2795
  
    

  		




  2731
  2796
  
    

  		




  2732
  
  
    
	<p style="padding-left:5em;">Related: <a href="#scientificName" class="wiki-page">scientificName</a></p>


  		




  
  2797
  
    
	<p style="padding-left:5em;">Compare to: <a href="#scientificName" class="wiki-page">scientificName</a></p>


  		




  2733
  2798
  
    

  		




  2734
  2799
  
    

  		




  2735
  2800
  
    
	<p style="padding-left:5em;">Named like: <a href="http://rs.tdwg.org/dwc/terms/#Taxon" class="external">DwC:Taxon</a></p>


  		




  ......




  4310
  4375
  
    
	<p style="padding-left:3em;">Related: <a href="#Occurrence" class="wiki-page">Occurrence</a></p>


  		




  4311
  4376
  
    

  		




  4312
  4377
  
    

  		




  
  4378
  
    
	<a name="barcode"></a>


  		




  
  4379
  
    
<h2  style="padding-left:2em;"><a href="#barcode" class="wiki-page">barcode</a><a href="#barcode" class="wiki-anchor">&para;</a></h2>


  		




  
  4380
  
    

  		




  
  4381
  
    

  		




  
  4382
  
    
	<p style="padding-left:5em;">"a bar code, machine-generated and glued or stamped to the specimen and recorded in the database" (e-mail from <a href="mailto:bboyleATemail.arizona.edu">Brad Boyle</a> on 2013-1-31)<br />"IF a herbarium provides a field labelled "barCode" (or similar) that value goes here, otherwise NULL. Should be locally unique within the dataset (it may also be unique within the datasource if datasource=dataset)." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/barcode" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  4383
  
    

  		




  
  4384
  
    

  		




  
  4385
  
    
	<p style="padding-left:5em;">From: <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/barCode" class="external">Brad's DwC ID terms</a>, NCU, U</p>


  		




  
  4386
  
    

  		




  
  4387
  
    

  		




  4313
  4388
  
    
	<a name="catalogNumber"></a>


  		




  4314
  4389
  
    
<h2  style="padding-left:2em;"><a href="#catalogNumber" class="wiki-page">catalogNumber</a><a href="#catalogNumber" class="wiki-anchor">&para;</a></h2>


  		




  4315
  4390
  
    

  		




  4316
  4391
  
    

  		




  
  4392
  
    
	<p style="padding-left:5em;">"an accession number stamped physically on the specimen [...] The accession number is the most widely used, but is not guaranteed to be unique because of the physical stamping process, human error, etc." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/accessionNumber" class="external">Brad's DwC ID terms</a>)<br />"Whatever the data provider provides, as long as catalogNumber is unique within the dataset. If no catalogNumber provided, use accessionNumber, but only if it is unique within the dataset. If no accession number, use datasetRecordID, else use barCode, else use datasourceRecordID. This usage differs from DwC in that catalogNumber is constrained to be unique within the dataset. It is populated for plot data as well as specimens." (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/catalogNumber" class="external">Brad's DwC ID terms</a>)</p>


  		




  
  4393
  
    

  		




  
  4394
  
    

  		




  4317
  4395
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#catalogNumber" class="external">DwC</a></p>


  		




  4318
  4396
  
    

  		




  4319
  4397
  
    

  		




  
  4398
  
    
	<p style="padding-left:5em;">Synonyms:</p>


  		




  
  4399
  
    

  		




  
  4400
  
    

  		




  
  4401
  
    
	<a name="museumAccessionNumber"></a>


  		




  
  4402
  
    
<h3  style="padding-left:7em;"><a href="#museumAccessionNumber" class="wiki-page">museumAccessionNumber</a><a href="#museumAccessionNumber" class="wiki-anchor">&para;</a></h3>


  		




  
  4403
  
    

  		




  
  4404
  
    

  		




  
  4405
  
    
	<p style="padding-left:9em;">From: <a href="http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&#38;wparam=taxoninterpretation&#38;entity=dba_tabledescription&#38;where=where_tablename#museumAccessionNumber" class="external">VegBank</a></p>


  		




  
  4406
  
    

  		




  
  4407
  
    

  		




  
  4408
  
    
	<a name="accessionNumber"></a>


  		




  
  4409
  
    
<h3  style="padding-left:7em;"><a href="#accessionNumber" class="wiki-page">accessionNumber</a><a href="#accessionNumber" class="wiki-anchor">&para;</a></h3>


  		




  
  4410
  
    

  		




  
  4411
  
    

  		




  
  4412
  
    
	<p style="padding-left:9em;">From: <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/accessionNumber" class="external">Brad's DwC ID terms</a>, REMIB</p>


  		




  
  4413
  
    

  		




  
  4414
  
    

  		




  
  4415
  
    
	<p style="padding-left:9em;">Named like: <a href="#museumAccessionNumber" class="wiki-page">museumAccessionNumber</a></p>


  		




  
  4416
  
    

  		




  
  4417
  
    

  		




  
  4418
  
    
	<a name="accession"></a>


  		




  
  4419
  
    
<h3  style="padding-left:7em;"><a href="#accession" class="wiki-page">accession</a><a href="#accession" class="wiki-anchor">&para;</a></h3>


  		




  
  4420
  
    

  		




  
  4421
  
    

  		




  
  4422
  
    
	<p style="padding-left:9em;">From: UNCC</p>


  		




  
  4423
  
    

  		




  
  4424
  
    

  		




  
  4425
  
    
	<p style="padding-left:9em;">Named like: <a href="#accessionNumber" class="wiki-page">accessionNumber</a></p>


  		




  
  4426
  
    

  		




  
  4427
  
    

  		




  4320
  4428
  
    
	<a name="preparations"></a>


  		




  4321
  4429
  
    
<h2  style="padding-left:2em;"><a href="#preparations" class="wiki-page">preparations</a><a href="#preparations" class="wiki-anchor">&para;</a></h2>


  		




  4322
  4430
  
    

  		




  ......




  4542
  4650
  
    
	<p style="padding-left:5em;">From: <a href="http://rs.tdwg.org/dwc/terms/#relationshipRemarks" class="external">DwC</a></p>


  		




  4543
  4651
  
    

  		




  4544
  4652
  
    

  		




  
  4653
  
    
	<a name="Changes-from-other-formats"></a>


  		




  
  4654
  
    
<h1 >Changes from other formats<a href="#Changes-from-other-formats" class="wiki-anchor">&para;</a></h1>


  		




  
  4655
  
    

  		




  
  4656
  
    

  		




  
  4657
  
    
	<p><strong>Brad's DwC ID terms: <a href="/nceas/attachments/download/621" class="attachment">vegbien_identifier_examples.xlsx</a></strong></p>


  		




  
  4658
  
    

  		




  
  4659
  
    

  		




  4545
  4660
  
    
	<a name="See-also"></a>


  		




  4546
  4661
  
    
<h1 >See also<a href="#See-also" class="wiki-anchor">&para;</a></h1>


  		




  4547
  4662
  
    

  		




  ......




  4566
  4681
  
    
  <span class="size">(12 KB)</span>


  		




  4567
  4682
  
    
    <span class="author">Aaron Marcuse-Kubitza, 12/05/2012 09:21 am</span>


  		




  4568
  4683
  
    
  </p>


  		




  
  4684
  
    
<p><a href="/nceas/attachments/download/621/vegbien_identifier_examples.xlsx" class="icon icon-attachment">vegbien_identifier_examples.xlsx</a>  


  		




  
  4685
  
    
  <span class="size">(28.6 KB)</span>


  		




  
  4686
  
    
    <span class="author">Aaron Marcuse-Kubitza, 01/31/2013 04:40 pm</span>


  		




  
  4687
  
    
  </p>


  		




  4569
  4688
  
    
</div>


  		




  4570
  4689
  
    

  		




  4571
  4690
  
    

  		












  

    
      mappings/VegCore.csv
    
  





  32
  32
  
    
institutionCode


  		




  33
  33
  
    
collectionCode


  		




  34
  34
  
    
datasetName


  		




  
  35
  
    
dataset


  		




  35
  36
  
    
ownerInstitutionCode


  		




  36
  37
  
    
basisOfRecord


  		




  37
  38
  
    
informationWithheld


  		




  ......




  229
  230
  
    
communityName


  		




  230
  231
  
    
communityConceptName


  		




  231
  232
  
    
occurrenceID


  		




  
  233
  
    
datasetRecordID


  		




  
  234
  
    
datasourceRecordID


  		




  232
  235
  
    
occurrenceRemarks


  		




  233
  236
  
    
recordNumber


  		




  234
  237
  
    
recordedBy


  		




  ......




  427
  430
  
    
basalDiameter


  		




  428
  431
  
    
basalDiam


  		




  429
  432
  
    
stemNotes


  		




  
  433
  
    
barcode


  		




  430
  434
  
    
catalogNumber


  		




  
  435
  
    
museumAccessionNumber


  		




  
  436
  
    
accessionNumber


  		




  
  437
  
    
accession


  		




  431
  438
  
    
preparations


  		




  432
  439
  
    
disposition


  		




  433
  440
  
    
otherCatalogNumbers


  		












Also available in:  Unified diff