| 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">¶</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&table=observation&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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</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">¶</a></h1>
|
| 4144 |
4169 |
|
mappings/VegCore.htm: regenerated from wiki. added dayOfYear (=julianDay), which is different from startDayOfYear/endDayOfYear.