[OSM-dev] way 7062297, is this new?

Matthias Julius lists at julius-net.net
Thu Oct 9 18:31:51 BST 2008


"Ian Dees" <ian.dees at gmail.com> writes:

> On Wed, Oct 8, 2008 at 9:35 PM, Stefan de Konink <stefan at konink.de> wrote:
>
>>
>>
>> No way! The database[1] uses indexing under the hood automatically. So
>> every created_by k or JOSM v is automatically indexed. This gives a
>> significant space reduction plus fast lookup.
>>
>> Next to that it is very easy now to do lookups like done in OSMXAPI,
>> which I wrote my own implementation for.
>>
>>
> So you do want to use tag lookups. Ok, just add an extra numeric value to
> your primary key of {wayid,k} so that it looks like {wayid,k,number}. When
> you insert, look for duplicate tag keys and change the "number" when you
> find a duplicate.

Or make it a normal index instead of a primary key.  Then you can have
duplicates.

Matthias




More information about the dev mailing list