I have a postgis db with an germany dump. I like to write a query which returns all ways in an specific area (Bounding box).
I have imported my data with osmosis. My ways have a linestring geometry and my nodes a point geometry.
I am not sure how to write the query.
My first idea was:
WHERE linestring && ‘BOX3D(60000000 430000000, 130000000 550000000)’::box3d
But this does not work.
Do you have an idea?