Revision 5638
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
| 37 | 37 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 38 | 38 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 39 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 39 | 40 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 40 | 41 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 41 | 42 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 51 | 52 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 52 | 53 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank, |
| 53 | 54 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 54 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 55 | 55 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
| 56 | 56 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 57 | 57 |
dateIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
| schemas/vegbien.my.sql | ||
|---|---|---|
| 229 | 229 |
rank text, |
| 230 | 230 |
verbatimrank text, |
| 231 | 231 |
identifyingtaxonomicname text, |
| 232 |
taxonomicname text,
|
|
| 232 |
binomial text,
|
|
| 233 | 233 |
author text, |
| 234 | 234 |
taxonomicnamewithauthor text, |
| 235 | 235 |
morphospecies text, |
| ... | ... | |
| 326 | 326 |
|
| 327 | 327 |
|
| 328 | 328 |
-- |
| 329 |
-- Name: COLUMN taxonlabel.taxonomicname; Type: COMMENT; Schema: public; Owner: -
|
|
| 329 |
-- Name: COLUMN taxonlabel.binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 330 | 330 |
-- |
| 331 | 331 |
|
| 332 | 332 |
|
| ... | ... | |
| 1086 | 1086 |
-- |
| 1087 | 1087 |
|
| 1088 | 1088 |
CREATE VIEW analytical_db_view AS |
| 1089 |
SELECT datasource.organizationname AS `dataSourceName`, accepted_taxonlabel.family, accepted_taxonlabel.genus, accepted_taxonlabel.species, COALESCE(accepted_taxonlabel.taxonomicnamewithauthor, accepted_taxonlabel.taxonomicname) AS taxon, accepted_taxonlabel.author AS `taxonAuthor`, accepted_taxonlabel.taxonepithet AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, functions._m2_to_ha(location.area_m2) AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, _fraction_to_percent(aggregateoccurrence.cover_fraction) AS `pctCover` FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1089 |
SELECT datasource.organizationname AS `dataSourceName`, accepted_taxonlabel.family, accepted_taxonlabel.genus, accepted_taxonlabel.species, COALESCE(accepted_taxonlabel.taxonomicnamewithauthor, accepted_taxonlabel.binomial) AS taxon, accepted_taxonlabel.author AS `taxonAuthor`, accepted_taxonlabel.taxonepithet AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, functions._m2_to_ha(location.area_m2) AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, _fraction_to_percent(aggregateoccurrence.cover_fraction) AS `pctCover` FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1090 | 1090 |
|
| 1091 | 1091 |
|
| 1092 | 1092 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 547 | 547 |
rank taxonrank, |
| 548 | 548 |
verbatimrank text, |
| 549 | 549 |
identifyingtaxonomicname text, |
| 550 |
taxonomicname text,
|
|
| 550 |
binomial text,
|
|
| 551 | 551 |
author text, |
| 552 | 552 |
taxonomicnamewithauthor text, |
| 553 | 553 |
morphospecies text, |
| ... | ... | |
| 557 | 557 |
description text, |
| 558 | 558 |
accessioncode text, |
| 559 | 559 |
CONSTRAINT taxonlabel_matched_label_fit_fraction_range CHECK (((matched_label_fit_fraction >= (0)::double precision) AND (matched_label_fit_fraction <= (1)::double precision))), |
| 560 |
CONSTRAINT taxonlabel_required_key CHECK ((((((((sourceaccessioncode IS NOT NULL) OR (taxonepithet IS NOT NULL)) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (morphospecies IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
|
|
| 560 |
CONSTRAINT taxonlabel_required_key CHECK ((((((((sourceaccessioncode IS NOT NULL) OR (taxonepithet IS NOT NULL)) OR (identifyingtaxonomicname IS NOT NULL)) OR (binomial IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (morphospecies IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
|
|
| 561 | 561 |
); |
| 562 | 562 |
|
| 563 | 563 |
|
| ... | ... | |
| 660 | 660 |
|
| 661 | 661 |
|
| 662 | 662 |
-- |
| 663 |
-- Name: COLUMN taxonlabel.taxonomicname; Type: COMMENT; Schema: public; Owner: -
|
|
| 663 |
-- Name: COLUMN taxonlabel.binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 664 | 664 |
-- |
| 665 | 665 |
|
| 666 |
COMMENT ON COLUMN taxonlabel.taxonomicname IS 'The concatenated taxonomic name which uniquely identifies this taxon. Does not include the author of the name.';
|
|
| 666 |
COMMENT ON COLUMN taxonlabel.binomial IS 'The taxonomic name without the author.';
|
|
| 667 | 667 |
|
| 668 | 668 |
|
| 669 | 669 |
-- |
| ... | ... | |
| 1541 | 1541 |
-- |
| 1542 | 1542 |
|
| 1543 | 1543 |
CREATE VIEW analytical_db_view AS |
| 1544 |
SELECT datasource.organizationname AS "dataSourceName", accepted_taxonlabel.family, accepted_taxonlabel.genus, accepted_taxonlabel.species, COALESCE(accepted_taxonlabel.taxonomicnamewithauthor, accepted_taxonlabel.taxonomicname) AS taxon, accepted_taxonlabel.author AS "taxonAuthor", accepted_taxonlabel.taxonepithet AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", functions._m2_to_ha(location.area_m2) AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "pctCover" FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1544 |
SELECT datasource.organizationname AS "dataSourceName", accepted_taxonlabel.family, accepted_taxonlabel.genus, accepted_taxonlabel.species, COALESCE(accepted_taxonlabel.taxonomicnamewithauthor, accepted_taxonlabel.binomial) AS taxon, accepted_taxonlabel.author AS "taxonAuthor", accepted_taxonlabel.taxonepithet AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", functions._m2_to_ha(location.area_m2) AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "pctCover" FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1545 | 1545 |
|
| 1546 | 1546 |
|
| 1547 | 1547 |
-- |
| ... | ... | |
| 4819 | 4819 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4820 | 4820 |
-- |
| 4821 | 4821 |
|
| 4822 |
CREATE UNIQUE INDEX taxonlabel_unique ON taxonlabel USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonepithet, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(creationdate, 'infinity'::date)), (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(morphospecies, '\\N'::text)));
|
|
| 4822 |
CREATE UNIQUE INDEX taxonlabel_unique ON taxonlabel USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonepithet, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(creationdate, 'infinity'::date)), (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(binomial, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(morphospecies, '\\N'::text)));
|
|
| 4823 | 4823 |
|
| 4824 | 4824 |
|
| 4825 | 4825 |
-- |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 149 | 149 |
cultivar,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel}/identifyingtaxonomicname",
|
| 150 | 150 |
scientificNameAuthorship,"//*_id/taxonlabel/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel}/identifyingtaxonomicname",
|
| 151 | 151 |
acceptedScientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/author, |
| 152 |
acceptedBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/binomial, |
|
| 152 | 153 |
acceptedFamily,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/family, |
| 153 | 154 |
acceptedGenus,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/genus, |
| 154 | 155 |
acceptedScientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/identifyingtaxonomicname, |
| ... | ... | |
| 181 | 182 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/parent_id/taxonlabel/verbatimrank, |
| 182 | 183 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/rank, |
| 183 | 184 |
acceptedSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/species, |
| 184 |
acceptedBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
| 185 | 185 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/verbatimrank, |
| 186 | 186 |
parentScientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 187 | 187 |
parentTaxonConceptID,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 188 | 188 |
parentTaxonID,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/sourceaccessioncode, |
| 189 | 189 |
scientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/author, |
| 190 |
binomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/binomial, |
|
| 190 | 191 |
accordingTo,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/creator_id/party/fullname, |
| 191 | 192 |
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/creator_id/party/fullname, |
| 192 | 193 |
family,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/family, |
| ... | ... | |
| 217 | 218 |
specificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/species, |
| 218 | 219 |
taxonName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonepithet, |
| 219 | 220 |
verbatimScientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/author, |
| 221 |
verbatimBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/binomial, |
|
| 220 | 222 |
verbatimFamily,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/family, |
| 221 | 223 |
verbatimGenus,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/genus, |
| 222 | 224 |
verbatimScientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/identifyingtaxonomicname, |
| ... | ... | |
| 227 | 229 |
verbatimScientificName,"//taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
| 228 | 230 |
morphospecies,"//taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/then", |
| 229 | 231 |
verbatimSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/species, |
| 230 |
verbatimBinomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/taxonomicname, |
|
| 231 | 232 |
verbatimTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonlabel/verbatimrank, |
| 232 |
binomial,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonomicname, |
|
| 233 | 233 |
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonomicnamewithauthor, |
| 234 | 234 |
taxonomicStatus,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/taxonstatus, |
| 235 | 235 |
taxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonlabel/verbatimrank, |
| ... | ... | |
| 240 | 240 |
monthIdentified,"//taxonoccurrence/taxondetermination[]/{determinationdate,*_id/taxonlabel/creationdate}",
|
| 241 | 241 |
yearIdentified,"//taxonoccurrence/taxondetermination[]/{determinationdate,*_id/taxonlabel/creationdate}",
|
| 242 | 242 |
originalScientificNameAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/author, |
| 243 |
originalBinomial,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
|
| 243 | 244 |
originalFamily,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 244 | 245 |
originalGenus,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 245 | 246 |
originalScientificName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel/identifyingtaxonomicname, |
| ... | ... | |
| 271 | 272 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/verbatimrank, |
| 272 | 273 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/rank, |
| 273 | 274 |
originalSpecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/species, |
| 274 |
originalBinomial,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname, |
|
| 275 | 275 |
originalScientificName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicnamewithauthor, |
| 276 | 276 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/verbatimrank, |
| 277 | 277 |
originalIdentificationQualifier,//taxonoccurrence/taxondetermination[isoriginal=true]/taxonfit, |
| inputs/test_taxonomic_names/Taxon/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 3 | 3 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 4 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 4 | 5 |
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode, |
| 5 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| inputs/test_taxonomic_names/Taxon/test.xml.ref | ||
|---|---|---|
| 20 | 20 |
<identifyingtaxonomicname>$scientificName</identifyingtaxonomicname> |
| 21 | 21 |
</taxonlabel> |
| 22 | 22 |
</matched_label_id> |
| 23 |
<binomial>$scientificName</binomial> |
|
| 23 | 24 |
<sourceaccessioncode>$scientificNameID</sourceaccessioncode> |
| 24 |
<taxonomicname>$scientificName</taxonomicname> |
|
| 25 | 25 |
</taxonlabel> |
| 26 | 26 |
</taxonlabel_id> |
| 27 | 27 |
</taxondetermination> |
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
| 29 | 29 |
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 30 | 30 |
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 31 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 31 | 32 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 32 | 33 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 33 | 34 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 40 | 41 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet", |
| 41 | 42 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 42 | 43 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 43 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 44 | 44 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
| 45 | 45 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
| 46 | 46 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 33 | 33 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
| 34 | 34 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 35 | 35 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 36 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 36 | 37 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 37 | 38 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 38 | 39 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 45 | 46 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet", |
| 46 | 47 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 47 | 48 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 48 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 49 | 49 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
| 50 | 50 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
| 51 | 51 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 138 | 138 |
</taxonlabel> |
| 139 | 139 |
</matched_label_id> |
| 140 | 140 |
<author>$ScientificNameAuthor</author> |
| 141 |
<binomial>$ScientificName</binomial> |
|
| 141 | 142 |
<creator_id> |
| 142 | 143 |
<_simplifyPath> |
| 143 | 144 |
<next>creator_id</next> |
| ... | ... | |
| 214 | 215 |
</taxonlabel> |
| 215 | 216 |
</parent_id> |
| 216 | 217 |
<species>$Species</species> |
| 217 |
<taxonomicname>$ScientificName</taxonomicname> |
|
| 218 | 218 |
<creationdate> |
| 219 | 219 |
<_date> |
| 220 | 220 |
<day> |
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 37 | 37 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 38 | 38 |
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 39 | 39 |
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 40 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,"Contains less than ""Specie+autor""" |
|
| 40 | 41 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 41 | 42 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 42 | 43 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 44 | 45 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 45 | 46 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 46 | 47 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 47 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,"Contains less than ""Specie+autor""" |
|
| 48 | 48 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicnamewithauthor, |
| 49 | 49 |
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 50 | 50 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 97 | 97 |
</taxonlabel> |
| 98 | 98 |
</matched_label_id> |
| 99 | 99 |
<author>$Autor (revised)</author> |
| 100 |
<binomial>$Species and morphotypes</binomial> |
|
| 100 | 101 |
<creator_id> |
| 101 | 102 |
<_simplifyPath> |
| 102 | 103 |
<next>creator_id</next> |
| ... | ... | |
| 148 | 149 |
</taxonlabel> |
| 149 | 150 |
</parent_id> |
| 150 | 151 |
<species>$Specific epithet</species> |
| 151 |
<taxonomicname>$Species and morphotypes</taxonomicname> |
|
| 152 | 152 |
<taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor> |
| 153 | 153 |
</taxonlabel> |
| 154 | 154 |
</taxonlabel_id> |
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 52 | 52 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
| 53 | 53 |
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 54 | 54 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 55 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 55 | 56 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 56 | 57 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| 57 | 58 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1", |
| ... | ... | |
| 65 | 66 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/1, |
| 66 | 67 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/2, |
| 67 | 68 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 68 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 69 | 69 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank/_alt/1, |
| 70 | 70 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank/_alt/2, |
| 71 | 71 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 116 | 116 |
</taxonlabel> |
| 117 | 117 |
</matched_label_id> |
| 118 | 118 |
<author>$authors</author> |
| 119 |
<binomial>$SciName</binomial> |
|
| 119 | 120 |
<family>$family</family> |
| 120 | 121 |
<genus>$genus</genus> |
| 121 | 122 |
<parent_id> |
| ... | ... | |
| 180 | 181 |
</_alt> |
| 181 | 182 |
</rank> |
| 182 | 183 |
<species>$species</species> |
| 183 |
<taxonomicname>$SciName</taxonomicname> |
|
| 184 | 184 |
<verbatimrank> |
| 185 | 185 |
<_alt> |
| 186 | 186 |
<1>$usdaRank</1> |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 12 | 12 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 13 | 13 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 14 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
|
|
| 14 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
|
|
| 15 | 15 |
county,/location/locationplace/*_id/placepath/county, |
| 16 | 16 |
state,/location/locationplace/*_id/placepath/stateprovince, |
| 17 | 17 |
confidentialityStatus,,** No join mapping for *confidentialityStatus ** |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 42 | 42 |
<identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname> |
| 43 | 43 |
</taxonlabel> |
| 44 | 44 |
</matched_label_id> |
| 45 |
<taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
|
|
| 45 |
<binomial>$currentTaxonName sec Weakley 2006</binomial>
|
|
| 46 | 46 |
</taxonlabel> |
| 47 | 47 |
</taxonlabel_id> |
| 48 | 48 |
</taxondetermination> |
| inputs/.TNRS/tnrs/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
| 12 | 12 |
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Contains author based on matched name
|
| 13 | 13 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/author, |
| 14 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/binomial, |
|
| 14 | 15 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/family, |
| 15 | 16 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 16 | 17 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| ... | ... | |
| 21 | 22 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/rank, |
| 22 | 23 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/verbatimrank, |
| 23 | 24 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank, |
| 24 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname, |
|
| 25 | 25 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/verbatimrank, |
| 26 | 26 |
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,Contains author based on matched name |
| 27 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 27 | 28 |
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,Contains family based on matched name |
| 28 | 29 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| 29 | 30 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
| ... | ... | |
| 38 | 39 |
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode, |
| 39 | 40 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 40 | 41 |
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/author,Contains author in original string |
| 42 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/binomial, |
|
| 41 | 43 |
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/family,Contains family in original string (uncommon) |
| 42 | 44 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/genus, |
| 43 | 45 |
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/identifyingtaxonomicname, |
| ... | ... | |
| 48 | 50 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
| 49 | 51 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/then", |
| 50 | 52 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/species, |
| 51 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname, |
|
| 52 | 53 |
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/verbatimrank, |
| 53 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 54 | 54 |
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonstatus, |
| 55 | 55 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
| 56 | 56 |
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid ** |
| inputs/.TNRS/tnrs/test.xml.ref | ||
|---|---|---|
| 41 | 41 |
<matched_label_id> |
| 42 | 42 |
<taxonlabel> |
| 43 | 43 |
<author>$Accepted_name_author</author> |
| 44 |
<binomial>$Accepted_name</binomial> |
|
| 44 | 45 |
<family>$Accepted_name_family</family> |
| 45 | 46 |
<identifyingtaxonomicname> |
| 46 | 47 |
<_join_words> |
| ... | ... | |
| 108 | 109 |
</taxonlabel> |
| 109 | 110 |
</parent_id> |
| 110 | 111 |
<rank>$Accepted_name_rank</rank> |
| 111 |
<taxonomicname>$Accepted_name</taxonomicname> |
|
| 112 | 112 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
| 113 | 113 |
</taxonlabel> |
| 114 | 114 |
</matched_label_id> |
| 115 | 115 |
</_taxonlabel_set_matched_label_id> |
| 116 | 116 |
<author>$Name_matched_author</author> |
| 117 |
<binomial>$Name_matched</binomial> |
|
| 117 | 118 |
<family>$Name_matched_accepted_family</family> |
| 118 | 119 |
<genus>$Genus_matched</genus> |
| 119 | 120 |
<parent_id> |
| ... | ... | |
| 166 | 167 |
<species>$Specific_epithet_matched</species> |
| 167 | 168 |
<taxonlabel fkey="matched_label_id"> |
| 168 | 169 |
<author>$Author_matched</author> |
| 170 |
<binomial>$Name_matched</binomial> |
|
| 169 | 171 |
<family>$Family_matched</family> |
| 170 | 172 |
<genus>$Genus_matched</genus> |
| 171 | 173 |
<identifyingtaxonomicname>$Name_submitted</identifyingtaxonomicname> |
| ... | ... | |
| 179 | 181 |
</matched_label_fit_fraction> |
| 180 | 182 |
<morphospecies>$Unmatched_terms</morphospecies> |
| 181 | 183 |
<species>$Specific_epithet_matched</species> |
| 182 |
<taxonomicname>$Name_matched</taxonomicname> |
|
| 183 | 184 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
| 184 | 185 |
</taxonlabel> |
| 185 |
<taxonomicname>$Name_matched</taxonomicname> |
|
| 186 | 186 |
<taxonstatus>$Taxonomic_status</taxonstatus> |
| 187 | 187 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
| 188 | 188 |
</taxonlabel> |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 37 | 37 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 38 | 38 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
| 39 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 39 | 40 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 40 | 41 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 41 | 42 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 48 | 49 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet", |
| 49 | 50 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 50 | 51 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 51 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 52 | 52 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicnamewithauthor,Contains the binomial in addition to the authority |
| 53 | 53 |
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes, |
| 54 | 54 |
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| inputs/ARIZ/Specimen/test.xml.ref | ||
|---|---|---|
| 137 | 137 |
</identifyingtaxonomicname> |
| 138 | 138 |
</taxonlabel> |
| 139 | 139 |
</matched_label_id> |
| 140 |
<binomial>$ScientificName</binomial> |
|
| 140 | 141 |
<creator_id> |
| 141 | 142 |
<_simplifyPath> |
| 142 | 143 |
<next>creator_id</next> |
| ... | ... | |
| 213 | 214 |
</taxonlabel> |
| 214 | 215 |
</parent_id> |
| 215 | 216 |
<species>$Species</species> |
| 216 |
<taxonomicname>$ScientificName</taxonomicname> |
|
| 217 | 217 |
<taxonomicnamewithauthor>$ScientificNameAuthor</taxonomicnamewithauthor> |
| 218 | 218 |
<creationdate> |
| 219 | 219 |
<_date> |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
| 23 | 23 |
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 24 | 24 |
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 25 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 25 | 26 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 26 | 27 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 27 | 28 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 30 | 31 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 31 | 32 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 32 | 33 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 33 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
|
|
| 34 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial,
|
|
| 34 | 35 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 35 | 36 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 36 | 37 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| ... | ... | |
| 38 | 39 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 39 | 40 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 40 | 41 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 41 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname, |
|
| 42 | 42 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 43 | 43 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 44 | 44 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 78 | 78 |
</taxonlabel> |
| 79 | 79 |
</matched_label_id> |
| 80 | 80 |
<author>$AuthorOfScientificName</author> |
| 81 |
<binomial>$ScientificName</binomial> |
|
| 81 | 82 |
<creator_id> |
| 82 | 83 |
<_simplifyPath> |
| 83 | 84 |
<next>creator_id</next> |
| ... | ... | |
| 130 | 131 |
</taxonlabel> |
| 131 | 132 |
</parent_id> |
| 132 | 133 |
<species>$SpecificEpithet</species> |
| 133 |
<taxonomicname>$ScientificName</taxonomicname> |
|
| 134 | 134 |
</taxonlabel> |
| 135 | 135 |
</taxonlabel_id> |
| 136 | 136 |
</taxondetermination> |
| ... | ... | |
| 138 | 138 |
<isoriginal>true</isoriginal> |
| 139 | 139 |
<taxonlabel_id> |
| 140 | 140 |
<taxonlabel> |
| 141 |
<binomial>$ScientificNameOriginal</binomial> |
|
| 141 | 142 |
<family>$GBIFFamilyOriginal</family> |
| 142 | 143 |
<genus>$GBIFGenusOriginal</genus> |
| 143 | 144 |
<matched_label_id> |
| ... | ... | |
| 202 | 203 |
</parent_id> |
| 203 | 204 |
</taxonlabel> |
| 204 | 205 |
</parent_id> |
| 205 |
<taxonomicname>$ScientificNameOriginal</taxonomicname> |
|
| 206 | 206 |
</taxonlabel> |
| 207 | 207 |
</taxonlabel_id> |
| 208 | 208 |
</taxondetermination> |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
| 16 | 16 |
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 17 | 17 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 18 |
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,
|
|
| 18 |
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,
|
|
| 19 | 19 |
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 20 | 20 |
Country,/location/locationplace/*_id/placepath/country, |
| 21 | 21 |
County,/location/locationplace/*_id/placepath/county, |
| inputs/NCU-NCSC/Specimen/test.xml.ref | ||
|---|---|---|
| 77 | 77 |
<identifyingtaxonomicname>$Full Taxon Name</identifyingtaxonomicname> |
| 78 | 78 |
</taxonlabel> |
| 79 | 79 |
</matched_label_id> |
| 80 |
<taxonomicname>$Full Taxon Name</taxonomicname>
|
|
| 80 |
<binomial>$Full Taxon Name</binomial>
|
|
| 81 | 81 |
</taxonlabel> |
| 82 | 82 |
</taxonlabel_id> |
| 83 | 83 |
</taxondetermination> |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 119 | 119 |
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/1, |
| 120 | 120 |
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/2, |
| 121 | 121 |
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/3, |
| 122 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 123 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 124 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 122 | 125 |
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 123 | 126 |
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 124 | 127 |
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| ... | ... | |
| 155 | 158 |
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 156 | 159 |
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 157 | 160 |
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 158 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 159 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 160 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 161 | 161 |
dwc_dwcore_Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes, |
| 162 | 162 |
dwc_terms_dateIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
| 163 | 163 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 299 | 299 |
<3>$dwc_dwcore_AuthorYearOfScientificName</3> |
| 300 | 300 |
</_alt> |
| 301 | 301 |
</author> |
| 302 |
<binomial> |
|
| 303 |
<_alt> |
|
| 304 |
<0>$conceptual_darwin_2003_1_0_ScientificName</0> |
|
| 305 |
<1>$dwc_dwcore_ScientificName</1> |
|
| 306 |
<2>$dwc_terms_scientificName</2> |
|
| 307 |
</_alt> |
|
| 308 |
</binomial> |
|
| 302 | 309 |
<creator_id> |
| 303 | 310 |
<_simplifyPath> |
| 304 | 311 |
<next>creator_id</next> |
| ... | ... | |
| 451 | 458 |
<2>$dwc_terms_specificEpithet</2> |
| 452 | 459 |
</_alt> |
| 453 | 460 |
</species> |
| 454 |
<taxonomicname> |
|
| 455 |
<_alt> |
|
| 456 |
<0>$conceptual_darwin_2003_1_0_ScientificName</0> |
|
| 457 |
<1>$dwc_dwcore_ScientificName</1> |
|
| 458 |
<2>$dwc_terms_scientificName</2> |
|
| 459 |
</_alt> |
|
| 460 |
</taxonomicname> |
|
| 461 | 461 |
<creationdate> |
| 462 | 462 |
<_alt> |
| 463 | 463 |
<1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1> |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 27 | 27 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
| 28 | 28 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 29 | 29 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 30 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 30 | 31 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 31 | 32 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| 32 | 33 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
| ... | ... | |
| 36 | 37 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 37 | 38 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 38 | 39 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 39 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 40 | 40 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 41 | 41 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 42 | 42 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/MO/Specimen/test.xml.ref | ||
|---|---|---|
| 110 | 110 |
</taxonlabel> |
| 111 | 111 |
</matched_label_id> |
| 112 | 112 |
<author>$ScientificNameAuthor</author> |
| 113 |
<binomial>$ScientificName</binomial> |
|
| 113 | 114 |
<creator_id> |
| 114 | 115 |
<_simplifyPath> |
| 115 | 116 |
<next>creator_id</next> |
| ... | ... | |
| 183 | 184 |
</taxonlabel> |
| 184 | 185 |
</parent_id> |
| 185 | 186 |
<species>$species</species> |
| 186 |
<taxonomicname>$ScientificName</taxonomicname> |
|
| 187 | 187 |
</taxonlabel> |
| 188 | 188 |
</taxonlabel_id> |
| 189 | 189 |
</taxondetermination> |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 30 | 30 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 31 | 31 |
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 32 | 32 |
interpretationdate,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
| 33 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
|
| 33 | 34 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 34 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname, |
|
| 35 | 35 |
museumaccessionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 36 | 36 |
Division,,** No join mapping for *Division ** |
| 37 | 37 |
Subclass,,** No join mapping for *Subclass ** |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 129 | 129 |
<isoriginal>true</isoriginal> |
| 130 | 130 |
<taxonlabel_id> |
| 131 | 131 |
<taxonlabel> |
| 132 |
<binomial>$authorplantname</binomial> |
|
| 132 | 133 |
<matched_label_id> |
| 133 | 134 |
<taxonlabel> |
| 134 | 135 |
<creator_id> |
| ... | ... | |
| 140 | 141 |
<identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname> |
| 141 | 142 |
</taxonlabel> |
| 142 | 143 |
</matched_label_id> |
| 143 |
<taxonomicname>$authorplantname</taxonomicname> |
|
| 144 | 144 |
</taxonlabel> |
| 145 | 145 |
</taxonlabel_id> |
| 146 | 146 |
</taxondetermination> |
| inputs/QMOR/Specimen/test.xml.ref | ||
|---|---|---|
| 132 | 132 |
</taxonlabel> |
| 133 | 133 |
</matched_label_id> |
| 134 | 134 |
<author>$scientificNameAuthorship</author> |
| 135 |
<binomial>$scientificName</binomial> |
|
| 135 | 136 |
<creator_id> |
| 136 | 137 |
<_simplifyPath> |
| 137 | 138 |
<next>creator_id</next> |
| ... | ... | |
| 211 | 212 |
</parent_id> |
| 212 | 213 |
<rank>$taxonRank</rank> |
| 213 | 214 |
<species>$specificEpithet</species> |
| 214 |
<taxonomicname>$scientificName</taxonomicname> |
|
| 215 | 215 |
<verbatimrank>$taxonRank</verbatimrank> |
| 216 | 216 |
<creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate> |
| 217 | 217 |
</taxonlabel> |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 149 | 149 |
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/9/_join_words:[1=""cult. ""]/2",
|
| 150 | 150 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
| 151 | 151 |
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/author, |
| 152 |
acceptedBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/binomial, |
|
| 152 | 153 |
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/family, |
| 153 | 154 |
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/genus, |
| 154 | 155 |
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/identifyingtaxonomicname/_alt/1, |
| ... | ... | |
| 181 | 182 |
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/verbatimrank, |
| 182 | 183 |
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank, |
| 183 | 184 |
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/species, |
| 184 |
acceptedBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonomicname, |
|
| 185 | 185 |
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/verbatimrank, |
| 186 | 186 |
parentScientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 187 | 187 |
parentTaxonConceptID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 188 | 188 |
parentTaxonID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_parent_id/parent_id/taxonlabel/sourceaccessioncode, |
| 189 | 189 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
| 190 |
binomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 190 | 191 |
accordingTo,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/1, |
| 191 | 192 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 192 | 193 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
| ... | ... | |
| 217 | 218 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
| 218 | 219 |
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonepithet, |
| 219 | 220 |
verbatimScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/author, |
| 221 |
verbatimBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/binomial, |
|
| 220 | 222 |
verbatimFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/family, |
| 221 | 223 |
verbatimGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/genus, |
| 222 | 224 |
verbatimScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/identifyingtaxonomicname, |
| ... | ... | |
| 227 | 229 |
verbatimScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
| 228 | 230 |
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/then", |
| 229 | 231 |
verbatimSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/species, |
| 230 |
verbatimBinomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonomicname, |
|
| 231 | 232 |
verbatimTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/verbatimrank, |
| 232 |
binomial,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 233 | 233 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicnamewithauthor, |
| 234 | 234 |
taxonomicStatus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonstatus, |
| 235 | 235 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
| ... | ... | |
| 240 | 240 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
|
| 241 | 241 |
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonlabel/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
| 242 | 242 |
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/author, |
| 243 |
originalBinomial,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
|
| 243 | 244 |
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 244 | 245 |
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 245 | 246 |
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/1, |
| ... | ... | |
| 271 | 272 |
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/verbatimrank, |
| 272 | 273 |
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/rank, |
| 273 | 274 |
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/species, |
| 274 |
originalBinomial,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicname, |
|
| 275 | 275 |
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonomicnamewithauthor, |
| 276 | 276 |
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/verbatimrank, |
| 277 | 277 |
originalIdentificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/taxonfit, |
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Renamed taxonomicname to binomial because it excludes the author