Yes, that is part of it, but there is more to it. See Yonik's comment
about needs further down.
On May 12, 2009, at 7:36 AM, Norman Leutner wrote:
So are you using boundary box to find results within a given range(km)
like mentioned here: http://www.nsshutdown.com/projects/lucene/whitepaper/locallucene_v2.html
?
Best regards
Norman Leutner
all2e GmbH
-----Ursprüngliche Nachricht-----
Von: Grant Ingersoll [mailto:gsing...@apache.org]
Gesendet: Dienstag, 12. Mai 2009 13:18
An: solr-user@lucene.apache.org
Betreff: Re: Geographical search based on latitude and longitude
See https://issues.apache.org/jira/browse/SOLR-773. In other words,
we're working on it and would love some help!
-Grant
On May 12, 2009, at 7:12 AM, Norman Leutner wrote:
Hi together,
I'm new to Solr and want to port a geographical range search from
MySQL to Solr.
Currently I'm using some mathematical functions (based on GRS80
modell) directly within MySQL to calculate
the actual distance from the locations within the database to a
current location (lat and long are known):
$query=SELECT street, zip, city, state, country, ".
$radius."*ACOS(cos(RADIANS(latitude))*cos(".
$theta.")*(sin(RADIANS(longitude))*sin(".$phi.")
+cos(RADIANS(longitude))*cos(".$phi."))+sin(RADIANS(latitude))*sin(".
$theta.")) AS Distance FROM ezgis_position WHERE ".
$radius."*ACOS(cos(RADIANS(latitude))*cos(".
$theta.")*(sin(RADIANS(longitude))*sin(".$phi.")
+cos(RADIANS(longitude))*cos(".$phi."))+sin(RADIANS(latitude))*sin(".
$theta.")) <= ".$range." ORDER BY Distance";
This works pretty fine and fast. Due to we want to include this
within our Solr search result I would like to have a attribute like
"actual_distance" within the result. Is there a way to use those
functions like (radians, sin, acos,...) directly within Solr?
Thanks in advance for any feedback
Norman Leutner
--------------------------
Grant Ingersoll
http://www.lucidimagination.com/
Search the Lucene ecosystem (Lucene/Solr/Nutch/Mahout/Tika/Droids)
using Solr/Lucene:
http://www.lucidimagination.com/search
--------------------------
Grant Ingersoll
http://www.lucidimagination.com/
Search the Lucene ecosystem (Lucene/Solr/Nutch/Mahout/Tika/Droids)
using Solr/Lucene:
http://www.lucidimagination.com/search
