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

[Hakan Tandogan]

On Tue, November 4, 2008 12:10, Andy Allan wrote:
> 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.

Sure, if you do have a border around the towns, and borders around the
countries, and all other kinds of border data...

Sometimes, you only know that this place "is in" that other place, but
there is no free data to derive borders from. And you can't trace
political / administrative boundaries from Yahoo imagery, can you?


Regards,
Hakan

-- 
The key to immortality is first living a life worth remembering...