postgis 127.0.0.1 5432 osm 0sm osm_bayarea false (SELECT *, (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0 WHEN highway = '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', '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 = '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', '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 *, (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0 WHEN highway = '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', '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 = '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', '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 *, (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0 WHEN highway = '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', 'primary', 'motorway', 'motorway_link') ORDER BY priority ASC, z_order ASC) AS major_roads postgis 127.0.0.1 5432 osm 0sm osm_bayarea false (SELECT *, (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0 WHEN highway = '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', 'tertiary') ORDER BY priority ASC, z_order ASC) AS minor_roads