Added by Cédric Briançon, last edited by Guilhem Legal on Sep 10, 2008  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.
Prerequistes

A PostgreSQL server 8.1 or above is needed. The PostGISextension must be installed on the server. An administration tools like pgAdmin on some client machine is recommended. The following script files are needed:

File Location
lwpostgis.sql
PostGIS installation directory
spatial_ref_sys.sql
PostGIS installation directory
structure Observations.sql Observation installation directory
step
  1. Create a new Database with the name you want.
  2. create an empty schema called postgis.
  3. Open lwpostgis.sql in a SQL editor and add the following line at the begining of the script: SET search_path = postgis, pg_catalog; Then run the script. The PostGIS tables and functions should be created in the "postgis" schema instead of the default "public" one.
  4. Open spatial_ref_sys.sql in a SQL editor and add the same line than at the previous step. Then run the script.
  5. execute the sql script structure Observations.sql.