[postgis-users] problem with st_makevalid and (LineString)

islanis at infomed.sld.cu islanis at infomed.sld.cu
Fri May 16 08:24:07 PDT 2014


Hello people, i got a problem where i have no idea what can i do.

I have this table

CREATE TABLE ft_potencial
(
   id_dw_ft_potencial integer NOT NULL,
   id_dw_tipo integer NOT NULL,
   id_dw_mes integer NOT NULL,
   id_dw_municipio integer NOT NULL,
   id_dw_date integer NOT NULL,
   potencial real NOT NULL,
   area real NOT NULL,
   the_geom geometry(Polygon,4326),
   CONSTRAINT ft_potencial_pkey PRIMARY KEY (id_dw_ft_potencial,  
id_dw_tipo, id_dw_mes, id_dw_municipio, id_dw_date)
)
WITH (
   OIDS=FALSE
);

and i want to clean  the errors that it has using the function ST_MakeValid
in this way

update ft_potencial set the_geom=ST_MakeValid(the_geom);

but it always return this error

ERROR:  Geometry type (LineString) does not match column type (Polygon)

********** Error **********

ERROR: Geometry type (LineString) does not match column type (Polygon)
Estado SQL:22023


what can i do to fix or clean the geometry without problems.

please help.
thanks

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


--

Este mensaje le ha llegado mediante el servicio de correo electronico que ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema Nacional de Salud. La persona que envia este correo asume el compromiso de usar el servicio a tales fines y cumplir con las regulaciones establecidas

Infomed: http://www.sld.cu/



More information about the postgis-users mailing list