Top "Spatial-index" questions

Spatial Index in MySQL - ERROR - Cannot get geometry object from data you send to the GEOMETRY field

I am new to the whole 'spatial index' thing, but it seems to be the best solution for filtering based …

mysql geometry geolocation spatial-index mysql-error-1416

What is a SPATIAL INDEX and when should I use it?

Like most of the average PHP web developers I use MySql as a RDBMS. MySql (as other RDBMS also) offers …

mysql indexing spatial-index

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query and without using SET FORCEPLAN

I am running following: DECLARE @g geography; declare @point nvarchar(50) ='' declare @i int =0, @lat decimal(8,6) =0.0, @long decimal(8,6) =0.0, @start datetime = …

sql-server sql-server-2008 indexing spatial-index sqlgeography

How can I specify this SQL Index Hint on my SQL Server 2008 query?

I'm not sure where/how I specify this SQL Spatial Index hint on my query :- SELECT Whatever FROM Table1 …

sql sql-server-2008 indexing spatial spatial-index

MySQL: Invalid GIS data provided to function st_geometryfromtext

Here's my code: SET @poly = 'Polygon((-98.07697478272888 30.123832577126326, -98.07697478272888 30.535734310413392, -97.48302581787107 30.535734310413392, -97.48302581787107 30.123832577126326))'; SELECT name FROM county_shapes WHERE MBRContains(ST_GeomFromText(@…

mysql gis spatial-index mysql-5.7

Know of any C# spatial data libraries?

I'm looking at implementing spatial queries in .NET without using SQL2008. The first requirement is to be able to create …

c# .net spatial spatial-index

Speeding up PostgreSQL query where data is between two dates

I have a large table (> 50m rows) which has some data with an ID and timestamp: id, timestamp, data1, ..., …

sql performance postgresql spatial-index

Selecting a good SQL Server 2008 spatial index with large polygons

I'm having some fun trying to pick a decent SQL Server 2008 spatial index setup for a data set I am …

sql-server-2008 geospatial spatial spatial-query spatial-index

How can I speed up this Sql Server Spatial query?

I have (what I think) is a simple Sql Server spatial query: Grab all the USA States that exist inside …

sql-server-2008 performance spatial spatial-index

libspatialindex and Rtree on python

Okay, so I am trying to install libspatialspatialindex to my Ubuntu machine python. I did follow all the instructions and …

python-2.7 ubuntu python-3.x spatial-index r-tree