[OSM-dev] Map rendering code... API or database direct?
richard at systemeD.net
Thu Mar 30 13:47:55 BST 2006
> with postgresql 8.1 (that includes the postgis geometric objects),
> it's even easier :D
> SELECT * FROM segments WHERE
> ( point_a @ box('(x1,y1),(x2,y2)') ) OR
> ( point_b @ box('(x1,y1),(x2,y2)') )
I don't speak postgresql, I'm afraid, but doesn't that still have the problem
represented in Imi's ASCII art - i.e. point_a and point_b are both outside the
box, but the line between them crosses a corner?
More information about the dev