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

How can I get the territory code that a pushipin is located

This is a discussion on How can I get the territory code that a pushipin is located within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi All, I am new using Mappoint 2002. Any help will be greatly appreciated. I have already defined manually 80 ...

  1. #1
    paf33 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    11

    How can I get the territory code that a pushipin is located

    Hi All,

    I am new using Mappoint 2002. Any help will be greatly appreciated.
    I have already defined manually 80 territories in New York State. The territory definition is really complex as my territories are defined in terms of cities, tows and villages. In addition, some territories are defined in terms of rivers, lakes and streets. Finally, after one week of hard work the territories are defined in terms of census tract units.

    Our existing database consists of around 500,000 records. We guess that almost 120,000 were assigned a wrong territory code in the past. The pushpins are imported to Mappoint. Now, we need to find an easy way to obtain in Excel a list of the pushpins with the code of the territory where each is located.

    Any ideas? Do you know any book that can help me with this issue?

    Thanks,

    PAF33

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

    Unfortunately I don't think this is possible with MapPoint (i.e. to programmatically loop through and determine the census tract or territory for each point).

    What you might try to do is get a list of the census tracts that are in each territory, download the census tract boundaries from census.gov, get your points out of MapPoint (export the lat/lons using a tool like the Pushpin Tool) and perform the anaylsis in a GIS like MapInfo or Manifold.

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

  3. #3
    paf33 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    11
    Eric.

    Thanks for your reply. I have the list of census tracts for each territory and also a list of lat/lons for each pushpin. However, I don'know how I can link census tracts with lat/lons.

    Can Mapinfo/Manifold match lat/lons with census tract?

    Thanks,

    PAF

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Yes, they can.. you would need to download the census tracts from census.gov if you don't already have them.

    Point in polygon is a pretty basic feature in a GIS like Manifold or MapPoint.. it's still possible but it's not as easy to do with MapPoint, you would have to import the census tracks as "shape" objects and then loop through with some custom programming on each one to figure it out. Finally, you'd still have to match it up with your list of which census track is in each territory.

    I don't know if either MapPoint or Manifold has a trial version you can check out, but I know ArcGIS (ESRI) ships a student version in one of their books, that would also accomplish it.

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

  5. #5
    paf33 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    11
    Eric,

    Could you please send me the link to download the census tracts?

    Thanks!

    Paf

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    census.gov ?
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    calv1ns's Avatar
    calv1ns is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    91

    Wish List

    I think these are the files:

    http://www.census.gov/geo/www/cob/index.html

    Eric

    Add to your wish list for MP 2006 a QueryTerritory method.

    Ciao,
    Calv1ns

  8. #8
    renatoa is offline Junior Member Yellow Belt
    Join Date
    Feb 2006
    Posts
    29

    Censu tract from lat/long

    I have now a project where I has been challenged with a similar problem and I succeeded to manage it.
    If still actual to you (yes, I know it was one year ago ) then please notify me to give you the solution.

    Renato

    Quote Originally Posted by paf33
    Eric.

    Thanks for your reply. I have the list of census tracts for each territory and also a list of lat/lons for each pushpin. However, I don'know how I can link census tracts with lat/lons.

    Can Mapinfo/Manifold match lat/lons with census tract?

    Thanks,

    PAF

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extracting Zips form the territory (from code)
    By andrejd in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 02-17-2006, 07:57 AM
  2. Zip Code Update and Territory Overlays
    By Anonymous in forum Wish List
    Replies: 1
    Last Post: 10-21-2005, 01:05 PM
  3. Which Territory is a Pushpin located?
    By johnweidauer in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-31-2005, 11:46 AM
  4. territory zip code capture
    By ToddF in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-01-2004, 03:17 PM
  5. MapPoint drivetime zone to territory byzip code
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 08-07-2003, 03:33 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