I have a Postgis table with records which have a geometry column. Within the geometry, there are multipart polygons (example. If I query this one record in QGIS, it shows one polygon at location x,y and the other polygon 200 meters north). What transformer can I use to identify records that have multipart geometries that are over 150 meters apart from one another?
Other records in the table have a geometry with one polygon and these can be ignored. I'm looking for records that have multipart geometry and if so, that are greater than 150m apart.
Much appreciated. Thank you.