[Geowanking] do cloud databases do spatial?

[Joshua Lieberman]

Same sort of problem as with introducing spatial "reasoning" for SCOTS  
knowledgebase tools. Difficult choice between shoehorning spatial  
logic into general-purpose tools, or hashing spatial (i.e. multi- 
dimensional) information to work with general-purpose query /  
inference. Ready to re-write JTS in Erlang?

On Nov 23, 2009, at 8:05 AM, Andrew Turner wrote:

> To open the question up - what are the example or best case interfaces
> and mechanisms of a "spatially-enabled cloud database"?
>
> And by "cloud" I mean internet accessible, on-demand, fast
> provisioned, near-limitless scaling without me having to do the
> administration. So setting up PostGIS/JTS/CouchDB are not cloud
> databases, just db's that people tend to run on horizontally scaling
> systems.
>
> As a first step, I'd like to see a GeoJSON API for a schema-less
> 'cloud' datastore that exposed an OpenSearch-Geo interface for
> querying it. Start with Point, but definitely needs to gain support
> more complex features as well.
>
> The store should be agnostic to the language I write my application  
> in.
>
> Andrew
>
> On Sat, Nov 21, 2009 at 12:52 PM, Josh Livni
> <josh at umbrellaconsulting.com> wrote:
>> You didn't mention if you're using java or python style appengine.   
>> If java,
>> then go w/Sean's recommendation (JTS) -- if python, I'd recommend  
>> GeoModel,
>> which unlike a standard geohash implementation will let you both  
>> query by
>> bounding box and still have access to your single inequality filter  
>> for
>> other items...
>>  -Josh
>>
>>
>> On Sat, Nov 21, 2009 at 2:14 AM, John McKerrell  
>> <john at mckerrell.net> wrote:
>>>
>>> As we're on this subject... a friend asked me recently if I knew a  
>>> way to
>>> get AppEngine to do bounding box requests, as far as he could tell  
>>> it wasn't
>>> possible, I had a look and I couldn't see a way either. I think  
>>> perhaps the
>>> issue was that he was using the GeoPt type but there's no way to  
>>> access the
>>> lat/lon from within it in a search so if he just stored the lat/ 
>>> lon as
>>> separate fields that might work better. It's not something I've  
>>> looked at
>>> too much but if anyone can offer a suggestion that would be good.
>>>
>>> He was originally asking my about geohashing in case that would  
>>> help but
>>> as far as I could tell it has the same problem as quadtiles in  
>>> that if
>>> you're on the edge of a big tile you don't find stuff on the next  
>>> tile. As
>>> it was a UK based app the meridian is likely to cause problems  
>>> there.
>>>
>>> John
>>>
>>> On 21 Nov 2009, at 02:00, Ivan Lucena wrote:
>>>
>>>> Oracle Spatial does work in the EC2 environment. Once you have an  
>>>> EC2
>>>> account you can go to OTN ,
>>>> http://www.oracle.com/technology/tech/cloud/index.html, and get  
>>>> an EC2 kit.
>>>> That means Features, 3D Point Cloud, Raster, the whole package.
>>>>
>>>> ________________________________________
>>>> From: geowanking-bounces at geowanking.org
>>>> [geowanking-bounces at geowanking.org] On Behalf Of Raj Singh
>>>> [raj at rajsingh.org]
>>>> Sent: Friday, November 20, 2009 2:29 PM
>>>> To: geowanking at geowanking.org
>>>> Subject: [Geowanking] do cloud databases do spatial?
>>>>
>>>> So, does Amazon SimpleDB do spatial?
>>>> http://aws.amazon.com/simpledb/
>>>>
>>>> Or how about MS SQL Azure?
>>>> http://www.microsoft.com/windowsazure/sqlazure/
>>>>
>>>> Any others to know about?
>>>>
>>>> ---
>>>> Raj
>>>>
>>>>
>>>
>
> _______________________________________________
> Geowanking mailing list
> Geowanking at geowanking.org
> http://geowanking.org/mailman/listinfo/geowanking_geowanking.org