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

_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to