Hi Ronan,
Do a SQL select;
Select *, Count()
Tables Polygon_table, Point_table
Where Polygon_table.obj contains Point_table.obj
this should create a new column in the polygon table with a count of the
points
Andrew Bailey
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 27, 1999 1:38 PM
Subject: RE: MI SQL query
> Dear all
>
> I am trying to do something which should be straightforward but can't
> quite manage and any suggestions would be appreciated.
>
> I have geo-referenced a largish point file (13,500 records) against a
> large polygon file (c9000) polys. In most cases the points produce
> represent one record per poly but for a number of the polys there are
> between 2-250 records 'hidden' behind the visible point. I've used
> disperse to get a more detailed map but what I really want to do is to
> find a way of counting the number of points within each poly and add the
> results as a new column in the poly file ( so I can produce choropleths
> of the true numbers in each poly). Any suggestions on how to do this -
> if you're confused by the question let me know and I'll try and simplify
> it - i suspect it may be a cleverly produced sql query ??
>
> any help gratefully received,
>
> ronan foley
> ----------------------------------------------------------------------
> 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]
