Revision 11228
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/taxon_observation.**.sample/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 2 |
FROM "taxon_observation.**" |
|
| 3 |
WHERE "locationID" IN (/*Heritage*/27581, /*CVS*/80476, /*NPS*/25572, /*GAP*/46073, /*Jennings*/11862, /*soil*/27234) |
|
| 4 |
-- see wiki.vegpath.org/Spot-checking#VegBank |
|
| 5 |
; -- runtime: 20 s ("Time: 20279.441 ms") @starscream
|
|
| inputs/VegBank/taxon_observation.**.sample/header.csv | ||
|---|---|---|
| 1 |
sort_col,locationID,eventID,*stratumtype_id,*stratum_id,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,taxonOccurrenceID__overall_plot,*taxonobservation_--plantname_id,*taxonobservation_--plantconcept_id,identificationID,*taxonobservation_--stemlocation_id,*taxonobservation_--taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_party_id,*taxonobservation_--role_id,identificationType,*taxonobservation_--reference_id,*taxonobservation_--originalinterpretation,*taxonobservation_--currentinterpretation,identificationQualifier,identificationVerificationStatus,UNUSED#collector_id,collectorNumber,*taxonobservation_--museum_id,accessionNumber,*taxonobservation_--grouptype,occurrenceRemarks,*taxonobservation_--notespublic,*taxonobservation_--notesmgt,*taxonobservation_--revisions,dateIdentified,dateCollected,*taxonobservation_--emb_taxoninterpretation,*taxonobservation_--taxoninterpretation_accessioncode,originalScientificName,*taxonobservation_--taxonobservation_reference_id,*taxonobservation_--taxoninferencearea,*taxonobservation_--emb_taxonobservation,*taxonobservation_--int_origplantconcept_id,EQUIV#to:authorplantname#int_origplantscifull,originalTaxonName,originalVernacularName,*taxonobservation_--int_origplantcode,*taxonobservation_--int_currplantconcept_id,scientificName_verbatim,taxonName,vernacularName,*taxonobservation_--int_currplantcode,*taxonobservation_--taxonobservation_accessioncode,*plantconcept_--plantconcept_reference_id,scientificName__for_nearest_taxon_concept,*plantconcept_--plantcode,*plantconcept_--plantdescription,*plantconcept_--d_obscount,*plantconcept_--d_currentaccepted,*plantconcept_--plantconcept_accessioncode,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,EQUIV#to:plantname#Species,EQUIV#to:plantname#Subspecies,EQUIV#to:plantname#Variety,EQUIV#to:plantname#Forma,DUPLICATE#of:plantconcept_plantname#plantname,*taxonobservation_--plantname_reference_id,*taxonobservation_--dateentered,observationGranularity,scientificName,coverPercent,*stemcount_--basalarea,*stemcount_--biomass,*stemcount_--inferencearea,*stemcount_--stratumbase,*stemcount_--stratumheight,*stemcount_--emb_taxonimportance,*stemcount_--covercode,diameterBreastHeight_cm,*stemcount_--stemdiameteraccuracy,height_m,*stemcount_--stemheightaccuracy,individualCount,*stemcount_--stemtaxonarea,*stemcount_--emb_stemcount,stemID,UNUSED#stemcode,UNUSED#stemxposition,UNUSED#stemyposition,*stemlocation_--stemhealth,*stemlocation_--emb_stemlocation,OMIT#stemdiameter,OMIT#stemdiameteraccuracy,OMIT#stemheight,OMIT#stemheightaccuracy,OMIT#stemcount,OMIT#stemtaxonarea,OMIT#emb_stemcount,individualID,*stratum--observation_id,*stratum--stratummethod_id,*stratum--stratumname,*stratum--stratumheight,*stratum--stratumbase,*stratum--stratumcover,*stratum--stratumdescription,*stratumtype--stratummethod_id,*stratumtype--stratumindex,stratum__name,*stratumtype--stratumdescription,*observation_--previousobs_id,projectID,authorEventCode,*observation_--dateaccuracy,*observation_--covermethod_id,*observation_--coverdispersion,*observation_--autotaxoncover,*observation_--stratummethod_id,samplingProtocol,*observation_--taxonobservationarea,*observation_--stemsizelimit,*observation_--stemobservationarea,*observation_--stemsamplemethod,*observation_--originaldata,*observation_--effortlevel,*observation_--plotvalidationlevel,*observation_--floristicquality,*observation_--bryophytequality,*observation_--lichenquality,*observation_--observationnarrative,*observation_--landscapenarrative,*observation_--homogeneity,*observation_--phenologicaspect,*observation_--representativeness,*observation_--standmaturity,*observation_--successionalstatus,*observation_--basalarea,*observation_--hydrologicregime,*observation_--soilmoistureregime,*observation_--soildrainage,*observation_--watersalinity,*observation_--waterdepth,*observation_--shoredistance,*observation_--soildepth,*observation_--organicdepth,*observation_--soiltaxon_id,*observation_--soiltaxonsrc,*observation_--percentbedrock,*observation_--percentrockgravel,*observation_--percentwood,*observation_--percentlitter,*observation_--percentbaresoil,*observation_--percentwater,*observation_--percentother,*observation_--nameother,*observation_--treeht,*observation_--shrubht,*observation_--fieldht,*observation_--nonvascularht,*observation_--submergedht,*observation_--treecover,*observation_--shrubcover,*observation_--fieldcover,*observation_--nonvascularcover,*observation_--floatingcover,*observation_--submergedcover,*observation_--dominantstratum,*observation_--growthform1type,*observation_--growthform2type,*observation_--growthform3type,*observation_--growthform1cover,*observation_--growthform2cover,*observation_--growthform3cover,*observation_--totalcover,*observation_--notespublic,*observation_--notesmgt,*observation_--revisions,startDate,endDate,*observation_--dateentered,*observation_--emb_observation,*observation_--interp_orig_ci_id,*observation_--interp_orig_cc_id,*observation_--interp_orig_sciname,*observation_--interp_orig_code,*observation_--interp_orig_party_id,*observation_--interp_orig_partyname,*observation_--interp_current_ci_id,*observation_--interp_current_cc_id,*observation_--interp_current_sciname,*observation_--interp_current_code,*observation_--interp_current_party_id,*observation_--interp_current_partyname,*observation_--interp_bestfit_ci_id,*observation_--interp_bestfit_cc_id,*observation_--interp_bestfit_sciname,*observation_--interp_bestfit_code,*observation_--interp_bestfit_party_id,*observation_--interp_bestfit_partyname,*observation_--toptaxon1name,*observation_--toptaxon2name,*observation_--toptaxon3name,*observation_--toptaxon4name,*observation_--toptaxon5name,*observation_--numberoftaxa,*observation_--accessioncode,*observation_--soilobs_id,*observation_--soilhorizon,*observation_--soildepthtop,*observation_--soildepthbottom,*observation_--soilcolor,organic_percent,texture,sand_percent,silt_percent,clay_percent,*observation_--soilcoarse,ph,cationExchangeCapacity_cmol_kg,baseSaturation_percent,*observation_--soildescription,*observation_--emb_soilobs,emb_soilobs,locationName,*plot_--reference_id,parentLocationID,coordinateUncertaintyInMeters__from_coords,accessRights_verbatim,*plot_--confidentialityreason,decimalLatitude,decimalLongitude,*plot_--authore,*plot_--authorn,*plot_--authorzone,*plot_--authordatum,*plot_--authorlocation,locality,*plot_--azimuth,*plot_--dsgpoly,footprintWKT,plotArea_m2,*plot_--standsize,*plot_--placementmethod,*plot_--permanence,*plot_--layoutnarrative,elevationInMeters,*plot_--elevationaccuracy,UNUSED#elevationrange,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,*plot_--topoposition,landform,*plot_--surficialdeposits,*plot_--rocktype,stateProvince,country,*plot_--submitter_surname,*plot_--submitter_givenname,*plot_--submitter_email,*plot_--notespublic,*plot_--notesmgt,*plot_--revisions,*plot_--dateentered,*plot_--emb_plot,*plot_--plotrationalenarrative,*plot_--accessioncode,continent,DUPLICATE#of:country#area|country|territory,DUPLICATE#of:stateprovince#region|state|province,county,*plot_--quadrangle,*plot_--Geographic Name,accessRights,coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters,taxonOccurrenceID |
|
| inputs/VegBank/taxon_observation.**.sample/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
|
|
| 0 | 3 | |
| inputs/VegBank/taxon_observation.**.sample/map.csv | ||
|---|---|---|
| 1 |
VegBank,VegCore,Filter,Comments |
|
| 2 |
sort_col,sort_col,, |
|
| 3 |
locationID,locationID,, |
|
| 4 |
eventID,eventID,, |
|
| 5 |
*stratumtype_id,*stratumtype_id,, |
|
| 6 |
*stratum_id,*stratum_id,, |
|
| 7 |
aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__taxon_presence,, |
|
| 8 |
aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID__individual_count,, |
|
| 9 |
aggregateOrganismObservationID,aggregateOrganismObservationID,, |
|
| 10 |
taxonOccurrenceID__overall_plot,taxonOccurrenceID__overall_plot,, |
|
| 11 |
*taxonobservation_--plantname_id,*taxonobservation_--plantname_id,, |
|
| 12 |
*taxonobservation_--plantconcept_id,*taxonobservation_--plantconcept_id,, |
|
| 13 |
identificationID,identificationID,, |
|
| 14 |
*taxonobservation_--stemlocation_id,*taxonobservation_--stemlocation_id,, |
|
| 15 |
*taxonobservation_--taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,, |
|
| 16 |
*taxonobservation_--taxoninterpretation_party_id,*taxonobservation_--taxoninterpretation_party_id,, |
|
| 17 |
*taxonobservation_--role_id,*taxonobservation_--role_id,, |
|
| 18 |
identificationType,identificationType,, |
|
| 19 |
*taxonobservation_--reference_id,*taxonobservation_--reference_id,, |
|
| 20 |
*taxonobservation_--originalinterpretation,*taxonobservation_--originalinterpretation,, |
|
| 21 |
*taxonobservation_--currentinterpretation,*taxonobservation_--currentinterpretation,, |
|
| 22 |
identificationQualifier,identificationQualifier,, |
|
| 23 |
identificationVerificationStatus,identificationVerificationStatus,, |
|
| 24 |
UNUSED#collector_id,UNUSED#collector_id,, |
|
| 25 |
collectorNumber,collectorNumber,, |
|
| 26 |
*taxonobservation_--museum_id,*taxonobservation_--museum_id,, |
|
| 27 |
accessionNumber,accessionNumber,, |
|
| 28 |
*taxonobservation_--grouptype,*taxonobservation_--grouptype,, |
|
| 29 |
occurrenceRemarks,occurrenceRemarks,, |
|
| 30 |
*taxonobservation_--notespublic,*taxonobservation_--notespublic,, |
|
| 31 |
*taxonobservation_--notesmgt,*taxonobservation_--notesmgt,, |
|
| 32 |
*taxonobservation_--revisions,*taxonobservation_--revisions,, |
|
| 33 |
dateIdentified,dateIdentified,, |
|
| 34 |
dateCollected,dateCollected,, |
|
| 35 |
*taxonobservation_--emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,, |
|
| 36 |
*taxonobservation_--taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,, |
|
| 37 |
originalScientificName,originalScientificName,, |
|
| 38 |
*taxonobservation_--taxonobservation_reference_id,*taxonobservation_--taxonobservation_reference_id,, |
|
| 39 |
*taxonobservation_--taxoninferencearea,*taxonobservation_--taxoninferencearea,, |
|
| 40 |
*taxonobservation_--emb_taxonobservation,*taxonobservation_--emb_taxonobservation,, |
|
| 41 |
*taxonobservation_--int_origplantconcept_id,*taxonobservation_--int_origplantconcept_id,, |
|
| 42 |
EQUIV#to:authorplantname#int_origplantscifull,EQUIV#to:authorplantname#int_origplantscifull,, |
|
| 43 |
originalTaxonName,originalTaxonName,, |
|
| 44 |
originalVernacularName,originalVernacularName,, |
|
| 45 |
*taxonobservation_--int_origplantcode,*taxonobservation_--int_origplantcode,, |
|
| 46 |
*taxonobservation_--int_currplantconcept_id,*taxonobservation_--int_currplantconcept_id,, |
|
| 47 |
scientificName_verbatim,scientificName_verbatim,, |
|
| 48 |
taxonName,taxonName,, |
|
| 49 |
vernacularName,vernacularName,, |
|
| 50 |
*taxonobservation_--int_currplantcode,*taxonobservation_--int_currplantcode,, |
|
| 51 |
*taxonobservation_--taxonobservation_accessioncode,*taxonobservation_--taxonobservation_accessioncode,, |
|
| 52 |
*plantconcept_--plantconcept_reference_id,*plantconcept_--plantconcept_reference_id,, |
|
| 53 |
scientificName__for_nearest_taxon_concept,scientificName__for_nearest_taxon_concept,, |
|
| 54 |
*plantconcept_--plantcode,*plantconcept_--plantcode,, |
|
| 55 |
*plantconcept_--plantdescription,*plantconcept_--plantdescription,, |
|
| 56 |
*plantconcept_--d_obscount,*plantconcept_--d_obscount,, |
|
| 57 |
*plantconcept_--d_currentaccepted,*plantconcept_--d_currentaccepted,, |
|
| 58 |
*plantconcept_--plantconcept_accessioncode,*plantconcept_--plantconcept_accessioncode,, |
|
| 59 |
kingdom,kingdom,, |
|
| 60 |
*Subkingdom,*Subkingdom,, |
|
| 61 |
*Superdivision,*Superdivision,, |
|
| 62 |
*Division,*Division,, |
|
| 63 |
*Subdivision,*Subdivision,, |
|
| 64 |
class,class,, |
|
| 65 |
*Subclass,*Subclass,, |
|
| 66 |
order,order,, |
|
| 67 |
family,family,, |
|
| 68 |
genus,genus,, |
|
| 69 |
EQUIV#to:plantname#Species,EQUIV#to:plantname#Species,, |
|
| 70 |
EQUIV#to:plantname#Subspecies,EQUIV#to:plantname#Subspecies,, |
|
| 71 |
EQUIV#to:plantname#Variety,EQUIV#to:plantname#Variety,, |
|
| 72 |
EQUIV#to:plantname#Forma,EQUIV#to:plantname#Forma,, |
|
| 73 |
DUPLICATE#of:plantconcept_plantname#plantname,DUPLICATE#of:plantconcept_plantname#plantname,, |
|
| 74 |
*taxonobservation_--plantname_reference_id,*taxonobservation_--plantname_reference_id,, |
|
| 75 |
*taxonobservation_--dateentered,*taxonobservation_--dateentered,, |
|
| 76 |
observationGranularity,observationGranularity,, |
|
| 77 |
scientificName,scientificName,, |
|
| 78 |
coverPercent,coverPercent,, |
|
| 79 |
*stemcount_--basalarea,*stemcount_--basalarea,, |
|
| 80 |
*stemcount_--biomass,*stemcount_--biomass,, |
|
| 81 |
*stemcount_--inferencearea,*stemcount_--inferencearea,, |
|
| 82 |
*stemcount_--stratumbase,*stemcount_--stratumbase,, |
|
| 83 |
*stemcount_--stratumheight,*stemcount_--stratumheight,, |
|
| 84 |
*stemcount_--emb_taxonimportance,*stemcount_--emb_taxonimportance,, |
|
| 85 |
*stemcount_--covercode,*stemcount_--covercode,, |
|
| 86 |
diameterBreastHeight_cm,diameterBreastHeight_cm,, |
|
| 87 |
*stemcount_--stemdiameteraccuracy,*stemcount_--stemdiameteraccuracy,, |
|
| 88 |
height_m,height_m,, |
|
| 89 |
*stemcount_--stemheightaccuracy,*stemcount_--stemheightaccuracy,, |
|
| 90 |
individualCount,individualCount,, |
|
| 91 |
*stemcount_--stemtaxonarea,*stemcount_--stemtaxonarea,, |
|
| 92 |
*stemcount_--emb_stemcount,*stemcount_--emb_stemcount,, |
|
| 93 |
stemID,stemID,, |
|
| 94 |
UNUSED#stemcode,UNUSED#stemcode,, |
|
| 95 |
UNUSED#stemxposition,UNUSED#stemxposition,, |
|
| 96 |
UNUSED#stemyposition,UNUSED#stemyposition,, |
|
| 97 |
*stemlocation_--stemhealth,*stemlocation_--stemhealth,, |
|
| 98 |
*stemlocation_--emb_stemlocation,*stemlocation_--emb_stemlocation,, |
|
| 99 |
OMIT#stemdiameter,OMIT#stemdiameter,, |
|
| 100 |
OMIT#stemdiameteraccuracy,OMIT#stemdiameteraccuracy,, |
|
| 101 |
OMIT#stemheight,OMIT#stemheight,, |
|
| 102 |
OMIT#stemheightaccuracy,OMIT#stemheightaccuracy,, |
|
| 103 |
OMIT#stemcount,OMIT#stemcount,, |
|
| 104 |
OMIT#stemtaxonarea,OMIT#stemtaxonarea,, |
|
| 105 |
OMIT#emb_stemcount,OMIT#emb_stemcount,, |
|
| 106 |
individualID,individualID,, |
|
| 107 |
*stratum--observation_id,*stratum--observation_id,, |
|
| 108 |
*stratum--stratummethod_id,*stratum--stratummethod_id,, |
|
| 109 |
*stratum--stratumname,*stratum--stratumname,, |
|
| 110 |
*stratum--stratumheight,*stratum--stratumheight,, |
|
| 111 |
*stratum--stratumbase,*stratum--stratumbase,, |
|
| 112 |
*stratum--stratumcover,*stratum--stratumcover,, |
|
| 113 |
*stratum--stratumdescription,*stratum--stratumdescription,, |
|
| 114 |
*stratumtype--stratummethod_id,*stratumtype--stratummethod_id,, |
|
| 115 |
*stratumtype--stratumindex,*stratumtype--stratumindex,, |
|
| 116 |
stratum__name,stratum__name,, |
|
| 117 |
*stratumtype--stratumdescription,*stratumtype--stratumdescription,, |
|
| 118 |
*observation_--previousobs_id,*observation_--previousobs_id,, |
|
| 119 |
projectID,projectID,, |
|
| 120 |
authorEventCode,authorEventCode,, |
|
| 121 |
*observation_--dateaccuracy,*observation_--dateaccuracy,, |
|
| 122 |
*observation_--covermethod_id,*observation_--covermethod_id,, |
|
| 123 |
*observation_--coverdispersion,*observation_--coverdispersion,, |
|
| 124 |
*observation_--autotaxoncover,*observation_--autotaxoncover,, |
|
| 125 |
*observation_--stratummethod_id,*observation_--stratummethod_id,, |
|
| 126 |
samplingProtocol,samplingProtocol,, |
|
| 127 |
*observation_--taxonobservationarea,*observation_--taxonobservationarea,, |
|
| 128 |
*observation_--stemsizelimit,*observation_--stemsizelimit,, |
|
| 129 |
*observation_--stemobservationarea,*observation_--stemobservationarea,, |
|
| 130 |
*observation_--stemsamplemethod,*observation_--stemsamplemethod,, |
|
| 131 |
*observation_--originaldata,*observation_--originaldata,, |
|
| 132 |
*observation_--effortlevel,*observation_--effortlevel,, |
|
| 133 |
*observation_--plotvalidationlevel,*observation_--plotvalidationlevel,, |
|
| 134 |
*observation_--floristicquality,*observation_--floristicquality,, |
|
| 135 |
*observation_--bryophytequality,*observation_--bryophytequality,, |
|
| 136 |
*observation_--lichenquality,*observation_--lichenquality,, |
|
| 137 |
*observation_--observationnarrative,*observation_--observationnarrative,, |
|
| 138 |
*observation_--landscapenarrative,*observation_--landscapenarrative,, |
|
| 139 |
*observation_--homogeneity,*observation_--homogeneity,, |
|
| 140 |
*observation_--phenologicaspect,*observation_--phenologicaspect,, |
|
| 141 |
*observation_--representativeness,*observation_--representativeness,, |
|
| 142 |
*observation_--standmaturity,*observation_--standmaturity,, |
|
| 143 |
*observation_--successionalstatus,*observation_--successionalstatus,, |
|
| 144 |
*observation_--basalarea,*observation_--basalarea,, |
|
| 145 |
*observation_--hydrologicregime,*observation_--hydrologicregime,, |
|
| 146 |
*observation_--soilmoistureregime,*observation_--soilmoistureregime,, |
|
| 147 |
*observation_--soildrainage,*observation_--soildrainage,, |
|
| 148 |
*observation_--watersalinity,*observation_--watersalinity,, |
|
| 149 |
*observation_--waterdepth,*observation_--waterdepth,, |
|
| 150 |
*observation_--shoredistance,*observation_--shoredistance,, |
|
| 151 |
*observation_--soildepth,*observation_--soildepth,, |
|
| 152 |
*observation_--organicdepth,*observation_--organicdepth,, |
|
| 153 |
*observation_--soiltaxon_id,*observation_--soiltaxon_id,, |
|
| 154 |
*observation_--soiltaxonsrc,*observation_--soiltaxonsrc,, |
|
| 155 |
*observation_--percentbedrock,*observation_--percentbedrock,, |
|
| 156 |
*observation_--percentrockgravel,*observation_--percentrockgravel,, |
|
| 157 |
*observation_--percentwood,*observation_--percentwood,, |
|
| 158 |
*observation_--percentlitter,*observation_--percentlitter,, |
|
| 159 |
*observation_--percentbaresoil,*observation_--percentbaresoil,, |
|
| 160 |
*observation_--percentwater,*observation_--percentwater,, |
|
| 161 |
*observation_--percentother,*observation_--percentother,, |
|
| 162 |
*observation_--nameother,*observation_--nameother,, |
|
| 163 |
*observation_--treeht,*observation_--treeht,, |
|
| 164 |
*observation_--shrubht,*observation_--shrubht,, |
|
| 165 |
*observation_--fieldht,*observation_--fieldht,, |
|
| 166 |
*observation_--nonvascularht,*observation_--nonvascularht,, |
|
| 167 |
*observation_--submergedht,*observation_--submergedht,, |
|
| 168 |
*observation_--treecover,*observation_--treecover,, |
|
| 169 |
*observation_--shrubcover,*observation_--shrubcover,, |
|
| 170 |
*observation_--fieldcover,*observation_--fieldcover,, |
|
| 171 |
*observation_--nonvascularcover,*observation_--nonvascularcover,, |
|
| 172 |
*observation_--floatingcover,*observation_--floatingcover,, |
|
| 173 |
*observation_--submergedcover,*observation_--submergedcover,, |
|
| 174 |
*observation_--dominantstratum,*observation_--dominantstratum,, |
|
| 175 |
*observation_--growthform1type,*observation_--growthform1type,, |
|
| 176 |
*observation_--growthform2type,*observation_--growthform2type,, |
|
| 177 |
*observation_--growthform3type,*observation_--growthform3type,, |
|
| 178 |
*observation_--growthform1cover,*observation_--growthform1cover,, |
|
| 179 |
*observation_--growthform2cover,*observation_--growthform2cover,, |
|
| 180 |
*observation_--growthform3cover,*observation_--growthform3cover,, |
|
| 181 |
*observation_--totalcover,*observation_--totalcover,, |
|
| 182 |
*observation_--notespublic,*observation_--notespublic,, |
|
| 183 |
*observation_--notesmgt,*observation_--notesmgt,, |
|
| 184 |
*observation_--revisions,*observation_--revisions,, |
|
| 185 |
startDate,startDate,, |
|
| 186 |
endDate,endDate,, |
|
| 187 |
*observation_--dateentered,*observation_--dateentered,, |
|
| 188 |
*observation_--emb_observation,*observation_--emb_observation,, |
|
| 189 |
*observation_--interp_orig_ci_id,*observation_--interp_orig_ci_id,, |
|
| 190 |
*observation_--interp_orig_cc_id,*observation_--interp_orig_cc_id,, |
|
| 191 |
*observation_--interp_orig_sciname,*observation_--interp_orig_sciname,, |
|
| 192 |
*observation_--interp_orig_code,*observation_--interp_orig_code,, |
|
| 193 |
*observation_--interp_orig_party_id,*observation_--interp_orig_party_id,, |
|
| 194 |
*observation_--interp_orig_partyname,*observation_--interp_orig_partyname,, |
|
| 195 |
*observation_--interp_current_ci_id,*observation_--interp_current_ci_id,, |
|
| 196 |
*observation_--interp_current_cc_id,*observation_--interp_current_cc_id,, |
|
| 197 |
*observation_--interp_current_sciname,*observation_--interp_current_sciname,, |
|
| 198 |
*observation_--interp_current_code,*observation_--interp_current_code,, |
|
| 199 |
*observation_--interp_current_party_id,*observation_--interp_current_party_id,, |
|
| 200 |
*observation_--interp_current_partyname,*observation_--interp_current_partyname,, |
|
| 201 |
*observation_--interp_bestfit_ci_id,*observation_--interp_bestfit_ci_id,, |
|
| 202 |
*observation_--interp_bestfit_cc_id,*observation_--interp_bestfit_cc_id,, |
|
| 203 |
*observation_--interp_bestfit_sciname,*observation_--interp_bestfit_sciname,, |
|
| 204 |
*observation_--interp_bestfit_code,*observation_--interp_bestfit_code,, |
|
| 205 |
*observation_--interp_bestfit_party_id,*observation_--interp_bestfit_party_id,, |
|
| 206 |
*observation_--interp_bestfit_partyname,*observation_--interp_bestfit_partyname,, |
|
| 207 |
*observation_--toptaxon1name,*observation_--toptaxon1name,, |
|
| 208 |
*observation_--toptaxon2name,*observation_--toptaxon2name,, |
|
| 209 |
*observation_--toptaxon3name,*observation_--toptaxon3name,, |
|
| 210 |
*observation_--toptaxon4name,*observation_--toptaxon4name,, |
|
| 211 |
*observation_--toptaxon5name,*observation_--toptaxon5name,, |
|
| 212 |
*observation_--numberoftaxa,*observation_--numberoftaxa,, |
|
| 213 |
*observation_--accessioncode,*observation_--accessioncode,, |
|
| 214 |
*observation_--soilobs_id,*observation_--soilobs_id,, |
|
| 215 |
*observation_--soilhorizon,*observation_--soilhorizon,, |
|
| 216 |
*observation_--soildepthtop,*observation_--soildepthtop,, |
|
| 217 |
*observation_--soildepthbottom,*observation_--soildepthbottom,, |
|
| 218 |
*observation_--soilcolor,*observation_--soilcolor,, |
|
| 219 |
organic_percent,organic_percent,, |
|
| 220 |
texture,texture,, |
|
| 221 |
sand_percent,sand_percent,, |
|
| 222 |
silt_percent,silt_percent,, |
|
| 223 |
clay_percent,clay_percent,, |
|
| 224 |
*observation_--soilcoarse,*observation_--soilcoarse,, |
|
| 225 |
ph,ph,, |
|
| 226 |
cationExchangeCapacity_cmol_kg,cationExchangeCapacity_cmol_kg,, |
|
| 227 |
baseSaturation_percent,baseSaturation_percent,, |
|
| 228 |
*observation_--soildescription,*observation_--soildescription,, |
|
| 229 |
*observation_--emb_soilobs,*observation_--emb_soilobs,, |
|
| 230 |
emb_soilobs,emb_soilobs,, |
|
| 231 |
locationName,locationName,, |
|
| 232 |
*plot_--reference_id,*plot_--reference_id,, |
|
| 233 |
parentLocationID,parentLocationID,, |
|
| 234 |
coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_coords,, |
|
| 235 |
accessRights_verbatim,accessRights_verbatim,, |
|
| 236 |
*plot_--confidentialityreason,*plot_--confidentialityreason,, |
|
| 237 |
decimalLatitude,decimalLatitude,, |
|
| 238 |
decimalLongitude,decimalLongitude,, |
|
| 239 |
*plot_--authore,*plot_--authore,, |
|
| 240 |
*plot_--authorn,*plot_--authorn,, |
|
| 241 |
*plot_--authorzone,*plot_--authorzone,, |
|
| 242 |
*plot_--authordatum,*plot_--authordatum,, |
|
| 243 |
*plot_--authorlocation,*plot_--authorlocation,, |
|
| 244 |
locality,locality,, |
|
| 245 |
*plot_--azimuth,*plot_--azimuth,, |
|
| 246 |
*plot_--dsgpoly,*plot_--dsgpoly,, |
|
| 247 |
footprintWKT,footprintWKT,, |
|
| 248 |
plotArea_m2,plotArea_m2,, |
|
| 249 |
*plot_--standsize,*plot_--standsize,, |
|
| 250 |
*plot_--placementmethod,*plot_--placementmethod,, |
|
| 251 |
*plot_--permanence,*plot_--permanence,, |
|
| 252 |
*plot_--layoutnarrative,*plot_--layoutnarrative,, |
|
| 253 |
elevationInMeters,elevationInMeters,, |
|
| 254 |
*plot_--elevationaccuracy,*plot_--elevationaccuracy,, |
|
| 255 |
UNUSED#elevationrange,UNUSED#elevationrange,, |
|
| 256 |
slopeAspect,slopeAspect,, |
|
| 257 |
minSlopeAspect,minSlopeAspect,, |
|
| 258 |
maxSlopeAspect,maxSlopeAspect,, |
|
| 259 |
slopeGradient,slopeGradient,, |
|
| 260 |
minSlopeGradient,minSlopeGradient,, |
|
| 261 |
maxSlopeGradient,maxSlopeGradient,, |
|
| 262 |
*plot_--topoposition,*plot_--topoposition,, |
|
| 263 |
landform,landform,, |
|
| 264 |
*plot_--surficialdeposits,*plot_--surficialdeposits,, |
|
| 265 |
*plot_--rocktype,*plot_--rocktype,, |
|
| 266 |
stateProvince,stateProvince,, |
|
| 267 |
country,country,, |
|
| 268 |
*plot_--submitter_surname,*plot_--submitter_surname,, |
|
| 269 |
*plot_--submitter_givenname,*plot_--submitter_givenname,, |
|
| 270 |
*plot_--submitter_email,*plot_--submitter_email,, |
|
| 271 |
*plot_--notespublic,*plot_--notespublic,, |
|
| 272 |
*plot_--notesmgt,*plot_--notesmgt,, |
|
| 273 |
*plot_--revisions,*plot_--revisions,, |
|
| 274 |
*plot_--dateentered,*plot_--dateentered,, |
|
| 275 |
*plot_--emb_plot,*plot_--emb_plot,, |
|
| 276 |
*plot_--plotrationalenarrative,*plot_--plotrationalenarrative,, |
|
| 277 |
*plot_--accessioncode,*plot_--accessioncode,, |
|
| 278 |
continent,continent,, |
|
| 279 |
DUPLICATE#of:country#area|country|territory,DUPLICATE#of:country#area|country|territory,, |
|
| 280 |
DUPLICATE#of:stateprovince#region|state|province,DUPLICATE#of:stateprovince#region|state|province,, |
|
| 281 |
county,county,, |
|
| 282 |
*plot_--quadrangle,*plot_--quadrangle,, |
|
| 283 |
*plot_--Geographic Name,*plot_--Geographic Name,, |
|
| 284 |
accessRights,accessRights,, |
|
| 285 |
coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters__from_fuzzing,, |
|
| 286 |
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,, |
|
| 287 |
taxonOccurrenceID,taxonOccurrenceID,, |
|
| inputs/VegBank/taxon_observation.**.sample/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| inputs/VegBank/taxon_observation.**.sample/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>VegBank.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<authorlocationcode>$locationName</authorlocationcode> |
|
| 11 |
<sourceaccessioncode>$locationID</sourceaccessioncode> |
|
| 12 |
<accesslevel>$accessRights</accesslevel> |
|
| 13 |
<area_m2>$plotArea_m2</area_m2> |
|
| 14 |
<elevation_m>$elevationInMeters</elevation_m> |
|
| 15 |
<iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated> |
|
| 16 |
<landform>$landform</landform> |
|
| 17 |
<locationevent> |
|
| 18 |
<method_id><method><name>$samplingProtocol</name></method></method_id> |
|
| 19 |
<project_id><project><sourceaccessioncode>$projectID</sourceaccessioncode></project></project_id> |
|
| 20 |
<authoreventcode>$authorEventCode</authoreventcode> |
|
| 21 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 22 |
<locationevent fkey="parent_id"> |
|
| 23 |
<stratum_id><stratum><stratumname>$stratum__name</stratumname></stratum></stratum_id> |
|
| 24 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 25 |
<taxonoccurrence> |
|
| 26 |
<aggregateoccurrence> |
|
| 27 |
<collectiondate>$dateCollected</collectiondate> |
|
| 28 |
<count>$individualCount</count> |
|
| 29 |
<cover_fraction><_percent_to_fraction><value>$coverPercent</value></_percent_to_fraction></cover_fraction> |
|
| 30 |
<notes>$occurrenceRemarks</notes> |
|
| 31 |
<plantobservation> |
|
| 32 |
<authorplantcode>$collectorNumber</authorplantcode> |
|
| 33 |
<sourceaccessioncode>$individualID</sourceaccessioncode> |
|
| 34 |
<specimenreplicate> |
|
| 35 |
<catalognumber_dwc>$accessionNumber</catalognumber_dwc> |
|
| 36 |
<collectionnumber>$collectorNumber</collectionnumber> |
|
| 37 |
</specimenreplicate> |
|
| 38 |
<stemobservation> |
|
| 39 |
<diameterbreastheight_m><_cm_to_m><value>$diameterBreastHeight_cm</value></_cm_to_m></diameterbreastheight_m> |
|
| 40 |
<height_m>$height_m</height_m> |
|
| 41 |
<sourceaccessioncode>$stemID</sourceaccessioncode> |
|
| 42 |
</stemobservation> |
|
| 43 |
</plantobservation> |
|
| 44 |
<sourceaccessioncode>$aggregateOrganismObservationID</sourceaccessioncode> |
|
| 45 |
</aggregateoccurrence> |
|
| 46 |
<authortaxoncode>$collectorNumber</authortaxoncode> |
|
| 47 |
<sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode> |
|
| 48 |
<taxondetermination> |
|
| 49 |
<taxonverbatim_id> |
|
| 50 |
<taxonverbatim> |
|
| 51 |
<taxonlabel_id> |
|
| 52 |
<taxonlabel> |
|
| 53 |
<parent_id> |
|
| 54 |
<taxonlabel> |
|
| 55 |
<parent_id> |
|
| 56 |
<taxonlabel> |
|
| 57 |
<rank>cultivar</rank> |
|
| 58 |
<parent_id> |
|
| 59 |
<taxonlabel> |
|
| 60 |
<rank>forma</rank> |
|
| 61 |
<parent_id> |
|
| 62 |
<taxonlabel> |
|
| 63 |
<rank>variety</rank> |
|
| 64 |
<parent_id> |
|
| 65 |
<taxonlabel> |
|
| 66 |
<rank>subspecies</rank> |
|
| 67 |
<parent_id> |
|
| 68 |
<taxonlabel> |
|
| 69 |
<rank>species</rank> |
|
| 70 |
<parent_id> |
|
| 71 |
<taxonlabel> |
|
| 72 |
<rank>genus</rank> |
|
| 73 |
<taxonepithet>$genus</taxonepithet> |
|
| 74 |
<parent_id> |
|
| 75 |
<taxonlabel> |
|
| 76 |
<rank>family</rank> |
|
| 77 |
<taxonepithet>$family</taxonepithet> |
|
| 78 |
<parent_id> |
|
| 79 |
<taxonlabel> |
|
| 80 |
<rank>order</rank> |
|
| 81 |
<taxonepithet>$order</taxonepithet> |
|
| 82 |
<parent_id> |
|
| 83 |
<taxonlabel> |
|
| 84 |
<rank>class</rank> |
|
| 85 |
<taxonepithet>$class</taxonepithet> |
|
| 86 |
<parent_id> |
|
| 87 |
<taxonlabel> |
|
| 88 |
<rank>phylum</rank> |
|
| 89 |
<parent_id> |
|
| 90 |
<taxonlabel> |
|
| 91 |
<rank>kingdom</rank> |
|
| 92 |
<taxonepithet>$kingdom</taxonepithet> |
|
| 93 |
</taxonlabel> |
|
| 94 |
</parent_id> |
|
| 95 |
</taxonlabel> |
|
| 96 |
</parent_id> |
|
| 97 |
</taxonlabel> |
|
| 98 |
</parent_id> |
|
| 99 |
</taxonlabel> |
|
| 100 |
</parent_id> |
|
| 101 |
</taxonlabel> |
|
| 102 |
</parent_id> |
|
| 103 |
</taxonlabel> |
|
| 104 |
</parent_id> |
|
| 105 |
</taxonlabel> |
|
| 106 |
</parent_id> |
|
| 107 |
</taxonlabel> |
|
| 108 |
</parent_id> |
|
| 109 |
</taxonlabel> |
|
| 110 |
</parent_id> |
|
| 111 |
</taxonlabel> |
|
| 112 |
</parent_id> |
|
| 113 |
</taxonlabel> |
|
| 114 |
</parent_id> |
|
| 115 |
</taxonlabel> |
|
| 116 |
</parent_id> |
|
| 117 |
<taxonomicname> |
|
| 118 |
<_merge_prefix> |
|
| 119 |
<prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix> |
|
| 120 |
<value> |
|
| 121 |
<_alt> |
|
| 122 |
<1>$scientificName</1> |
|
| 123 |
<2> |
|
| 124 |
<_alt> |
|
| 125 |
<1>$taxonName</1> |
|
| 126 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 127 |
</_alt> |
|
| 128 |
</2> |
|
| 129 |
</_alt> |
|
| 130 |
</value> |
|
| 131 |
</_merge_prefix> |
|
| 132 |
</taxonomicname> |
|
| 133 |
</taxonlabel> |
|
| 134 |
</taxonlabel_id> |
|
| 135 |
<family>$family</family> |
|
| 136 |
<genus>$genus</genus> |
|
| 137 |
<taxonname>$taxonName</taxonname> |
|
| 138 |
<taxonomicname>$scientificName</taxonomicname> |
|
| 139 |
</taxonverbatim> |
|
| 140 |
</taxonverbatim_id> |
|
| 141 |
<determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate> |
|
| 142 |
<determinationtype>$identificationType</determinationtype> |
|
| 143 |
<taxonfit>$identificationQualifier</taxonfit> |
|
| 144 |
</taxondetermination> |
|
| 145 |
<taxondetermination> |
|
| 146 |
<isoriginal>true</isoriginal> |
|
| 147 |
<taxonverbatim_id> |
|
| 148 |
<taxonverbatim> |
|
| 149 |
<taxonname>$originalTaxonName</taxonname> |
|
| 150 |
<taxonomicname>$originalScientificName</taxonomicname> |
|
| 151 |
</taxonverbatim> |
|
| 152 |
</taxonverbatim_id> |
|
| 153 |
</taxondetermination> |
|
| 154 |
</taxonoccurrence> |
|
| 155 |
</locationevent> |
|
| 156 |
<obsenddate>$endDate</obsenddate> |
|
| 157 |
<obsstartdate>$startDate</obsstartdate> |
|
| 158 |
<soilsample> |
|
| 159 |
<basesaturation_fraction><_percent_to_fraction><value>$baseSaturation_percent</value></_percent_to_fraction></basesaturation_fraction> |
|
| 160 |
<cationexchangecapacity_cmol_kg>$cationExchangeCapacity_cmol_kg</cationexchangecapacity_cmol_kg> |
|
| 161 |
<clay_fraction><_percent_to_fraction><value>$clay_percent</value></_percent_to_fraction></clay_fraction> |
|
| 162 |
<organic_fraction><_percent_to_fraction><value>$organic_percent</value></_percent_to_fraction></organic_fraction> |
|
| 163 |
<ph>$ph</ph> |
|
| 164 |
<sand_fraction><_percent_to_fraction><value>$sand_percent</value></_percent_to_fraction></sand_fraction> |
|
| 165 |
<silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction> |
|
| 166 |
<texture>$texture</texture> |
|
| 167 |
</soilsample> |
|
| 168 |
</locationevent> |
|
| 169 |
<locationnarrative>$locality</locationnarrative> |
|
| 170 |
<locationplace> |
|
| 171 |
<place_id> |
|
| 172 |
<place> |
|
| 173 |
<coordinates_id> |
|
| 174 |
<coordinates> |
|
| 175 |
<coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m> |
|
| 176 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
|
| 177 |
<latitude_deg> |
|
| 178 |
<_nullIf> |
|
| 179 |
<null>0</null> |
|
| 180 |
<type>float</type> |
|
| 181 |
<value>$decimalLatitude</value> |
|
| 182 |
</_nullIf> |
|
| 183 |
</latitude_deg> |
|
| 184 |
<longitude_deg> |
|
| 185 |
<_nullIf> |
|
| 186 |
<null>0</null> |
|
| 187 |
<type>float</type> |
|
| 188 |
<value>$decimalLongitude</value> |
|
| 189 |
</_nullIf> |
|
| 190 |
</longitude_deg> |
|
| 191 |
</coordinates> |
|
| 192 |
</coordinates_id> |
|
| 193 |
<continent>$continent</continent> |
|
| 194 |
<country>$country</country> |
|
| 195 |
<county>$county</county> |
|
| 196 |
<matched_place_id> |
|
| 197 |
<place> |
|
| 198 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 199 |
<coordinates_id> |
|
| 200 |
<coordinates> |
|
| 201 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 202 |
<latitude_deg> |
|
| 203 |
<_nullIf> |
|
| 204 |
<null>0</null> |
|
| 205 |
<type>float</type> |
|
| 206 |
<value>$decimalLatitude</value> |
|
| 207 |
</_nullIf> |
|
| 208 |
</latitude_deg> |
|
| 209 |
<longitude_deg> |
|
| 210 |
<_nullIf> |
|
| 211 |
<null>0</null> |
|
| 212 |
<type>float</type> |
|
| 213 |
<value>$decimalLongitude</value> |
|
| 214 |
</_nullIf> |
|
| 215 |
</longitude_deg> |
|
| 216 |
</coordinates> |
|
| 217 |
</coordinates_id> |
|
| 218 |
<country>$country</country> |
|
| 219 |
<county>$county</county> |
|
| 220 |
<stateprovince>$stateProvince</stateprovince> |
|
| 221 |
</place> |
|
| 222 |
</matched_place_id> |
|
| 223 |
<stateprovince>$stateProvince</stateprovince> |
|
| 224 |
</place> |
|
| 225 |
</place_id> |
|
| 226 |
</locationplace> |
|
| 227 |
<parent_id><location><sourceaccessioncode>$parentLocationID</sourceaccessioncode></location></parent_id> |
|
| 228 |
<slopeaspect_deg> |
|
| 229 |
<_alt> |
|
| 230 |
<1><_compass><value>$slopeAspect</value></_compass></1> |
|
| 231 |
<2> |
|
| 232 |
<_avg> |
|
| 233 |
<1>$minSlopeAspect</1> |
|
| 234 |
<2>$maxSlopeAspect</2> |
|
| 235 |
</_avg> |
|
| 236 |
</2> |
|
| 237 |
</_alt> |
|
| 238 |
</slopeaspect_deg> |
|
| 239 |
<slopegradient_fraction> |
|
| 240 |
<_alt> |
|
| 241 |
<1>$slopeGradient</1> |
|
| 242 |
<2> |
|
| 243 |
<_avg> |
|
| 244 |
<1>$minSlopeGradient</1> |
|
| 245 |
<2>$maxSlopeGradient</2> |
|
| 246 |
</_avg> |
|
| 247 |
</2> |
|
| 248 |
</_alt> |
|
| 249 |
</slopegradient_fraction> |
|
| 250 |
</location> |
|
| 251 |
</path> |
|
| 252 |
</_simplifyPath> |
|
| 253 |
</path> |
|
| 254 |
</_setDefault> |
|
| 255 |
</VegBIEN> |
|
| 256 |
Inserted 29 new rows into database |
|
| inputs/VegBank/taxon_observation.**.sample/unmapped_terms.csv | ||
|---|---|---|
| 1 |
sort_col |
|
| 2 |
*stratumtype_id |
|
| 3 |
*stratum_id |
|
| 4 |
aggregateOrganismObservationID__taxon_presence |
|
| 5 |
aggregateOrganismObservationID__individual_count |
|
| 6 |
taxonOccurrenceID__overall_plot |
|
| 7 |
*taxonobservation_--plantname_id |
|
| 8 |
*taxonobservation_--plantconcept_id |
|
| 9 |
identificationID |
|
| 10 |
*taxonobservation_--stemlocation_id |
|
| 11 |
*taxonobservation_--taxoninterpretation_plantname_id |
|
| 12 |
*taxonobservation_--taxoninterpretation_party_id |
|
| 13 |
*taxonobservation_--role_id |
|
| 14 |
*taxonobservation_--reference_id |
|
| 15 |
*taxonobservation_--originalinterpretation |
|
| 16 |
*taxonobservation_--currentinterpretation |
|
| 17 |
identificationVerificationStatus |
|
| 18 |
*taxonobservation_--museum_id |
|
| 19 |
*taxonobservation_--grouptype |
|
| 20 |
*taxonobservation_--notespublic |
|
| 21 |
*taxonobservation_--notesmgt |
|
| 22 |
*taxonobservation_--revisions |
|
| 23 |
*taxonobservation_--emb_taxoninterpretation |
|
| 24 |
*taxonobservation_--taxoninterpretation_accessioncode |
|
| 25 |
*taxonobservation_--taxonobservation_reference_id |
|
| 26 |
*taxonobservation_--taxoninferencearea |
|
| 27 |
*taxonobservation_--emb_taxonobservation |
|
| 28 |
*taxonobservation_--int_origplantconcept_id |
|
| 29 |
originalVernacularName |
|
| 30 |
*taxonobservation_--int_origplantcode |
|
| 31 |
*taxonobservation_--int_currplantconcept_id |
|
| 32 |
scientificName_verbatim |
|
| 33 |
vernacularName |
|
| 34 |
*taxonobservation_--int_currplantcode |
|
| 35 |
*taxonobservation_--taxonobservation_accessioncode |
|
| 36 |
*plantconcept_--plantconcept_reference_id |
|
| 37 |
scientificName__for_nearest_taxon_concept |
|
| 38 |
*plantconcept_--plantcode |
|
| 39 |
*plantconcept_--plantdescription |
|
| 40 |
*plantconcept_--d_obscount |
|
| 41 |
*plantconcept_--d_currentaccepted |
|
| 42 |
*plantconcept_--plantconcept_accessioncode |
|
| 43 |
*Subkingdom |
|
| 44 |
*Superdivision |
|
| 45 |
*Division |
|
| 46 |
*Subdivision |
|
| 47 |
*Subclass |
|
| 48 |
*taxonobservation_--plantname_reference_id |
|
| 49 |
*taxonobservation_--dateentered |
|
| 50 |
*stemcount_--basalarea |
|
| 51 |
*stemcount_--biomass |
|
| 52 |
*stemcount_--inferencearea |
|
| 53 |
*stemcount_--stratumbase |
|
| 54 |
*stemcount_--stratumheight |
|
| 55 |
*stemcount_--emb_taxonimportance |
|
| 56 |
*stemcount_--covercode |
|
| 57 |
*stemcount_--stemdiameteraccuracy |
|
| 58 |
*stemcount_--stemheightaccuracy |
|
| 59 |
*stemcount_--stemtaxonarea |
|
| 60 |
*stemcount_--emb_stemcount |
|
| 61 |
*stemlocation_--stemhealth |
|
| 62 |
*stemlocation_--emb_stemlocation |
|
| 63 |
*stratum--observation_id |
|
| 64 |
*stratum--stratummethod_id |
|
| 65 |
*stratum--stratumname |
|
| 66 |
*stratum--stratumheight |
|
| 67 |
*stratum--stratumbase |
|
| 68 |
*stratum--stratumcover |
|
| 69 |
*stratum--stratumdescription |
|
| 70 |
*stratumtype--stratummethod_id |
|
| 71 |
*stratumtype--stratumindex |
|
| 72 |
*stratumtype--stratumdescription |
|
| 73 |
*observation_--previousobs_id |
|
| 74 |
*observation_--dateaccuracy |
|
| 75 |
*observation_--covermethod_id |
|
| 76 |
*observation_--coverdispersion |
|
| 77 |
*observation_--autotaxoncover |
|
| 78 |
*observation_--stratummethod_id |
|
| 79 |
*observation_--taxonobservationarea |
|
| 80 |
*observation_--stemsizelimit |
|
| 81 |
*observation_--stemobservationarea |
|
| 82 |
*observation_--stemsamplemethod |
|
| 83 |
*observation_--originaldata |
|
| 84 |
*observation_--effortlevel |
|
| 85 |
*observation_--plotvalidationlevel |
|
| 86 |
*observation_--floristicquality |
|
| 87 |
*observation_--bryophytequality |
|
| 88 |
*observation_--lichenquality |
|
| 89 |
*observation_--observationnarrative |
|
| 90 |
*observation_--landscapenarrative |
|
| 91 |
*observation_--homogeneity |
|
| 92 |
*observation_--phenologicaspect |
|
| 93 |
*observation_--representativeness |
|
| 94 |
*observation_--standmaturity |
|
| 95 |
*observation_--successionalstatus |
|
| 96 |
*observation_--basalarea |
|
| 97 |
*observation_--hydrologicregime |
|
| 98 |
*observation_--soilmoistureregime |
|
| 99 |
*observation_--soildrainage |
|
| 100 |
*observation_--watersalinity |
|
| 101 |
*observation_--waterdepth |
|
| 102 |
*observation_--shoredistance |
|
| 103 |
*observation_--soildepth |
|
| 104 |
*observation_--organicdepth |
|
| 105 |
*observation_--soiltaxon_id |
|
| 106 |
*observation_--soiltaxonsrc |
|
| 107 |
*observation_--percentbedrock |
|
| 108 |
*observation_--percentrockgravel |
|
| 109 |
*observation_--percentwood |
|
| 110 |
*observation_--percentlitter |
|
| 111 |
*observation_--percentbaresoil |
|
| 112 |
*observation_--percentwater |
|
| 113 |
*observation_--percentother |
|
| 114 |
*observation_--nameother |
|
| 115 |
*observation_--treeht |
|
| 116 |
*observation_--shrubht |
|
| 117 |
*observation_--fieldht |
|
| 118 |
*observation_--nonvascularht |
|
| 119 |
*observation_--submergedht |
|
| 120 |
*observation_--treecover |
|
| 121 |
*observation_--shrubcover |
|
| 122 |
*observation_--fieldcover |
|
| 123 |
*observation_--nonvascularcover |
|
| 124 |
*observation_--floatingcover |
|
| 125 |
*observation_--submergedcover |
|
| 126 |
*observation_--dominantstratum |
|
| 127 |
*observation_--growthform1type |
|
| 128 |
*observation_--growthform2type |
|
| 129 |
*observation_--growthform3type |
|
| 130 |
*observation_--growthform1cover |
|
| 131 |
*observation_--growthform2cover |
|
| 132 |
*observation_--growthform3cover |
|
| 133 |
*observation_--totalcover |
|
| 134 |
*observation_--notespublic |
|
| 135 |
*observation_--notesmgt |
|
| 136 |
*observation_--revisions |
|
| 137 |
*observation_--dateentered |
|
| 138 |
*observation_--emb_observation |
|
| 139 |
*observation_--interp_orig_ci_id |
|
| 140 |
*observation_--interp_orig_cc_id |
|
| 141 |
*observation_--interp_orig_sciname |
|
| 142 |
*observation_--interp_orig_code |
|
| 143 |
*observation_--interp_orig_party_id |
|
| 144 |
*observation_--interp_orig_partyname |
|
| 145 |
*observation_--interp_current_ci_id |
|
| 146 |
*observation_--interp_current_cc_id |
|
| 147 |
*observation_--interp_current_sciname |
|
| 148 |
*observation_--interp_current_code |
|
| 149 |
*observation_--interp_current_party_id |
|
| 150 |
*observation_--interp_current_partyname |
|
| 151 |
*observation_--interp_bestfit_ci_id |
|
| 152 |
*observation_--interp_bestfit_cc_id |
|
| 153 |
*observation_--interp_bestfit_sciname |
|
| 154 |
*observation_--interp_bestfit_code |
|
| 155 |
*observation_--interp_bestfit_party_id |
|
| 156 |
*observation_--interp_bestfit_partyname |
|
| 157 |
*observation_--toptaxon1name |
|
| 158 |
*observation_--toptaxon2name |
|
| 159 |
*observation_--toptaxon3name |
|
| 160 |
*observation_--toptaxon4name |
|
| 161 |
*observation_--toptaxon5name |
|
| 162 |
*observation_--numberoftaxa |
|
| 163 |
*observation_--accessioncode |
|
| 164 |
*observation_--soilobs_id |
|
| 165 |
*observation_--soilhorizon |
|
| 166 |
*observation_--soildepthtop |
|
| 167 |
*observation_--soildepthbottom |
|
| 168 |
*observation_--soilcolor |
|
| 169 |
*observation_--soilcoarse |
|
| 170 |
*observation_--soildescription |
|
| 171 |
*observation_--emb_soilobs |
|
| 172 |
emb_soilobs |
|
| 173 |
*plot_--reference_id |
|
| 174 |
coordinateUncertaintyInMeters__from_coords |
|
| 175 |
accessRights_verbatim |
|
| 176 |
*plot_--confidentialityreason |
|
| 177 |
*plot_--authore |
|
| 178 |
*plot_--authorn |
|
| 179 |
*plot_--authorzone |
|
| 180 |
*plot_--authordatum |
|
| 181 |
*plot_--authorlocation |
|
| 182 |
*plot_--azimuth |
|
| 183 |
*plot_--dsgpoly |
|
| 184 |
*plot_--standsize |
|
| 185 |
*plot_--placementmethod |
|
| 186 |
*plot_--permanence |
|
| 187 |
*plot_--layoutnarrative |
|
| 188 |
*plot_--elevationaccuracy |
|
| 189 |
*plot_--topoposition |
|
| 190 |
*plot_--surficialdeposits |
|
| 191 |
*plot_--rocktype |
|
| 192 |
*plot_--submitter_surname |
|
| 193 |
*plot_--submitter_givenname |
|
| 194 |
*plot_--submitter_email |
|
| 195 |
*plot_--notespublic |
|
| 196 |
*plot_--notesmgt |
|
| 197 |
*plot_--revisions |
|
| 198 |
*plot_--dateentered |
|
| 199 |
*plot_--emb_plot |
|
| 200 |
*plot_--plotrationalenarrative |
|
| 201 |
*plot_--accessioncode |
|
| 202 |
*plot_--quadrangle |
|
| 203 |
*plot_--Geographic Name |
|
| 204 |
coordinateUncertaintyInMeters__from_fuzzing |
|
Also available in: Unified diff
inputs/VegBank/: added taxon_observation.**.sample subset of plots to use in the validation. this avoids the need to import all of VegBank just to validate a few of the plots.