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

Traian Stanev traian.stanev at autodesk.com
Sun Mar 23 14:19:32 EDT 2008

Hi Frank,

No problem, feel free to post the file (it came from publically available data).
Since I sent you that file, I have also added support for the geometry_columns (and spatial_ref_sys) in my code. I had the same columns as you have in the RFC, except for the "type" column. I will adjust the code to support "type" as well.


> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-
> bounces at lists.osgeo.org] On Behalf Of Frank Warmerdam (External)
> Sent: Sunday, March 23, 2008 1:58 PM
> To: FDO Internals Mail List
> Subject: Re: [fdo-internals] FDO RFC 16 - FDO Provider for SQLite
> Folks,
> I have added some specifics to the RFC for the geometry_columns table,
> and implemented support for this approach in the OGR SQLite driver.  I
> have uploaded a sample dataset of polygon data in WKB format to:
>    http://download.osgeo.org/gdal/data/sqlite3/polygon_wkb.db
> I also added limited FGF reading support to my driver, but it only
> kicks in if the geometry_columns table exists, and describes the format
> as FGF for the geometry column.  Traian provided me with sample data to
> which I added a geometry_columns table with an appropriate entry and
> it worked!  Traian, do you mind if I upload that adjusted dataset to
> the
> above location?
> I'd like to also flesh out the spatial_ref_sys aspect but I'll leave
> that for next week.  Off to eat road bunny and chocolate turkey or
> something
> like that.
> PS. I'm also interested in the spatialite project (referenced now on
> the RFC)
> but it has it's own slightly WKB like format for geometry which I don't
> feel up to immediately implementing.  Too many geometry formats!
> 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
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals

More information about the fdo-internals mailing list