Hi David,
I can think of three and a half solutions for you which I think you'll like
with varying degrees of happiness.
First is to perform a SQL selection that will result in the aggregate
column Count. Be sure to group them by the postcode and add a column
count. This will result in a browser with the count of responses/records
per postcode and the postcode, but no map. You'll need to save this query
as a new table and then geocode that new table. It can then be labeled
with the count column as needed or shaded or whatever you'd like. From my
experience, if you've had problems with printing a large number of
overlapping points, this will also handle the situation.
Option 2 is to thematically shade the boundary with the count of the
objects within the boundary. This is a range thematic map. In it you'll
create a range thematic of the boundary table you want shaded (for instance
the postcode boundary). In the field section of the Create Thematic Map 2
of 2 window, select join as the field. This will result in the update
column for join window. Select the table with your points as the get value
from table section, joining where appropriate. Then in the calculate box,
calculate the count. This will shade your postal codes with the count of
the objects in each code with a range.
Option 2b is to complete the thematic map in option 2 and then select to
label the boundary with the temporary column that the data is shaded with.
This temp column will be shown as a selection in the label with drop down
box of the label options window after you make the thematic map.
Option 4 will let you see the spread of the points. For this try the MBX
tool Disperse points. This will take the points at a particular location
and randomly spread them out around their original location. Make sure you
make a copy of the original table first though as should you not like what
you see, you can't undo the work without making the table un-mappable and
then regeocoding it. It works very nicely though to show a broader
spread within the boundary.
I've tried to think of a way to label it with the number of objects at a
location with your table as is, but can't seem to come up with a solution
other than these 3.5. I hope that one of them suits your needs and good
luck!
Jennifer Duncan
MBS, Inc./Memorial Business Systems Inc.
www.mbs-intl.com
615-373-0110 / 800-844-4447
fax 615-370-4901
-----Original Message-----
From: David Eagle [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 29, 2000 12:38 PM
To: [EMAIL PROTECTED]
Subject: MI Labelling with concentration
Mappers,
I have geocoded a number of responses to a survey by their
postcodes (it would have been nice to use OS ADDRESSPOINT
data but the addresses collected are too much of a mess to get
any decent hit rate). As a result of this I now have in most cases
one visible point on the map which actually represents between 5
and 25 respondents living under that postcode. Is it possible to
label each point visible with an 'expression' that will show the
concentration of respondents at each point.
Sorry if this isn't very clear but its difficult to explain...
Thanks, Dave
_________________________________________________________
David A. Eagle
WS Atkins Consultants - East Anglia
Wellbrook Court, Girton Road, Cambridge, CB3 0NA.
Direct Dial Tel: (01223) 814090, Fax: (01223) 277529
E-Mail: [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]
