Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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