RE: [MI-L] Counting points in buffers

Thu, 20 Jul 2006 16:55:39 -0700

Lee,

 

Say your buffers are in table ‘buffers’ and your points are in table ‘points’, try the following query:

 

Fields {buffers.ID, Count(*)}

Tables {points, buffers}

Where {points.Obj Within buffers.Obj}

Group {buffers.ID}

Order {}

Into {Selection}

Browse

 

I haven’t filtered out the buffers with less than 4 points, but you could do that with a second query on the results of the first.

 

cheers

David Llewellyn   

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Morris
Sent: Thursday, 20 July 2006 11:52 PM
To: [email protected]
Subject: [MI-L] Counting points in buffers

 

Could anyone please tell me how to count the number of points within a buffer?

 

I have what look like single points in some buffers, and I need to exclude any buffers containing less than 4 points.

 

Any help on this issue would be gratefully received.

 

Thanks

 

Lee Morris

 

Mouchel Parkman Services Ltd

Cunard Building

Water Street

Liverpool

L3 1ES

 

mailto: [EMAIL PROTECTED]

Tel 0151 242 7777 x.358

Fax 0151 242 7704

 

The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information. If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at [EMAIL PROTECTED] and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited.

As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it.

In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any).

Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded.

 

Mouchel Parkman Services Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040

If this email has been received in error, please delete all copies and inform the National Native Title Tribunal by return email or telephone 1800 640 501. The Tribunal does not warrant that its email is virus free. All emails sent to the Tribunal are filtered for viruses and inappropriate content. Thus your email may not reach the person to whom it is addressed. Seek confirmation of receipt of your email if you consider the email important.
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to