search

water-fountains / import2wikidata

scripts to import open government data to wikidata
Other
1 stars 2 forks source link

import (3?) fountain files of Basel ? #12

Open ralfhauser opened 5 years ago

ralfhauser commented 5 years ago

https://opendata.swiss/dataset/bade-trinkwasser-und-zierbrunnen-in-basel

With the help of J.Bieri, I got the file 20190909BrunnenInBasel.kml.zip

Please import !

see also https://github.com/water-fountains/proximap/issues/257

It has images, but they are unfortunately on google, so please 1) use P6500 https://github.com/water-fountains/proximap/issues/279

ralfhauser commented 5 years ago

I converted it with https://mygeodata.cloud/converter/kml-to-csv to 3 rather simplistic csv's but at least it would allow to

2) set the "swimming place (Q17456505)"

20190909BrunnenInBasel.kml2csv.mygeodata.zip

(Jonas.Bieri@bs.ch recommends to use https://github.com/opendatabs/csvtowikidata)

ralfhauser commented 5 years ago

for OSM, see https://wiki.openstreetmap.org/wiki/Switzerland/Fountains

ralfhauser commented 5 years ago

https://maproulette.org/admin/project/4913/challenge/9123

ralfhauser commented 5 years ago

Datenherr: reto.mueller@iwb.ch

ralfhauser commented 5 years ago

there does not seem to be a better file than https://opendata.swiss/dataset/bade-trinkwasser-und-zierbrunnen-in-basel (please use this as "reference" for the imported values)

ralfhauser commented 5 years ago

seems to be like (in the non-open world) https://www.google.com/maps/d/viewer?mid=14An4F58DfTw5IJYF9YK-VLtQ3Jk&ll=47.55971904592851%2C7.595102841769403&z=14

ralfhauser commented 5 years ago

While images out of KML are difficult, you can get them there (example "Faule Magd Brunnen" ) https://doc-0s-24-mymaps.googleusercontent.com/untrusted/hostedimage/f6u64nodcabo26320jjaagdfpc/emc2tle2rs5l5s8ghifmp2f5r0/1572372900000/GMyYZQtQrNc-i61GkAqfGleE4oRA2oA6/*/2AF2TALpo6PuzxnkwXHfkqOQ6p5wrEqSCRhpIPd-TKvMoJ7GwKV0xLM_XkGNXx2B1NpanhTbkTA9Ih6daqQx1G3ATtLLf9Y7OFmkhyTXWVa26qblph7soUVk0OgEdTF7k7tdNRY4QlM-lyx_X5rH0eRVdCmtDyWtp7w9vTQrgqggZal7vw4m-ZmEmZfOVplVhcxFevGU-qkKZvoQjLEg3V0K17p1H121wXUn_05VxgmpD5v62ZqhvMHGqpy4vftylyWuK_eyXHIo6J5fePANW8WOG1JP_TmfBDg?fife=s16383

also this link is no longer usable on the next day :(

ralfhauser commented 5 years ago

https://doc-0c-24-mymaps.googleusercontent.com/untrusted/hostedimage/f6u64nodcabo26320jjaagdfpc/g0v926cau5cbsste5fluabjdhc/1568029500000/GMyYZQtQrNc-i61GkAqfGleE4oRA2oA6/*/2AF2TALr-xoeMvAh71s7YRQ6MPKid4UXaAO05Xk5u4qBHUl2WTigqrIrj0RbyPPhGbHRGvMwc-k_g3ysenm83W5vAAGj-0E4z7tzu4uXvqpGv6rPs8iqtHGwzGfDU5zZPGE_l2VoP9NtGIwGSFW2TCvxMqyQmtXU10NGg-1w1DfiwbRjdfZQP3eavImcZyF1duVt6VwUKYWOoYUCyG-pPXWeFTQpa11t52LSD0HDmvFiKYLhJxY0-wuXU5SnyYVC9t5j4RJsqVfT3ikvaW9lru1Va0My21b4c6w?fife

height="200" width="auto" />

St. Johanns-Vorstadt (Foto Christian Lienhard, Basel)"

==> the KML conversion didn't work for the images :(

ralfhauser commented 5 years ago

see also https://github.com/opendatabs/csvtowikidata

ralfhauser commented 5 years ago

now Basel publishes their file also themselves: https://data.bs.ch/explore/dataset/100008/

ralfhauser commented 5 years ago

Jonas' raw data https://photos.app.goo.gl/Dt8hky2gqQozjdEJ9

ralfhauser commented 5 years ago

TODO write to photographer Christian Lienhard (http://www.spalentor-verlag.ch/informationen/das-team/index.php) whether he would donate his pertinent images to the fountains/wikimedia

ralfhauser commented 4 years ago

The corresponding fountain hunt was on Nov 9, 2019 https://twitter.com/OpenDataZurich/status/1190247899113885696?s=20 https://my-d.org/h2o.do/20191109_Basel_Water-Fountain_Hunt_Twitter.pdf