MapForums

mapenthuse · #1 (**permalink**) 02-08-2008

I read code in a .net book about MP that told you how to loop through a circle of given radius around a given center and process the pushpins within (e.g. calculate directions).

My project, however, needs to process pushpins within given zip codes - no circles involved. How would I compose such code?

I'm planning on writing the directions to a word file.

Thanks much,

Gary

**Wilfried** · #2 (**permalink**) 02-09-2008

Hi,

A pushpin has a Location property and this has a StreetAddress property with a PostalCode property. Is that what you wants ?

mapenthuse · #3 (**permalink**) 02-11-2008

Are you telling me I should loop through all my push pins and test in an if statement for those whose postal property = the zip code I'm interested in?

How do you loop through all push pins?

Gary

**Wilfried** · #4 (**permalink**) 02-15-2008

Hi,

Yes that's how to do it. Here is example in C#:

Code:

object o = 1;
Recordset rs = MP.ActiveMap.DataSets.get_Item(ref o).QueryAllRecords();
while (!rs.EOF) {
    if (rs.Pushpin.Location.StreetAddress != null)
        ; // etc..
    rs.MoveNext();
}

mapenthuse · #5 (**permalink**) 02-15-2008

That code tests if there's a street address, I wanted to test of the push pins zip code equaled the one I'm interested in.

WE're actually doing it in VBA.

Thanks, though - it still is helpful.

gary

**Wilfried** · #6 (**permalink**) 02-19-2008

Hi,

Yes but you have to check if Streetaddress property is not null. the Postal code property is one of the StreetAddress.

**lfdmike** · #7 (**permalink**) 02-19-2008

Gary

Wilfried gave you a good start to your goal, you just need to fill in the whatever functionality you need to do with it. I expanded on the provided code for a sample, which will need to be syntaxed for whatever language you are working with

Quote:

Recordset rs = MP.ActiveMap.DataSets.get_Item(ref o).QueryAllRecords();
while (!rs.EOF) {
if (rs.Pushpin.Location.StreetAddress != null)
then
retrieve postal code information from StreetAddress

if zipAddress = zipWanted
then
place pushpin data into matching set
else
place pushpin data into foreign set (if desired)
end if

else
place pushpin data into unkown set (if desired)
end if

rs.MoveNext()
}

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/processing-pushpins-within-zip-code-7107.html
Posted By	For	Type	Date
The Magazine for MapPoint - MP2K Magazine	This thread	Refback	02-10-2008 03:18 PM
Working With Excel and MapPoint - MP2K Magazine	This thread	Refback	02-10-2008 12:27 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mappoint pushpins and zip code heavy hitters	tvsmvp	MapPoint 2006/2009 Discussion	1	10-10-2005 01:01 PM
Batch Processing	Anonymous	MapPoint 2006/2009 Discussion	0	08-27-2004 12:31 AM
Records matched to Zip Code don't have Pushpins	Anonymous	MapPoint 2006/2009 Discussion	0	08-26-2004 03:12 PM
Pushpins missing when matched by Zip Code	Frielink	MapPoint 2006/2009 Discussion	0	06-23-2004 11:15 AM
Zip code distances from pushpins?	mschoonmaker	MapPoint 2006/2009 Discussion	0	08-14-2003 07:05 AM

MapForums

processing pushpins within a zip code

processing pushpins within a zip code

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/processing-pushpins-within-zip-code-7107.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

processing pushpins within a zip code

processing pushpins within a zip code

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/processing-pushpins-within-zip-code-7107.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/processing-pushpins-within-zip-code-7107.html