none
Latitude/Longitude RRS feed

  • Question

  • Hi,

    I've a SQL query that uses Latitude and Longitude to convert them in to geography as follows:

    geography::STPointFromText('POINT('
       + CAST([GIS_LONGTD_NO] as VARCHAR(10))
       + ' '
       + CAST([GIS_LAT_NO] AS VARCHAR(10))
       + ')', 4326) AS GEODATA 
      
    We've promoted both of the attributes to OLAP as two new attributes in our dimension table.

    Can you please help me know how will I convert these newly promoted attributes to return something similar to "geography" in SQL. The final goal is to plot this data on SSRS Maps. Any alternative suggestions are welcome as well.

     

    Thanks,

    NS

    Thursday, January 13, 2011 12:12 AM

Answers

All replies