Stack Overflow
Stack Overflow

Questions tagged [spatial-index]

Spatial indexes are data structures the support searches and computation that depend on geometric relationships between the stored data (k-nearest-neighbors, identify elements in a defined region, etc). Use this tag for questions about selecting, writing, or using spatial indexes in your code, including the use of spatial indexes in database management systems.

281 questions
0
votes
1 answer

SpatialHadoop: no scaling with multiple computing nodes

I am using SpatialHadoop to store and index a dataset with 87 million points. I then apply various range queries. I tested on 3 different cluster configurations: 1 , 2 and 4 nodes. Unfortunately, I don't see a runtime decrease with growing node…
MsIcklerly
  • 69
  • 6
0
votes
1 answer

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 column (NEW_SHAPE). My query is as…
Amir
  • 685
  • 3
  • 13
  • 36
0
votes
0 answers

Elasticsearch ignore borders in Intersect query

So I query against preindexed shapes. Some shapes in the value index have the exact same border as in the shape index (as they are subshapes from them). When I query with one of those shapes I always get all values which only share the same boarder…
Dennis Ich
  • 3,585
  • 6
  • 27
  • 44
0
votes
1 answer

multi dimensional points in solr

Lucene added multi dimensional point support in 6.0 https://issues.apache.org/jira/browse/LUCENE-7494 How can I can use this in Solr? I am hoping for a "simple end to end example" It would be a worthy blog post. 1) define in the schema curl -XPOST…
Eric Hartford
  • 16,464
  • 4
  • 33
  • 50
0
votes
2 answers

Geomesa Location Indexing Is Not Accurate

I'm using Geomesa indexing used library for indexing 3D location data (Longitude, Latitude, Time) into 1D indexed data. Here's my Scala code var z3Indexer = new Z3SFC(TimePeriod.Month); var z3 = z3Indexer.index(24.664152, 46.692425, 2678400) var…
Mohamed Seif
  • 382
  • 1
  • 3
  • 14
0
votes
1 answer

MySQL spatial query to find all rows that deliver to set point

I have a table, stores, with thousands of stores that deliver. If i have the lat, lng, and delivery_radius for each store (I can add a point column), what is the most efficient way to query the table to see which stores can deliver to where I stand…
Patrick H.
  • 66
  • 11
0
votes
2 answers

Why is the R -tree unordered ? Yet it is said to follow the rules of the B-tree

OK, in the screenshot attached below is an R tree. It has R1 and R2 at the root. to the left of R1 is r3,r3,r5. Why is that? I thought that elements to the left of the root element should be less than. If the root element on the root was R6, then it…
coder85
  • 11
  • 2
0
votes
1 answer

Unable to remove a node from Neo4j Spatial index

Inside my TransactionEventHandler.beforeCommit() I'm trying to remove a node from the spatial index, after it was successfully added. But the node remains in the index and I still able to find it using spatial Cypher query. This is an excerpt from…
Victor Dombrovsky
  • 2,955
  • 3
  • 21
  • 33
0
votes
1 answer

SQLite function for R*-tree in C#

I need to write SQLite function circle. A query like the following will be used to find all R*Tree entries that overlap with a circle centered a 45.3,22.9 with a radius of 5.0: SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0) I have…
MyName
  • 357
  • 2
  • 4
  • 15
0
votes
1 answer

Geospatial search: varying radius receptors and fixed event point

Therms of the problem: given a certain point on the Earth we will call "event point" given a certain number of other points on the Earth, we will call "receptors" given that any receptor has a circular area around it, with a variable radius we will…
Michele Carino
  • 1,043
  • 2
  • 11
  • 25
0
votes
0 answers

N-dimensional vectors in PostgreSQL Spatial Index

I have many 8-dimensional vectors. And I want to construct on them a R-tree ('USING gist' in PostgreSQL). But I have got stucked at the choice of the correct geometrical type. Whether the 'path' type (each vector number as x and y coords of path)…
Vladislav
  • 43
  • 6
0
votes
1 answer

Using sdo_contains with transient object in Oracle

I have two varchar columns with wkt value (a polygon and a point). I want to know if there are a polygon that contains some point using Oracle. I'm using sdo_contains command, but don't work. According the documentation, the polygon should be…
Felipe
  • 49
  • 1
  • 8
0
votes
1 answer

Finding county to a road using STContains

Running SQL Server 2014 Standard I have about 1 million linestring (represent roads) and 98 polygons (counties). I want to update what county the road belongs to. My query: UPDATE RAW_HERE SET COUNTY = RAW_HERE_COUNTY.POLYGON_NM FROM…
LearningJrDev
  • 911
  • 2
  • 8
  • 27
0
votes
2 answers

Why doesn't this query use key(MySQL 5.7 spatial)?

I'm using MySQL 5.7.10, the storage engine is InnoDB. Below are the SQLs. 1. create table CREATE TABLE `geo` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `geo` GEOMETRY NOT NULL, PRIMARY KEY (`id`), SPATIAL INDEX `geo`…
user2400825
  • 185
  • 2
  • 15
0
votes
1 answer

Any spatial index support in the standard PostgreSQL installation?

I'm new to PostgreSQL. For the default install of PostgreSQL (no extension like PostGIS), if there's geographic fields defined in my table, then what kinds of index does PostgreSQL support? I didn't find any information on the spatial index in…
Lenik
  • 13,946
  • 17
  • 75
  • 103
1 2 3
…
18 19