Last modified: 2012-07-13 21:16:16 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T40337, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 38337 - Add search by point for the monuments database
Add search by point for the monuments database
Status: RESOLVED FIXED
Product: Wiki Loves Monuments
Classification: Unclassified
API (Other open bugs)
unspecified
All All
: Unprioritized enhancement
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-07-11 19:21 UTC by Maarten Dammers
Modified: 2012-07-13 21:16 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Maarten Dammers 2012-07-11 19:21:39 UTC
At the moment we use bounding boxes (bbox) to return nearby monuments. Would be better to have an option to give the lat/lon and return the nearest monuments. 

http://owlz.org/?url=http://toolserver.org/~erfgoed/layar/location.html gives an idea of how the result would look
Comment 1 Max Semenik 2012-07-12 23:11:14 UTC
r 743.
Comment 2 Maarten Dammers 2012-07-13 20:17:23 UTC
If I understand this correctly your taking a point, build a bounding box around that point and than use the bounding box to get points.

Isn't it possible to ask the database the 100 nearest points from a certain point? Or do we need a pre-compiled table like prox_search for that?
Comment 3 Max Semenik 2012-07-13 21:16:16 UTC
(In reply to comment #2)
> If I understand this correctly your taking a point, build a bounding box around
> that point and than use the bounding box to get points.
> 
> Isn't it possible to ask the database the 100 nearest points from a certain
> point? Or do we need a pre-compiled table like prox_search for that?

I don't tink it's possible to do performantly in SQL.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links