Top "Spatial" questions

Spatial data types store geometric data, that is data related to an object's position in space.

NoSQL and spatial data

Has any of you had any experience with using NoSQL (non-relational) databases to store spatial data? Are there any potential …

gis nosql spatial spatialite
Calculate Minimum Bounding Rectangle Of 2D Shape By Coordinates

I have a solution that uses spatial data to represent a cluster of points on a map. I have the …

c# algorithm spatial mbr
SQL Spatial Join

I have 2 tables one with points as geographies and other with polygons as geographies. I am able to find which …

sql join spatial
Union all geometry in a SQL Server table like GeomUnion in Postgres

Just to clarify up-front: I'm talking about unioning geometry, not the SQL keyword UNION. I'm trying to move some spatial …

sql sql-server-2008 spatial
Spatial Data in PostgreSQL

PostgreSQL supports a variety of geometric types out of the box, along with lots of geometric operators and GiST indexes …

postgresql spatial
Check if point is in spatial object which consists of multiple polygons/holes

I have a SpatialPolygonsDataFrame with 11589 objects of class "polygons". 10699 of those objects consists of exactly 1 polygon, however the rest of …

r polygon geospatial spatial point-in-polygon
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
Principal component analysis (PCA) of time series data: spatial and temporal pattern

Suppose I have yearly precipitation data for 100 stations from 1951 to 1980. In some papers, I find people apply PCA to the …

r spatial pca temporal
Query points within a given radius in MySQL

I have created the following MySQL table to store latitude/longitude coordinates along with a name for each point: CREATE …

mysql database gis spatial mysql-spatial
Correct way of finding distance between two coordinates using spatial function in MySql

I am trying to calculate distance between two locations using spatial functions in both Mysql and PostgresSQL. I have taken …

mysql gis spatial