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 '16 at 12:24
  • no I want to filter all the species based on 'val' column value – Bruce Jan 19 '16 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 '16 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 '16 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.