tobwen

Variants to generate an INSPIRE-compliant grid in EPSG:3035 for Germany's federal state Northrhine-Westfalia in PostGIS

Get the polygons, which have been released under a zero license: https://www.opengeodata.nrw.de/produkte/geobasis/vkg/dvg/dvg1/dvg1_EPSG25832_Shape.zip

variant 1

execution time: 2203851,183 ms (36:43,851)
explain analyze: https://explain.depesz.com/s/5X2O

expand for SQL query

version

GDAL 3.4.1, released 2021/12/27

get source cache (mbtile)

curl -kJLOR "https://daten.gdz.bkg.bund.de/produkte/topplus_open/TopPlusOpen/aktuell/mercator/9.mbtile"
cp 9.mbtile 9.mbtiles

create extracts

WFS-Download

dl_wfs_1() {
    curl --insecure --location --remote-time --create-dirs --get \
    --url "$1" \
    --data "service=WFS" \
    --data "request=GetFeature" \
    --data "version=1.1.0" \
 --data "resultType=results" \

	# backport libfuse3 from Debian 10
	apt install -t stretch-backports equivs meson mk-build-deps
	mkdir "$HOME/build/libfuse3/" && cd "$HOME/build/libfuse3/"
	(
	dget -x http://deb.debian.org/debian/pool/main/f/fuse3/fuse3_3.4.1-1.dsc; \
	cd fuse3-3.4.1; \
	mk-build-deps --install --remove --tool "apt -o Debug::pkgProblemResolver=yes --no-install-recommends -t stretch-backports" --root-cmd "sudo"; \
	sudo dpkg --remove fuse3-build-deps; \
	dch --local ~bpo9+ --distribution stretch-backports "Rebuild for stretch-backports (local only)."; \
	DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -j4; \

	#!/usr/bin/env bash
	# for Debian 9: apt install -t stretch-backports uidmap [others will follow soon]

	export GOPATH="$HOME/go"
	export PATH="$PATH:$GOPATH"
	[ -d "$GOPATH" ] \|\| mkdir -p "$GOPATH"

	buildah_src="containers/buildah"
	catatonit_src="openSUSE/catatonit"
	cni_src="containernetworking/plugins"

	<!DOCTYPE html>
	<html>

	<head>
	<title>basemap.de Web Vektor - Leaflet Demo</title>
	<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/leaflet.css" />
	<style>
	body {
	margin: 0;
	padding: 0;