Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Plot multiple markers on google maps with spatial data

Posted on 2011-03-14
1
Medium Priority
?
1,261 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
1 Comment
 
LVL 6

Accepted Solution

by:
worthyking1 earned 2000 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article discusses how to create an extensible mechanism for linked drop downs.
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…

810 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