dwc_geospatial_VerbatimLongitude,DUPLICATE#of:verbatimLongitude#dwc_geospatial_VerbatimLongitude,,exact duplicate

http__purl_org_dc_terms_modified,modified,,

dwc_terms_collectionID,collectionURL,,

dwc_terms_collectionCode,collection,,

dwc_terms_basisOfRecord,basisOfRecord,,

dwc_terms_identifiedBy,identifiedBy,,

bien_web,VegCore,Filter,Comments

observationID,occurrenceID,,

dataSourceID,*dataSourceID,,

dataSourceNamePrimary,*dataSourceNamePrimary,,

plotID,locationID,,

observationType,observationGranularity,,

                    <location>

                        <authorlocationcode>

                            <_join>

                                <2>$collection</2>

                                <3>$accessionNumber</3>

                            </_join>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

SeniorCollector,DUPLICATE#of:CollectorString#SeniorCollector,,

CollectorString,recordedBy,,

CollectorStringShortened,DUPLICATE#of:CollectorString#CollectorStringShortened,,

CollectorAbbrev,DUPLICATE#of:CollectorString#CollectorAbbrev,,

CurrentDet,scientificName,,

CurrentDetRank,taxonRank,,

identifiedBy,identifiedBy,,

associatedReferences,associatedReferences,,

kingdom,kingdom,,

catalogNumber,accessionNumber,,

verbatimSRS,verbatimSRS,,

verbatimLongitude,verbatimLongitude,,

type,type,,

order,order,,

kingdom,kingdom,,

datasetID,datasetURL,,

countryCode,countryCode,,

catalogNumber,accessionNumber,,

previousIdentifications,previousIdentifications,,

identifiedBy,identifiedBy,,

associatedSequences,associatedSequences,,

SELECT util.search_path_append('util');

-- Remove institutions that we have direct data for

DELETE FROM :table

      'MO'

    , 'NY'

)

                                <1>$occurrenceID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

pkey,OMIT#pkey,,"CatalogNumber, etc. is a better pkey"

key,OMIT#key,,"CatalogNumber, etc. is a better pkey"

DateLastModified,modified,,

CollectionCode,collection,,

CatalogNumber,accessionNumber,,

ScientificName,taxonName,,

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

herbaria,VegCore,Filter,Comments

eparties_key,*eparties_key,,

NamOrganisation,*NamOrganisation,,

IhhInstitutionType,*IhhInstitutionType,,

NamBranch,*NamBranch,,

NamDepartment,*NamDepartment,,

REMIB,VegCore,Filter,Comments

row_num,*row_num,,

accession_number,accessionNumber,,"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]

[1] Using the following query:

long_deg,longitude_deg_verbatim,,

long_min,longitude_min_verbatim,,

long_sec,longitude_sec_verbatim,,

                <next>parent_id</next>

                <path>

                    <source>

                        <observationtype>specimen</observationtype>

                        <sourcetype>herbarium</sourcetype>

                    </source>

                    <location>

                        <authorlocationcode>

                            <_join>

                                <3>$accessionNumber</3>

                            </_join>

                        </authorlocationcode>

                                                <catalognumber_dwc>$accessionNumber</catalognumber_dwc>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

HVAA,VegCore,Filter,Comments

row_num,*row_num,,

collectionCode,collection,,

basisOfRecord,basisOfRecord,,

catalogNumber,accessionNumber,,

                                <1>$occurrenceID</1>

                                <2>

                                    <_join>

                                        <2>$collection</2>

                                        <3>$accessionNumber</3>

                                    </_join>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

collectionID,collectionURL,,

occurrenceRemarks,occurrenceRemarks,,

type,type,,

rights,rights,,

family,family,,

continent,continent,,

                                                </collectioncode_dwc>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

XAL:/content/record/,VegCore,Filter,Comments

row_num,*row_num,,

darwin:DateLastModified,modified,,

darwin:CollectionCode,collection,,

darwin:CatalogNumber,accessionNumber,,

darwin:ScientificName,taxonName,,

                    <location>

                        <authorlocationcode>

                            <_join>

                                <2>$collection</2>

                                <3>$accessionNumber</3>

                            </_join>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

darwin:DateLastModified,modified,,

darwin:CollectionCode,collection,,

darwin:CatalogNumber,accessionNumber,,

darwin:ScientificName,taxonName,,

CollectionDate,dateCollected,,

BarCode,OMIT#BarCode,,"Omitted because this isn't specified on all rows, but SpecimenPK is"

CatalogNumber,accessionNumber,,

Description,occurrenceRemarks,,

LandOwner,*LandOwner,,

BlockLocationReason,*BlockLocationReason,,

                                <1>$occurrenceID</1>

                                <2>

                                    <_join>

                                        <2>$collectionURL</2>

                                        <3>$accessionNumber</3>

                                    </_join>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

CurrentScientificName,taxonName,,

CurrentScientificNameWithAuthor,scientificName,,

CollectionDate,dateCollected,,

Description,occurrenceRemarks,,

CityLocality,municipality,,

Latitude1,decimalLatitude,,

SELECT util.search_path_append('util');

geodeticDatum,geodeticDatum,,

reproductiveCondition,reproductiveCondition,,

decimalLongitude,decimalLongitude,,

continent,continent,,

recordedBy,recordedBy,,

county,county,,

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

*row_num

basisOfRecord

geodeticDatum

georeferenceSources

language

georeferenceVerificationStatus

collectionCode,collection,,

verbatimCoordinates,verbatimCoordinates,,

decimalLatitude,decimalLatitude,,

catalogNumber,accessionNumber,,

verbatimLatitude,verbatimLatitude,,

identificationRemarks,identificationRemarks,,

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

BRIT,VegCore,Filter,Comments

specimen_id,dataProviderRecordID,,

Global_Unique_Identifier,UNUSED#Global_Unique_Identifier,,

Collector_Abbrev_Name,recordedBy_primary,,the primary collector

Collection_Team,recordedBy_additional,,additional collectors

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <3>$accessionNumber</3>

                                    </_join>

                                </2>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

DATA ENTRY BY,*DATA ENTRY BY,,

DATA ENTRY DATE,*DATA ENTRY DATE,,

DATA EDITED DATE,modified,,

:United States,country,,

DET DATE,dateIdentified,,

DETERMINER INSTITUTION,*DETERMINER INSTITUTION,,

DET NOTES,identificationRemarks,,

:United States,country,,

Ecology,habitat,,

Phenology,reproductiveCondition,,

Notes,occurrenceRemarks,,

SELECT util.search_path_append('util');

SELECT create_if_not_exists($$CREATE INDEX raw_occurrence_record_plants_institution_code

; -- runtime: 45 min ("2629095.310 ms") @starscream

-- Remove institutions that we have direct data for

-- runtime: 3.5 min ("208377.225 ms") @starscream

-- rerun time: ~0 ("Time: 2.271 ms") thanks to index (*after* manual vacuuming)

DELETE FROM :table

      'ACAD'

    , 'ARIZ'

    , 'BRIT'

data_provider_id,*data_provider_id,,

data_resource_id,*data_resource_id,,

resource_access_point_id,*resource_access_point_id,,

collection_code,collection,,

catalogue_number,accessionNumber,,

scientific_name,scientificName,,

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>$collection</2>

                                        <3>$accessionNumber</3>

                                    </_join>

                                                <collectioncode_dwc>$collection</collectioncode_dwc>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

data_provider_id,*data_provider_id,,

data_resource_id,*data_resource_id,,

resource_access_point_id,*resource_access_point_id,,

collection_code,collection,,

catalogue_number,accessionNumber,,

scientific_name,scientificName,,

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

dwc_geospatial_VerbatimLongitude,DUPLICATE#of:verbatimLongitude#dwc_geospatial_VerbatimLongitude,,exact duplicate

http__purl_org_dc_terms_modified,modified,,

dwc_terms_collectionID,collectionURL,,

dwc_terms_collectionCode,collection,,

dwc_terms_basisOfRecord,basisOfRecord,,

dwc_terms_identifiedBy,identifiedBy,,

datasetName,dataset,,

bibliographicCitation,bibliographicCitation,,

datasetID,datasetURL,,

recordNumber,collectorNumber,,

order,order,,

kingdom,kingdom,,

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

CollectorString,recordedBy,,

CollectorStringShortened,DUPLICATE#of:CollectorString#CollectorStringShortened,,

CollectionNumber,collectorNumber,,

InstitutionString,*InstitutionString,,

CollectorAbbrev,DUPLICATE#of:CollectorString#CollectorAbbrev,,

CurrentDet,scientificName,,

sheetno,associatedMedia,,?

cultivated,cultivated__main__verbatim,,

filler,*filler,,"Where used, same as family"

SELECT util.search_path_append('util');

-- remove frameshifted rows

DELETE FROM :table WHERE "yearCollected" !~ '^(?:1[7-9]|20)\d{2}$';

DELETE FROM :table WHERE country_verbatim ~ '\d';

DELETE FROM :table WHERE longitude_deg_verbatim ~ '[[:alpha:]]' AND longitude_deg_verbatim NOT IN ('RESTRINGIDO');

-- Remove institutions that we have direct data for

DELETE FROM :table

    -- Comments are from e-mail from Brad Boyle on 2013-1-16

    'MO' -- "all MO records in REMIB are also available from MO's own website"

    --, 'ARIZ' -- Some REMIB ARIZ specimens not yet in ARIZ itself

minimummonth,monthCollected,,

minimumyear,yearCollected,,

description,specimenDescription,,

notes,locationRemarks,,

determinationyear,yearIdentified,,

determinedby,identifiedBy,,

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

verbatimCoordinateSystem,coordinateUnits,,

locationRemarks,locationRemarks,,

genus,genus,,

higherClassification,higherClassification,,

verbatimSRS,verbatimSRS,,

municipality,municipality,,

                                <1>$dataProviderRecordID</1>

                                <2>

                                    <_join>

                                        <2>

                                            <_join>

                                                <1>$collection</1>

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

taxonID,"/_if[@name=""if specimen""]/cond/_exists",

source__version,"/_if[@name=""if specimen""]/else/source/edition",

source__modified_date,"/_if[@name=""if specimen""]/else/source/pubdate",

datasetURL,"/_if[@name=""if specimen""]/else/source/url",

observationGranularity,"/_if[@name=""if specimen""]/else/source/observationtype",

sourceType,"/_if[@name=""if specimen""]/else/source/sourcetype",

accessionNumber,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",

dataProviderRecordID,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",

occurrenceID,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",

collection,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then",

collectionURL,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then",

voucherType,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/cond",

accessionNumber,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

dataProviderRecordID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

occurrenceID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

dataProviderRecordID,//specimenreplicate/sourceaccessioncode,

occurrenceID,//specimenreplicate/sourceaccessioncode,

stemCount,//plantobservation/stemcount,

verbatimEventDate,verbatimEventDate,,

municipality,municipality,,

geodeticDatum,geodeticDatum,,

nomenclaturalCode,nomenclaturalCode,,

modified,modified,,

previousIdentifications,previousIdentifications,,

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

individualOrganismObservationID,individualObservationID

individualOrganismObservationRelativeX,organismX_m

individualOrganismObservationRelativeY,organismY_m

institutionCode_UNCC,specimenDonorInstitution

institutionID,specimenHolderURL

interpretationType,identificationType

species_DwC,specificEpithet

species_VegBank,speciesBinomial

specificEpithetScore,matchedSpeciesConfidence_fraction

ssp,subspecies

startX,subplotX

startY,subplotY

minimummonth,monthCollected,,

minimumyear,yearCollected,,

description,specimenDescription,,

determinationyear,yearIdentified,,

determinedby,identifiedBy,,

qualifier,identificationQualifier,,

taxonID,"/_if[@name=""if specimen""]/cond/_exists",

source__version,"/_if[@name=""if specimen""]/else/source/edition",

source__modified_date,"/_if[@name=""if specimen""]/else/source/pubdate",

datasetURL,"/_if[@name=""if specimen""]/else/source/url",

observationGranularity,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",

sourceType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",

accessionNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",

dataProviderRecordID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",

occurrenceID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",

collection,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",

collectionURL,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",

voucherType,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",

accessionNumber,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

dataProviderRecordID,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

occurrenceID,"/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

dataProviderRecordID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

occurrenceID,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

stemCount,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,

                                                <collectionnumber>$collectorNumber</collectionnumber>

                                                <institution_id>

                                                    <sourcelist>

                                                        <sourcename>

                                                            <name>

                                                                <_split>

                                                                    <separator>[,;] *</separator>

                                                                </_split>

                                                            </name>

                                                        </sourcename>

<html lang="en">

<head>

<meta charset="utf-8" />

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

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

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

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

<script src="/nceas/javascripts/jquery-1.8.3-ui-1.9.2-ujs-2.0.3.js?1364512407" type="text/javascript"></script>

<script type="text/javascript">

//<![CDATA[

$(window).load(function(){ warnLeavingUnsaved('The current page contains unsaved text that will be lost if you leave this page.'); });

<!-- page specific tags -->

</head>

<div id="wrapper">

<div id="wrapper2">

<div id="wrapper3">

</form>        

    </div>

    <img src="/nceas/images/nceas_logo.png" style="top-margin: 15px; left-margin: 15px;"/>

    <div id="main-menu">

    <div id="sidebar">

<h3>Wiki</h3>

    </div>

	<p><a href="http://VegCore.vegpath.org/ERD/"><img src="http://vegpath.org/VegCore/ERD/VegCore.ERD.png" title="VegCore schema: click for hyperlinked version" alt="VegCore schema: click for hyperlinked version" /></a></p>

<hr />

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

	<p style="padding-left:5em;">The institution(s) holding a copy of the specimen</p>

	<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 Boyle</a>)</p>

	<a name="specimenHolderInstitution"></a>

<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#specimenHolderInstitution" class="wiki-page">specimenHolderInstitution</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/621/vegbien_identifier_examples.xlsx#terms/institutionCode/where_specimen_held"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#specimenHolderInstitution" class="wiki-anchor">&para;</a></h3>

<p><a href="/nceas/attachments/download/493/ACAD.Specimen.csv" class="icon icon-attachment">ACAD.Specimen.csv</a>    <a href="/nceas/attachments/493/ACAD.Specimen.csv"><img alt="Magnifier" src="/nceas/images/magnifier.png?1347421714" /></a>

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

  </p>

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

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

  </p>

<p><a href="/nceas/attachments/download/626/vegbien_identifiers.xlsx" class="icon icon-attachment">vegbien_identifiers.xlsx</a>  

  <span class="size">(30.1 KB)</span>

  </p>

<p><a href="/nceas/attachments/download/629/BIEN%20database%20entities%20related%20to%20data%20provenance%20and%20ownership.docx" class="icon icon-attachment">BIEN database entities related to data provenance and ownership.docx</a>  

  <span class="size">(157 KB)</span>

  </p>

</div>

specimenHolderURL

specimenOwner

specimenStampingInstitution

ssp

startDate

startDayOfYear