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:

inputs/.geoscrub/Source/map.csv
1 1 
geoscrub,VegCore,Filter,Comments
2 2 
row_num,*row_num,,
3 3 
:aggregator,sourceType,,
4 
:r10707,edition,,"""Last Changed Rev: 10707"" (`svn info derived/biengeo/`)"
4 
:r10707,source__version,,"""Last Changed Rev: 10707"" (`svn info derived/biengeo/`)"
mappings/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>


  		












  

    
      mappings/VegCore-VegBIEN.csv
    
  





  2
  2
  
    
accessionNumber,"/_if[@name=""if specimen""]/cond/_exists",


  		




  3
  3
  
    
dataProviderRecordID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  4
  4
  
    
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  5
  
  
    
edition,"/_if[@name=""if specimen""]/else/source/edition",


  		




  
  5
  
    
source__version,"/_if[@name=""if specimen""]/else/source/edition",


  		




  6
  6
  
    
specimenHolderInstitutions,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",


  		




  7
  7
  
    
observationGranularity,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",


  		




  8
  8
  
    
sourceType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",


  		












  

    
      mappings/VegCore.thesaurus.csv
    
  





  119
  119
  
    
dcterms_type,type


  		




  120
  120
  
    
descriptionOfSite,locality


  		




  121
  121
  
    
detType,voucherType


  		




  
  122
  
    
edition,source__version


  		




  122
  123
  
    
familyScore,matchedFamilyConfidence_fraction


  		




  123
  124
  
    
fieldNotes_DwC_curatorial,occurrenceRemarks


  		




  124
  125
  
    
fieldNotes_DwC_terms,eventRemarks


  		












  

    
      mappings/for_review/VegCore-VegBIEN.csv
    
  





  2
  2
  
    
accessionNumber,"/_if[@name=""if specimen""]/cond/_exists",


  		




  3
  3
  
    
dataProviderRecordID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  4
  4
  
    
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  5
  
  
    
edition,"/_if[@name=""if specimen""]/else/source/edition",


  		




  
  5
  
    
source__version,"/_if[@name=""if specimen""]/else/source/edition",


  		




  6
  6
  
    
specimenHolderInstitutions,"/_if[@name=""if specimen""]/else/source/shortname",


  		




  7
  7
  
    
observationGranularity,"/_if[@name=""if specimen""]/else/source/observationtype",


  		




  8
  8
  
    
sourceType,"/_if[@name=""if specimen""]/else/source/sourcetype",


  		












  

    
      mappings/VegCore.vocab.csv
    
  





  193
  193
  
    
earliestEpochOrLowestSeries


  		




  194
  194
  
    
earliestEraOrLowestErathem


  		




  195
  195
  
    
earliestPeriodOrLowestSystem


  		




  
  196
  
    
edition


  		




  196
  197
  
    
?elevation


  		




  197
  198
  
    
elevationInMeters


  		




  198
  199
  
    
elevation_ft


  		




  ......




  557
  558
  
    
soilTexture


  		




  558
  559
  
    
source


  		




  559
  560
  
    
sourceType


  		




  
  561
  
    
source__modified_date


  		




  
  562
  
    
source__version


  		




  560
  563
  
    
?species


  		




  561
  564
  
    
speciesBinomial


  		




  562
  565
  
    
speciesBinomialWithMorphospecies


  		












Also available in:  Unified diff