DiversiPlant

Database Admin & Query Explorer

Checking...

Database Statistics

Distribution by Source

Growth Form

Threat Status (IUCN)

Lifespan

Climate Data (WorldClim)

TDWG: Uses aggregated data by region (5 macro-regions in Brazil). Fast, always available.

Precise Raster: Uses high-resolution WorldClim data (~1km²). Requires loading rasters with: python crawlers/worldclim_raster.py --apply-migration

Brazilian regions:

Global Climate Statistics

Biome Distribution

Click "Load Stats"

Köppen Distribution

Click "Load Stats"

Location Query

Climate-Adapted Species Filter

Find climatically adapted plant species for any terrestrial location. Click on the map or enter coordinates. Filters species by climate envelope matching using WorldClim data and ecoregion distributions.

Click on the map to select a location, or enter coordinates below

Experimental Strict

Filter by Growth Form

Custom Query

Example queries:

PostGIS / Geometry:

Data Upload

Upload the updated Practitioners CSV (~3,650 Brazilian threatened species). The file will be saved and the crawler will run automatically.

Drop CSV file here or click to browse

Required columns: sci_names, family, growth_form

Data Verification

Table Structure

species

Main species table

idinteger PK
canonical_namevarchar
genusvarchar
familyvarchar
wcvp_idvarchar
gbif_taxon_keybigint
gift_work_idinteger
reflora_idvarchar
wfo_idvarchar
taxonomic_statusvarchar
accepted_name_idinteger FK

species_unified

Consolidated traits (priority: gift > reflora > wcvp)

species_idinteger PK/FK
growth_formvarchar
growth_form_sourcevarchar
max_height_mnumeric
woodinessvarchar
nitrogen_fixerboolean
dispersal_syndromevarchar
is_treeboolean
is_shrubboolean
is_climberboolean
is_herbboolean
is_palmboolean
is_native_brazilboolean

species_regions

Geographic distribution by TDWG Level 3

idinteger PK
species_idinteger FK
tdwg_codevarchar
is_nativeboolean
is_endemicboolean
is_introducedboolean
sourcevarchar

species_geometry

PostGIS polygons (union of TDWG regions)

species_idinteger PK/FK
native_rangegeometry
full_rangegeometry
bboxgeometry
centroidgeometry
native_area_km2numeric
native_regions_countinteger
full_regions_countinteger

tdwg_level3

TDWG regions (369 global regions)

idinteger PK
level3_codevarchar
level3_namevarchar
level2_codevarchar
continentvarchar
geomgeometry

common_names

Common names (pt/en)

idinteger PK
species_idinteger FK
common_nametext
languagevarchar
sourcevarchar
verifiedboolean

tdwg_climate

WorldClim bioclimatic by TDWG

idinteger PK
tdwg_codevarchar FK
bio1_mean/min/maxdecimal
bio2-bio11_meandecimal
bio12_mean/min/maxdecimal
bio13-bio19_meandecimal
whittaker_biomevarchar
koppen_zonevarchar
aridity_indexdecimal

Color legend:

Primary Key
Foreign Key
NOT NULL
Filter fields
External IDs / Geometry
Nullable

Relationships:

species (1) ─────┬───── (1) species_unified     [consolidated traits]
                 │
                 ├───── (N) species_regions     [N TDWG regions per species]
                 │              │
                 │              └──── tdwg_level3  [FK: tdwg_code → level3_code]
                 │
                 ├───── (1) species_geometry    [polygon = union of regions]
                 │
                 └───── (N) common_names        [names in pt/en]