Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
db.in.ogr(1)		    GRASS GIS User's Manual		  db.in.ogr(1)

NAME
       db.in.ogr  - Imports attribute tables in	various	formats.

KEYWORDS
       database, import, attribute table

SYNOPSIS
       db.in.ogr
       db.in.ogr --help
       db.in.ogr  input=name   [db_table=name]	  [output=name]	  [key=string]
       [encoding=string]    [--overwrite]   [--help]   [--verbose]   [--quiet]
       [--ui]

   Flags:
       --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:
       input=nameA [required]
	   Table file to be imported or	DB connection string

       db_table=name
	   Name	of table from given DB to be imported

       output=name
	   Name	for output table

       key=string
	   Name	for auto-generated unique key column

       encoding=string
	   Encoding value for attribute	data

DESCRIPTION
       db.in.ogr  imports  attribute tables in various formats as supported by
       the OGR library on the local  system  (DBF,  CSV,  PostgreSQL,  SQLite,
       MySQL, ODBC, etc.). Optionally a	unique key (ID)	column can be added to
       the table.

EXAMPLES
   Import CSV file
       Limited type recognition	can be done for	Integer, Real,	String,	 Date,
       Time  and DateTime columns through a descriptive	file with same name as
       the CSV file, but .csvt extension (see details here).
       # NOTE: create koeppen_gridcode.csvt first for automated	type recognition
       db.in.ogr input=koeppen_gridcode.csv output=koeppen_gridcode
       db.select table=koeppen_gridcode

   Import DBF table
       Import of a DBF table with additional unique key	column	(e.g.,	needed
       for v.in.db).
       db.in.ogr input=/path/to/mydata.dbf output=census_raleigh key=myid
       db.describe -c census_raleigh

   Import of a SQLite table
       db.in.ogr input=/path/to/sqlite.db db_table=census_raleigh output=census_raleigh

   Import of a PostgreSQL table
       # HINT: if the database contains	spatial	tables,	but you	want to	import a non-spatial
       table, set the environmental variable PG_LIST_ALL_TABLES	to YES before importing
       db.in.ogr input="PG:host=localhost dbname=ecad user=neteler" \
		 db_table=ecad_verona_tmean output=ecad_verona_tmean
       db.select table=ecad_verona_tmean
       db.describe -c ecad_verona_tmean

   Import XLS file
       To  force  reading headers, define environmental	variable OGR_XLS_HEAD-
       ERS='FORCE'. Parameter db_table refers to the list within XLS file.
       export OGR_XLS_HEADERS='FORCE'
       db.in.ogr input=address.xls db_table=address_data

SEE ALSO
	db.select, v.in.ogr, v.in.db

       GRASS SQL interface

AUTHOR
       Markus Neteler

SOURCE CODE
       Available at: db.in.ogr source code (history)

       Main index | Database index | Topics index | Keywords index | Graphical
       index | Full index

       A(C) 2003-2020 GRASS Development	Team, GRASS GIS	7.8.3 Reference	Manual

GRASS 7.8.3							  db.in.ogr(1)

NAME | KEYWORDS | SYNOPSIS | DESCRIPTION | EXAMPLES | SEE ALSO | AUTHOR | SOURCE CODE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=db.in.ogr&sektion=1&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help