Questions tagged [spatial-index]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
49 views

Multiprocess Spatial Join with Spatial Index

I'm a newbie in implementing GIS on Python, but the lack of any GIS software at the office has forced me to learn about it. I have a huge grid (a multipolygon) that I'm currently filling out with ...
0
votes
0answers
26 views

Spatial index not speeding up spatialite query containing Multipoint Geometry Data?

I am querying a sqlite format geodatabase in which there is a label for each geometry shape. Think of data as : label = name of a district in your state geometry: polygon which specify the ...
3
votes
1answer
123 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 ...
3
votes
1answer
125 views

Getting the largest rectangle in the R-tree index of a PostGIS table?

Is it possible to use SQL or PL/pgsql to get the largest rectangle in the R-tree index (or other types of indices) of a table, so that it can be used as Bounding box for PostGIS table? If possible, ...
2
votes
1answer
98 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 ...
1
vote
1answer
131 views

Distance between point and line layers & spatial index issue

I am trying to compute on QGIS the distance from some clusters (ie points) to their closest road (ie lines); no need for all combinations, just the distance from each cluster to the closest road. To ...
0
votes
1answer
47 views

Export NDVI values from chart as JSON in Google Earth Engine

After filter OLI8 for a small area var collectionFilter = ee.ImageCollection('LANDSAT/LC08/C01/T1_RT_TOA') .filterBounds(geometry) .filterMetadata('CLOUD_COVER','less_than',4) .map(app); print(...
0
votes
0answers
58 views

Spatial index for a raster column in a table in PostGIS

I have a raster table in PostGIS. When I run ST_SetValue(rast, geom , value) on it to change the pixel value at a point, it works very slowly. Do you know how can I create spatial index for a raster ...
0
votes
0answers
42 views

Transfer indexed Oracle geoloc table to PostgreSQL using ogr2ogr

I am copying tables using ogr2ogr from Oracle to PostGIS using ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME&...
4
votes
0answers
254 views

When does a QGIS .qix spatial index of a shapefile need to be re-created?

I understand the basics of spatial indexes but would like to understand when exactly a spatial index would need to be re-created or updated? The reason I ask is because when a folder was moved to a ...
1
vote
1answer
28 views

Finding Rows Inside other Rows

So I have database with which I want to do the following: Find out which other rows are contained within the geometry of the row in question. To keep it simple, I am finding the envelope/bbox of the ...
2
votes
1answer
186 views

QGIS3 Creating spatial index in a standalone script as a part of output vector layer

I am making a buffer analisys in a standalone script. Is it possible to automatically during the analisys add index to the output vector layer (".qix" file)? I tried to add after the analisys like in ...
6
votes
2answers
400 views

Building spatialindex in Postgres with JNDI for GeoNetwork?

Which steps should be taken to build the spatialindex table inside PostgreSQL when using a JNDI connection? Is the table built by GeoNetwork or does it need to be created manually? What I have ...
1
vote
1answer
59 views

GIST index not used by query optimizer on geometry field

I'm trying to add elevation curves on an OpenStreetMap tile server I'm currently building. I created a table in PostgreSQL to store the shapes of the whole world. Structure was defined by gdal_contour ...
2
votes
1answer
165 views

postgis: scaling / optimization of shortest distance between two geometries (seeking recommendations)

I have two tables in postgis: one with 1B rows containing points (POINT, 4326)::geometry the other, with 250k rows containing linestrings also in 4326 Both tables have a GIST index. I am trying to ...
6
votes
0answers
69 views

Calculate volume of space defined by multiple overlapping 3D polygons

I have thousands of 3D polygons scattered in space but they mostly overlap with many of their neighbors in big extent. Is there any way how to compute volume they define effectively? I would love ...
2
votes
0answers
103 views

Adding Spatial Index for Geometric Network?

I am trying to create Spatial Indexes on all the feature classes in one of my databases. It has worked fine on most feature classes so far, but when I started on feature classes in a feature dataset ...
1
vote
0answers
45 views

PostGIS: Is it interesting to create an index on geom column and an alpha numeric field?

I would like to know if it's interesting to create an index on an other column than the geom one. In some cases, I would like to do spatial analysis. If not, I would like to analyse only attributes. ...
3
votes
1answer
134 views

Spatial Index on 100s of Millions of Records Taking Days in PostGIS? [closed]

I have a table with ~200million spatial records in it, and it is taking days to build a spatial index on the one geometry column: should this be taking so long? The geom column is of the type ...
0
votes
2answers
50 views

Creating index file in FME 2018?

Is there a transformer to create a index file for my shapefile output? As a .qix file on QGIS.
2
votes
0answers
216 views

SP-GiST for geography type in PostGIS

This CREATE INDEX geography_gdx ON schema.table USING GIST (geog); works, but CREATE INDEX geography_gdx ON schema.table USING SPGIST (geog); gives me [42704] ERROR: data type geography has no ...
1
vote
1answer
41 views

QgsfeatureRequest - Store result indexes

I recently posted a question. My original goal was to find a way to determine on which side of a line points are located. @xulnik answered this question with two codes. One returns a binary [0;1] ...
2
votes
0answers
226 views

Optimizing MySQL query to select all points with in a large polygon using spatial indexes

Re-posting it from stackoverflow as per their suggestion. Link to the thread in stackoverflow https://stackoverflow.com/questions/53182385/optimizing-mysql-query-to-select-all-points-with-in-polygon-...
0
votes
1answer
97 views

Chronological sort & indexing problems with QGIS Time Manager

I am trying to use QGIS Time Manager to create an animated map of property connected to polygon-geometry. The one article on animating polygons I've found on this site hasn't helped because my data is ...
1
vote
0answers
221 views

QGIS does not seem to make use of spatial index when using GeoPackages

I have a QGIS project with several Geopackage-Layers. The project is quite slow in comparison to a project with shapefile or database layers. I started QGIS together with DebugView to find out what ...
3
votes
2answers
922 views

Creating Spatial Index for Geopackage using QGIS?

Working in QGIS 2.18.14 standalone on Windows, is there a way to create a Spatial Index for Geopackage (gpkg) layers?
3
votes
2answers
204 views

Query slowed down by gist-index on points

So I have this simple query, selecting all points in my table that are within a given polygon: WITH my_polygon as ( SELECT ST_GeomFromEWKT('<EWKT polygon>') as geom ) SELECT count(*) FROM ...
2
votes
3answers
3k 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.
6
votes
2answers
239 views

Geometry distance PostGIS query with <-> operator suddenly much slower

One of my websites suddenly got much slower, and I've managed to track down the issue to a query that uses the <-> operator together with ORDER BY (2D distance between two geometries) to ...
1
vote
0answers
97 views

Which approach is faster for getting all POIs from MySQL/MariaDB with PHP/Laravel [closed]

Correct me if I'm wrong. There are three approaches to get the nearest homes, users have created in my website: To create a table with two columns(latitude, longitude) that both of them are float ...
5
votes
1answer
172 views

QgsSpatialIndex.nearestNeigbor() unexpected result

I have a Linestring layer for which I have build a QgsSpatialIndex with the following code: my_linestrings_lyr_idx = QgsSpatialindex() for f in my_linetraings_lyr.getFeatures(): ...
0
votes
0answers
149 views

Storing a Spatial Index in Sqlite

I would like to store an r-tree or quadtree index in a sqlite database using python. Does anyone know if there is any code to do this? A bit of background: The dataset cannot be moved to another ...
6
votes
1answer
282 views

3D time dimension (x,y,t) [closed]

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 ...
3
votes
0answers
184 views

Geoserver ImageMosaic ignores existing datastore.properties (connect to PostGIS) and automatically generates index using shapefile

I am new to Geoserver. I am trying to publish a WMS service for a raster time series using the ImageMosaic plugin in Geoserver. I am using the sample dataset and instructions at this link I want to ...
0
votes
1answer
617 views

Errors in creating spatial index on SDO_GEOMETRY column in Oracle 11g

I am using Oracle 11g (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production) and I have a table that has column of type SDO_GEOMETRY. I want to create a spatial index on this ...
14
votes
1answer
1k views

sql server spatial index performance

I have a table with around 2 million records in it. I create a spatial index, using the defaults other than the bounding box. I've been noticing that some queries are extremely fast, and some are ...
2
votes
1answer
298 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 ...
0
votes
1answer
313 views

indexes to optimize ST_Contains and ST_Overlaps for geoms in two tables

I'm a programmer getting into the wonderful world of GIS. I just had a fun day optimizing queries (took one from 60s to 3.4s, and another from 38s to 1.2s). Below is the last query that I can't seem ...
4
votes
4answers
4k views

Spatial index to speed up the query

I have spatial table in PostgreSQL 9.2 / postgis 2.0 that I have to extract some information from it. But my query is hopelessly slow. How could I make use of spatial index to improve the performance ...
2
votes
0answers
299 views

Improve the speed for ST_DWithin

I need to get the outer polygon of the LSOAs within 10 miles of each postcode centroid. There are 180k LSOA polygons in table1 and 2.6 million postcode centroid points in table2. I have created 2 ...
9
votes
3answers
3k views

Create Spatial Index in PostGIS on an entire Schema

I have loaded a number of shapefiles using SPIT (QGIS plugin) to my PostGIS database. These layers did not have a Spatial Index created upon loading. I am wondering if there is a way to create a ...
0
votes
1answer
191 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. ...
-1
votes
1answer
267 views

Does Spatial Index make feature class faster? [closed]

Does spatial index make dataset work faster? Are there any disadvantages in having it? All datasets in my sde don't have a spatial index. I thought I should add it to make things faster
0
votes
1answer
129 views

how to index measurements with spatial coordinates

I am beginner with the RTree I use libspatialindex, I will want to know how I insert a polygon / point with a measurement (statistic or measurement of weather) do I have to change the structure ? ...
4
votes
0answers
93 views

Speed up identify in QGIS

I have just transferred my Postgis database onto an RDS server, and there is a bit of a performance hit when using the Identify tool in QGIS (3) compared to localhost. I presume this is mostly network ...
6
votes
5answers
5k views

PostGIS doesn't use spatial index with ST_Intersects

I imported the data from openstreetmap using osm2pgsql and copied it another table structure. If I made a query for containing rows using st_intersects, st_contain or someone else, postgis don't use ...
3
votes
0answers
98 views

Most performant KNN method in postgis (<->, <<->>, st_distance)

My question is about the fastest way to order query results by approximate distance. I've seen conflicting information about this. My data are lat/lng points stored using WGS84 (SRID 4326). The ...
1
vote
1answer
45 views

Where do spatial indexes look for SRIDs?

I'm looking into optimizing the spatial indexes on some of our tables (stored in SQL Server 2008 R2), so I ran exec sp_help_spatial_geometry_index @tabname='myTable', @indexname='...
1
vote
1answer
108 views

Spatial join by time in postgis

I have two tables in psql that I am trying to join based on certain attributes - they are very large - 17 M rows and 2.7 M rows respectively mydb=> SELECT reltuples::bigint AS estimate FROM ...
1
vote
1answer
635 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 shapefiles. I am using geoprocessing tool (append) in ArcGIS to load shapefile to geodatabase. ...