non_spatial_processing.md

non-spatial

An output_schema (currently: dopa) is created.

After processing (scripted in non_spatial_processing.sql), the output schema contains:

• dopa_species (main table)
  • id_no bigint, derived from non_spatial_taxonomy, selected if existing in previously created table all_species_list
  • phylum text, derived from non_spatial_taxonomy
  • class text, derived from non_spatial_taxonomy
  • order_ text, derived from non_spatial_taxonomy
  • family text, derived from non_spatial_taxonomy
  • genus text, derived from non_spatial_taxonomy
  • binomial, text derived from non_spatial_taxonomy
  • endemic, boolean
  • ecosystems text[], derived from non_spatial_assessments, field systems
  • category text, derived from non_spatial_assessments, field redlistcategory
  • threatened boolean, derived from non_spatial_assessments, field redlistcategory, selecting 'Critically Endangered','Endangered' and 'Vulnerable' species
  • country text[], derived from _non_spatial_countries, field code (ISO2 country code), selecting in the fields:
    • presence: 'Extant'
    • origin: 'Native','Reintroduced','Assisted Colonisation'
    • seasonality: 'Non-Breeding Season','Breeding Season','Resident',NULL (this last one is a weakness, we wait for clairfication from IUCN).
  • country_n integer, derived from counts on previous field country,
  • conservation_needed text[], derived from non_spatial_conservation_needed
  • habitats text[], derived from non_spatial_habitats
  • research_needed text[], derived from non_spatial_research_needed
  • stresses text[], derived from non_spatial_threats, fields stresscode,stressname
  • threats text[], derived from non_spatial_threats
  • usetrade integer[], derived from non_spatial_usetrade
• class_species_category
• class_species_conservation_needed
• class_species_habitats
• class_species_research_needed
• class_species_stresses
• class_species_threats
• class_species_usetrade.