Project

General

Profile

« Previous | Next » 

Revision 10616

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/VegCore.htm: regenerated from wiki. added EQUIV (also mapped in mappings/VegCore-VegBIEN.csv).

View differences:

VegCore.htm
6 6 
<meta name="description" content="Redmine" />
7 7 
<meta name="keywords" content="issue,bug,tracker" />
8 8 
<meta content="authenticity_token" name="csrf-param" />
9 
<meta content="o+XJSARutArOfdI+giUHZsGWb0sZcERJP/ckBkL8mgg=" name="csrf-token" />
9 
<meta content="BFiYVG0GvclFbzzVxKxYsK5KODXTj/Y11NfUCJYr/DE=" name="csrf-token" />
10 10 
<link rel='shortcut icon' href='/nceas/favicon.ico?1347421715' />
11 11 
<link href="/nceas/stylesheets/jquery/jquery-ui-1.9.2.css?1364512407" media="all" rel="stylesheet" type="text/css" />
12 12 
<link href="/nceas/stylesheets/application.css?1364512407" media="all" rel="stylesheet" type="text/css" />
......
149 149 
	<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), while <a href="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database#3579462" class="external">single table inheritance</a> (option 1) is similar to the denormalized, full_occurrence format.</p>
150 150 

  		




  151
  151
  
    

  		




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


  		




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


  		




  153
  153
  
    

  		




  154
  154
  
    

  		




  155
  155
  
    
	<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="#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>


  		




  ......




  788
  788
  
    
<h2  style="padding-left:2em;"><a href="#dayOfYear" class="wiki-page">dayOfYear</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://rs.tdwg.org/dwc/terms/#startDayOfYear"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#dayOfYear" class="wiki-anchor">&para;</a></h2>


  		




  789
  789
  
    

  		




  790
  790
  
    

  		




  
  791
  
    
	<p style="padding-left:5em;">the day of the <em>month</em></p>


  		




  
  792
  
    

  		




  
  793
  
    

  		




  791
  794
  
    
	<a name="julianDay"></a>


  		




  792
  795
  
    
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#julianDay" class="wiki-page">julianDay</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://rs.tdwg.org/dwc/terms/history/index.htm#JulianDay-2003-06-17"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#julianDay" class="wiki-anchor">&para;</a></h3>


  		




  793
  796
  
    

  		




  ......




  3833
  3836
  
    
	<p style="padding-left:5em;">When possible, use one of the more specific terms below:</p>


  		




  3834
  3837
  
    

  		




  3835
  3838
  
    

  		




  
  3839
  
    
	<a name="UNUSED"></a>


  		




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


  		




  
  3841
  
    

  		




  
  3842
  
    

  		




  
  3843
  
    
	<p style="padding-left:10em;">The field does not contain any data</p>


  		




  
  3844
  
    

  		




  
  3845
  
    

  		




  
  3846
  
    
	<p style="padding-left:10em;">The following query should return no rows:<br /><pre><code class="SQL syntaxhl"><span class="CodeRay"><span class="class">SELECT</span> * <span class="keyword">FROM</span> <span class="type">table</span> <span class="keyword">WHERE</span> field <span class="keyword">IS</span> <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>


  		




  
  3847
  
    
</span></code></pre></p>


  		




  
  3848
  
    

  		




  
  3849
  
    

  		




  3836
  3850
  
    
	<a name="DUPLICATE"></a>


  		




  3837
  3851
  
    
<h2  style="padding-left:6em;"><a href="#DUPLICATE" class="wiki-page">DUPLICATE</a><a href="#DUPLICATE" class="wiki-anchor">&para;</a></h2>


  		




  3838
  3852
  
    

  		




  ......




  3840
  3854
  
    
	<p style="padding-left:10em;">The field contains the same data as another field (so that both do not need to be mapped)</p>


  		




  3841
  3855
  
    

  		




  3842
  3856
  
    

  		




  3843
  
  
    
	<p style="padding-left:10em;">The following query should return no rows: <code>SELECT * FROM table WHERE NOT this_field</code> <strong><a href="/nceas/projects/bien/wiki/Postgres_queries#is-more-complete-than" class="wiki-page">?>=</a></strong> <code>dup_field</code><br />(The values do not need to be exactly the same if this field is more complete than the other field)</p>


  		




  
  3857
  
    
	<p style="padding-left:10em;">The following query should return no rows: (requires <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Postgres_queries#is-more-complete-than" title="is more complete than" class="external"><strong>?>=</strong></a>)<br />(The values do not need to be exactly the same if the other field is more complete than this field)<br /><pre><code class="SQL syntaxhl"><span class="CodeRay"><span class="class">SELECT</span> * <span class="keyword">FROM</span> <span class="type">table</span> <span class="keyword">WHERE</span> <span class="keyword">NOT</span> dup_field <span class="error">?</span>&gt;= this_field


  		




  
  3858
  
    
</span></code></pre></p>


  		




  3844
  3859
  
    

  		




  3845
  3860
  
    

  		




  3846
  
  
    
	<p style="padding-left:10em;">Use the format <code>DUPLICATE#of:orig_name#this_col_orig_name</code></p>


  		




  
  3861
  
    
	<p style="padding-left:10em;">The field is also an <em>exact</em> duplicate if the following query returns no rows:<br /><pre><code class="SQL syntaxhl"><span class="CodeRay"><span class="class">SELECT</span> * <span class="keyword">FROM</span> <span class="type">table</span> <span class="keyword">WHERE</span> <span class="keyword">NOT</span> this_field <span class="keyword">IS</span> <span class="keyword">NOT</span> <span class="keyword">DISTINCT</span> <span class="keyword">FROM</span> dup_field


  		




  
  3862
  
    
</span></code></pre></p>


  		




  3847
  3863
  
    

  		




  3848
  3864
  
    

  		




  3849
  
  
    
	<a name="UNUSED"></a>


  		




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


  		




  
  3865
  
    
	<p style="padding-left:10em;">Use the format <code>DUPLICATE#of:of_col_orig_name#this_col_orig_name</code></p>


  		




  3851
  3866
  
    

  		




  3852
  3867
  
    

  		




  3853
  
  
    
	<p style="padding-left:10em;">The field does not contain any data</p>


  		




  
  3868
  
    
	<a name="EQUIV"></a>


  		




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


  		




  3854
  3870
  
    

  		




  3855
  3871
  
    

  		




  3856
  
  
    
	<p style="padding-left:10em;">The following query should return no rows: <code>SELECT * FROM table WHERE field IS NOT NULL</code></p>


  		




  
  3872
  
    
	<p style="padding-left:10em;">The field contains data that is equivalent to another field (so that both do not need to be mapped)</p>


  		




  3857
  3873
  
    

  		




  3858
  3874
  
    

  		




  
  3875
  
    
	<p style="padding-left:10em;">The following query should return no rows: (requires <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Postgres_queries#is-populated-more-often-than" title="is populated more often than" class="external"><strong>?*>=</strong></a>)<br /><pre><code class="SQL syntaxhl"><span class="CodeRay"><span class="class">SELECT</span> * <span class="keyword">FROM</span> <span class="type">table</span> <span class="keyword">WHERE</span> <span class="keyword">NOT</span> equiv_field <span class="error">?</span>*&gt;= this_field


  		




  
  3876
  
    
</span></code></pre></p>


  		




  
  3877
  
    

  		




  
  3878
  
    

  		




  
  3879
  
    
	<p style="padding-left:10em;">Use the format <code>EQUIV#to:to_col_orig_name#this_col_orig_name</code></p>


  		




  
  3880
  
    

  		




  
  3881
  
    

  		




  3859
  3882
  
    
	<a name="PRIVATE"></a>


  		




  3860
  3883
  
    
<h2  style="padding-left:6em;"><a href="#PRIVATE" class="wiki-page">PRIVATE</a><a href="#PRIVATE" class="wiki-anchor">&para;</a></h2>


  		




  3861
  3884
  
    

  		












Also available in:  Unified diff