In a database, a mechanism for optimizing access to data based on the spatial column(s) of a data table.

learn more… | top users | synonyms

2
votes
1answer
29 views

Indexing PostGIS table by tile boundaries

I have a PostGIS table with 2M rows, all Points. I'm creating tiles from the data, but it's quite slow. Although I have the normal geometry indexes enabled on the table, I wonder if it's possible to ...
2
votes
0answers
57 views

Match housenumbers on buildings (special case of point-in-polygon-test)

Task with example I'm working with geodata (country-size) from openstreetmap. Buildings are often polygons without housenumbers and a single point with the housenumber is placed within the polygon of ...
2
votes
0answers
966 views

How do you view the current spatial index grid size for a file geodatabase feature class?

I am receiving an "The spatial index grid size is invalid." error during a copy/paste of polygon features in ArcMap and I successfully corrected it with AddSpatialIndex. But in an effort to figure out ...
2
votes
0answers
210 views

How could I make this PostGIS query run faster?

SELECT st_band(rast, 1), st_width(rast), st_height(rast), st_bandpixeltype(rast, 1), st_bandnodatavalue(rast, 1), st_scalex(rast), st_scaley(rast), st_upperleftx(rast), st_upperlefty(rast) FROM ...
1
vote
3answers
2k 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.
1
vote
2answers
782 views

How to speed up spatialite-query using spatialindex?

I have got 2 tables, one of type LineLayer called strlayer, the other one is a PolygonLayer called blayer. The LineLayer contains two rows called fromBland and toBland that should be filled with an ...
1
vote
1answer
48 views

nearest N objects (points) [closed]

i'm searching nearest ten neighbor points from a given point. When i use this query: SELECT id, geom, ST_Distance(geography(geom), ST_GeographyFromText('SRID=4326;POINT(-0.22707 51.5444204)')) as ...
1
vote
1answer
63 views

ArcSDE PostgreSQL configuration parameters for Spatial Index?

I wonder why there is not any configuration parameter (DEFAULT Keyword) for spatial indexes in Arcsde for postgres. In ArcSDE for Oracle we have S_STORAGE,S_INDEX_SP_FID,S_INDEX_ALL parameter for ...
1
vote
1answer
224 views

Geoserver WFS features query inaccurate using SQL Server Backend with spatial index

I´m using Geoserver to query features through WFS in an Web Application with Openlayers as client. The queried layer is using SQL Server as backend storage. When applying a spatial index to the ...
1
vote
0answers
17 views

Spatialite Index not matching

I have a dataset containing GPS points I store in a table with a geometry column. I use the following code to populate my table. CREATE TABLE STOPS_GEO ( stop_id TEXT PRIMARY KEY, stop_desc TEXT, ...
1
vote
0answers
130 views

Using a ShapeFile spatial index with ogr2ogr and ogr.DataSource.ExecuteSQL()

I created a spatial index foo.qix for a foo.shp with ogrinfo -sql "CREATE SPATIAL INDEX ON foo" foo.shp However, when I do a query with ogr2ogr and look at it in strace, it doesn't use that index: ...
1
vote
0answers
75 views

Silly problem with spatial index?

I explain : I've got a points layer in .shp, it's allright, no problem with display( pan, zoom it's ok)… But when I create a spatial index, display of the map becomes crazy. It's not easy to explain ...
1
vote
1answer
55 views

Index to speed up ST_HausdorffDistance?

When comparing similarity of linestrings with ST_HausdorffDistance (or another type of similarity function), is there a way to use an index to speed up the search for similar linestrings?
1
vote
0answers
42 views

Cannot see shapes in ArcCatalog or ArcMap after creating spatial indexes? [closed]

I created a spatial index on a feature class, but when I try to load it in ArcMap, I cannot see the shapes. When I remove the spatial index, I can see the shapes in ArcMap/ArcCatalog.
1
vote
1answer
82 views

PostGIS Spatial Index not used after copying table

I am copying a PostGIS database from my computer to our webserver. I always had problems to copy the entire database using pg_dump and pg_restore so I am creating a new database on the server and copy ...
1
vote
0answers
159 views

mongoDB query not working as expected

My mongoDB collection has all three types of shapes. A point is stored as { 'CE_NO': '_', 'E_NAME': 'RAILWAY BOOKING CENTER', 'SRCTYPE': 'Facility', 'geom': { 'coordinates': [ ...
1
vote
0answers
70 views

Indexing GIS data associated with user with timestamp

I have data for each user in this format user1:(timestamp,lattitude,longitude) user1:(timestamp1,lattitude1,longitude1)..... Here the 1 at the end of timestamp/lat/long is to specify a different ...
1
vote
0answers
254 views

Adding multiple layers to Tilemill from a single sqlite DB

This is a repost of a question I had over at the MapBox support board. Since I wasn't having much luck over there, I'm hoping I would have better success here. I'm having trouble adding more than a ...
0
votes
1answer
84 views

Is there a way to force ArcCatalog to use a specific tessellation scheme for a SQL Server spatial index?

If I Recalculate a spatial index from ArcCatalog, the tessellation scheme is always set to "Geometry Grid". Even when the previous index was Geometry auto grid. ArcCatalog always changes it back. ...
0
votes
1answer
57 views

Problem with spatial index PostGis

I'm using Postgis 2.1. I have this table with about 50k rows: CREATE TABLE rilevazioni ( geom geometry(Polygon), stimolo integer, tmstmp timestamp without time zone, id bigserial NOT NULL, ...
0
votes
1answer
42 views

How to create my own remote sensing index?

Using Landsat images how do I create my own indices to extract particular landuse? Are there any tool/ software for creating indices?
0
votes
1answer
222 views

Spatial search performance on a collection of Points in a PostGis database

Let's assume you have a huge PostGis spatial table (using Postgresql 9.2, postgis 1.5) : BIGTABLE ( p Point, someData varchar ) which contains millions of records. Each record has been created ...
0
votes
0answers
4 views

PyQgis - How to update a spatial index?

I am trying to speed up a QGIS plugin I wrote by adding a spatial index to a vector layer. The aim of my plugin is to simplify a line network by merging some of its features, based on some criteria. ...
0
votes
0answers
21 views

Spatial index in R - Performance enhancement on geospatial processing [on hold]

In my Geoinformatics studies, I often stumbled over the usage of spatial indices in spatial databases like here. However, I wondered if there is any possibility to use such indices in R in order to ...
0
votes
0answers
34 views

“Spatial index is to small” from same geodatabase

I have an interesting thing going on. I have an ESRI geodatabase which contains numerous (versioned) featuredatasets. When I export for example a featureclass to a shapefile and try to import the ...
0
votes
0answers
96 views

how to use spatial index in spatialite query

I posted this question originally nearest neighbor query in SpatiaLite. Thanks to the answer given I was able to get the query working on some test data. However I am having trouble applying a spatial ...
0
votes
1answer
202 views

How to disable spatial index creation by ArcSDE for Oracle Spatial

Working with arcsde 10.1 and oracle spatial 11g. I set the feature class in load_only_io before loading shape files. I am using geoprocessing tool (append) in arcgis to load shape file to ...
0
votes
0answers
66 views

Pointers to open source C/C++ code for converting Lat/Lon data into geo-spatial indices in a triangular or hexagonal grid?

I have a streaming data application which needs equal area geo-spatial indexing of input Lat/Lon observational data for locality of referencing. From reading, it would seem that a triangular or ...
0
votes
1answer
356 views

Is it possible to use JTS for calculations on data in geographic coordinates?

I have some spatial data that has all of its coordinates as lat/lon pairs (with about 10 digits decimal precision), it's stored in a database as WGS84 data. Some of the data is represented as polygons ...
0
votes
0answers
341 views

Spatialite, to speed performance, when should I create Views, Indexes or additional spatial tables?

I’ve got a large Spatialite database with a table of lines (roads, rail and water). I created a spatial index of the geometry to speed things up. This works amazingly well when I’m zoomed in ...