I have the following table in postgis enter image description here

I want to group the species along with geometries based on column values of 'val' i.e

11,11,11,11,11,11,11-corresponding species
          6,6-corresponding species
          12,12-corresponding species

How to do this in postgis?

  • 1
    By group do you mean filter layer by species class?
    – artwork21
    Jan 19, 2016 at 12:24
  • no I want to filter all the species based on 'val' column value
    – Bruce
    Jan 19, 2016 at 13:17
  • 1
    You should be able to filter by a simple SQL select query. What app are you wanting to view the filtered val geometries in (e.g. QGIS)?
    – artwork21
    Jan 19, 2016 at 17:19
  • do you also want to combine the geometries for each value of val? (similar to qgis dissolve by attribute?)
    – Steven Kay
    Jan 19, 2016 at 21:38


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.