Skip to content

Instantly share code, notes, and snippets.

View fgianoli's full-sized avatar

Federico fgianoli

20 followers · 36 following
View GitHub Profile
@fgianoli
fgianoli / boundary_distance.sql
Last active June 28, 2021 10:04
Codice utilizzato per il calcolo della distanza dei confini dalla rispettiva capitale
DROP TABLE IF EXISTS sahel.boundaries;CREATE TABLE sahel.boundaries AS
WITH
confini AS (SELECT isocode iso2,ST_TRANSFORM(geom,4326) geom FROM sahel.confini_lineari),
capitali AS (SELECT iso_a2 iso2,geom FROM sahel.capital_sahel),
d100 AS (SELECT iso2,100 dis,ST_BUFFER(geom::geography,100000)::geometry geom FROM capitali a),
d3 AS (SELECT iso2,ST_BUFFER(geom::geography,300000)::geometry geom,300 dis FROM capitali a),
d6 AS (SELECT iso2,ST_BUFFER(geom::geography,600000)::geometry geom,600 dis FROM capitali a),
d9 AS (SELECT iso2,ST_BUFFER(geom::geography,900000)::geometry geom,900 dis FROM capitali a),
d12 AS (SELECT iso2,ST_BUFFER(geom::geography,1200000)::geometry geom,1200 dis FROM capitali a),
d18 AS (SELECT iso2,ST_BUFFER(geom::geography,1800000)::geometry geom,1800 dis FROM capitali a),
@fgianoli
fgianoli / PostgreSQL_PostGIS.md
Last active December 11, 2020 14:06
@fgianoli
fgianoli / lizmap.md
Last active November 14, 2022 17:17
Installazione Lizmap

Installazione Lizmap

sudo su

install apache2

apt install apache2

ensure to have PHP installed and all required extensions:

@fgianoli
fgianoli / geoserver
Created October 15, 2020 14:02
------------------------------
INSTALL GEOSERVER UNDER TOMCAT 8
------------------------------
//Install JAVA 8 for Geoserver
apt install openjdk-8-jdk
//Install Tomcat8 https://www.digitalocean.com/community/tutorials/how-to-install-apache-tomcat-8-on-ubuntu-16-04
@fgianoli
fgianoli / copernicus_FG.py
Last active July 8, 2020 15:47
from qgis.core import QgsProcessing
from qgis.core import QgsProcessingAlgorithm
from qgis.core import QgsProcessingMultiStepFeedback
from qgis.core import QgsProcessingParameterRasterLayer
from qgis.core import QgsProcessingParameterRasterDestination
from qgis.core import QgsCoordinateReferenceSystem
import processing
class Copernicus(QgsProcessingAlgorithm):
@fgianoli
fgianoli / gdal_warp.py
Last active July 6, 2020 12:33
from processing.gui.wrappers import WidgetWrapper
from qgis.PyQt.QtWidgets import QDateEdit
from qgis.PyQt.QtCore import Qt, QCoreApplication, QDate
from qgis.core import QgsProcessing
from qgis.core import QgsProcessingAlgorithm
from qgis.core import QgsProcessingMultiStepFeedback
from qgis.core import QgsProcessingParameterFolderDestination
from qgis.core import QgsProcessingParameterFile
from qgis.core import QgsProcessingParameterRasterDestination, QgsProcessingParameterRasterLayer
@fgianoli
fgianoli / resample_rasterio.py
Created July 3, 2020 20:38
# coding: utf-8
import os
import rasterio
import rasterio.warp
import rasterio.features
from rasterio.enums import Resampling
from rasterio import Affine, MemoryFile
import time
@fgianoli
fgianoli / download_copernicus_translate.py
Last active July 6, 2020 12:35
from processing.gui.wrappers import WidgetWrapper
from qgis.PyQt.QtWidgets import QDateEdit
from qgis.PyQt.QtCore import Qt, QCoreApplication, QDate
from qgis.core import QgsProcessing
from qgis.core import QgsProcessingAlgorithm
from qgis.core import QgsProcessingMultiStepFeedback
from qgis.core import QgsProcessingParameterFolderDestination
from qgis.core import QgsProcessingParameterFile
from qgis.core import QgsProcessingParameterRasterDestination, QgsProcessingParameterRasterLayer
@fgianoli
fgianoli / GeoNode_Ieraci
Last active June 15, 2020 13:29
## Install dependencies
# Install packages from GeoNode core
sudo apt install -y gdal-bin
sudo apt install -y python3-pip python3-dev python3-virtualenv python3-venv virtualenvwrapper
sudo apt install -y libxml2 libxml2-dev gettext
sudo apt install -y libxslt1-dev libjpeg-dev libpng-dev libpq-dev libgdal-dev libgdal20
sudo apt install -y software-properties-common build-essential
sudo apt install -y git unzip gcc zlib1g-dev libgeos-dev libproj-dev
sudo apt install -y sqlite3 spatialite-bin libsqlite3-mod-spatialite
@fgianoli
fgianoli / WebGIS_Backend
Last active June 11, 2020 09:34
------------------------
CONFIGURE SERVER FOR GIS
------------------------
sudo su
apt update
apt upgrade
apt install apache2
------------------------------