File:BAG import graph.png

From OpenStreetMap Wiki
Jump to: navigation, search
BAG_import_graph.png(728 × 410 pixels, file size: 27 KB, MIME type: image/png)

Summary

Progress of BAG import in the Netherlands. The number of buildings with source tags '3dShapes' and 'BAG' is shown, as well as the number of buildings with other source tags. Buildings without source tag are included in the Other/Overig category.

Data

Date 3dShapes BAG Overig
1-Oct-13 2800880 79566 224828
1-Nov-13 2788202 92408 265248
1-Dec-13 2785669 100487 273514
1-Jan-14 2765234 242684 250202
1-Feb-14 2715964 442183 253405
1-Mar-14 2622188 810324 257660
10-Mar-14 2575453 971866 260385
15-Mar-14 2535148 1165684 261483
20-Mar-14 2479173 1464212 260445
25-Mar-14 2300468 2142362 253502
30-Mar-14 2147306 2698273 243795
4-Apr-14 1966201 3285875 230878
9-Apr-14 1804200 3800549 217294
14-Apr-14 1663858 4271997 198985
19-Apr-14 1522165 4697164 177217
24-Apr-14 1359036 5209132 171256
29-Apr-14 1209138 5678192 165556
4-May-14 1019430 6220888 150667
9-May-14 904559 6619371 144833
14-May-14 775873 7158452 117339
19-May-14 684382 7458811 113698
24-May-14 600582 7795627 100756
29-May-14 554338 7983795 88155
3-Jun-14 469472 8304802 82363
8-Jun-14 411069 8510435 80980
13-Jun-14 357104 8711628 79128
18-Jun-14 329237 8797071 78168
28-Jun-14 254530 9024412 74571
8-Jul-14 217498 9188353 48581
18-Jul-14 191333 9252182 44384
1-Aug-14 161985 9331953 44282
12-Aug-14 97035 9547237 34914
16-Aug-14 66948 9651078 12895
1-Sep-14 56203 9697949 10779
5-Sep-14 56200 9697938 10808
8-Sep-14 29578 9799362 9302
12-Sep-14 21155 9817369 9182

Computing the data

Current method

  • OSM data for the Netherlands (netherlands-latest.osm.pbf) downloaded from Geofabrik.
  • Convert to o5m format with Osmconvert:
osmconvert netherlands-latest.osm.pbf -o=nl.o5m
  • Filter with Osmfilter, keeping only buildings:
osmfilter nl.o5m --keep="building=" -o=buildings.o5m
  • The Geofabrik file contains a small strip of land across the border. Buildings that are not inside the Netherlands need to be discarded. Download the border of the Netherlands from Openstreetmap and convert to a .poly file "Netherlands.poly". Then clip to this polygon:
osmconvert buildings.o5m -B=Netherlands.poly -o=buildings-clipped.o5m
  • Filter buildings and save statistics:
osmfilter buildings-clipped.o5m --keep="building=" --ignore-dependencies --drop-nodes --out-count=source > buildingsource.txt
osmfilter buildings-clipped.o5m --keep="building=" --ignore-dependencies --drop-nodes --out-count > buildingkeys.txt

Old method, using a PostgreSQL database

  • Buildings filtered with Osmosis:
osmosis --read-pbf file="netherlands-latest.osm.pbf" --tf reject-nodes 
    --tf accept-ways building=* --tf accept-relations building=* --write-pgsql-dump
  • Loaded in database using 'pgsnapshot_load_0.6.sql' from Osmosis
  • SQL query:
select source, count(*) as "num" from 
 (select lower(tags->'source') as "source" from ways union all 
  select lower(tags->'source') as "source" from relations) as "combine"
group by source

Gnuplot script

set term pngcairo size 728, 410 font "Helvetica,12"
set output "BAG_import_graph.png"
set xdata time
set timefmt "%d-%b-%y"
set xrange ["1-Nov-13":"30-Sep-14"]
set format x "%b-%y"
unset mxtics
set yrange [0:10]
set tics out nomirror scale 0.75
set xtics 2592000 textcolor rgb "black"
set ytics 2 textcolor rgb "black"
set ylabel "Aantal (in miljoen)"
set style data linespoints
set border lt rgb "#757575"
set grid ls 1 lt rgb "#D9D9D9"
set key inside c r samplen 2 spacing 1.65  reverse Left
plot "data.txt" using 1:($3/1e6) lw 2.5 lt rgb "#C0504D" pt 18 ps 0.8 title "BAG",\
     "data.txt" using 1:($2/1e6) lw 2.5 lt rgb "#4F81BD" pt 26 ps 1.1 title "3dShapes",\
     "data.txt" using 1:($4/1e6) lw 2.5 lt rgb "#9BBB59" pt 22 ps 0.8 title "Overig"

Licensing

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current16:03, 13 September 2014Thumbnail for version as of 16:03, 13 September 2014728 × 410 (27 KB)Cavit (Talk | contribs)Add new data, and use recalculated data, only including buildings in the Netherlands
20:09, 2 September 2014Thumbnail for version as of 20:09, 2 September 2014728 × 410 (27 KB)Cavit (Talk | contribs)Update with data until 1 Sep
12:06, 13 August 2014Thumbnail for version as of 12:06, 13 August 2014728 × 410 (27 KB)Cavit (Talk | contribs)Update data and formatting
18:35, 9 July 2014Thumbnail for version as of 18:35, 9 July 2014728 × 410 (25 KB)Cavit (Talk | contribs)Update with data from 8 Jul
11:47, 1 July 2014Thumbnail for version as of 11:47, 1 July 2014728 × 410 (25 KB)Cavit (Talk | contribs)Update with data from 28 Jun
11:20, 19 June 2014Thumbnail for version as of 11:20, 19 June 2014728 × 410 (25 KB)Cavit (Talk | contribs)Update with data from 18 Jun
19:40, 14 June 2014Thumbnail for version as of 19:40, 14 June 2014728 × 410 (25 KB)Cavit (Talk | contribs)Update with data from 13 Jun
10:41, 10 June 2014Thumbnail for version as of 10:41, 10 June 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 8 Jun
17:07, 4 June 2014Thumbnail for version as of 17:07, 4 June 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 3 Jun
10:52, 30 May 2014Thumbnail for version as of 10:52, 30 May 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 29 May
12:02, 25 May 2014Thumbnail for version as of 12:02, 25 May 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 24 May
09:43, 20 May 2014Thumbnail for version as of 09:43, 20 May 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 19 May
09:03, 15 May 2014Thumbnail for version as of 09:03, 15 May 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 14 May
15:46, 11 May 2014Thumbnail for version as of 15:46, 11 May 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update with data from 9 May
22:04, 6 May 2014Thumbnail for version as of 22:04, 6 May 2014728 × 410 (5 KB)Osm@floris.nu (Talk | contribs)added data for netherlands-140504.osm.pbf
09:01, 30 April 2014Thumbnail for version as of 09:01, 30 April 2014728 × 410 (23 KB)Cavit (Talk | contribs)Update with data from 29 Apr
08:55, 25 April 2014Thumbnail for version as of 08:55, 25 April 2014728 × 410 (23 KB)Cavit (Talk | contribs)Update 25 Apr
11:47, 20 April 2014Thumbnail for version as of 11:47, 20 April 2014728 × 410 (24 KB)Cavit (Talk | contribs)Update 20 Apr
11:09, 15 April 2014Thumbnail for version as of 11:09, 15 April 2014728 × 410 (23 KB)Cavit (Talk | contribs)Update 15 Apr
12:46, 10 April 2014Thumbnail for version as of 12:46, 10 April 2014728 × 410 (23 KB)Cavit (Talk | contribs)Update 10 Apr
16:07, 5 April 2014Thumbnail for version as of 16:07, 5 April 2014728 × 410 (17 KB)Cavit (Talk | contribs)Update 5 Apr
12:22, 31 March 2014Thumbnail for version as of 12:22, 31 March 2014728 × 410 (19 KB)Cavit (Talk | contribs)Update 31 Mar
11:38, 26 March 2014Thumbnail for version as of 11:38, 26 March 2014728 × 410 (18 KB)Cavit (Talk | contribs)Update 26 Mar
15:55, 21 March 2014Thumbnail for version as of 15:55, 21 March 2014728 × 410 (17 KB)Cavit (Talk | contribs)Update 21 Mar
20:31, 16 March 2014Thumbnail for version as of 20:31, 16 March 2014728 × 410 (15 KB)Cavit (Talk | contribs)Progress of BAG import in the Netherlands.
  • You cannot overwrite this file.

The following page links to this file: