[fdo-internals] FDO RFC 16 - FDO Provider for SQLite

[Frank Warmerdam]

Jason Birch wrote:
> I'd agree that having spatial functions supported (via GEOS) would be a
> nice addition to this RFC; maybe phase 2 if there are limited resources
> for this initial implementation? 
> 
> Jason
> 
> -----Original Message-----
> From: Mateusz Loskot
> Subject: Re: [fdo-internals] FDO RFC 16 - FDO Provider for SQLite
> 
> 2. Have you considered extending the SQLite engine with spatial 
> capatibilities like: built-in spatial index, SQL functions for spatial 
> operations?

Folks,

Wouldn't this fall into the category of an "FDO levelling" support library
that makes it easy to provide advanced FDO functions easily to FDO providers
that lack intrinsic support for the operators?

I think that is what section (3) of this is trying to address:

   http://trac.osgeo.org/fdo/wiki/FdoClientUtilities

It would certainly be desirable, but I think could also be handled as
an additional effort after the basic provider is implemented.

I am curious about whether a spatial index could be persisted with the data
in some way that would be useful in multiple environments (ie. FDO and OGR).
My main concern would be how to know know when it is dirty and needs to be
rebuilt.  Possibly we could support something as simplistic as
xmin/xmax/ymin/ymax columns in the table as a basis for a spatial index?

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org