Project

General

Profile

« Previous | Next » 

Revision 10209

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/*/*/map.csv for CSV tables with a row_num column: added missing row_num entry, which is needed by the staging table column renaming to make the order of the map.csv columns match the order in the staging table

View differences:

inputs/HVAA/Specimen/map.csv
1 1 
HVAA,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
institutionCode,specimenHolderInstitutions,,
3 4 
collectionCode,collection,,
4 5 
basisOfRecord,basisOfRecord,,
inputs/HVAA/Specimen/VegBIEN.csv
123 123 
ownerInstitutionCode,,** No join mapping for specimenOwner **
124 124 
preparations,,** No join mapping for preparations **
125 125 
rightsHolder,,** No join mapping for dataOwners **
126 
row_num,,** No join mapping for *row_num **
126 127 
startDayOfYear,,** No join mapping for startDayOfYear **
127 128 
typeStatus,,** No join mapping for typeStatus **
128 129 
verbatimCoordinateSystem,,** No join mapping for coordinateUnits **
inputs/HVAA/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
basisOfRecord
2 3 
otherCatalogNumbers
3 4 
specimenOwner
inputs/MT/Specimen/map.csv
1 1 
MT,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
establishmentMeans,establishmentMeans,,
4 5 
locality,locality,,
inputs/MT/Specimen/VegBIEN.csv
33 33 
datasetName,,** No join mapping for dataset **
34 34 
language,,** No join mapping for language **
35 35 
rightsHolder,,** No join mapping for dataOwners **
36 
row_num,,** No join mapping for *row_num **
36 37 
type,,** No join mapping for type **
inputs/MT/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
language
2 3 
type
3 4 
dataset
inputs/test_taxonomic_names/Taxon/map.csv
1 1 
test_taxonomic_names,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
scientificNameID,scientificNameID,,
3 4 
scientificName,taxonName,,
inputs/test_taxonomic_names/Taxon/VegBIEN.csv
3 3 
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode,
4 4 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
5 5 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
6 
row_num,,** No join mapping for *row_num **
inputs/test_taxonomic_names/Taxon/unmapped_terms.csv
1 
*row_num
inputs/XAL/Specimen/map.csv
1 1 
XAL:/content/record/,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
darwin:DateLastModified,modified,,
3 4 
darwin:InstitutionCode,specimenHolderInstitutions,,
4 5 
darwin:CollectionCode,collection,,
inputs/XAL/Specimen/VegBIEN.csv
80 80 
darwin:RelationshipType,,** No join mapping for relationshipOfResource **
81 81 
darwin:TimeOfDay,,** No join mapping for eventTime **
82 82 
darwin:TypeStatus,,** No join mapping for typeStatus **
83 
row_num,,** No join mapping for *row_num **
inputs/XAL/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
modified
2 3 
basisOfRecord
3 4 
typeStatus
inputs/CTFS/SubplotObservation/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
CensusID,eventID,,
3 4 
QuadratID,subplot,,Not globally unique; unique only within Site
4 5 
PlotID,locationID,,
inputs/CTFS/Subplot/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
QuadratID,subplot,,Not globally unique; unique only within Site
3 4 
PlotID,locationID,,
4 5 
QuadratName,OMIT,,QuadratID is used for the same purpose
inputs/CTFS/PlotObservation/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
CensusID,eventID,,
3 4 
PlotID,locationID,,
4 5 
PlotCensusNumber,authorEventCode,,
inputs/.geoscrub/geoscrub_output/map.csv
1 1 
geoscrub,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
decimallatitude,decimalLatitude,,
3 4 
decimallongitude,decimalLongitude,,
4 5 
country,country,,
inputs/.geoscrub/geoscrub_output/unmapped_terms.csv
1 
*row_num
inputs/ACAD/Specimen/VegBIEN.csv
95 95 
municipality,,** No join mapping for municipality **
96 96 
ownerInstitutionCode,,** No join mapping for specimenOwner **
97 97 
rightsHolder,,** No join mapping for dataOwners **
98 
row_num,,** No join mapping for *row_num **
98 99 
type,,** No join mapping for type **
99 100 
verbatimDepth,,** No join mapping for verbatimDepth **
inputs/WIN/Specimen/map.csv
1 1 
WIN,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
municipality,municipality,,
4 5 
verbatimLongitude,verbatimLongitude,,
inputs/WIN/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
municipality
2 3 
dataOwners
3 4 
associatedMedia
inputs/CTFS/SubplotObservation/unmapped_terms.csv
1 
*row_num
inputs/CTFS/Subplot/unmapped_terms.csv
1 
*row_num
1 2 
*DimX
2 3 
*DimY
inputs/NCU/Specimen/map.csv
1 1 
NCU,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
SpecimenPK,occurrenceID,,
3 4 
DerivedFromID,*DerivedFromID,,
4 5 
CollectionObjectTypeID,*CollectionObjectTypeID,,
inputs/NCU/Specimen/VegBIEN.csv
73 73 
TypeStatus,,** No join mapping for typeStatus **
74 74 
database,,** No join mapping for *database **
75 75 
lastAnnotationAgent,,** No join mapping for *lastAnnotationAgent **
76 
row_num,,** No join mapping for *row_num **
inputs/NCU/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
*DerivedFromID
2 3 
*CollectionObjectTypeID
3 4 
*CollectionObjectID
inputs/TEAM/VL/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
Id,individualObservationID,,
3 4 
Observation Date,eventDate,,
4 5 
Family,family,,
inputs/TEAM/VL/VegBIEN.csv
54 54 
Protocol Version,,** No join mapping for *Protocol Version **
55 55 
Sampling Period,,** No join mapping for *Sampling Period **
56 56 
Sampling Unit Name,,** No join mapping for *Sampling Unit Name **
57 
row_num,,** No join mapping for *row_num **
inputs/TEAM/VL/unmapped_terms.csv
1 
*row_num
1 2 
*Max Diameter
2 3 
*Max Diameter POM
3 4 
*Condition Codes
inputs/TEAM/VT/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
Id,individualObservationID,,
3 4 
Observation Date,eventDate,,
4 5 
Family,family,,
inputs/TEAM/VT/VegBIEN.csv
54 54 
Sampling Period,,** No join mapping for *Sampling Period **
55 55 
Sampling Unit Name,,** No join mapping for *Sampling Unit Name **
56 56 
Spatial Method,,"** No non-empty join mapping for OMIT ** Just contains ""Derived"", for 14927 rows"
57 
row_num,,** No join mapping for *row_num **
inputs/TEAM/VT/unmapped_terms.csv
1 
*row_num
1 2 
*POM Height
2 3 
*New Diameter
3 4 
*New POM Height
inputs/TEAM/TEAM_Sites/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
Site Name,projectName,,
3 4 
Name,locationName,,
4 5 
1ha Plot Coordinate,*1ha Plot Coordinate,,
inputs/TEAM/TEAM_Sites/VegBIEN.csv
14 14 
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
15 15 
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
16 16 
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate **
17 
row_num,,** No join mapping for *row_num **
inputs/TEAM/TEAM_Sites/unmapped_terms.csv
1 
*row_num
1 2 
*1ha Plot Coordinate
inputs/.geoscrub/Source/VegBIEN.csv
1 1 
geoscrub,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
3 
row_num,,** No join mapping for *row_num **
inputs/.geoscrub/geoscrub_output/VegBIEN.csv
38 38 
"" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT)"
39 39 
stateprovince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
40 40 
stateprovince,/location/locationplace/*_id/place/stateprovince,
41 
row_num,,** No join mapping for *row_num **
inputs/ACAD/Specimen/map.csv
1 1 
ACAD,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
basisOfRecord,basisOfRecord,,
4 5 
identifiedBy,identifiedBy,,
inputs/ACAD/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
basisOfRecord
2 3 
geodeticDatum
3 4 
georeferenceSources
inputs/WIN/Specimen/VegBIEN.csv
91 91 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
92 92 
ownerInstitutionCode,,** No join mapping for specimenOwner **
93 93 
rightsHolder,,** No join mapping for dataOwners **
94 
row_num,,** No join mapping for *row_num **
94 95 
type,,** No join mapping for type **
95 96 
verbatimCoordinateSystem,,** No join mapping for coordinateUnits **
96 97 
verbatimEventDate,,** No join mapping for verbatimEventDate **
inputs/CTFS/SubplotObservation/VegBIEN.csv
17 17 
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
18 18 
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
19 19 
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site
20 
row_num,,** No join mapping for *row_num **
inputs/CTFS/Subplot/VegBIEN.csv
18 18 
DimX,,** No join mapping for *DimX **
19 19 
DimY,,** No join mapping for *DimY **
20 20 
QuadratName,,** No non-empty join mapping for OMIT ** QuadratID is used for the same purpose
21 
row_num,,** No join mapping for *row_num **
inputs/CTFS/AggregateObservation/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
DWstagingID,occurrenceID,,
3 4 
Country,country,,
4 5 
Province,stateProvince,,
inputs/TEX/Specimen/VegBIEN.csv
68 68 
LONG EW,,** No join mapping for *LONG EW **
69 69 
SOURCE OF LATLONG,,** No join mapping for *SOURCE OF LATLONG **
70 70 
UTM,,** No join mapping for *UTM **
71 
row_num,,** No join mapping for *row_num **
inputs/TEX/Specimen2/unmapped_terms.csv
1 
*row_num
1 2 
barcode
2 3 
*SUBSPECIES AUTHOR
3 4 
*VARIETY AUTHOR
inputs/CTFS/PlotObservation/unmapped_terms.csv
1 
*row_num
1 2 
*Description
inputs/TEX/Specimen/map.csv
1 1 
TEX,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
HERBARIUM,collection,,
3 4 
ACCESSION NO.,accessionNumber,,
4 5 
COLLECTOR NAME(S),recordedBy,,
inputs/TEX/Specimen2/VegBIEN.csv
69 69 
SUBSPECIES AUTHOR,,** No join mapping for *SUBSPECIES AUTHOR **
70 70 
UTM,,** No join mapping for *UTM **
71 71 
VARIETY AUTHOR,,** No join mapping for *VARIETY AUTHOR **
72 
row_num,,** No join mapping for *row_num **
inputs/U/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
*Majorarea
2 3 
*Coorsyst
3 4 
*NS
inputs/CTFS/PlotObservation/VegBIEN.csv
22 22 
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
23 23 
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
24 24 
Description,,** No join mapping for *Description **
25 
row_num,,** No join mapping for *row_num **
inputs/CTFS/AggregateObservation/unmapped_terms.csv
1 
*row_num
1 2 
*MeanDate
inputs/TEX/Specimen2/map.csv
1 1 
TEX,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
HERBARIUM,collection,,
3 4 
BARCODE,barcode,,
4 5 
FAMILY,family,,
inputs/U/Specimen/VegBIEN.csv
64 64 
NS,,** No join mapping for *NS **
65 65 
Prefix,,** No non-empty join mapping for UNUSED **
66 66 
Suffix,,** No non-empty join mapping for UNUSED **
67 
row_num,,** No join mapping for *row_num **
inputs/CTFS/AggregateObservation/VegBIEN.csv
46 46 
Province,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
47 47 
Province,/location/locationplace/*_id/place/stateprovince,
48 48 
MeanDate,,** No join mapping for *MeanDate **
49 
row_num,,** No join mapping for *row_num **
inputs/TEX/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
infraspecificRank
2 3 
*INFRA AUTHORITY
3 4 
*LAT NS
inputs/U/Specimen/map.csv
1 1 
U,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
ID,dataProviderRecordID,,
3 4 
Barcode,accessionNumber,,
4 5 
Collector,recordedBy,/_join/1,
inputs/GBIF/map.csv
1 1 
GBIF,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
data_provider_id,*data_provider_id,,
4 5 
data_resource_id,*data_resource_id,,
inputs/JBM/Specimen/map.csv
1 1 
JBM,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
minimumElevationInMeters,minimumElevationInMeters,,
4 5 
verbatimLatitude,verbatimLatitude,,
inputs/UBC/Specimen/VegBIEN.csv
104 104 
previousIdentifications,,** No join mapping for previousIdentifications **
105 105 
references,,** No join mapping for distributors **
106 106 
rightsHolder,,** No join mapping for dataOwners **
107 
row_num,,** No join mapping for *row_num **
107 108 
type,,** No join mapping for type **
108 109 
typeStatus,,** No join mapping for typeStatus **
109 110 
verbatimSRS,,** No join mapping for verbatimSRS **
inputs/SpeciesLink/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
modified
2 3 
basisOfRecord
3 4 
day
inputs/Madidi/IndividualObservation/map.csv
1 1 
Madidi,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
PlotID,locationID,,
3 4 
PlotName,locationName,,
4 5 
OrientationXDegrees,*OrientationXDegrees,,
inputs/Madidi/LocationObservation/VegBIEN.csv
68 68 
Qualifier Interchangeable Calcium,,** No join mapping for *Qualifier Interchangeable Calcium **
69 69 
Textural Class (select),,** No join mapping for *Textural Class (select) **
70 70 
Topographic location,,** No join mapping for *Topographic location **
71 
row_num,,** No join mapping for *row_num **
inputs/Madidi/Location/unmapped_terms.csv
1 
*row_num
1 2 
*OrientationXDegrees
2 3 
*OrientationYDegrees
3 4 
*FirstSurveyDate
inputs/SALVIAS-CSV/Organism/map.csv
1 1 
SALVIAS-CSV,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
OBSERVATION_ID,individualID,,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
3 4 
PLOT_ID,locationID,,
4 5 
plot_code,locationName,,
inputs/QFA/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
associatedSequences
2 3 
dataset
3 4 
typeStatus
inputs/UBC/Specimen/map.csv
1 1 
UBC,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
collectionCode,collection,,
4 5 
identificationQualifier,identificationQualifier,,
inputs/SpeciesLink/Specimen/VegBIEN.csv
326 326 
dwc_terms_typeStatus,,** No join mapping for typeStatus **
327 327 
dwc_terms_year,,** No join mapping for year **
328 328 
http__purl_org_dc_terms_modified,,** No join mapping for modified **
329 
row_num,,** No join mapping for *row_num **
inputs/HIBG/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
dataOwners
2 3 
verbatimSRS
3 4 
distributors
inputs/Madidi/LocationObservation/map.csv
1 1 
Madidi,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
PlotID,locationID,/_first/2,
3 4 
PlotName,locationID,/_first/1,
4 5 
PlotInventoryName,authorEventCode,,
inputs/Madidi/Location/VegBIEN.csv
30 30 
FirstSurveyDate,,** No join mapping for *FirstSurveyDate **
31 31 
OrientationXDegrees,,** No join mapping for *OrientationXDegrees **
32 32 
OrientationYDegrees,,** No join mapping for *OrientationYDegrees **
33 
row_num,,** No join mapping for *row_num **
inputs/UNCC/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
specimenDonorInstitution
2 3 
*leaves
3 4 
*root
inputs/QFA/Specimen/VegBIEN.csv
96 96 
ownerInstitutionCode,,** No join mapping for specimenOwner **
97 97 
preparations,,** No join mapping for preparations **
98 98 
rightsHolder,,** No join mapping for dataOwners **
99 
row_num,,** No join mapping for *row_num **
99 100 
type,,** No join mapping for type **
100 101 
typeStatus,,** No join mapping for typeStatus **
101 102 
verbatimCoordinateSystem,,** No join mapping for coordinateUnits **
inputs/JBM/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
modified
2 3 
specimenOwner
3 4 
language
inputs/SpeciesLink/Specimen/map.csv
1 1 
SpeciesLink,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
3 4 
dwc_dwcore_DateLastModified,modified,,
4 5 
dwc_dwcore_BasisOfRecord,basisOfRecord,,
inputs/HIBG/Specimen/VegBIEN.csv
103 103 
ownerInstitutionCode,,** No join mapping for specimenOwner **
104 104 
references,,** No join mapping for distributors **
105 105 
rightsHolder,,** No join mapping for dataOwners **
106 
row_num,,** No join mapping for *row_num **
106 107 
type,,** No join mapping for type **
107 108 
verbatimCoordinateSystem,,** No join mapping for coordinateUnits **
108 109 
verbatimDepth,,** No join mapping for verbatimDepth **
inputs/Madidi/IndividualObservation/unmapped_terms.csv
1 
*row_num
1 2 
*OrientationXDegrees
2 3 
*OrientationYDegrees
3 4 
*WasCollected
inputs/Madidi/Location/map.csv
1 1 
Madidi,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
PlotID,locationID,,
3 4 
PlotName,locationName,,
4 5 
Area,plotArea_ha,,
inputs/UNCC/Specimen/VegBIEN.csv
132 132 
herbarium,,"** No join mapping for specimenDonorInstitution/_map:[UNCCD=UNCC,*=*]/value ** ""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."
133 133 
leaves,,** No join mapping for *leaves **
134 134 
root,,** No join mapping for *root **
135 
row_num,,** No join mapping for *row_num **
135 136 
sheetno,,** No join mapping for associatedMedia ** ?
inputs/QFA/Specimen/map.csv
1 1 
QFA,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
rights,rights,,
4 5 
recordNumber,collectorNumber,,
inputs/JBM/Specimen/VegBIEN.csv
78 78 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
79 79 
ownerInstitutionCode,,** No join mapping for specimenOwner **
80 80 
rightsHolder,,** No join mapping for dataOwners **
81 
row_num,,** No join mapping for *row_num **
81 82 
type,,** No join mapping for type **
inputs/UBC/Specimen/unmapped_terms.csv
1 
*row_num
1 2 
nomenclaturalCode
2 3 
dataOwners
3 4 
preparations
inputs/HIBG/Specimen/map.csv
1 1 
HIBG,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
id,dataProviderRecordID,,
3 4 
county,county,,
4 5 
dateIdentified,dateIdentified,,
inputs/Madidi/IndividualObservation/VegBIEN.csv
224 224 
WeightRachis4,,** No non-empty join mapping for UNUSED **
225 225 
WeightRachis5,,** No non-empty join mapping for UNUSED **
226 226 
WidthButtresses,,** No non-empty join mapping for UNUSED **
227 
row_num,,** No join mapping for *row_num **
inputs/Madidi/LocationObservation/unmapped_terms.csv
1 
*row_num
1 2 
*Other epilocs
2 3 
*Political Location
3 4 
*Plot Compass Direction
inputs/UNCC/Specimen/map.csv
1 1 
UNCC,VegCore,Filter,Comments
2 
row_num,*row_num,,
2 3 
accession,accessionNumber,,"Globally unique, although occasionally duplicated. [1]
3 4 

  		




  4
  5
  
    
[1] Using the following query:


  		












  

    
      inputs/SALVIAS-CSV/Organism/VegBIEN.csv
    
  





  136
  136
  
    
fam_status,,** No join mapping for *fam_status ** Brad: OMIT. This will be determined later by using TNRS.


  		




  137
  137
  
    
gen_status,,** No join mapping for *gen_status ** Brad: OMIT. This will be determined later by using TNRS.


  		




  138
  138
  
    
ind_id,,** No join mapping for *ind_id ** Brad: OMIT


  		




  
  139
  
    
row_num,,** No join mapping for *row_num ** 


  		




  139
  140
  
    
species_status,,"** No join mapping for *species_status ** 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."


  		












  

    
      inputs/SALVIAS-CSV/Plot/VegBIEN.csv
    
  





  60
  60
  
    
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."


  		




  61
  61
  
    
PLOT_ID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."


  		




  62
  62
  
    
recensused,,"** No join mapping for *recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"


  		




  
  63
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/REMIB/Specimen/VegBIEN.csv
    
  





  102
  102
  
    
state,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"


  		




  103
  103
  
    
state,"/location/locationplace/*_id/place/stateprovince/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"


  		




  104
  104
  
    
preparation,,** No join mapping for preparations ** 


  		




  
  105
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/IUCN/European_Red_List_Plants/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*IUCN Red List Category (Europe)


  		




  2
  3
  
    
*IUCN Red List Criteria (Europe)


  		




  3
  4
  
    
*IUCN Red List Category (EU 27)


  		












  

    
      inputs/SALVIAS-CSV/Plot/map.csv
    
  





  1
  1
  
    
SALVIAS-CSV,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
project,projectName,,


  		




  3
  4
  
    
PLOT_ID,locationID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."


  		




  4
  5
  
    
plot_code,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)


  		












  

    
      inputs/REMIB/Specimen/map.csv
    
  





  1
  1
  
    
REMIB,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
acronym,specimenHolderInstitutions,,


  		




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


  		




  4
  5
  
    

  		












  

    
      inputs/IUCN/European_Red_List_Plants/VegBIEN.csv
    
  





  17
  17
  
    
IUCN Red List Category (Europe),,** No join mapping for *IUCN Red List Category (Europe) ** 


  		




  18
  18
  
    
IUCN Red List Criteria (EU 27),,** No join mapping for *IUCN Red List Criteria (EU 27) ** 


  		




  19
  19
  
    
IUCN Red List Criteria (Europe),,** No join mapping for *IUCN Red List Criteria (Europe) ** 


  		




  
  20
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/SALVIAS-CSV/Organism/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*ind_id


  		




  2
  3
  
    
*collector_code


  		




  3
  4
  
    
*fam_status


  		












  

    
      inputs/TurboVeg/Source/map.csv
    
  





  1
  1
  
    
TurboVeg,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		












  

    
      inputs/IUCN/European_Red_List_Plants/map.csv
    
  





  1
  1
  
    
IUCN,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Family,family,,


  		




  3
  4
  
    
Species,specificEpithet,,


  		




  4
  5
  
    
IUCN Red List Category (Europe),*IUCN Red List Category (Europe),,


  		












  

    
      inputs/SALVIAS-CSV/Plot/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*recensused


  		












  

    
      inputs/REMIB/Specimen/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
preparations


  		












  

    
      inputs/.TNRS/Source/VegBIEN.csv
    
  





  1
  1
  
    
TNRS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments


  		




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


  		




  
  3
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/TaxonOccurrence.Understory/VegBIEN.csv
    
  





  28
  28
  
    
Tier Description,,** No join mapping for *Tier Description ** 


  		




  29
  29
  
    
Tier ID,,** No join mapping for *Tier ID ** 


  		




  30
  30
  
    
Value,,** No join mapping for *Value ** 


  		




  
  31
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/StemObservation/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Method Name


  		




  2
  3
  
    
*Taxon Bio Status


  		




  3
  4
  
    
*Taxon Palatibility


  		












  

    
      inputs/NVS/TaxonOccurrence/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Project Abbreviation,projectName,,


  		




  3
  4
  
    
Plot,locationName,,


  		




  4
  5
  
    
Sub Plot,subplot,,


  		












  

    
      inputs/NVS/Project/VegBIEN.csv
    
  





  6
  6
  
    
Description,,** No join mapping for *Description ** 


  		




  7
  7
  
    
Is Current,,** No join mapping for *Is Current ** 


  		




  8
  8
  
    
Name,,** No join mapping for *Name ** 


  		




  
  9
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/Coordinates/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Plot Obs ID


  		




  2
  3
  
    
type


  		




  3
  4
  
    
*XPrecision


  		












  

    
      inputs/TRT/Specimen/map.csv
    
  





  1
  1
  
    
TRT,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
id,dataProviderRecordID,,


  		




  3
  4
  
    
maximumElevationInMeters,maximumElevationInMeters,,


  		




  4
  5
  
    
dateIdentified,dateIdentified,,


  		












  

    
      inputs/MO/Specimen/VegBIEN.csv
    
  





  72
  72
  
    
minimumday,,** No join mapping for day ** 


  		




  73
  73
  
    
minimummonth,,** No join mapping for month ** 


  		




  74
  74
  
    
minimumyear,,** No join mapping for year ** 


  		




  
  75
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/TRTE/Specimen/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
bibliographicCitation


  		




  2
  3
  
    
language


  		




  3
  4
  
    
type


  		












  

    
      inputs/NVS/StemObservation/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Project Abbreviation,projectName,,


  		




  3
  4
  
    
Plot,locationName,,


  		




  4
  5
  
    
Sub Plot,subplot,,


  		












  

    
      inputs/NVS/AggregateOccurrence/VegBIEN.csv
    
  





  29
  29
  
    
Tier,,** No join mapping for *Tier ** 


  		




  30
  30
  
    
Tier Description,,** No join mapping for *Tier Description ** 


  		




  31
  31
  
    
Tier ID,,** No join mapping for *Tier ID ** 


  		




  
  32
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/TaxonOccurrence/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Method Name


  		




  2
  3
  
    
*Taxon Bio Status


  		




  3
  4
  
    
*Taxon Palatibility


  		












  

    
      inputs/NVS/Coordinates/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Plot Obs ID,*Plot Obs ID,,


  		




  3
  4
  
    
Project Abbreviation,projectName,,


  		




  4
  5
  
    
Plot,locationName,,


  		












  

    
      inputs/NVS/Plot/VegBIEN.csv
    
  





  26
  26
  
    
Permanence,,** No join mapping for *Permanence ** 


  		




  27
  27
  
    
Placement,,** No join mapping for *Placement ** 


  		




  28
  28
  
    
Slope Shape,,** No join mapping for *Slope Shape ** 


  		




  
  29
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/TRT/Specimen/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
typeStatus


  		




  2
  3
  
    
associatedReferences


  		




  3
  4
  
    
georeferenceProtocol


  		












  

    
      inputs/TRTE/Specimen/map.csv
    
  





  1
  1
  
    
TRTE,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
id,dataProviderRecordID,,


  		




  3
  4
  
    
collectionCode,collection,,


  		




  4
  5
  
    
genus,genus,,


  		












  

    
      inputs/NVS/TaxonOccurrence.Understory/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Method Name


  		




  2
  3
  
    
*Taxon Bio Status


  		




  3
  4
  
    
*Taxon Palatibility


  		












  

    
      inputs/NVS/AggregateOccurrence/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Project Abbreviation,projectName,,


  		




  3
  4
  
    
Plot,locationName,,


  		




  4
  5
  
    
Sub Plot,subplot,,


  		












  

    
      inputs/NVS/TaxonOccurrence/VegBIEN.csv
    
  





  24
  24
  
    
Severity,,** No join mapping for *Severity ** 


  		




  25
  25
  
    
Taxon Bio Status,,** No join mapping for *Taxon Bio Status ** 


  		




  26
  26
  
    
Taxon Palatibility,,** No join mapping for *Taxon Palatibility ** 


  		




  
  27
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/Project/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Is Current


  		




  2
  3
  
    
*Name


  		




  3
  4
  
    
*Description


  		












  

    
      inputs/NVS/Plot/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Plot,locationName,,


  		




  3
  4
  
    
Sub Plot,subplot,,


  		




  4
  5
  
    
Area,plotArea_m2,,Area Units is always m


  		












  

    
      inputs/TRT/Specimen/VegBIEN.csv
    
  





  113
  113
  
    
ownerInstitutionCode,,** No join mapping for specimenOwner ** 


  		




  114
  114
  
    
previousIdentifications,,** No join mapping for previousIdentifications ** 


  		




  115
  115
  
    
rightsHolder,,** No join mapping for dataOwners ** 


  		




  
  116
  
    
row_num,,** No join mapping for *row_num ** 


  		




  116
  117
  
    
type,,** No join mapping for type ** 


  		




  117
  118
  
    
typeStatus,,** No join mapping for typeStatus ** 


  		




  118
  119
  
    
verbatimCoordinateSystem,,** No join mapping for coordinateUnits ** 


  		












  

    
      inputs/MO/Specimen/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*elevationunits


  		




  2
  3
  
    
day


  		




  3
  4
  
    
month


  		












  

    
      inputs/NVS/TaxonOccurrence.Understory/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Project Abbreviation,projectName,,


  		




  3
  4
  
    
Plot,locationName,,


  		




  4
  5
  
    
Sub Plot,subplot,,


  		












  

    
      inputs/NVS/StemObservation/VegBIEN.csv
    
  





  46
  46
  
    
Taxon Bio Status,,** No join mapping for *Taxon Bio Status ** 


  		




  47
  47
  
    
Taxon Palatibility,,** No join mapping for *Taxon Palatibility ** 


  		




  48
  48
  
    
Units,,** No join mapping for *Units ** 


  		




  
  49
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/AggregateOccurrence/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Method Name


  		




  2
  3
  
    
*Taxon Bio Status


  		




  3
  4
  
    
*Taxon Palatibility


  		












  

    
      inputs/NVS/Project/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
Project ID,projectID,,


  		




  3
  4
  
    
Project Abbreviation,projectName,,


  		




  4
  5
  
    
Is Current,*Is Current,,


  		












  

    
      inputs/NVS/Coordinates/VegBIEN.csv
    
  





  19
  19
  
    
Type,,** No join mapping for type ** 


  		




  20
  20
  
    
Units,,** No join mapping for *Units ** 


  		




  21
  21
  
    
XPrecision,,** No join mapping for *XPrecision ** 


  		




  
  22
  
    
row_num,,** No join mapping for *row_num ** 


  		












  

    
      inputs/NVS/Plot/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  1
  2
  
    
*Area Units


  		




  2
  3
  
    
*Altitude Units


  		




  3
  4
  
    
*Aspect


  		












  

    
      inputs/MO/Specimen/map.csv
    
  





  1
  1
  
    
MO,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  2
  3
  
    
specimenid,dataProviderRecordID,,


  		




  3
  4
  
    
collectorstring,recordedBy,,


  		




  4
  5
  
    
collectionnumber,collectorNumber,,


  		












  

    
      inputs/TRTE/Specimen/VegBIEN.csv
    
  





  97
  97
  
    
ownerInstitutionCode,,** No join mapping for specimenOwner ** 


  		




  98
  98
  
    
previousIdentifications,,** No join mapping for previousIdentifications ** 


  		




  99
  99
  
    
rightsHolder,,** No join mapping for dataOwners ** 


  		




  
  100
  
    
row_num,,** No join mapping for *row_num ** 


  		




  100
  101
  
    
type,,** No join mapping for type ** 


  		




  101
  102
  
    
verbatimCoordinateSystem,,** No join mapping for coordinateUnits ** 


  		




  102
  103
  
    
verbatimEventDate,,** No join mapping for verbatimEventDate ** 


  		












Also available in:  Unified diff