In a geodatabase, a mechanism for optimizing access to data based on the spatial column of the business table.

learn more… | top users | synonyms

3
votes
2answers
3k views

How can I use R-Tree to find points within a distance in Spatialite?

Create a table with 3D points: create table points (coords pointz); select CreateSpatialIndex('points', 'coords'); Insert 13k rows: insert into points values (geometryfromtext('pointz(...)')) Do ...
4
votes
2answers
398 views

Spatial Indexes on OS MasterMap Data

What are the optimal settings for setting up a SQL Server 2008 Spatial database with full UK OS MasterMap data in? Seperate tables for the different feature types, or a single table with everything ...
4
votes
1answer
262 views

Spatial index vs two coordinates indexes

I have a table with two columns: latitude and longitude. I want to get all objects inside a "rectangular" (well, rectangular in a lat/lon coordinate metric) bounding box: min-max latitude and min-max ...
1
vote
3answers
1k views

C# library for bounds based geometry search

I am searching for C# library which has code that builds spatial index in memory based on geometry bounds and enables fast searching for all geometry inside given bounds. I prefer free library.
4
votes
1answer
517 views

Shorter Version of this SpatiaLite Query

I've been doing some spatial queries using spatialite, and they're large enough that a spatial index becomes a must. An example of using an index is given in the tutorial spatialite> SELECT ...
10
votes
3answers
2k views

optimize nearest neighbor query on 70 million extremely high density spatial point cloud on SQL Server 2008

I have about 75 million records in a SQL Server 2008 R2 Express database. Each is a lat long corresponding to some value. The table has geography column. I am trying to find one nearest neighbor for a ...
3
votes
1answer
2k views

How do I create a functional spatial index of an ST_Geometry Feature Class in Oracle/SDE?

Copied an SDE feature class (with blob(sdebinary(?) geom) into the same SDE GDB (Oracle 11g/SDE 9.3.1) but with the ST_geometry configuration keyword. I can see that the feature class was created, ...
4
votes
3answers
3k views

How to properly utilize DWITHIN Spatial Filter in OpenLayers

Given the following code: var points = []; points.push(new OpenLayers.Geometry.Point(-110, 38)); points.push(new OpenLayers.Geometry.Point(-108, 40)); var lineString = ...
11
votes
5answers
2k views

Speeding up OpenStreetMap PostGIS querying

I have OpenStreetMap data for the Netherlands loaded into a PostGIS database (PostgreSQL 8.3 / PostGIS 1.3.3) using the osmosis schema. This means all tags are stored in a hstore field. In addition to ...
7
votes
3answers
3k views

Poor Performance when using Spatial Indexes in MySQL

Re-post of a question asked on Stack Overflow when it was suggested this would be a better forum. I'm trying a little experiment at pushing a data set which is not geo-spatial but fits it quite well ...
4
votes
2answers
606 views

How to delete a broken index in SpatiaLite?

I managed to screw up an index in my SpatiaLite database. The index was created using spatialite-gui. In the meantime, I deleted the original table and three out of four index files: ...
5
votes
2answers
685 views

How does a quad-tree cope with very large objects?

If I use a quad-tree to index my map data, how does it cope with a road that goes from one end of the map to the other? What other sort of indexes should I consider to get round this problem?