[OSM-dev] Map rendering code... API or database direct?

Richard Fairhurst richard at systemeD.net
Thu Mar 30 13:47:55 BST 2006


Raphaël wrote:

> 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?

Richard





More information about the dev mailing list