Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.