Select YourColumns, Count(*) from YourTable where (some condition that they all pass)
group by Long,Lat into Selection
This assumes that your points have their coordinates in columns Long, Lat. If they
don't you will have to create columns and update them with CentroidX(), CentroidY().
The quiery will result in a browser where overlapping points have count>1...
Hope that helps.
Sincerely,
Sonya
JCH GeoInfo
(919)493-9339
Gabor Vasarhelyi wrote:
> Dear all,
> can anyone give me a query for counting the number of points that overlap on a given
>location. I would like to show the count next to the point record and or thematically
>map the overlapping points. The points are all in one table. There are lots of points
>(1000+)
>
> Also, can I add attributes of the points that overlap?
>
> tia
> Gabor Vasarhelyi
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
