Have you installed the ostGIS extension?
CREATE EXTENSION postgis;
If so you can add a Geometry column with;
https://postgis.net/docs/AddGeometryColumn.html
Set the SRID to what your data is.
Then you ST_MakePoint (If it is point data) to update the new column using the
data from other fields
Hello Jim,
To do so, you have first to add a Geometry column to your table (you can be
more precise on the type of Geometry by using for example Point as type).
You have to define also the SRS of the coordinates.
To populate your column you can for example use the ST_MakePoint function
using the
Jody,
If I have a PostgreSQL database that contains spatial coordinates, do you know
how I convert that database into PostGIS format so I can publish it on
GeoServer?
Jim Rogers
___
Geoserver-users mailing list
Please make sure you read the following
