Country report Brazil

Argentina is the Q155 Wikidata item and the BR ISO abbreviation. Database dumps collected in August 2018.

Wikidata dumps

...

OSM dumps

OSM sources at geofabrik.de.

The filtered elements with the wikidata tag (a Wikidata-ID value wd_id) showed the foloweing profile, about "direct use of the wikidata-tag".

element_type	Elements with wd_id	With distinct wd_id	% distincts
n	4168	4044	97
r	6099	6025	99
w	1568	1110	71

The most common reason for wd_id duplication is by tagging fragments, that is, the parts instead the whole. The most common element type edited with this part/whole confusion is way element (w).

Way (w) and relation (r) elements with members that have wikidata-tag, represents indirect use. The "feature type" is expressed by type and higthway tags, splitting the profile:

osm_type	feature_type	n_direct	n_total	Directs
n		4166	4166	100%
n	fixed_point	1	1	100%
n	triangulation	1	1	100%
n	enforcement	0	10	0%
r	boundary	5302	5331	99%
r	multipolygon	428	433	99%
r	route	167	186	90%
r	waterway	117	117	100%
r	public_transport	58	58	100%
r	route_master	17	17	100%
r	site	3	3	100%
r	watershed	1	2	50%
w		1248	49375	3%
w	primary	119	10353	1%
w	trunk	94	2299	4%
w	waterway	28	62	45%
w	secondary	21	1810	1%
w	service	15	165	9%
w	tertiary	14	1441	1%
w	motorway	13	3900	0%
w	residential	12	643	2%
w	boundary	2	8	25%
w	path	0	25	0%
w	track	0	47	0%

Prepare

Procedures described by simple-osmWd2csv:

wget https://download.geofabrik.de/south-america/brazil-latest.osm.pbf

osmium tags-filter brazil-latest.osm.pbf nwr/wikidata -o BR_wd.osm

sh src/step1-osmWd2csv_pre.sh < BR_wd.osm | php src/step2-osmWd2csv.php > /tmp/BR_wd.raw.csv

psql -U postgres work < src/step0-osmWd_lib.sql

psql -U postgres work < src/step3-osmWd_parseRaw.sql