Timeline for Understand way field (type geometry) in planet_osm_polygon
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 30, 2017 at 15:33 | comment | added | LaughU | @Anne Not need to worry. The format is POLYGON( x y , x y , ... you could create another field which only holds one pair of x and y values but to do this and how to, you would need to ask a new question after trying a bit around ;) | |
| Nov 30, 2017 at 15:18 | comment | added | Anne | Sorry for the delay. Thanks a lot, it helps a great deal ! I had tried something like that but with the geom_to_wkt function, which did not work. One last thing : as you wrote it in your answer, I get something like (4136278.21 5478121.15, ...) where the comma is misplaced, because it is placed so as to have two digits. This may be an issue when I want to join with table with, say, the nodes table. How can I fix this? | |
| Nov 30, 2017 at 13:35 | comment | added | LaughU | @Anne see my edit, hope it helps :) | |
| Nov 30, 2017 at 13:35 | history | edited | LaughU | CC BY-SA 3.0 |
added infos from comment
|
| Nov 30, 2017 at 12:46 | comment | added | Anne | Great, that's exactly what I was looking for, thanks ! Any idea as to how to do this with a query in DB manager ? | |
| Nov 30, 2017 at 12:45 | vote | accept | Anne | ||
| Nov 30, 2017 at 11:12 | history | answered | LaughU | CC BY-SA 3.0 |