Re: [gdal-dev] How to replace an osm key?

2016-11-14 Thread Rahkonen Jukka (MML)
Hi, If your version and environment requires escaping, then you need to do "select geometry, \"building\" as bldg,\"building:levels\" as bldg_levels,\”height\” as height from multipolygons ... " It may work also without escaping as "select geometry, "building" as bldg,"building:levels" as

Re: [gdal-dev] How to replace an osm key?

2016-11-14 Thread Rahkonen Jukka (MML)
Hi, If you enclose something between single quotes in SQL it becomes a string. SELECT ’building’ -> selects literally the given *string* –building— However, SELECT "building" -> selects the *value* of *field* –building-- (or “identifier” as is it called in SQL) See for example