Skip to main content
Geographic Information Systems

Return to Question

fixed formatting
Source Link
edit approved Jun 14, 2016 at 14:49
Matt
edit approved Jun 14, 2016 at 14:49
Matt
  • 1.7k
  • 18
  • 24

This is the Query I am using now..

SELECT top 1 coloumname FROM tablename WHERE ROUND ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2 ORDER BY ROUND((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2)

 SELECT top 1 coloumname FROM tablename WHERE ROUND
    ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2
    ORDER BY ROUND((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2)

howHow can I change this to using STBuffer.?

This is the Query am using now..

SELECT top 1 coloumname FROM tablename WHERE ROUND ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2 ORDER BY ROUND((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2)

how change this to using STBuffer.

This is the Query I am using now..

 SELECT top 1 coloumname FROM tablename WHERE ROUND
    ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2
    ORDER BY ROUND((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2)

How can I change this to using STBuffer?

Source Link
Ratheesh
Ratheesh
  • 115
  • 1
  • 9

How find Nearest points using STBuffer and STContains in SQLServer using given point from point table?

This is the Query am using now..

SELECT top 1 coloumname FROM tablename WHERE ROUND ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2 ORDER BY ROUND((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2)

how change this to using STBuffer.