Skip to content

Instantly share code, notes, and snippets.

@cquest

cquest/gist:996b9465fd46e7a19282

Created February 10, 2015 17:52
Show Gist options
  • Save cquest/996b9465fd46e7a19282 to your computer and use it in GitHub Desktop.
Save cquest/996b9465fd46e7a19282 to your computer and use it in GitHub Desktop.
Download ZIP
Stats d'exhaustivité OSM au 10-02-2015
Raw
gistfile1.txt
select *, round(100*pop_sans_route::numeric/population::numeric,1), round(100*pop_sans_bati::numeric/population::numeric,1) from (select tags->'ref:INSEE' as dep, count(*) as carreaux, sum(case when highways=0 then ind_c else 0 end) as pop_sans_route, sum(case when buildings=0 then ind_c else 0 end) as pop_sans_bati, sum(ind_c) as population from planet_osm_polygon d join insee_menages on (wkb_geometry && way) where boundary='administrative' and tags ? 'ref:INSEE' and admin_level='6' group by 1 order by 1) as stat;
dep | carreaux | pop_sans_route | pop_sans_bati | population | %rout | %bati
-----+----------+----------------+---------------+------------+-------+-------
01 | 59177 | 903 | 8654 | 2551428 | 0.0 | 0.3
02 | 35369 | 4994 | 272866 | 1099138 | 0.5 | 24.8
03 | 46147 | 7685 | 161065 | 498835 | 1.5 | 32.3
04 | 20406 | 4087 | 6506 | 309063 | 1.3 | 2.1
05 | 15939 | 1462 | 4773 | 265146 | 0.6 | 1.8
06 | 19420 | 4154 | 11571 | 1147043 | 0.4 | 1.0
07 | 45918 | 6662 | 99239 | 708945 | 0.9 | 14.0
08 | 15508 | 3081 | 152687 | 476474 | 0.6 | 32.0
09 | 21218 | 3105 | 80835 | 244870 | 1.3 | 33.0
10 | 17149 | 1455 | 112620 | 404914 | 0.4 | 27.8
11 | 25845 | 2285 | 102778 | 804891 | 0.3 | 12.8
12 | 56389 | 9432 | 82184 | 628150 | 1.5 | 13.1
13 | 51635 | 14418 | 32326 | 2477531 | 0.6 | 1.3
14 | 49459 | 11462 | 175957 | 802102 | 1.4 | 21.9
15 | 23827 | 2394 | 46512 | 221224 | 1.1 | 21.0
16 | 49390 | 5098 | 66222 | 542699 | 0.9 | 12.2
17 | 56834 | 3937 | 36239 | 991098 | 0.4 | 3.7
18 | 36545 | 7198 | 190502 | 478936 | 1.5 | 39.8
19 | 37856 | 5370 | 110752 | 344998 | 1.6 | 32.1
21 | 25893 | 2595 | 66758 | 667538 | 0.4 | 10.0
22 | 65608 | 5878 | 16982 | 809737 | 0.7 | 2.1
23 | 26310 | 2009 | 24270 | 231613 | 0.9 | 10.5
24 | 80481 | 13389 | 293489 | 715179 | 1.9 | 41.0
25 | 23721 | 720 | 12789 | 658120 | 0.1 | 1.9
26 | 59760 | 7512 | 40268 | 1355026 | 0.6 | 3.0
27 | 51529 | 11175 | 305507 | 1405189 | 0.8 | 21.7
28 | 33774 | 5844 | 262583 | 871610 | 0.7 | 30.1
29 | 62912 | 1287 | 11843 | 1025174 | 0.1 | 1.2
2A | 8405 | 5127 | 32802 | 149095 | 3.4 | 22.0
2B | 10669 | 8406 | 75700 | 234640 | 3.6 | 32.3
30 | 53855 | 10333 | 97665 | 1726295 | 0.6 | 5.7
31 | 83430 | 8186 | 123298 | 1619910 | 0.5 | 7.6
32 | 46030 | 9834 | 50346 | 337401 | 2.9 | 14.9
33 | 88128 | 19790 | 274577 | 1701736 | 1.2 | 16.1
34 | 29000 | 3989 | 96688 | 1175678 | 0.3 | 8.2
35 | 74314 | 5849 | 17823 | 1222610 | 0.5 | 1.5
36 | 30097 | 5090 | 85163 | 348376 | 1.5 | 24.4
37 | 45347 | 4577 | 77645 | 836295 | 0.5 | 9.3
38 | 91297 | 5273 | 22247 | 3416293 | 0.2 | 0.7
39 | 26458 | 286 | 7036 | 582985 | 0.0 | 1.2
40 | 51060 | 25124 | 146074 | 569467 | 4.4 | 25.7
41 | 50761 | 8841 | 201550 | 1241483 | 0.7 | 16.2
42 | 61000 | 15009 | 127421 | 1284020 | 1.2 | 9.9
43 | 25489 | 5125 | 71496 | 405194 | 1.3 | 17.6
44 | 75023 | 2990 | 4956 | 1664746 | 0.2 | 0.3
45 | 37092 | 3878 | 160090 | 843598 | 0.5 | 19.0
46 | 42056 | 8294 | 71174 | 287086 | 2.9 | 24.8
47 | 48723 | 16070 | 119129 | 412990 | 3.9 | 28.8
48 | 11332 | 2218 | 32021 | 110649 | 2.0 | 28.9
49 | 58889 | 2884 | 4228 | 1046541 | 0.3 | 0.4
50 | 58115 | 7928 | 108933 | 641206 | 1.2 | 17.0
51 | 20550 | 4554 | 216116 | 700005 | 0.7 | 30.9
52 | 14604 | 2473 | 119127 | 303922 | 0.8 | 39.2
53 | 41872 | 12745 | 33149 | 485443 | 2.6 | 6.8
54 | 39215 | 1218 | 70606 | 1777239 | 0.1 | 4.0
55 | 13502 | 1498 | 112296 | 364832 | 0.4 | 30.8
56 | 64365 | 8140 | 5691 | 1014707 | 0.8 | 0.6
57 | 36975 | 823 | 27129 | 1745398 | 0.0 | 1.6
58 | 27122 | 3499 | 128967 | 298540 | 1.2 | 43.2
59 | 75263 | 1202 | 37654 | 3682686 | 0.0 | 1.0
60 | 28611 | 897 | 250842 | 1135298 | 0.1 | 22.1
61 | 56644 | 10355 | 145951 | 550708 | 1.9 | 26.5
62 | 67179 | 1318 | 16547 | 3029287 | 0.0 | 0.5
63 | 48752 | 7053 | 92585 | 822977 | 0.9 | 11.3
64 | 46193 | 4438 | 10029 | 746839 | 0.6 | 1.3
65 | 29513 | 1741 | 19093 | 360237 | 0.5 | 5.3
66 | 12242 | 1274 | 31048 | 475153 | 0.3 | 6.5
67 | 27113 | 550 | 6420 | 1254599 | 0.0 | 0.5
68 | 23166 | 403 | 1208 | 1002619 | 0.0 | 0.1
69 | 54063 | 6541 | 28208 | 2287970 | 0.3 | 1.2
70 | 25432 | 1776 | 78491 | 529557 | 0.3 | 14.8
71 | 65053 | 4875 | 64572 | 918402 | 0.5 | 7.0
72 | 55039 | 6368 | 127350 | 745353 | 0.9 | 17.1
73 | 35398 | 1013 | 3730 | 1264917 | 0.1 | 0.3
74 | 31654 | 1452 | 10619 | 908765 | 0.2 | 1.2
75 | 3717 | 0 | 24 | 3221984 | 0.0 | 0.0
76 | 52490 | 13127 | 315080 | 1499195 | 0.9 | 21.0
77 | 42406 | 1917 | 180086 | 4674459 | 0.0 | 3.9
78 | 26675 | 1030 | 198094 | 2595871 | 0.0 | 7.6
79 | 41296 | 786 | 1365 | 646068 | 0.1 | 0.2
80 | 36624 | 1882 | 191233 | 1033859 | 0.2 | 18.5
81 | 45406 | 8206 | 81451 | 546369 | 1.5 | 14.9
82 | 40479 | 8016 | 61865 | 387699 | 2.1 | 16.0
83 | 36293 | 16245 | 82208 | 1148588 | 1.4 | 7.2
84 | 41813 | 8557 | 13531 | 849607 | 1.0 | 1.6
85 | 47528 | 201 | 1335 | 862793 | 0.0 | 0.2
86 | 41664 | 2190 | 16441 | 562722 | 0.4 | 2.9
87 | 41515 | 4105 | 66163 | 477159 | 0.9 | 13.9
88 | 29454 | 996 | 38164 | 540900 | 0.2 | 7.1
89 | 33874 | 1676 | 78127 | 669249 | 0.3 | 11.7
90 | 6648 | 139 | 507 | 305714 | 0.0 | 0.2
91 | 17888 | 402 | 37895 | 1997847 | 0.0 | 1.9
92 | 6403 | 49 | 3667 | 2975987 | 0.0 | 0.1
93 | 9589 | 0 | 49745 | 4740712 | 0.0 | 1.0
94 | 7635 | 1 | 158 | 2732061 | 0.0 | 0.0
95 | 19566 | 207 | 227969 | 3024983 | 0.0 | 7.5
(96 rows)
Time: 19376,147 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment