[HN Gopher] 72M Points of Interest
       ___________________________________________________________________
        
       72M Points of Interest
        
       Author : marklit
       Score  : 42 points
       Date   : 2026-02-02 16:40 UTC (5 days ago)
        
 (HTM) web link (tech.marksblogg.com)
 (TXT) w3m dump (tech.marksblogg.com)
        
       | realitylabs wrote:
       | Thank you! This was a good intro to using duckdb for me with
       | easily relatable content and cool maps.
        
       | RyanShook wrote:
       | This was great, thank you for sharing.
       | 
       | The dataset claims there are significantly more Citibank
       | locations than McDonalds worldwide which I don't think can be
       | correct?
       | 
       | 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...
        
         | marklit wrote:
         | Glad you enjoyed it.
         | 
         | 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've never heard of this firm before you mentioned it.
         | 
         | From Google:
         | 
         | > Citibank operates over 2,300 ATMs within more than 600 U.S.
         | branches, with a total network of over 65,000 fee-free ATMs
         | 
         | So the 57,163 Citibank locations are probably a combination of
         | their branches and ATMs.
         | 
         | 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.
         | https://tech.marksblogg.com/alltheplaces.html
        
         | yorwba wrote:
         | A quick overpass-turbo search for "brand:wikidata=Q24933714 in
         | Moscow" https://overpass-turbo.eu/s/2kaO (Q24933714 being
         | Wildberries https://www.wikidata.org/wiki/Q24933714 ) reveals
         | that almost all locations are tagged shop=outpost
         | https://wiki.openstreetmap.org/wiki/Tag:shop%3Doutpost which
         | identifies them as pick-up locations for goods ordered online.
         | I assume the dataset in the post has mostly the same locations.
        
       | marcinignac wrote:
       | 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...
        
         | marklit wrote:
         | I can'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.
        
       ___________________________________________________________________
       (page generated 2026-02-07 23:00 UTC)