Creating geolocation heatmap from a list of IP addresses

Source IP set is proxies.txt.

Generate KML with geolocation coordinates using the tool geoiplookup from MaxMind (free db from MaxMind may be needed):

cat proxies.txt | \
  awk '{ cmd="/usr/bin/geoiplookup "$1" | tr '\''\n'\'' '\''|'\''"; 
         cmd | getline res; print $1"|"res; close(cmd) }' \
  > proxies_geo.csv

cat proxies_geo.csv | \
  awk -F\| 'BEGIN { print "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
                    print "<kml xmns=\"http://opengis.net/kml/2.2\">" }
                  { split($3, a, ","); gsub(/ /, "", a[7]); gsub(/ /, "", a[8]);
                    print "<Placemark><name>"$1" 1</name><Point><coordinates>"a[8]","a[7]"</coordinates></Point></Placemark>" }
            END { print "</kml>" }' \
  > data.kml

Create a folder for the "heatmap" application:

mkdir heatmap
cd heatmap

Use the "heatmap-earthquakes" example package for visualization by OpenLayers available here. Fetch the example files to the heatmap folder: main.js, index.html, package.json.

Apply the following modifications:

index.html: add type="module" attrib in the <script> tag for main.js
index.html: set height:800px
main.js: replace url with url: 'data.kml'
main.js: replace layer: 'toner' with layer: 'toner-lite' (I prefer this)

In the folder heatmap install dependencies with yarn:

yarn

Copy created KML file with the geolocation data to the dist folder:

cp ../data.kml heatmap/dist

Build and start the web application in the folder heatmap:

yarn start

Now the heatmap should be available in your local browser at the URL http://localhost:1234.

tothi/ip_to_geo_map.md

Creating geolocation heatmap from a list of IP addresses