shape
coastlines/processed_p
shape
coastlines/processed_p
shape
coastlines/processed_p
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_polygon WHERE building IS NULL AND (amenity IN ('school', 'college', 'university', 'library', 'hospital') 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 * 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
(SELECT * FROM osm_bayarea_polygon WHERE building IS NULL AND amenity = 'parking' ORDER BY z_order ASC, way_area DESC) AS citylike
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * 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
(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
(SELECT *, (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 DESC, z_order ASC) AS minor_roads
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT *, (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 ('secondary', 'trunk', 'primary', 'motorway', 'motorway_link') ORDER BY priority DESC, z_order ASC) AS major_roads
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
(SELECT *, (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 DESC, z_order ASC) AS minor_roads
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT *, (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 ('secondary', 'trunk', 'primary', 'motorway', 'motorway_link') ORDER BY priority DESC, z_order ASC) AS major_roads
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE highway = 'motorway') AS motorways
postgis
127.0.0.1
5432
osm
0sm
osm_bayarea
false
(SELECT * FROM osm_bayarea_line WHERE highway = 'motorway') 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
(SELECT *, y(astext(way)) AS latitude FROM osm_bayarea_point WHERE railway IN ('station', 'subway_entrance') AND name IS NOT NULL ORDER BY z_order ASC, latitude DESC) AS rail_points
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_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
(SELECT * FROM osm_bayarea_polygon WHERE building IS NULL AND (amenity IN ('school', 'college', 'university', 'library', 'hospital') 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
(SELECT * 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
(SELECT * FROM osm_bayarea_polygon WHERE building IS NOT NULL ORDER BY z_order ASC, way_area DESC) AS citylike