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" \
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 # |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html> | |
<head> | |
<title>basemap.de Web Vektor - Leaflet Demo</title> | |
<link rel="stylesheet" href="https://unpkg.com/leaflet@1.8.0/dist/leaflet.css" /> | |
<style> | |
body { | |
margin: 0; | |
padding: 0; |
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
- execution time: 2203851,183 ms (36:43,851)
- explain analyze: https://explain.depesz.com/s/5X2O
expand for SQL query
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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; \ |
NewerOlder