Re: [Qgis-user] ArcGis mdb file
One problem occured on 64bit-systems (OpenSuse). The path to the mdb-library is hardcoded in gdal. So an option is to use a 32bit-system only for converting. Ralf Suhr Am Mittwoch 18 Juni 2008 schrieb Nikos Alexandris: > On Wed, 2008-06-18 at 20:42 +0200, Agustin Lobo wrote: > > I've also followed directions in http://gdal.org/ogr/drv_pgeo.html > > and I'm able to list the layers > > of the mdb Personal GeoDatabase: > > > > [EMAIL PROTECTED]:/usr/bin$ ogrinfo PGeo:sample_pgeo > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > > INFO: Open of `PGeo:sample_pgeo' > >using driver `PGeo' successful. > > 1: rios_puntos > > 2: usos_puntos > > 3: territorio_puntos > > 4: gps_puntos_5 > > 5: gps_puntos_4 > > 6: gps_puntos_3 > > 7: gps_puntos_2 > > 8: gps_puntos_1 > > 9: rios_lineas > > 10: transectos_puntos > > 11: territorio_poligonos > > > > (I'm using Ubuntu hardy) > > > > But: > > 1. Do we have to manually modify the personal .odbc.ini file > > each time we have to access one of these mdb files? > > (I do agree this is rather for the gdal list, but also of interest here, > > I think) > > 2. Most important: I understand there is no current way to access these > > mdb Personal Geodatabase through QGIS itself, am I wrong? > > > > Thanks! > > > > Agus > > I too use Hardy. But I can't get the layers listed. Are there any > limitations with respect to the size of the mdb files or anything else? > Any other documentation? > > It would save a LOT of time get the mdb's converted into an "open" > database format (e.g. SQLite). > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
On Wed, 2008-06-18 at 21:42 +0200, Marco Pasetti wrote: > > It would save a LOT of time get the mdb's converted into an "open" > > database format (e.g. SQLite). > > I never used it, but it worth a look: http://mdbtools.sourceforge.net/ > > Marco Marco, thank you. This is what I currently use but the problem is that it's not possible to convert at one step an mdb to a csv file for instance. It takes to export each time one of the tables contained in the mdb (at least I didn't find another way to export the data). Nikos ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
It would save a LOT of time get the mdb's converted into an "open" database format (e.g. SQLite). I never used it, but it worth a look: http://mdbtools.sourceforge.net/ Marco ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
On Wed, 2008-06-18 at 20:42 +0200, Agustin Lobo wrote: > I've also followed directions in http://gdal.org/ogr/drv_pgeo.html > and I'm able to list the layers > of the mdb Personal GeoDatabase: > > [EMAIL PROTECTED]:/usr/bin$ ogrinfo PGeo:sample_pgeo > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. > INFO: Open of `PGeo:sample_pgeo' >using driver `PGeo' successful. > 1: rios_puntos > 2: usos_puntos > 3: territorio_puntos > 4: gps_puntos_5 > 5: gps_puntos_4 > 6: gps_puntos_3 > 7: gps_puntos_2 > 8: gps_puntos_1 > 9: rios_lineas > 10: transectos_puntos > 11: territorio_poligonos > > (I'm using Ubuntu hardy) > > But: > 1. Do we have to manually modify the personal .odbc.ini file > each time we have to access one of these mdb files? > (I do agree this is rather for the gdal list, but also of interest here, > I think) > 2. Most important: I understand there is no current way to access these > mdb Personal Geodatabase through QGIS itself, am I wrong? > > Thanks! > > Agus I too use Hardy. But I can't get the layers listed. Are there any limitations with respect to the size of the mdb files or anything else? Any other documentation? It would save a LOT of time get the mdb's converted into an "open" database format (e.g. SQLite). ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
I've also followed directions in http://gdal.org/ogr/drv_pgeo.html and I'm able to list the layers of the mdb Personal GeoDatabase: [EMAIL PROTECTED]:/usr/bin$ ogrinfo PGeo:sample_pgeo ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. ERROR 1: importFromWKT() failed on SRS 'PROJCS["WGS_'. INFO: Open of `PGeo:sample_pgeo' using driver `PGeo' successful. 1: rios_puntos 2: usos_puntos 3: territorio_puntos 4: gps_puntos_5 5: gps_puntos_4 6: gps_puntos_3 7: gps_puntos_2 8: gps_puntos_1 9: rios_lineas 10: transectos_puntos 11: territorio_poligonos (I'm using Ubuntu hardy) But: 1. Do we have to manually modify the personal .odbc.ini file each time we have to access one of these mdb files? (I do agree this is rather for the gdal list, but also of interest here, I think) 2. Most important: I understand there is no current way to access these mdb Personal Geodatabase through QGIS itself, am I wrong? Thanks! Agus [EMAIL PROTECTED] wrote: Message: 4 Date: Sun, 15 Jun 2008 04:41:48 +0200 From: Nikos Alexandris <[EMAIL PROTECTED]> Subject: Re: [Qgis-user] ArcGis mdb file To: William Kyngesburye <[EMAIL PROTECTED]> Cc: gdal-dev <[EMAIL PROTECTED]>, qgis-user , "John C.Tull" <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain Maybe all this should be posted in gdal (?... sorry for cross-posting). I followed the instructions and it works for me under Ubuntu 64bit ;-) Yet, I get some "strange" error and no layers reported ? ogrinfo PGeo:rlp_db1 GDB_GeomColumns is not a table in this database INFO: Open of `PGeo:rlp_db1' using driver `PGeo' successful. -- Dr. Agustin Lobo Institut de Ciencies de la Terra "Jaume Almera" (CSIC) LLuis Sole Sabaris s/n 08028 Barcelona Spain Tel. 34 934095410 Fax. 34 934110012 email: [EMAIL PROTECTED] http://www.ija.csic.es/gt/obster ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
On Sat, 2008-06-14 at 19:24 -0500, William Kyngesburye wrote: > On linux, it uses the mdbtools library, and accesses the MDB thru > ODBC. while it works on Linux, I've had trouble getting it to work on > OSX, and I'm STILL waiting for a bug fix on another ODBC Access > driver :( So really, only OSX is out of luck for now. > > On Jun 14, 2008, at 5:05 PM, John C. Tull wrote: > > > Although I am pretty certain that format requires Windows as an > > Access lib is used by gdal. So no joy on Linux or OS X without a > > virtual machine. > > > > Regards, > > John > > > > On Jun 14, 2008, at 5:29 AM, Jeff McKenna wrote: > > > >> GDAL does have read support for mdb files > >> (http://gdal.org/ogr/drv_pgeo.html)so > >> you should be able to use GDAL's ogr2ogr utility to convert your > >> mdb into a readable format for QGIS. > >> > >> --jeff Maybe all this should be posted in gdal (?... sorry for cross-posting). I followed the instructions and it works for me under Ubuntu 64bit ;-) Yet, I get some "strange" error and no layers reported ? ogrinfo PGeo:rlp_db1 GDB_GeomColumns is not a table in this database INFO: Open of `PGeo:rlp_db1' using driver `PGeo' successful. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
On linux, it uses the mdbtools library, and accesses the MDB thru ODBC. while it works on Linux, I've had trouble getting it to work on OSX, and I'm STILL waiting for a bug fix on another ODBC Access driver :( So really, only OSX is out of luck for now. On Jun 14, 2008, at 5:05 PM, John C. Tull wrote: Although I am pretty certain that format requires Windows as an Access lib is used by gdal. So no joy on Linux or OS X without a virtual machine. Regards, John On Jun 14, 2008, at 5:29 AM, Jeff McKenna wrote: GDAL does have read support for mdb files (http://gdal.org/ogr/drv_pgeo.html)so you should be able to use GDAL's ogr2ogr utility to convert your mdb into a readable format for QGIS. --jeff - William Kyngesburye http://www.kyngchaos.com/ All generalizations are dangerous, even this one. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
Although I am pretty certain that format requires Windows as an Access lib is used by gdal. So no joy on Linux or OS X without a virtual machine. Regards, John On Jun 14, 2008, at 5:29 AM, Jeff McKenna wrote: GDAL does have read support for mdb files (http://gdal.org/ogr/drv_pgeo.html)so you should be able to use GDAL's ogr2ogr utility to convert your mdb into a readable format for QGIS. --jeff --- Jeff McKenna FOSS4G Consulting and Training Services http://www.gatewaygeomatics.com/ On 14-Jun-08, at 7:37 AM, Nikos Alexandris wrote: On Sat, 2008-06-14 at 13:19 +0200, Agustin Lobo wrote: How? I do have MDB tools, but don't see how I can open the arcgis mdb file (which has geographic information) with QGIS. I can open the tables with MDBTools, but cannot open the mdb file as I do with a shp file in QGIS. Agus Ralf Suhr wrote: In general yes, but the geometry-column has a format, that I don't know to convert. For mbd-access http://mdbtools.sourceforge.net/ Ralf Suhr Am Samstag 14 Juni 2008 schrieb Agustin Lobo: Can arc gis mdb files be opened with qgis under linux (ubuntu)? Thanks Agus I am also interested in this. Till now I just open an .mdb file with gmdb2 0.6pre1 (a gnome mdb viever) and export as .csv From this point it is easy to import in openoffice.Calc or import in GRASS' data base and then play around with it (in GRASS or QGIS). Greets, Nikos ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
GDAL does have read support for mdb files (http://gdal.org/ogr/drv_pgeo.html)so you should be able to use GDAL's ogr2ogr utility to convert your mdb into a readable format for QGIS. --jeff --- Jeff McKenna FOSS4G Consulting and Training Services http://www.gatewaygeomatics.com/ On 14-Jun-08, at 7:37 AM, Nikos Alexandris wrote: On Sat, 2008-06-14 at 13:19 +0200, Agustin Lobo wrote: How? I do have MDB tools, but don't see how I can open the arcgis mdb file (which has geographic information) with QGIS. I can open the tables with MDBTools, but cannot open the mdb file as I do with a shp file in QGIS. Agus Ralf Suhr wrote: In general yes, but the geometry-column has a format, that I don't know to convert. For mbd-access http://mdbtools.sourceforge.net/ Ralf Suhr Am Samstag 14 Juni 2008 schrieb Agustin Lobo: Can arc gis mdb files be opened with qgis under linux (ubuntu)? Thanks Agus I am also interested in this. Till now I just open an .mdb file with gmdb2 0.6pre1 (a gnome mdb viever) and export as .csv From this point it is easy to import in openoffice.Calc or import in GRASS' data base and then play around with it (in GRASS or QGIS). Greets, Nikos ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
On Sat, 2008-06-14 at 13:19 +0200, Agustin Lobo wrote: > How? I do have MDB tools, but don't see how > I can open the arcgis mdb file (which has geographic information) > with QGIS. > I can open the tables with MDBTools, but cannot > open the mdb file as I do with a shp file in QGIS. > > Agus > > Ralf Suhr wrote: > > In general yes, but the geometry-column has a format, that I don't know to > > convert. > > For mbd-access http://mdbtools.sourceforge.net/ > > > > Ralf Suhr > > > > Am Samstag 14 Juni 2008 schrieb Agustin Lobo: > >> Can arc gis mdb files be opened with qgis > >> under linux (ubuntu)? > >> Thanks > >> Agus I am also interested in this. Till now I just open an .mdb file with gmdb2 0.6pre1 (a gnome mdb viever) and export as .csv >From this point it is easy to import in openoffice.Calc or import in GRASS' data base and then play around with it (in GRASS or QGIS). Greets, Nikos ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
In general yes, but the geometry-column has a format, that I don't know to convert. For mbd-access http://mdbtools.sourceforge.net/ Ralf Suhr Am Samstag 14 Juni 2008 schrieb Agustin Lobo: > Can arc gis mdb files be opened with qgis > under linux (ubuntu)? > Thanks > Agus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] ArcGis mdb file
How? I do have MDB tools, but don't see how I can open the arcgis mdb file (which has geographic information) with QGIS. I can open the tables with MDBTools, but cannot open the mdb file as I do with a shp file in QGIS. Agus Ralf Suhr wrote: In general yes, but the geometry-column has a format, that I don't know to convert. For mbd-access http://mdbtools.sourceforge.net/ Ralf Suhr Am Samstag 14 Juni 2008 schrieb Agustin Lobo: Can arc gis mdb files be opened with qgis under linux (ubuntu)? Thanks Agus -- Dr. Agustin Lobo Institut de Ciencies de la Terra "Jaume Almera" (CSIC) LLuis Sole Sabaris s/n 08028 Barcelona Spain Tel. 34 934095410 Fax. 34 934110012 email: [EMAIL PROTECTED] http://www.ija.csic.es/gt/obster ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] ArcGis mdb file
Can arc gis mdb files be opened with qgis under linux (ubuntu)? Thanks Agus -- Dr. Agustin Lobo Institut de Ciencies de la Terra "Jaume Almera" (CSIC) LLuis Sole Sabaris s/n 08028 Barcelona Spain Tel. 34 934095410 Fax. 34 934110012 email: [EMAIL PROTECTED] http://www.ija.csic.es/gt/obster ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user