72M Points of Interest (tech.marksblogg.com)

29 points by marklit 5 days ago

3 comments:

by RyanShook 24 minutes ago

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…

by marklit a minute ago

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.

by realitylabs an hour ago

Thank you! This was a good intro to using duckdb for me with easily relatable content and cool maps.

Data from: Hacker News, provided by Hacker News (unofficial) API