[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