[postgis-users] postgis raster : getting pixel value

Jorge Arévalo jorge.arevalo at deimos-space.com
Tue Mar 15 03:22:01 PDT 2011


On Tue, Mar 15, 2011 at 11:10 AM, AJ7 <ackbar at ackadij.com> wrote:
>
>
>
> Pierre Racine-2 wrote:
>>
>>
>> the query look like this:
>>
>> CREATE TABLE resulttable AS
>>  SELECT id,
>>         (gv).geom AS the_geom,
>>         (gv).val
>>  FROM (SELECT id,
>>               ST_Intersection(rast, the_geom) AS gv
>>        FROM yourrastertable,
>>             yourpolygontable
>>        WHERE ST_Intersects(rast, the_geom)
>>       ) foo;
>>
>
> Pierre,
> I get the following error when I do an intersect:
> NOTICE:  UnsupportedOperationException: GeometryGraph::add(Geometry *):
> unknown geometry type: N4geos4geom12MultiPolygonE
> CONTEXT:  PL/pgSQL function "_st_intersects" line 28 at assignment
> SQL function "st_intersects" statement 1
>
>
> ERROR:  GEOS Intersection() threw an error!
> CONTEXT:  PL/pgSQL function "_st_intersects" line 28 at assignment
> SQL function "st_intersects" statement 1
>
> ------
>
> Any idea what could be wrong there? Could it be something wrong with the
> postgis raster conversion? When I convert the image to a vector file, all
> seems fine there.
>
>
>
> --
> View this message in context: http://old.nabble.com/postgis-raster-%3A-getting-pixel-value-tp31146394p31152398.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

Hello,

This error is probably caused because last PostGIS version from trunk
uses a modern version of GEOS library. Could you update your GEOS
version?

Best regards,

-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g



More information about the postgis-users mailing list