Revision 4504
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/SpeciesLink/Specimen/map.full.csv | ||
|---|---|---|
| 1 | 1 |
"SpeciesLink[Veg+,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",Veg+,Comments |
| 2 |
BoundingBox,BoundingBox |
|
| 3 |
CatalogNumber,CatalogNumber |
|
| 4 |
Class,Class |
|
| 5 |
CollectionCode,CollectionCode |
|
| 6 |
Collector,Collector |
|
| 7 |
CollectorNumber,CollectorNumber |
|
| 8 |
Continent,Continent |
|
| 9 |
ContinentOcean,ContinentOcean |
|
| 10 |
CoordinatePrecision,CoordinatePrecision |
|
| 11 |
Country,Country |
|
| 12 |
County,County |
|
| 13 |
DayCollected,DayCollected |
|
| 14 |
DayIdentified,DayIdentified |
|
| 15 |
DecimalLatitude,DecimalLatitude |
|
| 16 |
DecimalLongitude,DecimalLongitude |
|
| 17 |
Family,Family |
|
| 18 |
Genus,Genus |
|
| 19 |
GlobalUniqueIdentifier,GlobalUniqueIdentifier |
|
| 20 |
IdentifiedBy,IdentifiedBy |
|
| 21 |
IndividualCount,IndividualCount |
|
| 22 |
InfraspecificEpithet,InfraspecificEpithet |
|
| 23 |
InstitutionCode,InstitutionCode |
|
| 24 | 2 |
JulianDay,JulianDay/_alt/1, |
| 25 | 3 |
DayOfYear,JulianDay/_alt/2, |
| 26 |
Kingdom,Kingdom |
|
| 27 |
Latitude,Latitude |
|
| 28 |
Locality,Locality |
|
| 29 |
Longitude,Longitude |
|
| 30 |
MaximumDepth,MaximumDepth |
|
| 31 |
MaximumDepthInMeters,MaximumDepthInMeters |
|
| 32 |
MaximumElevation,MaximumElevation |
|
| 33 |
MaximumElevationInMeters,MaximumElevationInMeters |
|
| 34 |
MinimumDepth,MinimumDepth |
|
| 35 |
MinimumDepthInMeters,MinimumDepthInMeters |
|
| 36 |
MinimumElevation,MinimumElevation |
|
| 37 |
MinimumElevationInMeters,MinimumElevationInMeters |
|
| 38 |
MonthCollected,MonthCollected |
|
| 39 |
MonthIdentified,MonthIdentified |
|
| 40 |
Notes,Notes |
|
| 41 |
Order,Order |
|
| 42 |
Phylum,Phylum |
|
| 43 |
Remarks,Remarks |
|
| 44 |
ScientificName,ScientificName |
|
| 45 | 4 |
scientificNameAuthorship,ScientificNameAuthor/_alt/1, |
| 46 | 5 |
ScientificNameAuthor,ScientificNameAuthor/_alt/2, |
| 47 | 6 |
AuthorYearOfScientificName,ScientificNameAuthor/_alt/3, |
| 48 |
Sex,Sex |
|
| 49 |
Species,Species |
|
| 50 |
SpecificEpithet,SpecificEpithet |
|
| 51 |
StateProvince,StateProvince |
|
| 52 |
Subspecies,Subspecies |
|
| 53 |
VerbatimLatitude,VerbatimLatitude |
|
| 54 |
VerbatimLongitude,VerbatimLongitude |
|
| 55 |
YearCollected,YearCollected |
|
| 56 |
YearIdentified,YearIdentified |
|
| 7 |
boundingBox,boundingBox |
|
| 57 | 8 |
catalogNumber,catalogNumber |
| 58 | 9 |
class,class |
| 59 | 10 |
collectionCode,collectionCode |
| 60 | 11 |
collectionID,collectionID |
| 12 |
collector,collector |
|
| 13 |
collectorNumber,collectorNumber |
|
| 61 | 14 |
continent,continent |
| 15 |
continentOcean,continentOcean |
|
| 16 |
coordinatePrecision,coordinatePrecision |
|
| 62 | 17 |
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters |
| 63 | 18 |
country,country |
| 64 | 19 |
county,county |
| 65 | 20 |
dateIdentified,dateIdentified |
| 21 |
dayCollected,dayCollected |
|
| 22 |
dayIdentified,dayIdentified |
|
| 66 | 23 |
dc_terms_modified,dcterms:modified, |
| 67 | 24 |
decimalLatitude,decimalLatitude |
| 68 | 25 |
decimalLongitude,decimalLongitude |
| 69 | 26 |
family,family |
| 70 | 27 |
genus,genus |
| 28 |
globalUniqueIdentifier,globalUniqueIdentifier |
|
| 71 | 29 |
identifiedBy,identifiedBy |
| 72 | 30 |
individualCount,individualCount |
| 73 | 31 |
infraspecificEpithet,infraspecificEpithet |
| 74 | 32 |
institutionCode,institutionCode |
| 75 | 33 |
kingdom,kingdom |
| 34 |
latitude,latitude |
|
| 76 | 35 |
locality,locality |
| 36 |
longitude,longitude |
|
| 37 |
maximumDepth,maximumDepth |
|
| 77 | 38 |
maximumDepthInMeters,maximumDepthInMeters |
| 39 |
maximumElevation,maximumElevation |
|
| 78 | 40 |
maximumElevationInMeters,maximumElevationInMeters |
| 41 |
minimumDepth,minimumDepth |
|
| 79 | 42 |
minimumDepthInMeters,minimumDepthInMeters |
| 43 |
minimumElevation,minimumElevation |
|
| 80 | 44 |
minimumElevationInMeters,minimumElevationInMeters |
| 45 |
monthCollected,monthCollected |
|
| 46 |
monthIdentified,monthIdentified |
|
| 47 |
notes,notes |
|
| 81 | 48 |
order,order |
| 82 | 49 |
phylum,phylum |
| 83 | 50 |
recordNumber,recordNumber/_alt/1, |
| ... | ... | |
| 92 | 59 |
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
|
| 93 | 60 |
-----" |
| 94 | 61 |
recordedBy,recordedBy |
| 62 |
remarks,remarks |
|
| 95 | 63 |
scientificName,scientificName |
| 96 | 64 |
sex,sex |
| 65 |
species,species |
|
| 97 | 66 |
specificEpithet,specificEpithet |
| 98 | 67 |
stateProvince,stateProvince |
| 68 |
subspecies,subspecies |
|
| 99 | 69 |
verbatimLatitude,verbatimLatitude |
| 100 | 70 |
verbatimLongitude,verbatimLongitude |
| 71 |
yearCollected,yearCollected |
|
| 72 |
yearIdentified,yearIdentified |
|
| inputs/MO/Specimen/map.full.csv | ||
|---|---|---|
| 1 | 1 |
MO[Veg+],Veg+,Comments |
| 2 |
CatalogNumber,CatalogNumber |
|
| 3 |
CollectionCode,CollectionCode |
|
| 4 |
Collector,Collector |
|
| 5 |
CollectorNumber,CollectorNumber |
|
| 6 |
ContinentOcean,ContinentOcean |
|
| 7 |
Country,Country |
|
| 8 |
County,County |
|
| 9 |
DayCollected,DayCollected |
|
| 10 |
IdentifiedBy,IdentifiedBy |
|
| 11 |
IndividualCount,IndividualCount |
|
| 12 |
InstitutionCode,InstitutionCode |
|
| 13 |
Kingdom,Kingdom |
|
| 14 |
Locality,Locality |
|
| 15 |
MaximumElevation,MaximumElevation |
|
| 16 |
MinimumElevation,MinimumElevation |
|
| 17 |
MonthCollected,MonthCollected |
|
| 18 |
ScientificName,ScientificName |
|
| 19 |
ScientificNameAuthor,ScientificNameAuthor |
|
| 20 |
StateProvince,StateProvince |
|
| 21 |
Subspecies,Subspecies |
|
| 22 |
YearCollected,YearCollected |
|
| 2 |
catalogNumber,catalogNumber |
|
| 3 |
collectionCode,collectionCode |
|
| 4 |
collector,collector |
|
| 5 |
collectorNumber,collectorNumber |
|
| 6 |
continentOcean,continentOcean |
|
| 7 |
country,country |
|
| 8 |
county,county |
|
| 9 |
dayCollected,dayCollected |
|
| 23 | 10 |
family,family |
| 24 | 11 |
genus,genus |
| 12 |
identifiedBy,identifiedBy |
|
| 13 |
individualCount,individualCount |
|
| 14 |
institutionCode,institutionCode |
|
| 15 |
kingdom,kingdom |
|
| 25 | 16 |
latitude,latitude |
| 17 |
locality,locality |
|
| 26 | 18 |
longitude,longitude |
| 19 |
maximumElevation,maximumElevation |
|
| 20 |
minimumElevation,minimumElevation |
|
| 21 |
monthCollected,monthCollected |
|
| 27 | 22 |
convertednotes,notes, |
| 28 | 23 |
notes,notes |
| 24 |
scientificName,scientificName |
|
| 25 |
scientificNameAuthor,scientificNameAuthor |
|
| 29 | 26 |
species,species |
| 27 |
stateProvince,stateProvince |
|
| 28 |
subspecies,subspecies |
|
| 29 |
yearCollected,yearCollected |
|
| bin/intersect | ||
|---|---|---|
| 1 | 1 |
#!/usr/bin/env python |
| 2 | 2 |
# Intersects two map spreadsheets A0->B and A1->C to A->B, with B overwriting C |
| 3 | 3 |
# Multi-safe (supports an input appearing multiple times). |
| 4 |
# Case- and punctuation-insensitive. |
|
| 4 | 5 |
|
| 5 | 6 |
import csv |
| 6 | 7 |
import os.path |
| ... | ... | |
| 21 | 22 |
if compare_col_nums == []: |
| 22 | 23 |
compare_col_nums = None # list_subset() value for all columns |
| 23 | 24 |
|
| 24 |
def compare_on(row): return tuple(util.list_subset(row, compare_col_nums)) |
|
| 25 |
def compare_on(row): return tuple(map(maps.simplify, |
|
| 26 |
util.list_subset(row, compare_col_nums))) |
|
| 25 | 27 |
|
| 26 | 28 |
headers = [None]*2 |
| 27 | 29 |
|
| mappings/Makefile | ||
|---|---|---|
| 94 | 94 |
vegcsvMaps += Veg+.cs-VegBIEN.csv |
| 95 | 95 |
|
| 96 | 96 |
Veg+-VegBIEN.csv: Veg+.cs-VegBIEN.csv |
| 97 |
$(bin)/ci_map $< >$@
|
|
| 97 |
$(cp)
|
|
| 98 | 98 |
vegcsvMaps += Veg+-VegBIEN.csv |
| 99 | 99 |
|
| 100 | 100 |
vegcsv_maps: _always $(vegcsvMaps) ; |
| inputs/XAL/Specimen/map.full.csv | ||
|---|---|---|
| 1 | 1 |
"XAL[Veg+,darwin:]:/content/record/",Veg+,Comments |
| 2 |
CatalogNumber,CatalogNumber |
|
| 3 |
Class,Class |
|
| 4 |
CollectionCode,CollectionCode |
|
| 5 |
Collector,Collector |
|
| 6 |
ContinentOcean,ContinentOcean |
|
| 7 |
CoordinatePrecision,CoordinatePrecision |
|
| 8 |
Country,Country |
|
| 9 |
County,County |
|
| 10 |
DayCollected,DayCollected |
|
| 11 |
DayIdentified,DayIdentified |
|
| 12 |
Family,Family |
|
| 13 |
Genus,Genus |
|
| 14 |
IdentifiedBy,IdentifiedBy |
|
| 15 |
IndividualCount,IndividualCount |
|
| 16 |
InstitutionCode,InstitutionCode |
|
| 17 |
Kingdom,Kingdom |
|
| 18 |
Latitude,Latitude |
|
| 19 |
Locality,Locality |
|
| 20 |
Longitude,Longitude |
|
| 21 |
MaximumDepth,MaximumDepth |
|
| 22 |
MaximumElevation,MaximumElevation |
|
| 23 |
MinimumDepth,MinimumDepth |
|
| 24 |
MinimumElevation,MinimumElevation |
|
| 25 |
MonthCollected,MonthCollected |
|
| 26 |
MonthIdentified,MonthIdentified |
|
| 27 |
Notes,Notes |
|
| 28 |
Order,Order |
|
| 29 |
Phylum,Phylum |
|
| 30 |
ScientificName,ScientificName |
|
| 31 |
ScientificNameAuthor,ScientificNameAuthor |
|
| 32 |
Sex,Sex |
|
| 33 |
Species,Species |
|
| 34 |
StateProvince,StateProvince |
|
| 35 |
Subspecies,Subspecies |
|
| 36 |
YearCollected,YearCollected |
|
| 37 |
YearIdentified,YearIdentified |
|
| 2 |
catalogNumber,catalogNumber |
|
| 3 |
class,class |
|
| 4 |
collectionCode,collectionCode |
|
| 5 |
collector,collector |
|
| 6 |
continentOcean,continentOcean |
|
| 7 |
coordinatePrecision,coordinatePrecision |
|
| 8 |
country,country |
|
| 9 |
county,county |
|
| 10 |
dayCollected,dayCollected |
|
| 11 |
dayIdentified,dayIdentified |
|
| 12 |
family,family |
|
| 13 |
genus,genus |
|
| 14 |
identifiedBy,identifiedBy |
|
| 15 |
individualCount,individualCount |
|
| 16 |
institutionCode,institutionCode |
|
| 17 |
kingdom,kingdom |
|
| 18 |
latitude,latitude |
|
| 19 |
locality,locality |
|
| 20 |
longitude,longitude |
|
| 21 |
maximumDepth,maximumDepth |
|
| 22 |
maximumElevation,maximumElevation |
|
| 23 |
minimumDepth,minimumDepth |
|
| 24 |
minimumElevation,minimumElevation |
|
| 25 |
monthCollected,monthCollected |
|
| 26 |
monthIdentified,monthIdentified |
|
| 27 |
notes,notes |
|
| 28 |
order,order |
|
| 29 |
phylum,phylum |
|
| 38 | 30 |
CollectorNumber,recordNumber/_alt/1, |
| 39 | 31 |
FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines." |
| 32 |
scientificName,scientificName |
|
| 33 |
scientificNameAuthor,scientificNameAuthor |
|
| 34 |
sex,sex |
|
| 35 |
species,species |
|
| 36 |
stateProvince,stateProvince |
|
| 37 |
subspecies,subspecies |
|
| 38 |
yearCollected,yearCollected |
|
| 39 |
yearIdentified,yearIdentified |
|
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
"XAL[Veg+,darwin:]:/content/record/",VegBIEN:,Comments |
| 2 |
InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
|
|
| 3 |
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
|
|
| 4 |
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
|
|
| 5 |
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 6 |
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 7 |
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 8 |
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 9 |
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
|
|
| 10 |
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
|
|
| 11 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 14 |
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 15 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 16 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
|
|
| 17 |
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 18 |
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 19 |
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 20 |
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 21 |
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 22 |
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 23 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
|
|
| 27 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
|
|
| 2 |
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
|
|
| 3 |
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
|
|
| 4 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
|
|
| 5 |
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 6 |
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 7 |
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 8 |
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 9 |
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
|
|
| 10 |
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
|
|
| 11 |
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 14 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 15 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 16 |
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
|
|
| 17 |
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 18 |
monthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 19 |
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 20 |
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 21 |
monthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 22 |
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 23 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
|
|
| 27 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
|
|
| 28 | 28 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1, |
| 29 | 29 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines." |
| 30 |
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
|
|
| 31 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
|
|
| 32 |
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
|
|
| 33 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
|
|
| 30 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
|
|
| 31 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
|
|
| 32 |
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
|
|
| 33 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
|
|
| 34 | 34 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 35 | 35 |
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines." |
| 36 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
|
| 37 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
|
| 38 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
|
| 39 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
|
| 40 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
|
| 41 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2", |
|
| 42 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 43 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 44 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 45 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| 46 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname", |
|
| 47 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname", |
|
| 48 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname", |
|
| 49 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname", |
|
| 50 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 51 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 52 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 53 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
|
| 54 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 55 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
|
| 56 |
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
|
| 57 |
Locality,/location/locationnarrative/_merge/1, |
|
| 36 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
|
| 37 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
|
| 38 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
|
| 39 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
|
| 40 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
|
| 41 |
scientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2", |
|
| 42 |
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 43 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 44 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 45 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| 46 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname", |
|
| 47 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname", |
|
| 48 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname", |
|
| 49 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname", |
|
| 50 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
|
| 51 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
|
| 52 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
|
| 53 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
|
| 54 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 55 |
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
|
| 56 |
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
|
| 57 |
locality,/location/locationnarrative/_merge/1, |
|
| inputs/TEAM/VT/map.full.csv | ||
|---|---|---|
| 1 | 1 |
TEAM[Veg+],Veg+,Comments |
| 2 | 2 |
dbh,DBH, |
| 3 |
Family,Family |
|
| 4 |
Genus,Genus |
|
| 5 |
Latitude,Latitude |
|
| 6 |
Longitude,Longitude |
|
| 7 |
SpecificEpithet,SpecificEpithet |
|
| 8 |
Subplot,Subplot |
|
| 9 | 3 |
ObservationDate,eventDate, |
| 4 |
family,family |
|
| 5 |
genus,genus |
|
| 10 | 6 |
ID,id, |
| 7 |
latitude,latitude |
|
| 8 |
longitude,longitude |
|
| 11 | 9 |
X_1haPlot,organismX, |
| 12 | 10 |
Y_1haPlot,organismY, |
| 13 | 11 |
1haPlotCode,plotName, |
| 14 | 12 |
SiteName,projectName, |
| 15 | 13 |
Collectors,recordedBy, |
| 16 | 14 |
Method,samplingProtocol, |
| 15 |
specificEpithet,specificEpithet |
|
| 16 |
subplot,subplot |
|
| 17 | 17 |
TreeNumber,tag, |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TEAM[Veg+],VegBIEN:,Comments |
| 2 |
Subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
|
|
| 2 |
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
|
|
| 3 | 3 |
1haPlotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1", |
| 4 | 4 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1haPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 |
Subplot,/location/authorlocationcode,
|
|
| 7 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 6 |
subplot,/location/authorlocationcode,
|
|
| 7 |
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 9 | 9 |
Method,/location/locationevent/*_id/method/name, |
| 10 | 10 |
SiteName,/location/locationevent/*_id/project/projectname, |
| 11 |
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
|
|
| 11 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
|
|
| 12 | 12 |
1haPlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 13 | 13 |
ObservationDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1, |
| 14 | 14 |
ObservationDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1, |
| ... | ... | |
| 17 | 17 |
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
| 18 | 18 |
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition, |
| 19 | 19 |
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition, |
| 20 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 21 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 22 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 20 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 21 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 22 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 23 | 23 |
Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| inputs/NY/Specimen/map.full.csv | ||
|---|---|---|
| 1 | 1 |
NY[Veg+],Veg+,Comments |
| 2 |
BoundingBox,BoundingBox |
|
| 3 |
CatalogNumber,CatalogNumber |
|
| 4 |
Class,Class |
|
| 5 |
CollectionCode,CollectionCode |
|
| 6 |
Collector,Collector |
|
| 7 |
CollectorNumber,CollectorNumber |
|
| 8 |
ContinentOcean,ContinentOcean |
|
| 9 |
CoordinatePrecision,CoordinatePrecision |
|
| 10 |
Country,Country |
|
| 11 |
County,County |
|
| 12 |
DayCollected,DayCollected |
|
| 13 |
DayIdentified,DayIdentified |
|
| 14 |
Family,Family |
|
| 15 |
Genus,Genus |
|
| 16 |
Habitat,Habitat |
|
| 17 |
IdentifiedBy,IdentifiedBy |
|
| 18 |
IndividualCount,IndividualCount |
|
| 19 |
InstitutionCode,InstitutionCode |
|
| 20 |
Kingdom,Kingdom |
|
| 21 |
Latitude,Latitude |
|
| 22 | 2 |
Locality,Locality/_merge/1, |
| 23 | 3 |
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value", |
| 24 | 4 |
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value", |
| 25 |
Longitude,Longitude |
|
| 26 |
MaximumDepth,MaximumDepth |
|
| 27 |
MaximumElevation,MaximumElevation |
|
| 28 |
MinimumDepth,MinimumDepth |
|
| 29 | 5 |
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value, |
| 30 |
MonthCollected,MonthCollected |
|
| 31 |
MonthIdentified,MonthIdentified |
|
| 32 | 6 |
Notes,Notes/_merge/1, |
| 33 | 7 |
PlantFungusDescription,"Notes/_merge/2/_label[label=""plant fungus""]/value", |
| 34 |
Order,Order |
|
| 35 |
Phylum,Phylum |
|
| 36 |
ScientificName,ScientificName |
|
| 37 |
ScientificNameAuthor,ScientificNameAuthor |
|
| 38 |
Sex,Sex |
|
| 39 |
Species,Species |
|
| 40 |
StateProvince,StateProvince |
|
| 41 |
Subspecies,Subspecies |
|
| 42 |
YearCollected,YearCollected |
|
| 43 |
YearIdentified,YearIdentified |
|
| 8 |
boundingBox,boundingBox |
|
| 9 |
catalogNumber,catalogNumber |
|
| 10 |
class,class |
|
| 11 |
collectionCode,collectionCode |
|
| 12 |
collector,collector |
|
| 13 |
collectorNumber,collectorNumber |
|
| 14 |
continentOcean,continentOcean |
|
| 15 |
coordinatePrecision,coordinatePrecision |
|
| 16 |
country,country |
|
| 17 |
county,county |
|
| 18 |
dayCollected,dayCollected |
|
| 19 |
dayIdentified,dayIdentified |
|
| 20 |
family,family |
|
| 21 |
genus,genus |
|
| 22 |
habitat,habitat |
|
| 23 |
identifiedBy,identifiedBy |
|
| 24 |
individualCount,individualCount |
|
| 25 |
institutionCode,institutionCode |
|
| 26 |
kingdom,kingdom |
|
| 27 |
latitude,latitude |
|
| 28 |
longitude,longitude |
|
| 29 |
maximumDepth,maximumDepth |
|
| 30 |
maximumElevation,maximumElevation |
|
| 31 |
minimumDepth,minimumDepth |
|
| 32 |
monthCollected,monthCollected |
|
| 33 |
monthIdentified,monthIdentified |
|
| 44 | 34 |
UniqueNYInternalRecordNumber,occurrenceID, |
| 35 |
order,order |
|
| 36 |
phylum,phylum |
|
| 45 | 37 |
FieldNumber,recordNumber,Usage inconsistent with DwC definition |
| 38 |
scientificName,scientificName |
|
| 39 |
scientificNameAuthor,scientificNameAuthor |
|
| 40 |
sex,sex |
|
| 41 |
species,species |
|
| 42 |
stateProvince,stateProvince |
|
| 43 |
subspecies,subspecies |
|
| 44 |
yearCollected,yearCollected |
|
| 45 |
yearIdentified,yearIdentified |
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
NY[Veg+],VegBIEN:,Comments |
| 2 | 2 |
UniqueNYInternalRecordNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 |
InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
|
|
| 4 |
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
|
|
| 5 |
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
|
|
| 6 |
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 3 |
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
|
|
| 4 |
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
|
|
| 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
|
|
| 6 |
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 7 | 7 |
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value", |
| 8 | 8 |
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value", |
| 9 |
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 9 |
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 10 | 10 |
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value", |
| 11 |
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
|
|
| 12 |
BoundingBox,/location/locationdetermination/footprintgeometry_dwc,
|
|
| 13 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 15 |
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 16 |
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 17 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 18 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
|
|
| 19 |
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 20 |
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 21 |
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 22 |
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 23 |
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 27 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 28 |
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
|
|
| 11 |
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
|
|
| 12 |
boundingBox,/location/locationdetermination/footprintgeometry_dwc,
|
|
| 13 |
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 15 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 16 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 17 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 18 |
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
|
|
| 19 |
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 20 |
monthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 21 |
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 22 |
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 23 |
monthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 27 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 28 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
|
|
| 29 | 29 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1, |
| 30 | 30 |
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2/_label[label=""plant fungus""]/value", |
| 31 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
|
|
| 31 |
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
|
|
| 32 | 32 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,Usage inconsistent with DwC definition |
| 33 |
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
|
|
| 34 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
|
|
| 35 |
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
|
|
| 36 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
|
|
| 33 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
|
|
| 34 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
|
|
| 35 |
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
|
|
| 36 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
|
|
| 37 | 37 |
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 38 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
|
|
| 38 |
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
|
|
| 39 | 39 |
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition |
| 40 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
|
|
| 41 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
|
|
| 42 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
|
|
| 43 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
|
|
| 44 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 45 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
|
|
| 46 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 47 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 48 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 49 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 50 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 51 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 52 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 53 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 54 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 55 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 56 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 57 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
|
|
| 58 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
|
|
| 59 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 60 |
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 40 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
|
|
| 41 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
|
|
| 42 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
|
|
| 43 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
|
|
| 44 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 45 |
scientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
|
|
| 46 |
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 47 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 48 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 49 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 50 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 51 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 52 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 53 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 54 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 55 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 56 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 57 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
|
|
| 58 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
|
|
| 59 |
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 60 |
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 61 | 61 |
Locality,/location/locationnarrative/_merge/1/_merge/1, |
| 62 | 62 |
Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value", |
| 63 | 63 |
Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value", |
| 64 |
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
|
| 64 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
|
| inputs/Madidi/Organism/map.full.csv | ||
|---|---|---|
| 1 | 1 |
Madidi[Veg+],Veg+,Comments |
| 2 |
Habit,Habit |
|
| 3 | 2 |
Trunk,authorStemCode, |
| 4 | 3 |
Specimen,catalogNumber, |
| 5 | 4 |
Diameter,diameterBreastHeight, |
| 6 | 5 |
Family (revised),family, |
| 7 | 6 |
Observations,fieldNotes, |
| 8 | 7 |
Genera,genus, |
| 8 |
habit,habit |
|
| 9 | 9 |
Total height,height, |
| 10 | 10 |
Qualifier,identificationQualifier, |
| 11 | 11 |
Determined by,identifiedBy, |
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
Subplot Y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition, |
| 24 | 24 |
Tree number,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2, |
| 25 | 25 |
Specie+autor,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| 26 |
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""HemiepÃfito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
|
| 26 |
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""HemiepÃfito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
|
| 27 | 27 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 28 | 28 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 29 | 29 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
GROUP BY ""PLOT_ID"", subplot |
| 21 | 21 |
HAVING count(DISTINCT census_date) > 1 |
| 22 | 22 |
-----" |
| 23 |
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
|
| 24 |
----- |
|
| 25 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
|
| 26 |
FROM ""SALVIAS-CSV"".organisms |
|
| 27 |
WHERE subplot IS NOT NULL AND census_date IS NOT NULL |
|
| 28 |
GROUP BY ""PLOT_ID"", subplot |
|
| 29 |
HAVING count(DISTINCT census_date) > 1 |
|
| 30 |
-----" |
|
| 31 | 23 |
no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"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." |
| 32 | 24 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 33 | 25 |
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
</parent_id> |
| 10 | 10 |
<authorlocationcode>$subplot</authorlocationcode> |
| 11 | 11 |
<locationevent> |
| 12 |
<obsstartdate> |
|
| 13 |
<_date> |
|
| 14 |
<date> |
|
| 15 |
<_dateRangeStart> |
|
| 16 |
<value> |
|
| 17 |
<_alt> |
|
| 18 |
<0>$census_date</0> |
|
| 19 |
<1>$census_date</1> |
|
| 20 |
</_alt> |
|
| 21 |
</value> |
|
| 22 |
</_dateRangeStart> |
|
| 23 |
</date> |
|
| 24 |
</_date> |
|
| 25 |
</obsstartdate> |
|
| 12 |
<obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate> |
|
| 26 | 13 |
<taxonoccurrence> |
| 27 | 14 |
<aggregateoccurrence> |
| 28 | 15 |
<count>$no_of_individuals</count> |
| inputs/CTFS/StemObservation/map.full.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],Veg+,Comments |
| 2 | 2 |
CensusID,CensusID |
| 3 | 3 |
DBH,DBH |
| 4 |
Family,Family |
|
| 5 |
Genus,Genus |
|
| 6 |
PlotID,PlotID |
|
| 7 | 4 |
QuadratID,QuadratID |
| 8 |
SpeciesName,SpeciesName |
|
| 9 |
StemTag,StemTag |
|
| 10 |
SubSpeciesName,SubSpeciesName |
|
| 11 |
Tag,Tag |
|
| 12 | 5 |
StemID,authorStemCode, |
| 6 |
family,family |
|
| 7 |
genus,genus |
|
| 13 | 8 |
MeasureID,individualID, |
| 14 | 9 |
x,organismX, |
| 15 | 10 |
y,organismY, |
| 11 |
plotID,plotID |
|
| 16 | 12 |
SpeciesAuthority,scientificNameAuthorship, |
| 13 |
speciesName,speciesName |
|
| 14 |
stemTag,stemTag |
|
| 15 |
subSpeciesName,subSpeciesName |
|
| 16 |
tag,tag |
|
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],VegBIEN:,Comments |
| 2 | 2 |
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 3 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 3 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 4 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 6 | 6 |
QuadratID,/location/authorlocationcode/_first/1, |
| 7 | 7 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 9 | 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
| 10 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 10 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 11 | 11 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 12 | 12 |
MeasureID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode, |
| 13 | 13 |
StemID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode, |
| 14 | 14 |
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
| 15 |
StemTag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
|
|
| 16 |
Tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
|
|
| 15 |
stemTag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
|
|
| 16 |
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
|
|
| 17 | 17 |
x,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition, |
| 18 | 18 |
y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition, |
| 19 | 19 |
MeasureID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2, |
| 20 | 20 |
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/1", |
| 21 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 22 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 23 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 24 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| 21 |
subSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 22 |
speciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 23 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 24 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| inputs/CTFS/Subplot/map.full.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],Veg+,Comments |
| 2 |
PlotID,PlotID |
|
| 3 | 2 |
QuadratID,QuadratID |
| 4 | 3 |
QuadratName,QuadratName |
| 5 | 4 |
StartX,StartX |
| 6 | 5 |
StartY,StartY |
| 6 |
plotID,plotID |
|
| inputs/CTFS/Subplot/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],VegBIEN:,Comments |
| 2 | 2 |
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 3 | 3 |
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2", |
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 5 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 6 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 4 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 5 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 6 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 7 | 7 |
QuadratID,/location/authorlocationcode/_first/1, |
| 8 | 8 |
QuadratName,/location/authorlocationcode/_first/2, |
| 9 | 9 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 10 | 10 |
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2", |
| 11 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 11 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 12 | 12 |
StartX,/location/sublocationxposition, |
| 13 | 13 |
StartY,/location/sublocationyposition, |
| inputs/CTFS/PlotObservation/map.full.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],Veg+,Comments |
| 2 | 2 |
CensusID,CensusID |
| 3 |
EndDate,EndDate |
|
| 4 | 3 |
PlotCensusNumber,PlotCensusNumber |
| 5 |
PlotID,PlotID |
|
| 6 |
StartDate,StartDate |
|
| 4 |
endDate,endDate |
|
| 5 |
plotID,plotID |
|
| 6 |
startDate,startDate |
|
| inputs/CTFS/PlotObservation/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],VegBIEN:,Comments |
| 2 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 2 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 3 | 3 |
PlotCensusNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else", |
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 4 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 6 | 6 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 7 | 7 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
| 9 | 9 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
| 10 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 10 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 11 | 11 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
| 12 | 12 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 13 |
EndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
|
| 14 |
StartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
|
| 13 |
endDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
|
| 14 |
startDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
|
| inputs/CTFS/TaxonOccurrence/map.full.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],Veg+,Comments |
| 2 | 2 |
CensusID,CensusID |
| 3 |
Family,Family |
|
| 4 |
Genus,Genus |
|
| 5 |
PlotID,PlotID |
|
| 6 |
SpeciesInvID,SpeciesInvID |
|
| 7 |
SpeciesName,SpeciesName |
|
| 8 |
SubSpeciesName,SubSpeciesName |
|
| 3 |
family,family |
|
| 4 |
genus,genus |
|
| 5 |
plotID,plotID |
|
| 6 |
speciesInvID,speciesInvID |
|
| 7 |
speciesName,speciesName |
|
| 8 |
subSpeciesName,subSpeciesName |
|
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],VegBIEN:,Comments |
| 2 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 3 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 2 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 3 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 4 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 5 | 5 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 6 | 6 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
| 7 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 7 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 9 |
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
|
| 10 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 11 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 12 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 13 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| 9 |
speciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
|
| 10 |
subSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 11 |
speciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 12 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 13 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| inputs/CTFS/SubplotObservation/map.full.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],Veg+,Comments |
| 2 | 2 |
CensusID,CensusID |
| 3 |
PlotID,PlotID |
|
| 4 | 3 |
QuadratID,QuadratID |
| 4 |
plotID,plotID |
|
| inputs/CTFS/SubplotObservation/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],VegBIEN:,Comments |
| 2 | 2 |
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 3 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 3 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 4 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 6 | 6 |
QuadratID,/location/authorlocationcode/_first/1, |
| 7 | 7 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 9 | 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
| 10 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 10 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 11 | 11 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| inputs/CTFS/Plot/map.full.csv | ||
|---|---|---|
| 2 | 2 |
CountryName,CountryName |
| 3 | 3 |
DescriptionOfSite,DescriptionOfSite |
| 4 | 4 |
Elevation,Elevation |
| 5 |
Latitude,Latitude |
|
| 6 | 5 |
LocationName,LocationName |
| 7 |
Longitude,Longitude |
|
| 8 |
PlotID,PlotID |
|
| 9 |
PlotName,PlotName |
|
| 10 | 6 |
ShapeOfSite,ShapeOfSite |
| 11 | 7 |
SizeOfSite,SizeOfSite |
| 8 |
latitude,latitude |
|
| 9 |
longitude,longitude |
|
| 10 |
plotID,plotID |
|
| 11 |
plotName,plotName |
|
| inputs/CTFS/Plot/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CTFS[Veg+],VegBIEN:,Comments |
| 2 |
PlotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
|
|
| 3 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
|
|
| 6 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 2 |
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
|
|
| 3 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 4 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
|
|
| 5 |
plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
|
|
| 6 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
|
| 7 | 7 |
SizeOfSite,/location/area, |
| 8 | 8 |
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
| 9 | 9 |
ShapeOfSite,/location/locationdetermination/footprintgeometry_dwc, |
| 10 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 10 |
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 12 | 12 |
CountryName,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| 13 |
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
|
|
| 14 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 13 |
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
|
|
| 14 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
|
|
| 15 | 15 |
DescriptionOfSite,/location/locationnarrative/_merge/1, |
| 16 | 16 |
LocationName,/location/locationnarrative/_merge/1, |
| inputs/FIA/Organism/map.full.csv | ||
|---|---|---|
| 1 | 1 |
FIA[Veg+],Veg+,Comments |
| 2 |
BasalDiameter,BasalDiameter |
|
| 3 |
County,County |
|
| 4 | 2 |
DBH,DBH |
| 5 |
DecimalLatitude,DecimalLatitude |
|
| 6 |
DecimalLongitude,DecimalLongitude |
|
| 7 |
Genus,Genus |
|
| 8 |
Height,Height |
|
| 9 |
SpecificEpithet,SpecificEpithet |
|
| 10 |
StateProvince,StateProvince |
|
| 3 |
basalDiameter,basalDiameter |
|
| 4 |
county,county |
|
| 11 | 5 |
MeasDay,dayCollected, |
| 6 |
decimalLatitude,decimalLatitude |
|
| 7 |
decimalLongitude,decimalLongitude |
|
| 8 |
genus,genus |
|
| 9 |
height,height |
|
| 12 | 10 |
MeasMon,monthCollected, |
| 13 | 11 |
PlotCD,plotID, |
| 12 |
specificEpithet,specificEpithet |
|
| 13 |
stateProvince,stateProvince |
|
| 14 | 14 |
TreeTag,tag, |
| 15 | 15 |
MeasYear,yearCollected, |
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
</parent_id> |
| 10 | 10 |
<authorlocationcode>$Line</authorlocationcode> |
| 11 | 11 |
<locationevent> |
| 12 |
<obsenddate> |
|
| 13 |
<_date> |
|
| 14 |
<date> |
|
| 15 |
<_dateRangeEnd> |
|
| 16 |
<value> |
|
| 17 |
<_alt> |
|
| 18 |
<0>$census_date</0> |
|
| 19 |
<1>$census_date</1> |
|
| 20 |
</_alt> |
|
| 21 |
</value> |
|
| 22 |
</_dateRangeEnd> |
|
| 23 |
</date> |
|
| 24 |
</_date> |
|
| 25 |
</obsenddate> |
|
| 26 |
<obsstartdate> |
|
| 27 |
<_date> |
|
| 28 |
<date> |
|
| 29 |
<_dateRangeStart> |
|
| 30 |
<value> |
|
| 31 |
<_alt> |
|
| 32 |
<0>$census_date</0> |
|
| 33 |
<1>$census_date</1> |
|
| 34 |
</_alt> |
|
| 35 |
</value> |
|
| 36 |
</_dateRangeStart> |
|
| 37 |
</date> |
|
| 38 |
</_date> |
|
| 39 |
</obsstartdate> |
|
| 12 |
<obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate> |
|
| 13 |
<obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate> |
|
| 40 | 14 |
<taxonoccurrence> |
| 41 | 15 |
<aggregateoccurrence> |
| 42 | 16 |
<count>$NoInd</count> |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 4 | 4 |
Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
| 5 | 5 |
Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
| 6 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 6 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 7 | 7 |
Colldd,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
| 8 | 8 |
Collmm,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
| 9 | 9 |
Collyy,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 13 | 13 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
| 14 | 14 |
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
| 15 | 15 |
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
| 16 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
|
|
| 16 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
|
|
| 17 | 17 |
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2, |
| 18 | 18 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 19 | 19 |
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| ... | ... | |
| 21 | 21 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 22 | 22 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 23 | 23 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 25 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 24 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 25 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 26 | 26 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
| 27 | 27 |
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 28 | 28 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/1, |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
ARIZ[Veg+],VegBIEN:,Comments |
| 2 |
GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
|
|
| 3 |
InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
|
|
| 4 |
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
|
|
| 2 |
globalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
|
|
| 3 |
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
|
|
| 4 |
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
|
|
| 5 | 5 |
CatalogNumberNumeric,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else/_alt/1", |
| 6 | 6 |
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric |
| 7 |
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 8 |
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 9 |
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 10 |
MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 11 |
MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 12 |
MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
|
|
| 13 |
CoordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
|
|
| 14 |
BoundingBox,/location/locationdetermination/footprintgeometry_dwc,
|
|
| 15 |
DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 16 |
VerbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 17 |
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 18 |
VerbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 19 |
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 20 |
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 21 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 22 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
|
|
| 7 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 8 |
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 9 |
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 10 |
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
| 11 |
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
| 12 |
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
|
|
| 13 |
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
|
|
| 14 |
boundingBox,/location/locationdetermination/footprintgeometry_dwc,
|
|
| 15 |
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 16 |
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 17 |
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 18 |
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 19 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 20 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 21 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 22 |
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
|
|
| 23 | 23 |
VerbatimCollectingDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/0, |
| 24 |
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
monthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 27 | 27 |
VerbatimCollectingDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/0, |
| 28 |
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 29 |
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 30 |
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 28 |
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 29 |
monthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 30 |
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 31 | 31 |
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/0, |
| 32 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 33 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 34 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 35 |
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
|
|
| 36 |
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
|
|
| 37 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
|
|
| 32 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 33 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 34 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 35 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
|
|
| 36 |
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
|
|
| 37 |
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
|
|
| 38 | 38 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,Usage inconsistent with DwC definition |
| 39 |
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
|
|
| 39 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
|
|
| 40 | 40 |
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/1", |
| 41 | 41 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric |
| 42 |
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
|
|
| 43 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
|
|
| 44 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
|
|
| 45 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
|
|
| 42 |
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
|
|
| 43 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
|
|
| 44 |
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
|
|
| 45 |
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
|
|
| 46 | 46 |
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition |
| 47 | 47 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2/_alt/1,Contains the binomial in addition to the authority |
| 48 | 48 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2/_alt/2, |
| 49 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
|
|
| 50 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
|
|
| 51 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
|
|
| 49 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
|
|
| 50 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
|
|
| 51 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
|
|
| 52 | 52 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/1",Contains the binomial in addition to the authority |
| 53 | 53 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/2", |
| 54 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 55 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 56 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 57 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 58 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 59 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 60 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 61 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 62 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 63 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 64 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 65 |
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
|
|
| 54 |
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 55 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 56 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 57 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 58 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 59 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 60 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 61 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 62 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
|
|
| 63 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
|
|
| 64 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
|
|
| 65 |
remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
|
|
| 66 | 66 |
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 67 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
|
|
| 67 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
|
|
| 68 | 68 |
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1", |
| 69 | 69 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric |
| 70 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 71 |
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 72 |
Locality,/location/locationnarrative/_merge/1,
|
|
| 70 |
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 71 |
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
| 72 |
locality,/location/locationnarrative/_merge/1,
|
|
| 73 | 73 |
AgeClass,,** No join mapping for lifeStage ** |
| 74 | 74 |
GenBankNum,,"** No join mapping for associatedSequences/_label[label=""GenBank""]/value ** " |
| 75 | 75 |
GeorefMethod,,** No join mapping for georeferenceProtocol ** |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
MinimumElevationInMeter,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 8 | 8 |
MaximumElevationInMeter,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 9 | 9 |
MinimumElevationInMeter,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 10 |
DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
VerbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
VerbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 15 |
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 16 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 10 |
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 15 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 16 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 17 | 17 |
LatestDateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/2, |
| 18 | 18 |
LatestDateCollected,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/2, |
| 19 | 19 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2, |
| 20 | 20 |
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 21 | 21 |
CollectionCD,/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 |
| 22 | 22 |
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 23 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
|
|
| 24 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
|
|
| 25 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
|
|
| 26 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
|
|
| 27 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 23 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
|
|
| 24 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
|
|
| 25 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
|
|
| 26 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
|
|
| 27 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 28 | 28 |
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2", |
| 29 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 30 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 31 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 32 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 33 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
|
|
| 29 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 30 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 31 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 32 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 33 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
|
|
| 34 | 34 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 35 |
Locality,/location/locationnarrative/_merge/1,
|
|
| 35 |
locality,/location/locationnarrative/_merge/1,
|
|
| 36 | 36 |
GBIFFamilyOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations |
| 37 | 37 |
GBIFGenusOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations |
| 38 | 38 |
LastDateModified,,** No join mapping for DateLastModified ** |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
| 7 | 7 |
Lat (-=S),"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
| 8 | 8 |
Long (-=W),"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
| 9 |
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 10 |
State,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 11 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 9 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
|
|
| 10 |
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
|
|
| 11 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
|
|
| 12 | 12 |
Collect Date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/3, |
| 13 | 13 |
Collect Date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/3, |
| 14 | 14 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/3, |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 11 | 11 |
<0>$dwc_dwcore_InstitutionCode</0> |
| 12 | 12 |
<1>$dwc_terms_institutionCode</1> |
| 13 | 13 |
<2>$conceptual_darwin_2003_1_0_InstitutionCode</2> |
| 14 |
<3>$dwc_dwcore_InstitutionCode</3> |
|
| 15 |
<4>$dwc_terms_institutionCode</4> |
|
| 16 |
<5>$conceptual_darwin_2003_1_0_InstitutionCode</5> |
|
| 17 | 14 |
</_alt> |
| 18 | 15 |
</1> |
| 19 | 16 |
<2> |
| ... | ... | |
| 23 | 20 |
<0>$dwc_dwcore_CollectionCode</0> |
| 24 | 21 |
<1>$dwc_terms_collectionCode</1> |
| 25 | 22 |
<2>$conceptual_darwin_2003_1_0_CollectionCode</2> |
| 26 |
<3>$dwc_dwcore_CollectionCode</3> |
|
| 27 |
<4>$dwc_terms_collectionCode</4> |
|
| 28 |
<5>$conceptual_darwin_2003_1_0_CollectionCode</5> |
|
| 29 | 23 |
</_alt> |
| 30 | 24 |
</1> |
| 31 | 25 |
<2>$dwc_terms_collectionID</2> |
| ... | ... | |
| 36 | 30 |
<0>$dwc_dwcore_CatalogNumber</0> |
| 37 | 31 |
<1>$dwc_terms_catalogNumber</1> |
| 38 | 32 |
<2>$conceptual_darwin_2003_1_0_CatalogNumber</2> |
| 39 |
<3>$dwc_dwcore_CatalogNumber</3> |
|
| 40 |
<4>$dwc_terms_catalogNumber</4> |
|
| 41 |
<5>$conceptual_darwin_2003_1_0_CatalogNumber</5> |
|
| 42 | 33 |
</_alt> |
| 43 | 34 |
</3> |
| 44 | 35 |
</_join> |
| ... | ... | |
| 60 | 51 |
<0>$conceptual_darwin_2003_1_0_MaximumElevation</0> |
| 61 | 52 |
<1>$dwc_dwcore_MaximumElevationInMeters</1> |
| 62 | 53 |
<2>$dwc_terms_maximumElevationInMeters</2> |
| 63 |
<3>$dwc_dwcore_MaximumElevationInMeters</3> |
|
| 64 |
<4>$dwc_terms_maximumElevationInMeters</4> |
|
| 65 | 54 |
</_alt> |
| 66 | 55 |
</value> |
| 67 | 56 |
</_replace> |
| ... | ... | |
| 83 | 72 |
<0>$conceptual_darwin_2003_1_0_MinimumElevation</0> |
| 84 | 73 |
<1>$dwc_dwcore_MinimumElevationInMeters</1> |
| 85 | 74 |
<2>$dwc_terms_minimumElevationInMeters</2> |
| 86 |
<3>$dwc_dwcore_MinimumElevationInMeters</3> |
|
| 87 |
<4>$dwc_terms_minimumElevationInMeters</4> |
|
| 88 | 75 |
</_alt> |
| 89 | 76 |
</value> |
| 90 | 77 |
</_replace> |
| ... | ... | |
| 112 | 99 |
<0>$conceptual_darwin_2003_1_0_MinimumElevation</0> |
| 113 | 100 |
<1>$dwc_dwcore_MinimumElevationInMeters</1> |
| 114 | 101 |
<2>$dwc_terms_minimumElevationInMeters</2> |
| 115 |
<3>$dwc_dwcore_MinimumElevationInMeters</3> |
|
| 116 |
<4>$dwc_terms_minimumElevationInMeters</4> |
|
| 117 | 102 |
</_alt> |
| 118 | 103 |
</value> |
| 119 | 104 |
</_replace> |
| ... | ... | |
| 137 | 122 |
<0>$conceptual_darwin_2003_1_0_MaximumElevation</0> |
| 138 | 123 |
<1>$dwc_dwcore_MaximumElevationInMeters</1> |
| 139 | 124 |
<2>$dwc_terms_maximumElevationInMeters</2> |
| 140 |
<3>$dwc_dwcore_MaximumElevationInMeters</3> |
|
| 141 |
<4>$dwc_terms_maximumElevationInMeters</4> |
|
| 142 | 125 |
</_alt> |
| 143 | 126 |
</value> |
| 144 | 127 |
</_replace> |
| ... | ... | |
| 153 | 136 |
<0>$conceptual_darwin_2003_1_0_MinimumElevation</0> |
| 154 | 137 |
<1>$dwc_dwcore_MinimumElevationInMeters</1> |
| 155 | 138 |
<2>$dwc_terms_minimumElevationInMeters</2> |
| 156 |
<3>$dwc_dwcore_MinimumElevationInMeters</3> |
|
| 157 |
<4>$dwc_terms_minimumElevationInMeters</4> |
|
| 158 | 139 |
</_alt> |
| 159 | 140 |
</value> |
| 160 | 141 |
</_replace> |
| ... | ... | |
| 189 | 170 |
<_alt> |
| 190 | 171 |
<0>$dwc_geospatial_DecimalLatitude</0> |
| 191 | 172 |
<1>$dwc_terms_decimalLatitude</1> |
| 192 |
<2>$dwc_geospatial_DecimalLatitude</2> |
|
| 193 |
<3>$dwc_terms_decimalLatitude</3> |
|
| 194 | 173 |
</_alt> |
| 195 | 174 |
</value> |
| 196 | 175 |
</_nullIf> |
| ... | ... | |
| 204 | 183 |
<0>$conceptual_darwin_2003_1_0_Latitude</0> |
| 205 | 184 |
<1>$dwc_geospatial_VerbatimLatitude</1> |
| 206 | 185 |
<2>$dwc_terms_verbatimLatitude</2> |
| 207 |
<3>$dwc_geospatial_VerbatimLatitude</3> |
|
| 208 |
<4>$dwc_terms_verbatimLatitude</4> |
|
| 209 | 186 |
</_alt> |
| 210 | 187 |
</value> |
| 211 | 188 |
</_nullIf> |
| ... | ... | |
| 222 | 199 |
<_alt> |
| 223 | 200 |
<0>$dwc_geospatial_DecimalLongitude</0> |
| 224 | 201 |
<1>$dwc_terms_decimalLongitude</1> |
| 225 |
<2>$dwc_geospatial_DecimalLongitude</2> |
|
| 226 |
<3>$dwc_terms_decimalLongitude</3> |
|
| 227 | 202 |
</_alt> |
| 228 | 203 |
</value> |
| 229 | 204 |
</_nullIf> |
| ... | ... | |
| 237 | 212 |
<0>$conceptual_darwin_2003_1_0_Longitude</0> |
| 238 | 213 |
<1>$dwc_geospatial_VerbatimLongitude</1> |
| 239 | 214 |
<2>$dwc_terms_verbatimLongitude</2> |
| 240 |
<3>$dwc_geospatial_VerbatimLongitude</3> |
|
| 241 |
<4>$dwc_terms_verbatimLongitude</4> |
|
| 242 | 215 |
</_alt> |
| 243 | 216 |
</value> |
| 244 | 217 |
</_nullIf> |
| ... | ... | |
| 257 | 230 |
<0>$dwc_dwcore_County</0> |
| 258 | 231 |
<1>$dwc_terms_county</1> |
| 259 | 232 |
<2>$conceptual_darwin_2003_1_0_County</2> |
| 260 |
<3>$dwc_dwcore_County</3> |
|
| 261 |
<4>$dwc_terms_county</4> |
|
| 262 |
<5>$conceptual_darwin_2003_1_0_County</5> |
|
| 263 | 233 |
</_alt> |
| 264 | 234 |
</placename> |
| 265 | 235 |
<parent_id> |
| ... | ... | |
| 270 | 240 |
<0>$dwc_dwcore_StateProvince</0> |
| 271 | 241 |
<1>$dwc_terms_stateProvince</1> |
| 272 | 242 |
<2>$conceptual_darwin_2003_1_0_StateProvince</2> |
| 273 |
<3>$dwc_dwcore_StateProvince</3> |
|
| 274 |
<4>$dwc_terms_stateProvince</4> |
|
| 275 |
<5>$conceptual_darwin_2003_1_0_StateProvince</5> |
|
| 276 | 243 |
</_alt> |
| 277 | 244 |
</placename> |
| 278 | 245 |
<parent_id> |
| ... | ... | |
| 283 | 250 |
<0>$dwc_dwcore_Country</0> |
| 284 | 251 |
<1>$dwc_terms_country</1> |
| 285 | 252 |
<2>$conceptual_darwin_2003_1_0_Country</2> |
| 286 |
<3>$dwc_dwcore_Country</3> |
|
| 287 |
<4>$dwc_terms_country</4> |
|
| 288 |
<5>$conceptual_darwin_2003_1_0_Country</5> |
|
| 289 | 253 |
</_alt> |
| 290 | 254 |
</placename> |
| 291 | 255 |
<parent_id> |
| ... | ... | |
| 296 | 260 |
<0>$dwc_dwcore_Continent</0> |
| 297 | 261 |
<1>$dwc_terms_continent</1> |
| 298 | 262 |
<2>$conceptual_darwin_2003_1_0_ContinentOcean</2> |
| 299 |
<3>$dwc_dwcore_Continent</3> |
|
| 300 |
<4>$dwc_terms_continent</4> |
|
| 301 | 263 |
</_alt> |
| 302 | 264 |
</placename> |
| 303 | 265 |
</namedplace> |
| ... | ... | |
| 414 | 376 |
<0>$dwc_curatorial_IndividualCount</0> |
| 415 | 377 |
<1>$dwc_terms_individualCount</1> |
| 416 | 378 |
<2>$conceptual_darwin_2003_1_0_IndividualCount</2> |
| 417 |
<3>$dwc_curatorial_IndividualCount</3> |
|
| 418 |
<4>$dwc_terms_individualCount</4> |
|
| 419 |
<5>$conceptual_darwin_2003_1_0_IndividualCount</5> |
|
| 420 | 379 |
</_alt> |
| 421 | 380 |
</count> |
| 422 | 381 |
<notes>$conceptual_darwin_2003_1_0_Notes</notes> |
| ... | ... | |
| 438 | 397 |
<3>$dwc_curatorial_FieldNumber</3> |
| 439 | 398 |
<4>$dwc_terms_fieldNumber</4> |
| 440 | 399 |
<5>$conceptual_darwin_2003_1_0_FieldNumber</5> |
| 441 |
<6>$dwc_curatorial_FieldNumber</6> |
|
| 442 |
<7>$dwc_terms_fieldNumber</7> |
|
| 443 |
<8>$conceptual_darwin_2003_1_0_FieldNumber</8> |
|
| 444 |
<9>$dwc_curatorial_FieldNumber</9> |
|
| 445 |
<10>$dwc_terms_fieldNumber</10> |
|
| 446 |
<11>$conceptual_darwin_2003_1_0_FieldNumber</11> |
|
| 447 | 400 |
</_alt> |
| 448 | 401 |
</2> |
Also available in: Unified diff
intersect, union: Made case- and punctuation-insensitive. mappings/Veg+-VegBIEN.csv: Removed no longer needed duplicate entries for each first letter case, which must now be removed for case- and punctuation-insensitive intersect/union to work. Note that the SpeciesLink `svn diff` hides _alt entry 0, which contains one of the removed duplicate columns that appears in the diff.