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.

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.