1

With PostGIS, I want to generate a new table being the result of the intersection of a table of mixed geometries and a polygonal layer. Here is my attempt. I think this request is valid. But I have an error related to the topology.

CREATE TABLE schema.resultat AS
SELECT gid, suivi,ouvrage_type,
source,code,dr,convention, t2.parcelle, t2.section,
ST_Intersection(t1.geom, t2.geom ) as geom 
FROM schema.t1
JOIN schema.t2 on ST_Intersects (t1.geom,t2.geom)

Code:
ERROR: ERREUR:  GEOSIntersects: TopologyException: side location conflict at 872675.09999999998 6823686.2999999998


SQL state: XX000
Vince
  • 20,017
  • 15
  • 45
  • 64
user35117
  • 939
  • 1
  • 7
  • 17
  • Try snap to grid and/or a very small buffer – BERA Aug 26 '23 at 08:41
  • ST_Intersection may produce errors in certain input situations (although this rarely occurs in practice). Is it possible for you to post the geometries which cause the error? – dr_jts Aug 25 '23 at 17:35
  • Yes i am OK for sharing geometries which cause the error. But how I can do that? Thanks. – user35117 Aug 25 '23 at 18:30
  • If they are not too large, post the WKB here. Otherwise put them somewhere and post a link. – dr_jts Aug 26 '23 at 23:31

0 Answers0