How to get the geometries based on column values in postgis?

Asked 3 years, 9 months ago

Viewed 50 times

I have the following table in postgis

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?

asked Jan 19 '16 at 11:35

Bruce

17614 bronze badges

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

add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

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