[postgis-users] update xy field

Ed Eads eeads at ashevillenc.gov
Mon Apr 10 09:54:10 PDT 2017


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);

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170410/ddea2038/attachment.html>

More information about the postgis-users mailing list