Project

General

Profile

« Previous | Next » 

Revision 10716

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/VegCore.htm: regenerated from wiki. added source__version (= edition), source__modified_date.

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="BFiYVG0GvclFbzzVxKxYsK5KODXTj/Y11NfUCJYr/DE=" name="csrf-token" />
9 
<meta content="rFhHXZ7ZuBRqs3Z47TnkXu5tUfZB8OWvZlopwq5UnpM=" 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" />
......
302 302 
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#datasetOwner" class="wiki-page">datasetOwner</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/attachments/download/626/vegbien_identifiers.xlsx#terms/datasetOwnerID"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#datasetOwner" class="wiki-anchor">&para;</a></h3>
303 303 

  		




  304
  304
  
    

  		




  
  305
  
    
	<a name="source__version"></a>


  		




  
  306
  
    
<h2  style="padding-left:2em;"><a href="#source__version" class="wiki-page">source__version</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/wiki/2013-08-22_conference_call?version#add-derived-data-version-info"><img src="_" style="font-size: small;" title="conference call" alt="conference call" /></a><a href="#source__version" class="wiki-anchor">&para;</a></h2>


  		




  
  307
  
    

  		




  
  308
  
    

  		




  
  309
  
    
	<a name="edition"></a>


  		




  
  310
  
    
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#edition" class="wiki-page">edition</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#edition"><img src="_" style="font-size: small;" title="VegBank" alt="VegBank" /></a><a href="#edition" class="wiki-anchor">&para;</a></h3>


  		




  
  311
  
    

  		




  
  312
  
    

  		




  
  313
  
    
	<a name="source__modified_date"></a>


  		




  
  314
  
    
<h2  style="padding-left:2em;"><a href="#source__modified_date" class="wiki-page">source__modified_date</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/wiki/2013-08-22_conference_call?datelastmodified#source-level-tracking-of-import-and-revision"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#source__modified_date" class="wiki-anchor">&para;</a></h2>


  		




  
  315
  
    

  		




  
  316
  
    

  		




  
  317
  
    
	<p style="padding-left:5em;">This applies to the <em>source</em> rather than the data record</p>


  		




  
  318
  
    

  		




  
  319
  
    

  		




  
  320
  
    
	<p style="padding-left:5em;">Compare to: <a href="#modified" class="wiki-page">modified</a></p>


  		




  
  321
  
    

  		




  
  322
  
    

  		




  305
  323
  
    
	<a name="Dataset"></a>


  		




  306
  324
  
    
<h1 ><a href="#Dataset" class="wiki-page">Dataset</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/#datasetName"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/629/BIEN%20database%20entities%20related%20to%20data%20provenance%20and%20ownership.docx#dataset"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#Dataset" class="wiki-anchor">&para;</a></h1>


  		




  307
  325
  
    

  		




  ......




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


  		




  3859
  3877
  
    

  		




  3860
  3878
  
    

  		




  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


  		




  
  3879
  
    
	<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> dup_field <span class="keyword">IS</span> <span class="keyword">NOT</span> <span class="keyword">DISTINCT</span> <span class="keyword">FROM</span> this_field


  		




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


  		




  3863
  3881
  
    

  		




  3864
  3882
  
    

  		




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


  		




  
  3883
  
    
	<p style="padding-left:10em;">Use the format <code>DUPLICATE#of:dup_field#this_field</code> (with <em>original</em> column names)</p>


  		




  3866
  3884
  
    

  		




  3867
  3885
  
    

  		




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


  		




  ......




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


  		




  3877
  3895
  
    

  		




  3878
  3896
  
    

  		




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


  		




  
  3897
  
    
	<p style="padding-left:10em;">Use the format <code>EQUIV#to:equiv_field#this_field</code> (with <em>original</em> column names)</p>


  		




  3880
  3898
  
    

  		




  3881
  3899
  
    

  		




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


  		












Also available in:  Unified diff