[OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

Andy Allan gravitystorm at gmail.com
Tue Nov 4 11:10:37 GMT 2008


On Mon, Nov 3, 2008 at 6:47 PM, Frederik Ramm <frederik at remote.org> wrote:

> Increasingly, and I believe this is born from unreflected Wikipedia customs
> being applied here, people make "collections" or "categories" using
> relations, for example "cycle network North-Rine-Westphalia" containing
> every cycle route in that part of Germany, or another relation containing
> every German Autobahn, or one containing all McDonald's restaurants.

Nice. Much of this I suspect is because people really, really don't
understand the "spatial" bit of spatial databases. We still have
strong proponents of "is_in" style tagging on every object in a town,
when the more sane way to do that is to delineate the town itself and
use some spatial maths. Ditto with spatial-collections like All X in
area Y, which is utterly redundant.

Cheers,
Andy




More information about the dev mailing list