Anton Bakker arbakker

Geohash GeoPackage

Bash script to reorder feature tables of GeoPackage based on Geohash. Requires sqlite3 and libsqlite3-mod-spatialite version => 5.0.1. To run in Docker:

wget https://service.pdok.nl/cbs/vk100/atom/v1_0/downloads/cbs_vk100_2020.zip
mkdir -p data
unzip cbs_vk100_2020.zip -d data && rm cbs_vk100_2020.zip
docker build . -t "spl" 
docker run -v $(pwd)/data:/data spl /geohash-gpkg /data/cbs_vk100_2020.gpkg /data/cbs_vk100_2020-geohash.gpkg

README

Minimal lighttpd configuration example which proxies all HTTP traffic on localhost:80 to localhost:3333. To run in a Docker container execute:

sudo docker run --rm -t -v "$(pwd)/lighttpd.conf:/etc/lighttpd/lighttpd.conf" -p 80:80 sebp/lighttpd

README

First download and unzip CBS Postcode4 GeoPackage and then open with sqlite3:

wget https://service.pdok.nl/cbs/pc4/atom/v1_0/downloads/cbs_pc4_2020.gpkg.zip
unzip cbs_pc4_2020.gpkg.zip
sqlite3 cbs_pc4_2020.gpkg

	var myList = document.getElementById("tableTicketsList").getElementsByTagName("tr")
	var result = ""
	for (const item of myList) {
	var ticketNrEl = item.getElementsByClassName("ticket-number")[0]
	if (!ticketNrEl){
	continue
	}
	var ticketNr = ticketNrEl.innerText

	var ticketSubEl = item.getElementsByClassName("ticket-subject")[0]

	#!/usr/bin/env bash
	# author: https://github.com/arbakker
	# script requirements:
	# - curl
	# - xmlstarlet
	# - jq

	PROGRAM_NAME=$(basename "$0")
	URL=$1

	#!/usr/bin/env bash
	set -euo pipefail

	proces_record_b64() {
	# convert base64 encoded record to:
	# {"md_identifier":"XXX","service_url":"XXX"}
	# records that are not of type WMS or WMTS will be converted to null
	base64 --decode <<<"$1" \|
	jq -r '.md_record' \|
	base64 --decode \| # decodes the .md_record field which is also base64 encoded

	#!/usr/bin/env bash

	function gen_routes(){
	# shellcheck disable=SC1091
	if [ -z "$API_KEY" ]; then
	echo "ERROR: environmental variable API_KEY for openrouteservice is unset or empty"
	exit 1
	fi

	QUERY="select load_extension('mod_spatialite');SELECT ST_AsText(ST_Centroid(GeomFromGPB(locaties.geom))) as locatie_geom, ST_AsText(ST_Centroid(GeomFromGPB(klanten.geom))) as klanten_geom, klanten.postcode as klant_postcode, locaties.postcode as locatie_postcode FROM locaties, klanten;"

	#!/usr/bin/env bash

	test='[
	{"foo": "parrot"},
	{"foo": "fjords"}
	]'

	jq "[.[] \| select(.foo != \"parrot\")] + [.[] \| select(.foo == \"parrot\") + {bar: \"ex-parrot\"}]" <<< $test

	#!/usr/bin/env bash
	PROGRAM_NAME=$(basename "$0")

	function usage {
	echo "Medata CRUD CLI tool for CSW services (Catalogue Service for the Web)"
	echo ""
	echo "usage: $PROGRAM_NAME [options]"
	echo " - -o <operation>: allowed values: GET, DELETE, UPSERT"
	echo " - -f <md-file-path>: path to metadata file, required when OPERATION=upsert"
	echo " - -i <md-identifier>: metadata identifier, required when OPERATION=DELETE\|GET"

	#!/usr/bin/env bash
	PROGRAM_NAME=$(basename "$0")
	DATASET_OWNER="$1"
	PEM="$2"
	EXPIRY="$3"

	function usage {
	echo "Generate JWT token for use with PDOK delivery services"
	echo ""
	echo "usage: $PROGRAM_NAME <dataset-owner> <pem> <expiry>"