3 comments

  • RyanShook3 hours ago
    This was great, thank you for sharing.<p>The dataset claims there are significantly more Citibank locations than McDonalds worldwide which I don’t think can be correct?<p>It also lists over 56,000 Wildberries worldwide but a quick Google search shows they are a large online retailer. I wonder what is going on with the brand POIs…
    • marklit2 hours ago
      Glad you enjoyed it.<p>There should be enough SQL in the blog to re-purpose extracting out the Wildberries locations and seeing where they land on top of. I&#x27;ve never heard of this firm before you mentioned it.<p>From Google:<p>&gt; Citibank operates over 2,300 ATMs within more than 600 U.S. branches, with a total network of over 65,000 fee-free ATMs<p>So the 57,163 Citibank locations are probably a combination of their branches and ATMs.<p>Update: I reviewed Alltheplaces a while back, they scrape company websites for store locations. They reported 68,227 locations for Wildberries. ATP is one of the sources Overture use but they seem to use 1.55M of the records from their 19M-record dataset. <a href="https:&#x2F;&#x2F;tech.marksblogg.com&#x2F;alltheplaces.html" rel="nofollow">https:&#x2F;&#x2F;tech.marksblogg.com&#x2F;alltheplaces.html</a>
    • yorwba2 hours ago
      A quick overpass-turbo search for &quot;brand:wikidata=Q24933714 in Moscow&quot; <a href="https:&#x2F;&#x2F;overpass-turbo.eu&#x2F;s&#x2F;2kaO" rel="nofollow">https:&#x2F;&#x2F;overpass-turbo.eu&#x2F;s&#x2F;2kaO</a> (Q24933714 being Wildberries <a href="https:&#x2F;&#x2F;www.wikidata.org&#x2F;wiki&#x2F;Q24933714" rel="nofollow">https:&#x2F;&#x2F;www.wikidata.org&#x2F;wiki&#x2F;Q24933714</a> ) reveals that almost all locations are tagged shop=outpost <a href="https:&#x2F;&#x2F;wiki.openstreetmap.org&#x2F;wiki&#x2F;Tag:shop%3Doutpost" rel="nofollow">https:&#x2F;&#x2F;wiki.openstreetmap.org&#x2F;wiki&#x2F;Tag:shop%3Doutpost</a> which identifies them as pick-up locations for goods ordered online. I assume the dataset in the post has mostly the same locations.
  • marcinignac2 hours ago
    I really enjoy the exploration but I really wonder why people still use Mercator for data viz? Eg Greenland is not the size of Africa...
    • marklit1 hour ago
      I can&#x27;t get the vector basemap to render in QGIS properly with any other projection. I love using EPSG:3301 for Europe, etc.. but loads of strange things happen. Even 4326 is an issue.
  • realitylabs4 hours ago
    Thank you! This was a good intro to using duckdb for me with easily relatable content and cool maps.