Timeline for In Postgres how to create columns with geometry?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 28, 2016 at 9:31 | vote | accept | Luffydude | ||
| May 28, 2016 at 3:18 | comment | added | Lee Hachadoorian | This question needs a lot more detail, and from you comment, the question itself is misleading. You already have a table with a geometry column, and you want a table with the coordinates. You should address: Same table or different table? Do you just need the coordinates, or does it actually have to be a PostGIS table? Could it be a view? The reference to QGIS is particularly confusing because QGIS can already easily display a PostGIS spatial layer, so what do you mean by "more easily export the point data into QGIS"? | |
| May 27, 2016 at 23:12 | comment | added | Get Spatial | If you have point data in PostGIS, bringing it in to QGIS should be simple. Before giving more detail about possible options to convert your data, please give more detail. Specifically, lay out your table and column structure anyhow the point data, i.e., x and y coords are dried in your Postgres table. Also, as mentioned on other questions, review the docs for Postgres,PostGIS. What you are asking is basic functionality that you should at least attempt on your own first. | |
| May 27, 2016 at 18:21 | answer | added | Hicham Zouarhi | timeline score: 0 | |
| May 27, 2016 at 17:29 | comment | added | Luffydude | I mean I already have a table A with some point geometry, I need to create a new table B with table A's geometry column separated in X and Y | |
| May 27, 2016 at 17:02 | comment | added | Inactivated Account | Do you mean you have coordinates stored in a PostgreSQL table and you want to convert them to PostGIS geometry? | |
| May 27, 2016 at 16:29 | comment | added | ziggy | Im slightly confused-do you have a table with the point geometry already? if yes then are you simply trying to bring that into QGIS? | |
| May 27, 2016 at 16:17 | history | asked | Luffydude | CC BY-SA 3.0 |