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

immanuel.scholz at gmx.de immanuel.scholz at gmx.de
Thu Mar 30 12:53:17 BST 2006


Hi,

> SELECT id,path FROM segments WHERE
>     ((xmin BETWEEN $bbox_xmin AND $bbox_xmax) OR
>      (xmax BETWEEN $bbox_xmin AND $bbox_xmax) OR
>      (xmin<$bbox_xmin AND xmax>$bbox_xmax)) AND
>     ((ymin BETWEEN $bbox_ymin AND $bbox_ymax) OR
>      (ymax BETWEEN $bbox_ymin AND $bbox_ymax) OR
>      (ymin<$bbox_ymin AND ymax>$bbox_ymax))
>
> where xmin, xmax, ymin and ymax are the bounding box of each segment,
> and $bbox_xmin, $bbox_xmax etc. are the bounding box of the current map
> view (tile).

See my other posting why this is still flawed.

Ciao, Imi.




More information about the dev mailing list