sort_col,projectID,locationID,eventID,*STRATUMTYPE_ID,*STRATUM_ID,taxonOccurrenceID__overall_plot,*taxonObservation_--PLANTCONCEPT_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,OMIT#authorPlantName,*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_--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_--party--salutation,identifiedBy__first,identifiedBy__middle,identifiedBy__last,*taxonObservation_--party--suffix,*taxonObservation_--party--entry_userInitials,*taxonObservation_--party--organizationName,*taxonObservation_--party--currentName_ID,*taxonObservation_--party--contactInstructions,*taxonObservation_--party--email,*taxonObservation_--party--accessionCode,*taxonObservation_--party--partyType,*taxonObservation_--party--dba_src_ID,*taxonObservation_--party--dba_unsure,*plantConcept_--PLANTNAME_ID,*plantConcept_--plantConcept_reference_ID,taxonName,scientificName,*plantConcept_--plantCode,*plantConcept_--plantDescription,*plantConcept_--plantConcept_accessionCode,*plantConcept_--plantConcept_dba_src_ID,*plantConcept_--plantConcept_entry_sppID,*plantConcept_--USDAPlantsCode,*plantConcept_--VascularPlant,kingdom,division_main,*plantConcept_--category,family,genus_main,specificEpithet,infraspecificRank,infraspecificEpithet,infraspecificRank2,infraspecificEpithet2,*hybridX,taxonRank,OMIT#taxonRank,*plantConcept_--lowestParentName,*plantConcept_--lowestParentConcept_ID,*plantConcept_--lowestChildRank,vernacularName,*plantConcept_--growthForm_short,*plantConcept_--woody,*plantConcept_--exotic,*plantConcept_--usda_code,*plantConcept_--usda_growthForm,*plantConcept_--sensitiveSpeciesFuzzPlot,DUPLICATE#of:denorm_kingdom#Kingdom,*Subkingdom,division_normalized,class,*Subclass,order,*composite family,DUPLICATE#of:denorm_family#family,*tribe,*composite genus,genus_normalized,subgenus,*section,*composite species,speciesBinomial,EQUIV#to:species#subspecies,EQUIV#to:species#composite variety,EQUIV#to:species#variety,*division,genus,observationGranularity,identifiedBy,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,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,UNUSED#PARENT_ID,*plot_--plotObsolete,*plot_--REPLACEMENTPLOT_ID,coordinateUncertaintyInMeters__from_coords,accessRights_verbatim,*plot_--confidentialityFieldsBlocked,*plot_--confidentialityReason,decimalLatitude,decimalLongitude,*plot_--authorCoordinateType,*plot_--authorCoordinateUnits,*plot_--authorE,*plot_--authorN,*plot_--authorZone,*plot_--authorDatum,site_name,directions_to_place,*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,locality,projectName,*project--projectDescription,projectStartDate,projectEndDate,*project--accessionCode,*project--dba_src_ID,*project--entry_projectCode,*project--entry_projectCodeSource,*project--entry_contactDetails,*project--entry_eep_length,*project--entry_eep_width,*project--entry_eep_area,*project--entry_eep_requiredPlots,*project--entry_eep_projectType,*project--entry_riverBasin_np_ID,taxonOccurrenceID

NATURAL LEFT JOIN project

projectID,projectID,,

projectName,projectName,,

*project--projectDescription,*project--projectDescription,,

projectStartDate,projectStartDate,,

projectEndDate,projectEndDate,,

*project--accessionCode,*project--accessionCode,,

*project--dba_src_ID,*project--dba_src_ID,,

*project--entry_projectCode,*project--entry_projectCode,,

*project--entry_projectCodeSource,*project--entry_projectCodeSource,,

*project--entry_contactDetails,*project--entry_contactDetails,,

*project--entry_eep_length,*project--entry_eep_length,,

*project--entry_eep_width,*project--entry_eep_width,,

*project--entry_eep_area,*project--entry_eep_area,,

*project--entry_eep_requiredPlots,*project--entry_eep_requiredPlots,,

*project--entry_eep_projectType,*project--entry_eep_projectType,,

*project--entry_riverBasin_np_ID,*project--entry_riverBasin_np_ID,,

                            <project_id>

                                <project>

                                    <projectname>$projectName</projectname>

                                    <sourceaccessioncode>$projectID</sourceaccessioncode>

                                    <startdate>$projectStartDate</startdate>

                                    <stopdate>$projectEndDate</stopdate>

                                </project>

                            </project_id>

*project--projectDescription

*project--accessionCode

*project--dba_src_ID

*project--entry_projectCode

*project--entry_projectCodeSource

*project--entry_contactDetails

*project--entry_eep_length

*project--entry_eep_width

*project--entry_eep_area

*project--entry_eep_requiredPlots

*project--entry_eep_projectType

*project--entry_riverBasin_np_ID