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 4 of 4

Is it possible to enter a City or Zip Code, and re....

This is a discussion on Is it possible to enter a City or Zip Code, and re.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; Is it possible to enter a City or Zip Code, and return a list of City and Zip Code w/in ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Is it possible to enter a City or Zip Code, and return a list of City and Zip Code w/in a specified proximity that I can export?

    For example: I would like to enter "Denver" or "80206" and a range of 25 miles and retrieve a list of Zip Codes w/ City Name within that 25 mile reach. And then export that list to be used in a sql database.

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I would experiment with the following. Use the data mapping feature to map some random demographic variable (like average income by Zip). Then pick your center, draw a radius circle, and use this to extract the demographics (Export to Excel). This gives you all a neat spreadsheet that lists all the ZIPs that have their centroid (centerpoint) inside the radius range. [This won't give you the city names, but you could extract this from the spreadsheet if you performed this same routine on a list of points of interest - there's an article y Chris Gebhardt on this site that explains how to extract the 800,000 points of interest from MapPoint...if you add them back in using the Import Data feature, you should be able to get the result you want!]

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Thanks Eric,

    I'm fairly new to this. I'm not even sure what Geocoding means. I tried dictionary.com, but to no avail.

    I'm fairly compentent w/ VB. Can you give me a rough estimate to the amount of time it would take to do this?

    Thanks,
    Drew

  4. #4
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    This isn't native MapPoint functionality, you'd do it easier and cleaner (more intuitively) with MapInfo or another traditional GIS along with municipalities and zip code layers. There are some work-arounds that might enable you to achieve this with MapPoint alone, take a look at the techniques in our reverse geocoding articles (there are three of them dated Sept.-Oct. of last year). What I would suggest is generating a tight grid or lattice of lat/lons in the area that would be enscribed by the desired radius and then reverse-geocode and sort/group the results.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to get alll zip code of one city
    By confach in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 11-04-2009, 12:22 PM
  2. Replies: 0
    Last Post: 04-01-2005, 09:31 AM
  3. Getting the Zip code and City when user Clicks Map
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-21-2005, 02:39 AM
  4. Can you enter GPS coordinates and make a pushpin?
    By tonyc789698 in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-26-2004, 08:35 PM
  5. Having problems retrieving city name from Zip Code
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-18-2004, 02:22 PM

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 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83