[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