Flags:¶

-t

Use imported table as attribute table for new map

--overwrite

Allow output files to overwrite existing files

--help

Print usage summary

--verbose

Verbose module output

--quiet

Quiet module output

--ui

Force launching GUI dialog

Parameters:¶

table=name [required]

Input table name

driver=name

Name of database driver
Options: dbf, mysql, odbc, ogr, pg, sqlite
Default: sqlite

database=name

Name of database
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

x=name [required]

Name of column containing x coordinate

y=name [required]

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 < 1000 and inhab >= 10000

output=name [required]

Name for output vector map

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 present in the PostgreSQL table, a new column should be added. See PostgreSQL DB driver page for details.

Creating a map from PostGIS¶

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 present in the PostgreSQL table, a new column should be added. See PostgreSQL DB driver page for details.

Alternatively a vector point map can be imported from PostGIS database using v.in.ogr.

Creating a map from Open Document spreadsheet (ODS) file¶

# preview table structure with OGR tool:
ogrinfo -so meteodata.ods mysheet
# import from ODS into map
v.in.db key=ID table=mysheet x=long y=lat z=height output=meteodata \
         driver=ogr datatabase=meteodata.ods

Creating a map from MS Excel file¶

v.in.db table=List1 x=long y=lat z=height output=meteodata \
         driver=ogr datatabase=meteodata.xls

Creating a map from DBF table¶

v.in.db driver=dbf database=/home/user/tables/ table=pointsfile x=x y=y z=z \
        key=idcol out=dtmpoints

v.info dtmpoints
v.info -c dtmpoints

If DB driver for output vector map is different from SQLite driver and 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).

Creating a point map from DBF table for selected records only¶

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"

Creating a map from SQLite table¶

v.in.db driver=sqlite database=/home/user/tables/mysqlite.db table=pointsfile x=x y=y z=z \
        key=idcol out=dtmpoints