Solved

Populate a Chart/Map Dynamically

Posted on 2009-05-20
3
534 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
jQuery is a JavaScript library that greatly simplifies JavaScript programming. AJAX is an acronym formed from "Asynchronous JavaScript and XML."  AJAX refers to any communication between client and server, when the human client does not observe a…
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…

747 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