az09

# Standard Opening - open and read target input text file.
file = raw_input('Enter file name: ')
if len(file) < 1 : file = 'mbox-short.txt'
try :
    fhand = open(file)
except :
    print 'Cannot open file: ', file, '.', '...please try, again.'
    exit ()

# Prime the dictionary

az09

az09

az09

az09

SELECT ST_AsBinary("geometry") AS geom,"bridge","render","stylegroup","tunnel","type" FROM ( SELECT geometry, type, 0 AS bridge, access, render, layer, 1 as tunnel,
          CASE
            WHEN type IN ('motorway', 'trunk') THEN 'motorway'
            WHEN type IN ('primary', 'secondary') THEN 'mainroad'
            WHEN type IN ('motorway_link', 'trunk_link', 'primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'
            WHEN type IN ('service', 'track') THEN 'service'
            WHEN type IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'
            WHEN type IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'
            ELSE 'other' END AS stylegroup
          FROM (

az09

az09

az09

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
# "#" anywhere on a line.  The complete list of parameter names and allowed

az09

  SELECT way, COALESCE(p_o_l.highway, p_o_l.railway) AS "type", 1 AS bridge, access, render.render, layer, 0 as tunnel,
  COALESCE(hw.stylegroup, constr.stylegroup, rw.stylegroup, 'other') AS stylegroup
  FROM planet_osm_line as p_o_l
  INNER JOIN (values
        ('1_outline')
  ,     ('2_line')
  ,     ('3_inline')
  ) AS render (render) ON 1=1
  LEFT JOIN (values
        ('motorway', 'motorway')

az09

explain(analyze,buffers,verbose)
SELECT ST_AsBinary("way") AS geom,"area","name","type"
FROM (
 SELECT COALESCE(landuse, leisure, "natural", highway, amenity, tourism) AS "type", name, way_area AS area, ST_PointOnSurface(way) AS way
 FROM planet_osm_polygon
 WHERE name IS NOT NULL
   AND way && ST_SetSRID('BOX3D(15573585.89094331 4224215.931154246,15617613.61923559 4268243.659446535)'::box3d, 3857)
   AND ST_IsValid(way)
 UNION ALL
 SELECT 'building' AS "type", name, way_area AS area, ST_PointOnSurface(way) AS way