On 11 April 2017 at 04:54, Ed Eads <[email protected]> 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. -Mike _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
