[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