Revision 4354
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/CTFS/StemObservation/map.csv | ||
|---|---|---|
| 14 | 14 |
y,organismY, |
| 15 | 15 |
SubSpeciesCurrentTaxonFlag,, |
| 16 | 16 |
SubSpeciesObsoleteTaxonFlag,, |
| 17 |
SubSpeciesName,, |
|
| 18 | 17 |
SubSpeciesMnemonic,, |
| 19 | 18 |
SubSpeciesAuthority,, |
| 20 | 19 |
InfraSpecificLevel,, |
| 21 | 20 |
SpeciesCurrentTaxonFlag,, |
| 22 | 21 |
SpeciesObsoleteTaxonFlag,, |
| 23 | 22 |
SpeciesReferenceID,, |
| 24 |
SpeciesName,, |
|
| 25 | 23 |
SpeciesMnemonic,, |
| 26 | 24 |
SpeciesAuthority,scientificNameAuthorship, |
| 27 | 25 |
IDLevel,, |
| inputs/CTFS/StemObservation/map.full.csv | ||
|---|---|---|
| 5 | 5 |
Genus,Genus |
| 6 | 6 |
PlotID,PlotID |
| 7 | 7 |
QuadratID,QuadratID |
| 8 |
SpeciesName,SpeciesName |
|
| 8 | 9 |
StemTag,StemTag |
| 10 |
SubSpeciesName,SubSpeciesName |
|
| 9 | 11 |
Tag,Tag |
| 10 | 12 |
MeasureID,individualID, |
| 11 | 13 |
x,organismX, |
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition, |
| 15 | 15 |
MeasureID,/location/locationevent/taxonoccurrence/sourceaccessioncode, |
| 16 | 16 |
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", |
| 17 |
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", |
|
| 18 |
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", |
|
| 17 | 19 |
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", |
| 18 | 20 |
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", |
| 19 | 21 |
QuadratID,/location/sourceaccessioncode, |
| inputs/CTFS/StemObservation/test.xml.ref | ||
|---|---|---|
| 41 | 41 |
<parent_id> |
| 42 | 42 |
<plantname> |
| 43 | 43 |
<rank>subspecies</rank> |
| 44 |
<plantname>$SubSpeciesName</plantname> |
|
| 44 | 45 |
<parent_id> |
| 45 | 46 |
<plantname> |
| 46 | 47 |
<rank>species</rank> |
| 48 |
<plantname>$SpeciesName</plantname> |
|
| 47 | 49 |
<parent_id> |
| 48 | 50 |
<plantname> |
| 49 | 51 |
<rank>genus</rank> |
| ... | ... | |
| 74 | 76 |
<sourceaccessioncode>$QuadratID</sourceaccessioncode> |
| 75 | 77 |
</location> |
| 76 | 78 |
</VegBIEN> |
| 77 |
Inserted 14 new rows into database |
|
| 79 |
Inserted 16 new rows into database |
|
| mappings/Veg+-VegBIEN.csv | ||
|---|---|---|
| 343 | 343 |
TaxonRank,"/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/first", |
| 344 | 344 |
taxonRank,"/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/first", |
| 345 | 345 |
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", |
| 346 |
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", |
|
| 346 | 347 |
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", |
| 347 | 348 |
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", |
| 349 |
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", |
|
| 348 | 350 |
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", |
| 349 | 351 |
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", |
| 352 |
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", |
|
| 350 | 353 |
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", |
| 351 | 354 |
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", |
| 355 |
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", |
|
| 352 | 356 |
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", |
| 353 | 357 |
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", |
| 354 | 358 |
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", |
| mappings/Veg+.cs-VegBIEN.csv | ||
|---|---|---|
| 179 | 179 |
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", |
| 180 | 180 |
taxonRank,"/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/first", |
| 181 | 181 |
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", |
| 182 |
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", |
|
| 182 | 183 |
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", |
| 183 | 184 |
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", |
| 185 |
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", |
|
| 184 | 186 |
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", |
| 185 | 187 |
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", |
| 186 | 188 |
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", |
| mappings/for_review/Veg+-VegCore.csv | ||
|---|---|---|
| 35 | 35 |
boundingBox,footprintWKT, |
| 36 | 36 |
verbatimGrowthForm,growthForm,"According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>" |
| 37 | 37 |
taxonFit,identificationQualifier, |
| 38 |
subSpeciesName,infraspecificEpithet, |
|
| 38 | 39 |
subspecies,infraspecificEpithet, |
| 39 | 40 |
LocationName,locality, |
| 40 | 41 |
locationNarrative,locality, |
| ... | ... | |
| 65 | 66 |
scientificNameAuthorship,scientificNameAuthorship, |
| 66 | 67 |
scientificNameAuthor,scientificNameAuthorship, |
| 67 | 68 |
species,specificEpithet, |
| 69 |
speciesName,specificEpithet, |
|
| 68 | 70 |
plotEventStartDate,startDate, |
| 69 | 71 |
state,stateProvince, |
| 70 | 72 |
QuadratName,subplot, |
| mappings/Veg+-VegCore.to_self.csv | ||
|---|---|---|
| 36 | 36 |
habit,"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>"
|
| 37 | 37 |
verbatimGrowthForm,"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>"
|
| 38 | 38 |
taxonFit,identificationQualifier, |
| 39 |
subSpeciesName,infraspecificEpithet, |
|
| 39 | 40 |
subspecies,infraspecificEpithet, |
| 40 | 41 |
DescriptionOfSite,locality, |
| 41 | 42 |
LocationName,locality, |
| ... | ... | |
| 66 | 67 |
scientificNameAuthorship,scientificNameAuthorship/_alt/1, |
| 67 | 68 |
scientificNameAuthor,scientificNameAuthorship/_alt/2, |
| 68 | 69 |
species,specificEpithet, |
| 70 |
speciesName,specificEpithet, |
|
| 69 | 71 |
plotEventStartDate,startDate, |
| 70 | 72 |
state,stateProvince, |
| 71 | 73 |
QuadratName,subplot, |
| mappings/Veg+.self.csv | ||
|---|---|---|
| 136 | 136 |
SlopeGradient,SlopeGradient |
| 137 | 137 |
Sodium,Sodium |
| 138 | 138 |
Species,Species |
| 139 |
SpeciesName,SpeciesName |
|
| 139 | 140 |
SpecificEpithet,SpecificEpithet |
| 140 | 141 |
StartDate,StartDate |
| 141 | 142 |
StartX,StartX |
| ... | ... | |
| 145 | 146 |
StemCount,StemCount |
| 146 | 147 |
StemNotes,StemNotes |
| 147 | 148 |
StemTag,StemTag |
| 149 |
SubSpeciesName,SubSpeciesName |
|
| 148 | 150 |
Subplot,Subplot |
| 149 | 151 |
SubplotID,SubplotID |
| 150 | 152 |
SubplotX,SubplotX |
| ... | ... | |
| 302 | 304 |
slopeGradient,slopeGradient |
| 303 | 305 |
sodium,sodium |
| 304 | 306 |
species,species |
| 307 |
speciesName,speciesName |
|
| 305 | 308 |
specificEpithet,specificEpithet |
| 306 | 309 |
startDate,startDate |
| 307 | 310 |
state,state |
| ... | ... | |
| 309 | 312 |
stemCount,stemCount |
| 310 | 313 |
stemNotes,stemNotes |
| 311 | 314 |
stemTag,stemTag |
| 315 |
subSpeciesName,subSpeciesName |
|
| 312 | 316 |
subplot,subplot |
| 313 | 317 |
subplotID,subplotID |
| 314 | 318 |
subplotX,subplotX |
| mappings/Veg+-VegCore.csv | ||
|---|---|---|
| 35 | 35 |
boundingBox,footprintWKT, |
| 36 | 36 |
verbatimGrowthForm,"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>"
|
| 37 | 37 |
taxonFit,identificationQualifier, |
| 38 |
subSpeciesName,infraspecificEpithet, |
|
| 38 | 39 |
subspecies,infraspecificEpithet, |
| 39 | 40 |
LocationName,locality, |
| 40 | 41 |
locationNarrative,locality, |
| ... | ... | |
| 65 | 66 |
scientificNameAuthorship,scientificNameAuthorship/_alt/1, |
| 66 | 67 |
scientificNameAuthor,scientificNameAuthorship/_alt/2, |
| 67 | 68 |
species,specificEpithet, |
| 69 |
speciesName,specificEpithet, |
|
| 68 | 70 |
plotEventStartDate,startDate, |
| 69 | 71 |
state,stateProvince, |
| 70 | 72 |
QuadratName,subplot, |
Also available in: Unified diff
mappings/Veg+-VegCore.csv: Mapped speciesName, subSpeciesName