GROUP BY herbarium, accession

HAVING count(*) > 1

-----"

family,family,,

genus,genus,,

species,specificEpithet,,

state,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,

state,/location/locationplace/*_id/place/stateprovince,

filler,,"** No join mapping for *filler ** Where used, same as family"

leaves,,** No join mapping for *leaves ** 

root,,** No join mapping for *root ** 

sheetno,,** No join mapping for associatedMedia ** ?

usdaRank,taxonRank,/_alt/1,

infrarank,taxonRank,/_alt/2,

infraname,infraspecificEpithet,,

*leaves

*root

associatedMedia

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

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

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

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

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

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

</li><li><a href="#Specimen">Specimen</a><ul><li><a href="#specimenHolderInstitutions">specimenHolderInstitutions</a><ul><li><a href="#specimenHolderInstitution">specimenHolderInstitution</a></li><li><a href="#institutionCode_DwC">institutionCode_DwC</a></li></ul>

</li><li><a href="#specimenHolderURL">specimenHolderURL</a><ul><li><a href="#institutionID">institutionID</a></li></ul>

</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>

</li><li><a href="#specimenOwner">specimenOwner</a><ul><li><a href="#ownerInstitutionCode">ownerInstitutionCode</a></li></ul>

</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>

</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>

	<a name="phenology"></a>

	<a name="behavior"></a>

	<p style="padding-left:3em;">Related: <a href="#Stem" class="wiki-page">Stem</a>, <a href="#IndividualObservation" class="wiki-page">IndividualObservation</a></p>

	<a name="authorStemCode"></a>

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

	<p style="padding-left:3em;">A "part of a plant" (<a href="http://en.wikipedia.org/wiki/Specimen" class="external">Wikipedia</a>) which was collected from it</p>

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

<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#institutionCode_DwC" class="wiki-page">institutionCode_DwC</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/#institutionCode"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="alternative of" alt="alternative of" /> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore#institutionCode"><img src="_" style="font-size: small;" title="?institutionCode" alt="?institutionCode" /></a><a href="#institutionCode_DwC" class="wiki-anchor">&para;</a></h3>

	<a name="specimenHolderURL"></a>

	<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>

	<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>

?globalUniqueIdentifier,"?occurrenceID,dataProviderRecordID"

?height,"?height_m,height_ft"

?heightFirstBranch,"?heightFirstBranch_m,heightFirstBranch_ft"

?intercept,"?intercept_m,intercept_cm"

?latitude,"?decimalLatitude,verbatimLatitude,latitude_DMS"

?longitude,"?decimalLongitude,verbatimLongitude,longitude_DMS"

individualOrganismObservationRelativeX,organismX_m

individualOrganismObservationRelativeY,organismY_m

institutionCode_DwC,specimenHolderInstitutions

institutionID,specimenHolderURL

interpretationType,identificationType

isBadLatLong,latLongDomainInvalid

specificEpithet

specificEpithetScore

specimenDescription

specimenHolderInstitution

specimenHolderInstitutions

specimenHolderURL