Solved

Populate a Chart/Map Dynamically

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

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…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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…

679 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