Timeline for Deleting duplicate geometry in PostGIS tables
Current License: CC BY-SA 4.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 25, 2022 at 14:31 | answer | added | André | timeline score: 1 | |
| Oct 19, 2021 at 5:12 | answer | added | Taras♦ | timeline score: 0 | |
| Oct 19, 2021 at 5:08 | history | edited | Taras♦ | CC BY-SA 4.0 |
deleted 220 characters in body; edited tags; edited title
|
| Apr 6, 2021 at 21:59 | answer | added | Timothy Dalton | timeline score: 1 | |
| Jan 24, 2020 at 9:00 | history | tweeted | twitter.com/StackGIS/status/1220632460612067328 | ||
| Jan 23, 2020 at 6:48 | answer | added | Miro | timeline score: 4 | |
| S Feb 5, 2018 at 16:29 | history | suggested | Eva Großmann | CC BY-SA 3.0 |
corrected spelling
|
| Feb 5, 2018 at 16:05 | review | Suggested edits | |||
| S Feb 5, 2018 at 16:29 | |||||
| S Nov 2, 2016 at 20:58 | history | suggested | sophie_gis |
inserted tag
|
|
| Nov 2, 2016 at 20:44 | review | Suggested edits | |||
| S Nov 2, 2016 at 20:58 | |||||
| Oct 31, 2016 at 23:38 | answer | added | Nate Wanner | timeline score: 3 | |
| Dec 7, 2014 at 7:29 | comment | added | MartinMap | "The column ‘ctid’ is a special column available for every tables but not visible unless specifically mentioned. The ctid column value is considered unique for every rows in a table. - "technobytz.com/most-useful-postgresql-commands.html | |
| Dec 5, 2014 at 14:41 | comment | added | Zia |
Sorry, but I didn't get this ctid approach. This column has been added manually after the duplication event?
|
|
| Dec 5, 2014 at 14:32 | comment | added | John Powell | Yes, that will work, if you have another id (ctid) that is not duplicated. I was assuming that everything was identical and duplicated twice. | |
| Dec 5, 2014 at 14:30 | history | edited | MartinMap | CC BY-SA 3.0 |
added 186 characters in body
|
| Dec 5, 2014 at 14:07 | answer | added | John Powell | timeline score: 26 | |
| Dec 5, 2014 at 13:41 | comment | added | Zia |
Could you please provide the current planet_osm_point table structure? means type of columns. You can write a basic Python code to collect the selected columns, if having difficulty with the SQL functions.
|
|
| Dec 5, 2014 at 13:19 | history | asked | MartinMap | CC BY-SA 3.0 |