Geographic maps: Dynamic search of Dominican Republic occurrences

A. Database structure

1. Table drtaxa (2190 records)

LOCGRPCODE-- VARCHAR2(20) NOT NULL,
LOCNO-- VARCHAR2(20) NOT NULL,
GENUSNAME-- VARCHAR2(100),
SPECIESNAME-- VARCHAR2(100)

2. Table drlocat (2187 records)

LOCNO-- VARCHAR2(20) NOT NULL,
RIVER-- VARCHAR2(50),
STRATELEV-- VARCHAR2(10),
STRATUNITS-- VARCHAR2(10),
FORMATION-- VARCHAR2(50),
NANNOZONE-- VARCHAR2(20),
GEOLAGE-- VARCHAR2(50),
LOCGRPCODE-- VARCHAR2(10)

3. Table drlocgrp (164 records)

LOCGRPCODE-- VARCHAR2(10) NOT NULL,
LOCGRPNAME-- VARCHAR2(50),
MASTART-- VARCHAR2(10),
MAEND-- VARCHAR2(10),
STRATSECTION-- VARCHAR2(100),
HIGHELEV-- NUMBER(10),
LOWELEV-- NUMBER(10),
ELEVUNITS-- VARCHAR2(10)

4. Table drspecies (86 records)

GENUSNAME-- VARCHAR2(30),
SPECIESNAME-- VARCHAR2(30),
SPWEBPAGE-- VARCHAR2(30),

B. SQL code for dynamic search

Last updated on April 29, 2000-afb.