PostGIS
Drivers

Vectormap driver based on a Postgresql database with the PostGIS plugin. More...

Vectormap driver based on a Postgresql database with the PostGIS plugin.

Provides

- vectormap

Requires

- None

Configuration requests

- None

Configuration file options

- dbname (string)
  - Default: template1
  - The name of the Postgresql database to connect to.
- host (string)
  - Default: localhost
  - The name of the database host.
- user (string)
  - Default: postgres
  - The name of the database user.
- port (string)
  - Default: 5432
  - The port of the database.
- password (string)
  - Default: empty string
  - The password for the database user
- layers (string tuple)
  - Default: Field required
  - Names of the layers. The layers are named after the corresponding tables in the database.
    Example

        driver
        (
          name "postgis"
          provides ["vectormap:0"]
          dbname "gis"
          host "192.168.0.2"
          port "5432"
          user "postgres"
          password "secret"
          layers ["obstacles_geom" "markers_geom"]
        )

Creating a PostGIS Database
  The PostGIS extension and Postgres database come in a single package in Ubuntu called postgresql-8.1-postgis. PostGIS isn't supported by Postgres-8.2 at the time of writing. After the package has been installed the database should be running and a new user 'postgres' should have been added to the system.

After the database has been installed, you will need to install the PL/pgSQL language extension and load the PostGIS definitions.

- To do this switch to a postgres user (for example do a 'su - postgres').
- Create a database: createdb gis
- Add the PL/pgSQL language extension: createlang plpgsql gis
- Change to the directory holding lwpostgis.sql (For example '/usr/share/postgres-8.1-postgis/lwpostgis.sql')
- Load the PostGIS definitions: psql -d gis -f lwpostgis.sql
- Run psql command interpreter: psgl gis
- (Optionally) Add a user account:
  - CREATE ROLE username WITH LOGIN CREATEDB CREATEROLE;
- Create a table for your geometry data
  - CREATE TABLE obstacles_geom(id int4 PRIMARY KEY, name varchar(25));
- Let the PostGIS extension know about your data
  - SELECT AddGeometryColumn('public', 'obstacles_geom', 'geom', 423, 'LINESTRING', 2);
- Add column for attributes:
  - ALTER TABLE obstacles_geom ADD COLUMN attrib varchar(25);

Create one database table per one layer in the configuration file.

For more information see http://postgis.refractions.net/

Database schema
  /TODO: Add documentation

Author
  Ben Morelli

Last updated 12 September 2005 21:38:45