Revision 72
Added by Aaron Marcuse-Kubitza about 13 years ago
scripts/map | ||
---|---|---|
43 | 43 |
map_reader = csv.reader(map_stream) |
44 | 44 |
src, dest = map_reader.next()[:2] |
45 | 45 |
def split_col_name(name): |
46 |
name, sep, root = name.partition('/')
|
|
47 |
return name, sep != '', sep+root
|
|
46 |
name, sep, root = name.partition(':')
|
|
47 |
return name, sep != '', root |
|
48 | 48 |
src, in_is_xml, src_root = split_col_name(src) |
49 | 49 |
dest, out_is_xml, dest_root = split_col_name(dest) |
50 | 50 |
assert out_is_xml |
scripts/util/ch_map_root | ||
---|---|---|
3 | 3 |
|
4 | 4 |
import csv |
5 | 5 |
import os.path |
6 |
import re |
|
6 | 7 |
import sys |
7 | 8 |
|
8 | 9 |
sys.path.append(os.path.dirname(__file__)+"/../lib") |
... | ... | |
27 | 28 |
cols = reader.next() |
28 | 29 |
for i in xrange(len(configs)): |
29 | 30 |
config = configs[i] |
30 |
config['root'] = cols[i] |
|
31 |
label = cols[i].partition('/')[0] |
|
32 |
config['prefix'] = label+config['in_root'] |
|
33 |
config['prefix_len'] = len(config['prefix']) |
|
34 |
cols[i] = label+config['out_root'] |
|
31 |
label, sep, config['root'] = cols[i].partition(':') |
|
32 |
cols[i] = label+sep+config['out_root'] |
|
33 |
config['in_root_re'] = r'^'+re.escape(config['in_root'])+r'\b' |
|
35 | 34 |
writer.writerow(cols) |
36 | 35 |
for row in reader: |
37 | 36 |
for i in xrange(len(configs)): row[i] = configs[i]['root']+row[i] |
38 |
if row[0].startswith(configs[0]['prefix']): |
|
39 |
if not row[1].startswith(configs[1]['prefix']): |
|
40 |
raise SystemExit('Map error: Root "'+configs[1]['prefix'] |
|
41 |
+'" is not contained in output mapping: '+row[1]) |
|
42 |
for i in xrange(len(configs)): |
|
43 |
row[i] = row[i][configs[i]['prefix_len']:] |
|
37 |
def sub(i): |
|
38 |
row[i], n = re.subn(configs[i]['in_root_re'], r'', row[i]) |
|
39 |
return n > 0 |
|
40 |
if sub(0): |
|
41 |
if not sub(1): raise SystemExit('Map error: Root "' |
|
42 |
+configs[1]['in_root']+'" is not contained in output mapping: ' |
|
43 |
+row[1]) |
|
44 | 44 |
writer.writerow(row) |
45 | 45 |
|
46 | 46 |
main() |
mappings/VegX-VegBank.organisms.csv | ||
---|---|---|
1 |
"VegX/*s/individualOrganismObservation/","VegBank/taxonObservation/" |
|
2 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet" |
|
3 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank" |
|
4 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName" |
|
5 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName" |
|
6 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}" |
|
7 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName" |
|
8 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue" |
|
9 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue" |
|
10 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName" |
|
11 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName" |
|
12 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName" |
|
13 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName" |
|
14 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName" |
|
15 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName" |
|
16 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName" |
|
17 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName" |
|
18 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}" |
|
19 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName" |
|
20 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName" |
|
21 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName" |
|
22 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day" |
|
23 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month" |
|
24 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year" |
|
25 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}" |
|
26 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}" |
|
27 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber" |
|
28 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes" |
|
29 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName" |
|
30 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName" |
|
31 |
"*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber" |
|
32 |
"*ID->/*s/individualOrganism/identificationLabel","taxonImportance/stemCount/stemLocation/stemCode" |
|
33 |
"*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue" |
|
34 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue" |
|
35 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue" |
|
36 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","*_ID/observation/soilObs/soilPH" |
|
37 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue" |
|
38 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue" |
|
39 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue" |
|
40 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue" |
|
41 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue" |
|
42 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue" |
|
43 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue" |
|
44 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","*_ID/observation/soilObs/soilClay" |
|
45 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue" |
|
46 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","*_ID/observation/soilObs/soilOrganic" |
|
47 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","*_ID/observation/soilObs/soilSand" |
|
48 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","*_ID/observation/soilObs/soilSilt" |
|
49 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue" |
|
50 |
"*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","*_ID/observation/soilObs/soilTexture" |
|
51 |
"*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value","taxonImportance/*/stemCount" |
|
52 |
"*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName" |
|
53 |
"*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription" |
|
54 |
"*ID->/*s/plotObservation/*ID->/*s/project/title","*_ID/observation/*_ID/project/projectName" |
|
55 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","*_ID/observation/*_ID/plot/area" |
|
56 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName" |
|
57 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName" |
|
58 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName" |
|
59 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","*_ID/observation/*_ID/plot/locationAccuracy" |
|
60 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","*_ID/observation/*_ID/plot/realLatitude" |
|
61 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","*_ID/observation/*_ID/plot/realLongitude" |
|
62 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","*_ID/observation/*_ID/plot/dsgpoly" |
|
63 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","*_ID/observation/waterDepth/max" |
|
64 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}" |
|
65 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","*_ID/observation/waterDepth/min" |
|
66 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}" |
|
67 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","*_ID/observation/*_ID/plot/elevation" |
|
68 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","*_ID/observation/*_ID/plot/authorPlotCode" |
|
69 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}" |
|
70 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode" |
|
71 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription" |
|
72 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription" |
|
73 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName" |
|
74 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","*_ID/observation/*_ID/plot/slopeAspect" |
|
75 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","*_ID/observation/*_ID/plot/slopeGradient" |
|
76 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName" |
|
77 |
"*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName" |
|
78 |
"*ID->/*s/plotObservation/obsEndDate","*_ID/observation/obsEndDate" |
|
79 |
"*ID->/*s/plotObservation/obsStartDate","*_ID/observation/obsStartDate" |
|
80 |
"*ID->/*s/plotObservation/obsStartDate/_date/day","*_ID/observation/obsStartDate/_date/day" |
|
81 |
"*ID->/*s/plotObservation/obsStartDate/_date/month","*_ID/observation/obsStartDate/_date/month" |
|
82 |
"*ID->/*s/plotObservation/obsStartDate/_date/year","*_ID/observation/obsStartDate/_date/year" |
|
83 |
"*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","*_ID/observation/methodNarrative" |
|
84 |
"*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue" |
|
85 |
"*ID->/*s/plotObservation/temperature","*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue" |
|
86 |
"diameterBaseDistance[baseDistance=0]/diameter","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue" |
|
87 |
"diameterBaseDistance[baseDistance=1.37]/diameter","taxonImportance/stemCount/stemDiameter" |
|
88 |
"height","taxonImportance/stemCount/stemHeight" |
|
89 |
"simpleUserdefined[name=censusNo]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue" |
|
90 |
"simpleUserdefined[name=coverPercent]/value","taxonImportance/cover" |
|
91 |
"simpleUserdefined[name=habit]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue" |
|
92 |
"simpleUserdefined[name=habitat]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue" |
|
93 |
"simpleUserdefined[name=htFirstBranchM]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue" |
|
94 |
"simpleUserdefined[name=individualCode]/value","taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue" |
|
95 |
"simpleUserdefined[name=interceptCm]/value","taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue" |
|
96 |
"simpleUserdefined[name=plantFungusDescription]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue" |
|
97 |
"simpleUserdefined[name=stemCanopyForm]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue" |
|
98 |
"simpleUserdefined[name=stemCanopyPosition]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue" |
|
99 |
"simpleUserdefined[name=stemHeightFirstBranchM]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue" |
|
100 |
"simpleUserdefined[name=stemHeightM]/value","taxonImportance/stemCount/stemHeight" |
|
101 |
"simpleUserdefined[name=stemLianaInfestation]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue" |
|
102 |
"simpleUserdefined[name=substrate]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue" |
|
103 |
"simpleUserdefined[name=vegetation]/value","taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue" |
|
104 |
"simpleUserdefined[name=xPosition]/value","taxonImportance/stemCount/stemLocation/stemXPosition" |
|
105 |
"simpleUserdefined[name=yPosition]/value","taxonImportance/stemCount/stemLocation/stemYPosition" |
|
1 |
"VegX:/*s/individualOrganismObservation","VegBank:/taxonObservation" |
|
2 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet" |
|
3 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue" |
|
4 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName" |
|
5 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName" |
|
6 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName" |
|
7 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName" |
|
8 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}" |
|
9 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName" |
|
10 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank" |
|
11 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue" |
|
12 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName" |
|
13 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName" |
|
14 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName" |
|
15 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName" |
|
16 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName" |
|
17 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName" |
|
18 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}" |
|
19 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName" |
|
20 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName" |
|
21 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName" |
|
22 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day" |
|
23 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month" |
|
24 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year" |
|
25 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}" |
|
26 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}" |
|
27 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber" |
|
28 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes" |
|
29 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName" |
|
30 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName" |
|
31 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber" |
|
32 |
"/*ID->/*s/individualOrganism/identificationLabel","/taxonImportance/stemCount/stemLocation/stemCode" |
|
33 |
"/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue" |
|
34 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue" |
|
35 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue" |
|
36 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/*_ID/observation/soilObs/soilPH" |
|
37 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue" |
|
38 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue" |
|
39 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue" |
|
40 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue" |
|
41 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue" |
|
42 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue" |
|
43 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue" |
|
44 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/*_ID/observation/soilObs/soilClay" |
|
45 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue" |
|
46 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/*_ID/observation/soilObs/soilOrganic" |
|
47 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/*_ID/observation/soilObs/soilSand" |
|
48 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/*_ID/observation/soilObs/soilSilt" |
|
49 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/*_ID/observation/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue" |
|
50 |
"/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/*_ID/observation/soilObs/soilTexture" |
|
51 |
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","/*_ID/observation/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName" |
|
52 |
"/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/commDescription" |
|
53 |
"/*ID->/*s/plotObservation/*ID->/*s/project/title","/*_ID/observation/*_ID/project/projectName" |
|
54 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","/*_ID/observation/*_ID/plot/area" |
|
55 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName" |
|
56 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName" |
|
57 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName" |
|
58 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","/*_ID/observation/*_ID/plot/locationAccuracy" |
|
59 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","/*_ID/observation/*_ID/plot/realLatitude" |
|
60 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","/*_ID/observation/*_ID/plot/realLongitude" |
|
61 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","/*_ID/observation/*_ID/plot/dsgpoly" |
|
62 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","/*_ID/observation/waterDepth/max" |
|
63 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}" |
|
64 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","/*_ID/observation/waterDepth/min" |
|
65 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","/*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}" |
|
66 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","/*_ID/observation/*_ID/plot/elevation" |
|
67 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/authorPlotCode" |
|
68 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}" |
|
69 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","/*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode" |
|
70 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription" |
|
71 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription" |
|
72 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName" |
|
73 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","/*_ID/observation/*_ID/plot/slopeAspect" |
|
74 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","/*_ID/observation/*_ID/plot/slopeGradient" |
|
75 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName" |
|
76 |
"/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName" |
|
77 |
"/*ID->/*s/plotObservation/obsEndDate","/*_ID/observation/obsEndDate" |
|
78 |
"/*ID->/*s/plotObservation/obsStartDate","/*_ID/observation/obsStartDate" |
|
79 |
"/*ID->/*s/plotObservation/obsStartDate/_date/day","/*_ID/observation/obsStartDate/_date/day" |
|
80 |
"/*ID->/*s/plotObservation/obsStartDate/_date/month","/*_ID/observation/obsStartDate/_date/month" |
|
81 |
"/*ID->/*s/plotObservation/obsStartDate/_date/year","/*_ID/observation/obsStartDate/_date/year" |
|
82 |
"/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","/*_ID/observation/methodNarrative" |
|
83 |
"/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue" |
|
84 |
"/*ID->/*s/plotObservation/temperature","/*_ID/observation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue" |
|
85 |
"/diameterBaseDistance[baseDistance=0]/diameter","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue" |
|
86 |
"/diameterBaseDistance[baseDistance=1.37]/diameter","/taxonImportance/stemCount/stemDiameter" |
|
87 |
"/height","/taxonImportance/stemCount/stemHeight" |
|
88 |
"/simpleUserdefined[name=censusNo]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue" |
|
89 |
"/simpleUserdefined[name=count]/value","/taxonImportance/*/stemCount" |
|
90 |
"/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover" |
|
91 |
"/simpleUserdefined[name=habit]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue" |
|
92 |
"/simpleUserdefined[name=habitat]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue" |
|
93 |
"/simpleUserdefined[name=htFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue" |
|
94 |
"/simpleUserdefined[name=individualCode]/value","/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue" |
|
95 |
"/simpleUserdefined[name=interceptCm]/value","/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue" |
|
96 |
"/simpleUserdefined[name=plantFungusDescription]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue" |
|
97 |
"/simpleUserdefined[name=stemCanopyForm]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue" |
|
98 |
"/simpleUserdefined[name=stemCanopyPosition]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue" |
|
99 |
"/simpleUserdefined[name=stemHeightFirstBranchM]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue" |
|
100 |
"/simpleUserdefined[name=stemHeightM]/value","/taxonImportance/stemCount/stemHeight" |
|
101 |
"/simpleUserdefined[name=stemLianaInfestation]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue" |
|
102 |
"/simpleUserdefined[name=substrate]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue" |
|
103 |
"/simpleUserdefined[name=vegetation]/value","/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue" |
|
104 |
"/simpleUserdefined[name=xPosition]/value","/taxonImportance/stemCount/stemLocation/stemXPosition" |
|
105 |
"/simpleUserdefined[name=yPosition]/value","/taxonImportance/stemCount/stemLocation/stemYPosition" |
mappings/NYBG-VegX.organisms.csv | ||
---|---|---|
1 |
"NYBG","VegX/*s/individualOrganismObservation/"
|
|
1 |
"NYBG","VegX:/*s/individualOrganismObservation"
|
|
2 | 2 |
"key", |
3 | 3 |
"DateLastModified", |
4 |
"InstitutionCode","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName" |
|
5 |
"CollectionCode","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName" |
|
6 |
"CatalogNumber","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher" |
|
7 |
"ScientificName","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple" |
|
4 |
"InstitutionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"
|
|
5 |
"CollectionCode","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"
|
|
6 |
"CatalogNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
|
|
7 |
"ScientificName","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
|
|
8 | 8 |
"BasisOfRecord", |
9 |
"Kingdom","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name" |
|
10 |
"Phylum","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name" |
|
11 |
"Class","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name" |
|
12 |
"Order","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name" |
|
13 |
"Family","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name" |
|
14 |
"Genus","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name" |
|
15 |
"Species","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name" |
|
16 |
"Subspecies","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name" |
|
17 |
"ScientificNameAuthor","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple" |
|
18 |
"IdentifiedBy","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}" |
|
19 |
"YearIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year" |
|
20 |
"MonthIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month" |
|
21 |
"DayIdentified","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day" |
|
9 |
"Kingdom","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
|
|
10 |
"Phylum","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
|
|
11 |
"Class","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
|
|
12 |
"Order","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
|
|
13 |
"Family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
|
|
14 |
"Genus","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
|
|
15 |
"Species","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
|
|
16 |
"Subspecies","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
|
|
17 |
"ScientificNameAuthor","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
|
|
18 |
"IdentifiedBy","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"
|
|
19 |
"YearIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"
|
|
20 |
"MonthIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"
|
|
21 |
"DayIdentified","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"
|
|
22 | 22 |
"TypeStatus", |
23 | 23 |
"CollectorNumber", |
24 |
"FieldNumber","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode" |
|
25 |
"Collector","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}" |
|
26 |
"YearCollected","*ID->/*s/plotObservation/obsStartDate/_date/year" |
|
27 |
"MonthCollected","*ID->/*s/plotObservation/obsStartDate/_date/month" |
|
28 |
"DayCollected","*ID->/*s/plotObservation/obsStartDate/_date/day" |
|
24 |
"FieldNumber","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
|
|
25 |
"Collector","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"
|
|
26 |
"YearCollected","/*ID->/*s/plotObservation/obsStartDate/_date/year"
|
|
27 |
"MonthCollected","/*ID->/*s/plotObservation/obsStartDate/_date/month"
|
|
28 |
"DayCollected","/*ID->/*s/plotObservation/obsStartDate/_date/day"
|
|
29 | 29 |
"JulianDay", |
30 | 30 |
"TimeOfDay", |
31 | 31 |
"ContinentOcean", |
32 |
"Country","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country" |
|
33 |
"StateProvince","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state" |
|
34 |
"County","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county" |
|
35 |
"Locality","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value" |
|
36 |
"Longitude","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude" |
|
37 |
"Latitude","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude" |
|
38 |
"CoordinatePrecision","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters" |
|
39 |
"BoundingBox","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT" |
|
40 |
"MinimumElevation","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters" |
|
41 |
"MaximumElevation","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters" |
|
42 |
"MinimumDepth","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters" |
|
43 |
"MaximumDepth","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters" |
|
44 |
"Sex","*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value" |
|
32 |
"Country","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"
|
|
33 |
"StateProvince","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"
|
|
34 |
"County","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"
|
|
35 |
"Locality","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value"
|
|
36 |
"Longitude","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
|
|
37 |
"Latitude","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
|
|
38 |
"CoordinatePrecision","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters"
|
|
39 |
"BoundingBox","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT"
|
|
40 |
"MinimumElevation","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
|
|
41 |
"MaximumElevation","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
|
|
42 |
"MinimumDepth","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters"
|
|
43 |
"MaximumDepth","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters"
|
|
44 |
"Sex","/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value"
|
|
45 | 45 |
"PreparationType", |
46 | 46 |
"IndividualCount", |
47 | 47 |
"PreviousCatalogNumber", |
48 | 48 |
"RelationshipType", |
49 | 49 |
"RelatedCatalogItem", |
50 |
"Notes","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text" |
|
51 |
"Habitat","simpleUserdefined[name=habitat]/value" |
|
52 |
"PlantFungusDescription","simpleUserdefined[name=plantFungusDescription]/value" |
|
53 |
"Substrate","simpleUserdefined[name=substrate]/value" |
|
54 |
"Vegetation","simpleUserdefined[name=vegetation]/value" |
|
50 |
"Notes","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
|
|
51 |
"Habitat","/simpleUserdefined[name=habitat]/value"
|
|
52 |
"PlantFungusDescription","/simpleUserdefined[name=plantFungusDescription]/value"
|
|
53 |
"Substrate","/simpleUserdefined[name=substrate]/value"
|
|
54 |
"Vegetation","/simpleUserdefined[name=vegetation]/value"
|
|
55 | 55 |
"UniqueNYInternalRecordNumber", |
mappings/joins/NYBG-VegBank.organisms.csv | ||
---|---|---|
1 |
NYBG,VegBank/taxonObservation/ |
|
2 |
InstitutionCode,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName |
|
3 |
CollectionCode,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName |
|
4 |
CatalogNumber,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber |
|
5 |
ScientificName,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName |
|
6 |
Kingdom,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName |
|
7 |
Phylum,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName |
|
8 |
Class,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName |
|
9 |
Order,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName |
|
10 |
Family,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName |
|
11 |
Genus,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName |
|
12 |
Species,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName |
|
13 |
Subspecies,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName |
|
14 |
ScientificNameAuthor,"taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}" |
|
15 |
IdentifiedBy,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}" |
|
16 |
YearIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year |
|
17 |
MonthIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month |
|
18 |
DayIdentified,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day |
|
19 |
FieldNumber,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber |
|
20 |
Collector,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}" |
|
21 |
YearCollected,*_ID/observation/obsStartDate/_date/year |
|
22 |
MonthCollected,*_ID/observation/obsStartDate/_date/month |
|
23 |
DayCollected,*_ID/observation/obsStartDate/_date/day |
|
24 |
Country,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName |
|
25 |
StateProvince,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName |
|
26 |
County,*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName |
|
27 |
Locality,*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
28 |
Longitude,*_ID/observation/*_ID/plot/realLongitude |
|
29 |
Latitude,*_ID/observation/*_ID/plot/realLatitude |
|
30 |
CoordinatePrecision,*_ID/observation/*_ID/plot/locationAccuracy |
|
31 |
BoundingBox,*_ID/observation/*_ID/plot/dsgpoly |
|
32 |
MinimumElevation,"*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}" |
|
33 |
MaximumElevation,"*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}" |
|
34 |
MinimumDepth,*_ID/observation/waterDepth/min |
|
35 |
MaximumDepth,*_ID/observation/waterDepth/max |
|
36 |
Sex,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue" |
|
37 |
Notes,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes |
|
38 |
Habitat,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue" |
|
39 |
PlantFungusDescription,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue" |
|
40 |
Substrate,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue" |
|
41 |
Vegetation,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue" |
|
1 |
NYBG,VegBank:/taxonObservation |
|
2 |
InstitutionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/firstName |
|
3 |
CollectionCode,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museum_ID/party/OrganizationName/_name/lastName |
|
4 |
CatalogNumber,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber |
|
5 |
ScientificName,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName |
|
6 |
Kingdom,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Kingdom])/*_ID/*/plantName |
|
7 |
Phylum,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subkingdom])/*_ID/*/plantName |
|
8 |
Class,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Class])/*_ID/*/plantName |
|
9 |
Order,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Order])/*_ID/*/plantName |
|
10 |
Family,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName |
|
11 |
Genus,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName |
|
12 |
Species,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName |
|
13 |
Subspecies,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName |
|
14 |
ScientificNameAuthor,"/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/reference/referenceContributor/*_ID/referenceParty/{givenName,surname}" |
|
15 |
IdentifiedBy,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/*_ID/party/{givenName,middleName,surName}" |
|
16 |
YearIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/year |
|
17 |
MonthIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/month |
|
18 |
DayIdentified,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/interpretationDate/_date/day |
|
19 |
FieldNumber,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber |
|
20 |
Collector,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID/party/{givenName,middleName,surName}" |
|
21 |
YearCollected,/*_ID/observation/obsStartDate/_date/year |
|
22 |
MonthCollected,/*_ID/observation/obsStartDate/_date/month |
|
23 |
DayCollected,/*_ID/observation/obsStartDate/_date/day |
|
24 |
Country,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName |
|
25 |
StateProvince,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName |
|
26 |
County,/*_ID/observation/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName |
|
27 |
Locality,/*_ID/observation/*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
28 |
Longitude,/*_ID/observation/*_ID/plot/realLongitude |
|
29 |
Latitude,/*_ID/observation/*_ID/plot/realLatitude |
|
30 |
CoordinatePrecision,/*_ID/observation/*_ID/plot/locationAccuracy |
|
31 |
BoundingBox,/*_ID/observation/*_ID/plot/dsgpoly |
|
32 |
MinimumElevation,"/*_ID/observation/*_ID/plot/{elevation/min,elevationRange/from}" |
|
33 |
MaximumElevation,"/*_ID/observation/*_ID/plot/{elevation/max,elevationRange/to}" |
|
34 |
MinimumDepth,/*_ID/observation/waterDepth/min |
|
35 |
MaximumDepth,/*_ID/observation/waterDepth/max |
|
36 |
Sex,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=sex]]/definedValue" |
|
37 |
Notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes |
|
38 |
Habitat,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=habitat]]/definedValue" |
|
39 |
PlantFungusDescription,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]]/definedValue" |
|
40 |
Substrate,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=substrate]]/definedValue" |
|
41 |
Vegetation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=vegetation]]/definedValue" |
mappings/joins/SALVIAS-VegBank.plots.csv | ||
---|---|---|
1 |
SALVIAS,VegBank/observation/ |
|
2 |
project,*_ID/project/projectName |
|
3 |
plot_code,"{*_ID/plot/authorPlotCode,authorObsCode}" |
|
4 |
major_geo,*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName |
|
5 |
country,*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName |
|
6 |
pol1,*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName |
|
7 |
pol2,*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName |
|
8 |
locality_description,*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
9 |
lat_decimal,*_ID/plot/realLatitude |
|
10 |
long_decimal,*_ID/plot/realLongitude |
|
11 |
elev_m,*_ID/plot/elevation |
|
12 |
elev_max_m,"*_ID/plot/{elevation/max,elevationRange/to}" |
|
13 |
elev_min_m,"*_ID/plot/{elevation/min,elevationRange/from}" |
|
14 |
temp_c,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue" |
|
15 |
precip_mm,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue" |
|
16 |
slope_aspect,*_ID/plot/slopeAspect |
|
17 |
slope_gradient,*_ID/plot/slopeGradient |
|
18 |
plot_methodology,methodNarrative |
|
19 |
plot_area_ha,*_ID/plot/area |
|
20 |
date_start,obsStartDate |
|
21 |
date_finish,obsEndDate |
|
1 |
SALVIAS,VegBank:/observation |
|
2 |
project,/*_ID/project/projectName |
|
3 |
plot_code,"/{*_ID/plot/authorPlotCode,authorObsCode}" |
|
4 |
major_geo,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName |
|
5 |
country,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName |
|
6 |
pol1,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName |
|
7 |
pol2,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName |
|
8 |
locality_description,/*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
9 |
lat_decimal,/*_ID/plot/realLatitude |
|
10 |
long_decimal,/*_ID/plot/realLongitude |
|
11 |
elev_m,/*_ID/plot/elevation |
|
12 |
elev_max_m,"/*_ID/plot/{elevation/max,elevationRange/to}" |
|
13 |
elev_min_m,"/*_ID/plot/{elevation/min,elevationRange/from}" |
|
14 |
temp_c,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue" |
|
15 |
precip_mm,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue" |
|
16 |
slope_aspect,/*_ID/plot/slopeAspect |
|
17 |
slope_gradient,/*_ID/plot/slopeGradient |
|
18 |
clay_percent,/soilObs/soilClay |
|
19 |
silt_percent,/soilObs/soilSilt |
|
20 |
sand_percent,/soilObs/soilSand |
|
21 |
organic_percent,/soilObs/soilOrganic |
|
22 |
pH,/soilObs/soilPH |
|
23 |
soil_N,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue" |
|
24 |
soil_P,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue" |
|
25 |
soil_C,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue" |
|
26 |
soil_K,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue" |
|
27 |
soil_Mg,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue" |
|
28 |
soil_Ca,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue" |
|
29 |
soil_Na,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue" |
|
30 |
soil_acidity,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue" |
|
31 |
soil_base,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue" |
|
32 |
soil_cation_cap,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue" |
|
33 |
soil_conductivity,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue" |
|
34 |
soil_texture,/soilObs/soilTexture |
|
35 |
holdridge_life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription |
|
36 |
life_zone_code,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName |
|
37 |
plot_methodology,/methodNarrative |
|
38 |
plot_area_ha,/*_ID/plot/area |
|
39 |
date_start,/obsStartDate |
|
40 |
date_finish,/obsEndDate |
mappings/joins/SALVIAS-VegBank.organisms.csv | ||
---|---|---|
1 |
SALVIAS,VegBank/taxonObservation/ |
|
2 |
OBSERVATION_ID,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber |
|
3 |
plot_code,*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode |
|
4 |
census_no,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue" |
|
5 |
census_date,*_ID/observation/obsStartDate |
|
6 |
subplot,"*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}" |
|
7 |
individual_code,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue" |
|
8 |
tag1,taxonImportance/stemCount/stemLocation/stemCode |
|
9 |
tag2,taxonImportance/stemCount/stemLocation/stemCode |
|
10 |
x_position,taxonImportance/stemCount/stemLocation/stemXPosition |
|
11 |
y_position,taxonImportance/stemCount/stemLocation/stemYPosition |
|
12 |
voucher_string,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber |
|
13 |
coll_number,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber |
|
14 |
coll_lastname,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName |
|
15 |
coll_firstname,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName |
|
16 |
det_type,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue" |
|
17 |
family,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName |
|
18 |
genus,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName |
|
19 |
specific_epithet,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName |
|
20 |
specific_authority,"taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}" |
|
21 |
infra_rank_1,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank |
|
22 |
infra_ep_1,taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet |
|
23 |
cf_aff,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue" |
|
24 |
habit,"taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue" |
|
25 |
no_of_individuals,taxonImportance/*/stemCount |
|
26 |
cover_percent,taxonImportance/cover |
|
27 |
intercept_cm,"taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue" |
|
28 |
height_m,taxonImportance/stemCount/stemHeight |
|
29 |
ht_first_branch_m,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue" |
|
30 |
stem_tag1,taxonImportance/stemCount/stemLocation/stemCode |
|
31 |
stem_tag2,taxonImportance/stemCount/stemLocation/stemCode |
|
32 |
stem_dbh,taxonImportance/stemCount/stemDiameter |
|
33 |
basal_diam,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue" |
|
34 |
stem_height_m,taxonImportance/stemCount/stemHeight |
|
35 |
stem_height_first_branch_m,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue" |
|
36 |
stem_canopy_form,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue" |
|
37 |
stem_canopy_position,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue" |
|
38 |
stem_liana_infestation,"taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue" |
|
39 |
notes,taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes |
|
1 |
SALVIAS,VegBank:/taxonObservation |
|
2 |
OBSERVATION_ID,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/museumAccessionNumber |
|
3 |
plot_code,/*_ID/observation/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode |
|
4 |
census_no,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]]/definedValue" |
|
5 |
census_date,/*_ID/observation/obsStartDate |
|
6 |
subplot,"/*_ID/observation/{*_ID/plot/authorPlotCode,authorObsCode}" |
|
7 |
individual_code,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]]/definedValue" |
|
8 |
tag1,/taxonImportance/stemCount/stemLocation/stemCode |
|
9 |
tag2,/taxonImportance/stemCount/stemLocation/stemCode |
|
10 |
x_position,/taxonImportance/stemCount/stemLocation/stemXPosition |
|
11 |
y_position,/taxonImportance/stemCount/stemLocation/stemYPosition |
|
12 |
voucher_string,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber |
|
13 |
coll_number,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collectionNumber |
|
14 |
coll_lastname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/surName |
|
15 |
coll_firstname,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/collector_ID->/party/givenName |
|
16 |
det_type,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=determinationType]]/definedValue" |
|
17 |
family,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Family])/*_ID/*/plantName |
|
18 |
genus,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Genus])/*_ID/*/plantName |
|
19 |
specific_epithet,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/*/plantName |
|
20 |
specific_authority,"/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Species])/*_ID/plantName/reference_ID->/referenceParty/{givenName,surname}" |
|
21 |
infra_rank_1,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/rank |
|
22 |
infra_ep_1,/taxonImportance/stemCount/stemLocation/taxonInterpretation(/*_ID/plantConcept[plantStatus/plantLevel=Subspecies])/*_ID/*/plantName/epithet |
|
23 |
cf_aff,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]]/definedValue" |
|
24 |
habit,"/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonInterpretation,userDefinedName=habit]]/definedValue" |
|
25 |
no_of_individuals,/taxonImportance/*/stemCount |
|
26 |
cover_percent,/taxonImportance/cover |
|
27 |
intercept_cm,"/taxonImportance/definedValue[@fkey=tableRecord_ID,userDefined[tableName=taxonImportance,userDefinedName=interceptCm]]/definedValue" |
|
28 |
height_m,/taxonImportance/stemCount/stemHeight |
|
29 |
ht_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=heightFirstBranchM]]/definedValue" |
|
30 |
stem_tag1,/taxonImportance/stemCount/stemLocation/stemCode |
|
31 |
stem_tag2,/taxonImportance/stemCount/stemLocation/stemCode |
|
32 |
stem_dbh,/taxonImportance/stemCount/stemDiameter |
|
33 |
basal_diam,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemBasalDiameter]]/definedValue" |
|
34 |
stem_height_m,/taxonImportance/stemCount/stemHeight |
|
35 |
stem_height_first_branch_m,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]]/definedValue" |
|
36 |
stem_canopy_form,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]]/definedValue" |
|
37 |
stem_canopy_position,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]]/definedValue" |
|
38 |
stem_liana_infestation,"/taxonImportance/stemCount/stemLocation/definedValue[@fkey=tableRecord_ID,userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]]/definedValue" |
|
39 |
notes,/taxonImportance/stemCount/stemLocation/taxonInterpretation[PLANTCONCEPT_ID=]/notes |
mappings/SALVIAS-VegX.plots.csv | ||
---|---|---|
1 |
"SALVIAS","VegX/*s/plotObservation/"
|
|
2 |
"project","*ID->/*s/project/title" |
|
1 |
"SALVIAS","VegX:/*s/plotObservation"
|
|
2 |
"project","/*ID->/*s/project/title"
|
|
3 | 3 |
"PLOT_ID", |
4 |
"plot_code","*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier" |
|
5 |
"major_geo","*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value" |
|
6 |
"country","*UniqueIdentifierID->/*s/plot/country" |
|
7 |
"pol1","*UniqueIdentifierID->/*s/plot/state" |
|
8 |
"pol2","*UniqueIdentifierID->/*s/plot/county" |
|
9 |
"locality_description","*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value" |
|
10 |
"lat_decimal","*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude" |
|
11 |
"long_decimal","*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude" |
|
12 |
"elev_m","*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation" |
|
13 |
"elev_max_m","*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters" |
|
14 |
"elev_min_m","*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters" |
|
15 |
"temp_c","temperature" |
|
16 |
"precip_mm","simpleUserdefined[name=precipMm]/value" |
|
17 |
"slope_aspect","*UniqueIdentifierID->/*s/plot/slopeAspect" |
|
18 |
"slope_gradient","*UniqueIdentifierID->/*s/plot/slopeGradient" |
|
19 |
"clay_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value"
|
|
20 |
"silt_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value"
|
|
21 |
"sand_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value"
|
|
22 |
"organic_percent","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value"
|
|
23 |
"pH","/*s/plotObservation->/*s/abioticObservation[*ID]/ph"
|
|
24 |
"soil_N","/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen"
|
|
25 |
"soil_P","/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus"
|
|
26 |
"soil_C","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value"
|
|
27 |
"soil_K","/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium"
|
|
28 |
"soil_Mg","/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium"
|
|
29 |
"soil_Ca","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value"
|
|
30 |
"soil_Na","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value"
|
|
31 |
"soil_acidity","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value"
|
|
32 |
"soil_base","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value"
|
|
33 |
"soil_cation_cap","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value"
|
|
34 |
"soil_conductivity","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value"
|
|
35 |
"soil_texture","/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value"
|
|
36 |
"holdridge_life_zone","/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name"
|
|
37 |
"life_zone_code","/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName"
|
|
4 |
"plot_code","/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
|
|
5 |
"major_geo","/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value"
|
|
6 |
"country","/*UniqueIdentifierID->/*s/plot/country"
|
|
7 |
"pol1","/*UniqueIdentifierID->/*s/plot/state"
|
|
8 |
"pol2","/*UniqueIdentifierID->/*s/plot/county"
|
|
9 |
"locality_description","/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value"
|
|
10 |
"lat_decimal","/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
|
|
11 |
"long_decimal","/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
|
|
12 |
"elev_m","/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation"
|
|
13 |
"elev_max_m","/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
|
|
14 |
"elev_min_m","/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
|
|
15 |
"temp_c","/temperature"
|
|
16 |
"precip_mm","/simpleUserdefined[name=precipMm]/value"
|
|
17 |
"slope_aspect","/*UniqueIdentifierID->/*s/plot/slopeAspect"
|
|
18 |
"slope_gradient","/*UniqueIdentifierID->/*s/plot/slopeGradient"
|
|
19 |
"clay_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value" |
|
20 |
"silt_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value" |
|
21 |
"sand_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value" |
|
22 |
"organic_percent","->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value" |
|
23 |
"pH","->/*s/abioticObservation[*ID]/ph" |
|
24 |
"soil_N","->/*s/abioticObservation[*ID]/nitrogen" |
|
25 |
"soil_P","->/*s/abioticObservation[*ID]/phosphorus" |
|
26 |
"soil_C","->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value" |
|
27 |
"soil_K","->/*s/abioticObservation[*ID]/pottasium" |
|
28 |
"soil_Mg","->/*s/abioticObservation[*ID]/magnesium" |
|
29 |
"soil_Ca","->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value" |
|
30 |
"soil_Na","->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value" |
|
31 |
"soil_acidity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value" |
|
32 |
"soil_base","->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value" |
|
33 |
"soil_cation_cap","->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value" |
|
34 |
"soil_conductivity","->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value" |
|
35 |
"soil_texture","->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value" |
|
36 |
"holdridge_life_zone","->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name" |
|
37 |
"life_zone_code","->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName" |
|
38 | 38 |
"observation_type", |
39 |
"plot_methodology","simpleUserdefined[name=plotMethodology]/value" |
|
40 |
"plot_area_ha","*UniqueIdentifierID->/*s/plot/area" |
|
39 |
"plot_methodology","/simpleUserdefined[name=plotMethodology]/value"
|
|
40 |
"plot_area_ha","/*UniqueIdentifierID->/*s/plot/area"
|
|
41 | 41 |
"recensused", |
42 |
"date_start","obsStartDate" |
|
43 |
"date_finish","obsEndDate" |
|
42 |
"date_start","/obsStartDate" |
|
43 |
"date_finish","/obsEndDate" |
mappings/SALVIAS-VegX.organisms.csv | ||
---|---|---|
1 |
"SALVIAS","VegX/*s/individualOrganismObservation/"
|
|
2 |
"OBSERVATION_ID","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher" |
|
1 |
"SALVIAS","VegX:/*s/individualOrganismObservation"
|
|
2 |
"OBSERVATION_ID","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
|
|
3 | 3 |
"PLOT_ID", |
4 |
"plot_code","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier" |
|
5 |
"census_no","simpleUserdefined[name=censusNo]/value" |
|
6 |
"census_date","*ID->/*s/plotObservation/obsStartDate" |
|
7 |
"subplot","*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier" |
|
8 |
"individual_code","simpleUserdefined[name=individualCode]/value" |
|
4 |
"plot_code","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier"
|
|
5 |
"census_no","/simpleUserdefined[name=censusNo]/value"
|
|
6 |
"census_date","/*ID->/*s/plotObservation/obsStartDate"
|
|
7 |
"subplot","/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
|
|
8 |
"individual_code","/simpleUserdefined[name=individualCode]/value"
|
|
9 | 9 |
"ind_id", |
10 |
"tag1","*ID->/*s/individualOrganism/identificationLabel" |
|
11 |
"tag2","*ID->/*s/individualOrganism/identificationLabel" |
|
12 |
"x_position","simpleUserdefined[name=xPosition]/value" |
|
13 |
"y_position","simpleUserdefined[name=yPosition]/value" |
|
14 |
"voucher_string","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode" |
|
15 |
"coll_number","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode" |
|
10 |
"tag1","/*ID->/*s/individualOrganism/identificationLabel"
|
|
11 |
"tag2","/*ID->/*s/individualOrganism/identificationLabel"
|
|
12 |
"x_position","/simpleUserdefined[name=xPosition]/value"
|
|
13 |
"y_position","/simpleUserdefined[name=yPosition]/value"
|
|
14 |
"voucher_string","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
|
|
15 |
"coll_number","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
|
|
16 | 16 |
"collector_code", |
17 |
"coll_lastname","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName" |
|
18 |
"coll_firstname","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName" |
|
19 |
"det_type","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType" |
|
17 |
"coll_lastname","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName"
|
|
18 |
"coll_firstname","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName"
|
|
19 |
"det_type","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType"
|
|
20 | 20 |
"fam_status", |
21 | 21 |
"gen_status", |
22 | 22 |
"species_status", |
23 |
"family","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name" |
|
24 |
"genus","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name" |
|
25 |
"specific_epithet","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name" |
|
26 |
"specific_authority","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple" |
|
27 |
"infra_rank_1","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank" |
|
28 |
"infra_ep_1","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name" |
|
29 |
"cf_aff","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note" |
|
23 |
"family","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
|
|
24 |
"genus","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
|
|
25 |
"specific_epithet","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
|
|
26 |
"specific_authority","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
|
|
27 |
"infra_rank_1","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank"
|
|
28 |
"infra_ep_1","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name"
|
|
29 |
"cf_aff","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note"
|
|
30 | 30 |
"comments", |
31 |
"habit","simpleUserdefined[name=habit]/value" |
|
32 |
"no_of_individuals","*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value"
|
|
33 |
"cover_percent","simpleUserdefined[name=coverPercent]/value" |
|
34 |
"intercept_cm","simpleUserdefined[name=interceptCm]/value" |
|
35 |
"height_m","height" |
|
36 |
"ht_first_branch_m","simpleUserdefined[name=htFirstBranchM]/value" |
|
37 |
"stem_tag1","*ID->/*s/individualOrganism/identificationLabel" |
|
38 |
"stem_tag2","*ID->/*s/individualOrganism/identificationLabel" |
|
39 |
"stem_dbh","diameterBaseDistance[baseDistance=1.37]/diameter" |
|
40 |
"basal_diam","diameterBaseDistance[baseDistance=0]/diameter" |
|
41 |
"stem_height_m","simpleUserdefined[name=stemHeightM]/value" |
|
42 |
"stem_height_first_branch_m","simpleUserdefined[name=stemHeightFirstBranchM]/value" |
|
43 |
"stem_canopy_form","simpleUserdefined[name=stemCanopyForm]/value" |
|
44 |
"stem_canopy_position","simpleUserdefined[name=stemCanopyPosition]/value" |
|
45 |
"stem_liana_infestation","simpleUserdefined[name=stemLianaInfestation]/value" |
|
46 |
"notes","*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text" |
|
31 |
"habit","/simpleUserdefined[name=habit]/value"
|
|
32 |
"no_of_individuals","/simpleUserdefined[name=count]/value"
|
|
33 |
"cover_percent","/simpleUserdefined[name=coverPercent]/value"
|
|
34 |
"intercept_cm","/simpleUserdefined[name=interceptCm]/value"
|
|
35 |
"height_m","/height"
|
|
36 |
"ht_first_branch_m","/simpleUserdefined[name=htFirstBranchM]/value"
|
|
37 |
"stem_tag1","/*ID->/*s/individualOrganism/identificationLabel"
|
|
38 |
"stem_tag2","/*ID->/*s/individualOrganism/identificationLabel"
|
|
39 |
"stem_dbh","/diameterBaseDistance[baseDistance=1.37]/diameter"
|
|
40 |
"basal_diam","/diameterBaseDistance[baseDistance=0]/diameter"
|
|
41 |
"stem_height_m","/simpleUserdefined[name=stemHeightM]/value"
|
|
42 |
"stem_height_first_branch_m","/simpleUserdefined[name=stemHeightFirstBranchM]/value"
|
|
43 |
"stem_canopy_form","/simpleUserdefined[name=stemCanopyForm]/value"
|
|
44 |
"stem_canopy_position","/simpleUserdefined[name=stemCanopyPosition]/value"
|
|
45 |
"stem_liana_infestation","/simpleUserdefined[name=stemLianaInfestation]/value"
|
|
46 |
"notes","/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
|
|
47 | 47 |
"orig_family", |
48 | 48 |
"orig_species", |
mappings/extract_plot_map | ||
---|---|---|
5 | 5 |
cd "$selfDir" |
6 | 6 |
|
7 | 7 |
export \ |
8 |
left_in_root='/*s/individualOrganismObservation/*ID->/*s/plotObservation/' \
|
|
9 |
left_out_root='/*s/plotObservation/' \
|
|
10 |
right_in_root='/taxonObservation/*_ID/observation/' \
|
|
11 |
right_out_root='/observation/'
|
|
8 |
left_in_root='/*s/individualOrganismObservation/*ID->/*s/plotObservation' \ |
|
9 |
left_out_root='/*s/plotObservation' \ |
|
10 |
right_in_root='/taxonObservation/*_ID/observation' \ |
|
11 |
right_out_root='/observation' |
|
12 | 12 |
|
13 | 13 |
../scripts/util/ch_map_root <VegX-VegBank.organisms.csv >VegX-VegBank.plots.csv |
mappings/VegX-VegBank.plots.csv | ||
---|---|---|
1 |
VegX/*s/plotObservation/,VegBank/observation/ |
|
2 |
*ID->/*s/project/title,*_ID/project/projectName |
|
3 |
*UniqueIdentifierID->/*s/plot/area,*_ID/plot/area |
|
4 |
*UniqueIdentifierID->/*s/plot/country,*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName |
|
5 |
*UniqueIdentifierID->/*s/plot/county,*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName |
|
6 |
*UniqueIdentifierID->/*s/plot/county,*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName |
|
7 |
*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,*_ID/plot/locationAccuracy |
|
8 |
*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,*_ID/plot/realLatitude |
|
9 |
*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,*_ID/plot/realLongitude |
|
10 |
*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,*_ID/plot/dsgpoly |
|
11 |
*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,waterDepth/max |
|
12 |
*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"*_ID/plot/{elevation/max,elevationRange/to}" |
|
13 |
*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,waterDepth/min |
|
14 |
*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"*_ID/plot/{elevation/min,elevationRange/from}" |
|
15 |
*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,*_ID/plot/elevation |
|
16 |
*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,*_ID/plot/authorPlotCode |
|
17 |
*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"{*_ID/plot/authorPlotCode,authorObsCode}" |
|
18 |
*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode |
|
19 |
*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
20 |
*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
21 |
*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName |
|
22 |
*UniqueIdentifierID->/*s/plot/slopeAspect,*_ID/plot/slopeAspect |
|
23 |
*UniqueIdentifierID->/*s/plot/slopeGradient,*_ID/plot/slopeGradient |
|
24 |
*UniqueIdentifierID->/*s/plot/state,*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName |
|
25 |
*UniqueIdentifierID->/*s/plot/state,*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName |
|
26 |
obsEndDate,obsEndDate |
|
27 |
obsStartDate,obsStartDate |
|
28 |
obsStartDate/_date/day,obsStartDate/_date/day |
|
29 |
obsStartDate/_date/month,obsStartDate/_date/month |
|
30 |
obsStartDate/_date/year,obsStartDate/_date/year |
|
31 |
simpleUserdefined[name=plotMethodology]/value,methodNarrative |
|
32 |
simpleUserdefined[name=precipMm]/value,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue" |
|
33 |
temperature,"definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue" |
|
1 |
VegX:/*s/plotObservation,VegBank:/observation |
|
2 |
->/*s/abioticObservation[*ID]/magnesium,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilMagnesium]]/definedValue" |
|
3 |
->/*s/abioticObservation[*ID]/nitrogen,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilNitrogen]]/definedValue" |
|
4 |
->/*s/abioticObservation[*ID]/ph,/soilObs/soilPH |
|
5 |
->/*s/abioticObservation[*ID]/phosphorus,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]]/definedValue" |
|
6 |
->/*s/abioticObservation[*ID]/pottasium,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilPotassium]]/definedValue" |
|
7 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilAcidity]]/definedValue" |
|
8 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilBase]]/definedValue" |
|
9 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCalcium]]/definedValue" |
|
10 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCarbon]]/definedValue" |
|
11 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilCationCap]]/definedValue" |
|
12 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value,/soilObs/soilClay |
|
13 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilConductivity]]/definedValue" |
|
14 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value,/soilObs/soilOrganic |
|
15 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value,/soilObs/soilSand |
|
16 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value,/soilObs/soilSilt |
|
17 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,"/soilObs/definedValue[@fkey=tableRecord_ID,userDefined[tableName=soilObs,userDefinedName=soilSodium]]/definedValue" |
|
18 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilObs/soilTexture |
|
19 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/commconcept_ID/*_ID/observation/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName |
|
20 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription |
|
21 |
/*ID->/*s/project/title,/*_ID/project/projectName |
|
22 |
/*UniqueIdentifierID->/*s/plot/area,/*_ID/plot/area |
|
23 |
/*UniqueIdentifierID->/*s/plot/country,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=area|country|territory])/placeName |
|
24 |
/*UniqueIdentifierID->/*s/plot/county,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName |
|
25 |
/*UniqueIdentifierID->/*s/plot/county,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=county])/placeName |
|
26 |
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_ID/plot/locationAccuracy |
|
27 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_ID/plot/realLatitude |
|
28 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_ID/plot/realLongitude |
|
29 |
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_ID/plot/dsgpoly |
|
30 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterDepth/max |
|
31 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/plot/{elevation/max,elevationRange/to}" |
|
32 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterDepth/min |
|
33 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plot/{elevation/min,elevationRange/from}" |
|
34 |
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_ID/plot/elevation |
|
35 |
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/authorPlotCode |
|
36 |
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{*_ID/plot/authorPlotCode,authorObsCode}" |
|
37 |
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_ID/plot/PARENT_ID->/*_ID/observation/*_ID/plot/authorPlotCode |
|
38 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
39 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_ID/plot/place/*_ID/namedPlace/placeDescription |
|
40 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=continent])/placeName |
|
41 |
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_ID/plot/slopeAspect |
|
42 |
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_ID/plot/slopeGradient |
|
43 |
/*UniqueIdentifierID->/*s/plot/state,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=Geographic Name])/placeName |
|
44 |
/*UniqueIdentifierID->/*s/plot/state,/*_ID/plot/place(/*_ID/namedPlace[placeSystem=region|state|province])/placeName |
|
45 |
/obsEndDate,/obsEndDate |
|
46 |
/obsStartDate,/obsStartDate |
|
47 |
/obsStartDate/_date/day,/obsStartDate/_date/day |
|
48 |
/obsStartDate/_date/month,/obsStartDate/_date/month |
|
49 |
/obsStartDate/_date/year,/obsStartDate/_date/year |
|
50 |
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative |
|
51 |
/simpleUserdefined[name=precipMm]/value,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=precipitationMm]]/definedValue" |
|
52 |
/temperature,"/definedValue[@fkey=tableRecord_ID,userDefined[tableName=observation,userDefinedName=temperatureC]]/definedValue" |
Also available in: Unified diff
Fixed ch_map_root to support subpaths which follow the root by -> rather than /. Changed spreadsheet syntax to have : between label and root.