[postgis-users] update xy field
pschweitzer at usgs.gov
Mon Apr 10 10:38:47 PDT 2017
I don't know whether this is the only way to do it, but I would do
select AddGeometryColumn ('APDinternal','Incidents','geom',2264,'POINT',2);
then do your update command--I think that part is correct.
On Mon, Apr 10, 2017 at 12:54 PM, Ed Eads <eeads at ashevillenc.gov> wrote:
> 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 =
> postgis-users mailing list
> postgis-users at lists.osgeo.org
Peter N. Schweitzer (U.S. Geological Survey, Reston, VA 20192)
(703) 648-6533 email: pschweitzer at usgs.gov
More information about the postgis-users