postgresql

PSQL command line

Below some commands line I used to manage spatial data:

Import shape to postgis

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

Procedure:

  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)