[OSM-talk] Boundary relation with >5000 members?
Florian Lohoff
f at zz.de
Sun Mar 28 16:50:07 BST 2010
Hi,
i put together all boundary relations in the Database and got to this:
osm=# select * from relation_tags where relation_id = 305693;
relation_id | k | v
-------------+-------------+-----------------------------------------------------
305693 | admin_level | 4
305693 | boundary | administrative
305693 | name | XI Región Aysén del General Carlos Ibáñez del Campo
305693 | type | boundary
(4 rows)
osm=# select count(member_id) from relation_members where relation_id = 305693;
count
-------
5524
(1 row)
I havent looked at it very closely - but 5000 members in a boundary relations
sounds very much broken ...
It is be far leading the boundary relation member highscorer:
relation_id | count
-------------+-------
305693 | 5524
301542 | 4442
102039 | 981
356911 | 836
357113 | 772
94354 | 764
51477 | 686
166570 | 668
349004 | 660
391132 | 656
102740 | 651
90162 | 648
51684 | 631
89072 | 608
442397 | 579
Flo
--
Florian Lohoff f at zz.de
"Es ist ein grobes Missverständnis und eine Fehlwahrnehmung, dem Staat
im Internet Zensur- und Überwachungsabsichten zu unterstellen."
- - Bundesminister Dr. Wolfgang Schäuble -- 10. Juli in Berlin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20100328/5f4e7a6e/attachment.pgp>
More information about the talk
mailing list