Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table osm_roads that has a column named geometry geometry geometry(LineString,900913).

If I want to filter a city to draw districts, I cannot do it by geographic coordinates?

What if in openJUMP or QGIS I want to select by bounding box, such a table as that?

Thank you in advance.

share|improve this question
is you osm data in a database? – Mapperz Jan 29 '13 at 2:36
So you need only the districts from osm data? – Niculita Mihai Jan 29 '13 at 6:47
I apologize for not being clear. I have the country imported in PostGIS, but in order to work with a certain city I would only need to add a vector layer filtered, so I don't have to load the other 90% of the country as a layer in QGIS. – Martin0x777 Jan 29 '13 at 19:02
up vote 2 down vote accepted

To do the bounding box you need a polygon of the city in the same coordinate system as your current data


Go to either Vector>Research Tools->Select by location or Plugins>Spatial Query and select the options.

Vector>Research Tools->Polygon from layer extent and make a polygon of the full extent. Then follow the steps in option 1 above using your new polygon.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.