Timeline for Postgis Query Construction - postgresql
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 9, 2016 at 14:43 | comment | added | tkan |
Geometries can be grouped like any other column. You'd find them by using group by geometry and having count(*) = 1. This would display all geometries which are unique in the table. And those overlapping ones can be added by using UNION ALL and having count(*) > 1.
|
|
| Mar 4, 2016 at 21:15 | comment | added | Voyteck | Hi Tkan. I have to change my strategy. Your solution actually worked but I need something slightly different. How can I find unique geometries in my table and add a column which will contain for example letter "U"? All overlaping geometries should be blank in this column. | |
| Mar 3, 2016 at 13:56 | history | edited | tkan | CC BY-SA 3.0 |
deleted 1 character in body
|
| Mar 3, 2016 at 13:43 | review | First posts | |||
| Mar 3, 2016 at 13:46 | |||||
| Mar 3, 2016 at 13:41 | history | answered | tkan | CC BY-SA 3.0 |