I have two geometries and I want to write the information from one geometry into the other geometry, but only where they
intersect. Sometimes, a geometry is intersected with to different geometries (see my screenshot). The yellow geometry is intersected by two geometries (thick black line). The resulting table should contain the yellow geometry twice, with the two different information from the intersecting geometries.
CREATE TABLE myTable AS SELECT g.a, g.b, g.geom, t.c, t.d FROM green_geometries g LEFT OUTER JOIN thickBlackLine t ON ST_Intersects(ST_PointOnSurface(g.geom), t.geom);
However, the resulting table only contains the yellow geometry once, with only one information from the intersecting geometry added to it.
thickBlackLine t is a a table, containing many polygons. In the screenshot here you only see the outline (thickBlackline) of the polygon.
Maybe on the screenshot here it becomes more clear. I am trying to perform a Spatial Join on polygons, not line and polygon(s)!