Color(HSV) Spatial Queries

[justin alexander]

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.