Opening Esri Geodatabase file with GDAL/QGIS/Grass? The 2019 Stack Overflow Developer Survey Results Are InMapServer ESRI personal geodabase.mdbHow to open File Geodatabase in QGIS (Ubuntu)?Microsoft Access mdb “is not a valid or recognized data source” in QGISOpening Esri Personal Geodatabase (*.mdb) using QGIS?Opening table from file geodatabase in ArcPy?QGIS OpenFileGDB compatibility with File Geodatabase?Reading Esri File Geodatabase (FileGDB) with OGR?Querying Esri File Geodatabase?Opening file geodatabase in pythongdal and openFileGDB driver - polygons with bezier curves not exporting correctlyOpening Esri Personal Geodatabase (*.mdb) using QGIS
Why not take a picture of a closer black hole?
How come people say “Would of”?
Why doesn't mkfifo with a mode of 1755 grant read permissions and sticky bit to the user?
Why is ParallelDo slower than Do?
What do I do when my TA workload is more than expected?
! Package inputenc Error: Unicode character (U+2061) (inputenc) not set up for use with LaTeX
Straighten subgroup lattice
Can withdrawing asylum be illegal?
For what reasons would an animal species NOT cross a *horizontal* land bridge?
What to expect from an e-bike service?
Can there be female White Walkers?
Is bread bad for ducks?
APIPA and LAN Broadcast Domain
How to check whether the reindex working or not in Magento?
How to notate time signature switching consistently every measure
Deal with toxic manager when you can't quit
How to deal with speedster characters?
Worn-tile Scrabble
Is it possible for absolutely everyone to attain enlightenment?
"as much details as you can remember"
Why didn't the Event Horizon Telescope team mention Sagittarius A*?
What is the grammatical structure of "Il est de formation classique"?
What is the motivation for a law requiring 2 parties to consent for recording a conversation
Keeping a retro style to sci-fi spaceships?
Opening Esri Geodatabase file with GDAL/QGIS/Grass?
The 2019 Stack Overflow Developer Survey Results Are InMapServer ESRI personal geodabase.mdbHow to open File Geodatabase in QGIS (Ubuntu)?Microsoft Access mdb “is not a valid or recognized data source” in QGISOpening Esri Personal Geodatabase (*.mdb) using QGIS?Opening table from file geodatabase in ArcPy?QGIS OpenFileGDB compatibility with File Geodatabase?Reading Esri File Geodatabase (FileGDB) with OGR?Querying Esri File Geodatabase?Opening file geodatabase in pythongdal and openFileGDB driver - polygons with bezier curves not exporting correctlyOpening Esri Personal Geodatabase (*.mdb) using QGIS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
EDIT: I have a 64-bit installation of QGIS but 32-bit Microsoft Office Access drivers. It has been suggested that this is the cause of the problem, which is also indicated in this post:
https://www.sigterritoires.fr/index.php/en/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0/
I tried installing 64-bit drivers but installer says I have to uninstall Office to do this. If anyone knows a workaround or could verify that the file opens in QGIS with 64-bit drivers that would be great.
ORIGINAL POST
I am trying to import the Oceania dataset of the Global Drainage Basin Database into GIS:
http://www.cger.nies.go.jp/db/gdbd/gdbd_index_e.html
I have tried:
- rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)
- v.in.ogr in Grass GIS 7.6.1
- Data Source Manager in QGIS 3.6.1
All of these result in an error message: "Cannot open data source" / "ERROR: Unable to open data source [filename]" / "Invalid Data Source".
I have followed steps described in previous answers to questions about importing this file format to QGIS on StackExchange and haven't been able to find a solution. Any approach that lets me convert into a more universally accepted format would work.
Running Windows 10.
qgis r grass file-geodatabase
add a comment |
EDIT: I have a 64-bit installation of QGIS but 32-bit Microsoft Office Access drivers. It has been suggested that this is the cause of the problem, which is also indicated in this post:
https://www.sigterritoires.fr/index.php/en/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0/
I tried installing 64-bit drivers but installer says I have to uninstall Office to do this. If anyone knows a workaround or could verify that the file opens in QGIS with 64-bit drivers that would be great.
ORIGINAL POST
I am trying to import the Oceania dataset of the Global Drainage Basin Database into GIS:
http://www.cger.nies.go.jp/db/gdbd/gdbd_index_e.html
I have tried:
- rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)
- v.in.ogr in Grass GIS 7.6.1
- Data Source Manager in QGIS 3.6.1
All of these result in an error message: "Cannot open data source" / "ERROR: Unable to open data source [filename]" / "Invalid Data Source".
I have followed steps described in previous answers to questions about importing this file format to QGIS on StackExchange and haven't been able to find a solution. Any approach that lets me convert into a more universally accepted format would work.
Running Windows 10.
qgis r grass file-geodatabase
1
There are two strong possibilities: 1) It's corrupt 2) It's a 9.x FGDB, unreadable by the FGDB API
– Vince
Apr 5 at 12:59
On the download page readsThe file is in ArcGIS Geodatabase (Version 9) formatand ogrinfo printsUnable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=oceania.mdbfor me.
– user30184
Apr 5 at 13:17
Are you running 64bit qgis and do you have the 64bit odbc drivers installed gis.stackexchange.com/a/138445/2856
– user2856
Apr 6 at 8:03
Others have been able to open the files; not corrupt.
– user5730487
Apr 7 at 8:08
It seems I'm unable to install 64-bit ODBC drivers for Microsoft Access (.mdb) because my employer-provided Microsoft Office version is 32-bit Office 2010. (Or well unable to install without uninstalling Office.) I'll try asking someone with 64-bit drivers to open and save to a less barbaric format, thanks for help.
– user5730487
Apr 7 at 8:11
add a comment |
EDIT: I have a 64-bit installation of QGIS but 32-bit Microsoft Office Access drivers. It has been suggested that this is the cause of the problem, which is also indicated in this post:
https://www.sigterritoires.fr/index.php/en/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0/
I tried installing 64-bit drivers but installer says I have to uninstall Office to do this. If anyone knows a workaround or could verify that the file opens in QGIS with 64-bit drivers that would be great.
ORIGINAL POST
I am trying to import the Oceania dataset of the Global Drainage Basin Database into GIS:
http://www.cger.nies.go.jp/db/gdbd/gdbd_index_e.html
I have tried:
- rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)
- v.in.ogr in Grass GIS 7.6.1
- Data Source Manager in QGIS 3.6.1
All of these result in an error message: "Cannot open data source" / "ERROR: Unable to open data source [filename]" / "Invalid Data Source".
I have followed steps described in previous answers to questions about importing this file format to QGIS on StackExchange and haven't been able to find a solution. Any approach that lets me convert into a more universally accepted format would work.
Running Windows 10.
qgis r grass file-geodatabase
EDIT: I have a 64-bit installation of QGIS but 32-bit Microsoft Office Access drivers. It has been suggested that this is the cause of the problem, which is also indicated in this post:
https://www.sigterritoires.fr/index.php/en/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0/
I tried installing 64-bit drivers but installer says I have to uninstall Office to do this. If anyone knows a workaround or could verify that the file opens in QGIS with 64-bit drivers that would be great.
ORIGINAL POST
I am trying to import the Oceania dataset of the Global Drainage Basin Database into GIS:
http://www.cger.nies.go.jp/db/gdbd/gdbd_index_e.html
I have tried:
- rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)
- v.in.ogr in Grass GIS 7.6.1
- Data Source Manager in QGIS 3.6.1
All of these result in an error message: "Cannot open data source" / "ERROR: Unable to open data source [filename]" / "Invalid Data Source".
I have followed steps described in previous answers to questions about importing this file format to QGIS on StackExchange and haven't been able to find a solution. Any approach that lets me convert into a more universally accepted format would work.
Running Windows 10.
qgis r grass file-geodatabase
qgis r grass file-geodatabase
edited Apr 7 at 8:15
user5730487
asked Apr 5 at 12:08
user5730487user5730487
112
112
1
There are two strong possibilities: 1) It's corrupt 2) It's a 9.x FGDB, unreadable by the FGDB API
– Vince
Apr 5 at 12:59
On the download page readsThe file is in ArcGIS Geodatabase (Version 9) formatand ogrinfo printsUnable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=oceania.mdbfor me.
– user30184
Apr 5 at 13:17
Are you running 64bit qgis and do you have the 64bit odbc drivers installed gis.stackexchange.com/a/138445/2856
– user2856
Apr 6 at 8:03
Others have been able to open the files; not corrupt.
– user5730487
Apr 7 at 8:08
It seems I'm unable to install 64-bit ODBC drivers for Microsoft Access (.mdb) because my employer-provided Microsoft Office version is 32-bit Office 2010. (Or well unable to install without uninstalling Office.) I'll try asking someone with 64-bit drivers to open and save to a less barbaric format, thanks for help.
– user5730487
Apr 7 at 8:11
add a comment |
1
There are two strong possibilities: 1) It's corrupt 2) It's a 9.x FGDB, unreadable by the FGDB API
– Vince
Apr 5 at 12:59
On the download page readsThe file is in ArcGIS Geodatabase (Version 9) formatand ogrinfo printsUnable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=oceania.mdbfor me.
– user30184
Apr 5 at 13:17
Are you running 64bit qgis and do you have the 64bit odbc drivers installed gis.stackexchange.com/a/138445/2856
– user2856
Apr 6 at 8:03
Others have been able to open the files; not corrupt.
– user5730487
Apr 7 at 8:08
It seems I'm unable to install 64-bit ODBC drivers for Microsoft Access (.mdb) because my employer-provided Microsoft Office version is 32-bit Office 2010. (Or well unable to install without uninstalling Office.) I'll try asking someone with 64-bit drivers to open and save to a less barbaric format, thanks for help.
– user5730487
Apr 7 at 8:11
1
1
There are two strong possibilities: 1) It's corrupt 2) It's a 9.x FGDB, unreadable by the FGDB API
– Vince
Apr 5 at 12:59
There are two strong possibilities: 1) It's corrupt 2) It's a 9.x FGDB, unreadable by the FGDB API
– Vince
Apr 5 at 12:59
On the download page reads
The file is in ArcGIS Geodatabase (Version 9) format and ogrinfo prints Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=oceania.mdb for me.– user30184
Apr 5 at 13:17
On the download page reads
The file is in ArcGIS Geodatabase (Version 9) format and ogrinfo prints Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=oceania.mdb for me.– user30184
Apr 5 at 13:17
Are you running 64bit qgis and do you have the 64bit odbc drivers installed gis.stackexchange.com/a/138445/2856
– user2856
Apr 6 at 8:03
Are you running 64bit qgis and do you have the 64bit odbc drivers installed gis.stackexchange.com/a/138445/2856
– user2856
Apr 6 at 8:03
Others have been able to open the files; not corrupt.
– user5730487
Apr 7 at 8:08
Others have been able to open the files; not corrupt.
– user5730487
Apr 7 at 8:08
It seems I'm unable to install 64-bit ODBC drivers for Microsoft Access (.mdb) because my employer-provided Microsoft Office version is 32-bit Office 2010. (Or well unable to install without uninstalling Office.) I'll try asking someone with 64-bit drivers to open and save to a less barbaric format, thanks for help.
– user5730487
Apr 7 at 8:11
It seems I'm unable to install 64-bit ODBC drivers for Microsoft Access (.mdb) because my employer-provided Microsoft Office version is 32-bit Office 2010. (Or well unable to install without uninstalling Office.) I'll try asking someone with 64-bit drivers to open and save to a less barbaric format, thanks for help.
– user5730487
Apr 7 at 8:11
add a comment |
1 Answer
1
active
oldest
votes
In v2 of Q you can add it in as a File/System vector layer:

I would suspect you can do this in v3 too.
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317895%2fopening-esri-geodatabase-file-with-gdal-qgis-grass%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In v2 of Q you can add it in as a File/System vector layer:

I would suspect you can do this in v3 too.
add a comment |
In v2 of Q you can add it in as a File/System vector layer:

I would suspect you can do this in v3 too.
add a comment |
In v2 of Q you can add it in as a File/System vector layer:

I would suspect you can do this in v3 too.
In v2 of Q you can add it in as a File/System vector layer:

I would suspect you can do this in v3 too.
answered Apr 5 at 12:28
artwork21artwork21
31.1k555120
31.1k555120
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317895%2fopening-esri-geodatabase-file-with-gdal-qgis-grass%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
There are two strong possibilities: 1) It's corrupt 2) It's a 9.x FGDB, unreadable by the FGDB API
– Vince
Apr 5 at 12:59
On the download page reads
The file is in ArcGIS Geodatabase (Version 9) formatand ogrinfo printsUnable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=oceania.mdbfor me.– user30184
Apr 5 at 13:17
Are you running 64bit qgis and do you have the 64bit odbc drivers installed gis.stackexchange.com/a/138445/2856
– user2856
Apr 6 at 8:03
Others have been able to open the files; not corrupt.
– user5730487
Apr 7 at 8:08
It seems I'm unable to install 64-bit ODBC drivers for Microsoft Access (.mdb) because my employer-provided Microsoft Office version is 32-bit Office 2010. (Or well unable to install without uninstalling Office.) I'll try asking someone with 64-bit drivers to open and save to a less barbaric format, thanks for help.
– user5730487
Apr 7 at 8:11