PDA

View Full Version : Import Multiple Radii Points and export all zip codes in each radius



roxannebmiller
06-16-2011, 10:02 AM
I need to be able to plot multiple radius from an adress or lat/long then export all the zip codes in each radius.

Eric Frost
06-16-2011, 10:23 AM
How many are there? Would your project be good candidate for automation or are there few enough it would be feasible to do manually? It's just a few steps to do each one.

Eric

roxannebmiller
06-16-2011, 10:27 AM
Multiple points 1500 plus....

Each point - can the zip be pulled back serperately even if the radius overlap?

roxannebmiller
06-16-2011, 10:28 AM
What are the steps if we are looking at one at a time?

PROFIT100 Consulting
06-16-2011, 11:30 AM
MapPoint® - IC-GeoAnalysis™ Suite
:balloon2: The program "IC-DistanceAnalysis (Professional)" will fit your task.

It´s part of the IC-GeoAnalysis™ Suite
(When you become a BETA-Tester, you will get a full license and we will show you how it works.)

IC-GeoAnalysis™ Suite:
The ultimative collection of programs, addIns and macros designed for working with MapPoint,
115 pages of - documentation (http://wh-en.mappoint-tools.info/GA/index.htm) - with hundreds of tutorials and screenshots.

There is a 30 day free trial available for - download (http://www.dl-ww.mappoint-tools.info/GA/Setup_IC-GeoAnalysisSuite_1.0.18_plus.exe) (40MB) - .
We are looking for BETA-Tester (http://profit100.de/tinc?key=4aifjtsv&formname=GeoAnalysis) , BETA-Tester will get a 50% discount and many benefits.

With kind regards
Manfred


PROFIT1oo™ Consulting - Microsoft® MapPoint ISV (Independent Software Vendor)
Seitersweg 55, D-64287 Darmstadt, Germany, Tel.: +49 (6151) 9815-56 , GM: Jürgen Käsemann, Manfred Sündorf,
Email: info@profit100.eu (info@profit100.eu) - Internet: http://www.mappoint2010.info (http://www.mappoint2010.info/)

Eric Frost
06-16-2011, 12:51 PM
Multiple points 1500 plus....

Yes, it's probably worthwhile to automate :-) Do you want the output all in a single table or how should it be formatted?


Each point - can the zip be pulled back serperately even if the radius overlap?

Not sure what you mean, do you want each zip code to be associated with no more than one of your points? This would be do-able and could be done by looking at either the straight-line distance or the driving distance between your point and the center of each zip code.

Eric

Eric Frost
06-16-2011, 12:53 PM
What are the steps if we are looking at one at a time?

The trick is to first map any demographic variable by zip code, then you could draw your radius and then right-click on the edge and select "Export to Excel". What you would end up with is 1500 separate worksheets however, it's probably best to explore a custom macro that will generate the results you need in an easier-to-use format.

Eric

Eric Frost
06-16-2011, 07:11 PM
Depending on your budget and need for accuracy, I'd also mention you can buy updated zip code databases with lat/lon's for fairly cheap that might be more up-to-date than MapPoint and use this as your source for the zip data.

Eric

nolster
08-14-2012, 06:30 PM
Interested if the requested project was ever done. We have several thousand points of presence, for each we have drive time calculations. We would like to be able to determine the population coverage we have. Currently utilizing Map Point 2013, with 2007 census data. Looking for a rough overall number that can be recalculated as we add (or subtract) locations in the future. Close counts, as this is a government related project.

Eric Frost
08-14-2012, 06:48 PM
This project was not done, but I've lately been working with Census 2010 demographic data and have done similar projects, so it's certainly doable if you are interested!

Eric

nolster
08-14-2012, 07:03 PM
I'm interested. Please let me know what I need to do.