Ravenbrook / ILC 2002 / Common SQL
Sample database tables
Nick Levine, Ravenbrook Limited, 2002-09-13The 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
[PLEC] | "Amazonia Agrobiodiversity Database"; Environment and Sustainable Development Programme; United Nations University. |
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 $