/ All posts
- Select objects whose centers/centroids are within polygons
Would it be possible to select any objects - points, lines, polygons- that have their center/centroid inside selected polygons without needing to create center/centroid first for the objects before the overlay?
Two questions :
- is sql an option for you?
- M8 or M9
Thank you so much for helping; yes SQL will be OK and I am using M9.
Thank you again apo!
just an example
TABLE CALL TableCacheIndexGeoms((
SELECT [Ojects Drawing].*,
GeomMakePoint(GeomCenter([Ojects Drawing].[Geom],0)) as GeomCenter
FROM [Ojects Drawing]
INNER JOIN [Selected Polygons]
ON Geomtouches([Selected Polygons].[Geom],GeomMakePoint(GeomCenter([Ojects Drawing].[Geom],0)),0)
That is beautiful!
Thank you so much for your help!!!