Per documentar la informació geogràfica referent als desplegaments de fibra òptica estic avaluant diferents línies.

Amb eines com openstreetmaps, googlemaps, openlayers, ... ara amb postgresql + postgis + client.

Install Postgres/PostGIS on Ubuntu

sudo apt-get install postgresql postgresql-client postgresql-contrib
sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
sudo apt-get install postgresql-8.4-postgis

sudo su postgres
export DB_NAME=dbname
export DB_PASSWORD=password
createdb postgistemplate
createlang plpgsql postgistemplate

# in Ubuntu 10.04
psql -d postgistemplate -f /usr/share/postgresql/8.4/contrib/postgis.sql
psql -d postgistemplate -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql
# in Ubuntu 10.10
psql -d postgistemplate -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
psql -d postgistemplate -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql

psql

CREATE ROLE gisgroup NOSUPERUSER NOINHERIT CREATEDB NOCREATEROLE;

CREATE ROLE gis LOGIN PASSWORD '${DB_PASSWORD}' NOINHERIT;
GRANT gisgroup TO gis;
\q

psql -d postgistemplate

ALTER TABLE geometry_columns OWNER TO gis;
ALTER TABLE spatial_ref_sys OWNER TO gis;
CREATE SCHEMA gis_schema AUTHORIZATION gis;
\q

createdb -T postgistemplate -O gis ${DB_NAME}

exit # from user postgres

Algun Clients GIS

Quantum GIS
gvSIG