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

Ask Question

Asked 7 years ago

Modified 7 years ago

Viewed 72 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, 2016 at 11:35

Bruce

4896 silver badges18 bronze badges

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

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