MapForums

I thought I saw an article on Google or mp2kmag to do this, but I can't find it-- hopefully I'm not repeating.

I'm interested in querying MapPoint 2004 for all zipcodes in the US via C#.NET. Please see the following columns to describe the table of data I'm looking for.

(Zipcode, County, City, State)

Is there any way to do this? I tried using FindAddressResults() as follows (to no avail)

ApplicationClass app = new ApplicationClass();
FindResults frs = app.ActiveMap.FindAddressResults("", "", "", "", "", "USA");

I'd like to find a programmatic solution to this, but I'd also settle for getting this data in an Excel document via using the MapPoint 2k4 UI

Any help is much appreciated.

I know that of the 100,000 possible zip codes, there's something like 42k to 44k actual zip codes in use.. you might just consider using brute force to see which ones are valid and extract them. To get the city and state, you could do a FindNearby and extract the POI information, see the Extracting POI information article. I'm not sure how you'd get county, but likely it's possible by mapping a territory or demographic to the county level.

Eric

__________________