[talk-au] Qld police stations - potential OSM bulk import

[John Smith]

2009/12/11 Chris Barham <cbarham at pobox.com>:
> Hi,
> I think I have found a good datasource for OSM, but I've run out of
> steam trying to manipulate it.  If there is agreement the data is
> useful and legitimate; similar to the BP import, I wondered if I could
> ask for help, perhaps reapplying Johns' BP import code/procedure to
> this dataset?
>
> Queensland Police Stations XML File at :
> http://drop.io/8j7bxdi/asset/extractedpoliceqld-xml

Not sure if you dropped decimal places or not, but some locations only
has 2 decimal places which are only good to the nearest km

> The data is all Queensland police stations, as listed on
> http://www.police.qld.gov.au/station-locator/stationIndex.asp
> There are also index pages to police shops and neighbourhood beats,
> but I have ignored these.

Any reason you ignored these?

> The Copyright statement at http://www.police.qld.gov.au/copyright.htm
> says that QPS are keen on reuse, and just want attribution, which I
> thought might be easily achieved via a source tag(?)

That just means:

attributation=Qld Police

> 1) What format to transform it to - OSM? with what tags? how?

.osm file format makes it easy to import because you just load it into
JOSM and then tell JOSM to upload all points at once.

> 2) Would be great to generate a fixme tag generated HTML page,
> (similar to the the BP one) for people to easily jump to PotLatch and
> check/review

This is fairly trivial to do.

> 3) de-duplication if station already there (merging etc?)

This is should be a lot easier than amenity=fuel since you don't have
competing companies located next to each other.

> A possible output tag template(?):
>
> <node id='-1' action='create' visible='true' lat='${lat}' lon='${lon}'>
>    <tag k='amenity' v='police' />
>    <tag k='phone' v='${phone}' />
>    <tag k='name' v='${name}' />
>    <tag k='QueenslandPolice:stationId' v='${code}' />
>    <tag k='QueenslandPolice:address' v='${address}' />
>    <tag k='QueenslandPolice:suburb' v='${suburb}' />
>    <tag k='fixme' v='not_reviewed' />
>    <tag k='source' v='Queensland Police Service' />
>    <tag k='website'
> v='http://www.police.qld.gov.au/station-locator/station_locator.asp?code=${code}'
> />
> </node>
>
> So, in short, I can't finish what I have started; If there is
> agreement the data is useful and legitimate, could I hand it over to
> someone else to import? :-)

There is already some police stations tagged in the DB, so I don't see
why it wouldn't be useful,