sudo su
install apache2
apt install apache2
ensure to have PHP installed and all required extensions:
Federico fgianoli
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
| ------------------------------ | |
| 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
/ PostgreSQL_PostGIS.md
Last active
December 11, 2020 14:06
https://www.vultr.com/docs/install-the-postgis-extension-for-postgresql-on-ubuntu-linux
Install Postgres 12
sudo apt -y install postgresql-12 postgresql-client-12
fgianoli
/ boundary_distance.sql
Last active
June 28, 2021 10:04
Codice utilizzato per il calcolo della distanza dei confini dalla rispettiva capitale
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
| 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), |
OlderNewer