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

[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 $

Ravenbrook / ILC 2002 / Common SQL

Company     Contact     Privacy Policy     Terms of Use