Project

General

Profile

« Previous | Next » 

Revision 7816

mappings/VegCore.htm: Regenerated from wiki. Split specimenIndexer into specimenStampingInstitution and specimenDonor (which are often the same).

View differences:

inputs/UNCC/Specimen/map.csv
8 8
GROUP BY herbarium, accession
9 9
HAVING count(*) > 1
10 10
-----"
11
herbarium,specimenIndexer,"/_map:[UNCCD=UNCC,*=*]/value","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
11
herbarium,specimenDonor,"/_map:[UNCCD=UNCC,*=*]/value","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
12 12
family,family,,
13 13
genus,genus,,
14 14
species,specificEpithet,,
inputs/UNCC/Specimen/VegBIEN.csv
124 124
filler,,"** No join mapping for *filler ** Where used, same as family"
125 125
flower,,** No join mapping for *flower ** 
126 126
fruit,,** No join mapping for *fruit ** 
127
herbarium,,"** No join mapping for specimenIndexer/_map:[UNCCD=UNCC,*=*]/value ** ""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
127
herbarium,,"** No join mapping for specimenDonor/_map:[UNCCD=UNCC,*=*]/value ** ""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
128 128
leaves,,** No join mapping for *leaves ** 
129 129
root,,** No join mapping for *root ** 
130 130
sheetno,,** No join mapping for associatedMedia ** ?
inputs/UNCC/Specimen/new_terms.csv
1
herbarium,specimenIndexer,"/_map:[UNCCD=UNCC,*=*]/value","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
1
herbarium,specimenDonor,"/_map:[UNCCD=UNCC,*=*]/value","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
2 2
usdaRank,taxonRank,/_alt/1,
3 3
infrarank,taxonRank,/_alt/2,
4 4
infraname,infraspecificEpithet,,
inputs/UNCC/Specimen/unmapped_terms.csv
1
specimenIndexer
1
specimenDonor
2 2
*leaves
3 3
*flower
4 4
*fruit
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="rF6y+b/hwfyNqb2wL8FWEtup399P4yqM6a3XL7tgqyE=" name="csrf-token" />
9
<meta content="a3sYOjwaHdaCUDhUql/JF8MYcx9u9BXVOFJBQgtnRfc=" 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" />
......
142 142
</li><li><a href="#realLongitude">realLongitude</a><ul><li><a href="#Replace-with-PRIVATE-2">Replace with: PRIVATE</a></li></ul>
143 143
</li><li><a href="#verbatimCoordinates">verbatimCoordinates</a></li><li><a href="#coordinateUnits">coordinateUnits</a><ul><li><a href="#verbatimCoordinateSystem-DwC">?verbatimCoordinateSystem  DwC</a></li></ul>
144 144
</li><li><a href="#verbatimCoordinateSystem">?verbatimCoordinateSystem</a><ul><li><a href="#Alternative-coordinateUnits">Alternative: coordinateUnits</a></li><li><a href="#Alternative-geodeticDatum">Alternative: geodeticDatum</a></li></ul>
145
</li><li><a href="#verbatimSRS">verbatimSRS</a></li><li><a href="#geodeticDatum">geodeticDatum</a><ul><li><a href="#-verbatimCoordinateSystem">: ?verbatimCoordinateSystem</a></li></ul>
145
</li><li><a href="#verbatimSRS">verbatimSRS</a></li><li><a href="#geodeticDatum">geodeticDatum</a><ul><li><a href="#verbatimCoordinateSystem-conference-call-on-2013-2-28">?verbatimCoordinateSystem  conference call on 2013-2-28</a></li></ul>
146 146
</li><li><a href="#coordinateUncertainty">?coordinateUncertainty</a><ul><li><a href="#coordinatePrecision">?coordinatePrecision</a></li><li><a href="#coordinateUncertaintyInMeters">coordinateUncertaintyInMeters</a></li><li><a href="#coordinatePrecision_deg">coordinatePrecision_deg</a></li></ul>
147 147
</li><li><a href="#pointRadiusSpatialFit">pointRadiusSpatialFit</a></li><li><a href="#footprintWKT">footprintWKT</a><ul><li><a href="#boundingBox">boundingBox</a></li><li><a href="#shapeOfSite">shapeOfSite</a></li></ul>
148 148
</li><li><a href="#footprintSRS">footprintSRS</a></li><li><a href="#footprintSpatialFit">footprintSpatialFit</a></li><li><a href="#georeferencedBy">georeferencedBy</a></li><li><a href="#georeferencedDate">georeferencedDate</a></li><li><a href="#georeferenceProtocol">georeferenceProtocol</a><ul><li><a href="#georeferenceProtocol_bien">georeferenceProtocol_bien</a></li></ul>
......
299 299
</li><li><a href="#Specimen">Specimen</a><ul><li><a href="#specimenHolders">specimenHolders</a><ul><li><a href="#specimenHolder">specimenHolder</a></li><li><a href="#institutionCode_DwC">institutionCode_DwC</a></li></ul>
300 300
</li><li><a href="#specimenHolderURL">specimenHolderURL</a><ul><li><a href="#institutionID">institutionID</a></li></ul>
301 301
</li><li><a href="#institutionCode">?institutionCode</a><ul><li><a href="#Alternative-institutionCode_DwC">Alternative: institutionCode_DwC</a></li><li><a href="#Alternative-institutionCode_UNCC">Alternative: institutionCode_UNCC</a></li></ul>
302
</li><li><a href="#specimenIndexer">specimenIndexer</a><ul><li><a href="#specimenDonor">specimenDonor</a></li><li><a href="#institutionCode_UNCC">institutionCode_UNCC</a></li></ul>
302
</li><li><a href="#specimenStampingInstitution">specimenStampingInstitution</a></li><li><a href="#specimenDonor">specimenDonor</a><ul><li><a href="#institutionCode_UNCC">institutionCode_UNCC</a></li></ul>
303 303
</li><li><a href="#specimenOwner">specimenOwner</a><ul><li><a href="#ownerInstitutionCode">ownerInstitutionCode</a></li></ul>
304 304
</li><li><a href="#barcode">barcode</a></li><li><a href="#accessionNumber">accessionNumber</a><ul><li><a href="#accession">accession</a></li><li><a href="#museumAccessionNumber">museumAccessionNumber</a></li><li><a href="#catalogNumber">catalogNumber</a></li></ul>
305 305
</li><li><a href="#collectorNumber">collectorNumber</a><ul><li><a href="#collectionNumber">collectionNumber</a></li><li><a href="#recordNumber">recordNumber</a></li><li><a href="#fieldNumber_DwC_classic">fieldNumber_DwC_classic</a></li></ul>
......
1202 1202
<h2  style="padding-left:2em;"><a href="#geodeticDatum" class="wiki-page">geodeticDatum</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://rs.tdwg.org/dwc/terms/#geodeticDatum"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#geodeticDatum" class="wiki-anchor">&para;</a></h2>
1203 1203

  
1204 1204

  
1205
	<a name="-verbatimCoordinateSystem"></a>
1206
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0 3pt 0.65em;font-weight: normal;" title="Synonym" alt="Synonym" />: <a href="#verbatimCoordinateSystem" class="wiki-page">?verbatimCoordinateSystem</a><a href="#-verbatimCoordinateSystem" class="wiki-anchor">&para;</a></h3>
1205
	<a name="verbatimCoordinateSystem-conference-call-on-2013-2-28"></a>
1206
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#verbatimCoordinateSystem" class="wiki-page">?verbatimCoordinateSystem</a> <img src="_" style="padding: 0 0 3pt 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/2013-02-28_conference_call#ARIZ" class="external">conference call on 2013-2-28</a><a href="#verbatimCoordinateSystem-conference-call-on-2013-2-28" class="wiki-anchor">&para;</a></h3>
1207 1207

  
1208 1208

  
1209 1209
	<a name="coordinateUncertainty"></a>
......
3737 3737
<h3  style="padding-left:5em;">Alternative: <a href="#institutionCode_UNCC" class="wiki-page">institutionCode_UNCC</a><a href="#Alternative-institutionCode_UNCC" class="wiki-anchor">&para;</a></h3>
3738 3738

  
3739 3739

  
3740
	<a name="specimenIndexer"></a>
3741
<h2  style="padding-left:2em;"><a href="#specimenIndexer" class="wiki-page">specimenIndexer</a> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Global_IDs"><img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;font-style: italic;" title="global ID" alt="global ID" /></a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode/institution_that_donated_collection"><img src="_" style="font-size: small;" title="Bob Peet" alt="Bob Peet" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/626/vegbien_identifiers.xlsx#terms/institutionCode/acronym_that_sent_specimen"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#specimenIndexer" class="wiki-anchor">&para;</a></h2>
3740
	<a name="specimenStampingInstitution"></a>
3741
<h2  style="padding-left:2em;"><a href="#specimenStampingInstitution" class="wiki-page">specimenStampingInstitution</a> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Global_IDs"><img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;font-style: italic;" title="global ID" alt="global ID" /></a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode/institution_that_donated_collection"><img src="_" style="font-size: small;" title="Bob Peet" alt="Bob Peet" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/626/vegbien_identifiers.xlsx#terms/institutionCode/acronym_that_sent_specimen"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#specimenStampingInstitution" class="wiki-anchor">&para;</a></h2>
3742 3742

  
3743 3743

  
3744 3744
	<p style="padding-left:5em;">The institution that stamped an <a href="#accessionNumber" class="wiki-page">accession number</a> or <a href="#barcode" class="wiki-page">barcode</a> on the specimen</p>
3745 3745

  
3746 3746

  
3747
	<p style="padding-left:5em;">"The name or acronym in use by the institution that donated the collection" (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode" class="external">Bob Peet</a>)<br />"the acronym [of the donor institution] that sent [...] the specimen if it was an exchange or trade" (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/626/vegbien_identifiers.xlsx#terms/institutionCode/acronym_that_sent_specimen" class="external">Brad Boyle</a>)</p>
3747
	<a name="specimenDonor"></a>
3748
<h2  style="padding-left:2em;"><a href="#specimenDonor" class="wiki-page">specimenDonor</a> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Global_IDs"><img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;font-style: italic;" title="global ID" alt="global ID" /></a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode/institution_that_donated_collection"><img src="_" style="font-size: small;" title="Bob Peet" alt="Bob Peet" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/626/vegbien_identifiers.xlsx#terms/institutionCode/acronym_that_sent_specimen"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#specimenDonor" class="wiki-anchor">&para;</a></h2>
3748 3749

  
3749 3750

  
3750
	<a name="specimenDonor"></a>
3751
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#specimenDonor" class="wiki-page">specimenDonor</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode/institution_that_donated_collection"><img src="_" style="font-size: small;" title="Bob Peet" alt="Bob Peet" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/626/vegbien_identifiers.xlsx#terms/institutionCode/acronym_that_sent_specimen"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#specimenDonor" class="wiki-anchor">&para;</a></h3>
3751
	<p style="padding-left:5em;">"The name or acronym in use by the institution that donated the collection" (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode" class="external">Bob Peet</a>)<br />"the acronym [of the donor institution] that sent [...] the specimen if it was an exchange or trade" (<a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/626/vegbien_identifiers.xlsx#terms/institutionCode/acronym_that_sent_specimen" class="external">Brad Boyle</a>)</p>
3752 3752

  
3753 3753

  
3754 3754
	<a name="institutionCode_UNCC"></a>
mappings/VegCore.thesaurus.csv
27 27
?globalUniqueIdentifier,"?occurrenceID,dataProviderRecordID"
28 28
?height,"?height_m,height_ft"
29 29
?heightFirstBranch,"?heightFirstBranch_m,heightFirstBranch_ft"
30
?institutionCode,"?specimenHolders,specimenIndexer"
30
?institutionCode,"?specimenHolders,specimenDonor"
31 31
?intercept,"?intercept_m,intercept_cm"
32 32
?latitude,"?decimalLatitude,verbatimLatitude,latitude_DMS"
33 33
?longitude,"?decimalLongitude,verbatimLongitude,longitude_DMS"
......
137 137
individualOrganismObservationRelativeX,organismX_m
138 138
individualOrganismObservationRelativeY,organismY_m
139 139
institutionCode_DwC,specimenHolders
140
institutionCode_UNCC,specimenIndexer
140
institutionCode_UNCC,specimenDonor
141 141
institutionID,specimenHolderURL
142 142
interpretationType,identificationType
143 143
isBadLatLong,latLongDomainInvalid
......
202 202
species_DwC,specificEpithet
203 203
species_VegBank,speciesBinomial
204 204
specificEpithetScore,matchedSpeciesConfidence_fraction
205
specimenDonor,specimenIndexer
206 205
specimenHolder,specimenHolders
207 206
ssp,subspecies
208 207
startX,subplotX
mappings/VegCore.vocab.csv
563 563
specimenHolder
564 564
specimenHolderURL
565 565
specimenHolders
566
specimenIndexer
567 566
specimenOwner
567
specimenStampingInstitution
568 568
ssp
569 569
startDate
570 570
startDayOfYear

Also available in: Unified diff