stratumname,stratum__name,,

sort_col,locationID,eventID,*stratumtype_id,*stratum_id,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,taxonOccurrenceID,*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,*taxonobservation_--plantconcept_reference_id,scientificName__for_nearest_taxon_concept,*taxonobservation_--plantcode,*taxonobservation_--plantdescription,*taxonobservation_--d_obscount,*taxonobservation_--d_currentaccepted,*taxonobservation_--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,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

stratum__name,stratum__name,,

<meta content="k2WFMqKceqJ3OEvNe6iUOYLlU3M9FuY0FjDyfMY0JRM=" name="csrf-token" />

	<p>The schema makes extensive use of inheritance, which can be implemented in <a href="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database#3579462" class="external">several ways</a>. The tables are shown in the ERD using <a href="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database#3579462" class="external">class table inheritance</a> (option 3 in the link), which is considered the best practice for most database engines. However, <em>if and only if</em> <a href="http://www.postgresql.org/docs/9.1/static/ddl-inherit.html" class="external">PostgreSQL-style inheritance</a> is available, it's actually better to use <a href="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database#3579462" class="external">concrete table inheritance</a> (option 2), which avoids both the need to insert into each superclass table separately, and the need to join to superclass tables when selecting<sup><a href="#fn1">1</a></sup>. When this is not available, you can also get these benefits via <a href="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database#3579462" class="external">single table inheritance</a> (option 1, which is the denormalized, full_occurrence format) at the expense of not having separate tables for the separate subclasses.</p>

	<p id="fn1" class="footnote"><sup>1</sup> at the cost of slightly slower index scans when there is a large number of subclasses and rows are evenly distributed between them (because each subclass index needs to be scanned separately)</p>

	<p><a href="http://VegCore.vegpath.org/ERD/"><img src="http://vegpath.org/VegCore/ERD/VegCore.ERD.png" title="VegCore schema: click for hyperlinked version" alt="VegCore schema: click for hyperlinked version" /></a></p>

	<p><a href="#Source" class="wiki-page">Source</a><br /><a href="#Dataset" class="wiki-page">Dataset</a><br /><a href="#Record" class="wiki-page">Record</a><br /><a href="#Occurrence" class="wiki-page">Occurrence</a><br /><a href="#Method" class="wiki-page">Method</a><br /><a href="#Stratum" class="wiki-page">Stratum</a><br /><a href="#Project" class="wiki-page">Project</a><br /><a href="#Event" class="wiki-page">Event</a><br /><a href="#Coordinates" class="wiki-page">Coordinates</a><br /><a href="#Placename" class="wiki-page">Placename</a><br /><a href="#Geovalidation" class="wiki-page">Geovalidation</a><br /><a href="#Location" class="wiki-page">Location</a><br /><a href="#LocationObservation" class="wiki-page">LocationObservation</a><br /><a href="#Subplot" class="wiki-page">Subplot</a><br /><a href="#SubplotObservation" class="wiki-page">SubplotObservation</a><br /><a href="#SoilObservation" class="wiki-page">SoilObservation</a><br /><a href="#GeologicalContext" class="wiki-page">GeologicalContext</a><br /><a href="#Community" class="wiki-page">Community</a><br /><a href="#TaxonName" class="wiki-page">TaxonName</a><br /><a href="#TaxonConcept" class="wiki-page">TaxonConcept</a><br /><a href="#QualifiedTaxonName" class="wiki-page">QualifiedTaxonName</a><br /><a href="#MatchedTaxon" class="wiki-page">MatchedTaxon</a><br /><a href="#AcceptedTaxon" class="wiki-page">AcceptedTaxon</a><br /><a href="#TaxonOccurrence" class="wiki-page">TaxonOccurrence</a><br /><a href="#TaxonDetermination" class="wiki-page">TaxonDetermination</a><br /><a href="#OriginalTaxonDetermination" class="wiki-page">OriginalTaxonDetermination</a><br /><a href="#TaxonObservation" class="wiki-page">TaxonObservation</a><br /><a href="#AggregateObservation" class="wiki-page">AggregateObservation</a><br /><a href="#Individual" class="wiki-page">Individual</a><br /><a href="#IndividualObservation" class="wiki-page">IndividualObservation</a><br /><a href="#Stem" class="wiki-page">Stem</a><br /><a href="#StemObservation" class="wiki-page">StemObservation</a><br /><a href="#Collection" class="wiki-page">Collection</a><br /><a href="#Specimen" class="wiki-page">Specimen</a><br /><a href="#Voucher" class="wiki-page">Voucher</a><br /><a href="#Measurement" class="wiki-page">Measurement</a><br /><a href="#ResourceRelationship" class="wiki-page">ResourceRelationship</a></p>

	<a name="pubDate"></a>

<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#pubDate" class="wiki-page">pubDate</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&#38;wparam=reference&#38;entity=dba_tabledescription&#38;where=where_tablename#pubDate"><img src="_" style="font-size: small;" title="VegBank" alt="VegBank" /></a><a href="#pubDate" class="wiki-anchor">&para;</a></h3>

	<a name="Stratum"></a>

<h1 ><a href="#Stratum" class="wiki-page">Stratum</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://VegX.vegpath.org?stratum"><img src="_" style="font-size: small;" title="VegX" alt="VegX" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="http://VegBank.vegpath.org?stratumType"><img src="_" style="font-size: small;" title="VegBank" alt="VegBank" /></a><a href="#Stratum" class="wiki-anchor">&para;</a></h1>

	<p style="padding-left:3em;">a non-horizontal way of subdividing a plot</p>

	<a name="stratum__name"></a>

<h2  style="padding-left:2em;"><a href="#stratum__name" class="wiki-page">stratum__name</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://VegX.vegpath.org?stratum.stratumName"><img src="_" style="font-size: small;" title="VegX" alt="VegX" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="http://VegBank.vegpath.org?stratumType.stratumName"><img src="_" style="font-size: small;" title="VegBank" alt="VegBank" /></a><a href="#stratum__name" class="wiki-anchor">&para;</a></h2>

[[VegCore#Stratum|Stratum]]

Stratum

stratum__name,,

pubDate,source__modified_date

stratum__name,,

pubDate

stratum__name