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 "species_by_political_division"

Column Data Type Null Description Values
state_province text YES Standard state/province name from geonames database (GNRS)
species_by_political_division_id bigint NO Integer primary key. Uniquely identifies each record in this table.
scrubbed_species_binomial text YES Accepted species resolved by TNRS. If no accepted name, matched species is used, but only if matched_taxonomic_status='No opinion'.
is_new_world smallint YES Is country in western hemisphere? '0', '1', 'NULL' MORE
is_cultivated_observation smallint YES Is observation of an individual cultivated plant (0,1,NULL) '0', '1', 'NULL' MORE
is_cultivated_in_region smallint YES Is taxon known to be cultivated in declared political division? (NSR) '0', 'NULL' MORE
county text YES Standard county/parish name from geonames database (GNRS)
country text YES Standard country name from geonames database (GNRS)