Home -
General /
All posts - Select objects whose centers/centroids are within polygons
|
Hi all, 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? Thank you!
|
apo171 post(s) |
Two questions : - is sql an option for you?
- M8 or M9
a.
|
|
Apo, Thank you so much for helping; yes SQL will be OK and I am using M9. Thank you again apo!
|
apo171 post(s) |
just an example -- $manifold$ 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) ), TRUE); Attachments: test_centroid.mxb
|
|
Apo, That is beautiful! Thank you so much for your help!!!
|