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

Stefan de Konink stefan at konink.de
Thu Oct 9 03:35:54 BST 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Ian Dees schreef:
> On Wed, Oct 8, 2008 at 9:27 PM, Stefan de Konink <stefan at konink.de
> <mailto:stefan at konink.de>> wrote:
> 
>     I have a way table, that has a primary key {wayid}. The table way_tags
>     point to that wayid.
> 
> 
> Do you ever do a lookup by tag key name? If not, then you don't need to
> normalize the tags into their own table like that, just encode them
> somehow into a text blob column in the way table.

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.



Stefan

[1] http://www.monetdb.org/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEAREKAAYFAkjtbgoACgkQYH1+F2Rqwn1ORwCfYIP03zI1XqslqNp17eyx/wMJ
xv4AnRuleSRPCgfpIhgfh03nPN672ce4
=stIk
-----END PGP SIGNATURE-----




More information about the dev mailing list