tobwen

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" \

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

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

	# This code is under license CC0.

	import argparse
	import random
	import sys
	import time
	from typing import List, Tuple
	import datetime

	# Keyboard layout mapping for common typos (QWERTY layout)

	# hint: developed for and tested with ZTE ZTE MF79U (version BD_XCBZHKMF79UV1.0.0B03)

	import requests
	import hashlib
	import re
	import logging
	from typing import Dict, Any, Tuple

	logging.basicConfig(level=logging.DEBUG, format='%(asctime)s - %(levelname)s - %(message)s')
	logger = logging.getLogger(__name__)

	from qgis.core import QgsProject, QgsMapSettings, QgsRectangle, QgsMapRendererCustomPainterJob
	from qgis.PyQt.QtGui import QImage, QPainter
	from PyQt5.QtCore import QSize
	from pathlib import Path
	import time

	class MapExporter:
	def __init__(self, canvas):
	self.canvas = canvas
	self.project = QgsProject.instance()

	# commits to be built
	ARG CGAL55_GIT_COMMIT=tags/v5.6 # https://github.com/CGAL/cgal/tags
	ARG SFCGAL_GIT_COMMIT=tags/v1.5.0 # https://github.com/Oslandia/SFCGAL_CI/tags
	ARG PROJ_GIT_COMMIT=tags/9.3.0 # https://github.com/OSGeo/PROJ/tags
	ARG GEOS_GIT_COMMIT=tags/3.12.0 # https://github.com/libgeos/geos/tags
	ARG GDAL_GIT_COMMIT=tags/v3.7.3 # https://github.com/OSGeo/gdal/tags
	ARG POSTGIS_GIT_COMMIT=tags/3.4.0 # https://github.com/postgis/postgis/tags

	# base container with build-dependencies
	FROM docker://postgres:16-bookworm AS build-deps

	#!/usr/bin/env python3

	#######################################################################
	# This program is free software; you can redistribute it and/or #
	# modify it under the terms of the GNU General Public License as #
	# published by the Free Software Foundation; either version 2 of the #
	# License, or (at your option) any later version. #
	# #
	# This program is distributed in the hope that it will be useful, but #
	# WITHOUT ANY WARRANTY; without even the implied warranty of #

	<!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;