This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

[closed] Suspect records found in osm Australia extract.

4

Hi there all,

while becoming familiar ( and generally playing around with Postgresql + osm data ) with the mapping data system I discovered a set of records, contained within the australia.osm.pbf extract, which might be considered suspect...? I'll let higher authorities pass final judgement, however I include the following SQL style report on what I found.

-- QUERY: ~/Development/sql/suspect_tag_report.sql --

-- AUTHOR: MjF - 7 Feb 2013 -- -- HOST SYSTEM: SuSE Linux 12.1, postgresl 9.1, PostGIS 2.0 -- -- DB EXTENSIONS: hstore, plpsql, postgis, postgis_topology -- -- OSM DATA: osmosis <== regional data file 'australia.osm.pbf' -- -- OSM SOURCE: GeoFabrik - 1/2/2013 --

SELECT tags->'ref' AS tag_ref, tags->'name' AS tag_name, tags->'note' AS tag_note, tags->'power' AS tag_power, tags->'source' AS tag_source, tags->'addr:street' AS tag_addr_street, tags->'addr:suburb' AS tag_addr_suburb, tags->'attribution' AS tag_attribution, tags->'wp:location' AS tag_wp_location, tags->'wp:location_name' AS tag_wp_location_name FROM public.nodes WHERE tags->'source' = 'Western Power';

-- Above query returns 371 rows with similar output to that which is -- described below.

-- SAMPLE OUTPUT: single record - fields of concern marked with ''. -- ---------- -- tags->'ref' ==> | 605393 | -- ---------- -- tags->'name' ==> | 605393 | -- ***** -- tags->'note' ==> * This data has been extracted from a -- * Western Power database and should -- * not be uploaded to the OSM database. -- ***** -- tags->'power' ==> | pole | -- ----------------- -- tags->'source' ==> | Western Power | -- ----------------- -- tags->'addr:street' ==> | Absolon St | -- -------------- -- tags->'addr:suburb' ==> | Bumbleyung | -- ***** -- tags->'attribution' ==> * Permission NOT granted for reuse -- ****** -- tags->'wp:location' ==> | 1 E Dawson St | -- ----------------- -- tags->'wp:location_name' ==> | 605393 | -- ---------- -- ---------------------< END OF SAMPLE OUTPUT>----------------------

I wonder if someone could take a look at this as it seems rather suspect on first viewing, comments? Suggestions?

Regards, Michael.

asked 07 Feb '13, 07:28

MJFalconer's gravatar image

MJFalconer
71●1●2●4
accept rate: 0%

closed 13 Jan '15, 01:35

aseerel4c26's gravatar image

aseerel4c26 ♦
32.6k●18●248●554

Hmmm...i think things are not that easy at they seem. In Australia's case, the Western Power can be Russia, but this is a Eastern Power. Extrapolating that, America is The Eastern Power in this case but America is a Western Power. So all this raise a question: Why can't we just......get along....^-^

(07 Feb '13, 08:27) Kaigara
1

The above example is this node: https://www.openstreetmap.org/browse/node/1959963292 if that helps the DWG at all.

(07 Feb '13, 08:58) EdLoach ♦

@Kaigara: "Western Power" is probably the name of a power company.

(07 Feb '13, 12:23) gormo

2 Answers:

9

Hello,

Thanks for the report. The relevant nodes have been deleted and redacted.

Paul Norman,
For the Data Working Group

answered 08 Feb '13, 01:58

pnorman's gravatar image

pnorman
2.4k●5●21●40
accept rate: 18%

8

Thank you for reporting this. OSM has the Data Working Group https://wiki.openstreetmap.org/wiki/Data_working_group to deal with such issues.

I've sent them a mail with a pointer to this question. So I think you will get an answer in a couple of days here.

answered 07 Feb '13, 08:33

Roland%20Olbricht's gravatar image

Roland Olbricht
6.7k●3●64●89
accept rate: 36%

Source code available on GitHub .