You are not logged in.
- Topics: Active | Unanswered
Announcement
*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***
Pages: 1
#1 2011-05-06 09:34:40
- markusH
- Member
- Registered: 2011-02-08
- Posts: 14
Postgis query
Hey all,
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:
SELECT *
FROM ways
WHERE linestring && 'BOX3D(60000000 430000000, 130000000 550000000)'::box3d
But this does not work.
Do you have an idea?
Best regards,
Markus
Last edited by markusH (2011-05-06 09:43:10)
Offline
Pages: 1