Project

General

Profile

« Previous | Next » 

Revision 49

Added refactored mappings and changed data2xml to use the new 2-column format

View differences:

scripts/util/NYBG-VegBank-VegX_mapping.csv
1
"NYBG","VegBank","VegX"
2
"key",,
3
"DateLastModified",,
4
"InstitutionCode","/taxonInterpretation/museum_ID/party/OrganizationName/_name/firstName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"
5
"CollectionCode","/taxonInterpretation/museum_ID/party/OrganizationName/_name/lastName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"
6
"CatalogNumber","/taxonInterpretation/museumAccessionNumber","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
7
"ScientificName","/plantName/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
8
"BasisOfRecord",,
9
"Kingdom","/plantName[plantStatus/plantLevel=Kingdom]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
10
"Phylum","/plantName[plantStatus/plantLevel=Subkingdom]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
11
"Class","/plantName[plantStatus/plantLevel=Class]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
12
"Order","/plantName[plantStatus/plantLevel=Order]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
13
"Family","/plantName[plantStatus/plantLevel=Family]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
14
"Genus","/plantName[plantStatus/plantLevel=Genus]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
15
"Species","/plantName[plantStatus/plantLevel=Species]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
16
"Subspecies","/plantName[plantStatus/plantLevel=Subspecies]/plantName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
17
"ScientificNameAuthor","/plantConcept/reference_ID/reference/referenceContributor/referenceParty_ID/referenceParty/{givenName,surname}","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
18
"IdentifiedBy","/taxonInterpretation/PARTY_ID/party/{givenName,middleName,surName}","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"
19
"YearIdentified","/taxonInterpretation/interpretationDate/_date/year","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"
20
"MonthIdentified","/taxonInterpretation/interpretationDate/_date/month","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"
21
"DayIdentified","/taxonInterpretation/interpretationDate/_date/day","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"
22
"TypeStatus",,
23
"CollectorNumber",,
24
"FieldNumber","/taxonInterpretation/collectionNumber","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
25
"Collector","/taxonInterpretation/collector_ID/party/{givenName,middleName,surName}","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"
26
"YearCollected","/taxonInterpretation/collectionDate/_date/year","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/year"
27
"MonthCollected","/taxonInterpretation/collectionDate/_date/month","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/month"
28
"DayCollected","/taxonInterpretation/collectionDate/_date/day","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/day"
29
"JulianDay",,
30
"TimeOfDay",,
31
"ContinentOcean",,
32
"Country","/namedPlace[placeSystem=area|country|territory]/placeName","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"
33
"StateProvince","/namedPlace[placeSystem=region|state|province]/placeName","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"
34
"County","/namedPlace[placeSystem=county]/placeName","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"
35
"Locality","/namedPlace/placeDescription","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value"
36
"Longitude","/plot/realLongitude","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
37
"Latitude","/plot/realLatitude","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
38
"CoordinatePrecision","/plot/locationAccuracy","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters"
39
"BoundingBox","/plot/dsgpoly","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT"
40
"MinimumElevation","/plot/{elevation/min,elevationRange/from}","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
41
"MaximumElevation","/plot/{elevation/max,elevationRange/to}","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
42
"MinimumDepth","/observation/waterDepth/min","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters"
43
"MaximumDepth","/observation/waterDepth/max","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters"
44
"Sex","/userDefined[tableName=taxonInterpretation,userDefinedName=sex]/definedValue","/*s/individualOrganismObservation/individualOrganismID->/*s/individualOrganismObservation/simpleUserdefined[name=sex]/value"
45
"PreparationType",,
46
"IndividualCount",,
47
"PreviousCatalogNumber",,
48
"RelationshipType",,
49
"RelatedCatalogItem",,
50
"Notes","/taxonInterpretation/notes","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
51
"Habitat","/userDefined[tableName=stemLocation,userDefinedName=habitat]/definedValue","/*s/individualOrganismObservation/simpleUserdefined[name=habitat]/value"
52
"PlantFungusDescription","/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]/definedValue","/*s/individualOrganismObservation/simpleUserdefined[name=plantFungusDescription]/value"
53
"Substrate","/userDefined[tableName=stemLocation,userDefinedName=substrate]/definedValue","/*s/individualOrganismObservation/simpleUserdefined[name=substrate]/value"
54
"Vegetation","/userDefined[tableName=stemLocation,userDefinedName=vegetation]/definedValue","/*s/individualOrganismObservation/simpleUserdefined[name=vegetation]/value"
55
"UniqueNYInternalRecordNumber",,
scripts/data2xml
12 12
import xpath
13 13

  
14 14
def main():
15
    prog_name = sys.argv.pop(0)
16
    try:
17
        dest = sys.argv.pop(0)
18
        mappings_path = sys.argv.pop(0)
19
    except IndexError: raise Exception('Usage: '+prog_name
20
        +' dest_mappings_column mappings_path <dataset >output')
15
    prog_name = sys.argv[0]
16
    try: mappings_path = sys.argv[1]
17
    except ValueError:
18
        raise Exception('Usage: '+prog_name+' mappings_path <dataset >output')
21 19
    
22 20
    # Get mappings
23 21
    mappings = {}
24 22
    has_types = False # whether outer elements are type containiners
25 23
    stream = open(mappings_path, 'rb')
26 24
    reader = csv.reader(stream, delimiter=',', quotechar='"')
27
    fieldnames = reader.next()
28
    src = fieldnames[0]
29
    dest_idx = fieldnames.index(dest)
25
    src, dest = reader.next()[:2]
30 26
    for row in reader:
31
        name = row[0]
32
        path = row[dest_idx]
27
        name, path = row[:2]
33 28
        if name != '' and path != '':
34 29
            if path.startswith('/*s/'): has_types = True # *s used for type elem
35 30
            path = path.replace('<name>', name)
scripts/util/NYBG,VegX.csv
1
link ../../mappings/NYBG,VegX.csv
0 2

  
scripts/util/data2xml_test
8 8
test -n "$n" || n=2
9 9
let n++
10 10

  
11
head -$n NYSpecimenDataAmericas.csv|../data2xml VegX NYBG-VegBank-VegX_mapping.csv
11
head -$n NYSpecimenDataAmericas.csv|../data2xml NYBG,VegX.csv
mappings/NYBG,VegX.csv
1
"NYBG","VegX"
2
"key",
3
"DateLastModified",
4
"InstitutionCode","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName"
5
"CollectionCode","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName"
6
"CatalogNumber","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
7
"ScientificName","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple"
8
"BasisOfRecord",
9
"Kingdom","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name"
10
"Phylum","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name"
11
"Class","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name"
12
"Order","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name"
13
"Family","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
14
"Genus","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name"
15
"Species","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name"
16
"Subspecies","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name"
17
"ScientificNameAuthor","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple"
18
"IdentifiedBy","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}"
19
"YearIdentified","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year"
20
"MonthIdentified","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month"
21
"DayIdentified","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day"
22
"TypeStatus",
23
"CollectorNumber",
24
"FieldNumber","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
25
"Collector","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}"
26
"YearCollected","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/year"
27
"MonthCollected","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/month"
28
"DayCollected","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/day"
29
"JulianDay",
30
"TimeOfDay",
31
"ContinentOcean",
32
"Country","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"
33
"StateProvince","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"
34
"County","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"
35
"Locality","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value"
36
"Longitude","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
37
"Latitude","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
38
"CoordinatePrecision","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters"
39
"BoundingBox","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT"
40
"MinimumElevation","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
41
"MaximumElevation","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
42
"MinimumDepth","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters"
43
"MaximumDepth","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters"
44
"Sex","/*s/individualOrganismObservation/individualOrganismID->/*s/individualOrganismObservation/simpleUserdefined[name=sex]/value"
45
"PreparationType",
46
"IndividualCount",
47
"PreviousCatalogNumber",
48
"RelationshipType",
49
"RelatedCatalogItem",
50
"Notes","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
51
"Habitat","/*s/individualOrganismObservation/simpleUserdefined[name=habitat]/value"
52
"PlantFungusDescription","/*s/individualOrganismObservation/simpleUserdefined[name=plantFungusDescription]/value"
53
"Substrate","/*s/individualOrganismObservation/simpleUserdefined[name=substrate]/value"
54
"Vegetation","/*s/individualOrganismObservation/simpleUserdefined[name=vegetation]/value"
55
"UniqueNYInternalRecordNumber",
mappings/SALVIAS.metadata,VegX.csv
1
"SALVIAS","VegX"
2
"project","/*s/plotObservation/*ID->/*s/project/title"
3
"PLOT_ID",
4
"plot_code","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
5
"major_geo","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value"
6
"country","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country"
7
"pol1","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state"
8
"pol2","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county"
9
"locality_description","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value"
10
"lat_decimal","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude"
11
"long_decimal","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude"
12
"elev_m","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation"
13
"elev_max_m","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters"
14
"elev_min_m","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters"
15
"temp_c","/*s/plotObservation/temperature"
16
"precip_mm","/*s/plotObservation/simpleUserdefined[name=precipMm]/value"
17
"slope_aspect","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect"
18
"slope_gradient","/*s/plotObservation/*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"
38
"observation_type",
39
"plot_methodology","/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value"
40
"plot_area_ha","/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area"
41
"recensused",
42
"date_start","/*s/plotObservation/obsStartDate"
43
"date_finish","/*s/plotObservation/obsEndDate"
mappings/SALVIAS.data,VegX.csv
1
"SALVIAS","VegX"
2
"OBSERVATION_ID","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher"
3
"PLOT_ID",
4
"plot_code","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier"
5
"census_no","/*s/individualOrganismObservation/simpleUserdefined[name=censusNo]/value"
6
"census_date","/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate"
7
"subplot","/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier"
8
"individual_code","/*s/individualOrganismObservation/simpleUserdefined[name=individualCode]/value"
9
"ind_id",
10
"tag1","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel"
11
"tag2","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel"
12
"x_position","/*s/individualOrganismObservation/simpleUserdefined[name=xPosition]/value"
13
"y_position","/*s/individualOrganismObservation/simpleUserdefined[name=yPosition]/value"
14
"voucher_string","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
15
"coll_number","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode"
16
"collector_code",
17
"coll_lastname","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName"
18
"coll_firstname","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName"
19
"det_type","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType"
20
"fam_status",
21
"gen_status",
22
"species_status",
23
"family","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name"
24
"genus","/*s/individualOrganismObservation/*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","/*s/individualOrganismObservation/*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","/*s/individualOrganismObservation/*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","/*s/individualOrganismObservation/*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","/*s/individualOrganismObservation/*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","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note"
30
"comments",
31
"habit","/*s/individualOrganismObservation/simpleUserdefined[name=habit]/value"
32
"no_of_individuals","/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value"
33
"cover_percent","/*s/individualOrganismObservation/simpleUserdefined[name=coverPercent]/value"
34
"intercept_cm","/*s/individualOrganismObservation/simpleUserdefined[name=interceptCm]/value"
35
"height_m","/*s/individualOrganismObservation/height"
36
"ht_first_branch_m","/*s/individualOrganismObservation/simpleUserdefined[name=htFirstBranchM]/value"
37
"stem_tag1","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel"
38
"stem_tag2","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel"
39
"stem_dbh","/*s/individualOrganismObservation/diameterBaseDistance[baseDistance=1.37]/diameter"
40
"basal_diam","/*s/individualOrganismObservation/diameterBaseDistance[baseDistance=0]/diameter"
41
"stem_height_m","/*s/individualOrganismObservation/simpleUserdefined[name=stemHeightM]/value"
42
"stem_height_first_branch_m","/*s/individualOrganismObservation/simpleUserdefined[name=stemHeightFirstBranchM]/value"
43
"stem_canopy_form","/*s/individualOrganismObservation/simpleUserdefined[name=stemCanopyForm]/value"
44
"stem_canopy_position","/*s/individualOrganismObservation/simpleUserdefined[name=stemCanopyPosition]/value"
45
"stem_liana_infestation","/*s/individualOrganismObservation/simpleUserdefined[name=stemLianaInfestation]/value"
46
"notes","/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text"
47
"orig_family",
48
"orig_species",
mappings/VegX,VegBank.csv
1
"VegX","VegBank"
2
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/plantName[plantStatus/plantLevel=Subspecies]/plantName/epithet"
3
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/plantName[plantStatus/plantLevel=Subspecies]/plantName/rank"
4
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/plantName[plantStatus/plantLevel=Family]/plantName"
5
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/plantName[plantStatus/plantLevel=Genus]/plantName"
6
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/plantName[plantStatus/plantLevel=Species]/reference_ID->/referenceParty/{givenName,surname}"
7
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/plantName[plantStatus/plantLevel=Species]/plantName"
8
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=TaxonScrubber]/note","/userDefined[tableName=taxonInterpretation,userDefinedName=cfAff]/definedValue "
9
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/userDefined[tableName=taxonInterpretation,userDefinedName=detType]/definedValue "
10
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxonInterpretation/collector_ID->/party/givenName"
11
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName","/taxonInterpretation/collector_ID->/party/surName"
12
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/plantName[plantStatus/plantLevel=Class]/plantName"
13
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/plantName[plantStatus/plantLevel=Family]/plantName"
14
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/plantName[plantStatus/plantLevel=Genus]/plantName"
15
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/plantName[plantStatus/plantLevel=Order]/plantName"
16
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/plantName[plantStatus/plantLevel=Subkingdom]/plantName"
17
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/plantName[plantStatus/plantLevel=Kingdom]/plantName"
18
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/plantConcept/reference_ID/reference/referenceContributor/referenceParty_ID/referenceParty/{givenName,surname}"
19
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/plantName[plantStatus/plantLevel=Species]/plantName"
20
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/plantName[plantStatus/plantLevel=Subspecies]/plantName"
21
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/plantName/plantName"
22
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/day","/taxonInterpretation/interpretationDate/_date/day"
23
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/month","/taxonInterpretation/interpretationDate/_date/month"
24
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/date/_date/year","/taxonInterpretation/interpretationDate/_date/year"
25
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=collector]/*ID->/parties/party/individualName/{givenName,surName}","/taxonInterpretation/collector_ID/party/{givenName,middleName,surName}"
26
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID]/partyWithRole[role=identifier]/*ID->/parties/party/individualName/{givenName,surName}","/taxonInterpretation/PARTY_ID/party/{givenName,middleName,surName}"
27
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode","/taxonInterpretation/collectionNumber"
28
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text","/taxonInterpretation/notes"
29
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/firstName","/taxonInterpretation/museum_ID/party/OrganizationName/_name/firstName"
30
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/lastName","/taxonInterpretation/museum_ID/party/OrganizationName/_name/lastName"
31
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher","/taxonInterpretation/museumAccessionNumber"
32
"/*s/individualOrganismObservation/*ID->/*s/individualOrganism/identificationLabel","/stemLocation/stemCode"
33
"/*s/individualOrganismObservation/*ID->/*s/plotObservation->/*s/aggregateOrganismObservation[*ID]/simpleUserdefined[name=noOfIndividuals]/value","/stemCount/stemCount"
34
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","/namedPlace[placeSystem=area|country|territory]/placeName"
35
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/namedPlace[placeSystem=county]/placeName"
36
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters","/plot/locationAccuracy"
37
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","/plot/realLatitude"
38
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","/plot/realLongitude"
39
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT","/plot/dsgpoly"
40
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters","/observation/waterDepth/max"
41
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","/plot/{elevation/max,elevationRange/to}"
42
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters","/observation/waterDepth/min"
43
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","/plot/{elevation/min,elevationRange/from}"
44
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/plot/authorPlotCode"
45
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier","/plot/PARENT_ID->/plot/authorPlotCode"
46
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=locality]/value","/namedPlace/placeDescription"
47
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/namedPlace[placeSystem=region|state|province]/placeName"
48
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate","/taxonInterpretation/collectionDate,observation/authorObsCode"
49
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/day","/taxonInterpretation/collectionDate/_date/day"
50
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/month","/taxonInterpretation/collectionDate/_date/month"
51
"/*s/individualOrganismObservation/*ID->/*s/plotObservation/obsStartDate/_date/year","/taxonInterpretation/collectionDate/_date/year"
52
"/*s/individualOrganismObservation/diameterBaseDistance[baseDistance=0]/diameter","/userDefined[tableName=stemLocation,userDefinedName=basalDiam]/definedValue "
53
"/*s/individualOrganismObservation/diameterBaseDistance[baseDistance=1.37]/diameter","/stemCount/stemDiameter"
54
"/*s/individualOrganismObservation/height","/stemCount/stemHeight"
55
"/*s/individualOrganismObservation/individualOrganismID->/*s/individualOrganismObservation/simpleUserdefined[name=sex]/value","/userDefined[tableName=taxonInterpretation,userDefinedName=sex]/definedValue"
56
"/*s/individualOrganismObservation/simpleUserdefined[name=censusNo]/value","/userDefined[tableName=taxonInterpretation,userDefinedName=censusNo]/definedValue "
57
"/*s/individualOrganismObservation/simpleUserdefined[name=coverPercent]/value","/taxonImportance/cover"
58
"/*s/individualOrganismObservation/simpleUserdefined[name=habit]/value","/userDefined[tableName=taxonInterpretation,userDefinedName=habit]/definedValue "
59
"/*s/individualOrganismObservation/simpleUserdefined[name=habitat]/value","/userDefined[tableName=stemLocation,userDefinedName=habitat]/definedValue"
60
"/*s/individualOrganismObservation/simpleUserdefined[name=htFirstBranchM]/value","/userDefined[tableName=stemLocation,userDefinedName=htFirstBranchM]/definedValue "
61
"/*s/individualOrganismObservation/simpleUserdefined[name=individualCode]/value","/userDefined[tableName=taxonInterpretation,userDefinedName=individualCode]/definedValue "
62
"/*s/individualOrganismObservation/simpleUserdefined[name=interceptCm]/value","/userDefined[tableName=taxonImportance,userDefinedName=interceptCm]/definedValue "
63
"/*s/individualOrganismObservation/simpleUserdefined[name=plantFungusDescription]/value","/userDefined[tableName=stemLocation,userDefinedName=plantFungusDescription]/definedValue"
64
"/*s/individualOrganismObservation/simpleUserdefined[name=stemCanopyForm]/value","/userDefined[tableName=stemLocation,userDefinedName=stemCanopyForm]/definedValue "
65
"/*s/individualOrganismObservation/simpleUserdefined[name=stemCanopyPosition]/value","/userDefined[tableName=stemLocation,userDefinedName=stemCanopyPosition]/definedValue "
66
"/*s/individualOrganismObservation/simpleUserdefined[name=stemHeightFirstBranchM]/value","/userDefined[tableName=stemLocation,userDefinedName=stemHeightFirstBranchM]/definedValue "
67
"/*s/individualOrganismObservation/simpleUserdefined[name=stemHeightM]/value","/stemCount/stemHeight"
68
"/*s/individualOrganismObservation/simpleUserdefined[name=stemLianaInfestation]/value","/userDefined[tableName=stemLocation,userDefinedName=stemLianaInfestation]/definedValue "
69
"/*s/individualOrganismObservation/simpleUserdefined[name=substrate]/value","/userDefined[tableName=stemLocation,userDefinedName=substrate]/definedValue"
70
"/*s/individualOrganismObservation/simpleUserdefined[name=vegetation]/value","/userDefined[tableName=stemLocation,userDefinedName=vegetation]/definedValue"
71
"/*s/individualOrganismObservation/simpleUserdefined[name=xPosition]/value","/stemLocation/stemXPosition"
72
"/*s/individualOrganismObservation/simpleUserdefined[name=yPosition]/value","/stemLocation/stemYPosition"
73
"/*s/plotObservation->/*s/abioticObservation[*ID]/magnesium","/userDefined[tableName=soilObs,userDefinedName=soilMagnesium]/definedValue "
74
"/*s/plotObservation->/*s/abioticObservation[*ID]/nitrogen","/userDefined[tableName=soilObs,userDefinedName=soilNitrogen]/definedValue "
75
"/*s/plotObservation->/*s/abioticObservation[*ID]/ph","/soilObs/soilPH"
76
"/*s/plotObservation->/*s/abioticObservation[*ID]/phosphorus","/userDefined[tableName=soilObs,userDefinedName=soilPhosphorus]/definedValue "
77
"/*s/plotObservation->/*s/abioticObservation[*ID]/pottasium","/userDefined[tableName=soilObs,userDefinedName=soilPotassium]/definedValue "
78
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value","/userDefined[tableName=soilObs,userDefinedName=soilAcidity]/definedValue "
79
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value","/userDefined[tableName=soilObs,userDefinedName=soilBase]/definedValue "
80
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value","/userDefined[tableName=soilObs,userDefinedName=soilCalcium]/definedValue "
81
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value","/userDefined[tableName=soilObs,userDefinedName=soilCarbon]/definedValue "
82
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationCap]/value","/userDefined[tableName=soilObs,userDefinedName=soilCationCap]/definedValue "
83
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=clayPercent]/value","/soilObs/soilClay"
84
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value","/userDefined[tableName=soilObs,userDefinedName=soilConductivity]/definedValue "
85
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=organicPercent]/value","/soilObs/soilOrganic"
86
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sandPercent]/value","/soilObs/soilSand"
87
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=siltPercent]/value","/soilObs/soilSilt"
88
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value","/userDefined[tableName=soilObs,userDefinedName=soilSodium]/definedValue "
89
"/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value","/soilObs/soilTexture"
90
"/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName","/commName/commName"
91
"/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name","/commConcept/commDescription"
92
"/*s/plotObservation/*ID->/*s/project/title","/project/projectName"
93
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area","/plot/area"
94
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country","/namedPlace[placeSystem=area|country|territory]/placeName"
95
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county","/namedPlace[placeSystem=Geographic Name]/placeName"
96
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude","/plot/realLatitude"
97
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude","/plot/realLongitude"
98
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters","/plot/elevationRange/max"
99
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters","/plot/elevationRange/min"
100
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation","/plot/elevation"
101
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier","/plot/authorPlotCode,observation/authorObsCode"
102
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value","/namedPlace/placeDescription"
103
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value","/namedPlace[placeSystem=continent]/placeName"
104
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect","/plot/slopeAspect"
105
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient","/plot/slopeGradient"
106
"/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state","/namedPlace[placeSystem=Geographic Name]/placeName"
107
"/*s/plotObservation/obsEndDate","/observation/obsEndDate"
108
"/*s/plotObservation/obsStartDate","/observation/obsStartDate"
109
"/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value","/observation/methodNarrative"
110
"/*s/plotObservation/simpleUserdefined[name=precipMm]/value","/userDefined[tableName=observation,userDefinedName=precipMm]/definedValue "
111
"/*s/plotObservation/temperature","/userDefined[tableName=observation,userDefinedName=tempC]/definedValue "

Also available in: Unified diff