Places and their names — observations from 11 million place names

SELECT * FROM geonames WHERE name ILIKE ‘%bad%’

What is GeoNames and what is it good for?

I visualized geographical data on a graph and not a map. Mind-blowing.

Rājekumāravenkataperumālrāzumbahadūrvāripeta and other place I’d like to visit

  • Taumatawhakatangihangakoauauotamateapokaiwhenuakitanatahu
  • Rājekumāravenkataperumālrāzumbahadūrvāripeta
  • Hangukhwangyeongjeongchaekpyeonggayeonguwon
  • Jainnonghyeopjeontongjangnyugagonggongjang
  • Hangukdambaeinsamgonsasuwonjejochangsawon

Time for some name mapping!

I reeeally like those weird zebra patterns
The search of the ultimate Danish place name
North-West is clearly a place for creeks and coasts are places for rocks.
So this didn’t quite work out I imagined.
Bad. Very bad.
SELECT avg(length(name)), country, count(name) 
FROM geonames
WHERE name NOT LIKE '% %' AND featcode ='PPL'
GROUP BY country
ORDER BY avg asc
Northern France is the ville hotspot!
Yo dawg I heard you like Washington!




I mostly put lines, points and polygons on maps 🌍

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

K Means Algorithm With Real Life Problem

How Data Science Can Help Improving Gaming Environment (Part 1)

Window into the living expectations of being a Data scientist

A Gentle introduction to Exploratory Data Analysis!

Market Update: 02 Sep 2021

Determining Bull & Bear Market Trends Programmatically (Python)

Find thy hyper-parameters for scikit-learn pipelines using Microsoft NNI

4 Key Factors for Open Data Publication — From a User Standpoint

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Topi Tjukanov

Topi Tjukanov

I mostly put lines, points and polygons on maps 🌍

More from Medium

Keep it secret: 3 tips to protect your ArcGIS passwords

Line Chart experiment and learning

How to make a social vulnerability web map — part 2

#30DayMapChallenge 2021 by Kontur Team