Guest User

Untitled

a guest
Jul 22nd, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. mygeo=# CREATE TABLE uso_ocupacao_ibitinga_2 AS
  2. SELECT
  3. gid,
  4. (gv).val,
  5. (gv).geom
  6. FROM (
  7. SELECT
  8. gid,
  9. ST_Intersection(rast, geom) AS gv
  10. FROM
  11. municipios,
  12. uso_ocupacao_solo
  13. WHERE
  14. ST_Intersects(rast, geom)
  15. AND nome = 'Araraquara'
  16. )
  17. AS tmp;
  18.  
  19. ERROR: GEOSIntersects: TopologyException: side location conflict at -48.265729627714023 -21.544296308489137
  20. CONTEXT: PL/pgSQL function _st_intersects(geometry,raster,integer) line 22 at RETURN
  21. PL/pgSQL function st_intersection(geometry,raster,integer) line 5 at assignment
  22. SQL function "st_intersection" statement 1
Add Comment
Please, Sign In to add comment