ThomasG77’s gists

ThomasG77 / list_postgresql_instance_tables.sh

Created March 26, 2023 14:20

List schema and tables from all databases in PostgreSQL cluster

	psql -t --csv -d postgres -c "WITH get_database_names AS (
	SELECT d.datname as dbname
	FROM pg_catalog.pg_database d
	WHERE d.datname <> 'template0'
	ORDER BY 1
	)
	SELECT * FROM get_database_names;" >\| databases.txt

	echo "schemaname,tablename,dbname" >\| all_tables.txt
	for i in $(cat databases.txt);

ThomasG77 / demo-stream-gzipped-json-files.js

Created March 22, 2023 14:20

	const zlib = require('zlib');
	const unzip = zlib.createUnzip();
	const fs = require('fs');
	var geojsonStream = require('geojson-stream');

	function mergeFeatureCollectionStream (inputs) {

	var out = geojsonStream.stringify();
	inputs.map(async (file) => {
	fs.createReadStream(file)

ThomasG77 / App.java

Created February 10, 2023 14:11

Java certificate issues recipe + basic java demo

	package com.demo.HttpClientDemo;

	// Package Jar issue de https://github.com/stleary/JSON-java
	import org.json.JSONArray;
	import org.json.JSONObject;

	import java.net.URI;
	import java.net.http.HttpClient; // < New in Java 11, can also handle HTTP/2 requests!
	import java.net.http.HttpRequest;
	import java.net.http.HttpResponse;

ThomasG77 / App.java

Created February 8, 2023 17:56

Java basic http client API Geo (Java 11+)

	package com.demo.HttpClientDemo;

	// Package Jar issue de https://github.com/stleary/JSON-java
	import org.json.JSONArray;
	import org.json.JSONObject;

	import java.net.URI;
	import java.net.http.HttpClient; // < New in Java 11, can also handle HTTP/2 requests!
	import java.net.http.HttpRequest;
	import java.net.http.HttpResponse;

ThomasG77 / index.html

Last active January 9, 2023 13:40

WMS Leaflet

	<html>
	<head>
	<title>Leaflet WMS</title>
	<meta charset="utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/leaflet.css" integrity="sha256-kLaT2GOSpHechhsozzB+flnD+zUyjE2LlfWPgU04xyI=" crossorigin="" />
	<script src="https://unpkg.com/[email protected]/dist/leaflet.js" integrity="sha256-WBkoXOwTeyKclOHuWtc+i2uENFpDZ9YPdf5Hf+D7ewM=" crossorigin=""></script>
	<script src="https://unpkg.com/[email protected]/dist/leaflet.wms.js"></script>

	<style>

ThomasG77 / index.html

Created January 9, 2023 13:37

WMS maplibre tiled


	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8" />
	<title>Add a WMS source untiled</title>
	<meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" />
	<meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" />
	<script src="https://unpkg.com/[email protected]/dist/maplibre-gl.js"></script>
	<script src="https://unpkg.com/@mapbox/[email protected]/sphericalmercator.js"></script>

ThomasG77 / index.html

Created January 9, 2023 13:36

WMS maplibre untiled


	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8" />
	<title>Add a WMS source untiled</title>
	<meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" />
	<meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" />
	<script src="https://unpkg.com/[email protected]/dist/maplibre-gl.js"></script>
	<script src="https://unpkg.com/@mapbox/[email protected]/sphericalmercator.js"></script>

ThomasG77 / index.html

Last active January 4, 2023 13:42

Leaflet WFS

	<!DOCTYPE html>
	<html>

	<head lang="en">
	<meta charset="UTF-8">
	<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/leaflet.css" integrity="sha256-kLaT2GOSpHechhsozzB+flnD+zUyjE2LlfWPgU04xyI=" crossorigin="" />
	<!-- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet.css" /> -->
	<title></title>
	<style>
	html,

ThomasG77 / gdal.log

Created December 2, 2022 23:20

	GNM: GNMRegisterAllInternal
	GNM: RegisterGNMFile
	GNM: RegisterGNMdatabase
	WFS: https://www.wfs.nrw.de/geobasis/wfs_nw_inspire-flurstuecke_alkis?SERVICE=WFS&REQUEST=GetCapabilities
	HTTP: Fetch(https://www.wfs.nrw.de/geobasis/wfs_nw_inspire-flurstuecke_alkis?SERVICE=WFS&REQUEST=GetCapabilities)
	WFS: No paging support
	WFS: No ImplementsStandardJoins support
	WFS: No transaction support
	GDAL: GDALOpen(WFS:https://www.wfs.nrw.de/geobasis/wfs_nw_inspire-flurstuecke_alkis, this=0x19342f0) succeeds as WFS.
	GDAL: QuietDelete(cadastral_parcel_filtered.gpkg) invoking Delete()

ThomasG77 / ressources_demo_data_gouv_fr.sh

Created November 28, 2022 15:33

Get datasets/ressources from demo.data.gouv.fr

	counter=0

	while : ; do
	counter=$((counter+1))
	curl -s -X GET "https://demo.data.gouv.fr/api/1/datasets/?page=${counter}&page_size=500" >\| "page_${counter}.json"
	if [[ $( cat "page_${counter}.json" \
	\| jq '.next_page') == 'null' ]] ; then
	break #Exit the loop
	fi
	done

Thomas Gratier ThomasG77