The attached query:

  • Returns separation distance for suitable habitat & unsuitable habitat distances
  • Includes data from both a direct EGT-eo_specs link and a EGT-Element_Group-Eo_specs link.
  • Will contain duplicates (on EGT_id) when there are EO_Specs for more than 1 location use class (e.g. breeding, nonbreeding, migratory stopover). The EST ID & LUC have been concatenated in the EST_BY_LUC column, to enable joining according to this information


NOTE: Though it is not common, when an EO_Spec exists for an individual species and for a species group in which the species is a member, query will return only the row(s) from the individual species relationship, as done in Biotics. 


Required Prior to Running Query:

  1. Run the following query in Query Builder to determine the subnation_id for your program, replacing Texas with your state/province name:
    select subnation_id from subnation where subnation_name='Texas'
  2. In the attached query, replace subnation_id=70 to the appropriate subnation_id, using CTRL-H to make sure all are replaced