Ravenbrook / ILC 2002 / Common SQL

Sample database tables

Nick Levine, Ravenbrook Limited, 2002年09月13日

The tables in this document show the first ten rows in each of the main tables of the Amazonia Agrobiodiversity Database [PLEC].

If you're intending to print this off you should use landscape format, because otherwise some of these tables are too wide to be shown completely.

PlotDescription - 426 rows
SampleAreaNumber PlotNumer PlotSize LandTenure ResourceTenure Elevation Steepness Aspect SoilType MoistureStatus Date Researcher Notes
1 1 25x25 household household 0.20 0 silt 1/1/99 Fernando
1 2 25x25 household household 0.20 0 silt 1/1/99 Fernando
1 3 25x25 household household 0.00 0 silt 1/1/99 Fernando
1 4 25x25 household household 0.20 0 silt 1/1/99 Fernando
1 5 25x25 household household 0.10 0 silt 1/1/99 Fernando
1 6 25x25 household household 0.10 0 silt 1/1/99 Fernando
1 7 25x25 household household 0.30 0 silt 1/1/99 Fernando
1 8 25x25 household household 0.40 0 silt 1/1/99 Fernando
1 9 25x25 household household 0.10 0 silt 1/1/99 Fernando
1 10 25x25 household household 0.20 0 silt 1/1/99 Fernando


SampleAreas - 38 rows
ClusterName Country/Subcluster DemoSite SampleAreaLocation SampleAreaNumber LandUseStage FieldType Date Researcher Farmer Notes
Amazonia Brazil Macapa Mazagao 1 Forest Levee 1999年01月01日 Fernando 7
Amazonia Brazil Macapa Mazagao 2 Forest Levee 1999年02月01日 Fernando 2
Amazonia Brazil Macapa Mazagao 3 Forest Levee 1998年08月01日 Marcio 9
Amazonia Brazil Macapa Mazagao 4 Forest Swap 1999年04月01日 Fernando 3
Amazonia Brazil Macapa Mazagao 5 Housegarden Restinga 2000年04月01日 Marcio 2
Amazonia Brazil Macapa Mazagao 6 Housegarden Restinga 1998年02月01日 Marcio 10
Amazonia Brazil Macapa Mazagao 7 Housegarden Restinga 1999年06月01日 Marcio 7
Amazonia Brazil Macapa Mazagao 8 Housegarden Restinga 1998年07月01日 Viles 11
Amazonia Brazil Macapa Mazagao 9 Housegarden Restinga 1999年03月01日 Marcio 3
Amazonia Brazil Macapa Mazagao 10 Housegarden Restinga 1998年05月01日 Fernando 9


SpeciesData - 3440 rows
ID PlotNumber SpeciesID Abundance Utility Date Researcher Notes
1 1 5 1 0 1998年05月01日 1
2 1 40 1 0 1998年05月01日 Vilis
3 1 1 1 0 1998年05月06日 Vilis
4 1 113 1 0 1998年05月20日 Vilis
5 1 112 1 0 1998年05月01日 Vilis
6 1 104 1 0 1998年05月01日 Vilis
7 1 100 1 0 1998年05月01日 Vilis
8 1 92 1 0 1998年05月01日 Vilis
9 1 89 1 0 1998年05月01日 Vilis
10 1 78 1 0 1998年05月01日 Vilis


SpeciesList - 205 rows
LocalName ScientificName SpeciesID
Abacate Persea gratissima Gaertn. 1
Abiu Ferdinandusa paraensis 2
abiu do sertão Pouruma sp. 3
Abiurana Pouteria bilocularis (Winkler) Baehni 4
Açaí Euterpe Oleraceae Mahrt. 5
Acapurana Campsiandra laurifolia Benth. 6
Acerola Malpighia glabra 7
Ajuru 8
Ameixa Eugenia cuminii 9
Anani Symphonia globulifera L.F. 10


TreeData - 9448 rows
PlotID TreeTagNumber SpeciesID DBH Height Researcher Date Notes
110 461 5 3.00 4.00 Fernando 1999年01月01日
110 462 51 19.30 25.73 Fernando 1999年01月01日
110 465 76 4.10 5.46 Fernando 1999年01月01日
110 466 76 4.50 6.00 Fernando 1999年01月01日
110 467 76 4.40 5.86 Fernando 1999年01月01日
110 468 76 9.50 12.66 Fernando 1999年01月01日
110 469 76 5.30 7.06 Fernando 1999年01月01日
110 470 62 7.20 9.60 Fernando 1999年01月01日
110 471 62 3.40 4.53 Fernando 1999年01月01日
110 472 62 7.10 9.46 Fernando 1999年01月01日

A. References

B. Document History

2002年09月13日 NDL Created.
2002年09月25日 NDL First draft complete.
2002年10月14日 NDL Review complete, ready for distribution.

September 2002
Copyright © 2002 by LispWorks Ltd
All Rights Reserved.

You are permitted to view, copy, print and distribute this publication, subject to your agreement that: a) your use of the information is for informational, personal, and non-commercial purposes only, b) you will not modify the documents, publications or graphics, c) you will not copy or distribute graphics separate from their accompanying text and you will not quote materials out of their context, d) you will display the above copyright notice and other proprietary notices on every copy you make, and e) you agree that LispWorks Ltd may revoke this permission at any time and you shall immediately stop your activities related to this permission upon notice from LispWorks Ltd. Use for any other purpose is expressly prohibited by law, and may result in severe civil and criminal penalties. Violators will be prosecuted to the maximum extent possible.

The information in this publication is provided for information only, is subject to change without notice, and should not be construed as a commitment by LispWorks Ltd. LispWorks Ltd assumes no responsibility or liability for any errors or inaccuracies that may appear in this publication.

The software described in this publication is furnished under license and may only be used or copied in accordance with the terms of that license. LispWorks is a registered trademark of LispWorks Ltd. Microsoft is a registered trademark of Microsoft Corporation. Other brand or product names are the registered trademarks or trademarks of their respective holders.

$Id: reference:sql-tutorial:tables.html,v 1.1 2002年10月30日 17:17:17 davef Exp $

Ravenbrook / ILC 2002 / Common SQL

AltStyle によって変換されたページ (->オリジナル) /