View Full Version : MapPoint 2010 and Time zones...

02-23-2012, 04:08 PM
In MP 2004/2006 we were able to extract US time zone information from MapPoint by using the FindNearby method results, then checking each location object. This was necessary because the time zones don't follow state lines. If the type wasn't one of a few already defined, we looked for "GMT" in the name. This would yield, "Pacific (GMT-8)" or "Eastern (GMT-5)", etc. Apparently, this either isn't in the US database anymore, or they don't have that in the name. Does anyone know? I can't install mappoint 2010 on my dev machine right now to test out what's happening.


Mattys Consulting
02-23-2012, 10:58 PM
That data seems to have been discontinued. Try importing an ESRI .shp file of time zones, right click on the shape and export to Excel.

02-24-2012, 07:30 AM
I'm not sure what exporting to Excel would accomplish, besides the fact I don't have an ESRI .shp file of time zones. Is that resource somewhere? I'm basically looking at the location to see what's near me to get the current country, city, state, etc. Knowing the timezone where you are is also necessary because the time I show is off of GMT time.


Mattys Consulting
02-24-2012, 08:38 AM
I found one for you on Google, Steve:
A map of the TZ timezones of the US (http://efele.net/maps/tz/us/)

My idea is to have you import all of your pushpins which will then appear within one of the shapes.
You'd then export each time zone to a seperate Excel sheet and include a new column in your data table for TimeZone
If required, you can also have a column for how many hours devaition from GMT.
Then just re-integrate your data on a single sheet.

If you find this tedious, I could be coaxed into making some sort of addin that would append TZ data to your export.

02-24-2012, 08:57 AM
Ah, I think I see the issue now. My problem is we are doing all this programatically within our App. Mappoint is running as an embedded object using MFC as a ocx wrapper, and done in real time. If you import this to the map, does it show up as an object with FindNearby method?

Mattys Consulting
02-24-2012, 09:12 AM
No, you'd have to do a 'point in polygon' operation. Someone else might have a better idea, though.

Roger Allen
04-25-2012, 04:13 PM
I found that the best solution for timezone analysis is here OnTimeZone.com North American Time Zones (http://ontimezone.com/)
I have used this product in a couple of projects with great success.