I am just a newbie into PostGIS, but from the SQL code presented I see some puzzling questions (for me, of course): 1. Although two geometry fields exist in the table, I see constraints just for one of them (geometria); 2. The SRID and other fields in the table refer to a geographical reference system (not projected); 3. Given the statement above, how could a Point with coordinates (1 1) be inserted??! 4. Further, each coordinate should have a space separating the next coordinate in the tuple, not a comma. If PostGIS uses decimal degrees for geographic coordinates, then a typical Point insertion would be: POINT(2.82806 41.98500) which is longitude (positive is East) and latitude (positive is North). Regards, Joao
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amrita p Sent: Wednesday, November 14, 2007 9:51 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] A simple GeomFromText Because in ur table the constraint is 2 dimension. U cant store point into ur table. To store point delete the constraint for two dim. On Thu, 01 Nov 2007 [EMAIL PROTECTED] wrote : >Hi, > >I might have missed something, but I keep looking at it and can't >understand why the following keeps throwing an 'invalid geometry' error :( > >Here's the table: > >------------------------ >CREATE TABLE asistentes >( > gid int8 NOT NULL, > nombre varchar(150), > longitud float8, > latitud float8, > the_geom geometry, > geometria geometry, > CONSTRAINT asistentes_pkey PRIMARY KEY (gid), > CONSTRAINT enforce_dims_geometria CHECK (ndims(geometria) = 2), > CONSTRAINT enforce_geotype_geometria CHECK (geometrytype(geometria) = >'POINT'::text OR geometria IS NULL), > CONSTRAINT enforce_srid_geometria CHECK (srid(geometria) = 4326) >) >WITHOUT OIDS; >ALTER TABLE asistentes OWNER TO postgres; >------------------------ > >The table is already populated and then I try updating one of the >geometries with: > >------------------------ >UPDATE asistentes SET geometria=GeometryFromText('POINT(1,1)', 4326) WHERE >gid=3; >------------------------ > >And I get the following Explain comment? > >------------------------ >La consulta insertó una fila con OID 0. > >ERROR: parse error - invalid geometry >------------------------ > >The spanish line says something like 'the query added one row with OID 0'. >If anyone could shed some light on this I'd very much appreciate it :) > >Marc > >_______________________________________________ >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
