Categories
GIS tutorial

DB creation 🐘 PostGIS in cloud for QGIS in 10 minutes (DigitalOcean + Postgres)

Required for this tutorial:
– account DigitalOcean (REFERRAL LINK https://m.do.co/c/0b88c63ccdf0)
– PuTTY: a free SSH and Telnet client
– Windows 8 or higher
– pgAdmin4
– QGIS

Italian version: this link

Video tutorial

Procedura

– create droplet digitalocean 1GB 5€/mo
– connect with putty and change password
– (https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04)
– sudo apt update
– sudo apt install postgresql postgresql-contrib
– (https://black-tea.github.io/setup-notes/2017/03/12/Postgres-and-GeoServer-on-DigitalOcean-Ubuntu.html)
– (https://launchpad.net/ubuntu/bionic/+package/postgresql-10-postgis-2.4)
– sudo apt-get install postgresql-10-postgis-2.4
– (https://www.igismap.com/install-postgis-postgresql-ubuntu/)
– sudo -u postgres psql
postgres=# CREATE DATABASE mygeo;\connect mygeo;
postgres=# CREATE EXTENSION postgis SCHEMA public; (QGIS expects postGIS to be installed in Public schema)
(https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e)
postgres=# create user pjhooker with encrypted password ‘1jRM6EA0’;
postgres=# grant all privileges on database mygeo to pjhooker;
– putty tunnel
– create connection with pgadmi4
– create connection with qgis3.2
– import pg_cittametropolitane
– load in qgis pg_cittametropolitane

Categories
Map tutorial

Usage examples for all datasets listed in the Registry of Open Data on AWS

Registry of Open Data on AWS exists to help people discover and share datasets that are available via AWS resources. Learn more about sharing data on AWS. See all usage examples for datasets listed in this registry. See datasets from Facebook Data for Good, NOAA Big Data Project, and Space Telescope Science Institute.

Same example for geographical data:

Shared by Andrea Borruso

Categories
GIS tutorial

Creazione DB 🐘 PostGIS in cloud per QGIS in 10 minuti (DigitalOcean + Postgres)

Per info gistips WhatsApp 3487448152 email lima.cityplanner@gmail.com
Richiesto per il tutorial:
– account DigitalOcean (REFERRAL LINK https://m.do.co/c/0b88c63ccdf0)
– PuTTY: a free SSH and Telnet client
– Windows 8 or higher
– pgAdmin4
– QGIS

Versione in inglese: questo link

Procedura

– create droplet digitalocean 1GB 5€/mo
– connect with putty and change password
– (https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04)
– sudo apt update
– sudo apt install postgresql postgresql-contrib
– (https://black-tea.github.io/setup-notes/2017/03/12/Postgres-and-GeoServer-on-DigitalOcean-Ubuntu.html)
– (https://launchpad.net/ubuntu/bionic/+package/postgresql-10-postgis-2.4)
– sudo apt-get install postgresql-10-postgis-2.4
– (https://www.igismap.com/install-postgis-postgresql-ubuntu/)
– sudo -u postgres psql
postgres=# CREATE DATABASE mygeo;\connect mygeo;
postgres=# CREATE EXTENSION postgis SCHEMA public; (QGIS expects postGIS to be installed in Public schema)
(https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e)
postgres=# create user pjhooker with encrypted password ‘1jRM6EA0’;
postgres=# grant all privileges on database mygeo to pjhooker;
– putty tunnel
– create connection with pgadmi4
– create connection with qgis3.2
– import pg_cittametropolitane
– load in qgis pg_cittametropolitane