spatial
What is ST in PostGIS?
Almost all the functions in PostGIS s开发者_如何学Gotart with ST. e.g. ST_Distance_Sphere, ST_GeomFromText, ST_Intersection, etc.[详细]
2023-03-31 19:07 分类:问答How do I use the DbGeography Spatial Data Type with EF4.1
I\'m using Entity Framework 4.开发者_开发技巧1 Code First and have been trying to add a field to represent a Geography column.However, the datatype DbGeography is not recognized.I\'ve found references[详细]
2023-03-27 10:27 分类:问答Bulk-load algorithm for MX-CIF quadtree
My application loads a collection of ~100k items (rectangles) from a map file, then builds a MX-CIF quadtree as an index for fast lookup.The quadtree is built at startup and its contents do not change[详细]
2023-03-26 14:18 分类:问答Best solution for 2D occlusion culling
In my 2D game, I have static and dynamic objects. There can be multiple cameras. My problem: Determine objects that intersect with the current camera\'s view rectangle.[详细]
2023-03-26 09:00 分类:问答Umbraco: Storing spatial data
I\'m researching Umbraco for use as a base in a large CMS project, however the project calls for the SQL Server 2008 database to store spatial data against content.[详细]
2023-03-24 06:27 分类:问答How to improve a spatial raster map using ggplot when compared to spplot?
How can I improve the legend of spatial raster map plot using ggplot when compared to a spplot() legend?[详细]
2023-03-23 09:40 分类:问答Is SQL Azure suitable for adhoc intensive SQL processing?
I\'m looking for some guidance on whether SQL Azure is a suitable platform for one-off, short-term intensive processing of a batch of SQL data. (i.e. \"crunching\" of d开发者_StackOverflow社区ata)[详细]
2023-03-22 22:02 分类:问答2D Spatial partitioning alternatives to spatial hashes and quadtrees
I\'ve been 开发者_高级运维trying to implement a spatial partitioning algorithm in my game, but both spatial hashes and quadtrees aren\'t what I\'m looking for.[详细]
2023-03-22 13:48 分类:问答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 分类:问答find closest lat long to a input lat long Sql server 2008
Hi I have a point cloud in my database (Sql server 2008 spatial). That is about 6 million records. There are 3 columns: id, value , geom.[详细]
2023-03-17 14:31 分类:问答