0

I have point data stored in the postgis server and I need to create a new table with their geometry values.

How can I extract their coordinates and translate them into a table. Something like:

column1 = coordinate X | column2= coordinate Y

I need this to more easily export the point data into QGIS.

Improve this question
5
  • 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?
    – ziggy
    Commented May 27, 2016 at 16:29
  • Do you mean you have coordinates stored in a PostgreSQL table and you want to convert them to PostGIS geometry?
    – Inactivated Account
    Commented May 27, 2016 at 17:02
  • 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
    – Luffydude
    Commented May 27, 2016 at 17:29
  • 2
    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.
    – Get Spatial
    Commented May 27, 2016 at 23:12
  • 1
    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"?
    – Lee Hachadoorian
    Commented May 28, 2016 at 3:18

1 Answer 1

Reset to default
0

I was waiting that the moderators will unhold your question here after the edit but still nothing so here is a possible answer, check the comments I left there for adding the count of overlapping points:

Here to add the columns of X and Y :

alter table your_Table add column x double precision; 
alter table your_Table add column y double precision;
update your_Table set x=st_x(your_GeometryColumn), y=st_y(your_GeometryColumn);
Improve this answer
1
  • 2
    To update a field, you can just write UPDATE your_table SET x = ST_X(geom);
    – thibautg
    Commented May 27, 2016 at 19:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.