How to skip GEOMETRYCOLLECTION EMPTY in intersect queries

[المشرف العام]

I have the same problem like here: How to split polygons with another polygon and inheritage data?

I have two database A is the background and B is the polygon above (see it in red).

I've used the ST_Intersection() to get intersected smaller polygon with the A and B attributes.

Finaly I got the result, but if I have more polygon in A db (D, E, F... parcels), I receive nulled geometry for the rest area.

I mean it: Result (fake):

ID | geom | Area

A 012300000000c2454 0,1545

B 012300000000c2454 0,2111

C 012300000000c2454 0,5445

D GEOMETRYCOLLECTION EMPTY 0

What can I do to skip the nulled geometries.

Thanks Gergo



أكثر...