Opened 10 years ago

Closed 9 years ago

Last modified 8 years ago

#5494 closed enhancement (fixed)

update SQLite/SpatiaLite driver to RFC 41

Reported by: martinl Owned by: Even Rouault
Priority: high Milestone: 2.0.0
Component: OGR_SF Version: svn-trunk
Severity: normal Keywords: sqlite, rfc41


Currently SQLite/SpatiaLite driver doesn't seem to support wiki:rfc41_multiple_geometry_fields (RFC41). Testing data attached. Steps to reproduce (requires at least GDAL 1.11).

ogrinfo 20140331_OB_564729_UKSH.xml.gz
Had to open data source read-only.
INFO: Open of `20140331_OB_564729_UKSH.xml.gz'
      using driver `GML' successful.
1: Obce (Multi Point, Multi Polygon, Multi Polygon)
2: CastiObci (Point)
3: KatastralniUzemi (Multi Point, Multi Polygon, Multi Polygon)
4: Zsj (Multi Point, Multi Polygon)
5: Ulice (Multi Line String)
6: Parcely (Point, Polygon)
7: StavebniObjekty (Point, Multi Polygon)
8: AdresniMista (Point, Point, Point)

ogr2ogr -f 'SQLite' vfr.db 20140331_OB_564729_UKSH.xml.gz

ogrinfo vfr.db 
INFO: Open of `vfr.db'
      using driver `SQLite' successful.
1: obce (Multi Point)
2: castiobci (Point)
3: katastralniuzemi (Multi Point)
4: zsj (Multi Point)
5: ulice (Multi Line String)
6: parcely (Point)
7: stavebniobjekty (Point)
8: adresnimista (Point)

Attachments (1)

20140331_OB_564729_UKSH.xml.gz (480.2 KB ) - added by martinl 10 years ago.
multi geometries data set

Download all attachments as: .zip

Change History (5)

by martinl, 10 years ago

multi geometries data set

comment:1 by Jukka Rahkonen, 9 years ago

At least driver does not support converting all geometry fields from source to target with one command. I suppose that you can more or less use several geometry columns from SpatiaLite if you create them with SQL and register into geometry_columns.

BTW, your command creates SQLite database with geometries stored according to FDO system. You will probably rather test with SpatiaLite. Add -dsco spatialite=yes into your command. But at the moment (GDAL 2.0-dev) it does not make any change.

comment:2 by Even Rouault, 9 years ago

Owner: changed from warmerdam to Even Rouault

Working on that...

comment:3 by Even Rouault, 9 years ago

Resolution: fixed
Status: newclosed

trunk r28386 "SQLite/Spatialite: add support for multiple geometry colunn tables, accordingly with RFC 41 (#5494)"

comment:4 by Even Rouault, 8 years ago


Milestone renamed

Note: See TracTickets for help on using tickets.