<meta name="description" content="Redmine" />

<meta name="keywords" content="issue,bug,tracker" />

<meta content="authenticity_token" name="csrf-param" />

<link rel='shortcut icon' href='/nceas/favicon.ico?1347421715' />

<link href="/nceas/stylesheets/jquery/jquery-ui-1.9.2.css?1364512407" media="all" rel="stylesheet" type="text/css" />

<link href="/nceas/stylesheets/application.css?1364512407" media="all" rel="stylesheet" type="text/css" />

</form>        

    </div>

    <div id="main-menu">

        <ul><li><a href="/nceas/projects/bien" class="overview">Overview</a></li>

	<p id="fn2" class="footnote"><sup>2</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).<br />also, when inserting into a subclass, you need to explicitly check that the pkey doesn't exist in any superclass (or sibling subclass), because unique indexes don't include superclass rows.</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>

<h2  style="padding-left:2em;"><a href="#event__participant" class="wiki-page">event__participant</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=observationContributor&#38;entity=dba_tabledescription&#38;where=where_tablename#PARTY_ID"><img src="_" style="font-size: small;" title="VegBank" alt="VegBank" /></a><a href="#event__participant" class="wiki-anchor">&para;</a></h2>

	<a name="Coordinates"></a>

<h1 ><a href="#Coordinates" class="wiki-page">Coordinates</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/entry/inputs/CTFS/_archive/DBv5.txt#Coordinates"><img src="_" style="font-size: small;" title="CTFS" alt="CTFS" /></a><a href="#Coordinates" class="wiki-anchor">&para;</a></h1>

<h3  style="padding-left:2em;"><img src="_" style="padding: 0 0.3em 3pt 0.75em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#TaxonNameUsageConcept" class="wiki-page">TaxonNameUsageConcept</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/taxonNameUsageConcepts/taxonNameUsageConcept"><img src="_" style="font-size: small;" title="VegX" alt="VegX" /></a><a href="#TaxonNameUsageConcept" class="wiki-anchor">&para;</a></h3>

	<p style="padding-left:3em;">Named like: <a href="#Occurrence" class="wiki-page">Occurrence</a></p>

<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#taxonNameUsageConceptID" class="wiki-page">taxonNameUsageConceptID</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganisms/individualOrganism/taxonNameUsageConceptID"><img src="_" style="font-size: small;" title="VegX" alt="VegX" /></a><a href="#taxonNameUsageConceptID" class="wiki-anchor">&para;</a></h3>

	<p style="padding-left:5em;">Related: <a href="http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&#38;wparam=taxonobservation&#38;entity=dba_tabledescription&#38;where=where_tablename" class="external">VegBank:taxonObservation</a></p>

<h2  style="padding-left:2em;"><a href="#dayCollected" class="wiki-page">dayCollected</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#dayCollected" class="wiki-anchor">&para;</a></h2>

	<a name="growthForm"></a>

<h2  style="padding-left:2em;"><a href="#growthForm" class="wiki-page">growthForm</a><a href="#growthForm" class="wiki-anchor">&para;</a></h2>

	<a name="TaxonObservation"></a>

	<a name="AggregateObservation"></a>

<h1 ><a href="#AggregateObservation" class="wiki-page">AggregateObservation</a><a href="#AggregateObservation" class="wiki-anchor">&para;</a></h1>

</li>

</ul>

</li>

<li><a href="/nceas/projects/bien/wiki/SQL_dotpaths">SQL dotpaths</a></li>

<li><a href="/nceas/projects/bien/wiki/VegCore_refactoring">VegCore refactoring</a></li>

</ul>

[[VegCore#TaxonOccurrence|TaxonOccurrence]]

[[VegCore#TaxonDetermination|TaxonDetermination]]

[[VegCore#OriginalTaxonDetermination|OriginalTaxonDetermination]]

[[VegCore#AggregateObservation|AggregateObservation]]

[[VegCore#Individual|Individual]]

[[VegCore#IndividualObservation|IndividualObservation]]

TaxonOccurrence

TaxonDetermination

OriginalTaxonDetermination

AggregateObservation

Individual

IndividualObservation

shapeOfSite,footprintWKT

soilConductivity,conductivity

soilTexture,texture

speciesName,specificEpithet

species_DwC,specificEpithet

species_VegBank,speciesBinomial

taxonIsAccepted,taxonIsCanonical

taxonMorphospecies,speciesBinomialWithMorphospecies

taxonNameUsageConceptID,taxonOccurrenceID

temp_C,temperature_C

timeOfDay,eventTime

traitName,measurementName

projectName

projectStartDate

projectTitle

proximateDataProvider

pubDate

quadratID