I should be done with a source for California today or tommorrow. What I have laid out is two tables in a DB. One table basically has all the zipcodes in CA associated with regions. These regions are the regions that are the closest match for traffic data for each zipcode. So when in Mappoint you would get current zipcode and query this table for the region. Then I have a second table with has region, lat, long, streetname. You retrieve all the streetnames for a region and there lat/long. Then based on the streetname I have a C# function that gets all the current speeds from
www.sigalert.com. It is then very easy to add pushpins to Mappoint. Its only one state, but its a big one. When I finish I will give all I have to at least add California to this national traffic DB that is trying to be created.
Bookmarks