Scratchings for a latency article

Building

Requirements:

postgres
a database called latency
postgis extension installed in that database
Python 3
the packages in the requirements.txt
- the shapely wheel doesn't get on with libgeos on debian stable, so I had to use the following magic incantation: pip install shapely --no-binary shapely
Maxmind's "GeoLite2 City" database file, GeoLite2-City.mmdb
A few C libraries, the debian packages for which are:
- libgeos-dev
- libproj-dev

Then run:

make -j

If you just want to see what I did, best to read the makefile directly.

geocoded-cities.csv - my, hand corrected, geocoding of Wonder Network city names (except "Koto", "Malaysia", "Mexico" and "Monticello" - which I can't narrow down) to Geoname's geoid
partial-geocode.sql - query I used to extract data to create the above
get-connectedness.sql - query to get internet speeds vs speed of light

Name		Name	Last commit message	Last commit date
Latest commit History 21 Commits
calpaterson-logs-2020-09-30		calpaterson-logs-2020-09-30
.gitignore		.gitignore
Makefile		Makefile
README.md		README.md
accesslog2csv.py		accesslog2csv.py
cities_2_wkt.py		cities_2_wkt.py
draw_latency_maps.py		draw_latency_maps.py
geocoded-cities.csv		geocoded-cities.csv
get-connectedness.sql		get-connectedness.sql
get-hosts.sql		get-hosts.sql
get-user-latencies.sql		get-user-latencies.sql
get_latency_data.py		get_latency_data.py
host_latlngs.py		host_latlngs.py
load-accesslog.sql		load-accesslog.sql
load-cities.sql		load-cities.sql
load-geocoded-cities.sql		load-geocoded-cities.sql
load-geocoded-hosts.sql		load-geocoded-hosts.sql
load-latencies.sql		load-latencies.sql
partial-geocode.sql		partial-geocode.sql
requirements.txt		requirements.txt
schema.sql		schema.sql