PSQL command line

Below some commands line I used to manage spatial data:

Import shape to postgis

Resizing a VirtualBox 4.2 virtual Hard Disk

Here a little how to increase the dimension of  VBox machine Hard Disk (ubuntu guest and host):

1. on a terminal host execute this command:

      tips: for the size in megabyte go to Google  and type your desired size in gigabyte to be converted to megabyte. For example: 10 GB = MB –> the       result should be 10240.

(font: http://askubuntu.com/)

2. then I needed to physically expand the partition of the virtual disk. To do this I used the software “gparted” in the guest machine running a live CD version of my distro.

For further information take a look here

(font: http://trivialproof.blogspot.it/)

Create a desktop launcher on Linux mint

Here a little procedure to create a desktop launcher:

1. Install gnome-panel package using the following command from your terminal

Create new launcher:

2. open the terminal and run the following command

(font: http://www.ubuntugeek.com/)

Installing postgis 2.x as extension on Ubuntu 12.04 LTS

This is the procedure that I follow to implement postgis (vers.2.0) as extension:

  1. Installation of the  postgis 2.x packages  from the Ubuntu official repository;
  2. creation of a new fresh postgreSQL database “mydb” without any postgis function;
  3. creation  of the extension with pgAdminIII:

Postgis 2.0.0 installation from source

Here you are the procedure I follow to install postgis 2.0.0 from source:

  • compile and install  updating GEOS library  from source;
  • execute “ldconfig” command;
  • execute the command a posted here:

SO: Ubuntu 11.10

Installation and configuration of a geodatabase


  1. repository and software installation:

2. creation of the geodatabase template

4. Creation of the geodatabase and optionally his admin user:

SO: Ubuntu 12.04 LTS 64 bit
Fonts: (Nicolo Rigacci, Simon Tokumine)