Table Columns

If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings

  Sort columns ordinally
  Sort columns alphabetically

Columns in table "nsr"




Column Data Type Null Description Values
family text YES
id bigint NO Integer primary key. Uniquely identifies each record in this table.
genus text YES Genus name
species text YES Species name without authority
country text YES Standard country name from geonames database (GNRS)
state_province text YES Standard state/province name from geonames database (GNRS)
county_parish text YES Standard county/parish name from geonames database (GNRS)
poldiv_full text YES [internal use]
poldiv_type text YES Political division type
native_status_country text YES Native status in country (NSR) 'A', 'I', 'Ie', 'N', 'Ne', 'NULL', 'P' MORE
native_status_state_province text YES Native status in state/province (NSR) 'I', 'Ie', 'N', 'Ne', 'NULL', 'P' MORE
native_status_county_parish text YES Native status in sounty/parish (NSR) 'I', 'Ie', 'NULL' MORE
native_status text YES Native status of taxon in lowest political division for which checklist information available (NSR) 'A', 'I', 'Ie', 'N', 'Ne', 'P', 'UNK' MORE
native_status_reason text YES Reason overall native status assigned (NSR) 'Absent from all checklists for region', 'Endem… MORE
native_status_sources text YES Checklist sources used to assign native status (NSR)
isintroduced text YES Is taxon introduced in declared political division? Final NSR assessment based on native_status (0,1,NULL).
is_cultivated_in_region text YES Is taxon known to be cultivated in declared political division? (NSR) '0' MORE
is_cultivated_taxon text YES Is taxon primarily cultivated? (NSR) '0', '1' MORE
user_id bigint YES [internal use]
taxon_poldiv text YES [internal use]