Revision 4636
Added by Aaron Marcuse-Kubitza about 12 years ago
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
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>