Revision 10420
Added by Aaron Marcuse-Kubitza over 11 years ago
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">¶</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 |
|
Also available in: Unified diff
mappings/VegCore.htm: regenerated from wiki. added dayOfYear (=julianDay), which is different from startDayOfYear/endDayOfYear.