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

People count in a city?

This is a discussion on People count in a city? within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi all, I have a list of people and their home cities & zip codes. I want to prepare a ...

  1. #1
    villadrive is offline Junior Member White Belt
    Join Date
    Jan 2006

    Question People count in a city?

    Hi all,
    I have a list of people and their home cities & zip codes. I want to prepare a map showing the number of people from my list that live in each city, not each zip code.

    DOES THIS SOUND RIGHT? --- I think I would need a master list of zip codes for all USA and group the zip codes for each city, come up with some sort of translation table so that when I put my data into MapPoint it simply displays a number over each city. Maybe just use one zip code for each city???

    i.e. if I have 29 people living in zip codes that are all contained in one city, then I want to see a map of that city with a single "pin" and the number of people within that city's pin.

    Fred Flintstone Berkeley 94702
    John Smith Berkeley 94702
    Peter PumpkinEater Berkeley 94702
    Zippy TheClown Berkeley 94702
    Jason Mask Berkeley 94703
    Dog AndPony Berkeley 94703
    Harry Carry Berkeley 94703
    Mary Contrary Berkeley 94703
    Dilbert Johnson Berkeley 94704
    Mike Rophone Berkeley 94704
    Honk UrHorn Berkeley 94704
    Cubicle Walls Berkeley 94705
    Blue Angels Berkeley 94705
    Jason Flintstone Berkeley 94705
    Dog Smith Berkeley 94705
    Harry PumpkinEater Berkeley 94707
    Mary TheClown Berkeley 94707
    Fred Mask Berkeley 94707
    John AndPony Berkeley 94707
    Peter Carry Berkeley 94707
    Zippy Contrary Berkeley 94707
    Jason Johnson Berkeley 94707
    Dog Rophone Berkeley 94708
    Harry UrHorn Berkeley 94708
    Mary Walls Berkeley 94708
    Dilbert Angels Berkeley 94708
    Mike TheClown Berkeley 94709
    Honk Mask Berkeley 94710
    Cubicle AndPony Berkeley 94710

    So, I would see BERKELY with one pin or marker on it with a small box saying "29".

    Anyone done this already? Ideas on how best to do it???


  2. #2
    calv1ns's Avatar
    calv1ns is offline Member Green Belt
    Join Date
    Mar 2005

    Use Excel or Access

    Quick and easy way is to use Excel to create a cross tab with Count records by City as the result - then use MapPoint to map your summarized data.

    If you can use Access it is easier with a group by and count query then Map off the created query result.


Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Virtual Earth Gives People a Way to Explore The World Online
    By Eric Frost in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 07-25-2005, 06:13 AM
  2. Need a count of occurrences in a zipcode Shaded Area
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-29-2005, 03:36 PM
  3. Newbie help; using Excel data to map by COUNT
    By rjhbos in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-25-2004, 11:06 PM
  4. I am plotting data by zip codes for Seminole Count....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-09-2002, 06:20 AM
  5. How do I map county data? Do I put state and count....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-08-1999, 06:16 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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59