You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Sean Ochoa <se...@gmail.com> on 2011/02/05 18:22:33 UTC
postgis > cassandra?
Can someone tell me how to represent spatial data (coming from postgis) in
Cassandra?
- Sean
Re: postgis > cassandra?
Posted by Mike Malone <mi...@simplegeo.com>.
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 <aa...@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 <se...@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 < <bi...@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
>
>
Re: postgis > cassandra?
Posted by Aaron Morton <aa...@thelastpickle.com>.
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 <se...@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 <bi...@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
Re: postgis > cassandra?
Posted by Sean Ochoa <se...@gmail.com>.
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 <bi...@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
Re: postgis > cassandra?
Posted by William R Speirs <bi...@gmail.com>.
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