SQL Server 2008 Spatial: find a point in polygon

by

I think the geography method STIntersects() will do what you want:

DECLARE @g geography;
DECLARE @h geography;
SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);
SET @h = geography::Point(47.653, -122.358, 4326)

SELECT @g.STIntersects(@h)

More Related Contents:

  1. Should every User Table have a Clustered Index?
  2. SQL Server Configuration Manager cannot be found
  3. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  4. sql geography to dbgeography?
  5. How to split a comma-separated value to columns
  6. How to get a float result by dividing two integer values using T-SQL?
  7. Get first day of week in SQL Server
  8. SQL Server add auto increment primary key to existing table
  9. How to delete large data of table in SQL without log?
  10. Confused about UPDLOCK, HOLDLOCK
  11. Retrieve column definition for stored procedure result set
  12. Change Notification with Sql Server 2008
  13. Do while loop in SQL Server 2008
  14. Query times out when executed from web, but super-fast when executed from SSMS
  15. TSQL: How to convert local time to UTC? (SQL Server 2008)
  16. Regular Expressions in SQL Server servers?
  17. Unique constraint on multiple columns
  18. Connecting to MS SQL Server with Windows Authentication using Python?
  19. Transpose rows and columns with no aggregate
  20. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  21. How to find the port for MS SQL Server 2008?
  22. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  23. How to convert number of minutes to hh:mm format in TSQL?
  24. SQL Server recursive query
  25. Temporarily disable all foreign key constraints
  26. How do I move a table into a schema in T-SQL
  27. nvarchar(max) vs NText
  28. Using IF ELSE statement based on Count to execute different Insert statements
  29. In SQL Server, how can I find everywhere a column is referenced?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment