[OSM-talk] GeoServer and OpenStreetMap
Walter Nordmann
wnordmann at gmx.de
Thu Sep 29 21:08:36 UTC 2016
That's nearly all which has to be done in geoserver: Create a SQL layer.
select osm_id,
tags->'fire_hydrant:type' "type",
tags->'fire_hydrant:position' "position",
tags->'fire_hydrant:count' "count",
tags->'fire_hydrant:diameter' "diameter",
tags->'fire_hydrant:pressure' "pressure",
name,
note,
operator,
ref,
tags,
way
from planet_osm_point
where tags->'emergency'='fire_hydrant'
plus some global parametes. That's all.
regards
walter
More information about the talk
mailing list