Project

General

Profile

« Previous | Next » 

Revision 10420

mappings/VegCore.htm: regenerated from wiki. added dayOfYear (=julianDay), which is different from startDayOfYear/endDayOfYear.

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="UTi5yVJLe8Z2XCb5jExkIzjuwftsNUoiek6UQ/aIKUA=" name="csrf-token" />
9
<meta content="o+XJSARutArOfdI+giUHZsGWb0sZcERJP/ckBkL8mgg=" 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" />
......
139 139
	<p style="padding-left:2em;"><a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/mappings/VegCore.vocab.csv" class="external"><strong>Vocabulary</strong></a> | <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/mappings/VegCore.thesaurus.csv" class="external"><strong>Thesaurus</strong></a></p>
140 140

  
141 141

  
142
<hr />
143

  
144

  
142 145
	<a name="Tables"></a>
143 146
<h1 >Tables<a href="#Tables" class="wiki-anchor">&para;</a></h1>
144 147

  
......
152 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>
153 156

  
154 157

  
158
<hr />
159

  
160

  
155 161
	<a name="Source"></a>
156 162
<h1 ><a href="#Source" class="wiki-page">Source</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&#38;table=observation&#38;target=tbl_structure.php#dataSourceName"><img src="_" style="font-size: small;" title="BIEN2" alt="BIEN2" /></a> <img src="_" style="font-size: small;" title="|" alt="|" /> <a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/datasource"><img src="_" style="font-size: small;" title="Brad Boyle" alt="Brad Boyle" /></a><a href="#Source" class="wiki-anchor">&para;</a></h1>
157 163

  
......
778 784
<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#timeOfDay" class="wiki-page">timeOfDay</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#TimeOfDay-2003-06-13"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#timeOfDay" class="wiki-anchor">&para;</a></h3>
779 785

  
780 786

  
781
	<a name="startDayOfYear"></a>
782
<h2  style="padding-left:2em;"><a href="#startDayOfYear" class="wiki-page">startDayOfYear</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="#startDayOfYear" class="wiki-anchor">&para;</a></h2>
787
	<a name="dayOfYear"></a>
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>
783 789

  
784 790

  
785 791
	<a name="julianDay"></a>
786 792
<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>
787 793

  
788 794

  
795
	<a name="startDayOfYear"></a>
796
<h2  style="padding-left:2em;"><a href="#startDayOfYear" class="wiki-page">startDayOfYear</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="#startDayOfYear" class="wiki-anchor">&para;</a></h2>
797

  
798

  
789 799
	<a name="endDayOfYear"></a>
790 800
<h2  style="padding-left:2em;"><a href="#endDayOfYear" class="wiki-page">endDayOfYear</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/#endDayOfYear"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#endDayOfYear" class="wiki-anchor">&para;</a></h2>
791 801

  
......
3800 3810
<h2  style="padding-left:2em;"><a href="#relationshipRemarks" class="wiki-page">relationshipRemarks</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/#relationshipRemarks"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#relationshipRemarks" class="wiki-anchor">&para;</a></h2>
3801 3811

  
3802 3812

  
3813
<hr />
3814

  
3815

  
3803 3816
	<a name="Special-terms"></a>
3804 3817
<h1 >Special terms<a href="#Special-terms" class="wiki-anchor">&para;</a></h1>
3805 3818

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

  
3829 3842

  
3830
	<p style="padding-left:10em;">The values do not need to be exactly the same if this field is more complete than the other field</p>
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>
3831 3844

  
3832 3845

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

  
3848

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

  
......
3847 3863
	<p style="padding-left:10em;">The field contains private data which should be omitted from a public database</p>
3848 3864

  
3849 3865

  
3866
<hr />
3867

  
3868

  
3850 3869
	<a name="Sources"></a>
3851 3870
<h1 >Sources<a href="#Sources" class="wiki-anchor">&para;</a></h1>
3852 3871

  
......
3961 3980
<h3  style="padding-left:8em;"><a href="https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx" class="external">Brad Boyle-DwC IDs-2013-1-31</a><a href="#Brad-Boyle-DwC-IDs-2013-1-31" class="wiki-anchor">&para;</a></h3>
3962 3981

  
3963 3982

  
3983
<hr />
3984

  
3985

  
3964 3986
	<a name="Editing"></a>
3965 3987
<h1 >Editing<a href="#Editing" class="wiki-anchor">&para;</a></h1>
3966 3988

  
......
3979 4001

  
3980 4002

  
3981 4003
	<ul>
3982
	<li>A term name should always be a <em><a href="/nceas/projects/bien/wiki/U-name" class="wiki-page">u-name</a></em> (unambiguous) to allow seamlessly combining data from arbitrary datasets</li>
4004
	<li>A term name should always be a <em><a href="/nceas/projects/bien/wiki/U-name" class="wiki-page">u-name</a></em> (unambiguous and with a <a href="/nceas/projects/bien/wiki/U-name#format" class="wiki-page">standard format</a>) to allow seamlessly combining data from arbitrary datasets</li>
3983 4005
		<li>It should ideally be the <em><a href="/nceas/projects/bien/wiki/C-name" class="wiki-page">c-name</a></em> (as short as possible)</li>
3984 4006
	</ul>
3985 4007

  
......
3989 4011

  
3990 4012

  
3991 4013
	<ul>
3992
	<li>Table names are capitalized</li>
4014
	<li>Table names are capitalized (this is required by scripts that parse the data dictionary page)</li>
3993 4015
		<li>Table names should always be <em>singular</em>, not plural</li>
3994 4016
	</ul>
3995 4017

  
......
4016 4038

  
4017 4039

  
4018 4040
	<ul>
4019
	<li>Field names start with a lowercase letter</li>
4041
	<li>Field names start with a lowercase letter (this is required by scripts that parse the data dictionary page)</li>
4020 4042
	</ul>
4021 4043

  
4022 4044

  
......
4139 4161
h3((((. !{padding: 0 0.3em 3pt 0.65em; font-weight: normal;}_(Unit alternative:)! [[VegCore#fieldRequiringUnits_units2|fieldRequiringUnits_units2]]
4140 4162
</pre>
4141 4163

  
4164
<hr />
4165

  
4166

  
4142 4167
	<a name="Related-pages"></a>
4143 4168
<h1 >Related pages<a href="#Related-pages" class="wiki-anchor">&para;</a></h1>
4144 4169

  

Also available in: Unified diff