[postgis-users] postgis raster : getting pixel value

AJ7 ackbar at ackadij.com
Tue Mar 15 03:10:32 PDT 2011




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.




More information about the postgis-users mailing list