[postgis-users] Geom/Rast Intersection St9bad_alloc

[JamesH]

Hi all,

I am attempting to intersect a thermal raster TIFF with a MasterMap
shapefile.

Both sets of data are stored in my database successfully and the query I am
running is:
SELECT gid, ST_Intersection(geom, rast, 1)
FROM clip_build, nclheat
WHERE ST_Intersects(rast, geom)

The raster file is quite large so takes a few hours to run, but it returned
an error message that I don't fully understand (below)
NOTICE:  Ring Self-intersection at or near point 425485.0638371231
567560.21788342111
CONTEXT:  PL/pgSQL function "st_intersection" line 10 at RETURN QUERY
NOTICE:  LWGEOM_GEOS_buildArea() threw an error: St9bad_alloc
CONTEXT:  PL/pgSQL function "st_intersection" line 10 at RETURN QUERY
ERROR:  St9bad_alloc
CONTEXT:  PL/pgSQL function "st_intersection" line 10 at RETURN QUERY

Can anyone explain how to solve the Ring self-intersection problem or what
St9Bad_alloc is?

Kind Regards,
James

-----
GIS Undergraduate
--
View this message in context: http://postgis.17.n6.nabble.com/Geom-Rast-Intersection-St9bad-alloc-tp4912994p4912994.html
Sent from the PostGIS - User mailing list archive at Nabble.com.