3

Hi sly,

thx for that hint, but my problem is different: I want to get rid of some parts of the column (type hstore), which contains the OSM tags in the format “key”=>“value”, e.g.

{“lcn”=>“yes”, “ref”=>“VdL 5”, “route”=>“bicycle”, “lcn_ref”=>“VDL-Nr5”, “network”=>“lcn”, “z_order”=>“0”, “distance”=>“3,2”, “roundtrip”=>“no”, “route_name”=>“Piste cyclable VDL Nr 05”, “route_pref_color”=>“0”}

This can nicely be converted into an array and loaded into the “properties” field of a GeoJSON string by simply evaluating it in PHP:

while ($row = pg_fetch_assoc ($qry_result)) {
eval ( “$tags = array (” . $row[‘tags’] . “);” );
}

Unfortunately, the column tags contains some non-OSM tags…

I assume I have to dive into the osm2pgsql sources.

Regards
Nils