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

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

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

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

Eric,

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

Thanks!

Paf

census.gov ?

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,

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

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