[OSM-talk-be] Buildings and cadastre in Brussels and Belgium

eMerzh merzhin at gmail.com
Tue Oct 4 21:25:58 UTC 2011


Here is another bunch of stats (not 100% sure about this... i'm quite
new to postgis/osm2psql :p)
i can give sql if someone is interested at verifying/correct :p

I hope you'll find what you're looking for....



Number of building per city.

 count |                     name
-------+----------------------------------------------
 22376 | Bruxelles/Brussel
  9185 | Etterbeek
  6251 | Saint-Gilles - Sint-Gillis
  4355 | Forest - Vorst
  3400 | Woluwe-Saint-Lambert - Sint-Lambrecht-Woluwe
  2729 | Ixelles - Elsene
  2116 | Woluwe-Saint-Pierre - Sint-Pieters-Woluwe
  1181 | Anderlecht
   784 | Auderghem - Oudergem
   671 | Jette
   670 | Uccle - Ukkel
   640 | Molenbeek-Saint-Jean - Sint-Jans-Molenbeek
   598 | Schaerbeek - Schaarbeek
   570 | Watermael-Boitsfort - Watermaal-Bosvoorde
   445 | Evere
   375 | Ganshoren
   260 | Berchem-Sainte-Agathe - Sint-Agatha-Berchem
   160 | Saint-Josse-ten-Noode - Sint-Joost-ten-Node
    72 | Koekelberg



Size of building cover / city cover / %age of building vs city


 nbr_building | build_size | com_size  |  proc   |
com_name
--------------+------------+-----------+---------+----------------------------------------------
         9185 | 1.66 km²   | 3.17 km²  | 52.32 % | Etterbeek
         6251 | 1.32 km²   | 2.54 km²  | 52.18 % | Saint-Gilles - Sint-Gillis
          160 | 0.44 km²   | 1.14 km²  | 38.60 % |
Saint-Josse-ten-Noode - Sint-Joost-ten-Node
         2729 | 0.41 km²   | 1.25 km²  | 32.48 % | Ixelles - Elsene
        22376 | 10.06 km²  | 32.95 km² | 30.55 % | Bruxelles/Brussel
         4355 | 1.34 km²   | 6.31 km²  | 21.24 % | Forest - Vorst
          640 | 1.26 km²   | 6.04 km²  | 20.90 % |
Molenbeek-Saint-Jean - Sint-Jans-Molenbeek
         3400 | 1.26 km²   | 7.36 km²  | 17.19 % |
Woluwe-Saint-Lambert - Sint-Lambrecht-Woluwe
          445 | 0.87 km²   | 5.19 km²  | 16.69 % | Evere
          598 | 1.09 km²   | 7.94 km²  | 13.76 % | Schaerbeek - Schaarbeek
          671 | 0.54 km²   | 5.19 km²  | 10.41 % | Jette
         1181 | 1.79 km²   | 17.98 km² | 9.98 %  | Anderlecht
          260 | 0.29 km²   | 2.93 km²  | 9.97 %  |
Berchem-Sainte-Agathe - Sint-Agatha-Berchem
          375 | 0.24 km²   | 2.45 km²  | 9.80 %  | Ganshoren
           72 | 0.10 km²   | 1.19 km²  | 8.45 %  | Koekelberg
         2116 | 0.60 km²   | 8.94 km²  | 6.75 %  | Woluwe-Saint-Pierre
- Sint-Pieters-Woluwe
          784 | 0.54 km²   | 9.00 km²  | 6.01 %  | Auderghem - Oudergem
          670 | 0.81 km²   | 22.95 km² | 3.55 %  | Uccle - Ukkel
          570 | 0.30 km²   | 12.94 km² | 2.34 %  | Watermael-Boitsfort
- Watermaal-Bosvoorde



AND the top hit contributing  :


        osm_user        | count
------------------------+-------
 eMerzh                 |  9410
 moyogo                 |  8853
 TAA                    |  4432
 rob72                  |  1344
 orioane                |  1082
 Sebke                  |   876
 Pieter S               |   723
 Polyglot               |   539
 Capitaine Igloo        |   478
 Niobos                 |   240
 Paul-Andre Duchesne    |   231
 zors1843               |    94
 Bouska                 |    85
 Tbj                    |    73
 CyFo                   |    71
 Toi                    |    51
 KLMB                   |    44
 meet00                 |    41
 Jowielen               |    39
 Laurent Peuch          |    33
 Tomi                   |    32
 BenoitL                |    27
 Victor LP              |    21
 pluimpje               |    21
 chefduff               |    20
 Oli-Wan                |    16
 xybot                  |    13
 Eimai                  |    12
 DeStandaert            |    12
 Simke                  |    11
 steak country          |    11
 Thomas1950             |    10
 Markus B               |    10
 Xavpei                 |     9
 AtonX                  |     9
 foxandpotatoes         |     8
 ulrich-dtmd            |     8
 PhilippeP              |     8
 FTstreet               |     8
 BSVT                   |     7
 friesede               |     7
 linusable              |     7
 Beruco                 |     6
 Bigon                  |     6
 La pinte               |     6
 osm_contrib            |     5
 plexi32                |     5
 Irbis82                |     5
 quosoo                 |     5
 MichelD                |     5
 ulfl                   |     4
 Dieter Schmeer         |     4
 Michel Vandermeuter    |     4
 Ben VdA                |     3
 inoshishi              |     3
 raskas                 |     3
 FrViPofm               |     3
 Scapor                 |     3
 Koying                 |     3
 Mr_Israel              |     2
stijndw                |     2
 Sea                    |     2
 pvdp                   |     2
 Zyphos                 |     2
 gkai                   |     2
 LivingWithDragons      |     2
 Pieter Van Pamel       |     2
 Maarten Deen           |     2
 OlivierCO              |     2
 npettiaux              |     2
 Filip                  |     1
 Walter Schlögl         |     1
 FanJoe                 |     1
 MichalP                |     1
 snyder19               |     1
 bigtrifle              |     1
 adjuva                 |     1
 CSU                    |     1
 schristophe            |     1
 CGT                    |     1
 patidou                |     1
 stoecker               |     1
 toeklk                 |     1
 Geostationary          |     1
 s-m                    |     1
 ProsperS               |     1
 Wila                   |     1
 ghia                   |     1
 Min's                  |     1
dkinnard               |     1
 Julien Fastré          |     1
 Drupol                 |     1
 cimm                   |     1
 belgiumpma             |     1
 OIB                    |     1
 cgu66                  |     1
 Falken                 |     1
 PeterIto               |     1
 Dirk Dufour            |     1
 Olivier Le Thanh Duong |     1
 Ana Luisa              |     1
 user_5359              |     1
 _al                    |     1
 Tpenninckx             |     1
 tijuca                 |     1
 magicmagnet            |     1




More information about the Talk-be mailing list