NAME

v.in.db - Create new vector (points) from database table containing coordinates.

SYNOPSIS

v.in.db
v.in.db help
v.in.db driver=string database=string table=string x=string y=string [z=string] key=string output=string

Parameters:

driver=string
Input driver name
Options: dbf,shp,odbc,pg,ogr
database=string
Input database name
table=string
Input table name
x=string
x column name
y=string
y column name
z=string
z column name
key=string
key column name
output=string
Name of vector output file

DESCRIPTION

v.in.db creates new vector (points) map from database table containing coordinates.

EXAMPLE

1) Creating a map from PostgreSQL table:
 v.in.db driver=pg database="host=myserver.itc.it,dbname=mydb,user=name" \
         table=pat_stazioni x=east y=north z=quota  key=id output=pat_stazioni

2) Creating a map from PostGIS: To extract coordinate values from PostGIS, functions have to be used:

 v.in.db driver=pg database="host=myserver.itc.it,dbname=mydb,user=name" \
         table=station x="x(geom)" y="y(geom)" z="z(geom)" key=id out=meteostations

3) Import of a points table (x, y, z) from DBF file to vector points map:

The DBF file has to be copied into $MAPSET/dbf/ (to be created if not existing yet). Then the DBMI needs to be connected to this directory:


db.connect driver=dbf database='$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/'

#if no ID column present in the DBF file, the 'shp' driver can be used
#instead of the 'dbf' driver to generate the virtual ID/key column 'shp_fid'
#on-the-fly:

v.in.db driver=shp database='$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/' \
  table=pointsfile x=x y=y z=z key=shp_fid out=dtm
v.info dtm

AUTHOR

Radim Blazek

Last changed: $Date: 2004/05/19 13:58:43 $


Help Index