Skip to main content
Geographic Information Systems

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

7
  • 1
    Swap the two points in ST_MakeBox2D? Doc says the first point should be the lower left one. Commented Jan 30, 2015 at 22:28
  • 1
    @mkennedy. The docs do say that, but it makes no difference, in practice. Check out, select st_astext(st_makebox2d(st_makepoint(50,50), st_makepoint(5,5)) ); Commented Jan 30, 2015 at 23:36
  • What Christopher says is true, but I am surprised that no roads are contained in a polygon covering all of London -- I hope so, I'm going there in a few hours by bus :D. The query looks fine, so perhaps you could post a couple of rows of the actual geometry values? Commented Jan 30, 2015 at 23:41
  • Thanks guys, I've updated with observations from your comments :) Commented Jan 31, 2015 at 10:58
  • Would you be able to provide the link the you got england-latest.osm from, so we are dealing with the same data. I fancy loading osm for the UK and might have some insights after doing so. Commented Feb 2, 2015 at 17:02