Andrea Borruso / Oct 10 2019
Remix of Python by Nextjournal

dataNotebook

pip install --user --upgrade goodtables geopandas xq beautifulsoup4 altair vega_datasets csvkit chardet ipython-sql daff pyexcel-cli csvs-to-sqlite requests-html emoji goodtables
apt update
apt install nodejs
apt install npm gdal-bin jq xmlstarlet tidy
npm install -g mapshaper
wget https://github.com/johnkerl/miller/releases/download/v5.6.2/mlr.linux.x86_64
mv mlr.linux.x86_64 mlr
mv mlr /bin
chmod +x /bin/mlr

1. Spatialite

apt-get install sqlite3
apt-get install -y python3-dev build-essential wget libxml2-dev libproj-dev libgeos-dev libsqlite3-dev zlib1g-dev pkg-config && sudo apt clean
apt-get install automake
apt-get install autoconf
apt-get install autotools-dev
git clone https://git.osgeo.org/gitea/rttopo/librttopo.git
cd librttopo
./autogen.sh
./configure
make
make check
make install
wget "https://www.gaia-gis.it/gaia-sins/freexl-1.0.5.tar.gz" && tar zxf freexl-1.0.5.tar.gz \
    && cd freexl-1.0.5 && ./configure && make 
make install
cd ..
wget http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-5.0.0-beta0.tar.gz
tar zxf libspatialite-5.0.0-beta0.tar.gz
cd libspatialite-5.0.0-beta0
./configure --enable-rttopo=yes --enable-gcp=yes
make -j8
make install-strip
/sbin/ldconfig -v
ls