[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