SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'



select * from 
      (select way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name
       from planet_osm_polygon
       where landuse is not null
          or leisure is not null
          or aeroway in ('apron','aerodrome')
          or man_made='pier'
          or amenity in ('parking','university','college','school','hospital','grave_yard')
          or military in ('barracks','danger_area')
          or "natural" in ('field','beach','glacier','heath','mud','wood')
          or power in ('station','sub_station')
          or tourism in ('attraction','camp_site','caravan_site','picnic_site','zoo')
       order by z_order,way_area desc
      ) as leisure
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from (select way,leisure from planet_osm_polygon where leisure in ('sports_centre','stadium') order by z_order,way_area desc) as sports_grounds WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from (select way,"natural",waterway,landuse,name from planet_osm_polygon where waterway in ('dock','mill_pond','riverbank','canal') or landuse in ('reservoir','water') or "natural" in ('lake','water','land','marsh','scrub','wetland','glacier') order by z_order,way_area desc) as water_areas WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from (select way,waterway,disused,name,case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel from planet_osm_line where waterway IS NOT NULL order by z_order) as water_lines WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way from planet_osm_line where man_made='pier') as piers
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,highway from planet_osm_line where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','residential','unclassified','minor') and tunnel in ('yes','true','1') order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from (select way from planet_osm_line where "historic"='citywalls') as citywalls WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point'
select * from (select way from planet_osm_point where highway='turning_circle') as turning_circle WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,highway,horse,foot,bicycle from planet_osm_line where highway in ('bridleway','footway','cycleway','path') and tunnel in ('yes','true','1') order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,tracktype from planet_osm_line where highway='track' and (bridge is null or bridge in ('no','false','0')) and (tunnel is null or tunnel in ('no','false','0'))) as tracks
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,tracktype from planet_osm_line where highway='track' and tunnel in ('yes','true','1')) as tracks
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
      (select way,building,leisure,railway,amenity,aeroway from planet_osm_polygon
       where building is not null
          or leisure in ('pitch','track')
          or railway='station'
          or amenity='place_of_worship'
          or aeroway='terminal'
       order by z_order,way_area desc) as buildings
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,barrier,"natural",man_made from planet_osm_line where barrier is not null or "natural" in ('hedge','cliff') or man_made='embankment') as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
       (select way,barrier,"natural" from planet_osm_polygon where barrier is not null or "natural"='hedge') as barriers
        WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
      (select way,highway from planet_osm_polygon
       where highway in ('residential','unclassified','pedestrian','service','footway','track')
       order by z_order,way_area desc) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,highway,service,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
       from planet_osm_line
       where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','residential','unclassified','minor','road','service','pedestrian','raceway')
       order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
      (select way,highway from planet_osm_polygon
       where highway in ('residential','unclassified','pedestrian','service','footway','living_street','track')
       order by z_order,way_area desc) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,highway,horse,bicycle,foot,construction,railway,aeroway,service,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
       case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge
       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')
       order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way from planet_osm_line where route='ferry' ) as routes
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,aerialway from planet_osm_line where aerialway is not null) as aerialways
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_roads'
select * from 
      (select way,highway,railway,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
       from planet_osm_roads
       where highway is not null
          or railway is not null
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from (select way,name from planet_osm_line where waterway='canal' and bridge in ('yes','true','1','aqueduct') order by z_order) as water WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,tracktype from planet_osm_line where highway='track' and bridge in ('yes','true','1')) as tracks
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,access,highway from planet_osm_line where access is not null) as access
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way from planet_osm_line where railway='tram' and (tunnel is null or tunnel not in ('yes','true','1'))) as trams
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point'
select * from (select way,place,capital,name,ref from planet_osm_point where place is not null) as placenames WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point'
select * from (select * from planet_osm_point where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from (select * from planet_osm_polygon where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from (select way from planet_osm_line where "power"='line') as power WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point'
select * from (select way from planet_osm_point where power='tower') as power_towers WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway from planet_osm_line where oneway is not null) as directions
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_roads'
select * from 
      (select way,highway,ref,char_length(ref) as length
       from planet_osm_roads
       where highway in ('motorway','trunk','primary')
         and ref is not null
      ) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from 
      (select way,highway,aeroway,name,ref,char_length(ref) as length,
       case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge
       from planet_osm_line
       where waterway IS NULL
         and leisure IS NULL
         and landuse IS NULL
         and (name is not null or ref is not null)
      ) as roads
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_line'
select * from       
       (select way from planet_osm_line where "addr:interpolation" is not null) as interpolation
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from (select way,"addr:housenumber" from planet_osm_polygon where "addr:housenumber" is not null and building is not null) as way_numbers WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point'
select * from (select way,"addr:housenumber" from planet_osm_point where "addr:housenumber" is not null) as node_numbers WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point'
select * from 
      (select way,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref,military,aeroway,'yes'::text as point
       from planet_osm_point
       where amenity is not null
          or leisure is not null
          or landuse is not null
          or tourism is not null
          or "natural" is not null
          or man_made='lighthouse'
          or place='island'
          or highway='motorway_junction'
          or military='danger_area'
          or aeroway='gate'
      ) as text
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
      (select way,aeroway,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,NULL as ele,name,ref,military,'no'::text as point
       from planet_osm_polygon
       where amenity is not null
          or leisure is not null
          or landuse is not null
          or tourism is not null
          or "natural" is not null
          or man_made='lighthouse'
          or place='island'
          or military='danger_area'
      ) as text
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
      (select way,way_area,name
       from planet_osm_polygon
       where name is not null
         and (waterway is null or waterway <> 'riverbank')
       order by z_order,way_area desc
      ) as text
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_polygon'
select * from 
      (select way,name from planet_osm_polygon where boundary='national_park') as boundary
       WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_roads'
select * from 
      (select way,admin_level from planet_osm_roads where "boundary"='administrative') as admin WHERE "way" && SetSRID('BOX3D(-20037508 -19929239,20037508 19929239)'::box3d, 900913) limit 0
SELECT AsBinary("way",'NDR') AS geom,"aeroway","amenity","landuse","leisure","man_made","military","natural","power","tourism" from 
      (select way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name
       from planet_osm_polygon
       where landuse is not null
          or leisure is not null
          or aeroway in ('apron','aerodrome')
          or man_made='pier'
          or amenity in ('parking','university','college','school','hospital','grave_yard')
          or military in ('barracks','danger_area')
          or "natural" in ('field','beach','glacier','heath','mud','wood')
          or power in ('station','sub_station')
          or tourism in ('attraction','camp_site','caravan_site','picnic_site','zoo')
       order by z_order,way_area desc
      ) as leisure
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from (select way,leisure from planet_osm_polygon where leisure in ('sports_centre','stadium') order by z_order,way_area desc) as sports_grounds WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"landuse","name","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') or "natural" in ('lake','water','land','marsh','scrub','wetland','glacier') order by z_order,way_area desc) as water_areas WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"disused","name","tunnel","waterway" from (select way,waterway,disused,name,case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel from planet_osm_line where waterway IS NOT NULL order by z_order) as water_lines WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"disused","name","tunnel","waterway" from (select way,waterway,disused,name,case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel from planet_osm_line where waterway IS NOT NULL order by z_order) as water_lines WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from 
      (select way from planet_osm_line where man_made='pier') as piers
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') 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','residential','unclassified','minor') and tunnel in ('yes','true','1') order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') 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','residential','unclassified','minor') and tunnel in ('yes','true','1') order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from (select way from planet_osm_line where "historic"='citywalls') as citywalls WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from (select way from planet_osm_point where highway='turning_circle') as turning_circle WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"bicycle","foot","highway","horse" from 
      (select way,highway,horse,foot,bicycle from planet_osm_line where highway in ('bridleway','footway','cycleway','path') and tunnel in ('yes','true','1') order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"tracktype" from 
      (select way,tracktype from planet_osm_line where highway='track' and (bridge is null or bridge in ('no','false','0')) and (tunnel is null or tunnel in ('no','false','0'))) as tracks
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"tracktype" from 
      (select way,tracktype from planet_osm_line where highway='track' and tunnel in ('yes','true','1')) as tracks
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","amenity","building","leisure","railway" from 
      (select way,building,leisure,railway,amenity,aeroway from planet_osm_polygon
       where building is not null
          or leisure in ('pitch','track')
          or railway='station'
          or amenity='place_of_worship'
          or aeroway='terminal'
       order by z_order,way_area desc) as buildings
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"man_made","natural" from 
      (select way,barrier,"natural",man_made from planet_osm_line where barrier is not null or "natural" in ('hedge','cliff') or man_made='embankment') as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"barrier","man_made","natural" from 
      (select way,barrier,"natural",man_made from planet_osm_line where barrier is not null or "natural" in ('hedge','cliff') or man_made='embankment') as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"barrier","natural" from 
       (select way,barrier,"natural" from planet_osm_polygon where barrier is not null or "natural"='hedge') as barriers
        WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway" from 
      (select way,highway from planet_osm_polygon
       where highway in ('residential','unclassified','pedestrian','service','footway','track')
       order by z_order,way_area desc) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway","tunnel" from 
      (select way,highway,service,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
       from planet_osm_line
       where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','residential','unclassified','minor','road','service','pedestrian','raceway')
       order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway","service","tunnel" from 
      (select way,highway,service,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
       from planet_osm_line
       where highway in ('motorway','motorway_link','trunk','trunk_link','primary','primary_link','secondary','secondary_link','tertiary','residential','unclassified','minor','road','service','pedestrian','raceway')
       order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway" from 
      (select way,highway from planet_osm_polygon
       where highway in ('residential','unclassified','pedestrian','service','footway','living_street','track')
       order by z_order,way_area desc) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway","tunnel" from 
      (select way,highway,horse,bicycle,foot,construction,railway,aeroway,service,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
       case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge
       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')
       order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","bridge","construction","foot","highway","horse","railway","service","tunnel" from 
      (select way,highway,horse,bicycle,foot,construction,railway,aeroway,service,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel,
       case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge
       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')
       order by z_order) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from 
      (select way from planet_osm_line where route='ferry' ) as routes
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aerialway" from 
      (select way,aerialway from planet_osm_line where aerialway is not null) as aerialways
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"railway" from 
      (select way,highway,railway,
       case when tunnel in ('yes','true','1') then 'yes'::text else tunnel end as tunnel
       from planet_osm_roads
       where highway is not null
          or railway is not null
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"name" from (select way,name from planet_osm_line where waterway='canal' and bridge in ('yes','true','1','aqueduct') order by z_order) as water WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"highway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bicycle","foot","highway","horse","layer","railway" from 
      (select way,highway,aeroway,railway,layer,horse,bicycle,foot,bridge
       from planet_osm_line
       where (highway is not null
              or aeroway in ('runway','taxiway')
              or railway in ('light_rail','subway'))
         and bridge not in ('no','false','0')
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"tracktype" from 
      (select way,tracktype from planet_osm_line where highway='track' and bridge in ('yes','true','1')) as tracks
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"access","highway" from 
      (select way,access,highway from planet_osm_line where access is not null) as access
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from 
      (select way from planet_osm_line where railway='tram' and (tunnel is null or tunnel not in ('yes','true','1'))) as trams
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"name","place" from (select way,place,capital,name,ref from planet_osm_point where place is not null) as placenames WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"name","place" from (select way,place,capital,name,ref from planet_osm_point where place is not null) as placenames WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"name","place" from (select way,place,capital,name,ref from planet_osm_point where place is not null) as placenames WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"name","place" from (select way,place,capital,name,ref from planet_osm_point where place is not null) as placenames WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aerialway","disused","name","railway" from (select * from planet_osm_point where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aerialway","barrier","disused","highway","man_made","name","natural","power","power_source","railway" from (select * from planet_osm_point where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"access","aerialway","amenity","barrier","disused","highway","man_made","name","natural","power","power_source","railway","religion","tourism" from (select * from planet_osm_point where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aerialway","disused","name","railway" from (select * from planet_osm_polygon where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aerialway","barrier","disused","highway","man_made","name","natural","power","power_source","railway" from (select * from planet_osm_polygon where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"access","aerialway","amenity","barrier","disused","highway","man_made","name","natural","power","power_source","railway","religion","tourism" from (select * from planet_osm_polygon where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from (select way from planet_osm_line where "power"='line') as power WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from (select way from planet_osm_point where power='tower') as power_towers WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"oneway" from 
      (select way,case when oneway in ('yes','true','1') then 'yes'::text else oneway end as oneway from planet_osm_line where oneway is not null) as directions
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","bridge","highway","length","name","ref" from 
      (select way,highway,aeroway,name,ref,char_length(ref) as length,
       case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge
       from planet_osm_line
       where waterway IS NULL
         and leisure IS NULL
         and landuse IS NULL
         and (name is not null or ref is not null)
      ) as roads
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from       
       (select way from planet_osm_line where "addr:interpolation" is not null) as interpolation
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"addr:housenumber" from (select way,"addr:housenumber" from planet_osm_polygon where "addr:housenumber" is not null and building is not null) as way_numbers WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"addr:housenumber" from (select way,"addr:housenumber" from planet_osm_point where "addr:housenumber" is not null) as node_numbers WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","amenity","ele","highway","landuse","leisure","man_made","military","name","natural","place","point","ref","tourism" from 
      (select way,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref,military,aeroway,'yes'::text as point
       from planet_osm_point
       where amenity is not null
          or leisure is not null
          or landuse is not null
          or tourism is not null
          or "natural" is not null
          or man_made='lighthouse'
          or place='island'
          or highway='motorway_junction'
          or military='danger_area'
          or aeroway='gate'
      ) as text
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"aeroway","amenity","ele","highway","landuse","leisure","man_made","military","name","natural","place","point","ref","tourism" from 
      (select way,aeroway,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,NULL as ele,name,ref,military,'no'::text as point
       from planet_osm_polygon
       where amenity is not null
          or leisure is not null
          or landuse is not null
          or tourism is not null
          or "natural" is not null
          or man_made='lighthouse'
          or place='island'
          or military='danger_area'
      ) as text
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"name","way_area" from 
      (select way,way_area,name
       from planet_osm_polygon
       where name is not null
         and (waterway is null or waterway <> 'riverbank')
       order by z_order,way_area desc
      ) as text
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom from 
      (select way,name from planet_osm_polygon where boundary='national_park') as boundary
       WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
SELECT AsBinary("way",'NDR') AS geom,"admin_level" from 
      (select way,admin_level from planet_osm_roads where "boundary"='administrative') as admin WHERE "way" && SetSRID('BOX3D(2338590.880384967 6841343.34260813,2338896.628498109 6841649.090721272)'::box3d, 900913)
