Homepage > Man Pages > Category > General Commands
Homepage > Man Pages > Name > V

v.in.db

man page of v.in.db

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

NAME
v.in.db - Creates new vector (points) map from database table containing coordinates.
KEYWORDS
vector, import, database, points

SYNOPSIS

v.in.db v.in.db help v.in.db table=name [driver=name] [database=name] x=name y=name [z=name] key=name [where=sql_query] output=name [--overwrite] [--verbose] [--quiet] Flags: --overwrite Allow output files to overwrite existing files --verbose Verbose module output --quiet Quiet module output Parameters: table=name Input table name driver=name Driver name Options: dbf,odbc,pg,mysql,sqlite,ogr Default: dbf database=name Database name Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ x=name Name of column containing x coordinate y=name Name of column containing y coordinate z=name Name of column containing z coordinate key=name Name of column containing category number Must refer to an integer column where=sql_query WHERE conditions of SQL statement without 'where' keyword Example: income = 10000 output=name Name for output vector map

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" \ table=pat_stazioni x=east y=north z=quota key=id output=pat_stazioni If an ID column is not not present in the PostgreSQL table, a new column should be added. See pg driver page for detail. 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" \ table=station x="x(geom)" y="y(geom)" z="z(geom)" key=id out=meteostations If an ID column is not not present in the PostgreSQL table, a new column should be added. See pg driver page for detail. 3) Import of a points table (x, y, z) from DBF file to vector points map: #create vector map from DBF table (here, 'idcol' contains unique row IDs, 'z' is optional): #the 'database' parameter is the directory where the DBF file is stored: v.in.db driver=dbf database=/home/user/tables/ table=pointsfile x=x y=y z=z \ key=idcol out=dtmpoints #check result: v.info dtmpoints v.info -c dtmpoints If an ID column is missing in the DBF file, it has to be added beforehand, e.g. with OpenOffice. Alternatively, import the table with db.in.ogr into GRASS and then with v.in.db from the imported table (db.in.ogr optionally adds an unique ID column). 4) Import of a points table (x, y, z) from SQLite file to vector points map: #create vector map from table in SQLITE database file (here, 'idcol' contains unique row IDs, 'z' is optional): #the 'database' parameter is the the SQLite database file with path: v.in.db driver=sqlite database=/home/user/tables/mysqlite.db table=pointsfile x=x y=y z=z \ key=idcol out=dtmpoints #check result: v.info dtmpoints v.info -c dtmpoints If an ID column is missing in the table, it has to be added beforehand with 'sqlite3' or db.execute. 5) Import of a points table (x, y, z) from DBF file to vector points map for selected points only: The user can import only selected vector points from a table using the where parameter (see above for general DBF handling): v.in.db driver=dbf database=/home/user/tables/ table=pointsfile x=x y=y z=z \ key=idcol out=dtmpoints where="x NOT NULL and z > 100"

SEE ALSO

db.execute, db.in.ogr, v.info, v.in.ogr, v.to.db, SQL support in GRASS GIS
AUTHOR
Radim Blazek Last changed: $Date: 2007-12-30 12:51:27 +0100 (Sun, 30 Dec 2007) $ Full index (C) 2003-2010 GRASS Development Team V.IN.DB(1)
 
 
 

Copyright © 2011–2018 by topics-of-interest.com . All rights reserved. Hosted by all-inkl.
Contact · Imprint · Privacy

Page generated in 25.38ms.

Ich brauche eine Hundeversicherung | amazing-wings.de | information-information.de