]> Map { map-bgcolor: #8cb6d3; } shape &coastlines; shape &coastlines; shape &coastlines; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; = 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size FROM planet_osm_polygon WHERE building IS NULL AND (amenity IN ('park') OR landuse IN ('recreation_ground', 'greenfield', 'cemetery') OR leisure IN ('park', 'pitch', 'track', 'golf_course', 'common', 'playground', 'garden', 'plaza')) ORDER BY z_order ASC, way_area DESC) AS parklike]]> postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_line WHERE waterway IN ('river', 'stream', 'canal') ORDER BY z_order ASC) AS rivers postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_line WHERE highway IN ('footpath', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') ORDER BY z_order ASC) AS minor_roads postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_line WHERE highway IN ('footpath', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') ORDER BY z_order ASC) AS minor_roads postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_line WHERE highway IN ('motorway', 'trunk')) AS motorways postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_line WHERE highway IN ('motorway', 'trunk')) AS motorways postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_line WHERE railway IN ('rail', 'spur', 'subway', 'light_rail', 'tram', 'abandoned', 'disused', 'monorail') ORDER BY z_order ASC) AS railways postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT * FROM planet_osm_polygon WHERE building IS NOT NULL ORDER BY z_order ASC, way_area DESC) AS citylike postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT *, COALESCE(z_order, 0) AS correct_z_order, (CASE WHEN place = 'city' THEN 0 WHEN place = 'town' THEN 1 WHEN place = 'village' THEN 2 ELSE 3 END) AS priority FROM planet_osm_point WHERE place IN ('city', 'town', 'hamlet', 'village') ORDER BY priority ASC, correct_z_order DESC) AS places postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; = 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size, REGEXP_REPLACE(UPPER(name), '(.)', E'\\1\xC2\xA0\xC2\xA0', 'g') AS name_stretched FROM planet_osm_polygon WHERE building IS NULL AND (amenity IN ('park') OR landuse IN ('recreation_ground', 'greenfield', 'cemetery') OR leisure IN ('park', 'pitch', 'track', 'golf_course', 'common', 'playground', 'garden', 'plaza')) ORDER BY z_order ASC, way_area DESC) AS parklike]]> postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; = 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size, REGEXP_REPLACE(UPPER(name), '(.)', E'\\1\xC2\xA0\xC2\xA0', 'g') AS name_stretched FROM planet_osm_polygon WHERE building IS NULL AND (amenity IN ('parking', 'school', 'college', 'university', 'library', 'hospital', 'police', 'fire_station') OR landuse IN ('industrial', 'commercial') OR aeroway IN ('apron')) ORDER BY z_order ASC, way_area DESC) AS citylike]]> postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; (SELECT *, length(way) AS length, (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0 WHEN highway IN ('trunk', 'primary') THEN 1 WHEN highway = 'secondary' THEN 2 WHEN highway = 'tertiary' THEN 3 ELSE 4 END) AS priority FROM planet_osm_line WHERE highway IN ('residential', 'unclassified', 'service', 'minor', 'road', 'tertiary') ORDER BY priority ASC, z_order ASC, length DESC) AS minor_roads postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; = 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size, REGEXP_REPLACE(UPPER(name), '(.)', E'\\1\xC2\xA0\xC2\xA0', 'g') AS name_stretched FROM planet_osm_polygon WHERE landuse IN ('reservoir', 'water') OR "natural" IN ('lake', 'water', 'land') ORDER BY z_order ASC) AS water]]> postgis &host; &port; &user; &password; &dbname; &estimate_extent; &extent; = 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size, REGEXP_REPLACE(UPPER(name), '(.)', E'\\1\xC2\xA0\xC2\xA0', 'g') AS name_stretched FROM planet_osm_polygon WHERE building IS NOT NULL ORDER BY z_order ASC, way_area DESC) AS citylike]]>