Hi Samuel,
You might want to look at pre-computing bounding boxes. That will
enable you to run an equality search to narrow down your result-set
(filtering some items in memory) and you'll still be able to order by
some other property. You may need to fetch results from multiple
bounding boxes to get the radius you want.
The idea is very simple and intuitive, effectively you store a list
of 'boxes' with a progressively lower resolution. You accuracy in a
'known' way so that you can pre-compute the boxes and run equality
queries at the appropriate resolution.
Here are a few resources discussing this topic:
http://code.google.com/appengine/articles/geosearch.html
http://code.google.com/p/geomodel/
Robert
On Thu, Feb 24, 2011 at 12:53, Samuel <samu.mor...@gmail.com> wrote:
> Hello,
> I'm using geohashes to geolocate some entities (I'm using Java, but it
> doesn't matter too much). I store millions of those entities and I query
> them to show no more than 100 of them on the map. As I can only sort by the
> same field of the inequality filter (the geohash field), all the results
> appear in the bottom-left corner of the map, even if I don't specify a
> sorting field.
> Obviously, it'd be much nicer if I could retrieve entities that are spread
> on the map (sorting by creation date would be fine, but it's not possible if
> you filter by geohash). Other possible solution is split the query in
> smaller square portions of the map, but the same problem persists in the
> bottom-left corner of each portion.
> Have any of you solved a similar problem?
> Thanks!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To post to this group, send email to google-appengine@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/google-appengine?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
