I would like to extract 'landuse' information from OSM data using postgis

Question

I am trying to extract OSM land use information for a given bounding box in PostGIS. Using this example I wrote my code:

SELECT *
FROM planet_osm_polygon 
WHERE 
  planet_osm_polygon.landuse && 
  ST_Transform(ST_MakeEnvelope(1.49464, 49.1963130, 1.628030, 49.287031, 4326), 32647);

Unfortunately it returns me an error:

ERROR: transform: couldn't project point (1.49464 49.1963 0): latitude or longitude exceeded limits (-14)

Answer 1

The problem was in a wrong column I should take planet_osm_polygon.way not planet_osm_polygon.landuse

SELECT  * FROM planet_osm_polygon 
WHERE planet_osm_polygon.way && 
ST_Transform(ST_MakeEnvelope( 2.3160604029813427 ,49.20365292898691, 2.317437943284213 ,49.204552967527086 , 4326), 900913)