MySQL Forums
Forum List  »  General

Color(HSV) Spatial Queries
Posted by: justin alexander
Date: February 02, 2010 12:45AM

Is it possible to use MySQL's spacial search to find points inside of a 3D polygon?

Or better still, is it possible to use MySQL to find the values on the surface of an HSV cylinder?

An example query might look like

Select *,hsvDistance(160,.2,.3, hsv) as dist FROM histograms ORDER BY dist LIMIT 0,100

It's not very difficult to create a procedure for hsvDistance, but it would need to iterate over every element of the database. This wouldn't scale beyond a few thousand records. I am hopping to optimize the problem using spatial indexes.

Can anyone help?

Edited 1 time(s). Last edit at 02/02/2010 12:56AM by justin alexander.

Options: ReplyQuote

Written By
Color(HSV) Spatial Queries
February 02, 2010 12:45AM
February 03, 2010 10:57PM

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.