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
_______________________________________________
talk mailing list
talk@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk
