home
SQL Spatial queries




MySQL server version 5.0 have some spatial capabilities. It can create and store geometry objects, as well as fetch them and check their relations using Minimal Bounding Rectangles (MBRs). Untill now it lacks advanced functions like Distance(), ClosestPoint() and other important features that are supposed to appear in the coming relise of MS SQLserver 2008. See article by Jason Follas: SQL Server 2008: Spatial Data


Some spatial data about Milan city 2008-02-23
Create points using SQLserver Spatial 2008-12-16
Create polylines using SQLserver Spatial 2008-12-16
View many spatial layers using UNION ALL (SQLserver Spatial) 2008-12-17
MySQL. Create and populate spatial table 2008-06-09
MySQL. Create polygon geometries 2008-06-09
MySQL. Function to measure distance between points in Lat Long 2008-06-12
MySQL. Check relations between geometries 2008-06-17



sqlexamples.info