Question : I have a table x like this: Columns: SubjectID int(11) Timestamp bigint(20) fix_geom point When i try to […]
Tag: spatial
Over 99 million records with geography column & spatial index – VERY VERY VERY slow queries!
Question : I’ve been working with SQL Server for a long time but have only recently encountered the need to […]
SQL geography::point null parameter error when parameter is not null?
Question : I was getting this error: ‘geography::Point’ failed because parameter 1 is not allowed to be null. On this […]
How does R-Tree outperform B-Tree for simple check if a point is within a rectangle
Question : For things like find nearest neighbors, I can undertand that R=Tree can outperform B-Tree. R-Tree can kick out […]
Does MySQL or MariaDB support GIS KNN Index Queries (k-nearest neighbors)?
Question : Can you do k-nearest neighbors algorithm (k-NN) queries on MySQL for example, to find the nearest point in […]
implement geo / spatial / proximity search with php and mysql — what have you done successfully [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Why I can’t calculate the distance between a fixed point and a geometry field of a MySql table using this distance function? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
PostGIS vs. SQL Server for GIS data
Question : So I’m recently starting at a new company and have a lot of ArcGIS users who seem really […]
MySQL Syntax – Searching points within polygons using GeomFromText
Question : I am trying to select points within polygons using the GIS/spatial extensions for MySQL. I’m fairly new to […]
How to optimize STDistance execution?
Question : I am creating temporary table during stored procedure execution with the following structure: [ID] BIGINT [Point] GEOGRAPHY the […]