Revision 11759
Added by Aaron Marcuse-Kubitza almost 11 years ago
| inputs/CVS/stemCount_/postprocess.sql | ||
|---|---|---|
| 1 | 1 |
SELECT util.search_path_append('util');
|
| 2 | 2 |
|
| 3 |
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("taxonOccurrenceID")$$); -- runtime: 3 s ("3003.022 ms") @starscream
|
|
| 3 |
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("taxonOccurrenceID__overall_plot")$$); -- runtime: 3 s ("3003.022 ms") @starscream
|
|
| 4 | 4 |
|
| 5 | 5 |
|
| 6 | 6 |
SELECT mk_derived_col((:table_str, 'aggregateOrganismObservationID'), |
| inputs/CVS/stemCount_/map.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegCore,Filter,Comments |
| 2 | 2 |
taxonImportance_ID,aggregateOrganismObservationID__taxon_presence,, |
| 3 |
taxonObservation_ID,taxonOccurrenceID,, |
|
| 3 |
taxonObservation_ID,taxonOccurrenceID__overall_plot,,
|
|
| 4 | 4 |
stratum_ID,*STRATUM_ID,, |
| 5 | 5 |
cover,coverPercent,, |
| 6 | 6 |
basalArea,*stemCount_--basalarea,, |
| inputs/CVS/stemCount_/test.xml.ref | ||
|---|---|---|
| 21 | 21 |
</plantobservation> |
| 22 | 22 |
<sourceaccessioncode>$aggregateOrganismObservationID</sourceaccessioncode> |
| 23 | 23 |
</aggregateoccurrence> |
| 24 |
<sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode> |
|
| 25 | 24 |
</taxonoccurrence> |
| 26 | 25 |
</locationevent> |
| 27 | 26 |
</locationevent> |
| ... | ... | |
| 31 | 30 |
</path> |
| 32 | 31 |
</_setDefault> |
| 33 | 32 |
</VegBIEN> |
| 34 |
Inserted 7 new rows into database |
|
| 33 |
Inserted 5 new rows into database |
|
| inputs/CVS/stemCount_/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
aggregateOrganismObservationID__taxon_presence |
| 2 |
taxonOccurrenceID__overall_plot |
|
| 2 | 3 |
*STRATUM_ID |
| 3 | 4 |
*stemCount_--basalarea |
| 4 | 5 |
*stemCount_--biomass |
| inputs/CVS/taxonObservation_/map.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegCore,Filter,Comments |
| 2 | 2 |
PLANTCONCEPT_ID,*taxonObservation_--PLANTCONCEPT_ID,, |
| 3 |
TAXONOBSERVATION_ID,taxonOccurrenceID,, |
|
| 3 |
TAXONOBSERVATION_ID,taxonOccurrenceID__overall_plot,,
|
|
| 4 | 4 |
OBSERVATION_ID,eventID,, |
| 5 | 5 |
authorPlantName,originalTaxonName,, |
| 6 | 6 |
taxonObservation_reference_ID,*taxonObservation_--taxonObservation_reference_ID,, |
| inputs/CVS/taxonObservation_/test.xml.ref | ||
|---|---|---|
| 25 | 25 |
</plantobservation> |
| 26 | 26 |
</aggregateoccurrence> |
| 27 | 27 |
<authortaxoncode>$collectorNumber</authortaxoncode> |
| 28 |
<sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode> |
|
| 29 | 28 |
<taxondetermination> |
| 30 | 29 |
<taxonverbatim_id> |
| 31 | 30 |
<taxonverbatim> |
| inputs/CVS/taxonObservation_/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*taxonObservation_--PLANTCONCEPT_ID |
| 2 |
taxonOccurrenceID__overall_plot |
|
| 2 | 3 |
*taxonObservation_--taxonObservation_reference_ID |
| 3 | 4 |
*taxonObservation_--currentTaxonInterpPlantConcept_ID |
| 4 | 5 |
*taxonObservation_--taxonInferenceArea |
| inputs/CVS/taxon_observation.**/header.csv | ||
|---|---|---|
| 1 |
sort_col,locationID,eventID,*STRATUMTYPE_ID,*STRATUM_ID,taxonOccurrenceID__overall_plot,*taxonObservation_--PLANTCONCEPT_ID,originalTaxonName,*taxonObservation_--taxonObservation_reference_ID,*taxonObservation_--currentTaxonInterpPlantConcept_ID,*taxonObservation_--taxonInferenceArea,*taxonObservation_--taxonObservation_accessionCode,*taxonObservation_--taxonObservation_dba_src_ID,*taxonObservation_--cust_cvs_corner1Presence,*taxonObservation_--cust_cvs_corner2Presence,*taxonObservation_--cust_cvs_corner3Presence,*taxonObservation_--cust_cvs_corner4Presence,*taxonObservation_--cust_cvs_corner5Presence,*taxonObservation_--entry_herbLineID,*taxonObservation_--entry_treeLineID,*taxonObservation_--taxonObservation_entry_sppID,*taxonObservation_--entry_unknownSp,*taxonObservation_--entry_sortOrder,*taxonObservation_--cust_cvs_collectionFlag,*taxonObservation_--taxonObservationNotes,*taxonObservation_--temp_taxonUpToDate,identificationID,stemID,dateIdentified,*taxonObservation_--taxonInterpretation_PLANTNAME_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,*taxonObservation_--ROLE_ID,identificationType,*taxonObservation_--reference_ID,taxon_determination__is_original,taxon_determination__is_current,identificationQualifier,identificationVerificationStatus,UNUSED#collector_ID,collectorNumber,dateCollected,*taxonObservation_--museum_ID,accessionNumber,*taxonObservation_--groupType,occurrenceRemarks,*taxonObservation_--notesPublic,*taxonObservation_--notesMgt,*taxonObservation_--revisions,*taxonObservation_--taxonInterpretation_dba_src_ID,*taxonObservation_--taxonInterpretation_accessionCode,*taxonObservation_--PLANTNAME_ID,*taxonObservation_--plantConcept_reference_ID,taxonName,scientificName,*taxonObservation_--plantCode,*taxonObservation_--plantDescription,*taxonObservation_--plantConcept_accessionCode,*taxonObservation_--plantConcept_dba_src_ID,*taxonObservation_--plantConcept_entry_sppID,*taxonObservation_--USDAPlantsCode,*taxonObservation_--VascularPlant,kingdom,division_main,*taxonObservation_--category,family,genus_main,specificEpithet,infraspecificRank,infraspecificEpithet,infraspecificRank2,infraspecificEpithet2,*taxonObservation_--hybridX,taxonRank,OMIT#taxonRank,*taxonObservation_--lowestParentName,*taxonObservation_--lowestParentConcept_ID,*taxonObservation_--lowestChildRank,vernacularName,*taxonObservation_--growthForm_short,*taxonObservation_--woody,*taxonObservation_--exotic,*taxonObservation_--usda_code,*taxonObservation_--usda_growthForm,*taxonObservation_--sensitiveSpeciesFuzzPlot,DUPLICATE#of:denorm_kingdom#Kingdom,*taxonObservation_--Subkingdom,division_normalized,class,*taxonObservation_--Subclass,order,*taxonObservation_--composite family,DUPLICATE#of:denorm_family#family,*taxonObservation_--tribe,*taxonObservation_--composite genus,genus_normalized,subgenus,*taxonObservation_--section,*taxonObservation_--composite species,speciesBinomial,EQUIV#to:species#subspecies,EQUIV#to:species#composite variety,EQUIV#to:species#variety,*taxonObservation_--division,genus,observationGranularity,aggregateOrganismObservationID__taxon_presence,coverPercent,*stemCount_--basalarea,*stemCount_--biomass,*stemCount_--inferencearea,*stemCount_--cust_cvs_StemFrequency,*stemCount_--taxonImportance_dba_src_ID,*stemCount_--taxonImportance_entry_herbLineID,*stemCount_--taxonImportance_entry_treeLineID,*stemCount_--cust_cvs_corner1Presence,*stemCount_--cust_cvs_corner2Presence,*stemCount_--cust_cvs_corner3Presence,*stemCount_--cust_cvs_corner4Presence,*stemCount_--cust_cvs_corner5Presence,*stemCount_--cust_cvs_originalCoverCode,aggregateOrganismObservationID__individual_count,diameterBreastHeight_cm,*stemCount_--stemdiameteraccuracy,height_m,*stemCount_--stemheightaccuracy,individualCount,*stemCount_--stemtaxonarea,*stemCount_--stemCount_dba_src_ID,*stemCount_--cust_cvs_ddh,*stemCount_--cust_cvs_ddhAccuracy,*stemCount_--cust_cvs_isPlanted,*stemCount_--cust_cvs_subsamplingFactor,*stemCount_--stemCount_entry_herbLineID,*stemCount_--stemCount_entry_treeLineID,*stemCount_--entry_recordCount,*stemCount_--entry_sortOrder,aggregateOrganismObservationID,*stratum--OBSERVATION_ID,*stratum--STRATUMMETHOD_ID,*stratum--stratumName,*stratum--stratumHeight,*stratum--stratumBase,*stratum--stratumCover,*stratum--stratumDescription,*stratum--dba_src_ID,*stratum--stratumArea,*stratum--stratumLabel,*stratumType--STRATUMMETHOD_ID,*stratumType--stratumIndex,stratum__name,*stratumType--stratumDescription,*stratumType--dba_src_ID,*stratumType--stratumOrder,*observation_--PREVIOUSOBS_ID,projectID,authorEventCode,startDate,endDate,*observation_--dateAccuracy,*observation_--dateEntered,*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_--soilTaxonComplex,*observation_--soilMapUnit,*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_--accessionCode,*observation_--notesPublic,*observation_--notesMgt,*observation_--revisions,*observation_--cust_cvs_CowardinSystem,*observation_--cust_cvs_mcnab_LFI_asp,*observation_--cust_cvs_mcnab_LFI_45,*observation_--cust_cvs_mcnab_LFI_90,*observation_--cust_cvs_mcnab_LFI_135,*observation_--cust_cvs_mcnab_LFI_180,*observation_--cust_cvs_mcnab_LFI_225,*observation_--cust_cvs_mcnab_LFI_270,*observation_--cust_cvs_mcnab_LFI_315,*observation_--cust_cvs_mcnab_TSI_asp,*observation_--cust_cvs_mcnab_TSI_45,*observation_--cust_cvs_mcnab_TSI_90,*observation_--cust_cvs_mcnab_TSI_135,*observation_--cust_cvs_mcnab_TSI_180,*observation_--cust_cvs_mcnab_TSI_225,*observation_--cust_cvs_mcnab_TSI_270,*observation_--cust_cvs_mcnab_TSI_315,*observation_--cust_cvs_mcnab_LFI,*observation_--cust_cvs_mcnab_TSI,*observation_--cust_cvs_LeafType,*observation_--cust_cvs_LeafPhenology,*observation_--cust_cvs_CanopyHeight,*observation_--cust_cvs_compassType,*observation_--cust_cvs_LocationSource,*observation_--cust_cvs_GPSLocationX,*observation_--cust_cvs_GPSLocationY,*observation_--cust_cvs_Ownership,*observation_--cust_cvs_taxaRichness,*observation_--cust_cvs_lengthSoilProbe,*observation_--cust_cvs_percentHistosol,*observation_--cust_cvs_percentBedrock,*observation_--cust_cvs_percentBoulder,*observation_--cust_cvs_percentGravelCobble,*observation_--cust_cvs_percentMineralSoil,*observation_--cust_cvs_percentCWD,*observation_--cust_cvs_percentFWD,*observation_--cust_cvs_percentDuff,*observation_--cust_cvs_percentLitter,*observation_--cust_cvs_percentNonVasc,*observation_--cust_cvs_percentWater,*observation_--cust_cvs_percentOther,*observation_--cust_cvs_percentOtherName,*observation_--cust_cvs_samplingLevel,*observation_--cust_cvs_postDsgPoly,*observation_--cust_cvs_stemsSampled,*observation_--cust_cvs_stemSamplingNarrative,*observation_--cust_eep_plotLastPlantedDate,*observation_--cust_eep_plotNotSampled,*observation_--cust_eep_plotNotSampledReason,*observation_--entry_ares_herbs,*observation_--entry_ares_trees,*observation_--entry_currentLandUse,*observation_--entry_depth,*observation_--entry_elevationUnits,*observation_--entry_formerLandUse,*observation_--entry_identificationNarrative,*observation_--entry_IntensiveModuleList,*observation_--entry_moduleSize_Overall,*observation_--entry_moduleSizeX,*observation_--entry_moduleSizeY,*observation_--entry_photosTaken,*observation_--entry_physClass,*observation_--entry_plot_X,*observation_--entry_plot_Y,*observation_--entry_soilModulesSampled,*observation_--entry_subsequentObsNum,*observation_--entry_taxonomicAuthority_ID,*observation_--entry_taxonomicAuthorityDate,*observation_--entry_team,*observation_--entry_plot,*observation_--entry_numberOfModules,*observation_--errors,*observation_--dba_src_ID,*observation_--dba_notes,*observation_--numberOfTaxa,*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_--cust_cvs_collectionName,*observation_--cust_cvs_Lab,*observation_--cust_cvs_N,*observation_--cust_cvs_S,*observation_--cust_cvs_P,*observation_--cust_cvs_Ca_ppm,*observation_--cust_cvs_Mg_ppm,*observation_--cust_cvs_K_ppm,*observation_--cust_cvs_Na_ppm,*observation_--cust_cvs_percent_Ca,*observation_--cust_cvs_percent_Mg,*observation_--cust_cvs_percent_K,*observation_--cust_cvs_percent_Na,*observation_--cust_cvs_percent_Othr,*observation_--cust_cvs_percent_H,*observation_--cust_cvs_B_ppm,*observation_--cust_cvs_Fe_ppm,*observation_--cust_cvs_Mn_ppm,*observation_--cust_cvs_Cu_ppm,*observation_--cust_cvs_Zn_ppm,*observation_--cust_cvs_Al_ppm,*observation_--cust_cvs_Density,*observation_--cust_cvs_Ca_over_Mg_ppm,*observation_--soilObs_dba_src_ID,locationName,*plot_--reference_ID,parentLocationID,*plot_--plotObsolete,*plot_--REPLACEMENTPLOT_ID,UNUSED#realLatitude,UNUSED#realLongitude,coordinateUncertaintyInMeters__from_coords,accessRights_verbatim,*plot_--confidentialityFieldsBlocked,*plot_--confidentialityReason,decimalLatitude,decimalLongitude,*plot_--authorCoordinateType,*plot_--authorCoordinateUnits,*plot_--authorE,*plot_--authorN,*plot_--authorZone,*plot_--authorDatum,*plot_--authorLocation,locality,*plot_--plotRationaleNarrative,*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,county,*plot_--cust_cvs_province,stateProvince,country,*plot_--dateentered,*plot_--submitter_surname,*plot_--submitter_givenname,*plot_--submitter_email,*plot_--accessionCode,*plot_--notesPublic,*plot_--notesMgt,*plot_--revisions,*plot_--cust_eep_reach,*plot_--dba_src_ID,continent,DUPLICATE#of:COUNTRY#area|country|territory,DUPLICATE#of:stateProvince#region|state|province,DUPLICATE#of:county#county_,*plot_--quadrangle,*plot_--Geographic Name,*plot_--River Basin,accessRights,coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters,taxonOccurrenceID |
|
| inputs/CVS/taxon_observation.**/postprocess.sql | ||
|---|---|---|
| 1 |
SELECT util.search_path_append('util');
|
|
| 2 |
|
|
| 3 |
SELECT force_update_view(:table_str, $$ |
|
| 4 |
/* no row_num because left-join to stemCount_ adds rows to each |
|
| 5 |
taxonobservation_ */ |
|
| 6 |
SELECT "identificationID" AS sort_col, * |
|
| 7 |
, NULLIF(concat_ws('; ', "taxonOccurrenceID__overall_plot"::text, "aggregateOrganismObservationID"), '') AS "taxonOccurrenceID"
|
|
| 8 |
FROM "taxonObservation_" |
|
| 9 |
NATURAL LEFT JOIN "stemCount_" |
|
| 10 |
NATURAL LEFT JOIN stratum |
|
| 11 |
NATURAL LEFT JOIN "stratumType" |
|
| 12 |
NATURAL LEFT JOIN observation_ |
|
| 13 |
NATURAL LEFT JOIN plot_ |
|
| 14 |
$$); |
|
| 15 |
|
|
| 16 |
SELECT mk_subset_by_row_num_func(:table_str); |
|
| inputs/CVS/taxon_observation.**/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/view.run
|
|
| 0 | 3 | |
| inputs/CVS/taxon_observation.**/map.csv | ||
|---|---|---|
| 1 |
CVS,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 |
taxonOccurrenceID__overall_plot,taxonOccurrenceID__overall_plot,, |
|
| 8 |
*taxonObservation_--PLANTCONCEPT_ID,*taxonObservation_--PLANTCONCEPT_ID,, |
|
| 9 |
originalTaxonName,originalTaxonName,, |
|
| 10 |
*taxonObservation_--taxonObservation_reference_ID,*taxonObservation_--taxonObservation_reference_ID,, |
|
| 11 |
*taxonObservation_--currentTaxonInterpPlantConcept_ID,*taxonObservation_--currentTaxonInterpPlantConcept_ID,, |
|
| 12 |
*taxonObservation_--taxonInferenceArea,*taxonObservation_--taxonInferenceArea,, |
|
| 13 |
*taxonObservation_--taxonObservation_accessionCode,*taxonObservation_--taxonObservation_accessionCode,, |
|
| 14 |
*taxonObservation_--taxonObservation_dba_src_ID,*taxonObservation_--taxonObservation_dba_src_ID,, |
|
| 15 |
*taxonObservation_--cust_cvs_corner1Presence,*taxonObservation_--cust_cvs_corner1Presence,, |
|
| 16 |
*taxonObservation_--cust_cvs_corner2Presence,*taxonObservation_--cust_cvs_corner2Presence,, |
|
| 17 |
*taxonObservation_--cust_cvs_corner3Presence,*taxonObservation_--cust_cvs_corner3Presence,, |
|
| 18 |
*taxonObservation_--cust_cvs_corner4Presence,*taxonObservation_--cust_cvs_corner4Presence,, |
|
| 19 |
*taxonObservation_--cust_cvs_corner5Presence,*taxonObservation_--cust_cvs_corner5Presence,, |
|
| 20 |
*taxonObservation_--entry_herbLineID,*taxonObservation_--entry_herbLineID,, |
|
| 21 |
*taxonObservation_--entry_treeLineID,*taxonObservation_--entry_treeLineID,, |
|
| 22 |
*taxonObservation_--taxonObservation_entry_sppID,*taxonObservation_--taxonObservation_entry_sppID,, |
|
| 23 |
*taxonObservation_--entry_unknownSp,*taxonObservation_--entry_unknownSp,, |
|
| 24 |
*taxonObservation_--entry_sortOrder,*taxonObservation_--entry_sortOrder,, |
|
| 25 |
*taxonObservation_--cust_cvs_collectionFlag,*taxonObservation_--cust_cvs_collectionFlag,, |
|
| 26 |
*taxonObservation_--taxonObservationNotes,*taxonObservation_--taxonObservationNotes,, |
|
| 27 |
*taxonObservation_--temp_taxonUpToDate,*taxonObservation_--temp_taxonUpToDate,, |
|
| 28 |
identificationID,identificationID,, |
|
| 29 |
stemID,stemID,, |
|
| 30 |
dateIdentified,dateIdentified,, |
|
| 31 |
*taxonObservation_--taxonInterpretation_PLANTNAME_ID,*taxonObservation_--taxonInterpretation_PLANTNAME_ID,, |
|
| 32 |
*taxonObservation_--taxonInterpretation_PARTY_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,, |
|
| 33 |
*taxonObservation_--ROLE_ID,*taxonObservation_--ROLE_ID,, |
|
| 34 |
identificationType,identificationType,, |
|
| 35 |
*taxonObservation_--reference_ID,*taxonObservation_--reference_ID,, |
|
| 36 |
taxon_determination__is_original,taxon_determination__is_original,, |
|
| 37 |
taxon_determination__is_current,taxon_determination__is_current,, |
|
| 38 |
identificationQualifier,identificationQualifier,, |
|
| 39 |
identificationVerificationStatus,identificationVerificationStatus,, |
|
| 40 |
UNUSED#collector_ID,UNUSED#collector_ID,, |
|
| 41 |
collectorNumber,collectorNumber,, |
|
| 42 |
dateCollected,dateCollected,, |
|
| 43 |
*taxonObservation_--museum_ID,*taxonObservation_--museum_ID,, |
|
| 44 |
accessionNumber,accessionNumber,, |
|
| 45 |
*taxonObservation_--groupType,*taxonObservation_--groupType,, |
|
| 46 |
occurrenceRemarks,occurrenceRemarks,, |
|
| 47 |
*taxonObservation_--notesPublic,*taxonObservation_--notesPublic,, |
|
| 48 |
*taxonObservation_--notesMgt,*taxonObservation_--notesMgt,, |
|
| 49 |
*taxonObservation_--revisions,*taxonObservation_--revisions,, |
|
| 50 |
*taxonObservation_--taxonInterpretation_dba_src_ID,*taxonObservation_--taxonInterpretation_dba_src_ID,, |
|
| 51 |
*taxonObservation_--taxonInterpretation_accessionCode,*taxonObservation_--taxonInterpretation_accessionCode,, |
|
| 52 |
*taxonObservation_--PLANTNAME_ID,*taxonObservation_--PLANTNAME_ID,, |
|
| 53 |
*taxonObservation_--plantConcept_reference_ID,*taxonObservation_--plantConcept_reference_ID,, |
|
| 54 |
taxonName,taxonName,, |
|
| 55 |
scientificName,scientificName,, |
|
| 56 |
*taxonObservation_--plantCode,*taxonObservation_--plantCode,, |
|
| 57 |
*taxonObservation_--plantDescription,*taxonObservation_--plantDescription,, |
|
| 58 |
*taxonObservation_--plantConcept_accessionCode,*taxonObservation_--plantConcept_accessionCode,, |
|
| 59 |
*taxonObservation_--plantConcept_dba_src_ID,*taxonObservation_--plantConcept_dba_src_ID,, |
|
| 60 |
*taxonObservation_--plantConcept_entry_sppID,*taxonObservation_--plantConcept_entry_sppID,, |
|
| 61 |
*taxonObservation_--USDAPlantsCode,*taxonObservation_--USDAPlantsCode,, |
|
| 62 |
*taxonObservation_--VascularPlant,*taxonObservation_--VascularPlant,, |
|
| 63 |
kingdom,kingdom,, |
|
| 64 |
division_main,division_main,, |
|
| 65 |
*taxonObservation_--category,*taxonObservation_--category,, |
|
| 66 |
family,family,, |
|
| 67 |
genus_main,genus_main,, |
|
| 68 |
specificEpithet,specificEpithet,, |
|
| 69 |
infraspecificRank,infraspecificRank,, |
|
| 70 |
infraspecificEpithet,infraspecificEpithet,, |
|
| 71 |
infraspecificRank2,infraspecificRank2,, |
|
| 72 |
infraspecificEpithet2,infraspecificEpithet2,, |
|
| 73 |
*taxonObservation_--hybridX,*taxonObservation_--hybridX,, |
|
| 74 |
taxonRank,taxonRank,, |
|
| 75 |
OMIT#taxonRank,OMIT#taxonRank,, |
|
| 76 |
*taxonObservation_--lowestParentName,*taxonObservation_--lowestParentName,, |
|
| 77 |
*taxonObservation_--lowestParentConcept_ID,*taxonObservation_--lowestParentConcept_ID,, |
|
| 78 |
*taxonObservation_--lowestChildRank,*taxonObservation_--lowestChildRank,, |
|
| 79 |
vernacularName,vernacularName,, |
|
| 80 |
*taxonObservation_--growthForm_short,*taxonObservation_--growthForm_short,, |
|
| 81 |
*taxonObservation_--woody,*taxonObservation_--woody,, |
|
| 82 |
*taxonObservation_--exotic,*taxonObservation_--exotic,, |
|
| 83 |
*taxonObservation_--usda_code,*taxonObservation_--usda_code,, |
|
| 84 |
*taxonObservation_--usda_growthForm,*taxonObservation_--usda_growthForm,, |
|
| 85 |
*taxonObservation_--sensitiveSpeciesFuzzPlot,*taxonObservation_--sensitiveSpeciesFuzzPlot,, |
|
| 86 |
DUPLICATE#of:denorm_kingdom#Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,, |
|
| 87 |
*taxonObservation_--Subkingdom,*taxonObservation_--Subkingdom,, |
|
| 88 |
division_normalized,division_normalized,, |
|
| 89 |
class,class,, |
|
| 90 |
*taxonObservation_--Subclass,*taxonObservation_--Subclass,, |
|
| 91 |
order,order,, |
|
| 92 |
*taxonObservation_--composite family,*taxonObservation_--composite family,, |
|
| 93 |
DUPLICATE#of:denorm_family#family,DUPLICATE#of:denorm_family#family,, |
|
| 94 |
*taxonObservation_--tribe,*taxonObservation_--tribe,, |
|
| 95 |
*taxonObservation_--composite genus,*taxonObservation_--composite genus,, |
|
| 96 |
genus_normalized,genus_normalized,, |
|
| 97 |
subgenus,subgenus,, |
|
| 98 |
*taxonObservation_--section,*taxonObservation_--section,, |
|
| 99 |
*taxonObservation_--composite species,*taxonObservation_--composite species,, |
|
| 100 |
speciesBinomial,speciesBinomial,, |
|
| 101 |
EQUIV#to:species#subspecies,EQUIV#to:species#subspecies,, |
|
| 102 |
EQUIV#to:species#composite variety,EQUIV#to:species#composite variety,, |
|
| 103 |
EQUIV#to:species#variety,EQUIV#to:species#variety,, |
|
| 104 |
*taxonObservation_--division,*taxonObservation_--division,, |
|
| 105 |
genus,genus,, |
|
| 106 |
observationGranularity,observationGranularity,, |
|
| 107 |
aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__taxon_presence,, |
|
| 108 |
coverPercent,coverPercent,, |
|
| 109 |
*stemCount_--basalarea,*stemCount_--basalarea,, |
|
| 110 |
*stemCount_--biomass,*stemCount_--biomass,, |
|
| 111 |
*stemCount_--inferencearea,*stemCount_--inferencearea,, |
|
| 112 |
*stemCount_--cust_cvs_StemFrequency,*stemCount_--cust_cvs_StemFrequency,, |
|
| 113 |
*stemCount_--taxonImportance_dba_src_ID,*stemCount_--taxonImportance_dba_src_ID,, |
|
| 114 |
*stemCount_--taxonImportance_entry_herbLineID,*stemCount_--taxonImportance_entry_herbLineID,, |
|
| 115 |
*stemCount_--taxonImportance_entry_treeLineID,*stemCount_--taxonImportance_entry_treeLineID,, |
|
| 116 |
*stemCount_--cust_cvs_corner1Presence,*stemCount_--cust_cvs_corner1Presence,, |
|
| 117 |
*stemCount_--cust_cvs_corner2Presence,*stemCount_--cust_cvs_corner2Presence,, |
|
| 118 |
*stemCount_--cust_cvs_corner3Presence,*stemCount_--cust_cvs_corner3Presence,, |
|
| 119 |
*stemCount_--cust_cvs_corner4Presence,*stemCount_--cust_cvs_corner4Presence,, |
|
| 120 |
*stemCount_--cust_cvs_corner5Presence,*stemCount_--cust_cvs_corner5Presence,, |
|
| 121 |
*stemCount_--cust_cvs_originalCoverCode,*stemCount_--cust_cvs_originalCoverCode,, |
|
| 122 |
aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID__individual_count,, |
|
| 123 |
diameterBreastHeight_cm,diameterBreastHeight_cm,, |
|
| 124 |
*stemCount_--stemdiameteraccuracy,*stemCount_--stemdiameteraccuracy,, |
|
| 125 |
height_m,height_m,, |
|
| 126 |
*stemCount_--stemheightaccuracy,*stemCount_--stemheightaccuracy,, |
|
| 127 |
individualCount,individualCount,, |
|
| 128 |
*stemCount_--stemtaxonarea,*stemCount_--stemtaxonarea,, |
|
| 129 |
*stemCount_--stemCount_dba_src_ID,*stemCount_--stemCount_dba_src_ID,, |
|
| 130 |
*stemCount_--cust_cvs_ddh,*stemCount_--cust_cvs_ddh,, |
|
| 131 |
*stemCount_--cust_cvs_ddhAccuracy,*stemCount_--cust_cvs_ddhAccuracy,, |
|
| 132 |
*stemCount_--cust_cvs_isPlanted,*stemCount_--cust_cvs_isPlanted,, |
|
| 133 |
*stemCount_--cust_cvs_subsamplingFactor,*stemCount_--cust_cvs_subsamplingFactor,, |
|
| 134 |
*stemCount_--stemCount_entry_herbLineID,*stemCount_--stemCount_entry_herbLineID,, |
|
| 135 |
*stemCount_--stemCount_entry_treeLineID,*stemCount_--stemCount_entry_treeLineID,, |
|
| 136 |
*stemCount_--entry_recordCount,*stemCount_--entry_recordCount,, |
|
| 137 |
*stemCount_--entry_sortOrder,*stemCount_--entry_sortOrder,, |
|
| 138 |
aggregateOrganismObservationID,aggregateOrganismObservationID,, |
|
| 139 |
*stratum--OBSERVATION_ID,*stratum--OBSERVATION_ID,, |
|
| 140 |
*stratum--STRATUMMETHOD_ID,*stratum--STRATUMMETHOD_ID,, |
|
| 141 |
*stratum--stratumName,*stratum--stratumName,, |
|
| 142 |
*stratum--stratumHeight,*stratum--stratumHeight,, |
|
| 143 |
*stratum--stratumBase,*stratum--stratumBase,, |
|
| 144 |
*stratum--stratumCover,*stratum--stratumCover,, |
|
| 145 |
*stratum--stratumDescription,*stratum--stratumDescription,, |
|
| 146 |
*stratum--dba_src_ID,*stratum--dba_src_ID,, |
|
| 147 |
*stratum--stratumArea,*stratum--stratumArea,, |
|
| 148 |
*stratum--stratumLabel,*stratum--stratumLabel,, |
|
| 149 |
*stratumType--STRATUMMETHOD_ID,*stratumType--STRATUMMETHOD_ID,, |
|
| 150 |
*stratumType--stratumIndex,*stratumType--stratumIndex,, |
|
| 151 |
stratum__name,stratum__name,, |
|
| 152 |
*stratumType--stratumDescription,*stratumType--stratumDescription,, |
|
| 153 |
*stratumType--dba_src_ID,*stratumType--dba_src_ID,, |
|
| 154 |
*stratumType--stratumOrder,*stratumType--stratumOrder,, |
|
| 155 |
*observation_--PREVIOUSOBS_ID,*observation_--PREVIOUSOBS_ID,, |
|
| 156 |
projectID,projectID,, |
|
| 157 |
authorEventCode,authorEventCode,, |
|
| 158 |
startDate,startDate,, |
|
| 159 |
endDate,endDate,, |
|
| 160 |
*observation_--dateAccuracy,*observation_--dateAccuracy,, |
|
| 161 |
*observation_--dateEntered,*observation_--dateEntered,, |
|
| 162 |
*observation_--COVERMETHOD_ID,*observation_--COVERMETHOD_ID,, |
|
| 163 |
*observation_--coverDispersion,*observation_--coverDispersion,, |
|
| 164 |
*observation_--autoTaxonCover,*observation_--autoTaxonCover,, |
|
| 165 |
*observation_--STRATUMMETHOD_ID,*observation_--STRATUMMETHOD_ID,, |
|
| 166 |
samplingProtocol,samplingProtocol,, |
|
| 167 |
*observation_--taxonObservationArea,*observation_--taxonObservationArea,, |
|
| 168 |
*observation_--stemSizeLimit,*observation_--stemSizeLimit,, |
|
| 169 |
*observation_--stemObservationArea,*observation_--stemObservationArea,, |
|
| 170 |
*observation_--stemSampleMethod,*observation_--stemSampleMethod,, |
|
| 171 |
*observation_--originalData,*observation_--originalData,, |
|
| 172 |
*observation_--effortLevel,*observation_--effortLevel,, |
|
| 173 |
*observation_--plotValidationLevel,*observation_--plotValidationLevel,, |
|
| 174 |
*observation_--floristicQuality,*observation_--floristicQuality,, |
|
| 175 |
*observation_--bryophyteQuality,*observation_--bryophyteQuality,, |
|
| 176 |
*observation_--lichenQuality,*observation_--lichenQuality,, |
|
| 177 |
*observation_--observationNarrative,*observation_--observationNarrative,, |
|
| 178 |
*observation_--landscapeNarrative,*observation_--landscapeNarrative,, |
|
| 179 |
*observation_--homogeneity,*observation_--homogeneity,, |
|
| 180 |
*observation_--phenologicAspect,*observation_--phenologicAspect,, |
|
| 181 |
*observation_--representativeness,*observation_--representativeness,, |
|
| 182 |
*observation_--standMaturity,*observation_--standMaturity,, |
|
| 183 |
*observation_--successionalStatus,*observation_--successionalStatus,, |
|
| 184 |
*observation_--basalArea,*observation_--basalArea,, |
|
| 185 |
*observation_--hydrologicRegime,*observation_--hydrologicRegime,, |
|
| 186 |
*observation_--soilMoistureRegime,*observation_--soilMoistureRegime,, |
|
| 187 |
*observation_--soilDrainage,*observation_--soilDrainage,, |
|
| 188 |
*observation_--waterSalinity,*observation_--waterSalinity,, |
|
| 189 |
*observation_--waterDepth,*observation_--waterDepth,, |
|
| 190 |
*observation_--shoreDistance,*observation_--shoreDistance,, |
|
| 191 |
*observation_--soilDepth,*observation_--soilDepth,, |
|
| 192 |
*observation_--organicDepth,*observation_--organicDepth,, |
|
| 193 |
*observation_--SOILTAXON_ID,*observation_--SOILTAXON_ID,, |
|
| 194 |
*observation_--soilTaxonSrc,*observation_--soilTaxonSrc,, |
|
| 195 |
*observation_--soilTaxonComplex,*observation_--soilTaxonComplex,, |
|
| 196 |
*observation_--soilMapUnit,*observation_--soilMapUnit,, |
|
| 197 |
*observation_--percentBedRock,*observation_--percentBedRock,, |
|
| 198 |
*observation_--percentRockGravel,*observation_--percentRockGravel,, |
|
| 199 |
*observation_--percentWood,*observation_--percentWood,, |
|
| 200 |
*observation_--percentLitter,*observation_--percentLitter,, |
|
| 201 |
*observation_--percentBareSoil,*observation_--percentBareSoil,, |
|
| 202 |
*observation_--percentWater,*observation_--percentWater,, |
|
| 203 |
*observation_--percentOther,*observation_--percentOther,, |
|
| 204 |
*observation_--nameOther,*observation_--nameOther,, |
|
| 205 |
*observation_--treeHt,*observation_--treeHt,, |
|
| 206 |
*observation_--shrubHt,*observation_--shrubHt,, |
|
| 207 |
*observation_--fieldHt,*observation_--fieldHt,, |
|
| 208 |
*observation_--nonvascularHt,*observation_--nonvascularHt,, |
|
| 209 |
*observation_--submergedHt,*observation_--submergedHt,, |
|
| 210 |
*observation_--treeCover,*observation_--treeCover,, |
|
| 211 |
*observation_--shrubCover,*observation_--shrubCover,, |
|
| 212 |
*observation_--fieldCover,*observation_--fieldCover,, |
|
| 213 |
*observation_--nonvascularCover,*observation_--nonvascularCover,, |
|
| 214 |
*observation_--floatingCover,*observation_--floatingCover,, |
|
| 215 |
*observation_--submergedCover,*observation_--submergedCover,, |
|
| 216 |
*observation_--dominantStratum,*observation_--dominantStratum,, |
|
| 217 |
*observation_--growthform1Type,*observation_--growthform1Type,, |
|
| 218 |
*observation_--growthform2Type,*observation_--growthform2Type,, |
|
| 219 |
*observation_--growthform3Type,*observation_--growthform3Type,, |
|
| 220 |
*observation_--growthform1Cover,*observation_--growthform1Cover,, |
|
| 221 |
*observation_--growthform2Cover,*observation_--growthform2Cover,, |
|
| 222 |
*observation_--growthform3Cover,*observation_--growthform3Cover,, |
|
| 223 |
*observation_--totalCover,*observation_--totalCover,, |
|
| 224 |
*observation_--accessionCode,*observation_--accessionCode,, |
|
| 225 |
*observation_--notesPublic,*observation_--notesPublic,, |
|
| 226 |
*observation_--notesMgt,*observation_--notesMgt,, |
|
| 227 |
*observation_--revisions,*observation_--revisions,, |
|
| 228 |
*observation_--cust_cvs_CowardinSystem,*observation_--cust_cvs_CowardinSystem,, |
|
| 229 |
*observation_--cust_cvs_mcnab_LFI_asp,*observation_--cust_cvs_mcnab_LFI_asp,, |
|
| 230 |
*observation_--cust_cvs_mcnab_LFI_45,*observation_--cust_cvs_mcnab_LFI_45,, |
|
| 231 |
*observation_--cust_cvs_mcnab_LFI_90,*observation_--cust_cvs_mcnab_LFI_90,, |
|
| 232 |
*observation_--cust_cvs_mcnab_LFI_135,*observation_--cust_cvs_mcnab_LFI_135,, |
|
| 233 |
*observation_--cust_cvs_mcnab_LFI_180,*observation_--cust_cvs_mcnab_LFI_180,, |
|
| 234 |
*observation_--cust_cvs_mcnab_LFI_225,*observation_--cust_cvs_mcnab_LFI_225,, |
|
| 235 |
*observation_--cust_cvs_mcnab_LFI_270,*observation_--cust_cvs_mcnab_LFI_270,, |
|
| 236 |
*observation_--cust_cvs_mcnab_LFI_315,*observation_--cust_cvs_mcnab_LFI_315,, |
|
| 237 |
*observation_--cust_cvs_mcnab_TSI_asp,*observation_--cust_cvs_mcnab_TSI_asp,, |
|
| 238 |
*observation_--cust_cvs_mcnab_TSI_45,*observation_--cust_cvs_mcnab_TSI_45,, |
|
| 239 |
*observation_--cust_cvs_mcnab_TSI_90,*observation_--cust_cvs_mcnab_TSI_90,, |
|
| 240 |
*observation_--cust_cvs_mcnab_TSI_135,*observation_--cust_cvs_mcnab_TSI_135,, |
|
| 241 |
*observation_--cust_cvs_mcnab_TSI_180,*observation_--cust_cvs_mcnab_TSI_180,, |
|
| 242 |
*observation_--cust_cvs_mcnab_TSI_225,*observation_--cust_cvs_mcnab_TSI_225,, |
|
| 243 |
*observation_--cust_cvs_mcnab_TSI_270,*observation_--cust_cvs_mcnab_TSI_270,, |
|
| 244 |
*observation_--cust_cvs_mcnab_TSI_315,*observation_--cust_cvs_mcnab_TSI_315,, |
|
| 245 |
*observation_--cust_cvs_mcnab_LFI,*observation_--cust_cvs_mcnab_LFI,, |
|
| 246 |
*observation_--cust_cvs_mcnab_TSI,*observation_--cust_cvs_mcnab_TSI,, |
|
| 247 |
*observation_--cust_cvs_LeafType,*observation_--cust_cvs_LeafType,, |
|
| 248 |
*observation_--cust_cvs_LeafPhenology,*observation_--cust_cvs_LeafPhenology,, |
|
| 249 |
*observation_--cust_cvs_CanopyHeight,*observation_--cust_cvs_CanopyHeight,, |
|
| 250 |
*observation_--cust_cvs_compassType,*observation_--cust_cvs_compassType,, |
|
| 251 |
*observation_--cust_cvs_LocationSource,*observation_--cust_cvs_LocationSource,, |
|
| 252 |
*observation_--cust_cvs_GPSLocationX,*observation_--cust_cvs_GPSLocationX,, |
|
| 253 |
*observation_--cust_cvs_GPSLocationY,*observation_--cust_cvs_GPSLocationY,, |
|
| 254 |
*observation_--cust_cvs_Ownership,*observation_--cust_cvs_Ownership,, |
|
| 255 |
*observation_--cust_cvs_taxaRichness,*observation_--cust_cvs_taxaRichness,, |
|
| 256 |
*observation_--cust_cvs_lengthSoilProbe,*observation_--cust_cvs_lengthSoilProbe,, |
|
| 257 |
*observation_--cust_cvs_percentHistosol,*observation_--cust_cvs_percentHistosol,, |
|
| 258 |
*observation_--cust_cvs_percentBedrock,*observation_--cust_cvs_percentBedrock,, |
|
| 259 |
*observation_--cust_cvs_percentBoulder,*observation_--cust_cvs_percentBoulder,, |
|
| 260 |
*observation_--cust_cvs_percentGravelCobble,*observation_--cust_cvs_percentGravelCobble,, |
|
| 261 |
*observation_--cust_cvs_percentMineralSoil,*observation_--cust_cvs_percentMineralSoil,, |
|
| 262 |
*observation_--cust_cvs_percentCWD,*observation_--cust_cvs_percentCWD,, |
|
| 263 |
*observation_--cust_cvs_percentFWD,*observation_--cust_cvs_percentFWD,, |
|
| 264 |
*observation_--cust_cvs_percentDuff,*observation_--cust_cvs_percentDuff,, |
|
| 265 |
*observation_--cust_cvs_percentLitter,*observation_--cust_cvs_percentLitter,, |
|
| 266 |
*observation_--cust_cvs_percentNonVasc,*observation_--cust_cvs_percentNonVasc,, |
|
| 267 |
*observation_--cust_cvs_percentWater,*observation_--cust_cvs_percentWater,, |
|
| 268 |
*observation_--cust_cvs_percentOther,*observation_--cust_cvs_percentOther,, |
|
| 269 |
*observation_--cust_cvs_percentOtherName,*observation_--cust_cvs_percentOtherName,, |
|
| 270 |
*observation_--cust_cvs_samplingLevel,*observation_--cust_cvs_samplingLevel,, |
|
| 271 |
*observation_--cust_cvs_postDsgPoly,*observation_--cust_cvs_postDsgPoly,, |
|
| 272 |
*observation_--cust_cvs_stemsSampled,*observation_--cust_cvs_stemsSampled,, |
|
| 273 |
*observation_--cust_cvs_stemSamplingNarrative,*observation_--cust_cvs_stemSamplingNarrative,, |
|
| 274 |
*observation_--cust_eep_plotLastPlantedDate,*observation_--cust_eep_plotLastPlantedDate,, |
|
| 275 |
*observation_--cust_eep_plotNotSampled,*observation_--cust_eep_plotNotSampled,, |
|
| 276 |
*observation_--cust_eep_plotNotSampledReason,*observation_--cust_eep_plotNotSampledReason,, |
|
| 277 |
*observation_--entry_ares_herbs,*observation_--entry_ares_herbs,, |
|
| 278 |
*observation_--entry_ares_trees,*observation_--entry_ares_trees,, |
|
| 279 |
*observation_--entry_currentLandUse,*observation_--entry_currentLandUse,, |
|
| 280 |
*observation_--entry_depth,*observation_--entry_depth,, |
|
| 281 |
*observation_--entry_elevationUnits,*observation_--entry_elevationUnits,, |
|
| 282 |
*observation_--entry_formerLandUse,*observation_--entry_formerLandUse,, |
|
| 283 |
*observation_--entry_identificationNarrative,*observation_--entry_identificationNarrative,, |
|
| 284 |
*observation_--entry_IntensiveModuleList,*observation_--entry_IntensiveModuleList,, |
|
| 285 |
*observation_--entry_moduleSize_Overall,*observation_--entry_moduleSize_Overall,, |
|
| 286 |
*observation_--entry_moduleSizeX,*observation_--entry_moduleSizeX,, |
|
| 287 |
*observation_--entry_moduleSizeY,*observation_--entry_moduleSizeY,, |
|
| 288 |
*observation_--entry_photosTaken,*observation_--entry_photosTaken,, |
|
| 289 |
*observation_--entry_physClass,*observation_--entry_physClass,, |
|
| 290 |
*observation_--entry_plot_X,*observation_--entry_plot_X,, |
|
| 291 |
*observation_--entry_plot_Y,*observation_--entry_plot_Y,, |
|
| 292 |
*observation_--entry_soilModulesSampled,*observation_--entry_soilModulesSampled,, |
|
| 293 |
*observation_--entry_subsequentObsNum,*observation_--entry_subsequentObsNum,, |
|
| 294 |
*observation_--entry_taxonomicAuthority_ID,*observation_--entry_taxonomicAuthority_ID,, |
|
| 295 |
*observation_--entry_taxonomicAuthorityDate,*observation_--entry_taxonomicAuthorityDate,, |
|
| 296 |
*observation_--entry_team,*observation_--entry_team,, |
|
| 297 |
*observation_--entry_plot,*observation_--entry_plot,, |
|
| 298 |
*observation_--entry_numberOfModules,*observation_--entry_numberOfModules,, |
|
| 299 |
*observation_--errors,*observation_--errors,, |
|
| 300 |
*observation_--dba_src_ID,*observation_--dba_src_ID,, |
|
| 301 |
*observation_--dba_notes,*observation_--dba_notes,, |
|
| 302 |
*observation_--numberOfTaxa,*observation_--numberOfTaxa,, |
|
| 303 |
*observation_--SOILOBS_ID,*observation_--SOILOBS_ID,, |
|
| 304 |
*observation_--soilHorizon,*observation_--soilHorizon,, |
|
| 305 |
*observation_--soilDepthTop,*observation_--soilDepthTop,, |
|
| 306 |
*observation_--soilDepthBottom,*observation_--soilDepthBottom,, |
|
| 307 |
*observation_--soilColor,*observation_--soilColor,, |
|
| 308 |
organic_percent,organic_percent,, |
|
| 309 |
texture,texture,, |
|
| 310 |
sand_percent,sand_percent,, |
|
| 311 |
silt_percent,silt_percent,, |
|
| 312 |
clay_percent,clay_percent,, |
|
| 313 |
*observation_--soilCoarse,*observation_--soilCoarse,, |
|
| 314 |
ph,ph,, |
|
| 315 |
cationExchangeCapacity_cmol_kg,cationExchangeCapacity_cmol_kg,, |
|
| 316 |
baseSaturation_percent,baseSaturation_percent,, |
|
| 317 |
*observation_--soilDescription,*observation_--soilDescription,, |
|
| 318 |
*observation_--cust_cvs_collectionName,*observation_--cust_cvs_collectionName,, |
|
| 319 |
*observation_--cust_cvs_Lab,*observation_--cust_cvs_Lab,, |
|
| 320 |
*observation_--cust_cvs_N,*observation_--cust_cvs_N,, |
|
| 321 |
*observation_--cust_cvs_S,*observation_--cust_cvs_S,, |
|
| 322 |
*observation_--cust_cvs_P,*observation_--cust_cvs_P,, |
|
| 323 |
*observation_--cust_cvs_Ca_ppm,*observation_--cust_cvs_Ca_ppm,, |
|
| 324 |
*observation_--cust_cvs_Mg_ppm,*observation_--cust_cvs_Mg_ppm,, |
|
| 325 |
*observation_--cust_cvs_K_ppm,*observation_--cust_cvs_K_ppm,, |
|
| 326 |
*observation_--cust_cvs_Na_ppm,*observation_--cust_cvs_Na_ppm,, |
|
| 327 |
*observation_--cust_cvs_percent_Ca,*observation_--cust_cvs_percent_Ca,, |
|
| 328 |
*observation_--cust_cvs_percent_Mg,*observation_--cust_cvs_percent_Mg,, |
|
| 329 |
*observation_--cust_cvs_percent_K,*observation_--cust_cvs_percent_K,, |
|
| 330 |
*observation_--cust_cvs_percent_Na,*observation_--cust_cvs_percent_Na,, |
|
| 331 |
*observation_--cust_cvs_percent_Othr,*observation_--cust_cvs_percent_Othr,, |
|
| 332 |
*observation_--cust_cvs_percent_H,*observation_--cust_cvs_percent_H,, |
|
| 333 |
*observation_--cust_cvs_B_ppm,*observation_--cust_cvs_B_ppm,, |
|
| 334 |
*observation_--cust_cvs_Fe_ppm,*observation_--cust_cvs_Fe_ppm,, |
|
| 335 |
*observation_--cust_cvs_Mn_ppm,*observation_--cust_cvs_Mn_ppm,, |
|
| 336 |
*observation_--cust_cvs_Cu_ppm,*observation_--cust_cvs_Cu_ppm,, |
|
| 337 |
*observation_--cust_cvs_Zn_ppm,*observation_--cust_cvs_Zn_ppm,, |
|
| 338 |
*observation_--cust_cvs_Al_ppm,*observation_--cust_cvs_Al_ppm,, |
|
| 339 |
*observation_--cust_cvs_Density,*observation_--cust_cvs_Density,, |
|
| 340 |
*observation_--cust_cvs_Ca_over_Mg_ppm,*observation_--cust_cvs_Ca_over_Mg_ppm,, |
|
| 341 |
*observation_--soilObs_dba_src_ID,*observation_--soilObs_dba_src_ID,, |
|
| 342 |
locationName,locationName,, |
|
| 343 |
*plot_--reference_ID,*plot_--reference_ID,, |
|
| 344 |
parentLocationID,parentLocationID,, |
|
| 345 |
*plot_--plotObsolete,*plot_--plotObsolete,, |
|
| 346 |
*plot_--REPLACEMENTPLOT_ID,*plot_--REPLACEMENTPLOT_ID,, |
|
| 347 |
UNUSED#realLatitude,UNUSED#realLatitude,, |
|
| 348 |
UNUSED#realLongitude,UNUSED#realLongitude,, |
|
| 349 |
coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_coords,, |
|
| 350 |
accessRights_verbatim,accessRights_verbatim,, |
|
| 351 |
*plot_--confidentialityFieldsBlocked,*plot_--confidentialityFieldsBlocked,, |
|
| 352 |
*plot_--confidentialityReason,*plot_--confidentialityReason,, |
|
| 353 |
decimalLatitude,decimalLatitude,, |
|
| 354 |
decimalLongitude,decimalLongitude,, |
|
| 355 |
*plot_--authorCoordinateType,*plot_--authorCoordinateType,, |
|
| 356 |
*plot_--authorCoordinateUnits,*plot_--authorCoordinateUnits,, |
|
| 357 |
*plot_--authorE,*plot_--authorE,, |
|
| 358 |
*plot_--authorN,*plot_--authorN,, |
|
| 359 |
*plot_--authorZone,*plot_--authorZone,, |
|
| 360 |
*plot_--authorDatum,*plot_--authorDatum,, |
|
| 361 |
*plot_--authorLocation,*plot_--authorLocation,, |
|
| 362 |
locality,locality,, |
|
| 363 |
*plot_--plotRationaleNarrative,*plot_--plotRationaleNarrative,, |
|
| 364 |
*plot_--azimuth,*plot_--azimuth,, |
|
| 365 |
*plot_--dsgpoly,*plot_--dsgpoly,, |
|
| 366 |
footprintWKT,footprintWKT,, |
|
| 367 |
plotArea_m2,plotArea_m2,, |
|
| 368 |
*plot_--standSize,*plot_--standSize,, |
|
| 369 |
*plot_--placementMethod,*plot_--placementMethod,, |
|
| 370 |
*plot_--permanence,*plot_--permanence,, |
|
| 371 |
*plot_--layoutNarrative,*plot_--layoutNarrative,, |
|
| 372 |
elevationInMeters,elevationInMeters,, |
|
| 373 |
*plot_--elevationAccuracy,*plot_--elevationAccuracy,, |
|
| 374 |
UNUSED#elevationRange,UNUSED#elevationRange,, |
|
| 375 |
slopeAspect,slopeAspect,, |
|
| 376 |
minSlopeAspect,minSlopeAspect,, |
|
| 377 |
maxSlopeAspect,maxSlopeAspect,, |
|
| 378 |
slopeGradient,slopeGradient,, |
|
| 379 |
minSlopeGradient,minSlopeGradient,, |
|
| 380 |
maxSlopeGradient,maxSlopeGradient,, |
|
| 381 |
*plot_--topoPosition,*plot_--topoPosition,, |
|
| 382 |
landform,landform,, |
|
| 383 |
*plot_--surficialDeposits,*plot_--surficialDeposits,, |
|
| 384 |
*plot_--rockType,*plot_--rockType,, |
|
| 385 |
county,county,, |
|
| 386 |
*plot_--cust_cvs_province,*plot_--cust_cvs_province,, |
|
| 387 |
stateProvince,stateProvince,, |
|
| 388 |
country,country,, |
|
| 389 |
*plot_--dateentered,*plot_--dateentered,, |
|
| 390 |
*plot_--submitter_surname,*plot_--submitter_surname,, |
|
| 391 |
*plot_--submitter_givenname,*plot_--submitter_givenname,, |
|
| 392 |
*plot_--submitter_email,*plot_--submitter_email,, |
|
| 393 |
*plot_--accessionCode,*plot_--accessionCode,, |
|
| 394 |
*plot_--notesPublic,*plot_--notesPublic,, |
|
| 395 |
*plot_--notesMgt,*plot_--notesMgt,, |
|
| 396 |
*plot_--revisions,*plot_--revisions,, |
|
| 397 |
*plot_--cust_eep_reach,*plot_--cust_eep_reach,, |
|
| 398 |
*plot_--dba_src_ID,*plot_--dba_src_ID,, |
|
| 399 |
continent,continent,, |
|
| 400 |
DUPLICATE#of:COUNTRY#area|country|territory,DUPLICATE#of:COUNTRY#area|country|territory,, |
|
| 401 |
DUPLICATE#of:stateProvince#region|state|province,DUPLICATE#of:stateProvince#region|state|province,, |
|
| 402 |
DUPLICATE#of:county#county_,DUPLICATE#of:county#county_,, |
|
| 403 |
*plot_--quadrangle,*plot_--quadrangle,, |
|
| 404 |
*plot_--Geographic Name,*plot_--Geographic Name,, |
|
| 405 |
*plot_--River Basin,*plot_--River Basin,, |
|
| 406 |
accessRights,accessRights,, |
|
| 407 |
coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters__from_fuzzing,, |
|
| 408 |
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,, |
|
| 409 |
taxonOccurrenceID,taxonOccurrenceID,, |
|
| inputs/CVS/taxon_observation.**/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| inputs/CVS/taxon_observation.**/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CVS.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 |
<specimenreplicate> |
|
| 34 |
<catalognumber_dwc>$accessionNumber</catalognumber_dwc> |
|
| 35 |
<collectionnumber>$collectorNumber</collectionnumber> |
|
| 36 |
</specimenreplicate> |
|
| 37 |
<stemobservation> |
|
| 38 |
<diameterbreastheight_m><_cm_to_m><value>$diameterBreastHeight_cm</value></_cm_to_m></diameterbreastheight_m> |
|
| 39 |
<height_m>$height_m</height_m> |
|
| 40 |
<sourceaccessioncode>$stemID</sourceaccessioncode> |
|
| 41 |
</stemobservation> |
|
| 42 |
</plantobservation> |
|
| 43 |
<sourceaccessioncode>$aggregateOrganismObservationID</sourceaccessioncode> |
|
| 44 |
</aggregateoccurrence> |
|
| 45 |
<authortaxoncode>$collectorNumber</authortaxoncode> |
|
| 46 |
<sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode> |
|
| 47 |
<taxondetermination> |
|
| 48 |
<taxonverbatim_id> |
|
| 49 |
<taxonverbatim> |
|
| 50 |
<taxonlabel_id> |
|
| 51 |
<taxonlabel> |
|
| 52 |
<parent_id> |
|
| 53 |
<taxonlabel> |
|
| 54 |
<rank>$taxonRank</rank> |
|
| 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 |
<taxonepithet>$specificEpithet</taxonepithet> |
|
| 71 |
<parent_id> |
|
| 72 |
<taxonlabel> |
|
| 73 |
<rank>genus</rank> |
|
| 74 |
<taxonepithet>$genus</taxonepithet> |
|
| 75 |
<parent_id> |
|
| 76 |
<taxonlabel> |
|
| 77 |
<rank>family</rank> |
|
| 78 |
<taxonepithet>$family</taxonepithet> |
|
| 79 |
<parent_id> |
|
| 80 |
<taxonlabel> |
|
| 81 |
<rank>order</rank> |
|
| 82 |
<taxonepithet>$order</taxonepithet> |
|
| 83 |
<parent_id> |
|
| 84 |
<taxonlabel> |
|
| 85 |
<rank>class</rank> |
|
| 86 |
<taxonepithet>$class</taxonepithet> |
|
| 87 |
<parent_id> |
|
| 88 |
<taxonlabel> |
|
| 89 |
<rank>phylum</rank> |
|
| 90 |
<parent_id> |
|
| 91 |
<taxonlabel> |
|
| 92 |
<rank>kingdom</rank> |
|
| 93 |
<taxonepithet>$kingdom</taxonepithet> |
|
| 94 |
</taxonlabel> |
|
| 95 |
</parent_id> |
|
| 96 |
</taxonlabel> |
|
| 97 |
</parent_id> |
|
| 98 |
</taxonlabel> |
|
| 99 |
</parent_id> |
|
| 100 |
</taxonlabel> |
|
| 101 |
</parent_id> |
|
| 102 |
</taxonlabel> |
|
| 103 |
</parent_id> |
|
| 104 |
</taxonlabel> |
|
| 105 |
</parent_id> |
|
| 106 |
</taxonlabel> |
|
| 107 |
</parent_id> |
|
| 108 |
</taxonlabel> |
|
| 109 |
</parent_id> |
|
| 110 |
</taxonlabel> |
|
| 111 |
</parent_id> |
|
| 112 |
</taxonlabel> |
|
| 113 |
</parent_id> |
|
| 114 |
</taxonlabel> |
|
| 115 |
</parent_id> |
|
| 116 |
<taxonepithet>$infraspecificEpithet</taxonepithet> |
|
| 117 |
</taxonlabel> |
|
| 118 |
</parent_id> |
|
| 119 |
<rank>$taxonRank</rank> |
|
| 120 |
<taxonomicname> |
|
| 121 |
<_merge_prefix> |
|
| 122 |
<prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix> |
|
| 123 |
<value> |
|
| 124 |
<_alt> |
|
| 125 |
<1>$scientificName</1> |
|
| 126 |
<2> |
|
| 127 |
<_alt> |
|
| 128 |
<1>$taxonName</1> |
|
| 129 |
<2> |
|
| 130 |
<_join_words> |
|
| 131 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 132 |
<3>$specificEpithet</3> |
|
| 133 |
<5> |
|
| 134 |
<_join_words> |
|
| 135 |
<1> |
|
| 136 |
<_if name="if has infraspecificEpithet"> |
|
| 137 |
<cond>$infraspecificEpithet</cond> |
|
| 138 |
<then>$taxonRank</then> |
|
| 139 |
</_if> |
|
| 140 |
</1> |
|
| 141 |
<2>$infraspecificEpithet</2> |
|
| 142 |
</_join_words> |
|
| 143 |
</5> |
|
| 144 |
</_join_words> |
|
| 145 |
</2> |
|
| 146 |
</_alt> |
|
| 147 |
</2> |
|
| 148 |
</_alt> |
|
| 149 |
</value> |
|
| 150 |
</_merge_prefix> |
|
| 151 |
</taxonomicname> |
|
| 152 |
</taxonlabel> |
|
| 153 |
</taxonlabel_id> |
|
| 154 |
<family>$family</family> |
|
| 155 |
<genus>$genus</genus> |
|
| 156 |
<specific_epithet>$specificEpithet</specific_epithet> |
|
| 157 |
<taxonname>$taxonName</taxonname> |
|
| 158 |
<taxonomicname>$scientificName</taxonomicname> |
|
| 159 |
<verbatimrank>$taxonRank</verbatimrank> |
|
| 160 |
</taxonverbatim> |
|
| 161 |
</taxonverbatim_id> |
|
| 162 |
<determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate> |
|
| 163 |
<determinationtype>$identificationType</determinationtype> |
|
| 164 |
<iscurrent__verbatim>$taxon_determination__is_current</iscurrent__verbatim> |
|
| 165 |
<isoriginal>$taxon_determination__is_original</isoriginal> |
|
| 166 |
<taxonfit>$identificationQualifier</taxonfit> |
|
| 167 |
</taxondetermination> |
|
| 168 |
<taxondetermination> |
|
| 169 |
<isoriginal>true</isoriginal> |
|
| 170 |
<taxonverbatim_id><taxonverbatim><taxonname>$originalTaxonName</taxonname></taxonverbatim></taxonverbatim_id> |
|
| 171 |
</taxondetermination> |
|
| 172 |
</taxonoccurrence> |
|
| 173 |
</locationevent> |
|
| 174 |
<obsenddate>$endDate</obsenddate> |
|
| 175 |
<obsstartdate>$startDate</obsstartdate> |
|
| 176 |
<soilsample> |
|
| 177 |
<basesaturation_fraction><_percent_to_fraction><value>$baseSaturation_percent</value></_percent_to_fraction></basesaturation_fraction> |
|
| 178 |
<cationexchangecapacity_cmol_kg>$cationExchangeCapacity_cmol_kg</cationexchangecapacity_cmol_kg> |
|
| 179 |
<clay_fraction><_percent_to_fraction><value>$clay_percent</value></_percent_to_fraction></clay_fraction> |
|
| 180 |
<organic_fraction><_percent_to_fraction><value>$organic_percent</value></_percent_to_fraction></organic_fraction> |
|
| 181 |
<ph>$ph</ph> |
|
| 182 |
<sand_fraction><_percent_to_fraction><value>$sand_percent</value></_percent_to_fraction></sand_fraction> |
|
| 183 |
<silt_fraction><_percent_to_fraction><value>$silt_percent</value></_percent_to_fraction></silt_fraction> |
|
| 184 |
<texture>$texture</texture> |
|
| 185 |
</soilsample> |
|
| 186 |
</locationevent> |
|
| 187 |
<locationnarrative>$locality</locationnarrative> |
|
| 188 |
<locationplace> |
|
| 189 |
<place_id> |
|
| 190 |
<place> |
|
| 191 |
<coordinates_id> |
|
| 192 |
<coordinates> |
|
| 193 |
<coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m> |
|
| 194 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
|
| 195 |
<latitude_deg> |
|
| 196 |
<_nullIf> |
|
| 197 |
<null>0</null> |
|
| 198 |
<type>float</type> |
|
| 199 |
<value>$decimalLatitude</value> |
|
| 200 |
</_nullIf> |
|
| 201 |
</latitude_deg> |
|
| 202 |
<longitude_deg> |
|
| 203 |
<_nullIf> |
|
| 204 |
<null>0</null> |
|
| 205 |
<type>float</type> |
|
| 206 |
<value>$decimalLongitude</value> |
|
| 207 |
</_nullIf> |
|
| 208 |
</longitude_deg> |
|
| 209 |
</coordinates> |
|
| 210 |
</coordinates_id> |
|
| 211 |
<continent>$continent</continent> |
|
| 212 |
<country>$country</country> |
|
| 213 |
<county>$county</county> |
|
| 214 |
<matched_place_id> |
|
| 215 |
<place> |
|
| 216 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 217 |
<coordinates_id> |
|
| 218 |
<coordinates> |
|
| 219 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 220 |
<latitude_deg> |
|
| 221 |
<_nullIf> |
|
| 222 |
<null>0</null> |
|
| 223 |
<type>float</type> |
|
| 224 |
<value>$decimalLatitude</value> |
|
| 225 |
</_nullIf> |
|
| 226 |
</latitude_deg> |
|
| 227 |
<longitude_deg> |
|
| 228 |
<_nullIf> |
|
| 229 |
<null>0</null> |
|
| 230 |
<type>float</type> |
|
| 231 |
<value>$decimalLongitude</value> |
|
| 232 |
</_nullIf> |
|
| 233 |
</longitude_deg> |
|
| 234 |
</coordinates> |
|
| 235 |
</coordinates_id> |
|
| 236 |
<country>$country</country> |
|
| 237 |
<county>$county</county> |
|
| 238 |
<stateprovince>$stateProvince</stateprovince> |
|
| 239 |
</place> |
|
| 240 |
</matched_place_id> |
|
| 241 |
<stateprovince>$stateProvince</stateprovince> |
|
| 242 |
</place> |
|
| 243 |
</place_id> |
|
| 244 |
</locationplace> |
|
| 245 |
<parent_id><location><sourceaccessioncode>$parentLocationID</sourceaccessioncode></location></parent_id> |
|
| 246 |
<slopeaspect_deg> |
|
| 247 |
<_alt> |
|
| 248 |
<1><_compass><value>$slopeAspect</value></_compass></1> |
|
| 249 |
<2> |
|
| 250 |
<_avg> |
|
| 251 |
<1>$minSlopeAspect</1> |
|
| 252 |
<2>$maxSlopeAspect</2> |
|
| 253 |
</_avg> |
|
| 254 |
</2> |
|
| 255 |
</_alt> |
|
| 256 |
</slopeaspect_deg> |
|
| 257 |
<slopegradient_fraction> |
|
| 258 |
<_alt> |
|
| 259 |
<1>$slopeGradient</1> |
|
| 260 |
<2> |
|
| 261 |
<_avg> |
|
| 262 |
<1>$minSlopeGradient</1> |
|
| 263 |
<2>$maxSlopeGradient</2> |
|
| 264 |
</_avg> |
|
| 265 |
</2> |
|
| 266 |
</_alt> |
|
| 267 |
</slopegradient_fraction> |
|
| 268 |
</location> |
|
| 269 |
</path> |
|
| 270 |
</_simplifyPath> |
|
| 271 |
</path> |
|
| 272 |
</_setDefault> |
|
| 273 |
</VegBIEN> |
|
| 274 |
Inserted 34 new rows into database |
|
| inputs/CVS/taxon_observation.**/unmapped_terms.csv | ||
|---|---|---|
| 1 |
sort_col |
|
| 2 |
*STRATUMTYPE_ID |
|
| 3 |
*STRATUM_ID |
|
| 4 |
taxonOccurrenceID__overall_plot |
|
| 5 |
*taxonObservation_--PLANTCONCEPT_ID |
|
| 6 |
*taxonObservation_--taxonObservation_reference_ID |
|
| 7 |
*taxonObservation_--currentTaxonInterpPlantConcept_ID |
|
| 8 |
*taxonObservation_--taxonInferenceArea |
|
| 9 |
*taxonObservation_--taxonObservation_accessionCode |
|
| 10 |
*taxonObservation_--taxonObservation_dba_src_ID |
|
| 11 |
*taxonObservation_--cust_cvs_corner1Presence |
|
| 12 |
*taxonObservation_--cust_cvs_corner2Presence |
|
| 13 |
*taxonObservation_--cust_cvs_corner3Presence |
|
| 14 |
*taxonObservation_--cust_cvs_corner4Presence |
|
| 15 |
*taxonObservation_--cust_cvs_corner5Presence |
|
| 16 |
*taxonObservation_--entry_herbLineID |
|
| 17 |
*taxonObservation_--entry_treeLineID |
|
| 18 |
*taxonObservation_--taxonObservation_entry_sppID |
|
| 19 |
*taxonObservation_--entry_unknownSp |
|
| 20 |
*taxonObservation_--entry_sortOrder |
|
| 21 |
*taxonObservation_--cust_cvs_collectionFlag |
|
| 22 |
*taxonObservation_--taxonObservationNotes |
|
| 23 |
*taxonObservation_--temp_taxonUpToDate |
|
| 24 |
identificationID |
|
| 25 |
*taxonObservation_--taxonInterpretation_PLANTNAME_ID |
|
| 26 |
*taxonObservation_--taxonInterpretation_PARTY_ID |
|
| 27 |
*taxonObservation_--ROLE_ID |
|
| 28 |
*taxonObservation_--reference_ID |
|
| 29 |
identificationVerificationStatus |
|
| 30 |
*taxonObservation_--museum_ID |
|
| 31 |
*taxonObservation_--groupType |
|
| 32 |
*taxonObservation_--notesPublic |
|
| 33 |
*taxonObservation_--notesMgt |
|
| 34 |
*taxonObservation_--revisions |
|
| 35 |
*taxonObservation_--taxonInterpretation_dba_src_ID |
|
| 36 |
*taxonObservation_--taxonInterpretation_accessionCode |
|
| 37 |
*taxonObservation_--PLANTNAME_ID |
|
| 38 |
*taxonObservation_--plantConcept_reference_ID |
|
| 39 |
*taxonObservation_--plantCode |
|
| 40 |
*taxonObservation_--plantDescription |
|
| 41 |
*taxonObservation_--plantConcept_accessionCode |
|
| 42 |
*taxonObservation_--plantConcept_dba_src_ID |
|
| 43 |
*taxonObservation_--plantConcept_entry_sppID |
|
| 44 |
*taxonObservation_--USDAPlantsCode |
|
| 45 |
*taxonObservation_--VascularPlant |
|
| 46 |
division_main |
|
| 47 |
*taxonObservation_--category |
|
| 48 |
genus_main |
|
| 49 |
infraspecificRank |
|
| 50 |
infraspecificRank2 |
|
| 51 |
infraspecificEpithet2 |
|
| 52 |
*taxonObservation_--hybridX |
|
| 53 |
*taxonObservation_--lowestParentName |
|
| 54 |
*taxonObservation_--lowestParentConcept_ID |
|
| 55 |
*taxonObservation_--lowestChildRank |
|
| 56 |
vernacularName |
|
| 57 |
*taxonObservation_--growthForm_short |
|
| 58 |
*taxonObservation_--woody |
|
| 59 |
*taxonObservation_--exotic |
|
| 60 |
*taxonObservation_--usda_code |
|
| 61 |
*taxonObservation_--usda_growthForm |
|
| 62 |
*taxonObservation_--sensitiveSpeciesFuzzPlot |
|
| 63 |
*taxonObservation_--Subkingdom |
|
| 64 |
division_normalized |
|
| 65 |
*taxonObservation_--Subclass |
|
| 66 |
*taxonObservation_--composite family |
|
| 67 |
*taxonObservation_--tribe |
|
| 68 |
*taxonObservation_--composite genus |
|
| 69 |
genus_normalized |
|
| 70 |
subgenus |
|
| 71 |
*taxonObservation_--section |
|
| 72 |
*taxonObservation_--composite species |
|
| 73 |
speciesBinomial |
|
| 74 |
*taxonObservation_--division |
|
| 75 |
aggregateOrganismObservationID__taxon_presence |
|
| 76 |
*stemCount_--basalarea |
|
| 77 |
*stemCount_--biomass |
|
| 78 |
*stemCount_--inferencearea |
|
| 79 |
*stemCount_--cust_cvs_StemFrequency |
|
| 80 |
*stemCount_--taxonImportance_dba_src_ID |
|
| 81 |
*stemCount_--taxonImportance_entry_herbLineID |
|
| 82 |
*stemCount_--taxonImportance_entry_treeLineID |
|
| 83 |
*stemCount_--cust_cvs_corner1Presence |
|
| 84 |
*stemCount_--cust_cvs_corner2Presence |
|
| 85 |
*stemCount_--cust_cvs_corner3Presence |
|
| 86 |
*stemCount_--cust_cvs_corner4Presence |
|
| 87 |
*stemCount_--cust_cvs_corner5Presence |
|
| 88 |
*stemCount_--cust_cvs_originalCoverCode |
|
| 89 |
aggregateOrganismObservationID__individual_count |
|
| 90 |
*stemCount_--stemdiameteraccuracy |
|
| 91 |
*stemCount_--stemheightaccuracy |
|
| 92 |
*stemCount_--stemtaxonarea |
|
| 93 |
*stemCount_--stemCount_dba_src_ID |
|
| 94 |
*stemCount_--cust_cvs_ddh |
|
| 95 |
*stemCount_--cust_cvs_ddhAccuracy |
|
| 96 |
*stemCount_--cust_cvs_isPlanted |
|
| 97 |
*stemCount_--cust_cvs_subsamplingFactor |
|
| 98 |
*stemCount_--stemCount_entry_herbLineID |
|
| 99 |
*stemCount_--stemCount_entry_treeLineID |
|
| 100 |
*stemCount_--entry_recordCount |
|
| 101 |
*stemCount_--entry_sortOrder |
|
| 102 |
*stratum--OBSERVATION_ID |
|
| 103 |
*stratum--STRATUMMETHOD_ID |
|
| 104 |
*stratum--stratumName |
|
| 105 |
*stratum--stratumHeight |
|
| 106 |
*stratum--stratumBase |
|
| 107 |
*stratum--stratumCover |
|
| 108 |
*stratum--stratumDescription |
|
| 109 |
*stratum--dba_src_ID |
|
| 110 |
*stratum--stratumArea |
|
| 111 |
*stratum--stratumLabel |
|
| 112 |
*stratumType--STRATUMMETHOD_ID |
|
| 113 |
*stratumType--stratumIndex |
|
| 114 |
*stratumType--stratumDescription |
|
| 115 |
*stratumType--dba_src_ID |
|
| 116 |
*stratumType--stratumOrder |
|
| 117 |
*observation_--PREVIOUSOBS_ID |
|
| 118 |
*observation_--dateAccuracy |
|
| 119 |
*observation_--dateEntered |
|
| 120 |
*observation_--COVERMETHOD_ID |
|
| 121 |
*observation_--coverDispersion |
|
| 122 |
*observation_--autoTaxonCover |
|
| 123 |
*observation_--STRATUMMETHOD_ID |
|
| 124 |
*observation_--taxonObservationArea |
|
| 125 |
*observation_--stemSizeLimit |
|
| 126 |
*observation_--stemObservationArea |
|
| 127 |
*observation_--stemSampleMethod |
|
| 128 |
*observation_--originalData |
|
| 129 |
*observation_--effortLevel |
|
| 130 |
*observation_--plotValidationLevel |
|
| 131 |
*observation_--floristicQuality |
|
| 132 |
*observation_--bryophyteQuality |
|
| 133 |
*observation_--lichenQuality |
|
| 134 |
*observation_--observationNarrative |
|
| 135 |
*observation_--landscapeNarrative |
|
| 136 |
*observation_--homogeneity |
|
| 137 |
*observation_--phenologicAspect |
|
| 138 |
*observation_--representativeness |
|
| 139 |
*observation_--standMaturity |
|
| 140 |
*observation_--successionalStatus |
|
| 141 |
*observation_--basalArea |
|
| 142 |
*observation_--hydrologicRegime |
|
| 143 |
*observation_--soilMoistureRegime |
|
| 144 |
*observation_--soilDrainage |
|
| 145 |
*observation_--waterSalinity |
|
| 146 |
*observation_--waterDepth |
|
| 147 |
*observation_--shoreDistance |
|
| 148 |
*observation_--soilDepth |
|
| 149 |
*observation_--organicDepth |
|
| 150 |
*observation_--SOILTAXON_ID |
|
| 151 |
*observation_--soilTaxonSrc |
|
| 152 |
*observation_--soilTaxonComplex |
|
| 153 |
*observation_--soilMapUnit |
|
| 154 |
*observation_--percentBedRock |
|
| 155 |
*observation_--percentRockGravel |
|
| 156 |
*observation_--percentWood |
|
| 157 |
*observation_--percentLitter |
|
| 158 |
*observation_--percentBareSoil |
|
| 159 |
*observation_--percentWater |
|
| 160 |
*observation_--percentOther |
|
| 161 |
*observation_--nameOther |
|
| 162 |
*observation_--treeHt |
|
| 163 |
*observation_--shrubHt |
|
| 164 |
*observation_--fieldHt |
|
| 165 |
*observation_--nonvascularHt |
|
| 166 |
*observation_--submergedHt |
|
| 167 |
*observation_--treeCover |
|
| 168 |
*observation_--shrubCover |
|
| 169 |
*observation_--fieldCover |
|
| 170 |
*observation_--nonvascularCover |
|
| 171 |
*observation_--floatingCover |
|
| 172 |
*observation_--submergedCover |
|
| 173 |
*observation_--dominantStratum |
|
| 174 |
*observation_--growthform1Type |
|
| 175 |
*observation_--growthform2Type |
|
| 176 |
*observation_--growthform3Type |
|
| 177 |
*observation_--growthform1Cover |
|
| 178 |
*observation_--growthform2Cover |
|
| 179 |
*observation_--growthform3Cover |
|
| 180 |
*observation_--totalCover |
|
| 181 |
*observation_--accessionCode |
|
| 182 |
*observation_--notesPublic |
|
| 183 |
*observation_--notesMgt |
|
| 184 |
*observation_--revisions |
|
| 185 |
*observation_--cust_cvs_CowardinSystem |
|
| 186 |
*observation_--cust_cvs_mcnab_LFI_asp |
|
| 187 |
*observation_--cust_cvs_mcnab_LFI_45 |
|
| 188 |
*observation_--cust_cvs_mcnab_LFI_90 |
|
| 189 |
*observation_--cust_cvs_mcnab_LFI_135 |
|
| 190 |
*observation_--cust_cvs_mcnab_LFI_180 |
|
| 191 |
*observation_--cust_cvs_mcnab_LFI_225 |
|
| 192 |
*observation_--cust_cvs_mcnab_LFI_270 |
|
| 193 |
*observation_--cust_cvs_mcnab_LFI_315 |
|
| 194 |
*observation_--cust_cvs_mcnab_TSI_asp |
|
| 195 |
*observation_--cust_cvs_mcnab_TSI_45 |
|
| 196 |
*observation_--cust_cvs_mcnab_TSI_90 |
|
| 197 |
*observation_--cust_cvs_mcnab_TSI_135 |
|
| 198 |
*observation_--cust_cvs_mcnab_TSI_180 |
|
| 199 |
*observation_--cust_cvs_mcnab_TSI_225 |
|
| 200 |
*observation_--cust_cvs_mcnab_TSI_270 |
|
| 201 |
*observation_--cust_cvs_mcnab_TSI_315 |
|
| 202 |
*observation_--cust_cvs_mcnab_LFI |
|
| 203 |
*observation_--cust_cvs_mcnab_TSI |
|
| 204 |
*observation_--cust_cvs_LeafType |
|
| 205 |
*observation_--cust_cvs_LeafPhenology |
|
| 206 |
*observation_--cust_cvs_CanopyHeight |
|
| 207 |
*observation_--cust_cvs_compassType |
|
| 208 |
*observation_--cust_cvs_LocationSource |
|
| 209 |
*observation_--cust_cvs_GPSLocationX |
|
| 210 |
*observation_--cust_cvs_GPSLocationY |
|
| 211 |
*observation_--cust_cvs_Ownership |
|
| 212 |
*observation_--cust_cvs_taxaRichness |
|
| 213 |
*observation_--cust_cvs_lengthSoilProbe |
|
| 214 |
*observation_--cust_cvs_percentHistosol |
|
| 215 |
*observation_--cust_cvs_percentBedrock |
|
| 216 |
*observation_--cust_cvs_percentBoulder |
|
| 217 |
*observation_--cust_cvs_percentGravelCobble |
|
| 218 |
*observation_--cust_cvs_percentMineralSoil |
|
| 219 |
*observation_--cust_cvs_percentCWD |
|
| 220 |
*observation_--cust_cvs_percentFWD |
|
| 221 |
*observation_--cust_cvs_percentDuff |
|
| 222 |
*observation_--cust_cvs_percentLitter |
|
| 223 |
*observation_--cust_cvs_percentNonVasc |
|
| 224 |
*observation_--cust_cvs_percentWater |
|
| 225 |
*observation_--cust_cvs_percentOther |
|
| 226 |
*observation_--cust_cvs_percentOtherName |
|
| 227 |
*observation_--cust_cvs_samplingLevel |
|
| 228 |
*observation_--cust_cvs_postDsgPoly |
|
| 229 |
*observation_--cust_cvs_stemsSampled |
|
| 230 |
*observation_--cust_cvs_stemSamplingNarrative |
|
| 231 |
*observation_--cust_eep_plotLastPlantedDate |
|
| 232 |
*observation_--cust_eep_plotNotSampled |
|
| 233 |
*observation_--cust_eep_plotNotSampledReason |
|
| 234 |
*observation_--entry_ares_herbs |
|
| 235 |
*observation_--entry_ares_trees |
|
| 236 |
*observation_--entry_currentLandUse |
|
| 237 |
*observation_--entry_depth |
|
| 238 |
*observation_--entry_elevationUnits |
|
| 239 |
*observation_--entry_formerLandUse |
|
| 240 |
*observation_--entry_identificationNarrative |
|
| 241 |
*observation_--entry_IntensiveModuleList |
|
| 242 |
*observation_--entry_moduleSize_Overall |
|
| 243 |
*observation_--entry_moduleSizeX |
|
| 244 |
*observation_--entry_moduleSizeY |
|
| 245 |
*observation_--entry_photosTaken |
|
| 246 |
*observation_--entry_physClass |
|
| 247 |
*observation_--entry_plot_X |
|
| 248 |
*observation_--entry_plot_Y |
|
| 249 |
*observation_--entry_soilModulesSampled |
|
| 250 |
*observation_--entry_subsequentObsNum |
|
| 251 |
*observation_--entry_taxonomicAuthority_ID |
|
| 252 |
*observation_--entry_taxonomicAuthorityDate |
|
| 253 |
*observation_--entry_team |
|
| 254 |
*observation_--entry_plot |
|
| 255 |
*observation_--entry_numberOfModules |
|
| 256 |
*observation_--errors |
|
| 257 |
*observation_--dba_src_ID |
|
| 258 |
*observation_--dba_notes |
|
| 259 |
*observation_--numberOfTaxa |
|
| 260 |
*observation_--SOILOBS_ID |
|
| 261 |
*observation_--soilHorizon |
|
| 262 |
*observation_--soilDepthTop |
|
| 263 |
*observation_--soilDepthBottom |
|
| 264 |
*observation_--soilColor |
|
| 265 |
*observation_--soilCoarse |
|
| 266 |
*observation_--soilDescription |
|
| 267 |
*observation_--cust_cvs_collectionName |
|
| 268 |
*observation_--cust_cvs_Lab |
|
| 269 |
*observation_--cust_cvs_N |
|
| 270 |
*observation_--cust_cvs_S |
|
| 271 |
*observation_--cust_cvs_P |
|
| 272 |
*observation_--cust_cvs_Ca_ppm |
|
| 273 |
*observation_--cust_cvs_Mg_ppm |
|
| 274 |
*observation_--cust_cvs_K_ppm |
|
| 275 |
*observation_--cust_cvs_Na_ppm |
|
| 276 |
*observation_--cust_cvs_percent_Ca |
|
| 277 |
*observation_--cust_cvs_percent_Mg |
|
| 278 |
*observation_--cust_cvs_percent_K |
|
| 279 |
*observation_--cust_cvs_percent_Na |
|
| 280 |
*observation_--cust_cvs_percent_Othr |
|
| 281 |
*observation_--cust_cvs_percent_H |
|
| 282 |
*observation_--cust_cvs_B_ppm |
|
| 283 |
*observation_--cust_cvs_Fe_ppm |
|
| 284 |
*observation_--cust_cvs_Mn_ppm |
|
| 285 |
*observation_--cust_cvs_Cu_ppm |
|
| 286 |
*observation_--cust_cvs_Zn_ppm |
|
| 287 |
*observation_--cust_cvs_Al_ppm |
|
| 288 |
*observation_--cust_cvs_Density |
|
| 289 |
*observation_--cust_cvs_Ca_over_Mg_ppm |
|
| 290 |
*observation_--soilObs_dba_src_ID |
|
| 291 |
*plot_--reference_ID |
|
| 292 |
*plot_--plotObsolete |
|
| 293 |
*plot_--REPLACEMENTPLOT_ID |
|
| 294 |
coordinateUncertaintyInMeters__from_coords |
|
| 295 |
accessRights_verbatim |
|
| 296 |
*plot_--confidentialityFieldsBlocked |
|
| 297 |
*plot_--confidentialityReason |
|
| 298 |
*plot_--authorCoordinateType |
|
| 299 |
*plot_--authorCoordinateUnits |
|
| 300 |
*plot_--authorE |
|
| 301 |
*plot_--authorN |
|
| 302 |
*plot_--authorZone |
|
| 303 |
*plot_--authorDatum |
|
| 304 |
*plot_--authorLocation |
|
| 305 |
*plot_--plotRationaleNarrative |
|
| 306 |
*plot_--azimuth |
|
| 307 |
*plot_--dsgpoly |
|
| 308 |
*plot_--standSize |
|
| 309 |
*plot_--placementMethod |
|
| 310 |
*plot_--permanence |
|
| 311 |
*plot_--layoutNarrative |
|
| 312 |
*plot_--elevationAccuracy |
|
| 313 |
*plot_--topoPosition |
|
| 314 |
*plot_--surficialDeposits |
|
| 315 |
*plot_--rockType |
|
| 316 |
*plot_--cust_cvs_province |
|
| 317 |
*plot_--dateentered |
|
| 318 |
*plot_--submitter_surname |
|
| 319 |
*plot_--submitter_givenname |
|
| 320 |
*plot_--submitter_email |
|
| 321 |
*plot_--accessionCode |
|
| 322 |
*plot_--notesPublic |
|
| 323 |
*plot_--notesMgt |
|
| 324 |
*plot_--revisions |
|
| 325 |
*plot_--cust_eep_reach |
|
| 326 |
*plot_--dba_src_ID |
|
| 327 |
*plot_--quadrangle |
|
| 328 |
*plot_--Geographic Name |
|
| 329 |
*plot_--River Basin |
|
| 330 |
coordinateUncertaintyInMeters__from_fuzzing |
|
Also available in: Unified diff
inputs/CVS/: added taxon_observation.** left-join of the tables, using the steps at http://wiki.vegpath.org/Left-joining_a_datasource. this involves renaming taxonOccurrenceID->taxonOccurrenceID__overall_plot so that it can then be joined together with aggregateOrganismObservationID to create the full taxonOccurrenceID (as in VegBank).