Map { map-bgcolor: transparent; }
shape
../../coastlines/processed_p
shape
../../coastlines/processed_p
shape
../../coastlines/processed_p
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
= 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size
FROM osm_bayarea_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
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE waterway IN ('river', 'stream', 'canal') ORDER BY z_order ASC) AS rivers
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE highway IN ('footpath', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') ORDER BY z_order ASC) AS minor_roads
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE highway IN ('footpath', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') ORDER BY z_order ASC) AS minor_roads
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE highway IN ('motorway', 'trunk')) AS motorways
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE highway IN ('motorway', 'trunk')) AS motorways
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE railway IN ('rail', 'spur', 'subway', 'light_rail', 'tram', 'abandoned', 'disused', 'monorail') ORDER BY z_order ASC) AS railways
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_polygon WHERE building IS NOT NULL ORDER BY z_order ASC, way_area DESC) AS citylike
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(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 osm_bayarea_point WHERE place IN ('city', 'town', 'hamlet', 'village') ORDER BY priority ASC, correct_z_order DESC) AS places
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
= 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 osm_bayarea_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
127.0.0.1
5432
osm
0sm
osm_bayarea
false
= 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 osm_bayarea_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
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(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 osm_bayarea_line WHERE highway IN ('residential', 'unclassified', 'service', 'minor', 'road', 'tertiary') ORDER BY priority ASC, z_order ASC, length DESC) AS minor_roads
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
= 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 osm_bayarea_polygon
WHERE landuse IN ('reservoir', 'water')
OR "natural" IN ('lake', 'water', 'land')
ORDER BY z_order ASC) AS water]]>
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
= 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 osm_bayarea_polygon
WHERE building IS NOT NULL
ORDER BY z_order ASC, way_area DESC) AS citylike]]>