Populate a Chart/Map Dynamically

We have an ASP.Net application that is database driven.  We have various data elements in the database for example resident info and their zip codes.  Currently, we allow a report to be run that may display zip codes and a count of residents for each zip code:

For example:

Zip Code              Count of Residents
48596                   20
48247                   30

etc...

We are interested in being able to display this data on a map and have it display dynamically each time the report is generated.  We are looking specifically for a map of Michigan where we can display dynamic data by zip code, city, or county.  These would each be different maps we assume and it may be something like a plain outline map where an area is colored in when data is availabe for that zip code or city or county (populatd the number of residents and the zip code or city name or county name).

Any suggestions would be greatly appreciated.  
sam1492Asked:
Who is Participating?
 
TimSledgeCommented:
Here's a resource:  http://www.mapgraphics.com/

There may be an easier way to do it, but I would first load the background map image (I might use absolute positoning for this.) with a z-index value that is low enough to make sure what comes next goes on top of it.

In the database, I would give each area and set of info an ID number.  In the code behind the web page, I would use Select Case for the different ID numbers.  For example if the ID number is one, Select Case picks up the value and turns on a label that is absolutely positioned over the right spot on the map and turns off (visible=false) all the other labels on the other parts of the map.  Before the Select Case statement I would populate a string variable with the data pulled from the database for ID 1.  In the Case 1 section I would populate the label's text with the string variable.  If a differment map background were being used for each ID, the image url could be reset under each case value as well.
0
 
manavsiCommented:
well since u have the zipcodes ready in ur hand y dont u opt for Google Maps API?? It can display that red pointer where ever u want...

Link: http://code.google.com/p/gmaps-utility-library/

This utility library release officially by Google, has a lot of markers... of ur choice..

HTH
Manavsi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.