Re: Cassandra Geospatial Search

[Hiller, Dean]

We have not quite gotten to it yet and has been driven by paying customers
at this time and there is one customer who wants it but they themselves
keep pushing it out for other things they want.

Thanks,
Dean

On 2/15/13 4:16 PM, "Drew Kutcharian"  wrote:

>Hey Dean, do you guys have any thoughts on how to implement it yet?
>
>On Feb 15, 2013, at 6:18 AM, "Hiller, Dean"  wrote:
>
>> Yes, this is in PlayOrm's roadmap as well but not there yet.
>> 
>> Dean
>> 
>> On 2/13/13 6:42 PM, "Drew Kutcharian"  wrote:
>> 
>>> Hi Guys,
>>> 
>>> Has anyone on this mailing list tried to build a bounding box style
>>>(get
>>> the records inside a known bounding box) geospatial search? I've been
>>> researching this a bit and seems like the only attempt at this was by
>>> SimpleGeo guys, but there isn't much public info out there on how they
>>> did it besides the a video.
>>> 
>>> -- Drew
>>> 
>> 
>

Re: Cassandra Geospatial Search

[Drew Kutcharian]

Hey Dean, do you guys have any thoughts on how to implement it yet?

On Feb 15, 2013, at 6:18 AM, "Hiller, Dean"  wrote:

> Yes, this is in PlayOrm's roadmap as well but not there yet.
> 
> Dean
> 
> On 2/13/13 6:42 PM, "Drew Kutcharian"  wrote:
> 
>> Hi Guys,
>> 
>> Has anyone on this mailing list tried to build a bounding box style (get
>> the records inside a known bounding box) geospatial search? I've been
>> researching this a bit and seems like the only attempt at this was by
>> SimpleGeo guys, but there isn't much public info out there on how they
>> did it besides the a video.
>> 
>> -- Drew
>> 
> 

Re: Cassandra Geospatial Search

[Hiller, Dean]

Yes, this is in PlayOrm's roadmap as well but not there yet.

Dean

On 2/13/13 6:42 PM, "Drew Kutcharian"  wrote:

>Hi Guys,
>
>Has anyone on this mailing list tried to build a bounding box style (get
>the records inside a known bounding box) geospatial search? I've been
>researching this a bit and seems like the only attempt at this was by
>SimpleGeo guys, but there isn't much public info out there on how they
>did it besides the a video.
>
>-- Drew
>

Re: Cassandra Geospatial Search

[Joe Stein]

what about using geo hashes http://geohash.org/dr5ru2mevjppe

store as column names the geo hashes

geohash#dr5ru2mevjppe
geohash#dr5ru2mevjpp
geohash#dr5ru2mevjp
geohash#dr5ru2mevj
geohash#dr5ru2mev
geohash#dr5ru2me
geohash#dr5ru2m
geohash#dr5ru2
geohash#dr5ru
geohash#dr5

the rows is what you want to return

do a MultigetSliceQuery like this
https://github.com/joestein/skeletor/blob/master/src/test/scala/skeletor/SkeletorSpec.scala#L171

the column value you can hold some json objects or more serialization on
relationships from there, maybe persisted graph structure

here are my slides on how we do this and what for
http://files.meetup.com/1794037/jstein.meetup.cassandra2002.pptx

On Wed, Feb 13, 2013 at 8:42 PM, Drew Kutcharian  wrote:

> Hi Guys,
>
> Has anyone on this mailing list tried to build a bounding box style (get
> the records inside a known bounding box) geospatial search? I've been
> researching this a bit and seems like the only attempt at this was by
> SimpleGeo guys, but there isn't much public info out there on how they did
> it besides the a video.
>
> -- Drew
>
>


-- 

/*
Joe Stein
http://www.linkedin.com/in/charmalloc
Twitter: @allthingshadoop 
*/

Cassandra Geospatial Search

[Drew Kutcharian]

Hi Guys,

Has anyone on this mailing list tried to build a bounding box style (get the 
records inside a known bounding box) geospatial search? I've been researching 
this a bit and seems like the only attempt at this was by SimpleGeo guys, but 
there isn't much public info out there on how they did it besides the a video.

-- Drew