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

[Richard Fairhurst]

Imi wrote:

> 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))
>> [SQL snipped]
>> 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.

It works for your ASCII art suggestion, doesn't it?

xmax is between $bbox_xmin and $bbox_xmax, so the first part is true
ymin is between $bbox_ymin and $bbox_ymax, so the second part is true
therefore the ANDed condition is true.

If it's flawed I should probably tell the Waterscape chaps, as this is 
the query that chooses waterway lines for their maps. :)

cheers
Richard