[postgis-users] Invalid Geometry
Ryan Ollerenshaw
ollerery at engr.orst.edu
Tue Nov 21 17:22:02 PST 2006
Can anyone help me with this error, i cant seem to find the source of my
problem.
# UPDATE mro_asu SET the_geom = 'GeometryFromText(POLYGON((81 48, 82 48,
82 49, 81 49, 81 48)),4326)' WHERE team_id = 'PSP_001332_2620_RED';
ERROR: parse error - invalid geometry
My table looks like this
=# \d mro_asu
Table "public.mro_asu"
Column | Type | Modifiers
--------------+-----------------------------+-----------
team_id | character varying(100) |
date | date |
location | character varying(500) |
jpg | boolean |
jp2 | boolean |
browse | boolean |
thumb | boolean |
orbit | integer |
map_location | character varying(500) |
map_jpg | boolean |
map_jp2 | boolean |
map_browse | boolean |
map_thumb | boolean |
res | double precision |
minlat | double precision |
minlon | double precision |
maxlat | double precision |
maxlon | double precision |
the_geom | geometry |
starttime | timestamp without time zone |
stoptime | timestamp without time zone |
Check constraints:
"enforce_dims_the_geom" CHECK (ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =
'POLYGON'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (srid(the_geom) = 4326)
Thank you very much.
-Ryan
More information about the postgis-users
mailing list