db.in.ogr(1grass) | GRASS GIS User's Manual | db.in.ogr(1grass) |
db.in.ogr - Imports attribute tables in various formats.
database, import, attribute table
db.in.ogr
db.in.ogr --help
db.in.ogr input=name [gdal_config=string]
[gdal_doo=string] [db_table=name]
[output=name] [key=string]
[encoding=string] [--overwrite] [--help]
[--verbose] [--quiet] [--ui]
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.
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 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
db.in.ogr input=/path/to/sqlite.db db_table=census_raleigh output=census_raleigh
# 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
To force reading headers, define environmental variable
OGR_XLS_HEADERS=’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
db.select, v.in.ogr, v.in.db
GRASS SQL interface
Markus Neteler
Available at: db.in.ogr source code (history)
Accessed: Monday Apr 01 03:09:28 2024
Main index | Database index | Topics index | Keywords index | Graphical index | Full index
© 2003-2024 GRASS Development Team, GRASS GIS 8.3.2 Reference Manual
GRASS 8.3.2 |