This database is a modified subset of TROPICOS, the Missouri Botanical Garden's taxonomic database. Most of the data was derived and corrected from Al Gentry's database, and stored in dBase (.DBF) format.
In the column TYPE, C refers to a character string and N refers to a numeric string. LENGTH refers to the field length.
# | NAME | TYPE | LENGTH | SUBJECT |
---|---|---|---|---|
1 | TAXNO | C | 8 | TROPICOS taxonomic reference number |
2 | TROPNO | C | 8 | TROPICOS collection reference number |
3 | COUNTRY | C | 24 | Country of collection |
4 | STATE | C | 24 | First political division |
5 | PROV | C | 124 | Second political division |
6 | VIC | C | 254 | First locality field |
7 | HAB | C | 150 | Habitat |
9 | CHARS | C | 254 | Plant characteristics |
10 | NOTES | C | 227 | Miscellaneous notes about specimen |
11 | ANNOT | C | 100 | Annotations on specimen |
12 | DETBY | C | 30 | Determined by |
13 | LAT | C | 45 | Latitude/Longitude with minutes and seconds |
14 | ELEV | C | 25 | Elevation in meters |
15 | FL_STATE | C | 10 | Flowering state of specimen |
16 | HERB | C | 44 | Herbarium of deposit |
17 | TAXNAME | C | 42 | Taxonomic name used on original entry |
18 | GENUS | C | 15 | Genus |
19 | SPECIES | C | 29 | Species |
20 | INFRA | C | 20 | Infra specific name |
21 | SENCOL | C | 25 | Senior collector (useful for sorting and selecting) |
22 | FULLCOLL | C | 82 | Full collector name on original entry |
23 | COLL_NO | C | 18 | Collector's number |
24 | AUTHOR | C | 39 | Author of taxonomic name |
25 | TRIBE | C | 4 | Tribal assignment in Bignoniaceae |
26 | DAY | N | 2 | Day of collection |
27 | MONTH | N | 2 | Month of collection |
28 | YEAR | C | 5 | Year of collection |
29 | SOURCE | C | 3 | 'ahg' indicates derived from Gentry's database |