Data formats: Difference between revisions

From GRASS-Wiki
Jump to navigation Jump to search
(cleanup)
Line 76: Line 76:
Four possible ways to import .mdb:
Four possible ways to import .mdb:
* via unixODBC driver (see above)
* via unixODBC driver (see above)
 
* via [http://code.google.com/p/mdb-sqlite/ mdb-sqlite] - automated conversion of MS Access 2000 databases to SQLite on any platform
* via GDAL/OGR:
** [http://www.gdal.org/ogr/drv_mdb.html MDB driver] (GDAL/OGR >= 1.9.0 needed)
** [http://www.gdal.org/ogr/drv_geomedia.html Geomedia] GDAL driver
** old [http://www.gdal.org/ogr/drv_pgeo.html PGeo] driver
* via [http://www.r-project.org/ R-statistics]
* via [http://www.r-project.org/ R-statistics]
R
<source lang="bash">
install.packages('Hmisc', dependencies=TRUE)
R
library(Hmisc)
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
</source>
 
* via GDAL [http://www.gdal.org/ogr/drv_mdb.html MDB driver]
NOTE: GDAL/OGR >= 1.9.0 needed (probably need to be compiled/recompiled).
Also there are old [http://www.gdal.org/ogr/drv_pgeo.html PGeo] and more new [http://www.gdal.org/ogr/drv_geomedia.html Geomedia] GDAL drivers.


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

Revision as of 09:52, 14 September 2012

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

Four possible ways to import .mdb:

  • via unixODBC driver (see above)
  • via mdb-sqlite - automated conversion of MS Access 2000 databases to SQLite on any platform
  • via GDAL/OGR:
  • via R-statistics
R
install.packages('Hmisc', dependencies=TRUE)
library(Hmisc)

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: