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

Zip Code centroids

This is a discussion on Zip Code centroids within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am trying to query zip codes that fall into territories I created using GIS data, and centroids are causing ...

  1. #1
    jzp
    jzp is offline Junior Member White Belt
    Join Date
    Jan 2007
    Posts
    3

    Zip Code centroids

    I am trying to query zip codes that fall into territories I created using GIS data, and centroids are causing me problems. I want any zip code that is located in each of my shapes, or even partially located in my shapes, to appear in the 'download to excel' query I do. Unfortunately, it only captures zip codes with their centroid located in the shape I've created.

    Is there a way to use the zip code area, not the centroid, as the determining factor for my query?

    Thanks,
    jzp

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Zip Code centroids

    Can you illustrate the issue with a screenshot and list the Excel output?

    Eric

  3. #3
    jzp
    jzp is offline Junior Member White Belt
    Join Date
    Jan 2007
    Posts
    3

    Re: Zip Code centroids

    Attached is a section of the map. (I am having trouble pasting it in the body of the reply)

    Notice that zip code 99017 straddles 3 of my territories: Orange, Yellow and Pink. However, because the centroid is located in Orange, it only shows up in the excel export in Orange, but not when I export data for Yellow or Pink.

    Could I convert the zip code boundary lines into shapes that I could name using the real zip codes and then query the two sets of territories? Or is there another solution?

    Any help is appreciated!

    Thanks,
    Judy
    Attached Images Attached Images

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Zip Code centroids

    Judy, I downloaded the shape-files of zipcodes from the USPS gazeteer and use them to queryshape. Not sure of the web address at the moment - matbe someone else knows.

  5. #5
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    Re: Zip Code centroids

    Zipcode (ZCTA) ESRI shape files from the 2000 census:
    Census 2000 5-Digit ZIP Code Tabulation Areas (ZCTAs) Cartographic Boundary Files - U.S. Census Bureau

    I wasn't able to find a newer public-domain set, but these are fairly accurate.
    You might try searching at USGS Earth Explorer or ESRI.

    HTH
    -Paul

  6. #6
    jzp
    jzp is offline Junior Member White Belt
    Join Date
    Jan 2007
    Posts
    3

    Re: Zip Code centroids

    Thank you to both of you! I have learned more about zip codes on this project than I thought even existed.

    Thanks again.

Thread Information

Users Browsing this Thread

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

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 84 85 86 87 88 89 90 91 92 93 94 95 96