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.
Questions tagged [spatial-index]
281 questions
0
votes
1 answer
knn search for a trajectory (a line of points) in an r-tree
I have some trajectory data (a set of gps points, they are from the same trip so spatially close to each other). I want to find the k-nearest-line-segments for each of the point. I know that I can do a knn search in a RTree to get the knn for one…
daydayup
- 2,049
- 5
- 22
- 47
0
votes
0 answers
Can I use both spatial index and partition together
I have a table that has structure:
CREATE TABLE [dbo].[CompanyGeoLocationInfo](
[Id] [bigint] NOT NULL,
[CompanyId] [bigint] NOT NULL,
[Geocode] [geography] NOT NULL,
[GeocodeText] [varchar](100) NOT NULL,
[StateGroupId] [int]…
Sessiz Saat
- 1,079
- 8
- 20
0
votes
0 answers
Slow performance on mssql spatial queries
I have a table, dbo.ashfill_pointCloud, that consists of approximately 3 million geometry points. I then draw polygons (rectangles) and run a query to find the average of the z-values of all the points that lie inside that polygon.
The performance…
Nico Bos
- 185
- 1
- 10
0
votes
1 answer
Query Optimization Problems (spatial)
I have two datasets with spatial data.
Dataset 1 has approximately 15,000,000 records.
Dataset 2 has approximately 16,000,000 records.
Both are using the data type geography (GPS coordinates) and all records are points.
Both tables have spatial…
hcaelxxam
- 616
- 3
- 14
0
votes
1 answer
MDSYS.SPATIAL_INDEX syntax error
CREATE INDEX test_index ON cola_markets(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
I am creating an index on Oracle Spatial column, following the guidelines here at…
Weishi Z
- 1,629
- 5
- 18
- 38
0
votes
1 answer
Cluster on a spatial index
I am trying to cluster on spatial locality (Not just create a spatial index), but SQL Server does not allow this. To create a spatial index it first wants me to create a clustered primary key, which nothing makes sense to cluster on. I want to…
ParoX
- 5,685
- 23
- 81
- 152
0
votes
0 answers
Spatial Index for Intersects
I'm using SQL Azure and Entity Framework 6 and need to find which of 5000 areas (polygons) intersects with a point.
My code looks a bit like this
List
Mr. Flibble
- 26,564
- 23
- 69
- 100
0
votes
2 answers
Umbraco and Indexing
I have a Visual Studio project with 2 solutions:
Solution 1: UmbracoCms (Umbraco 7.2 code base)
Solution 2: SeachIndexer (lucene.net spatial - Windows Console Application)
In my solution 2 I have reference to the following .dlls from the Umbraco…
Huzzi
- 561
- 2
- 7
- 21
0
votes
2 answers
Undefined reference to libspatialindex functions in C++
I'm just getting started with libspatialindex. I ran through the instructions to install and it installed ok on ubuntu with the following commands (except I couldn't find autogen.sh which it mentions).
./configure
make
sudo make install
then I made…
Patrick64
- 430
- 6
- 12
0
votes
1 answer
Azure SQL Server Spatial Index Error Cannot create...because column is computed
[UPDATE] I tried the index definition below and received the following error message:
Cannot create primary xml, selective xml or spatial index 'SI_Property' on table 'BTSOne.dbo.Properties', column 'Point', because the column is computed.
This…
Will Lopez
- 2,089
- 3
- 40
- 64
0
votes
1 answer
RavenDB SpatialSearch SpatialGenerate IgnoredLuceueField
I'm having some trouble generating a SpatialIndex.
I want to get the closest event from a given location.
When I query my Coordinates has the value IgnoredLuceueField I think they mean LuceneField but it says Luceue so it's not a typo from me.
I…
user3066449
- 1
- 2
0
votes
1 answer
geoNear in MongoDB returns empty result
In MongoDB I have created a database named 'GIS' and a collection named 'UTILITIES'. I have inserted some GeoJSON elements as below
{
"_id" : ObjectId("54e6de457e550c23bc1521a0"),
"id" : "1",
"geometry" : {
"coordinates" : [
86.74957,…
Chandan Kumar Rath
- 147
- 1
- 14
0
votes
2 answers
MongoDB 2dsphere spatial index creation error
In MongoDB I have created a database named 'GIS' and a collection named 'UTILITIES' and within the collection I have inserted a BSON document as below.
{
"_id" : ObjectId("54e6b3ca7e550c1f4c2b47f6"),
"features" : [
{
"id" : "1",
…
Chandan Kumar Rath
- 147
- 1
- 14
0
votes
1 answer
Insert into MSSQL with spatial index from PHP fails
I have a stored procedure that inserts into a table with a spatial index on one of its fields.
When I run the procedure from SQL Server Management Studio it runs just fine.
When I run it from PHP, it returns the error:
"INSERT failed because the…
user3158212
- 555
- 6
- 16
0
votes
0 answers
Passing variables into a spatial index
I have the following code that allows me to define the bounding box of a spatial database:
with TEMP as(
select
MIN(geometry.STEnvelope().STPointN(1).STX) as X1
,MIN(geometry.STEnvelope().STPointN(1).STY) as Y1…
SteveC81
- 35
- 1
- 8