Jean-Louis Stanus jlstanus

## create_gpkg_table.sql
CREATE TABLE 'new_alert_zone_layer' (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  geometry MULTIPOLYGON NOT NULL,
  LayerNameFr TEXT DEFAULT 'New Layer',
  LayerNameNl TEXT DEFAULT 'New Layer',
  NameNl TEXT NOT NULL,
  NameFr TEXT NOT NULL,
  Category TEXT NOT NULL DEFAULT 'INFO',
  Buffer INTEGER NOT NULL DEFAULT 0,
  'From' TEXT NOT NULL,

## cabanes_hautes_vosges.geojson

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              0 stars
            
          
                jlstanus
                / cabanes_hautes_vosges.geojson
            
            
              Created
              November 26, 2019 07:53
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## Setup_a_proxy.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jlstanus
                / Setup_a_proxy.md
            
            
              Last active
              December 11, 2019 11:43
            
              
                Setup a proxy with let's encrypt. Source: https://github.com/oSoc19/best/blob/master/pelias/README.md
              
          
    Proxy Server

Why?

FR
Set up a proxy

In this step we will setup an apache proxy server:
Our server is an ubuntu server (18.04.2).

  
## agenda.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jlstanus
                / agenda.md
            
            
              Last active
              May 1, 2020 15:16
            
              
                Incubhacker - Demo FreeCAD
              
          
    Incubhacker: Demo FreeCAD

Introduction


FreeCAD est basé sur le framework Open CASCADE Technology
Il existe d'autres solutions:

OpenSCAD
SolveSpace
..etc..


Documentation Fr --> Yorik Vanhavre a étudié à Saint-Luc. Il est le principal développeur de l'atelier Architecture et a fourni très tot une documentation francophone


## QGIS Virtual Layer makeline.sql
# Create a line to show the distance between points
# http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html
# 'select EnableGpkgAmphibiousMode()' to enable sql query on geopackage

select
	cNewg.address,
	MakeLine(cNewg.geometry, cOldg.geometry) as geometry
from
(select Newg.rue_txt || Newg.numero as address, Newg.geometry
 from Newg

## BlenderGIS How-to
# BlenderGIS

## Requirements

* Download [Blender](https://www.blender.org/download/)
* Download [Blender GIS](https://github.com/domlysz/BlenderGIS)
* Install Blender GIS from *Edit > Preferences > Addon > Install*
* Install Node addon too

## Normal Process (easy)

## QGIS 3D & caves.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jlstanus
                / QGIS 3D & caves.md
            
            
              Last active
              May 19, 2020 18:46
            
          
    Prerequis


QGIS 3
Hillshades

DEM Copernicus EPSG:3035 (ETRS89, LAEA)


## geopackage_triggers.sql
-- Classic triggers for geopackages DB files
-- 1. Creation date
CREATE TRIGGER "trigger_add_creation_date" AFTER INSERT
ON "table_name"
BEGIN
	UPDATE table_name SET attribute = datetime('now') WHERE fid = NEW.fid;
END

-- 2. Update date
CREATE TRIGGER "trigger_update_date" AFTER UPDATE

## system_backup.sh
#!/bin/bash
#
# Automate Raspberry Pi Backups
# Inspired from https://raw.githubusercontent.com/kallsbo/BASH-RaspberryPI-System-Backup/master/system_backup.sh
# Kristofer Källsbo 2017 www.hackviking.com
#
# Usage: system_backup.sh {path} {days of retention}
#
# Below you can set the default values if no command line args are sent.
# The script will name the backup files {$HOSTNAME}.{YYYYmmdd}.img

## h-bridge_micropython.py
import time
from network import WLAN
from machine import Pin, PWM
from umqtt.simple import MQTTClient
from ubinascii import hexlify
import sys

CLIENT_ID = "smashing-sub"

MQTT_SERVER = "192.168.1.10"
	CREATE TABLE 'new_alert_zone_layer' (
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	geometry MULTIPOLYGON NOT NULL,
	LayerNameFr TEXT DEFAULT 'New Layer',
	LayerNameNl TEXT DEFAULT 'New Layer',
	NameNl TEXT NOT NULL,
	NameFr TEXT NOT NULL,
	Category TEXT NOT NULL DEFAULT 'INFO',
	Buffer INTEGER NOT NULL DEFAULT 0,
	'From' TEXT NOT NULL,
	# Create a line to show the distance between points
	# http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html
	# 'select EnableGpkgAmphibiousMode()' to enable sql query on geopackage

	select
	cNewg.address,
	MakeLine(cNewg.geometry, cOldg.geometry) as geometry
	from
	(select Newg.rue_txt \|\| Newg.numero as address, Newg.geometry
	from Newg
	# BlenderGIS

	## Requirements

	* Download [Blender](https://www.blender.org/download/)
	* Download [Blender GIS](https://github.com/domlysz/BlenderGIS)
	* Install Blender GIS from Edit > Preferences > Addon > Install
	* Install Node addon too

	## Normal Process (easy)
	-- Classic triggers for geopackages DB files
	-- 1. Creation date
	CREATE TRIGGER "trigger_add_creation_date" AFTER INSERT
	ON "table_name"
	BEGIN
	UPDATE table_name SET attribute = datetime('now') WHERE fid = NEW.fid;
	END

	-- 2. Update date
	CREATE TRIGGER "trigger_update_date" AFTER UPDATE
	#!/bin/bash
	#
	# Automate Raspberry Pi Backups
	# Inspired from https://raw.githubusercontent.com/kallsbo/BASH-RaspberryPI-System-Backup/master/system_backup.sh
	# Kristofer Källsbo 2017 www.hackviking.com
	#
	# Usage: system_backup.sh {path} {days of retention}
	#
	# Below you can set the default values if no command line args are sent.
	# The script will name the backup files {$HOSTNAME}.{YYYYmmdd}.img
	import time
	from network import WLAN
	from machine import Pin, PWM
	from umqtt.simple import MQTTClient
	from ubinascii import hexlify
	import sys

	CLIENT_ID = "smashing-sub"

	MQTT_SERVER = "192.168.1.10"