MySQL Forums
Forum List  »  GIS

WGS84 Data & distance queries
Posted by: Glenn Nead
Date: April 25, 2006 07:26PM

Does any version of MySQL support spatial of this nature?

-- World-wide lat/lon in WGS-84 (be able to handle 180E/W properly)
--- handle decimal degrees and/or DDDMMSS.SSH

-- Ability to query
--- all points w/in x nautical (or statute) miles of point X
--- all polygons w/in x nautical miles of point X
--- all polygons w/in (contained & intersected by) polygon P

We can do this now using Sybase and Spatial Query Server (SQS) and have been for 10 years, but the SQS portion is no longer supported (ie, no new compiles/updates). Oracle 8 was the last version of Oracle on our platform and couldn't support these queries correctly. Oracle 9 & 10 can, but our platform was dropped.

Platform is Silicon Graphics (SGI) Octane w/ IRIX 6.5.

The database supports a mission critical system.

-- Glenn

Options: ReplyQuote

Written By
WGS84 Data & distance queries
April 25, 2006 07:26PM
December 19, 2006 03:42AM
April 18, 2007 01:07AM
September 01, 2007 02:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.