Suspect records found in osm Australia extract.
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.
<code>
-- --------------------------------------------------------------------
-- 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>----------------------
</code>
I <i>wonder</i> if someone could take a look at this as it seems rather suspect on first viewing, <b><i>comments? Suggestions?</i></b>
Regards,
Michael.