[osmosis-dev] postGIS: bbox columns?

David Carmean dlc at halibut.com
Sat May 22 22:36:46 BST 2010


Who is knowledgable about the osm/postGIS simple schema design and 
associated scripts?

I have several questions, and keep coming up with others, as 
I experiment with using osm data as GIS base data, but today's 
question is:

    Who/what uses the ways.bbox column?  Is there something/somebody 
    that cannot use the linestring gist index, but instead requires 
    an explicit bounding box geometry?

For what it's worth, I reversed the order and created the 
linestring geometry column first, and found that creating
the bbox column from the linestring instead was seemingly 
thousands of times faster than creating it (the bbox) from 
the nodes table.  Once I fix a hardware problem I plan to 
get some hard numbers.

Thanks.





More information about the osmosis-dev mailing list