Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Basic - Zip Code Data (Bubble Diagram)

This is a discussion on Basic - Zip Code Data (Bubble Diagram) within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am trying to build out a map diagram that takes 330,000 records with just zip codes that does a ...

  1. #1
    robertuva is offline Junior Member White Belt
    Join Date
    Jun 2004
    Posts
    3

    Basic - Zip Code Data (Bubble Diagram)

    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?

    Bobby

  2. #2
    I.T. is offline Junior Member White Belt
    Join Date
    Mar 2005
    Posts
    9
    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]
    FROM ZipTable
    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

    Iain T.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. help on converting vba code to visaul basic 2005 express
    By nmilne in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 01-24-2007, 02:16 PM
  2. A kind of diagram
    By chpw in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-01-2006, 08:31 AM
  3. Formatting data in a bubble
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-11-2005, 01:29 PM
  4. Visual Basic 6.0 generating a map based on access data
    By virgilar in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 03-11-2005, 09:27 AM
  5. Controlling Autoroute from Visual Basic code
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-26-2004, 11:47 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25