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

Matching Un-matched Records to Zip Code

This is a discussion on Matching Un-matched Records to Zip Code within the Products: Pushpin Tool, Single State Mapper forums, part of the Map Forums category; I have to create "Multiple Symbol Maps" on a daily basis importing records from an Excel spreadsheet. There are always ...

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

    Matching Un-matched Records to Zip Code

    I have to create "Multiple Symbol Maps" on a daily basis importing records from an Excel spreadsheet. There are always some records that come up as "un-matched". When I select the Zip Code choice from the available "Potential Locations for This Record" window, the records are "Mapped", yet DO NOT SHOW UP on the map with a Pushpin.

    If I attempt to map the SAME locations, but create a "Pushpin Map" instead of the "Multiple Symbol Map", the records matched to Zip Codes DO show up with pushpins! I can't use the "Pushpin Map" for my purposes, though. I need to map addresses for multiple business units on one map.

    This is a serious glitch, because you can be looking at a map and think there are only three locations in a given area, when actually there may be more that are "ghosts" - they don't show up with pushpins. If you drag a box around the area and export into Excel, there may be many more records than appear on the map. They're there, but they're not!

    HELP!!! I'm confident that I'm not doing this wrong - I've been using the program for a long time and pretty much know what I'm doing. I really think it's a glitch in the software. Any suggestions???

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    If I understand correctly, multiple pushpins show up on top of each other.

    A couple suggestions:
    How often do these records change? Could you get a unique lat/lon (i.e. pushpins shifted from center) for each one and store it with your data? Then you would map by the stored lat/lon.

    You might also consider doing a shaded area map on code or a pie chart map with zip code.

    Finally, you could program a custom rendering wizard for your data.. it would detect when there are duplicate zip codes and shift subsequent pushpins out in a pattern around the zip code center..

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pushpins missing when matched by Zip Code
    By Frielink in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-18-2009, 05:46 PM
  2. Exporting Data for Matched Records
    By TechGuild in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 06-14-2006, 03:12 PM
  3. Matching records problem - URGENT HELP
    By Abilio Serafim in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-09-2005, 12:23 PM
  4. Help matching data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-01-2005, 04:53 PM
  5. Records matched to Zip Code don't have Pushpins
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-26-2004, 04:12 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 84 85 86 87 88 89 90 91 92 93 94 95 96