Sentenced to road and the intersection part of the polygon, use st_intersectiond () function, but the results returned from this function has a lot of empty geometry, as shown in figure,
I want to keep only those records is not empty, what conditions should be added?

CodePudding user response:

Try the where -- here st_intersects -- needs (r. gutierrez eom, v.g eom)=1