cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Malone <m...@simplegeo.com>
Subject Re: postgis > cassandra?
Date Mon, 07 Feb 2011 18:03:01 GMT
It's not really the storage of spatial data that's tricky. We use geojson as
a wire-line format at the higher levels of our system (e.g., the HTTP
API). But the hard part is organizing the data for efficient retrieval and
keeping those indices consistent with the data being indexed. Efficient
multi-dimensional indexing is tricky, but that's what you'll need if you
want to support generic spatial querying (overlaps, contains, interacts,
nearest neighbor, etc).

On Sun, Feb 6, 2011 at 1:14 PM, Aaron Morton <aaron@thelastpickle.com>wrote:

> Here is a recent presentation from simplegeo.com that may provide some
> inspiration
>
> http://strangeloop2010.com/system/talks/presentations/000/014/495/Malone-DimensionalDataDHT.pdf
>
> Can you provide some more details on the data you want to store and queries
> you want to run ?
>
> Aaron
>
> On 6/02/2011, at 7:04 AM, Sean Ochoa <sean.m.ochoa@gmail.com> wrote:
>
> That's a good question, Bill.
>
> The data that I'm trying to store begins as a simple point.  But, moving
> fo=
> rward, it will become more like complex geometries.  I assume that I can
> si=
> mply create a JSON-like object and insert it.  Which, for now, that works.
> =
>  I'm just wondering if theres a typical / publicly accepted standard of
> sto=
> ring somewhat complex spatial data in Cassandra.
>
> Additionally, I would like to figure out how one goes about slicing on
> large spatial data sets given situations where, for instance, I would like
> to get all the points in a column-family where the point is within a shape.
>  I guess it boils down to using a spatial comparator of some sort, but I
> haven't seen one, yet.
>
>  - Sean
>
> On Sat, Feb 5, 2011 at 9:51 AM, William R Speirs < <bill.speirs@gmail.com>
> bill.speirs@gmail.com> wrote:
>
>> I know nothing about postgis and little about spacial data, but if you're
>> simply talking about data that relates to some latitude & longitude pair,
>> you could have your row key simply be the concatenation of the two:
>> lat:long.
>>
>> Can you provide more details about the type of data you're looking to
>> store?
>>
>> Thanks...
>>
>> Bill-
>>
>>
>> On 02/05/2011 12:22 PM, Sean Ochoa wrote:
>>
>>> Can someone tell me how to represent spatial data (coming from postgis)
>>> in
>>> Cassandra?
>>>
>>>  - Sean
>>>
>>
>
>
> --
> Sean | M (206) 962-7954 | GV (760) 624-8718
>
>

Mime
View raw message