[GRASS-user] Importing ESRI Personal Geodatabase

Hi there,

I'd be grateful if someone could advise on the quickest way to import ESRI
Personal Geodatabase into GRASS.

A couple of questions:

1. Is it possible to directly import the mdb into GRASS after installing the
mdb driver?

2. I've been using ogr2ogr (ogr2ogr --version GDAL 1.7.1, released
2010/02/08) to convert the mdb to shapefiles (which I subsequently plan to
import into GRASS) but the geometry is not being created in the shapefile.

Eg.

ogr2ogr -f "ESRI Shapefile" -a_srs EPSG:4326 test_BWA_adm_ogr.shp
PGeo:sample_pgeo
ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'.
ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'.
ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'.
Warning 6: Normalized/laundered field name: 'NAME_ENGLISH' to 'NAME_ENGLI'
Warning 6: Normalized/laundered field name: 'NAME_OBSOLETE' to 'NAME_OBSOL'
Warning 6: Normalized/laundered field name: 'NAME_VARIANTS' to 'NAME_VARIA'
Warning 6: Normalized/laundered field name: 'NAME_NONLATIN' to 'NAME_NONLA'
Warning 6: Normalized/laundered field name: 'NAME_FRENCH' to 'NAME_FRENC'
Warning 6: Normalized/laundered field name: 'NAME_SPANISH' to 'NAME_SPANI'
Warning 6: Normalized/laundered field name: 'NAME_RUSSIAN' to 'NAME_RUSSI'
Warning 6: Normalized/laundered field name: 'NAME_ARABIC' to 'NAME_ARABI'
Warning 6: Normalized/laundered field name: 'NAME_CHINESE' to 'NAME_CHINE'
Warning 6: Normalized/laundered field name: 'Shape_Length' to 'Shape_Leng'
Warning 6: Normalized/laundered field name: 'Shape_Length' to 'Shape_Leng'
Warning 6: Normalized/laundered field name: 'Shape_Length' to 'Shape_Leng'

I'm running GRASS 6.4.0 RC7 on OpenSuse 11.3

Thanks.
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Importing-ESRI-Personal-Geodatabase-tp5737128p5737128.html
Sent from the Grass - Users mailing list archive at Nabble.com.

On Sun, Nov 14, 2010 at 10:09 AM, RichTC <richtcooper@hotmail.com> wrote:

Hi there,

I'd be grateful if someone could advise on the quickest way to import ESRI
Personal Geodatabase into GRASS.

A couple of questions:

1. Is it possible to directly import the mdb into GRASS after installing the
mdb driver?

"More or less" - AFAIK you need to register it as ODBC source then.
http://grass.osgeo.org/grass64/manuals/html64_user/grass-odbc.html

2. I've been using ogr2ogr (ogr2ogr --version GDAL 1.7.1, released
2010/02/08) to convert the mdb to shapefiles (which I subsequently plan to
import into GRASS) but the geometry is not being created in the shapefile.

Eg.

ogr2ogr -f "ESRI Shapefile" -a_srs EPSG:4326 test_BWA_adm_ogr.shp
PGeo:sample_pgeo
ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'.
ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'.
ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'.
Warning 6: Normalized/laundered field name: 'NAME_ENGLISH' to 'NAME_ENGLI'

...

All I know is this...
http://www.gdal.org/ogr/drv_pgeo.html

I'm running GRASS 6.4.0 RC7 on OpenSuse 11.3

(btw, consider to update to 6.4.0 final)

Markus