Project

General

Profile

« Previous | Next » 

Revision 4636

inputs/*/*/map.csv: Added back automapped mappings to map.csv, using the steps at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Map_refactoring#Add-back-automapped-mappings-to-mapcsv>

View differences:

inputs/SALVIAS/plotObservations/map.csv
68 68
temp_dbh,diameterBreastHeight,
69 69
temp_liandbh,,
70 70
tmp_del,,
71
PlotID_index,,
inputs/U/Specimen/map.csv
10 10
Collmm,monthCollected,
11 11
Collyy,yearCollected,
12 12
DateInfo,,Not used
13
Family,,
14
Genus,,
13 15
cf,identificationQualifier,
14 16
Detby,identifiedBy,
15 17
Detyy,yearIdentified,
16 18
Gazetteer,"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/1",
17 19
Newgazett,"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row
18 20
Majorarea,,
21
Country,,
19 22
Locnotes,VerbatimLocality/_merge/2,
20 23
Coorsyst,,
21 24
Lat,decimalLatitude,
......
26 29
Alt2,,What is this?
27 30
Ecology,habitat,
28 31
Phenology,ReproductiveCondition,
32
Notes,,
inputs/ARIZ/Specimen/new_terms.csv
1
BasisOfRecord
1 2
CatalogNumberNumeric
2 3
TimeCollected
3 4
VerbatimCollectingDate
5
HigherGeography
6
IslandGroup
7
Island
4 8
HorizontalDatum
5 9
OriginalCoordinateSystem
6 10
GeorefMethod
7 11
LatLongComments
12
VerbatimDepth
8 13
IdentificationModifier
14
TypeStatus
15
Preparations
9 16
Tissues
10 17
AgeClass
11 18
GenBankNum
inputs/GBIF/Specimen/new_terms.csv
1
0
2
1
3
3
1 4
LatestDateCollected
2 5
InstitutionCD
3 6
CollectionCD
......
7 10
AuthorOfScientificName
8 11
GBIFFamilyOriginal
9 12
GBIFGenusOriginal
13
25
10 14
MinimumElevationInMeter
11 15
MaximumElevationInMeter
inputs/MT/Specimen/map.csv
1 1
MT[Veg+],Veg+,Comments
2
id,,
3
establishmentMeans,,
4
locality,,
5
language,,
6
collectionID,,
7
occurrenceRemarks,,
8
type,,
9
institutionCode,,
10
rights,,
11
family,,
12
continent,,
13
collectionCode,,
14
datasetName,,
15
rightsHolder,,
16
genus,,
17
basisOfRecord,,
18
individualCount,,
19
countryCode,,
inputs/TEAM/VL/map.csv
1 1
TEAM[Veg+],Veg+,Comments
2
ID,,
2 3
SiteName,projectName,
3 4
1haPlotCode,plotName,
4 5
ObservationDate,eventDate,
6
Family,,
7
Genus,,
8
SpecificEpithet,,
5 9
Collectors,recordedBy,
10
dbh,,
6 11
max_diam,,
7 12
max_diam_pom,,
8 13
ConditionCodes,,
......
10 15
SamplingPeriod,,
11 16
Comments,,
12 17
SamplingUnitName,,
18
Latitude,,
19
Longitude,,
13 20
Method,samplingProtocol,
21
Subplot,,
14 22
X_1haPlot,organismX,
15 23
Y_1haPlot,organismY,
16 24
TreeNumber,tag,
inputs/TEAM/VL/unmapped_terms.csv
9 9
""
10 10
""
11 11
""
12
""
13
""
14
""
15
""
16
""
17
""
18
""
19
""
inputs/TEAM/VT/map.csv
1 1
TEAM[Veg+],Veg+,Comments
2 2
ID,occurrenceID,
3 3
ObservationDate,eventDate,
4
Family,,
5
Genus,,
6
SpecificEpithet,,
4 7
Collectors,recordedBy,
5 8
dbh,diameterBreastHeight,
6 9
dbh_pom,,
......
10 13
SamplingPeriod,,
11 14
Comments,,
12 15
SamplingUnitName,,
16
Latitude,,
17
Longitude,,
13 18
Method,samplingProtocol,
19
Subplot,,
14 20
X_1haPlot,organismX,
15 21
Y_1haPlot,organismY,
16 22
TreeNumber,tag,
inputs/TEAM/VT/unmapped_terms.csv
9 9
""
10 10
""
11 11
""
12
""
13
""
14
""
15
""
16
""
17
""
inputs/NY/Specimen/map.csv
1 1
NY[Veg+],Veg+,Comments
2 2
key,,Not used because UniqueNYInternalRecordNumber is a better pkey
3
DateLastModified,,
4
InstitutionCode,,
5
CollectionCode,,
6
CatalogNumber,,
7
ScientificName,,
8
BasisOfRecord,,
9
Kingdom,,
10
Phylum,,
11
Class,,
12
Order,,
13
Family,,
14
Genus,,
15
Species,,
16
Subspecies,,
17
ScientificNameAuthor,,
18
IdentifiedBy,,
19
YearIdentified,,
20
MonthIdentified,,
21
DayIdentified,,
22
TypeStatus,,
3 23
CollectorNumber,OMIT,"Not used [1], so does not need to be mapped.
4 24

  
5 25
[1] The following query returns no rows: SELECT * FROM ""NY"".""Specimen"" WHERE ""CollectorNumber"" IS NOT NULL"
6 26
FieldNumber,recordNumber,Usage inconsistent with DwC definition
27
Collector,,
28
YearCollected,,
29
MonthCollected,,
30
DayCollected,,
31
JulianDay,,
32
TimeOfDay,,
33
ContinentOcean,,
34
Country,,
35
StateProvince,,
36
County,,
7 37
Locality,Locality/_merge/1,
38
Longitude,,
39
Latitude,,
40
CoordinatePrecision,,
41
BoundingBox,,
8 42
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value,
43
MaximumElevation,,
44
MinimumDepth,,
45
MaximumDepth,,
46
Sex,,
47
PreparationType,,
48
IndividualCount,,
49
PreviousCatalogNumber,,
50
RelationshipType,,
51
RelatedCatalogItem,,
9 52
Notes,Notes/_merge/1,
53
Habitat,,
10 54
PlantFungusDescription,"Notes/_merge/2/_label[label=""plant fungus""]/value",
11 55
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value",
12 56
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value",
inputs/NY/Specimen/new_terms.csv
1 1
key
2
BasisOfRecord
3
TypeStatus
2 4
PlantFungusDescription
3 5
Substrate
4 6
Vegetation
inputs/NY/Specimen/unmapped_terms.csv
1 1
""
2
""
3
""
4
""
5
""
6
""
7
""
8
""
9
""
10
""
11
""
12
""
13
""
14
""
15
""
16
""
17
""
18
""
19
""
20
""
21
""
2 22
OMIT
23
""
24
""
25
""
26
""
27
""
28
""
29
""
30
""
31
""
32
""
3 33
Locality/_merge/1
34
""
35
""
36
""
37
""
4 38
MinimumElevation/_nullIf:[null=.]/value
39
""
40
""
41
""
42
""
43
""
44
""
45
""
46
""
47
""
5 48
Notes/_merge/1
49
""
6 50
"Notes/_merge/2/_label[label=""plant fungus""]/value"
7 51
"Locality/_merge/2/_label[label=""substrate""]/value"
8 52
"Locality/_merge/3/_label[label=""vegetation""]/value"
inputs/Madidi/Organism/map.csv
30 30
Trunk,authorStemCode,
31 31
Total height,height,
32 32
Bole height,,trunk height
33
Habit,,
33 34
Phenology,,
34 35
Crown position,,
35 36
Crown shape,,
inputs/Madidi/Organism/unmapped_terms.csv
15 15
""
16 16
""
17 17
""
18
""
inputs/CTFS/Plot/unmapped_terms.csv
2 2
""
3 3
""
4 4
""
5
""
6
""
7
""
8
""
9
""
10
""
11
""
12
""
13
""
14
""
inputs/FIA/Organism/unmapped_terms.csv
1 1
""
2
""
3
""
4
""
5
""
6
""
7
""
8
""
9
""
10
""
inputs/SALVIAS/plotMetadata/new_terms.csv
54 54
date_finish
55 55
plot_administrator
56 56
tmp_del
57
Country_index
58
PrimOwnerID_index
59
plot_administrator_index
60
project_id_index
inputs/SALVIAS/stems/map.csv
15 15
stem_canopy_position,canopyPosition,
16 16
stem_liana_infestation,lianaInfestation,
17 17
tmp_del,,
18
plotobs_id_index,,
inputs/SALVIAS/stems/unmapped_terms.csv
1 1
""
2 2
""
3
""
inputs/SALVIAS/plotObservations/unmapped_terms.csv
25 25
""
26 26
""
27 27
""
28
""
inputs/ARIZ/Specimen/map.csv
1 1
ARIZ[Veg+],Veg+,Comments
2
GlobalUniqueIdentifier,,
3
DateLastModified,,
4
BasisOfRecord,,
5
InstitutionCode,,
6
CollectionCode,,
2 7
CatalogNumber,CatalogNumber/_alt/2,Don't overwrite CatalogNumberNumeric
3 8
CatalogNumberNumeric,CatalogNumber/_alt/1,
9
Collector,,
10
CollectorNumber,,
4 11
FieldNumber,OMIT,"Usage inconsistent with DwC definition: meaning is recordNumber. Identical to CollectorNumber [1], so does not need to be mapped.
5 12

  
6 13
[1] The following query returns no rows: SELECT * FROM ""ARIZ"".""Specimen"" WHERE ""CollectorNumber"" IS DISTINCT FROM ""FieldNumber"""
14
YearCollected,,
15
MonthCollected,,
16
DayCollected,,
7 17
TimeCollected,eventTime,
8 18
VerbatimCollectingDate,dateCollected/_alt/0,
19
FieldNotes,,
20
JulianDay,,
21
HigherGeography,,
22
ContinentOcean,,
23
IslandGroup,,
24
Island,,
25
Country,,
26
StateProvince,,
27
County,,
28
Locality,,
29
DecimalLatitude,,
30
DecimalLongitude,,
9 31
HorizontalDatum,,Not used
10 32
OriginalCoordinateSystem,verbatimSRS,
33
VerbatimLatitude,,
34
VerbatimLongitude,,
11 35
GeorefMethod,georeferenceProtocol,
36
CoordinateUncertaintyInMeters,,
12 37
LatLongComments,georeferenceRemarks,
38
BoundingBox,,
39
MinimumElevationInMeters,,
40
MaximumElevationInMeters,,
41
VerbatimElevation,,
42
MinimumDepthInMeters,,
43
MaximumDepthInMeters,,
44
VerbatimDepth,,
13 45
ScientificName,ScientificName/_alt/2,
46
Kingdom,,
47
Phylum,,
48
Class,,
49
Order,,
50
Family,,
51
Genus,,
52
Species,,
53
Subspecies,,
14 54
ScientificNameAuthor,ScientificName/_alt/1,Contains the binomial in addition to the authority
55
IdentifiedBy,,
15 56
IdentificationModifier,identificationQualifier,
57
YearIdentified,,
58
MonthIdentified,,
59
DayIdentified,,
60
TypeStatus,,
61
Sex,,
62
Preparations,,
16 63
Tissues,,Not used
64
IndividualCount,,
17 65
AgeClass,lifeStage,
18 66
GenBankNum,"associatedSequences/_label[label=""GenBank""]/value",
19 67
OtherCatalogNumbers,RelatedCatalogItem/_alt/1,
20 68
RelatedCatalogedItems,RelatedCatalogItem/_alt/2,Used only when OtherCatalogNumbers is NULL
69
Remarks,,
inputs/GBIF/Specimen/map.csv
1 1
GBIF[Veg+],Veg+,Comments
2
0,,
3
1,,
4
Collector,,
5
3,,
2 6
LatestDateCollected,dateCollected,
3 7
InstitutionCD,institutionCode,
4 8
CollectionCD,collectionCode,
5 9
CatalogNO,catalogNumber,
6 10
LastDateModified,dcterms:modified,
11
IdentifiedBy,,
7 12
ScientificNameOriginal,verbatimScientificName,
8 13
AuthorOfScientificName,scientificNameAuthorship,
14
ScientificName,,
9 15
GBIFFamilyOriginal,verbatimFamily,
16
Family,,
10 17
GBIFGenusOriginal,verbatimGenus,
18
Genus,,
19
Country,,
20
Locality,,
21
County,,
22
StateProvince,,
23
DecimalLatitude,,
24
VerbatimLatitude,,
25
DecimalLongitude,,
26
VerbatimLongitude,,
27
25,,
11 28
MinimumElevationInMeter,minimumElevationInMeters,
12 29
MaximumElevationInMeter,maximumElevationInMeters,
30
SpecificEpithet,,
31
InfraspecificEpithet,,
inputs/NCU-NCSC/Specimen/map.csv
4 4
Barcode,catalogNumber,
5 5
Full Taxon Name,scientificName,
6 6
Collect Date,dateCollected,
7
Country,,
8
State,,
9
County,,
7 10
Cultivated?,cultivated,
8 11
Elevation,verbatimElevation,
9 12
Lat (-=S),"Latitude/_replace:[""\?$""=]/value",
......
14 17
Alt E/W,,
15 18
Format,preparations,
16 19
Typology,typeStatus,
20
,,
inputs/UNCC/Specimen/map.csv
1 1
UNCC[Veg+],Veg+,Comments
2 2
accession,occurrenceID,
3 3
herbarium,institutionCode,
4
family,,
5
genus,,
6
species,,
4 7
usdaRank,taxonRank/_alt/1,
5 8
infrarank,taxonRank/_alt/2,
6 9
infraname,infraspecificEpithet,
......
14 17
collmonth,monthCollected,
15 18
collday,dayCollected,
16 19
collyear,yearCollected,
20
country,,
21
state,,
22
county,,
17 23
campus,"fieldNotes/_merge/5/_label[label=""campus""]/value",
18 24
leaves,"reproductiveCondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
19 25
flower,"reproductiveCondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
20 26
fruit,"reproductiveCondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
21 27
root,"reproductiveCondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
28
locality,,
29
habitat,,
22 30
comment1,fieldNotes/_merge/1,
23 31
comment2,fieldNotes/_merge/2,
24 32
comment3,fieldNotes/_merge/3,
inputs/UNCC/Specimen/unmapped_terms.csv
1
""
2
""
3
""
1 4
taxonRank/_alt/1
2 5
taxonRank/_alt/2
3 6
Collector/_merge/1
4 7
Collector/_merge/2
5 8
Collector/_merge/3
6 9
Collector/_merge/4
10
""
11
""
12
""
7 13
"fieldNotes/_merge/5/_label[label=""campus""]/value"
8 14
"reproductiveCondition/_map:[A=*,I=*,M=*]/value"
9 15
"reproductiveCondition/_map:[A=*,I=*,M=*]/value"
10 16
"reproductiveCondition/_map:[A=*,I=*,M=*]/value"
11 17
"reproductiveCondition/_map:[A=*,I=*,M=*]/value"
18
""
19
""
12 20
fieldNotes/_merge/1
13 21
fieldNotes/_merge/2
14 22
fieldNotes/_merge/3
inputs/ACAD/Specimen/map.csv
1 1
ACAD[Veg+],Veg+,Comments
2
id,,
3
basisOfRecord,,
4
identifiedBy,,
5
collectionID,,
6
class,,
7
geodeticDatum,,
8
reproductiveCondition,,
9
decimalLongitude,,
10
institutionCode,,
11
continent,,
12
recordedBy,,
13
county,,
14
order,,
15
georeferenceSources,,
16
language,,
17
georeferenceVerificationStatus,,
18
verbatimElevation,,
19
locationRemarks,,
20
dateIdentified,,
21
verbatimDepth,,
22
municipality,,
23
infraspecificEpithet,,
24
modified,,
25
type,,
26
specificEpithet,,
27
identificationRemarks,,
28
rightsHolder,,
29
recordNumber,,
30
eventDate,,
31
rights,,
32
occurrenceRemarks,,
33
habitat,,
34
family,,
35
stateProvince,,
36
scientificNameAuthorship,,
37
scientificName,,
38
taxonRank,,
39
phylum,,
40
locality,,
41
kingdom,,
42
decimalLatitude,,
43
genus,,
44
ownerInstitutionCode,,
45
collectionCode,,
46
bibliographicCitation,,
47
catalogNumber,,
48
country,,
49
dynamicProperties,,
inputs/REMIB/Specimen/map.csv
1 1
REMIB[Veg+],Veg+,Comments
2 2
acronym,collectionCode,
3 3
accession_number,occurrenceID,
4
family,,
5
genus,,
6
specificEpithet,,
7
country,,
8
state,,
9
county,,
10
locality,,
4 11
long_deg,verbatimLongitude,
5 12
long_min,,
6 13
long_sec,,
......
10 17
coll_day,dayCollected,
11 18
coll_month,monthCollected,
12 19
coll_year,yearCollected,
20
collector,,
21
habitat,,
22
preparation,,
inputs/REMIB/Specimen/unmapped_terms.csv
2 2
""
3 3
""
4 4
""
5
""
6
""
7
""
8
""
9
""
10
""
11
""
12
""
13
""
14
""
inputs/CTFS/StemObservation/map.csv
6 6
TreeID,,
7 7
StemID,authorStemCode,
8 8
MeasureID,individualID,
9
CensusID,,
10
DBH,,
9 11
HOM,,
10 12
PrimaryStem,,
11 13
ExactDate,,
14
StemTag,,
12 15
StemDescription,,
13 16
QuadratID,subplot,Not globally unique; unique only within Site
17
PlotID,,
18
Tag,,
14 19
x,organismX,
15 20
y,organismY,
16 21
SubSpeciesCurrentTaxonFlag,,
17 22
SubSpeciesObsoleteTaxonFlag,,
23
SubSpeciesName,,
18 24
SubSpeciesMnemonic,,
19 25
SubSpeciesAuthority,,
20 26
InfraSpecificLevel,,
21 27
SpeciesCurrentTaxonFlag,,
22 28
SpeciesObsoleteTaxonFlag,,
23 29
SpeciesReferenceID,,
30
SpeciesName,,
24 31
SpeciesMnemonic,,
25 32
SpeciesAuthority,scientificNameAuthorship,
26 33
IDLevel,,
27 34
FieldFamily,,
28 35
Description,,
36
Genus,,
29 37
GenusReferenceID,,
30 38
GenusAuthority,,
39
Family,,
31 40
ReferenceID,,
32 41
row_num,,
inputs/CTFS/StemObservation/unmapped_terms.csv
23 23
""
24 24
""
25 25
""
26
""
27
""
28
""
29
""
30
""
31
""
32
""
33
""
34
""
inputs/CTFS/Subplot/map.csv
1 1
CTFS[Veg+],Veg+,Comments
2 2
QuadratID,subplot,Not globally unique; unique only within Site
3
PlotID,,
3 4
QuadratName,OMIT,QuadratID is used for the same purpose
5
StartX,,
6
StartY,,
4 7
DimX,,
5 8
DimY,,
inputs/CTFS/Subplot/unmapped_terms.csv
1
""
1 2
OMIT
2 3
""
3 4
""
5
""
6
""
inputs/CTFS/PlotObservation/map.csv
1 1
CTFS[Veg+],Veg+,Comments
2
CensusID,,
3
PlotID,,
4
PlotCensusNumber,,
5
StartDate,,
6
EndDate,,
2 7
Description,,
inputs/CTFS/PlotObservation/unmapped_terms.csv
1 1
""
2
""
3
""
4
""
5
""
6
""
inputs/CTFS/TaxonOccurrence/map.csv
3 3
GenusID,,
4 4
SpeciesID,,
5 5
SubSpeciesID,,
6
SpeciesInvID,,
7
CensusID,,
8
PlotID,,
6 9
SubSpeciesCurrentTaxonFlag,,
7 10
SubSpeciesObsoleteTaxonFlag,,
11
SubSpeciesName,,
8 12
SubSpeciesMnemonic,,
9 13
SubSpeciesAuthority,,
10 14
InfraSpecificLevel,,"Not used, as the following query returns zero:
......
15 19
SpeciesCurrentTaxonFlag,,
16 20
SpeciesObsoleteTaxonFlag,,
17 21
SpeciesReferenceID,,
22
SpeciesName,,
18 23
SpeciesMnemonic,,
19 24
SpeciesAuthority,,
20 25
IDLevel,,
21 26
FieldFamily,,
22 27
Description,,
28
Genus,,
23 29
GenusReferenceID,,
24 30
GenusAuthority,,
31
Family,,
25 32
ReferenceID,,
26 33
row_num,,
inputs/CTFS/TaxonOccurrence/unmapped_terms.csv
19 19
""
20 20
""
21 21
""
22
""
23
""
24
""
25
""
26
""
27
""
28
""
inputs/CTFS/SubplotObservation/map.csv
1 1
CTFS[Veg+],Veg+,Comments
2
CensusID,,
2 3
QuadratID,subplot,Not globally unique; unique only within Site
4
PlotID,,
inputs/CTFS/Plot/map.csv
1 1
CTFS[Veg+],Veg+,Comments
2 2
CountryID,,
3
PlotID,,
4
PlotName,,
5
LocationName,,
6
Latitude,,
7
Longitude,,
8
Elevation,,
3 9
ReferenceX,,Rarely used
4 10
ReferenceY,,Rarely used
11
SizeOfSite,,
12
ShapeOfSite,,
13
DescriptionOfSite,,
14
CountryName,,
5 15
row_num,,
inputs/FIA/Organism/map.csv
1 1
FIA[Veg+],Veg+,Comments
2 2
TreeTag,tag,
3
Genus,,
4
SpecificEpithet,,
3 5
MeasYear,yearCollected,
4 6
MeasMon,monthCollected,
5 7
MeasDay,dayCollected,
8
DecimalLatitude,,
9
DecimalLongitude,,
6 10
PlotCD,locationID,
11
StateProvince,,
12
County,,
13
DBH,,
7 14
HOM,,
15
BasalDiameter,,
16
Height,,
inputs/SALVIAS/plotMetadata/map.csv
63 63
plot_administrator,,
64 64
plot_notes,,
65 65
tmp_del,,
66
Country_index,,
67
PrimOwnerID_index,,
68
plot_administrator_index,,
69
project_id_index,,
inputs/SALVIAS/plotMetadata/unmapped_terms.csv
36 36
""
37 37
""
38 38
""
39
""
40
""
41
""
42
""
inputs/SALVIAS/stems/new_terms.csv
12 12
stem_canopy_position
13 13
stem_liana_infestation
14 14
tmp_del
15
plotobs_id_index
inputs/SALVIAS/plotObservations/new_terms.csv
50 50
temp_dbh
51 51
temp_liandbh
52 52
tmp_del
53
PlotID_index
inputs/U/Specimen/unmapped_terms.csv
3 3
""
4 4
Collector/_merge/2
5 5
""
6
""
7
""
6 8
"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/1"
7 9
"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/2"
8 10
""
11
""
9 12
VerbatimLocality/_merge/2
10 13
""
11 14
""
......
13 16
""
14 17
""
15 18
ReproductiveCondition
19
""
inputs/ARIZ/Specimen/unmapped_terms.csv
1
""
2
""
3
""
4
""
5
""
1 6
CatalogNumber/_alt/2
2 7
CatalogNumber/_alt/1
8
""
9
""
3 10
OMIT
11
""
12
""
13
""
4 14
eventTime
5 15
dateCollected/_alt/0
6 16
""
17
""
18
""
19
""
20
""
21
""
22
""
23
""
24
""
25
""
26
""
27
""
28
""
7 29
verbatimSRS
30
""
31
""
8 32
georeferenceProtocol
33
""
9 34
georeferenceRemarks
35
""
36
""
37
""
38
""
39
""
40
""
41
""
10 42
ScientificName/_alt/2
43
""
44
""
45
""
46
""
47
""
48
""
49
""
50
""
11 51
ScientificName/_alt/1
12 52
""
53
""
54
""
55
""
56
""
57
""
58
""
59
""
60
""
13 61
lifeStage
14 62
"associatedSequences/_label[label=""GenBank""]/value"
15 63
RelatedCatalogItem/_alt/1
16 64
RelatedCatalogItem/_alt/2
65
""
inputs/GBIF/Specimen/unmapped_terms.csv
1
""
2
""
3
""
4
""
1 5
dcterms:modified
6
""
7
""
8
""
9
""
10
""
11
""
12
""
13
""
14
""
15
""
16
""
17
""
18
""
19
""
20
""
inputs/NCU-NCSC/Specimen/unmapped_terms.csv
1
""
2
""
3
""
1 4
"Latitude/_replace:[""\?$""=]/value"
2 5
"Longitude/_replace:[""\?$""=]/value"
3 6
""
......
5 8
""
6 9
preparations
7 10
typeStatus
11
""
inputs/VegBank/taxonobservation_/unmapped_terms.csv
48 48
""
49 49
""
50 50
""
51
""
52
""
53
""
54
""
55
""
56
""
57
""
58
""
59
""
inputs/VegBank/taxonobservation_/map.csv
26 26
reference_id,,
27 27
originalinterpretation,,
28 28
currentinterpretation,,
29
taxonfit,,
29 30
taxonconfidence,,
30 31
collector_id,,
31 32
collectionnumber,,
32 33
museum_id,,
33 34
museumaccessionnumber,catalogNumber,
34 35
grouptype,,
36
notes,,
35 37
notespublic,,
36 38
notesmgt,,
37 39
revisions,,
......
47 49
d_obscount,,
48 50
d_currentaccepted,,
49 51
plantconcept_accessioncode,,
52
Kingdom,,
50 53
Subkingdom,,
51 54
Superdivision,,
52 55
Division,,
53 56
Subdivision,,
57
Class,,
54 58
Subclass,,
59
Order,,
60
Family,,
61
Genus,,
62
Species,,
63
Subspecies,,
55 64
Variety,,
56 65
Forma,,
57 66
row_num,,
inputs/VegBank/plot_/map.csv
8 8
locationaccuracy,coordinateUncertaintyInMeters,
9 9
confidentialitystatus,,
10 10
confidentialityreason,,
11
latitude,,
12
longitude,,
11 13
authore,,
12 14
authorn,,
13 15
authorzone,,
14 16
authordatum,,
15 17
authorlocation,,
18
locationnarrative,,
16 19
azimuth,,
17 20
dsgpoly,,
18 21
shape,footprintWKT,
......
21 24
placementmethod,,
22 25
permanence,,
23 26
layoutnarrative,,
27
elevation,,
24 28
elevationaccuracy,,
25 29
elevationrange,,
30
slopeaspect,,
31
minslopeaspect,,
32
maxslopeaspect,,
33
slopegradient,,
34
minslopegradient,,
35
maxslopegradient,,
26 36
topoposition,,
37
landform,,
27 38
surficialdeposits,,
28 39
rocktype,,
40
stateprovince,,
41
country,,
29 42
submitter_surname,,
30 43
submitter_givenname,,
31 44
submitter_email,,
......
36 49
emb_plot,,
37 50
plotrationalenarrative,,
38 51
accessioncode,,
52
continent,,
39 53
area|country|territory,country,
40 54
region|state|province,stateProvince,
55
county,,
41 56
quadrangle,,
42 57
Geographic Name,,
43 58
row_num,,
inputs/MO/Specimen/new_terms.csv
1
BasisOfRecord
2
TypeStatus
1 3
convertednotes
inputs/VegBank/observation_/unmapped_terms.csv
98 98
""
99 99
""
100 100
""
101
""
102
""
103
""
104
""
inputs/MO/Specimen/map.csv
1 1
MO[Veg+],Veg+,Comments
2
CatalogNumber,,
3
DateLastModified,,
4
InstitutionCode,,
5
CollectionCode,,
6
ScientificName,,
7
BasisOfRecord,,
8
Kingdom,,
9
family,,
10
genus,,
11
species,,
12
Subspecies,,
13
ScientificNameAuthor,,
14
IdentifiedBy,,
15
TypeStatus,,
16
CollectorNumber,,
17
Collector,,
18
DayCollected,,
19
MonthCollected,,
20
YearCollected,,
21
ContinentOcean,,
22
Country,,
23
StateProvince,,
24
County,,
25
Locality,,
26
longitude,,
27
latitude,,
28
MinimumElevation,,
29
MaximumElevation,,
30
IndividualCount,,
31
notes,,
2 32
convertednotes,fieldNotes,
inputs/VegBank/observation_/map.csv
1 1
VegBank[Veg+],Veg+,Comments
2 2
observation_id,eventID,
3 3
previousobs_id,,
4
plot_id,,
5
project_id,,
6
authorobscode,,
4 7
dateaccuracy,,
5 8
covermethod_id,,
6 9
coverdispersion,,
......
107 110
soilcoarse,,
108 111
soilph,ph,
109 112
exchangecapacity,cationExchangeCapacity,
113
basesaturation,,
110 114
soildescription,,
111 115
emb_soilobs,,
112 116
row_num,,
inputs/VegBank/plot_/unmapped_terms.csv
33 33
""
34 34
""
35 35
""
36
""
37
""
38
""
39
""
40
""
41
""
42
""
43
""
44
""
45
""
46
""
47
""
48
""
49
""
50
""
inputs/QMOR/Specimen/map.csv
1 1
QMOR[Veg+],Veg+,Comments
2
id,,
3
locationRemarks,,
4
decimalLongitude,,
5
stateProvince,,
6
typeStatus,,
7
institutionID,,
8
identificationRemarks,,
9
genus,,
10
georeferenceSources,,
11
samplingProtocol,,
12
country,,
13
georeferencedBy,,
14
acceptedNameUsage,,
15
institutionCode,,
16
decimalLatitude,,
17
catalogNumber,,
18
verbatimLongitude,,
19
verbatimEventDate,,
20
county,,
21
nomenclaturalCode,,
22
georeferenceRemarks,,
23
occurrenceRemarks,,
24
continent,,
25
bibliographicCitation,,
26
verbatimSRS,,
27
scientificNameAuthorship,,
28
datasetName,,
29
preparations,,
30
sex,,
31
locality,,
32
waterBody,,
33
behavior,,
34
collectionID,,
35
lifeStage,,
36
habitat,,
37
eventDate,,
38
minimumElevationInMeters,,
39
eventRemarks,,
40
kingdom,,
41
class,,
42
rightsHolder,,
43
verbatimCoordinateSystem,,
44
language,,
45
verbatimCoordinates,,
46
rights,,
47
type,,
48
footprintWKT,,
49
collectionCode,,
50
georeferenceProtocol,,
51
verbatimLatitude,,
52
geodeticDatum,,
53
identifiedBy,,
54
datasetID,,
55
georeferencedDate,,
56
taxonRank,,
57
family,,
58
phylum,,
59
modified,,
60
order,,
61
coordinateUncertaintyInMeters,,
62
basisOfRecord,,
63
scientificName,,
64
maximumElevationInMeters,,
65
dateIdentified,,
66
individualCount,,
67
municipality,,
68
identificationQualifier,,
69
eventTime,,
70
recordedBy,,
71
specificEpithet,,
72
verbatimElevation,,
73
ownerInstitutionCode,,
74
infraspecificEpithet,,

Also available in: Unified diff