[gdal-dev] Regarding missing stylestring in SQLITE Driver
even.rouault at mines-paris.org
Wed May 22 10:54:00 PDT 2013
Le mercredi 22 mai 2013 16:11:30, Jukka Rahkonen a écrit :
> Abhinav <abhinav <at> vizexperts.com> writes:
> > Hi All,
> > I am using sqlite driver to write the OGRLayer to disk. I am setting
> > StyleString for each feature. But when I read back, my feature contains
> > NULL stylestring. Though I am able to get other attributes, I am
> > setting to the feature.
> > I wonder whether sqlite driver supports writing style string or not? If
> > It allows, do we have to give any option to enable writing of the style
> > ?
> Please tell us how you tried to do your task. Here is what I did in my
> quick test.
> Step 1: Set OGR style with SQL and write features with styles into
> Spatialite db.
> ogr2ogr -f SQLite -dsco spatialite=yes styletest.sqlite finland.osm.pbf
> -sql "select highway, ref, 'SYMBOL(id:bus_stop.png)' as OGR_STYLE from
> points where highway='bus_stop'"
Jukka's suggestion to set a OGR_STYLE attribute is actually what you can do to
have styles written in a sqlite database. The SetStyleString() API is
supported directly by very few formats (only MapInfo comes to mind). For other
cases, using the special OGR_STYLE attribute is the only way to go.
Geospatial professional services
More information about the gdal-dev