Something simple like:
UPDATE
crimetest
SET
geom = PointFromText('POINT(' || x || ' ' || y || ')', 4326)
WHERE
x IS NOT NULL AND
y IS NOT NULL
UPDATE
crimetest
SET
geom = PointFromText('POINT(0 0)', 4326)
WHERE
x IS NULL OR
y IS NULL
Would work, but you might want to do something more clever. I'm not
sure what you'd like in the geom column when x or y is invalid.
-----Original Message-----
From: Richard Heimann [C] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 3:58 PM
To: Michael Smedberg; [EMAIL PROTECTED]; 'PostGIS Users
Discussion'
Subject: RE: [postgis-users] HELP adding spatial field to table
Thanks for the prompt response. And youre right there are some such
values.
Is there a work around?
Rich
-----Original Message-----
From: Michael Smedberg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 6:55 PM
To: [EMAIL PROTECTED]; PostGIS Users Discussion
Subject: RE: [postgis-users] HELP adding spatial field to table
Are you sure that x and y always have legit values? If one were null or
the zero-length string, I think you'd get an error like that.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Richard Heimann [C]
Sent: Tuesday, December 11, 2007 3:44 PM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] HELP adding spatial field to table
All,
Im getting some strange behavior that I cant explain and sadly know its
likely trivial. My pursuit is simple, add a spatial filed to a table
containing x,y.
First. AddGeometryColumn
SELECT AddGeometryColumn( 'crimetest', 'geom', 4326, 'POINT', 2)
Next (and where the trouble lies)
UPDATE crimetest
SET geom = PointFromText('POINT(' || x || ' ' || y || ')', 4326)
This is the error I receive.
ERROR: Invalid OGC WKT (too short)
SQL state: XX000
Context: SQL function "geomfromtext" statement 1
SQL function "pointfromtext" statement 1
Can anyone shed some light on this?
Thanks
Rich
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
