Project

General

Profile

« Previous | Next » 

Revision 428

VegX-VegBIEN mapping: Fixed syntax error in mapping

View differences:

inputs/SALVIAS/map.VegBIEN.organisms.csv
25 25
Genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
26 26
auth,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
27 27
Species,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
28
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first",
29
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last",
28
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}",
29
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}",
30 30
OrigFamily,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
31 31
OrigSpecies,"/{taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
32 32
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/SALVIAS_db-VegBIEN.organisms.csv
25 25
Genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
26 26
auth,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
27 27
Species,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
28
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first",
29
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last",
28
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}",
29
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}",
30 30
OrigFamily,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
31 31
OrigSpecies,"/{taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
32 32
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/VegX-VegBIEN.organisms.csv
91 91
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
92 92
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname"
93 93
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
94
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first"
95
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last"
94
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}"
95
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}"
96 96
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day"
97 97
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month"
98 98
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year"
mappings/for_review/SALVIAS_db-VegBIEN.organisms.csv
25 25
Genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
26 26
auth,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
27 27
Species,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
28
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/first",
29
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/last",
28
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/*_id/*/plantname/_name/first}",
29
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/last,*_id/plantconcept/*_id/*/plantname/_name/last}",
30 30
OrigFamily,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
31 31
OrigSpecies,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname},taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
32 32
PlotObsID,"/{taxondetermination[rolecode=collector]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot/authorcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/for_review/VegX-VegBIEN.organisms.csv
91 91
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
92 92
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname"
93 93
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
94
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/first"
95
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/last"
94
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/*_id/*/plantname/_name/first}"
95
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/last,*_id/plantconcept/*_id/*/plantname/_name/last}"
96 96
//*s/taxonDetermination[role=identifier]/date/_date/day,/taxondetermination[rolecode=identifier]/determinationdate/_date/day
97 97
//*s/taxonDetermination[role=identifier]/date/_date/month,/taxondetermination[rolecode=identifier]/determinationdate/_date/month
98 98
//*s/taxonDetermination[role=identifier]/date/_date/year,/taxondetermination[rolecode=identifier]/determinationdate/_date/year
mappings/for_review/SALVIAS-VegBIEN.organisms.csv
33 33
genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
34 34
specific_authority,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
35 35
specific_epithet,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
36
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/first",
37
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/last",
36
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/*_id/*/plantname/_name/first}",
37
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/last,*_id/plantconcept/*_id/*/plantname/_name/last}",
38 38
orig_family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
39 39
orig_species,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname},taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
40 40
OBSERVATION_ID,"/{taxondetermination[rolecode=collector]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot/authorcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/SALVIAS-VegBIEN.organisms.csv
33 33
genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
34 34
specific_authority,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
35 35
specific_epithet,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
36
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first",
37
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last",
36
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}",
37
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}",
38 38
orig_family,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
39 39
orig_species,"/{taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
40 40
OBSERVATION_ID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."

Also available in: Unified diff