On Fri, Sep 12, 2008 at 04:50:00PM +0200, Andreas Kalsch wrote:
Subject: Re: [OSM-dev] Spatial vs. multi-column indexes for points
Thanks!
And this really outperforms a simple query like ... latitude between
y1 and y2 and longitude between x1 and x2 ?
This would either need a combined
On Thu, Sep 11, 2008 at 08:31:23PM +0200, Andreas Kalsch wrote:
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
My current optimization includes:
- using mediumint for lat/lon - enough for ~2 meters resolution
- using a bounding box first for point+radius calculation and then
selecting the circle with a Pythagoras approximation, which is exact enough
For the first, I want to use MySQL.
On Fri, Sep 12, 2008 at 08:20:18AM +0200, Andreas Kalsch wrote:
Subject: Re: [OSM-dev] Spatial vs. multi-column indexes for points
On Thu, Sep 11, 2008 at 08:31:23PM +0200, Andreas Kalsch wrote:
All, thanks for your quick responses!
Quad tiles look like a smart way to create
On Thu, Sep 11, 2008 at 01:49:55PM +0200, Andreas Kalsch wrote:
Has anybody used GIS successfully in MySQL or PGSQL and can tell me
how the performance compares between the two techniques?
At least in PostgreSQL/PostGIS, the geometric indices are WAY faster.
Just remember to either use the
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
On Thu, Sep 11, 2008 at 1:31 PM, Andreas Kalsch [EMAIL PROTECTED]wrote:
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
My current optimization includes:
- using mediumint for lat/lon - enough for ~2 meters resolution
- using a bounding box first for point+radius calculation and then selecting
the circle with a Pythagoras approximation, which is exact enough
For the first, I want to use MySQL.
If you
8 matches
Mail list logo
