Solved

Populate a Chart/Map Dynamically

Posted on 2009-05-20
3
535 Views
Last Modified: 2012-05-07
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
Comment
Question by:sam1492
3 Comments
 
LVL 4

Accepted Solution

by:
TimSledge earned 125 total points
ID: 24436221
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
 
LVL 4

Assisted Solution

by:manavsi
manavsi earned 125 total points
ID: 24438125
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Achieve json result 2 65
Performance  Html.BeginForm vs jQuery 3 45
Error in page 3 44
Run time Error 4 34
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now