Solved

Plot multiple markers on google maps with spatial data

Posted on 2011-03-14
1
1,223 Views
Last Modified: 2012-05-11
Dear Experts,

I have a table holding spatial data in SQL 2008.  I would like to be able to plot this data onto a google map.  The data is returned via a recordset using classic ASP.

Can anyone point me in the right direction.

Thanks
0
Comment
Question by:grantballantyne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
worthyking1 earned 500 total points
ID: 35209605
When you say "spatial data" do you mean Lat/Long coordinates?

If you don't want anything fancy, just a static Google Map (without zoom etc.) then just use this URL to embed it:

http://maps.google.com/maps/api/staticmap?center=Brooklyn+Bridge,New+York,NY&zoom=14&size=512x512&maptype=roadmap
&markers=color:blue%7Clabel:A%7C40.702147,-74.015794&markers=color:green%7Clabel:B%7C40.711614,-74.012318
&markers=color:red%7Ccolor:red%7Clabel:C%7C40.718217,-73.998284&sensor=false

The above example is centered on the brooklyn bridge with three different color markers. Add as many markers as you want with the URL Param 'marker' like so:

&markers=color:blue%7Clabel:A%7C40.702147,-74.015794

For dynamic Javascript maps you can check out more in-depth methods here:

http://code.google.com/apis/maps/documentation/javascript/tutorial.html
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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Building JSON Results Table FROM DB 9 38
Jquery if else not working ... WHY? 5 26
javascript form - error when hitting enter 3 28
GitHub 1 10
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

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