Hello:
Run
SELECT PostGIS_full_version();
TO know if your installation has GEOS 3.3.0 or above.
---
Iván Santiago
GIS Specialist
Information Technologies
Office of Management and Budget
787.725.9420 x 2378
Calle Cruz 254
PO Box 9023228
San Juan, PR 00902-3228
Ivan Santiago isanti...@ogp.pr.gov escribió:
Hello:
Run
SELECT PostGIS_full_version();
TO know if your installation has GEOS 3.3.0 or above.
I get this
POSTGIS=2.0.0 r9605 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.8.0, 6
March 2012 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8
You can try to analyze a bit to understand better
(for the following I consider your table doesn't contains too much data)
with the_data AS (
SELECT the_geom, ST_ISValid(the_geom) AS is_valid,
ST_IsValidReason(the_geom)
FROM ft_potencial
)
SELECT *, ST_AsText(ST_MakeValid(the_geom)) AS