locked
Bing Maps API - SQL CLR Get Geocode and SRID RRS feed

  • General discussion

  • In reviewing the following interesting article:

    https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/

    Should not the SRID 4326 be inserted somewhere in this forumula:

    -- Create a new geography Point by geocoding a provided address
    -- For any address elements unknown, simply supply an empty string
    DECLARE @g geography;
    SET @g = dbo.Geocode('10 Downing Street', 'London', '', 'SW1A 2AA', 'UK') <<Insert +',4326)' Perhaps Here>>;
    -- Retrieve the WKT of the created instance

    SELECT@g.ToString();

    Where does the SRID get inserted? And what formula does one use to find out the SRID that was inserted? Since you can Select Spatial.Lat= Latitude, is there not something similar for the SRID ?

    Thank you,


    John


    • Edited by vsla Monday, April 4, 2016 3:20 PM
    Monday, April 4, 2016 3:19 PM