Data formats: Difference between revisions

From GRASS-Wiki
Jump to navigation Jump to search
(→‎RDBMS: +ms access tips)
Line 40: Line 40:
=== RDBMS ===
=== RDBMS ===


* [[Tips for working with ODBC]] RDBMSs
==== ODBC ====
* Tips for working with [[ODBC]] RDBMSs
** {{cmd|grass-odbc}} help page
** {{cmd|grass-odbc}} help page
: http://gdal.osgeo.org/ogr/drv_odbc.html
: http://gdal.osgeo.org/ogr/drv_odbc.html


* [[Tips for working with MySQL]]
==== MySQL ====
* Tips for working with [[MySQL]]
** {{cmd|grass-mysql}} help page
** {{cmd|grass-mysql}} help page
** {{cmd|grass-mesql}} help page
** {{cmd|grass-mesql}} help page
Line 51: Line 53:
: http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html
: http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html


* Tips for working with PostgreSQL/[[PostGIS]]
==== PostgreSQL and PostGIS ====
* Tips for working with [[PostgreSQL]]/[[PostGIS]]
** {{cmd|grass-pg}} help page
** {{cmd|grass-pg}} help page
** {{cmd|v.external}} help page
** {{cmd|v.external}} help page
Line 57: Line 60:
: http://gdal.osgeo.org/ogr/drv_pg.html
: http://gdal.osgeo.org/ogr/drv_pg.html


* [[Tips for working with Oracle Spatial]]
==== Oracle ====
* Tips for working with [[Oracle Spatial]]
** {{cmd|grass-odbc}} help page
** {{cmd|grass-odbc}} help page
: http://gdal.osgeo.org/ogr/drv_oci.html
: http://gdal.osgeo.org/ogr/drv_oci.html


* [[Tips for working with SQLite/SpatiaLite]]
==== SQLite and SpatiaLite ====
* Tips for working with [[SQLite]]/[[SpatiaLite]]
** {{cmd|grass-sqlite}} help page
** {{cmd|grass-sqlite}} help page
: http://gdal.osgeo.org/ogr/drv_sqlite.html
: http://gdal.osgeo.org/ogr/drv_sqlite.html
: http://www.gaia-gis.it/spatialite/
: http://www.gaia-gis.it/spatialite/
: http://lists.osgeo.org/pipermail/aust-nz/2008-April/000454.html
: http://lists.osgeo.org/pipermail/aust-nz/2008-April/000454.html
==== MicroSoft Access ====
Three possible ways to import .mdb:
* via unixODBC driver (see above)
* via [http://www.r-project.org/ R-statistics]
R
install.packages('Hmisc', dependencies=TRUE)
library(Hmisc)
* via [http://code.google.com/p/mdb-sqlite/ mdb-sqlite] - automated conversion of MS Access 2000 databases
to SQLite on any platform


== Satellite data ==
== Satellite data ==

Revision as of 08:17, 17 August 2009

Please help expand this page! <- what is the scope of this page? You name it!

General formats

Supported raster formats with r.in.gdal and r.out.gdal:

gdalinfo --formats

Supported vector formats with v.in.ogr and v.out.ogr

ogrinfo --formats


GIS formats

v.in.ogr or ogr2ogr to make a shapefile first?
See GRASS-News article: M. Neteler, 2005. SRTM and VMAP0 data in OGR and GRASS. GRASS Newsletter, Vol.3, pp 2-6, June 2005. PDF and erratum
for Electronic Nautical Charts (ENCs)
for Rasterized Nautical Charts (RNCs)

Databases and SQL

RDBMS

ODBC

http://gdal.osgeo.org/ogr/drv_odbc.html

MySQL

http://gdal.osgeo.org/ogr/drv_mysql.html
http://dev.mysql.com/doc/refman/4.1/en/spatial-extensions.html
http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html

PostgreSQL and PostGIS

http://gdal.osgeo.org/ogr/drv_pg.html

Oracle

http://gdal.osgeo.org/ogr/drv_oci.html

SQLite and SpatiaLite

http://gdal.osgeo.org/ogr/drv_sqlite.html
http://www.gaia-gis.it/spatialite/
http://lists.osgeo.org/pipermail/aust-nz/2008-April/000454.html

MicroSoft Access

Three possible ways to import .mdb:

  • via unixODBC driver (see above)
R
install.packages('Hmisc', dependencies=TRUE)
library(Hmisc)
  • via mdb-sqlite - automated conversion of MS Access 2000 databases

to SQLite on any platform

Satellite data

Global datasets

(see the Global datasets page)

GRASS's data formats

  • TODO: link to those here
For now see the Development pages


Some hints can be found on these pages: