Project

General

Profile

« Previous | Next » 

Revision 7469

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/VegCore-VegBIEN.csv, inputs/*/*/map.csv: Applied term renamings from the new dynamically generated Veg+-VegCore.csv, which reflects the current state of the data dictionary. (Permanently switching to the new Veg+-VegCore.csv will be a separate change.) Updates to VegCore term names that have occurred since the data dictionary was created are now able to take effect, which involves remapping and inferring units on several fields.

View differences:

inputs/GBIF/Source/map.csv
1 1 
GBIF,VegCore,Filter,Comments
2 2 
:aggregator,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/UBC/Source/map.csv
1 1 
UBC,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/HIBG/Specimen/test.xml.ref
265 265 
                                </place>
266 266 
                            </place_id>
267 267 
                        </locationplace>
268 
                        <notespublic>$locationRemarks</notespublic>
268 269 
                        <verbatimelevation>$verbatimElevation</verbatimelevation>
269 270 
                    </location>
270 271 
                </path>
inputs/SALVIAS/plotObservations/map.csv
48 48 
height_class,*height_class,,
49 49 
height_m,height_m,,"""Total height of individual, in meters"" (height_m definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>)"
50 50 
height_m_commercial,*height_m_commercial,,
51 
ht_first_branch_m,heightFirstBranch,,
51 
ht_first_branch_m,heightFirstBranch_m,,
52 52 
NoInd,individualCount,,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
53 53 
cover_percent,coverPercent,,
54 54 
intercept_cm,intercept_cm,,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
......
60 60 
OrigGenus,originalGenus,,
61 61 
OrigSpecies,originalSpecificEpithet,,Brad: OMIT
62 62 
OrigAuth,*OrigAuth,,
63 
phenology,phenology,,
63 
phenology,reproductiveCondition,,
64 64 
canopy_position,canopyPosition,,
65 65 
canopy_form,canopyForm,,
66 66 
liana_infestation,lianaInfestation,,
67 
Notes,fieldNotes,,
67 
Notes,organismNotes,,
68 68 
tmp_PlotObsID,*tmp_PlotObsID,,
69 69 
temp_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"
70 70 
temp_liandbh,*temp_liandbh,,
inputs/SALVIAS/plotObservations/unmapped_terms.csv
15 15 
*morphocf
16 16 
*IsMorpho
17 17 
*OrigAuth
18 
phenology
18 
reproductiveCondition
19 19 
*tmp_PlotObsID
20 20 
*temp_liandbh
21 21 
*tmp_del
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
27 27 
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_alt/4,
28 28 
date_finish,/location/locationevent/obsenddate/_alt/1,
29 29 
date_start,/location/locationevent/obsstartdate/_alt/1,
30 
Precip,/location/locationevent/precipitation_m,
30 
Precip,/location/locationevent/precipitation_m/_mm_to_m/value,
31 31 
soil_acidity,"/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
32 32 
soil_base,/location/locationevent/soilsample/basesaturation_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
33 33 
soil_Ca,/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values
inputs/SALVIAS/plotMetadata_/new_terms.csv
11 11 
Elev,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
12 12 
elev_max_m,maximumElevationInMeters,,
13 13 
elev_min_m,minimumElevationInMeters,,
14 
Precip,precipitation,,
15 
Temp,temperature,,
14 
Precip,precipitation_mm,,
15 
Temp,temperature_C,,
16 16 
soil_N,nitrogen_percent,,Assuming units are % based on the range of values
17 17 
soil_P,phosphorus_percent,"/_map:[""<1,5""=0,*=*]/value",Assuming units are % based on the range of values
18 18 
soil_K,potassium_percent,,Assuming units are % based on the range of values
inputs/U/Specimen/map.csv
29 29 
Alt2,*Alt2,,What is this?
30 30 
Ecology,habitat,,
31 31 
Phenology,reproductiveCondition,,
32 
Notes,fieldNotes,,
32 
Notes,organismNotes,,
inputs/JBM/Source/map.csv
1 1 
JBM,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/HIBG/Specimen/VegBIEN.csv
81 81 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
82 82 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
83 83 
stateProvince,/location/locationplace/*_id/place/stateprovince,
84 
locationRemarks,/location/notespublic,
84 85 
verbatimElevation,/location/verbatimelevation,
85 86 
associatedMedia,,** No join mapping for associatedMedia **
86 87 
basisOfRecord,,** No join mapping for basisOfRecord **
......
95 96 
informationWithheld,,** No join mapping for informationWithheld **
96 97 
institutionID,,** No join mapping for institutionID **
97 98 
language,,** No join mapping for language **
98 
locationRemarks,,** No join mapping for locationRemarks **
99 99 
modified,,** No join mapping for modified **
100 100 
municipality,,** No join mapping for municipality **
101 101 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
inputs/MT/Source/map.csv
1 1 
MT,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/XAL/Source/map.csv
1 1 
XAL,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/XAL/Specimen/map.csv
45 45 
darwin:PreviousCatalogNumber,otherCatalogNumbers,,
46 46 
darwin:RelationshipType,relationshipOfResource,,
47 47 
darwin:RelatedCatalogItem,relatedResourceID,,
48 
darwin:Notes,fieldNotes,,
48 
darwin:Notes,organismNotes,,
inputs/XAL/Specimen/new_terms.csv
42 42 
darwin:PreviousCatalogNumber,otherCatalogNumbers,,
43 43 
darwin:RelationshipType,relationshipOfResource,,
44 44 
darwin:RelatedCatalogItem,relatedResourceID,,
45 
darwin:Notes,fieldNotes,,
45 
darwin:Notes,organismNotes,,
inputs/NCU/Source/map.csv
1 1 
NCU,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/NCU/Specimen/map.csv
14 14 
BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
15 15 
CatalogNumber,catalogNumber,,
16 16 
CatalogSeriesPrefix,institutionCode,/_alt/1,
17 
Description,fieldNotes,,
17 
Description,organismNotes,,
18 18 
LandOwner,*LandOwner,,
19 19 
BlockLocationReason,*BlockLocationReason,,
20 20 
BlockSpecificLocation,*BlockSpecificLocation,,
inputs/NCU/Specimen/new_terms.csv
6 6 
CurrentScientificNameWithAuthor,scientificName,,
7 7 
CollectionDate,dateCollected,,
8 8 
CatalogSeriesPrefix,institutionCode,/_alt/1,
9 
Description,fieldNotes,,
9 
Description,organismNotes,,
10 10 
CityLocality,verbatimLocality,/_alt/2,
11 11 
Latitude1,decimalLatitude,,
12 12 
Longitude1,decimalLongitude,,
inputs/bien2_traits/TraitObservation/map.csv
12 12 
TraitName,measurementType,,
13 13 
TraitValue,measurementValue,,
14 14 
Unit,measurementUnit,,
15 
Method,method,,
15 
Method,samplingProtocol,,
16 16 
Region,*Region,,
17 17 
Country,country,,
18 18 
StateProvince,stateProvince,,
inputs/bien2_traits/TraitObservation/VegBIEN.csv
5 5 
VerbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
6 6 
TraitObservationID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
7 7 
LocalityDescription,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2,
8 
Method,/location/locationevent/*_id/method/name,
8 9 
TraitObservationID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
9 10 
TraitObservationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
10 11 
Taxon,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
......
48 49 
AuthorshipContact,,** No join mapping for *AuthorshipContact **
49 50 
Family_index,,** No non-empty join mapping for OMIT **
50 51 
LowerPolitical,,** No join mapping for *LowerPolitical **
51 
Method,,** No join mapping for method **
52 52 
Observation,,** No join mapping for *Observation **
53 53 
Project_PI,,** No join mapping for *Project_PI **
54 54 
Project_PI_contact,,** No join mapping for *Project_PI_contact **
inputs/bien2_traits/TraitObservation/test.xml.ref
17 17 
                        </elevation_m>
18 18 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocalityDescription</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
19 19 
                        <locationevent>
20 
                            <method_id><method><name>$Method</name></method></method_id>
20 21 
                            <taxonoccurrence>
21 22 
                                <aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$TraitObservationID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
22 23 
                                <growthform>$Habit</growthform>
......
150 151 
        </path>
151 152 
    </_setDefault>
152 153 
</VegBIEN>
153 
Inserted 30 new rows into database
154 
Inserted 31 new rows into database
inputs/bien2_traits/TraitObservation/unmapped_terms.csv
1 
method
2 1 
*Region
3 2 
*LowerPolitical
4 3 
*Source
inputs/bien2_traits/Source/map.csv
1 1 
bien2_traits,VegCore,Filter,Comments
2 2 
:primary database,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/TEAM/Source/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 2 
:primary database,referenceType,,
3 
:plot,observationType,,
3 
:plot,observationGranularity,,
inputs/ACAD/Source/map.csv
1 1 
ACAD,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/ACAD/Specimen/VegBIEN.csv
80 80 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
81 81 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
82 82 
stateProvince,/location/locationplace/*_id/place/stateprovince,
83 
locationRemarks,/location/notespublic,
83 84 
verbatimElevation,/location/verbatimelevation,
84 85 
basisOfRecord,,** No join mapping for basisOfRecord **
85 86 
bibliographicCitation,,** No join mapping for bibliographicCitation **
......
89 90 
georeferenceVerificationStatus,,** No join mapping for georeferenceVerificationStatus **
90 91 
identificationRemarks,,** No join mapping for identificationRemarks **
91 92 
language,,** No join mapping for language **
92 
locationRemarks,,** No join mapping for locationRemarks **
93 93 
modified,,** No join mapping for modified **
94 94 
municipality,,** No join mapping for municipality **
95 95 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
inputs/ACAD/Specimen/test.xml.ref
264 264 
                                </place>
265 265 
                            </place_id>
266 266 
                        </locationplace>
267 
                        <notespublic>$locationRemarks</notespublic>
267 268 
                        <verbatimelevation>$verbatimElevation</verbatimelevation>
268 269 
                    </location>
269 270 
                </path>
inputs/ACAD/Specimen/unmapped_terms.csv
4 4 
georeferenceSources
5 5 
language
6 6 
georeferenceVerificationStatus
7 
locationRemarks
8 7 
verbatimDepth
9 8 
municipality
10 9 
modified
inputs/WIN/Source/map.csv
1 1 
WIN,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/CTFS/PlotObservation/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 2 
CensusID,eventID,,
3 3 
PlotID,locationID,,
4 
PlotCensusNumber,fieldNumber,,
4 
PlotCensusNumber,authorEventCode,,
5 5 
StartDate,startDate,,
6 6 
EndDate,endDate,,
7 7 
Description,*Description,,
inputs/CTFS/Source/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 2 
:primary database,referenceType,,
3 
:plot,observationType,,
3 
:plot,observationGranularity,,
inputs/SALVIAS/stems/map.csv
3 3 
origrecord_id_stems,*origrecord_id_stems,,
4 4 
PlotObsID,individualID,,
5 5 
NoInd,stemCount,,
6 
basal_diam,basalDiameter,,
6 
basal_diam,basalDiameter_cm,,Assuming units are the same as for stem_dbh because the values are similar and they measure the same dimension
7 7 
stem_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for plotObservations.intercept_cm, which measures the same dimension"
8 
gentry_dbh,diameterBreastHeightGentry,,
8 
gentry_dbh,diameterBreastHeightGentry_cm,,Assuming units are the same as for stem_dbh because the values are similar and they measure the same dimension
9 9 
stem_notes,stemNotes,,
10 10 
stem_tag1,tag,/_alt/2,"The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
11 11 
stem_tag2,tag,/_alt/1,"The second tag supercedes the first. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
12 12 
stem_height_m,height_m,,"""Total height of this stem only, in meters"" (stem_height_m definition at < http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: Same as for height, but applies to individuals stems, not trees. Rare."
13 
stem_height_first_branch_m,heightFirstBranch,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
13 
stem_height_first_branch_m,heightFirstBranch_m,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
14 14 
stem_canopy_form,canopyForm,,
15 15 
stem_canopy_position,canopyPosition,,
16 16 
stem_liana_infestation,lianaInfestation,,
inputs/SALVIAS/stems/VegBIEN.csv
2 2 
PlotObsID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 3 
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/2,
4 4 
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
5 
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m,
5 
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m/_cm_to_m/value,Assuming units are the same as for stem_dbh because the values are similar and they measure the same dimension
6 6 
stem_canopy_form,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
7 7 
stem_canopy_position,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
8 
gentry_dbh,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
8 
gentry_dbh,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue/_cm_to_m/value",Assuming units are the same as for stem_dbh because the values are similar and they measure the same dimension
9 9 
stem_liana_infestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
10 10 
stem_notes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
11 11 
stem_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"Assuming units based on the units for plotObservations.intercept_cm, which measures the same dimension"
inputs/SALVIAS/stems/test.xml.ref
14 14 
                                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
15 15 
                                        <stemcount>$NoInd</stemcount>
16 16 
                                        <stemobservation>
17 
                                            <basaldiameter_m>$basal_diam</basaldiameter_m>
17 
                                            <basaldiameter_m><_cm_to_m><value>$basal_diam</value></_cm_to_m></basaldiameter_m>
18 18 
                                            <definedvalue fkey="tablerecord_id">
19 19 
                                                <userdefined_id>
20 20 
                                                    <userdefined>
......
40 40 
                                                        <userdefinedname>gentryDiameter</userdefinedname>
41 41 
                                                    </userdefined>
42 42 
                                                </userdefined_id>
43 
                                                <definedvalue>$gentry_dbh</definedvalue>
43 
                                                <definedvalue><_cm_to_m><value>$gentry_dbh</value></_cm_to_m></definedvalue>
44 44 
                                            </definedvalue>
45 45 
                                            <definedvalue fkey="tablerecord_id">
46 46 
                                                <userdefined_id>
inputs/SALVIAS/stems/new_terms.csv
2 2 
NoInd,stemCount,,
3 3 
stem_tag1,tag,/_alt/2,"The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
4 4 
stem_height_m,height_m,,"""Total height of this stem only, in meters"" (stem_height_m definition at < http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: Same as for height, but applies to individuals stems, not trees. Rare."
5 
stem_height_first_branch_m,heightFirstBranch,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
5 
stem_height_first_branch_m,heightFirstBranch_m,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
6 6 
plotobs_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/SALVIAS/Source/map.csv
1 1 
SALVIAS,VegCore,Filter,Comments
2 2 
:aggregator,referenceType,,
3 
:plot,observationType,,
3 
:plot,observationGranularity,,
inputs/SALVIAS/plotObservations/VegBIEN.csv
147 147 
name_status,,"** No non-empty join mapping for OMIT ** Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
148 148 
other_annotations,,** No join mapping for *other_annotations **
149 149 
perp_dist,,** No join mapping for *perp_dist **
150 
phenology,,** No join mapping for phenology **
150 
phenology,,** No join mapping for reproductiveCondition **
151 151 
species_code,,** No join mapping for *species_code **
152 152 
temp_liandbh,,** No join mapping for *temp_liandbh **
153 153 
tmp_PlotObsID,,** No join mapping for *tmp_PlotObsID **
inputs/SALVIAS/plotMetadata_/map.csv
22 22 
Elev,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
23 23 
elev_max_m,maximumElevationInMeters,,
24 24 
elev_min_m,minimumElevationInMeters,,
25 
Precip,precipitation,,
25 
Precip,precipitation_mm,,
26 26 
ElevSource,*ElevSource,,
27 
Temp,temperature,,
27 
Temp,temperature_C,,
28 28 
PrecipSource,*PrecipSource,,
29 29 
TempSource,*TempSource,,
30 30 
bearing,*bearing,,
......
61 61 
date_start,startDate,,
62 62 
date_finish,endDate,,
63 63 
plot_administrator,*plot_administrator,,
64 
plot_notes,plotNotes,,
64 
plot_notes,locationRemarks,,
65 65 
tmp_del,*tmp_del,,"3 plots contain ""del"" in this field and 3 in AccessCode"
66 66 
Country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
67 67 
PrimOwnerID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/SALVIAS/plotMetadata_/test.xml.ref
70 70 
                            </commclass>
71 71 
                            <obsenddate>$date_finish</obsenddate>
72 72 
                            <obsstartdate>$date_start</obsstartdate>
73 
                            <precipitation_m>$Precip</precipitation_m>
73 
                            <precipitation_m><_mm_to_m><value>$Precip</value></_mm_to_m></precipitation_m>
74 74 
                            <soilsample>
75 75 
                                <acidity_fraction>
76 76 
                                    <_percent_to_fraction>
inputs/U/Source/map.csv
1 1 
U,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/QFA/Source/map.csv
1 1 
QFA,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/HIBG/Source/map.csv
1 1 
HIBG,VegCore,Filter,Comments
2 2 
:herbarium,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/HIBG/Specimen/unmapped_terms.csv
3 3 
references
4 4 
institutionID
5 5 
verbatimCoordinateSystem
6 
locationRemarks
7 6 
reproductiveCondition
8 7 
dynamicProperties
9 8 
basisOfRecord
inputs/SpeciesLink/Specimen/map.csv
30 30 
dwc_dwcore_Sex,sex,,
31 31 
dwc_curatorial_IdentifiedBy,identifiedBy,,
32 32 
dwc_curatorial_CollectorNumber,recordNumber,/_alt/3,
33 
dwc_curatorial_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
34 
-----
35 
SELECT count(*) FROM ""SpeciesLink"".specimens
36 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
33 
dwc_curatorial_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
34 
-----
35 
SELECT count(*) FROM ""SpeciesLink"".specimens
36 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
37 37 
-----"
38 38 
dwc_curatorial_TypeStatus,typeStatus,,
39 39 
dwc_curatorial_IndividualCount,individualCount,,
......
63 63 
dwc_terms_year,year,,
64 64 
dwc_terms_month,month,,
65 65 
dwc_terms_day,day,,
66 
dwc_terms_fieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
67 
-----
68 
SELECT count(*) FROM ""SpeciesLink"".specimens
69 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
66 
dwc_terms_fieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
67 
-----
68 
SELECT count(*) FROM ""SpeciesLink"".specimens
69 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
70 70 
-----"
71 71 
dwc_terms_continent,continent,,
72 72 
dwc_terms_country,country,,
......
113 113 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
114 114 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
115 115 
conceptual_darwin_2003_1_0_CollectorNumber,recordNumber,/_alt/3,
116 
conceptual_darwin_2003_1_0_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
117 
-----
118 
SELECT count(*) FROM ""SpeciesLink"".specimens
119 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
116 
conceptual_darwin_2003_1_0_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
117 
-----
118 
SELECT count(*) FROM ""SpeciesLink"".specimens
119 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
120 120 
-----"
121 121 
conceptual_darwin_2003_1_0_Collector,recordedBy,,
122 122 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
......
143 143 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,
144 144 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,
145 145 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,
146 
conceptual_darwin_2003_1_0_Notes,fieldNotes,,
146 
conceptual_darwin_2003_1_0_Notes,organismNotes,,
inputs/SpeciesLink/Source/map.csv
1 1 
SpeciesLink,VegCore,Filter,Comments
2 2 
:aggregator,referenceType,,
3 
:specimen,observationType,,
3 
:specimen,observationGranularity,,
inputs/SpeciesLink/Specimen/new_terms.csv
29 29 
dwc_dwcore_Sex,sex,,
30 30 
dwc_curatorial_IdentifiedBy,identifiedBy,,
31 31 
dwc_curatorial_CollectorNumber,recordNumber,/_alt/3,
32 
dwc_curatorial_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
33 
-----
34 
SELECT count(*) FROM ""SpeciesLink"".specimens
35 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
32 
dwc_curatorial_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
33 
-----
34 
SELECT count(*) FROM ""SpeciesLink"".specimens
35 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
36 36 
-----"
37 37 
dwc_curatorial_TypeStatus,typeStatus,,
38 38 
dwc_curatorial_IndividualCount,individualCount,,
......
62 62 
dwc_terms_year,year,,
63 63 
dwc_terms_month,month,,
64 64 
dwc_terms_day,day,,
65 
dwc_terms_fieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
66 
-----
67 
SELECT count(*) FROM ""SpeciesLink"".specimens
68 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
65 
dwc_terms_fieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
66 
-----
67 
SELECT count(*) FROM ""SpeciesLink"".specimens
68 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
69 69 
-----"
70 70 
dwc_terms_continent,continent,,
71 71 
dwc_terms_country,country,,
......
112 112 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
113 113 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
114 114 
conceptual_darwin_2003_1_0_CollectorNumber,recordNumber,/_alt/3,
115 
conceptual_darwin_2003_1_0_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
116 
-----
117 
SELECT count(*) FROM ""SpeciesLink"".specimens
118 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
115 
conceptual_darwin_2003_1_0_FieldNumber,recordNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
116 
-----
117 
SELECT count(*) FROM ""SpeciesLink"".specimens
118 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
119 119 
-----"
120 120 
conceptual_darwin_2003_1_0_Collector,recordedBy,,
121 121 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
......
142 142 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,
143 143 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,
144 144 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,
145 
conceptual_darwin_2003_1_0_Notes,fieldNotes,,
145 
conceptual_darwin_2003_1_0_Notes,organismNotes,,
inputs/SpeciesLink/Specimen/VegBIEN.csv
32 32 
dwc_terms_minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
33 33 
dwc_dwcore_GlobalUniqueIdentifier,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
34 34 
dwc_terms_recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
35 
conceptual_darwin_2003_1_0_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
36 
-----
37 
SELECT count(*) FROM ""SpeciesLink"".specimens
38 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
35 
conceptual_darwin_2003_1_0_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
36 
-----
37 
SELECT count(*) FROM ""SpeciesLink"".specimens
38 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
39 39 
-----"
40 
dwc_curatorial_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
41 
-----
42 
SELECT count(*) FROM ""SpeciesLink"".specimens
43 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
40 
dwc_curatorial_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
41 
-----
42 
SELECT count(*) FROM ""SpeciesLink"".specimens
43 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
44 44 
-----"
45 
dwc_terms_fieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
46 
-----
47 
SELECT count(*) FROM ""SpeciesLink"".specimens
48 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
45 
dwc_terms_fieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
46 
-----
47 
SELECT count(*) FROM ""SpeciesLink"".specimens
48 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
49 49 
-----"
50 50 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
51 51 
dwc_curatorial_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
......
65 65 
dwc_terms_individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
66 66 
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
67 67 
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,
68 
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
69 
-----
70 
SELECT count(*) FROM ""SpeciesLink"".specimens
71 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
68 
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
69 
-----
70 
SELECT count(*) FROM ""SpeciesLink"".specimens
71 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
72 72 
-----"
73 
dwc_curatorial_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
74 
-----
75 
SELECT count(*) FROM ""SpeciesLink"".specimens
76 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
73 
dwc_curatorial_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
74 
-----
75 
SELECT count(*) FROM ""SpeciesLink"".specimens
76 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
77 77 
-----"
78 
dwc_terms_fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
79 
-----
80 
SELECT count(*) FROM ""SpeciesLink"".specimens
81 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
78 
dwc_terms_fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
79 
-----
80 
SELECT count(*) FROM ""SpeciesLink"".specimens
81 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
82 82 
-----"
83 83 
conceptual_darwin_2003_1_0_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/3,
84 84 
dwc_curatorial_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/3,
......
93 93 
dwc_terms_collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
94 94 
dwc_terms_collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
95 95 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1",
96 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
97 
-----
98 
SELECT count(*) FROM ""SpeciesLink"".specimens
99 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
96 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
97 
-----
98 
SELECT count(*) FROM ""SpeciesLink"".specimens
99 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
100 100 
-----"
101 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
102 
-----
103 
SELECT count(*) FROM ""SpeciesLink"".specimens
104 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
101 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
102 
-----
103 
SELECT count(*) FROM ""SpeciesLink"".specimens
104 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
105 105 
-----"
106 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
107 
-----
108 
SELECT count(*) FROM ""SpeciesLink"".specimens
109 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
106 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
107 
-----
108 
SELECT count(*) FROM ""SpeciesLink"".specimens
109 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
110 110 
-----"
111 111 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/3",
112 112 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/3",
......
122 122 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
123 123 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
124 124 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1",
125 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
126 
-----
127 
SELECT count(*) FROM ""SpeciesLink"".specimens
128 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
125 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
126 
-----
127 
SELECT count(*) FROM ""SpeciesLink"".specimens
128 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
129 129 
-----"
130 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
131 
-----
132 
SELECT count(*) FROM ""SpeciesLink"".specimens
133 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
130 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
131 
-----
132 
SELECT count(*) FROM ""SpeciesLink"".specimens
133 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
134 134 
-----"
135 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
136 
-----
137 
SELECT count(*) FROM ""SpeciesLink"".specimens
138 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
135 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
136 
-----
137 
SELECT count(*) FROM ""SpeciesLink"".specimens
138 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
139 139 
-----"
140 140 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/3",
141 141 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/3",
......
147 147 
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
148 148 
dwc_dwcore_GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
149 149 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
150 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
151 
-----
152 
SELECT count(*) FROM ""SpeciesLink"".specimens
153 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
150 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
151 
-----
152 
SELECT count(*) FROM ""SpeciesLink"".specimens
153 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
154 154 
-----"
155 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
156 
-----
157 
SELECT count(*) FROM ""SpeciesLink"".specimens
158 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
155 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
156 
-----
157 
SELECT count(*) FROM ""SpeciesLink"".specimens
158 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
159 159 
-----"
160 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
161 
-----
162 
SELECT count(*) FROM ""SpeciesLink"".specimens
163 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
160 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
161 
-----
162 
SELECT count(*) FROM ""SpeciesLink"".specimens
163 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
164 164 
-----"
165 165 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
166 166 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
......
236 236 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
237 237 
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
238 238 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1",
239 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
240 
-----
241 
SELECT count(*) FROM ""SpeciesLink"".specimens
242 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
239 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
240 
-----
241 
SELECT count(*) FROM ""SpeciesLink"".specimens
242 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
243 243 
-----"
244 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
245 
-----
246 
SELECT count(*) FROM ""SpeciesLink"".specimens
247 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
244 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
245 
-----
246 
SELECT count(*) FROM ""SpeciesLink"".specimens
247 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
248 248 
-----"
249 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
250 
-----
251 
SELECT count(*) FROM ""SpeciesLink"".specimens
252 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
249 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
250 
-----
251 
SELECT count(*) FROM ""SpeciesLink"".specimens
252 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
253 253 
-----"
254 254 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
255 255 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
inputs/bien_web/observation/map.csv
4 4 
dataSourceName,institutionCode,,
5 5 
dataSourceNamePrimary,*dataSourceNamePrimary,,
6 6 
plotID,locationID,,
7 
observationType,observationType,,
7 
observationType,observationGranularity,,
8 8 
bien2_taxonomyID,*bien2_taxonomyID,,
9 9 
bien2_DBPlotID,*bien2_DBPlotID,,
10 10 
bien2_ObservationID,*bien2_ObservationID,,
......
36 36 
plotMethod,samplingProtocol,,
37 37 
latitude,decimalLatitude,,
38 38 
longitude,decimalLongitude,,
39 
isValidLatLong,isValidLatLong,,
40 
isGeovalid,isGeovalid,,
39 
isValidLatLong,latLongDomainValid,,
40 
isGeovalid,geovalid,,
41 41 
isNewWorld,isNewWorld,,
42 42 
elevation_m,elevationInMeters,,
43 43 
isCultivated,cultivated,,
......
47 47 
abund2.5,*abund2.5,,
48 48 
abund10,*abund10,,
49 49 
pctCover,coverPercent,,
50 
traitName,traitName,,
51 
traitValue,traitValue,,
50 
traitName,measurementType,,
51 
traitValue,measurementValue,,
52 52 
traitUnit,*traitUnit,,
53 53 
traitMethod,*traitMethod,,
54 54 
observationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/NY/Specimen/map.csv
47 47 
PreviousCatalogNumber,otherCatalogNumbers,,
48 48 
RelationshipType,relationshipOfResource,,
49 49 
RelatedCatalogItem,relatedResourceID,,
50 
Notes,fieldNotes,/_join/1,
50 
Notes,organismNotes,/_join/1,
51 51 
Habitat,habitat,,
52 
PlantFungusDescription,fieldNotes,"/_join/2/_label[label=""plant fungus""]/value",
52 
PlantFungusDescription,organismNotes,"/_join/2/_label[label=""plant fungus""]/value",
53 53 
Substrate,locality,"/_join/2/_label[label=""substrate""]/value",
54 54 
Vegetation,locality,"/_join/3/_label[label=""vegetation""]/value",
55 55 
UniqueNYInternalRecordNumber,OMIT,,"Globally unique when provided, but omitted to avoid confusion since this is an internal-only ID"
inputs/Madidi/IndividualObservation/new_terms.csv
1 1 
Sequence,subplot,,
2 
PlotInventoryName,fieldNumber,,
2 
PlotInventoryName,authorEventCode,,
3 3 
Tree,individualCode,,
4 4 
Trunk,authorStemCode,,
5 5 
SpecimenID,catalogNumber,,
......
22 22 
Diameter,diameterBreastHeight_cm,,
23 23 
TotalHeight,height_m,,
24 24 
HabitName,growthForm,,
25 
TreeNotes,fieldNotes,,
25 
TreeNotes,organismNotes,,
inputs/Madidi/Location/map.csv
14 14 
FirstSurveyDate,*FirstSurveyDate,,
15 15 
Topography,landform,,
16 16 
LocalityDescription,locality,,
17 
Note,plotNotes,,
17 
Note,locationRemarks,,
inputs/UNCC/Specimen/VegBIEN.csv
1 1 
UNCC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
accession,"/_if[@name=""if specimen""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.
3 

  		




  4
  
  
    
[1] Using the following query:


  		




  5
  
  
    
-----


  		




  6
  
  
    
SELECT herbarium, accession, count(*)


  		




  7
  
  
    
FROM ""UNCC"".""Specimen""


  		




  8
  
  
    
GROUP BY herbarium, accession


  		




  9
  
  
    
HAVING count(*) > 1


  		




  
  2
  
    
accession,"/_if[@name=""if specimen""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  3
  
    

  		




  
  4
  
    
[1] Using the following query:



  		




  
  5
  
    
-----



  		




  
  6
  
    
SELECT herbarium, accession, count(*)



  		




  
  7
  
    
FROM ""UNCC"".""Specimen""



  		




  
  8
  
    
GROUP BY herbarium, accession



  		




  
  9
  
    
HAVING count(*) > 1



  		




  10
  10
  
    
-----"


  		




  11
  11
  
    
herbarium,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",


  		




  12
  
  
    
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  13
  
  
    

  		




  14
  
  
    
[1] Using the following query:


  		




  15
  
  
    
-----


  		




  16
  
  
    
SELECT herbarium, accession, count(*)


  		




  17
  
  
    
FROM ""UNCC"".""Specimen""


  		




  18
  
  
    
GROUP BY herbarium, accession


  		




  19
  
  
    
HAVING count(*) > 1


  		




  
  12
  
    
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  13
  
    

  		




  
  14
  
    
[1] Using the following query:



  		




  
  15
  
    
-----



  		




  
  16
  
    
SELECT herbarium, accession, count(*)



  		




  
  17
  
    
FROM ""UNCC"".""Specimen""



  		




  
  18
  
    
GROUP BY herbarium, accession



  		




  
  19
  
    
HAVING count(*) > 1



  		




  20
  20
  
    
-----"


  		




  21
  
  
    
accession,"/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","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  22
  
  
    

  		




  23
  
  
    
[1] Using the following query:


  		




  24
  
  
    
-----


  		




  25
  
  
    
SELECT herbarium, accession, count(*)


  		




  26
  
  
    
FROM ""UNCC"".""Specimen""


  		




  27
  
  
    
GROUP BY herbarium, accession


  		




  28
  
  
    
HAVING count(*) > 1


  		




  
  21
  
    
accession,"/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","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  22
  
    

  		




  
  23
  
    
[1] Using the following query:



  		




  
  24
  
    
-----



  		




  
  25
  
    
SELECT herbarium, accession, count(*)



  		




  
  26
  
    
FROM ""UNCC"".""Specimen""



  		




  
  27
  
    
GROUP BY herbarium, accession



  		




  
  28
  
    
HAVING count(*) > 1



  		




  29
  29
  
    
-----"


  		




  30
  30
  
    
herbarium,"/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""]/then",


  		




  31
  
  
    
accession,"/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""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  32
  
  
    

  		




  33
  
  
    
[1] Using the following query:


  		




  34
  
  
    
-----


  		




  35
  
  
    
SELECT herbarium, accession, count(*)


  		




  36
  
  
    
FROM ""UNCC"".""Specimen""


  		




  37
  
  
    
GROUP BY herbarium, accession


  		




  38
  
  
    
HAVING count(*) > 1


  		




  
  31
  
    
accession,"/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""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  32
  
    

  		




  
  33
  
    
[1] Using the following query:



  		




  
  34
  
    
-----



  		




  
  35
  
    
SELECT herbarium, accession, count(*)



  		




  
  36
  
    
FROM ""UNCC"".""Specimen""



  		




  
  37
  
    
GROUP BY herbarium, accession



  		




  
  38
  
    
HAVING count(*) > 1



  		




  39
  39
  
    
-----"


  		




  40
  40
  
    
collectno,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  41
  41
  
    
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2",Ignore other values


  		




  ......




  52
  52
  
    
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/6/_label[label=""loaned to""]/value",


  		




  53
  53
  
    
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/7/_label[label=""in or out""]/value",


  		




  54
  54
  
    
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,


  		




  55
  
  
    
accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  56
  
  
    

  		




  57
  
  
    
[1] Using the following query:


  		




  58
  
  
    
-----


  		




  59
  
  
    
SELECT herbarium, accession, count(*)


  		




  60
  
  
    
FROM ""UNCC"".""Specimen""


  		




  61
  
  
    
GROUP BY herbarium, accession


  		




  62
  
  
    
HAVING count(*) > 1


  		




  
  55
  
    
accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  56
  
    

  		




  
  57
  
    
[1] Using the following query:



  		




  
  58
  
    
-----



  		




  
  59
  
    
SELECT herbarium, accession, count(*)



  		




  
  60
  
    
FROM ""UNCC"".""Specimen""



  		




  
  61
  
    
GROUP BY herbarium, accession



  		




  
  62
  
    
HAVING count(*) > 1



  		




  63
  63
  
    
-----"


  		




  64
  64
  
    
collectno,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",


  		




  65
  
  
    
accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  66
  
  
    

  		




  67
  
  
    
[1] Using the following query:


  		




  68
  
  
    
-----


  		




  69
  
  
    
SELECT herbarium, accession, count(*)


  		




  70
  
  
    
FROM ""UNCC"".""Specimen""


  		




  71
  
  
    
GROUP BY herbarium, accession


  		




  72
  
  
    
HAVING count(*) > 1


  		




  
  65
  
    
accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  66
  
    

  		




  
  67
  
    
[1] Using the following query:



  		




  
  68
  
    
-----



  		




  
  69
  
    
SELECT herbarium, accession, count(*)



  		




  
  70
  
    
FROM ""UNCC"".""Specimen""



  		




  
  71
  
    
GROUP BY herbarium, accession



  		




  
  72
  
    
HAVING count(*) > 1



  		




  73
  73
  
    
-----"


  		




  74
  74
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",


  		




  75
  75
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",


  		




  ......




  107
  107
  
    
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,


  		




  108
  108
  
    
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank/_alt/1,


  		




  109
  109
  
    
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank/_alt/2,


  		




  110
  
  
    
accession,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  111
  
  
    

  		




  112
  
  
    
[1] Using the following query:


  		




  113
  
  
    
-----


  		




  114
  
  
    
SELECT herbarium, accession, count(*)


  		




  115
  
  
    
FROM ""UNCC"".""Specimen""


  		




  116
  
  
    
GROUP BY herbarium, accession


  		




  117
  
  
    
HAVING count(*) > 1


  		




  
  110
  
    
accession,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  111
  
    

  		




  
  112
  
    
[1] Using the following query:



  		




  
  113
  
    
-----



  		




  
  114
  
    
SELECT herbarium, accession, count(*)



  		




  
  115
  
    
FROM ""UNCC"".""Specimen""



  		




  
  116
  
    
GROUP BY herbarium, accession



  		




  
  117
  
    
HAVING count(*) > 1



  		




  118
  118
  
    
-----"


  		




  119
  119
  
    
collectno,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",


  		




  120
  120
  
    
locality,/location/locationnarrative/_merge/1,


  		












  

    
      inputs/SALVIAS-CSV/Organism/VegBIEN.csv
    
  





  68
  68
  
    
det_type,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."


  		




  69
  69
  
    
coll_number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Map instead as for voucher_string


  		




  70
  70
  
    
voucher_string,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."


  		




  71
  
  
    
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m,


  		




  
  71
  
    
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m/_cm_to_m/value,Assuming units are the same as for stem_dbh because the values are similar and they measure the same dimension


  		




  72
  72
  
    
stem_canopy_form,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",


  		




  73
  73
  
    
stem_canopy_position,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",


  		




  74
  74
  
    
stem_liana_infestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",


  		












  

    
      inputs/SALVIAS-CSV/Plot/map.csv
    
  





  12
  12
  
    
elev_m,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.


  		




  13
  13
  
    
elev_max_m,maximumElevationInMeters,,


  		




  14
  14
  
    
elev_min_m,minimumElevationInMeters,,


  		




  15
  
  
    
temp_c,temperature,,


  		




  16
  
  
    
precip_mm,precipitation,,


  		




  
  15
  
    
temp_c,temperature_C,,


  		




  
  16
  
    
precip_mm,precipitation_mm,,


  		




  17
  17
  
    
slope_aspect,slopeAspect,,


  		




  18
  18
  
    
slope_gradient,slopeGradient,,


  		




  19
  19
  
    
clay_percent,clay_percent,,


  		












  

    
      inputs/CVS/stemCount_/new_terms.csv
    
  





  1
  1
  
    
taxonImportance_ID,OMIT,,Omitted because STEMCOUNT_ID is more specific


  		




  2
  2
  
    
cover,coverPercent,,


  		




  3
  
  
    
STEMCOUNT_ID,aggregateOccurrenceID,,


  		




  
  3
  
    
STEMCOUNT_ID,aggregateOrganismObservationID,,


  		




  4
  4
  
    
stemDiameter,diameterBreastHeight_cm,,


  		












  

    
      inputs/CVS/stemLocation_/new_terms.csv
    
  





  1
  
  
    
STEMCOUNT_ID,aggregateOccurrenceID,,


  		




  
  1
  
    
STEMCOUNT_ID,aggregateOrganismObservationID,,


  		




  2
  2
  
    
taxonImportance_ID,OMIT,,Omitted because STEMCOUNT_ID is more specific


  		




  3
  3
  
    
stemDiameter,diameterBreastHeight_cm,,


  		




  4
  4
  
    
STEMLOCATION_ID,stemID,,


  		












  

    
      inputs/bien_web/Source/map.csv
    
  





  1
  1
  
    
bien_web,VegCore,Filter,Comments


  		




  2
  2
  
    
:aggregator,referenceType,,


  		




  3
  
  
    
:plot,observationType,,


  		




  
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/NY/Source/map.csv
    
  





  1
  1
  
    
NY,VegCore,Filter,Comments


  		




  2
  2
  
    
:herbarium,referenceType,,


  		




  3
  
  
    
:specimen,observationType,,


  		




  
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/Madidi/IndividualObservation/map.csv
    
  





  6
  6
  
    
Sequence,subplot,,


  		




  7
  7
  
    
SubplotX,subplotX,,


  		




  8
  8
  
    
SubplotY,subplotY,,


  		




  9
  
  
    
PlotInventoryName,fieldNumber,,


  		




  
  9
  
    
PlotInventoryName,authorEventCode,,


  		




  10
  10
  
    
Tree,individualCode,,


  		




  11
  11
  
    
Trunk,authorStemCode,,


  		




  12
  12
  
    
Tag,tag,,


  		




  ......




  49
  49
  
    
SubplotX2,*SubplotX2,,


  		




  50
  50
  
    
SubplotY2,*SubplotY2,,


  		




  51
  51
  
    
HabitName,growthForm,,


  		




  52
  
  
    
TreeNotes,fieldNotes,,


  		




  
  52
  
    
TreeNotes,organismNotes,,


  		




  53
  53
  
    
DNASample,*DNASample,,


  		




  54
  54
  
    
IsAlive,*IsAlive,,


  		




  55
  55
  
    
CompoundLeaf,UNUSED,,


  		












  

    
      inputs/Madidi/map.csv
    
  





  1
  
  
    
Madidi,VegCore,Filter,Comments


  		




  2
  
  
    
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,Assuming units are % based on the range of values


  		




  3
  
  
    
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,Assuming units are % based on the range of values


  		




  4
  
  
    
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,Assuming units are % based on the range of values


  		




  5
  
  
    
"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,Assuming units are % based on the range of values


  		




  6
  
  
    
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,Assuming units are % based on the range of values


  		




  7
  
  
    
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,Assuming units are % based on the range of values


  		




  8
  
  
    
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,Assuming units are % based on the range of values


  		




  9
  
  
    
Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  10
  
  
    

  		




  11
  
  
    
[1] Using the following query:


  		




  12
  
  
    
-----


  		




  13
  
  
    
SELECT ""Altitude""::real, ""Locality""


  		




  14
  
  
    
FROM ""Madidi"".""Plot""


  		




  15
  
  
    
WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'


  		




  16
  
  
    
GROUP BY ""Altitude""::real , ""Locality""


  		




  17
  
  
    
ORDER BY ""Altitude""::real DESC


  		




  18
  
  
    
-----


  		




  19
  
  
    
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"


  		




  20
  
  
    
Arcilla (DIN 18 123–%–1),clay_percent,,Assuming units are % based on the range of values


  		




  21
  
  
    
Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"


  		




  22
  
  
    
Arena (DIN 18 123–%–2.5),sand_percent,,Assuming units are % based on the range of values


  		




  23
  
  
    
Autor (revised),scientificNameAuthorship,,


  		




  24
  
  
    
Available Phosphor,phosphorus_percent,,Assuming units are % based on the range of values


  		




  25
  
  
    
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,


  		




  26
  
  
    
CIC,cationExchangeCapacity_cmol_kg,,


  		




  27
  
  
    
CollectorAbbrev,recordedBy,/_first/3,


  		




  28
  
  
    
CollectorString,recordedBy,/_first/1/_merge/2,


  		




  29
  
  
    
CollectorStringShortened,recordedBy,/_first/2,


  		




  30
  
  
    
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,


  		




  31
  
  
    
CurrentDet,scientificName,,


  		




  32
  
  
    
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"


  		




  33
  
  
    
CurrentDetQualifier,identificationQualifier,,


  		




  34
  
  
    
CurrentDetRank,taxonRank,,


  		




  35
  
  
    
Determined by,identifiedBy,,


  		




  36
  
  
    
Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values


  		




  37
  
  
    
Direction,slopeAspect,/_alt/1,Part files provide either this field or Orientación


  		




  38
  
  
    
Electric conductivity,conductivity,,


  		




  39
  
  
    
Expedition name,projectName,,Consistent (globally unique) between PPM and PT data


  		




  40
  
  
    
Expedition number,projectID,,Consistent (globally unique) between PPM and PT data


  		




  41
  
  
    
Expedition,projectName,,


  		




  42
  
  
    
Family (revised),family,,


  		




  43
  
  
    
Field family,originalFamily,,


  		




  44
  
  
    
Field name,originalGenus,,Often = Genera


  		




  45
  
  
    
FieldFamilyFullName,originalFamily,,


  		




  46
  
  
    
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"


  		




  47
  
  
    
FieldNameAuthors,originalScientificNameAuthorship,,


  		




  48
  
  
    
FieldNameFullName,originalTaxonName,,


  		




  49
  
  
    
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors


  		




  50
  
  
    
First evaluation,eventDate,,


  		




  51
  
  
    
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values


  		




  52
  
  
    
Genera,genus,,


  		




  53
  
  
    
HabitName,growthForm,,


  		




  54
  
  
    
Index collector,recordedBy,,


  		




  55
  
  
    
Institutions,institutionCode,,


  		




  56
  
  
    
Interchangable Calcium,calcium_percent,,Assuming units are % based on the range of values


  		




  57
  
  
    
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values


  		




  58
  
  
    
Interchangeable Magnesium,magnesium_percent,,Assuming units are % based on the range of values


  		




  59
  
  
    
Interchangeable Potassium,potassium_percent,,Assuming units are % based on the range of values


  		




  60
  
  
    
Interchangeable Sodium,sodium_percent,,Assuming units are % based on the range of values


  		




  61
  
  
    
Inventory code,locationID,,


  		




  62
  
  
    
Inventory name,locationName,,


  		




  63
  
  
    
LatitudeDecDeg,decimalLatitude,,


  		




  64
  
  
    
Liana presence,lianaInfestation,,


  		




  65
  
  
    
Limo (DIN 18 123–%–1),silt_percent,,Assuming units are % based on the range of values


  		




  66
  
  
    
LongitudeDecDeg,decimalLongitude,,


  		




  67
  
  
    
LowerName,county,,


  		




  68
  
  
    
MaximumElevationMeters,maximumElevationInMeters,,


  		




  69
  
  
    
Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  70
  
  
    

  		




  71
  
  
    
[1] Using the following query:


  		




  72
  
  
    
-----


  		




  73
  
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  74
  
  
    
FROM ""Madidi"".""Plot""


  		




  75
  
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  76
  
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  77
  
  
    
-----


  		




  78
  
  
    
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"


  		




  79
  
  
    
MinimumElevationMeters,minimumElevationInMeters,,


  		




  80
  
  
    
MorphoSpeciesName,morphoname,,


  		




  81
  
  
    
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values


  		




  82
  
  
    
Number of subplot,subplot,,


  		




  83
  
  
    
Observaciones,plotNotes,,


  		




  84
  
  
    
Observations,fieldNotes,,


  		




  85
  
  
    
Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction


  		




  86
  
  
    
PlotInventoryName,fieldNumber,,


  		




  87
  
  
    
Qualifier,identificationQualifier,,


  		




  88
  
  
    
SeniorCollector,recordedBy,/_first/1/_merge/1,


  		




  89
  
  
    
Sequence,subplot,,


  		




  90
  
  
    
Slope,slopeGradient,,


  		




  91
  
  
    
Specie+autor,scientificName,,


  		




  92
  
  
    
Species and morphotypes,taxonName,,"Contains less than ""Specie+autor"""


  		




  93
  
  
    
Specimen,catalogNumber,,


  		




  94
  
  
    
SpecimenID,catalogNumber,,


  		




  95
  
  
    
Tag number,tag,,


  		




  96
  
  
    
Textural class,texture,,


  		




  97
  
  
    
Topographical situation,landform,,


  		




  98
  
  
    
Topography,landform,,


  		




  99
  
  
    
Total Nitrogen,nitrogen_percent,,Assuming units are % based on the range of values


  		




  100
  
  
    
Total height,height_m,,Assuming units based on the range and precision of values


  		




  101
  
  
    
Tree number,individualCode,,


  		




  102
  
  
    
Tree,individualCode,,


  		




  103
  
  
    
TreeNotes,fieldNotes,,


  		




  104
  
  
    
Trunk,authorStemCode,,


  		




  105
  
  
    
UpperName,stateProvince,,


  		




  106
  
  
    
Vegetation Type,communityID,,


  		




  107
  
  
    
pH acuoso (ISRIC 4–– 1 - 14),ph,,


  		




  108
  
  
    
pH disolved,ph,,


  		




  
  1
  
    
Madidi,VegCore,Filter,Comments


  		




  
  2
  
    
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,Assuming units are % based on the range of values


  		




  
  3
  
    
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,Assuming units are % based on the range of values


  		




  
  4
  
    
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,Assuming units are % based on the range of values


  		




  
  5
  
    
"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,Assuming units are % based on the range of values


  		




  
  6
  
    
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,Assuming units are % based on the range of values


  		




  
  7
  
    
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,Assuming units are % based on the range of values


  		




  
  8
  
    
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,Assuming units are % based on the range of values


  		




  
  9
  
    
Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  10
  
    

  		




  
  11
  
    
[1] Using the following query:


  		




  
  12
  
    
-----


  		




  
  13
  
    
SELECT ""Altitude""::real, ""Locality""


  		




  
  14
  
    
FROM ""Madidi"".""Plot""


  		




  
  15
  
    
WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'


  		




  
  16
  
    
GROUP BY ""Altitude""::real , ""Locality""


  		




  
  17
  
    
ORDER BY ""Altitude""::real DESC


  		




  
  18
  
    
-----


  		




  
  19
  
    
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"


  		




  
  20
  
    
Arcilla (DIN 18 123–%–1),clay_percent,,Assuming units are % based on the range of values


  		




  
  21
  
    
Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"


  		




  
  22
  
    
Arena (DIN 18 123–%–2.5),sand_percent,,Assuming units are % based on the range of values


  		




  
  23
  
    
Autor (revised),scientificNameAuthorship,,


  		




  
  24
  
    
Available Phosphor,phosphorus_percent,,Assuming units are % based on the range of values


  		




  
  25
  
    
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,


  		




  
  26
  
    
CIC,cationExchangeCapacity_cmol_kg,,


  		




  
  27
  
    
CollectorAbbrev,recordedBy,/_first/3,


  		




  
  28
  
    
CollectorString,recordedBy,/_first/1/_merge/2,


  		




  
  29
  
    
CollectorStringShortened,recordedBy,/_first/2,


  		




  
  30
  
    
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,


  		




  
  31
  
    
CurrentDet,scientificName,,


  		




  
  32
  
    
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"


  		




  
  33
  
    
CurrentDetQualifier,identificationQualifier,,


  		




  
  34
  
    
CurrentDetRank,taxonRank,,


  		




  
  35
  
    
Determined by,identifiedBy,,


  		




  
  36
  
    
Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values


  		




  
  37
  
    
Direction,slopeAspect,/_alt/1,Part files provide either this field or Orientación


  		




  
  38
  
    
Electric conductivity,conductivity,,


  		




  
  39
  
    
Expedition name,projectName,,Consistent (globally unique) between PPM and PT data


  		




  
  40
  
    
Expedition number,projectID,,Consistent (globally unique) between PPM and PT data


  		




  
  41
  
    
Expedition,projectName,,


  		




  
  42
  
    
Family (revised),family,,


  		




  
  43
  
    
Field family,originalFamily,,


  		




  
  44
  
    
Field name,originalGenus,,Often = Genera


  		




  
  45
  
    
FieldFamilyFullName,originalFamily,,


  		




  
  46
  
    
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"


  		




  
  47
  
    
FieldNameAuthors,originalScientificNameAuthorship,,


  		




  
  48
  
    
FieldNameFullName,originalTaxonName,,


  		




  
  49
  
    
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors


  		




  
  50
  
    
First evaluation,eventDate,,


  		




  
  51
  
    
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values


  		




  
  52
  
    
Genera,genus,,


  		




  
  53
  
    
HabitName,growthForm,,


  		




  
  54
  
    
Index collector,recordedBy,,


  		




  
  55
  
    
Institutions,institutionCode,,


  		




  
  56
  
    
Interchangable Calcium,calcium_percent,,Assuming units are % based on the range of values


  		




  
  57
  
    
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values


  		




  
  58
  
    
Interchangeable Magnesium,magnesium_percent,,Assuming units are % based on the range of values


  		




  
  59
  
    
Interchangeable Potassium,potassium_percent,,Assuming units are % based on the range of values


  		




  
  60
  
    
Interchangeable Sodium,sodium_percent,,Assuming units are % based on the range of values


  		




  
  61
  
    
Inventory code,locationID,,


  		




  
  62
  
    
Inventory name,locationName,,


  		




  
  63
  
    
LatitudeDecDeg,decimalLatitude,,


  		




  
  64
  
    
Liana presence,lianaInfestation,,


  		




  
  65
  
    
Limo (DIN 18 123–%–1),silt_percent,,Assuming units are % based on the range of values


  		




  
  66
  
    
LongitudeDecDeg,decimalLongitude,,


  		




  
  67
  
    
LowerName,county,,


  		




  
  68
  
    
MaximumElevationMeters,maximumElevationInMeters,,


  		




  
  69
  
    
Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  70
  
    

  		




  
  71
  
    
[1] Using the following query:


  		




  
  72
  
    
-----


  		




  
  73
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  74
  
    
FROM ""Madidi"".""Plot""


  		




  
  75
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  76
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  77
  
    
-----


  		




  
  78
  
    
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"


  		




  
  79
  
    
MinimumElevationMeters,minimumElevationInMeters,,


  		




  
  80
  
    
MorphoSpeciesName,morphoname,,


  		




  
  81
  
    
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values


  		




  
  82
  
    
Number of subplot,subplot,,


  		




  
  83
  
    
Observaciones,plotNotes,,


  		




  
  84
  
    
Observations,fieldNotes,,


  		




  
  85
  
    
Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction


  		




  
  86
  
    
PlotInventoryName,authorEventCode,,


  		




  
  87
  
    
Qualifier,identificationQualifier,,


  		




  
  88
  
    
SeniorCollector,recordedBy,/_first/1/_merge/1,


  		




  
  89
  
    
Sequence,subplot,,


  		




  
  90
  
    
Slope,slopeGradient,,


  		




  
  91
  
    
Specie+autor,scientificName,,


  		




  
  92
  
    
Species and morphotypes,taxonName,,"Contains less than ""Specie+autor"""


  		




  
  93
  
    
Specimen,catalogNumber,,


  		




  
  94
  
    
SpecimenID,catalogNumber,,


  		




  
  95
  
    
Tag number,tag,,


  		




  
  96
  
    
Textural class,texture,,


  		




  
  97
  
    
Topographical situation,landform,,


  		




  
  98
  
    
Topography,landform,,


  		




  
  99
  
    
Total Nitrogen,nitrogen_percent,,Assuming units are % based on the range of values


  		




  
  100
  
    
Total height,height_m,,Assuming units based on the range and precision of values


  		




  
  101
  
    
Tree number,individualCode,,


  		




  
  102
  
    
Tree,individualCode,,


  		




  
  103
  
    
TreeNotes,fieldNotes,,


  		




  
  104
  
    
Trunk,authorStemCode,,


  		




  
  105
  
    
UpperName,stateProvince,,


  		




  
  106
  
    
Vegetation Type,communityID,,


  		




  
  107
  
    
pH acuoso (ISRIC 4–– 1 - 14),ph,,


  		




  
  108
  
    
pH disolved,ph,,


  		












  

    
      inputs/UNCC/Specimen/map.csv
    
  





  1
  1
  
    
UNCC,VegCore,Filter,Comments


  		




  2
  
  
    
accession,catalogNumber,,"Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  3
  
  
    

  		




  4
  
  
    
[1] Using the following query:


  		




  5
  
  
    
-----


  		




  6
  
  
    
SELECT herbarium, accession, count(*)


  		




  7
  
  
    
FROM ""UNCC"".""Specimen""


  		




  8
  
  
    
GROUP BY herbarium, accession


  		




  9
  
  
    
HAVING count(*) > 1


  		




  
  2
  
    
accession,catalogNumber,,"Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.



  		




  
  3
  
    

  		




  
  4
  
    
[1] Using the following query:



  		




  
  5
  
    
-----



  		




  
  6
  
    
SELECT herbarium, accession, count(*)



  		




  
  7
  
    
FROM ""UNCC"".""Specimen""



  		




  
  8
  
    
GROUP BY herbarium, accession



  		




  
  9
  
    
HAVING count(*) > 1



  		




  10
  10
  
    
-----"


  		




  11
  11
  
    
herbarium,institutionCode,,


  		




  12
  12
  
    
family,family,,


  		




  ......




  28
  28
  
    
country,country,,


  		




  29
  29
  
    
state,stateProvince,,


  		




  30
  30
  
    
county,county,,


  		




  31
  
  
    
campus,fieldNotes,"/_join/5/_label[label=""campus""]/value",


  		




  
  31
  
    
campus,organismNotes,"/_join/5/_label[label=""campus""]/value",


  		




  32
  32
  
    
leaves,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  33
  33
  
    
flower,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  34
  34
  
    
fruit,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  35
  35
  
    
root,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  36
  36
  
    
locality,locality,,


  		




  37
  37
  
    
habitat,habitat,,


  		




  38
  
  
    
comment1,fieldNotes,/_join/1,


  		




  39
  
  
    
comment2,fieldNotes,/_join/2,


  		




  40
  
  
    
comment3,fieldNotes,/_join/3,


  		




  41
  
  
    
comment4,fieldNotes,/_join/4,


  		




  42
  
  
    
loanto,fieldNotes,"/_join/6/_label[label=""loaned to""]/value",


  		




  43
  
  
    
inorout,fieldNotes,"/_join/7/_label[label=""in or out""]/value",


  		




  
  38
  
    
comment1,organismNotes,/_join/1,


  		




  
  39
  
    
comment2,organismNotes,/_join/2,


  		




  
  40
  
    
comment3,organismNotes,/_join/3,


  		




  
  41
  
    
comment4,organismNotes,/_join/4,


  		




  
  42
  
    
loanto,organismNotes,"/_join/6/_label[label=""loaned to""]/value",


  		




  
  43
  
    
inorout,organismNotes,"/_join/7/_label[label=""in or out""]/value",


  		




  44
  44
  
    
sheetno,associatedMedia,,?


  		




  45
  45
  
    
cultivated,cultivated,,Ignore other values


  		




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


  		












  

    
      inputs/SALVIAS-CSV/Organism/map.csv
    
  





  40
  40
  
    
cover_percent,coverPercent,,


  		




  41
  41
  
    
intercept_cm,intercept_cm,,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."


  		




  42
  42
  
    
height_m,height_m,/_alt/2,"""Total height of individual, in meters"" (height_m definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>)"


  		




  43
  
  
    
ht_first_branch_m,heightFirstBranch,,


  		




  
  43
  
    
ht_first_branch_m,heightFirstBranch_m,,


  		




  44
  44
  
    
stem_tag1,tag,/_alt/1/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."


  		




  45
  45
  
    
stem_tag2,tag,/_alt/1/_alt/1,The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: see above


  		




  46
  46
  
    
stem_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"


  		




  47
  
  
    
basal_diam,basalDiameter,,


  		




  
  47
  
    
basal_diam,basalDiameter_cm,,Assuming units are the same as for stem_dbh because the values are similar and they measure the same dimension


  		




  48
  48
  
    
stem_height_m,height_m,/_alt/1,"""Total height of this stem only, in meters"" (stem_height_m definition at < http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: Same as for height, but applies to individuals stems, not trees. Rare."


  		




  49
  
  
    
stem_height_first_branch_m,heightFirstBranch,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."


  		




  
  49
  
    
stem_height_first_branch_m,heightFirstBranch_m,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."


  		




  50
  50
  
    
stem_canopy_form,canopyForm,,


  		




  51
  51
  
    
stem_canopy_position,canopyPosition,,


  		




  52
  52
  
    
stem_liana_infestation,lianaInfestation,,


  		












  

    
      inputs/SALVIAS-CSV/Source/map.csv
    
  





  1
  1
  
    
SALVIAS-CSV,VegCore,Filter,Comments


  		




  2
  2
  
    
:aggregator,referenceType,,


  		




  3
  
  
    
:plot,observationType,,


  		




  
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/CVS/stemCount_/map.csv
    
  





  16
  16
  
    
cust_cvs_corner4Presence,*cust_cvs_corner4Presence,,


  		




  17
  17
  
    
cust_cvs_corner5Presence,*cust_cvs_corner5Presence,,


  		




  18
  18
  
    
cust_cvs_originalCoverCode,*cust_cvs_originalCoverCode,,


  		




  19
  
  
    
STEMCOUNT_ID,aggregateOccurrenceID,,


  		




  
  19
  
    
STEMCOUNT_ID,aggregateOrganismObservationID,,


  		




  20
  20
  
    
stemDiameter,diameterBreastHeight_cm,,


  		




  21
  21
  
    
stemDiameterAccuracy,*stemdiameteraccuracy,,


  		




  22
  22
  
    
stemHeight,height_m,,


  		












  

    
      inputs/CVS/stemLocation_/map.csv
    
  





  1
  1
  
    
CVS,VegCore,Filter,Comments


  		




  2
  
  
    
STEMCOUNT_ID,aggregateOccurrenceID,,


  		




  
  2
  
    
STEMCOUNT_ID,aggregateOrganismObservationID,,


  		




  3
  3
  
    
taxonImportance_ID,OMIT,,Omitted because STEMCOUNT_ID is more specific


  		




  4
  4
  
    
stemDiameter,diameterBreastHeight_cm,,


  		




  5
  5
  
    
stemDiameterAccuracy,*stemdiameteraccuracy,,


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff