File:BAG import graph.png
Jump to navigation
Jump to 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
This work is licensed under the Creative Commons Attribution-ShareAlike 2.0 License.
Attribution not specified as a parameter! THIS LICENSE ALWAYS REQUIRES ATTRIBUTION! Use {{CC-BY-SA-2.0|Attribution, typically name of author}} See Template:CC-BY-SA-2.0 for full description how this template should be used.
Note, there is
There is also
Attribution not specified as a parameter! THIS LICENSE ALWAYS REQUIRES ATTRIBUTION! Use {{CC-BY-SA-2.0|Attribution, typically name of author}} See Template:CC-BY-SA-2.0 for full description how this template should be used.
Note, there is
{{CC-BY-SA-2.0 OpenStreetMap}}
for files based on old OSM map data, before the license change made on 2012-09-12.There is also
{{OSM Carto screenshot||old_license}}
for files based on old OSM map data, before the license change made on 2012-09-12, created using OSM Carto map style.
File history
Click on a date/time to view the file as it appeared at that time.
Date/Time | Thumbnail | Dimensions | User | Comment | |
---|---|---|---|---|---|
current | 16:03, 13 September 2014 | 728 × 410 (27 KB) | Cavit (talk | contribs) | Add new data, and use recalculated data, only including buildings in the Netherlands | |
20:09, 2 September 2014 | 728 × 410 (27 KB) | Cavit (talk | contribs) | Update with data until 1 Sep | ||
12:06, 13 August 2014 | 728 × 410 (27 KB) | Cavit (talk | contribs) | Update data and formatting | ||
18:35, 9 July 2014 | 728 × 410 (25 KB) | Cavit (talk | contribs) | Update with data from 8 Jul | ||
11:47, 1 July 2014 | 728 × 410 (25 KB) | Cavit (talk | contribs) | Update with data from 28 Jun | ||
11:20, 19 June 2014 | 728 × 410 (25 KB) | Cavit (talk | contribs) | Update with data from 18 Jun | ||
19:40, 14 June 2014 | 728 × 410 (25 KB) | Cavit (talk | contribs) | Update with data from 13 Jun | ||
10:41, 10 June 2014 | 728 × 410 (24 KB) | Cavit (talk | contribs) | Update with data from 8 Jun | ||
17:07, 4 June 2014 | 728 × 410 (24 KB) | Cavit (talk | contribs) | Update with data from 3 Jun | ||
10:52, 30 May 2014 | 728 × 410 (24 KB) | Cavit (talk | contribs) | Update with data from 29 May |
You cannot overwrite this file.
File usage
The following page uses this file: