<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Florian Lohoff wrote:
<blockquote cite="mid:20080912065808.GA28297@paradigm.rfc822.org"
type="cite">
<pre wrap="">On Fri, Sep 12, 2008 at 08:20:18AM +0200, Andreas Kalsch wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Subject: Re: [OSM-dev] Spatial vs. multi-column indexes for points
</pre>
<blockquote type="cite">
<pre wrap="">On Thu, Sep 11, 2008 at 08:31:23PM +0200, Andreas Kalsch wrote:
</pre>
<blockquote type="cite">
<pre wrap="">All, thanks for your quick responses!
Quad tiles look like a smart way to create an index. So to lookup a
single point or a quad tile, this is fine. But for my application I
need another lookup - by bounding box with any ratio and size. Is
there a way to look up a special bounding box with this index? I
think this will be a little more complicated without conventional
multi-column indices. Hmm, I think you could take a maximum number
of quad lookups which contain the requested box, what do you think?
</pre>
</blockquote>
<pre wrap="">The code in the api calculates all possible quadtile areas and does a
quadtile in ( x, y, z, a, b, c, d, e, f ) or quadtile between x and y
etc
</pre>
</blockquote>
<pre wrap="">Can you give me the position of this code in SVN, I am sure will understand it more deeply then.
</pre>
</blockquote>
<pre wrap=""><!---->
applications/utils/export/osm2ai/osm2ai.pl
Is a perl variant - look for "sql_for_area"
In the rails_ports its done with a C helper - look in
sites/rails_port/lib/quad_tile/
</pre>
</blockquote>
or for the rails version<br>
<a class="moz-txt-link-freetext" href="http://trac.openstreetmap.org/browser/sites/rails_port/lib/quad_tile.rb">http://trac.openstreetmap.org/browser/sites/rails_port/lib/quad_tile.rb</a><br>
<br>
Shaun<br>
<br>
</body>
</html>