Opened 7 years ago

Closed 7 years ago

Last modified 6 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
Cc:

Description

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 7 years ago.
multi geometries data set

Download all attachments as: .zip

Change History (5)

Changed 7 years ago by martinl

multi geometries data set

comment:1 Changed 7 years ago by Jukka Rahkonen

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 Changed 7 years ago by Even Rouault

Owner: changed from warmerdam to Even Rouault

Working on that...

comment:3 Changed 7 years ago by Even Rouault

Resolution: fixed
Status: newclosed

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

comment:4 Changed 6 years ago by Even Rouault

Milestone: 2.02.0.0

Milestone renamed

Note: See TracTickets for help on using tickets.