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
94 views

Bulk loading into pyrtree index

I'm using pyrtree to create an index for a point in polygon operation. I am currently trying to insert 1.8 million rows into the index and it takes more than an hour to do so. I am unable to use rtree ...
2
votes
2answers
78 views

Postgis Functional Index on st_pointonsurface() Ignored

If I define the following table... CREATE TABLE tbl_vast_importance( id bigserial PRIMARY KEY, geom geometry(MultiPolygon,4326) ); CREATE INDEX ON tbl_vast_importance USING GIST (geom); CREATE ...
2
votes
1answer
286 views

Basic sp-gist indexing?

Please forgive a very, very elementary question. I am using a PostgreSQL 9.3.5 database, and one of the tables stores longitude and latitude. (These are two separate columns.) I would like to do ...
2
votes
2answers
595 views

How to work with the STRtree Index when object in the index change it's position?

I'm work with the NTS(NetTopologySuite), I get large amounts of Point geometries, for fast querying the point object, I make the STRtree Index like this, STRtree tree = new STRtree(); foreach (var p ...
2
votes
2answers
417 views

3D KNN index in PostGIS

I am looking for a way to do fast KNN queries on a dataset of 10+ million 3D points (and growing). I was hoping PostGIS would do the trick with its new <-> and <#> operators, but they don't seem ...
2
votes
2answers
1k views

Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?

In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong... Points are in Oracle ...
2
votes
0answers
97 views

display issue in qgis 2.14 : features appear and disappear

I have several virtual layers in my project. One of them contains 6 lines. Depending of the scale, at least one line disappears from the canvas for an unknown reason. I heard that sometimes, creating ...
2
votes
0answers
21 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. ...
2
votes
0answers
38 views

In memory spatial index for frequent updating point objects

Is there any in memory spatial index specialized for frequent updating point objects? The dataset will be moving cars, most likely update per second but with millions of them. The project will be ...
2
votes
1answer
39 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
59 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
1k 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
219 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 public....
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
913 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
78 views

Using Postgis spatial index in st_distance operation based upon explicit SRID column

I have two large tables with data that spans over multiple regions of the U.S and needs a defined SRID column in atleast one the tables to denote which coordinate system should be used for area/...
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
90 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
317 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 ...
1
vote
1answer
273 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
22 views

3D time dimension (x,y,t)

I'm working with data points (x,y) and timestamp t as a separate attribute in my table. (x, y) are in WGS 84 latitude,longitude format while timestamp is in Unix Time. For instance (71.8, -13.5) and ...
1
vote
0answers
18 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
212 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
88 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
61 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
1answer
84 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
214 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
73 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
276 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
68 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
98 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
2answers
46 views

Building efficient multi geometry type database with PostGIS?

I'm trying to build a PostGIS database which must be able to store (multi)points, (multi)linestrings and (multi)polygons. The goal is to efficiently querying the data with ST_Intersects and other ...
0
votes
1answer
49 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
264 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
34 views

What is the impact of changing grid sizes while applying spatial index on specified table in SQL Server 2014

I have a Feature class with millions of points of interest (contains OID and geometry columns) which is stored in ArcSDE along with other non-spatial datatables which are stored in SQL Server DB . I ...
0
votes
0answers
37 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
131 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
406 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
412 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 close....