Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Plotting markers on a google map

Status
Not open for further replies.

G12Consult

Programmer
May 12, 2016
77
AU
Hi,

I have a table with lat and long fields. I also have geolocation field which I populate using the following StoreProc.

Code:
USE [property]
GO
/****** Object:  StoredProcedure [dbo].[spUpdateGeoCodes]    Script Date: 19/05/2016 22:40:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateGeoCodes]



AS
BEGIN

SET NOCOUNT ON;

UPDATE [dbo].[Properties]
SET [Geocode] = geography::STPointFromText('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + 
                    CAST([Latitude] AS VARCHAR(20)) + ')', 4326)


END

I now need to know how I can populate a list of those values on a google map?

Most of the tutorials I see online, dont use the new geography field. just lat and long.

Thanks
Andrew
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top