spatial-query
SQL Server 2008 Geometry.STBuffer(…) really slow
I’ve got a basic SQL query that looks like: SELECT TOP 1 [geom].STBuffer(500) FROM [db].[dbo].[boundaries][详细]
2023-03-22 12:45 分类:问答Most efficient way to get points within radius of a point with sql server spatial
I am trying to work out the most efficient query to get points within a radius of a given point. The results do not have to be very accurate so I would favor speed over accuracy.[详细]
2023-03-13 05:28 分类:问答Spatial index/query (finding k nearest points)
I have +10k points (latitude, longitude) and I\'m building an app that shows you the k nearest points to a user\'s location.[详细]
2023-03-06 04:07 分类:问答What ADO type is the Geography spatial type from SQL Server 2008?
I am looking to refactor this method (from Massive.cs by Rob Conery): public static void AddParam(this DbCommand cmd, object item) {[详细]
2023-02-24 06:27 分类:问答Uniform Grid Subdivision of Points in C#
I have a set P of 2D points that I could like to cluster in a 2D uniformly spaced grid, where each cell is length X.[详细]
2023-01-16 13:38 分类:问答How to implement Spatial(Geo-Location) searching in Grails?
I am working on Grails 1.3.2 with MySql. I need to store the latitude and longitude of certain locations in the database and then on the basis of the user\'s current location, I need to return the ite[详细]
2023-01-07 03:25 分类:问答Database procedure for locations
I\'m trying to store a database of GPS locations and run queries which find the points within a given radius and also the closest points.I\'m using mysql and have been looking at the spatial extension[详细]
2023-01-06 20:27 分类:问答Spatial querying, converting metres to radians?
I have geographic data that was loaded into the geography datatype. For very specific purposes, I now need to have store this as a geometry. However, I need to perform a query like this.开发者_StackOv[详细]
2023-01-04 03:50 分类:问答Data structure in python for 2d range counting queries
I need a data structure for doing 2d range counting queries (i.e. how many points are in a given rectangle).[详细]
2023-01-03 22:41 分类:问答Unable to retrieve computed distance in Spatial Solr queries
I\'m using this plugin to allow spatial queries in Solr. I have followed the steps included in the documentation and I\'ve got the spatial queries working fine.[详细]
2023-01-03 18:04 分类:问答