View Full Version : Basic - Zip Code Data (Bubble Diagram)
09-26-2005, 12:54 PM
I am trying to build out a map diagram that takes 330,000 records with just zip codes that does a count and then presents a visual on a map (in the form of a bubble; more records = larger bubble) for Metro areas, etc. The problem is when I import my Access db it seems to run over the majority of records. How can I do this?
You would probably be a lot quicker using a "Make Table" query in Access to make a table first then importing the results into MapPoint
The SQL would be something like:-
SELECT ZipTable.ZipCode, Count(ZipTable.ZipCode) AS CountOfZipCode INTO [Make Table]
GROUP BY ZipTable.ZipCode;
This will reduce your 330,000 records into however many different Zip Codes you have in your table. I just tried this on a table with 410,000 records and it took about 2 or 3 seconds. A lot easier than trying to import them all then doing the maths.
Hope this helps
Powered by vBulletin® Version 4.2.2 Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO