Revision 3337
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/SALVIAS-CSV/test/VegBIEN.organisms.xml.ref | ||
|---|---|---|
| 7 | 7 |
<locationevent_id> |
| 8 | 8 |
<locationevent> |
| 9 | 9 |
<obsstartdate>2001-01-01</obsstartdate> |
| 10 |
<authorlocationcode>1</authorlocationcode> |
|
| 11 |
<location_id> |
|
| 12 |
<location> |
|
| 13 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 14 |
<sourceaccessioncode>26102; 1</sourceaccessioncode> |
|
| 15 |
</location> |
|
| 16 |
</location_id> |
|
| 10 | 17 |
<parent_id> |
| 11 | 18 |
<locationevent> |
| 12 | 19 |
<authorlocationcode>ALP-11</authorlocationcode> |
| 13 | 20 |
<location_id> |
| 14 | 21 |
<location> |
| 22 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 15 | 23 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| 16 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 17 | 24 |
</location> |
| 18 | 25 |
</location_id> |
| 19 | 26 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| 20 | 27 |
</locationevent> |
| 21 | 28 |
</parent_id> |
| 22 |
<location_id> |
|
| 23 |
<location> |
|
| 24 |
<sourceaccessioncode>26102; 1</sourceaccessioncode> |
|
| 25 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 26 |
</location> |
|
| 27 |
</location_id> |
|
| 28 |
<authorlocationcode>1</authorlocationcode> |
|
| 29 | 29 |
</locationevent> |
| 30 | 30 |
</locationevent_id> |
| 31 | 31 |
<growthform>tree</growthform> |
| ... | ... | |
| 120 | 120 |
<locationevent_id> |
| 121 | 121 |
<locationevent> |
| 122 | 122 |
<obsstartdate>2001-01-01</obsstartdate> |
| 123 |
<authorlocationcode>4</authorlocationcode> |
|
| 124 |
<location_id> |
|
| 125 |
<location> |
|
| 126 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 127 |
<sourceaccessioncode>26102; 4</sourceaccessioncode> |
|
| 128 |
</location> |
|
| 129 |
</location_id> |
|
| 123 | 130 |
<parent_id> |
| 124 | 131 |
<locationevent> |
| 125 | 132 |
<authorlocationcode>ALP-11</authorlocationcode> |
| 126 | 133 |
<location_id> |
| 127 | 134 |
<location> |
| 135 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 128 | 136 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| 129 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 130 | 137 |
</location> |
| 131 | 138 |
</location_id> |
| 132 | 139 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| 133 | 140 |
</locationevent> |
| 134 | 141 |
</parent_id> |
| 135 |
<location_id> |
|
| 136 |
<location> |
|
| 137 |
<sourceaccessioncode>26102; 4</sourceaccessioncode> |
|
| 138 |
<datasource_id><party><organizationname>SALVIAS-CSV</organizationname></party></datasource_id> |
|
| 139 |
</location> |
|
| 140 |
</location_id> |
|
| 141 |
<authorlocationcode>4</authorlocationcode> |
|
| 142 | 142 |
</locationevent> |
| 143 | 143 |
</locationevent_id> |
| 144 | 144 |
<growthform>tree</growthform> |
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 37 | 37 |
soil_Na,"/soilobs/sodium/_units:[default=""%"",to=]/value", |
| 38 | 38 |
soil_texture,/soilobs/texture, |
| 39 | 39 |
temp_c,/temperature, |
| 40 |
plot_code,":[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 41 |
PLOT_ID,":[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
|
|
| 40 |
plot_code,"/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project); ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 41 |
PLOT_ID,"/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/1}","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata.; ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 42 | 42 |
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type" |
| 43 | 43 |
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values" |
| inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegBIEN:/plantobservation,Comments |
| 2 | 2 |
census_date,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year, |
| 3 |
plot_code,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}","Brad: Same as plotCode, above"
|
|
| 4 |
PLOT_ID,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}","Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
|
|
| 5 |
subplot,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 3 |
subplot,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 4 |
plot_code,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/2},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/2}","Brad: Same as plotCode, above; ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 5 |
PLOT_ID,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/1},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/1}","Brad: Not sure why this is repeated? This field and plotCode, as the same as above.; ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 6 | 6 |
habit,"/aggregateoccurrence/*_id/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=]/value","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
|
| 7 | 7 |
infra_rank_1,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 8 | 8 |
specific_authority,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss. |
| inputs/CTFS/test/VegBIEN.organisms.xml.ref | ||
|---|---|---|
| 7 | 7 |
<locationevent_id> |
| 8 | 8 |
<locationevent> |
| 9 | 9 |
<obsstartdate>1981-05-03</obsstartdate> |
| 10 |
<authorlocationcode>3811</authorlocationcode> |
|
| 10 | 11 |
<location_id> |
| 11 | 12 |
<location> |
| 12 | 13 |
<datasource_id><party><organizationname>CTFS</organizationname></party></datasource_id> |
| 13 | 14 |
<sourceaccessioncode>2733</sourceaccessioncode> |
| 14 | 15 |
</location> |
| 15 | 16 |
</location_id> |
| 16 |
<authorlocationcode>3811</authorlocationcode> |
|
| 17 | 17 |
<sourceaccessioncode>2733</sourceaccessioncode> |
| 18 | 18 |
</locationevent> |
| 19 | 19 |
</locationevent_id> |
| ... | ... | |
| 78 | 78 |
<locationevent_id> |
| 79 | 79 |
<locationevent> |
| 80 | 80 |
<obsstartdate>1981-05-03</obsstartdate> |
| 81 |
<authorlocationcode>3811</authorlocationcode> |
|
| 81 | 82 |
<location_id> |
| 82 | 83 |
<location> |
| 83 | 84 |
<datasource_id><party><organizationname>CTFS</organizationname></party></datasource_id> |
| 84 | 85 |
<sourceaccessioncode>2733</sourceaccessioncode> |
| 85 | 86 |
</location> |
| 86 | 87 |
</location_id> |
| 87 |
<authorlocationcode>3811</authorlocationcode> |
|
| 88 | 88 |
<sourceaccessioncode>2733</sourceaccessioncode> |
| 89 | 89 |
</locationevent> |
| 90 | 90 |
</locationevent_id> |
| inputs/CTFS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 42 | 42 |
/*ID->/*s/plotObservation/temperature,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/temperature, |
| 43 | 43 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value", |
| 44 | 44 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value", |
| 45 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1,
|
|
| 49 |
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/2},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/1},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| 51 | 51 |
/simpleUserdefined[name=growthForm]/value,/aggregateoccurrence/*_id/taxonoccurrence/growthform, |
| 52 | 52 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 53 | 53 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| inputs/SALVIAS/test/VegBIEN.organisms.xml.ref | ||
|---|---|---|
| 6 | 6 |
<taxonoccurrence> |
| 7 | 7 |
<locationevent_id> |
| 8 | 8 |
<locationevent> |
| 9 |
<authorlocationcode>1</authorlocationcode> |
|
| 10 |
<location_id> |
|
| 11 |
<location> |
|
| 12 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 13 |
<sourceaccessioncode>295; 1</sourceaccessioncode> |
|
| 14 |
</location> |
|
| 15 |
</location_id> |
|
| 9 | 16 |
<parent_id> |
| 10 | 17 |
<locationevent> |
| 11 | 18 |
<authorlocationcode>c2000-1</authorlocationcode> |
| 12 | 19 |
<location_id> |
| 13 | 20 |
<location> |
| 21 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 14 | 22 |
<sourceaccessioncode>295</sourceaccessioncode> |
| 15 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 16 | 23 |
</location> |
| 17 | 24 |
</location_id> |
| 18 | 25 |
<sourceaccessioncode>295</sourceaccessioncode> |
| 19 | 26 |
</locationevent> |
| 20 | 27 |
</parent_id> |
| 21 |
<location_id> |
|
| 22 |
<location> |
|
| 23 |
<sourceaccessioncode>295; 1</sourceaccessioncode> |
|
| 24 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 25 |
</location> |
|
| 26 |
</location_id> |
|
| 27 |
<authorlocationcode>1</authorlocationcode> |
|
| 28 | 28 |
</locationevent> |
| 29 | 29 |
</locationevent_id> |
| 30 | 30 |
<growthform>tree</growthform> |
| ... | ... | |
| 109 | 109 |
<taxonoccurrence> |
| 110 | 110 |
<locationevent_id> |
| 111 | 111 |
<locationevent> |
| 112 |
<authorlocationcode>1</authorlocationcode> |
|
| 113 |
<location_id> |
|
| 114 |
<location> |
|
| 115 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 116 |
<sourceaccessioncode>295; 1</sourceaccessioncode> |
|
| 117 |
</location> |
|
| 118 |
</location_id> |
|
| 112 | 119 |
<parent_id> |
| 113 | 120 |
<locationevent> |
| 114 | 121 |
<authorlocationcode>c2000-1</authorlocationcode> |
| 115 | 122 |
<location_id> |
| 116 | 123 |
<location> |
| 124 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 117 | 125 |
<sourceaccessioncode>295</sourceaccessioncode> |
| 118 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 119 | 126 |
</location> |
| 120 | 127 |
</location_id> |
| 121 | 128 |
<sourceaccessioncode>295</sourceaccessioncode> |
| 122 | 129 |
</locationevent> |
| 123 | 130 |
</parent_id> |
| 124 |
<location_id> |
|
| 125 |
<location> |
|
| 126 |
<sourceaccessioncode>295; 1</sourceaccessioncode> |
|
| 127 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
|
| 128 |
</location> |
|
| 129 |
</location_id> |
|
| 130 |
<authorlocationcode>1</authorlocationcode> |
|
| 131 | 131 |
</locationevent> |
| 132 | 132 |
</locationevent_id> |
| 133 | 133 |
<growthform>tree</growthform> |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 37 | 37 |
soil_Na,"/soilobs/sodium/_units:[default=""%"",to=]/value", |
| 38 | 38 |
soil_texture,"/soilobs/texture/_units:[default=""%"",to=]/value", |
| 39 | 39 |
Temp,/temperature, |
| 40 |
SiteCode,":[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 41 |
PlotID,":[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
|
|
| 40 |
SiteCode,"/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project); ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 41 |
PlotID,"/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/1}","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata.; ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 42 | 42 |
AccessCode,,** No input mapping for AccessCode ** |
| 43 | 43 |
ElevSource,,** No input mapping for ElevSource ** |
| 44 | 44 |
Habitat,,** No input mapping for Habitat ** |
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:/plantobservation,Comments |
| 2 |
PlotCode,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}","Brad: Same as plotCode, above"
|
|
| 3 |
PlotID,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}","Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
|
|
| 4 |
Line,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 2 |
Line,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 3 |
PlotCode,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/2},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/2}","Brad: Same as plotCode, above; ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 4 |
PlotID,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/1},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/1}","Brad: Not sure why this is repeated? This field and plotCode, as the same as above.; ""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 5 | 5 |
Habit,"/aggregateoccurrence/*_id/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=]/value","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
|
| 6 | 6 |
infra_rank_1,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 7 | 7 |
auth,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss. |
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 42 | 42 |
/temperature,/temperature, |
| 43 | 43 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value", |
| 44 | 44 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value", |
| 45 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
/partyWithRole/*ID->/parties/party/organizationName,:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1, |
|
| 49 |
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,":[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,":[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/{./parent_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/2},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/1},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/{./parent_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
/partyWithRole/*ID->/parties/party/organizationName,/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 42 | 42 |
/*ID->/*s/plotObservation/temperature,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/temperature, |
| 43 | 43 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value", |
| 44 | 44 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value", |
| 45 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1,
|
|
| 49 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/2},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/1},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| 51 | 51 |
/simpleUserdefined[name=growthForm]/value,/aggregateoccurrence/*_id/taxonoccurrence/growthform, |
| 52 | 52 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 53 | 53 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| mappings/for_review/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 42 | 42 |
/temperature,/temperature, |
| 43 | 43 |
//geospatial/maximumDepthInMeters,/waterdepth/_avg/max/_units/value, |
| 44 | 44 |
//geospatial/minimumDepthInMeters,/waterdepth/_avg/min/_units/value, |
| 45 |
//plot/plotName,"/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
//party/organizationName,/{parent_id/locationevent/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
//plot/plotUniqueIdentifier,"/{parent_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
//party/organizationName,//party/organizationname/_alt/1, |
|
| 49 |
//plot/plotName,"/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
//plot/plotUniqueIdentifier,"/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
//plot/plotName,"/{./authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
//plot/plotName,"/{./parent_id/locationevent/{./authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
//plot/plotUniqueIdentifier,"/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
//party/organizationName,/{./parent_id/locationevent/{.}/*_id/location/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
//plot/plotUniqueIdentifier,"/{./sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
//party/organizationName,/{.}/*_id/location/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 42 | 42 |
//plotObservation/temperature,//locationevent/temperature, |
| 43 | 43 |
//geospatial/maximumDepthInMeters,//locationevent/waterdepth/_avg/max/_units/value, |
| 44 | 44 |
//geospatial/minimumDepthInMeters,//locationevent/waterdepth/_avg/min/_units/value, |
| 45 |
//plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
//party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
//plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
//party/organizationName,//party/organizationname/_alt/1,
|
|
| 49 |
//plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
//plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
//plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
//plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
//plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
//party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{.}/*_id/location/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
//plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
//party/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{.}/*_id/location/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| 51 | 51 |
/simpleUserdefined[name=growthForm]/value,//taxonoccurrence/growthform, |
| 52 | 52 |
//*s/taxonConcept[tcs:@code=TaxonomicRankBelowSubspeciesEnum]/tcs:Rank,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 53 | 53 |
//*s/taxonConcept[tcs:@code=auth]/tcs:Name,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| mappings/for_review/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 42 | 42 |
//plotObservation/temperature,//locationevent/temperature, |
| 43 | 43 |
//geospatial/maximumDepthInMeters,//locationevent/waterdepth/_avg/max/_units/value, |
| 44 | 44 |
//geospatial/minimumDepthInMeters,//locationevent/waterdepth/_avg/min/_units/value, |
| 45 |
//plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
//party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
//plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
//party/organizationName,//party/organizationname/_alt/1,
|
|
| 49 |
//plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
//plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
//plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
//plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
//plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
//party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{.}/*_id/location/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
//plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
//party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{.}/*_id/location/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| 51 | 51 |
//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,//taxonoccurrence/growthform, |
| 52 | 52 |
//*s/taxonConcept[tcs:@code=TaxonomicRankBelowSubspeciesEnum]/tcs:Rank,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 53 | 53 |
//*s/taxonConcept[tcs:@code=auth]/tcs:Name,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| mappings/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 42 | 42 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/temperature,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/temperature, |
| 43 | 43 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value", |
| 44 | 44 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value", |
| 45 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_alt/2},*_id/location/sourceaccessioncode/_merge/1/_alt/2}",
|
|
| 46 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1},
|
|
| 47 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{parent_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_alt/1},*_id/location/sourceaccessioncode/_merge/1/_alt/1}",
|
|
| 48 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/*_id/location/datasource_id/party/organizationname/_alt/1,
|
|
| 49 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
|
| 50 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[*_id/location/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
|
| 45 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 46 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./authorlocationcode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/2},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/2}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 47 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_alt/1},*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/1/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 48 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./parent_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1},"""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 49 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{./sourceaccessioncode,*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode/_merge/2/_alt/1}","""{./"" sorts it before the location.datasource_id mapping with ""{.}"""
|
|
| 50 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{.}/*_id/location:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,"""{.}"" sorts it with other location mappings with a datasource_id"
|
|
| 51 | 51 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/simpleUserdefined[name=growthForm]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/growthform, |
| 52 | 52 |
"/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 53 | 53 |
"/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name","/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
Also available in: Unified diff
mappings/VegX-VegBIEN.stems.csv: Reattached location.datasource_id :[] mappings directly to the location itself, rather than to the location via the locationevent