Hi
try this, if you have a table of points and a table of regions, its a simple
sql statement...
After the selection builded, you can easily obtain the number of records
selected(of tablepoint)
sorry for my bad english..
regards
Select * From TablePoints
Where obj Entirely Within (Select obj From TableRegion Where
TableRegion.x = x)
or
Select * From TablePoints
Where obj Entirely Within ObjectVariable
___________________________________
|| // Antoine Gilbert
|| // [EMAIL PROTECTED]
|| // #ICQ 9737371
|| \\
|| \\ Le Groupe KOREM Inc.
|| \\ http://www.korem.com
3360, rue de La Perade, bureau 200
Sainte-Foy (Qc) CANADA G1X 2L7
___________________________________
----- Original Message -----
From: Elliot Tinton EG CEFAS (DN=EJT00, RECIPIENTS, LOWESTOFT, CEFAS)
<[EMAIL PROTECTED]>
To: 'MAPINFO-L' <[EMAIL PROTECTED]>
Sent: Thursday, June 03, 1999 9:50 AM
Subject: MI Counting particles contained in regions
>Hello All,
>
>Can anyone tell me whether there is a way to count up the number of point
objects from one table that are contained within certain regions in another
layer. I have a table of points which are particle positions from the
output of a model. I also have a grid which makes up many rectangular
regions over the area. I want to count the number of particles contained
within each grid section so that I can thematically map the result. I could
do this by changing my model so that it does the calculation before
outputing the point positions but this may take a lot of time and I was
wondering if there is an easier way via mapinfo.
>
>Alternatively, I could make up regions from a grid which can have
differing lon and lat increments so that the mapinfo grid can each time
match the grid from my model. I can't find a way to do this either as the
gridmaker always keeps the grid spacing the same in x and y.
>
>Any help would be greatly appreciated
>Thanks very much
>
>Elliot Tinton.
>CEFAS
>Lowestoft
>Email [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]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
