Skip to content

Instantly share code, notes, and snippets.

@kieste
Created January 15, 2013 22:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kieste/4542748 to your computer and use it in GitHub Desktop.
Save kieste/4542748 to your computer and use it in GitHub Desktop.
Tirex Backend Manager Crashing Postgres Statements Log
013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","amenity","landuse","leisure","military","natural","power","tourism" FROM (select way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name,highway,
case when religion in ('christian','jewish') then religion else 'INT-generic'::text end as religion
from planet_osm_polygon
where landuse is not null
or leisure is not null
or aeroway in ('apron','aerodrome')
or amenity in ('parking','university','college','school','hospital','kindergarten','grave_yard','prison')
or military in ('barracks','danger_area')
or "natural" in ('field','beach','desert','heath','mud','grassland','wood','sand','scrub')
or power in ('station','sub_station','generator')
or tourism in ('attraction','camp_site','caravan_site','picnic_site','zoo')
or highway in ('services','rest_area')
order by z_order,way_area desc
) as leisure WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","amenity","landuse","leisure","military","natural","power","tourism" FROM (select way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name,highway,
case when religion in ('christian','jewish') then religion else 'INT-generic'::text end as religion
from planet_osm_polygon
where landuse is not null
or leisure is not null
or aeroway in ('apron','aerodrome')
or amenity in ('parking','university','college','school','hospital','kindergarten','grave_yard','prison')
or military in ('barracks','danger_area')
or "natural" in ('field','beach','desert','heath','mud','grassland','wood','sand','scrub')
or power in ('station','sub_station','generator')
or tourism in ('attraction','camp_site','caravan_site','picnic_site','zoo')
or highway in ('services','rest_area')
order by z_order,way_area desc
) as leisure WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"leisure" FROM (select way,leisure,
case when leisure='pitch' then 2
when leisure='track' then 1
else 0 end as prio
from planet_osm_polygon
where leisure in ('sports_centre','stadium','pitch','track')
order by z_order,prio,way_area desc
) as sports_grounds WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"leisure" FROM (select way,leisure,
case when leisure='pitch' then 2
when leisure='track' then 1
else 0 end as prio
from planet_osm_polygon
where leisure in ('sports_centre','stadium','pitch','track')
order by z_order,prio,way_area desc
) as sports_grounds WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"landuse","natural","waterway" FROM (select way,"natural",waterway,landuse,name
from planet_osm_polygon
where (waterway in ('dock','mill_pond','riverbank','canal')
or landuse in ('reservoir','water','basin')
or "natural" in ('lake','water','land','glacier','mud','bay'))
and building is null
order by z_order,way_area desc
) as water_areas WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"landuse","natural","waterway" FROM (select way,"natural",waterway,landuse,name
from planet_osm_polygon
where (waterway in ('dock','mill_pond','riverbank','canal')
or landuse in ('reservoir','water','basin')
or "natural" in ('lake','water','land','glacier','mud','bay'))
and building is null
order by z_order,way_area desc
) as water_areas WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","way_area" FROM (select way,name,way_area
from planet_osm_polygon
where "natural"='glacier' and building is null
order by way_area desc
) as glaciers WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:38 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","way_area" FROM (select way,name,way_area
from planet_osm_polygon
where "natural"='glacier' and building is null
order by way_area desc
) as glaciers WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"disused","waterway" FROM (select way,waterway,disused,lock,name,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
from planet_osm_line
where waterway in ('weir','river','canal','derelict_canal','stream','drain','ditch','wadi')
and (bridge is null or bridge not in ('yes','true','1','aqueduct'))
order by z_order
) as water_lines WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"disused","waterway" FROM (select way,waterway,disused,lock,name,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
from planet_osm_line
where waterway in ('weir','river','canal','derelict_canal','stream','drain','ditch','wadi')
and (bridge is null or bridge not in ('yes','true','1','aqueduct'))
order by z_order
) as water_lines WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom FROM (select way,man_made from planet_osm_polygon where man_made in ('pier','breakwater','groyne')) as piers WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom FROM (select way,man_made from planet_osm_polygon where man_made in ('pier','breakwater','groyne')) as piers WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"man_made" FROM (select way,man_made from planet_osm_line where man_made in ('pier','breakwater','groyne')) as piers WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"man_made" FROM (select way,man_made from planet_osm_line where man_made in ('pier','breakwater','groyne')) as piers WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway from planet_osm_line where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified') and tunnel in ('yes','true','1') order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway from planet_osm_line where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified') and tunnel in ('yes','true','1') order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway from planet_osm_line where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified') and tunnel in ('yes','true','1') order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway from planet_osm_line where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified') and tunnel in ('yes','true','1') order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"landuse","leisure" FROM (select way,landuse,leisure
from planet_osm_polygon
where (landuse = 'military' or leisure='nature_reserve') and building is null
) as landuse_overlay WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"landuse","leisure" FROM (select way,landuse,leisure
from planet_osm_polygon
where (landuse = 'military' or leisure='nature_reserve') and building is null
) as landuse_overlay WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway","tunnel" FROM (select way,highway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified','road','service','pedestrian','raceway','living_street')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway","tunnel" FROM (select way,highway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified','road','service','pedestrian','raceway','living_street')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway","tunnel" FROM (select way,highway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified','road','service','pedestrian','raceway','living_street')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway","tunnel" FROM (select way,highway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','tertiary_link','residential','unclassified','road','service','pedestrian','raceway','living_street')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway" FROM (select way,highway,railway,aeroway from planet_osm_polygon
where highway in ('residential','unclassified','pedestrian','service','footway','living_street','track','path','platform','services')
or railway='platform'
or aeroway in ('runway','taxiway','helipad')
order by z_order,way_area desc) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway" FROM (select way,highway,railway,aeroway from planet_osm_polygon
where highway in ('residential','unclassified','pedestrian','service','footway','living_street','track','path','platform','services')
or railway='platform'
or aeroway in ('runway','taxiway','helipad')
order by z_order,way_area desc) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"amenity","building","railway" FROM (select way,building,railway,amenity from planet_osm_polygon
where railway='station'
or building in ('station','supermarket')
or amenity='place_of_worship'
order by z_order,way_area desc) as buildings WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"amenity","building","railway" FROM (select way,building,railway,amenity from planet_osm_polygon
where railway='station'
or building in ('station','supermarket')
or amenity='place_of_worship'
order by z_order,way_area desc) as buildings WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","building" FROM (select way,aeroway,
case
when building in ('residential','house','garage','garages','detached','terrace','apartments') then 'INT-light'::text
else building
end as building
from planet_osm_polygon
where (building is not null
and building not in ('no','station','supermarket','planned')
and (railway is null or railway != 'station')
and (amenity is null or amenity != 'place_of_worship'))
or aeroway = 'terminal'
order by z_order,way_area desc) as buildings WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:39 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","building" FROM (select way,aeroway,
case
when building in ('residential','house','garage','garages','detached','terrace','apartments') then 'INT-light'::text
else building
end as building
from planet_osm_polygon
where (building is not null
and building not in ('no','station','supermarket','planned')
and (railway is null or railway != 'station')
and (amenity is null or amenity != 'place_of_worship'))
or aeroway = 'terminal'
order by z_order,way_area desc) as buildings WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:40 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","construction","highway","railway","tunnel" FROM (select way,highway,horse,bicycle,foot,construction,aeroway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when bridge in ('yes','true','1','viaduct') then 'yes'::text else bridge end as bridge,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'spur-siding-yard'::text else railway end as railway,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','narrow_gauge','funicular','rail','subway','tram','spur','siding','platform','disused','abandoned','construction','miniature','turntable')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","construction","highway","railway","tunnel" FROM (select way,highway,horse,bicycle,foot,construction,aeroway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when bridge in ('yes','true','1','viaduct') then 'yes'::text else bridge end as bridge,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'spur-siding-yard'::text else railway end as railway,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','narrow_gauge','funicular','rail','subway','tram','spur','siding','platform','disused','abandoned','construction','miniature','turntable')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","construction","highway","railway","tunnel" FROM (select way,highway,horse,bicycle,foot,construction,aeroway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when bridge in ('yes','true','1','viaduct') then 'yes'::text else bridge end as bridge,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'spur-siding-yard'::text else railway end as railway,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','narrow_gauge','funicular','rail','subway','tram','spur','siding','platform','disused','abandoned','construction','miniature','turntable')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","construction","highway","railway","tunnel" FROM (select way,highway,horse,bicycle,foot,construction,aeroway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when bridge in ('yes','true','1','viaduct') then 'yes'::text else bridge end as bridge,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'spur-siding-yard'::text else railway end as railway,
case when service in ('parking_aisle','drive-through','driveway') then 'INT-minor'::text else service end as service
from planet_osm_line
where highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','narrow_gauge','funicular','rail','subway','tram','spur','siding','platform','disused','abandoned','construction','miniature','turntable')
order by z_order) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom FROM (select way from planet_osm_line where route='ferry' ) as routes WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aerialway" FROM (select way,aerialway from planet_osm_line where aerialway is not null) as aerialways WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"railway","tunnel" FROM (select way,highway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when railway='preserved' and service in ('spur','siding','yard') then 'INT-preserved-ssy'::text else railway end as railway
from planet_osm_roads
where highway is not null
or (railway is not null and railway!='preserved' and (service is null or service not in ('spur','siding','yard')))
or railway='preserved'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and (layer is null or layer = '0')
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and (layer is null or layer = '0')
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom FROM (select way from planet_osm_line where route='ferry' ) as routes WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '1'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aerialway" FROM (select way,aerialway from planet_osm_line where aerialway is not null) as aerialways WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '1'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:41 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"railway","tunnel" FROM (select way,highway,
case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
case when railway='preserved' and service in ('spur','siding','yard') then 'INT-preserved-ssy'::text else railway end as railway
from planet_osm_roads
where highway is not null
or (railway is not null and railway!='preserved' and (service is null or service not in ('spur','siding','yard')))
or railway='preserved'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '2'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and (layer is null or layer = '0')
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '2'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and (layer is null or layer = '0')
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '3'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '1'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '3'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '1'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '4'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '2'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '4'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '2'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '5'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '3'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '5'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '3'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"admin_level" FROM (select way,admin_level
from planet_osm_roads
where "boundary"='administrative'
and admin_level in ('0','1','2','3','4')
) as admin WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"admin_level" FROM (select way,admin_level
from planet_osm_roads
where "boundary"='administrative'
and admin_level in ('5','6','7','8')
) as admin WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '4'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '4'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name" FROM (select way,place,name,ref
from planet_osm_point
where place in ('city','metropolis','town') and capital='yes'
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '5'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('city','metropolis','town','large_town','small_town')
and (capital is null or capital != 'yes')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway" FROM (select way,highway,aeroway,horse,bicycle,foot,tracktype,
case when railway in ('spur','siding')
or (railway='rail' and service in ('spur','siding','yard'))
then 'INT-spur-siding-yard'::text else railway end as railway
from planet_osm_line
where (highway is not null
or aeroway in ('runway','taxiway')
or railway in ('light_rail','subway','narrow_gauge','rail','spur','siding','disused','abandoned','construction'))
and bridge in ('yes','true','1','viaduct')
and layer = '5'
order by z_order
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('city','metropolis','town','large_town','small_town')
and (capital is null or capital != 'yes')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"admin_level" FROM (select way,admin_level
from planet_osm_roads
where "boundary"='administrative'
and admin_level in ('0','1','2','3','4')
) as admin WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"admin_level" FROM (select way,admin_level
from planet_osm_roads
where "boundary"='administrative'
and admin_level in ('5','6','7','8')
) as admin WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('suburb','village','large_village','hamlet','locality','isolated_dwelling','farm')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name" FROM (select way,place,name,ref
from planet_osm_point
where place in ('city','metropolis','town') and capital='yes'
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('city','metropolis','town','large_town','small_town')
and (capital is null or capital != 'yes')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('suburb','village','large_village','hamlet','locality','isolated_dwelling','farm')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('city','metropolis','town','large_town','small_town')
and (capital is null or capital != 'yes')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('suburb','village','large_village','hamlet','locality','isolated_dwelling','farm')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,name
from planet_osm_point
where place in ('suburb','village','large_village','hamlet','locality','isolated_dwelling','farm')
) as placenames WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"disused","railway" FROM (select way,name,railway,aerialway,disused
from planet_osm_point
where railway in ('station','halt','tram_stop','subway_entrance')
or aerialway='station'
) as stations WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"disused","railway" FROM (select way,name,railway,aerialway,disused
from planet_osm_polygon
where railway in ('station','halt','tram_stop')
or aerialway='station'
) as stations WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","name","natural" FROM (select *
from planet_osm_point
where aeroway in ('airport','aerodrome','helipad')
or barrier in ('bollard','gate','lift_gate','block')
or highway in ('mini_roundabout','gate')
or man_made in ('lighthouse','power_wind','windmill','mast')
or (power='generator' and ("generator:source"='wind' or power_source='wind'))
or "natural" in ('peak','volcano','spring','tree','cave_entrance')
or railway='level_crossing'
) as symbols WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"disused","railway" FROM (select way,name,railway,aerialway,disused
from planet_osm_point
where railway in ('station','halt','tram_stop','subway_entrance')
or aerialway='station'
) as stations WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"disused","railway" FROM (select way,name,railway,aerialway,disused
from planet_osm_polygon
where railway in ('station','halt','tram_stop')
or aerialway='station'
) as stations WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","name","natural" FROM (select *
from planet_osm_polygon
where aeroway in ('airport','aerodrome','helipad')
or barrier in ('bollard','gate','lift_gate','block')
or highway in ('mini_roundabout','gate')
or man_made in ('lighthouse','power_wind','windmill','mast')
or (power='generator' and ("generator:source"='wind' or power_source='wind'))
or "natural" in ('peak','volcano','spring','tree')
or railway='level_crossing'
) as symbols WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","name","natural" FROM (select *
from planet_osm_point
where aeroway in ('airport','aerodrome','helipad')
or barrier in ('bollard','gate','lift_gate','block')
or highway in ('mini_roundabout','gate')
or man_made in ('lighthouse','power_wind','windmill','mast')
or (power='generator' and ("generator:source"='wind' or power_source='wind'))
or "natural" in ('peak','volcano','spring','tree','cave_entrance')
or railway='level_crossing'
) as symbols WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway","length","ref" FROM (select way,highway,ref,char_length(ref) as length
from planet_osm_roads
where highway in ('motorway','trunk','primary','secondary')
and ref is not null
and char_length(ref) between 1 and 8
) as roads WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"aeroway","name","natural" FROM (select *
from planet_osm_polygon
where aeroway in ('airport','aerodrome','helipad')
or barrier in ('bollard','gate','lift_gate','block')
or highway in ('mini_roundabout','gate')
or man_made in ('lighthouse','power_wind','windmill','mast')
or (power='generator' and ("generator:source"='wind' or power_source='wind'))
or "natural" in ('peak','volcano','spring','tree')
or railway='level_crossing'
) as symbols WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","ref" FROM (select way,ref,name
from planet_osm_point
where highway='motorway_junction'
) as junctions WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"highway","length","ref" FROM (select way,highway,ref,char_length(ref) as length
from planet_osm_roads
where highway in ('motorway','trunk','primary','secondary')
and ref is not null
and char_length(ref) between 1 and 8
) as roads WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"military","name","place" FROM (select way,amenity,shop,access,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref,military,aeroway,waterway,historic,'yes'::text as point
from planet_osm_point
where amenity is not null
or shop in ('supermarket','bakery','clothes','fashion','convenience','doityourself','hairdresser','department_store','butcher','car','car_repair','bicycle','florist')
or leisure is not null
or landuse is not null
or tourism is not null
or "natural" is not null
or man_made in ('lighthouse','windmill')
or place='island'
or military='danger_area'
or aeroway='gate'
or waterway='lock'
or historic in ('memorial','archaeological_site')
) as text WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:42 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"name","ref" FROM (select way,ref,name
from planet_osm_point
where highway='motorway_junction'
) as junctions WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:43 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"military","name","place" FROM (select way,amenity,shop,access,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref,military,aeroway,waterway,historic,'yes'::text as point
from planet_osm_point
where amenity is not null
or shop in ('supermarket','bakery','clothes','fashion','convenience','doityourself','hairdresser','department_store','butcher','car','car_repair','bicycle','florist')
or leisure is not null
or landuse is not null
or tourism is not null
or "natural" is not null
or man_made in ('lighthouse','windmill')
or place='island'
or military='danger_area'
or aeroway='gate'
or waterway='lock'
or historic in ('memorial','archaeological_site')
) as text WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:43 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"military","name","place" FROM (select way,aeroway,shop,access,amenity,leisure,landuse,man_made,"natural",place,tourism,NULL as ele,name,ref,military,waterway,historic,'no'::text as point
from planet_osm_polygon
where amenity is not null
or shop in ('supermarket','bakery','clothes','fashion','convenience','doityourself','hairdresser','department_store', 'butcher','car','car_repair','bicycle')
or leisure is not null
or landuse is not null
or tourism is not null
or "natural" is not null
or man_made in ('lighthouse','windmill')
or place='island'
or military='danger_area'
or historic in ('memorial','archaeological_site')
) as text WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:43 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom,"military","name","place" FROM (select way,aeroway,shop,access,amenity,leisure,landuse,man_made,"natural",place,tourism,NULL as ele,name,ref,military,waterway,historic,'no'::text as point
from planet_osm_polygon
where amenity is not null
or shop in ('supermarket','bakery','clothes','fashion','convenience','doityourself','hairdresser','department_store', 'butcher','car','car_repair','bicycle')
or leisure is not null
or landuse is not null
or tourism is not null
or "natural" is not null
or man_made in ('lighthouse','windmill')
or place='island'
or military='danger_area'
or historic in ('memorial','archaeological_site')
) as text WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:43 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom FROM (select way,way_area,name,boundary from planet_osm_polygon where boundary='national_park' and building is null) as boundary WHERE "way" && ST_SetSRID('BOX3D(1482266.852506138 6883001.523023553,1570322.309090659 6971056.979608074)'::box3d, 900913)
2013-01-15 23:18:43 CET LOG: unexpected EOF on client connection
2013-01-15 23:18:43 CET LOG: execute <unnamed>: SELECT ST_AsBinary("way") AS geom FROM (select way,way_area,name,boundary from planet_osm_polygon where boundary='national_park' and building is null) as boundary WHERE "way" && ST_SetSRID('BOX3D(1403995.335542116 6883001.523023551,1492050.792126641 6971056.979608076)'::box3d, 900913)
2013-01-15 23:18:43 CET LOG: unexpected EOF on client connection
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment