Categorie
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

Categorie
GIS tutorial WebGIS

LeafletJS: 4 minitutorial per arricchire il design della tua webapp o webmap

Content not available.
Please allow cookies by clicking Accept on the banner

Mini tutorial:
1) pin and popup base https://codepen.io/pjhooker/pen/ROrajv
2) pin base and popup mod1 https://codepen.io/pjhooker/pen/gyrLyN
3) pin base and popup mod2 (creativetim) https://codepen.io/pjhooker/pen/axNpmj
4) pin mod1 and popup mod2 (creativetim) https://codepen.io/pjhooker/pen/ZZWeRd

Approfondimenti:
– Creative TIM: https://demos.creative-tim.com/material-dashboard/examples/dashboard.html
– LeafletJS primo tutorial: https://leafletjs.com/examples/quick-start/
– A simple JSON store for your web or mobile app http://myjson.com
– GEOJSON.io http://geojson.io

Categorie
GIS tutorial

Creare una mappa custom con QGIS, evidenziando le aree verdi sulla basemap di Carto

QuickMapServices è un plugin molto utile che offre molte basemaps. Per creare una mappa “con stile” però bisogna approfondire di più questi strumenti. Infine con alcune operazioni sui vettori e l’utilizzo dell’Atlas, è possibile ottenere delle mappe per rilievi “ad hoc”

Content not available.
Please allow cookies by clicking Accept on the banner

https://overpass-turbo.eu/s/GIA

/*
This has been generated by the overpass-turbo wizard.
The original search was:
“park in milan”
*/
[out:json][timeout:25];
// fetch area “milan” to search in
{{geocodeArea:manhattan}}->.searchArea;
// gather results
(
// query part for: “park”
node["leisure"="park"](area.searchArea);
way["leisure"="park"](area.searchArea);
relation["leisure"="park"](area.searchArea);
);
// print results
out body;
>;
out skel qt;

Categorie
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

Categorie
GIS tutorial Ufficio tecnico digitale

Trovare le coordinate da un indirizzo con Excel Google Spreadsheet

Se vi capita di dovere ripetere tante volte la ricerca di punti tramite indirizzo, nella classica ricerca in Google Maps, questa è sicuramente una soluzione pronta all’uso.

Infatti con Spreadsheet, l’Excel di Google, c’è una funzionalità che torna sempre comodo: ImportXML.

Forse non è così immediato imparare i parametri che può ospitare questa funzione, ma prenderci confidenza è sicuramente un tassello importante nell’utilizzo di Spreadsheet.

Riferimenti:

  • https://developers.google.com/maps/documentation/geocoding/intro
  • https://gis.stackexchange.com/questions/102839/how-to-geocode-a-google-spreadsheet
  • http://www.digital-geography.com/geocoding-google-spreadsheets/#.U6fem5R_uSo
  • https://drive.google.com/drive/folders/1AaQH4M-LEvMaMsANYQ5xYrMbASsmG2T6?usp=sharing