Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
ralfhauser opened this issue Sep 9, 2019 · 13 comments
Open

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

ralfhauser opened this issue Sep 9, 2019 · 13 comments

Comments

@ralfhauser
Copy link
Member

ralfhauser commented Sep 9, 2019 •
edited
Loading

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 water-fountains/proximap#257

It has images, but they are unfortunately on google, so please

  1. use P6500 allow to display images from other URLs than commons.wikimedia proximap#279
@ralfhauser
Copy link
Member Author

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

  1. set the "swimming place (Q17456505)"

20190909BrunnenInBasel.kml2csv.mygeodata.zip

([email protected] recommends to use https://github.com/opendatabs/csvtowikidata)

@ralfhauser
Copy link
Member Author

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

@ralfhauser
Copy link
Member Author

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

@ralfhauser ralfhauser mentioned this issue Sep 10, 2019
Open
@ralfhauser
Copy link
Member Author

ralfhauser commented Oct 4, 2019 •
edited
Loading

Datenherr: [email protected]

@ralfhauser
Copy link
Member Author

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
Copy link
Member Author

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
Copy link
Member Author

ralfhauser commented Oct 29, 2019 •
edited
Loading

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
Copy link
Member Author

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 pushed a commit that referenced this issue Oct 29, 2019
raw data from
d904571 
#12
@ralfhauser ralfhauser mentioned this issue Oct 30, 2019
Open
@ralfhauser
Copy link
Member Author

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

@ralfhauser
Copy link
Member Author

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

@ralfhauser
Copy link
Member Author

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

@ralfhauser
Copy link
Member Author

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
Copy link
Member Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ralfhauser