Looking for help or info on using a map to search a database

Posted on 2005-05-03
Last Modified: 2012-05-05
I have a large web project that I'm working on that involves a database search for companies. To be more specific I want to be able to use a map say the map of Alberta and allow web visitors the ability to clickon various cities on the map. In turn they would get a list of home builders that build house in those cities. So my question is can anyone point me in to a website that can provide me  some help in that area, or has anyone done this and how did you build it. Was it in flash or what would be the best way to do it. Any help in this area would be appreciated thanks.

Question by:Duec
    LVL 29

    Expert Comment

    I did'nt finish this, and you would want to make the hotspots smaller, but this demonstrates how easy it is to do this with an image map.

    LVL 29

    Accepted Solution

    Below the map is the SQL querystring that would be executed assuming I had a table of builders by region.  As I said, you can reduce the size of the hotspots to query by city or other smaller areas.

    The ASP is overly simple for the example, but I think it is easy enough to see what will happen if we add the database access code.  The key is the query responding to the image click.


    LVL 10

    Expert Comment

    If you have lots of money, there's ArcWeb from ESRI.  See for an example.

    Author Comment

    Thanks rdivilbiss, I appreciate your help, I think I can work with this.
    LVL 29

    Expert Comment

    While I normally advise against WYSIWYG editors, image maps are much easier to do with that type of editor.  Sorry I didn't have a fancier example.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure ( It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
    Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
    The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following:…
    The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

    730 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

    18 Experts available now in Live!

    Get 1:1 Help Now