HomeMicrosoft


Can Microsoft MapPoint map 5 million addresses?
SPC
I need to map 5,700,000 addresses. Will MapPoint do that or is there another program that could be used?
winwaed
Depends what you mean by "map". If you just want to geocode them, then you could do this with a script. If you physically want to put that many pushpins on a map, then that is too many; but I don't think you really want to do this. *Any* map program is going to be very slow with that many pins, unless you split then up into groups (eg. States of sub-States). They are also going to crowd out the map. What exactly is your end objective? I think there will be a better way of doing it that will be more effective.

Richard
SPC
It's a customer base for about 5 states. In looking at new sites, I would like to "export" this information by 1, 2, 3, 4, 5 mile radius or custom polygons.
Ken in Regina
Richard,

If the customer database is in an Access database with geocoding, can Mappoint pull from the Access database to display things using the kind of criteria SPC mentioned? That would seem to be exactly the sort of thing you would expect from the integration Mappoint has with the Office tools.

@SPC, you can download Mappoint free for a 60-day trial. It's fully functional. No restrictions. It simply dies after 60 days if you don't buy it. I recommend you download it, take a subset of your customer base and run it through an online geocoding site or use Mappoint to do it. Then store the test set in an Access database and see what the search and display capabilities are.

...ken...
SPC
I have 100,000 in Excel and 5.7 mil in Access. MapPoint 2009 handled 100,000 geocoded addresses fine.
Ken in Regina
Have you used the data mapping wizard to see if it will produce the displays that you want?

Sorry if the questions are redundant. I guess the better question is, are you already comfortable that Mappoint will do everything you want from a functional viewpoint and your only question is whether it will support the large number of customer locations?

...ken...
winwaed
I've seen different reports on how many pushpins MapPoint can import at once. 100,000 sounds pretty typical.

One approach might be to try multiple pushpin sets, but I think a "proper" solution would require custom programming.

For example, you could use custom programming to geocode all your points. Then you can doing points-in-circle queries using custom programming (trigonometry) without MapPoint. Point-in-polygon queries are more complex, but could be done outside of MapPoint if you have all the points as coordinates. (yes I could be hired to do this!)

Another approach might be to look at the geospatial extensions in SQL Server. You could load SQL Server with your points and then query the shapes you have. This would require more set up and programming. If you have developers on staff, then Apress have a good book on SQL Server's geospatial features entitled "Beginning Spatial with SQL Server 2008".


Richard
Ken in Regina
Richard, won't the data mapping wizard do some of that for you? E.g. can't you get it to dip an Access database or Excel worksheet containing location coordinates and map the locations that fit your "query"?

...ken...
winwaed
I don't think so. To do the query at the database end (eg. with a specific query) would be too consuming in the general case, but might be useful for one off maps.

I was thinking the data could be split into regions - of, say 100,000 pushpins or so. And these could be imported on and worked on one at a time. Splitting into regions would make MapPoint run a bit quicker as well.


Richard
Ken in Regina
I see what you mean. I did a bit of a test with Larry's POI Megafile which has over 86,000 entries. I've got a version in Excel so I decided to play with the data mapping wizard a bit. It won't dip the Excel file. It insists on importing and geocoding it first. It didn't matter whether I chose to use the data directly or link to it .. in either case it immediately tries to geocode the entire list, even though the locations (lat, lon) are already in the file.

Any thoughts on how to stop it from trying to geocode a file that already contains the coordinates?

Worse, it's geocoding on the address. Many of the entries in the test file do not have addresses, so geocoding fails ... even though the coordinates are already in the entries.

Worse yet, you can only select one "region" for the geocoding exercise. The test file contains both American and Canadian entries. I can choose either Canada or United States as the region, which causes the geocoding in the other region to fail. So even if I needed it to geocode, it's flawed.

It's powerful but crude; rather like using a trackhoe when you really need a pair of tweezers. I can see why you suggest some customization might be in order.

...ken...
laptopgpsworld.com About