[OSM-talk] Adding wikidata tags to the remaining objects with only wikipedia tag

Stefano sabas88 at gmail.com
Thu Sep 28 06:15:35 UTC 2017


On 28 Sep 2017 2:57 am, "Andy Townsend" <ajt1047 at gmail.com> wrote:


It depends - if you want to do a "quick search for something" then an
equivalent to overpass turbo might be an option, but in the real world what
you'd _actually_ want to do is a local database query.  Unfortunately that
side of things seems to be completely missing (or at least very
well-hidden) - wikidata seems to be quite immature in that respect.
Where's the "switch2osm" for wikidata?  Where's the "osm2pgsql" or
"osmosis"?  Sure I can download 20Gb of gzipped JSON from
https://dumps.wikimedia.org/wikidatawiki/entities/20170925/ and try and
write some sort of parser based on https://www.mediawiki.org/
wiki/Wikibase/DataModel/JSON , but this seems very much like going back to
banging the rocks together (and no, a third-party query interface that
depends on an external network connection such as
https://query.wikidata.org/ or anything else isn't a better option).


We used this library to process the dump and then we add the results in
pgsql

https://www.entropywins.wtf/blog/2015/11/08/wikidata-wikibase-json-dump-reader/

https://github.com/osmItalia/wikidata-geo-match

What would the requirement of a wikidata2pgsql be?


Regards,
Andy


Ciao,
Stefano



_______________________________________________
talk mailing list
talk at openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20170928/67c8f240/attachment.html>


More information about the talk mailing list