I have a multilinestring street table in postgis with two columns: label and prefix. This table has 2 different roads with the same name and each road contains multiple segments. Roads were splitted on each intersection during authoring in QGIS so that the table has total 14 rows. How to query the two so that i have two unique street rows with prefix and label column in the result?

  • not sure how in qgis, you are wanting distinct query. – Brad Nesom Oct 27 '11 at 16:23
  • hi brad, i meant in sql. not spesific to qgis – ranggalawe Oct 27 '11 at 16:35

If you mean purely sql, the select distinct I think is what you are asking about.
There is a tutorial here

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.