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

  • General discussion

  • In reviewing the following interesting article:


    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


    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,


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