[gdal-dev] How to concatenate with newlines by using OGR SQL?

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Mon Jul 30 23:39:23 PDT 2012


I was playing with the new OSM driver and tried to transfer some 
POI features into my GPS. It goes well by using GPX format in 
between. However, I have a little problem. My GPS supports multiline
descriptions but I do not know how to insert newlines into the 
output of ogr2ogr. The following command adds a space character 
between addr_street and addr_housenumber, but is is somehow possible
to insert newline instead?

ogr2ogr -f gpx test.gpx finland.osm.pbf
-sql "select name,CONCAT(addr_street,' ',addr_housenumber)
as 'desc' from points where amenity='toilets'"

I made two blind trials as 
CONCAT(addr_street,\n,addr_housenumber) which gives parsing error and
CONCAT(addr_street,'\n',addr_housenumber) which adds string \n literally.

-Jukka Rahkonen-

More information about the gdal-dev mailing list