[OSM-dev] A proposal for linking multiple ways into a virtual polygon

[SteveC]

On 16 May 2007, at 12:28, Martijn van Oosterhout wrote:

> On 5/15/07, Jon Burgess <jburgess777 at googlemail.com> wrote:
>> Yes, this can be speeded up easily by generating indexes for  
>> traversing
>> node->segment->way but I fear this would add significantly to the  
>> memory
>> usage (probably doubling it). The osm2pgsql code has already been
>> criticised for excessive memory usage.
>
> If you have a spatial index on ways you can simply do a bbox search on
> the endpoints. That will not require any extra indexes...

You haven't looked at the existing data model, it's a bit more work  
than that.

have fun,

SteveC | steve at asklater.com | http://www.asklater.com/steve/