[postgis-users] update xy field

Mike Toews mwtoews at gmail.com
Mon Apr 10 15:04:22 PDT 2017

On 11 April 2017 at 04:54, Ed Eads <eeads at ashevillenc.gov> wrote:
> All,
> I have xy data in a PostgreSQL table and was able to add a geom column.
> The issue showed up when I then attempted to update the geom column with the
> xy values.
> I want to transform from xy values to a gis-enabled table. Any assistance is
> appreciated. Thanks - Ed
> ALTER TABLE "APDinternal"."Incidents"
> ADD COLUMN geom geometry(POINT,2264);
> UPDATE "APDinternal"."Incidents" SET geom =
> ST_SetSRID(ST_MakePoint(Xinc,Yinc),2264);

What was the issue? If Xinc and Yinc are already in EPSG:2246, then
these steps look correct. However, if the coordinates need to be
projected, then you need to find out the spatial reference system of
these coordinate columns, and use ST_Transform to project them.


More information about the postgis-users mailing list