Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

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.  
0
sam1492
Asked:
sam1492
2 Solutions
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now