Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mygeo=# CREATE TABLE uso_ocupacao_ibitinga_2 AS
- SELECT
- gid,
- (gv).val,
- (gv).geom
- FROM (
- SELECT
- gid,
- ST_Intersection(rast, geom) AS gv
- FROM
- municipios,
- uso_ocupacao_solo
- WHERE
- ST_Intersects(rast, geom)
- AND nome = 'Araraquara'
- )
- AS tmp;
- ERROR: GEOSIntersects: TopologyException: side location conflict at -48.265729627714023 -21.544296308489137
- CONTEXT: PL/pgSQL function _st_intersects(geometry,raster,integer) line 22 at RETURN
- PL/pgSQL function st_intersection(geometry,raster,integer) line 5 at assignment
- SQL function "st_intersection" statement 1
Add Comment
Please, Sign In to add comment