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;








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:



  1. rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)

  2. v.in.ogr in Grass GIS 7.6.1

  3. 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.










share|improve this question



















  • 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) 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











  • 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

















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:



  1. rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)

  2. v.in.ogr in Grass GIS 7.6.1

  3. 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.










share|improve this question



















  • 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) 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











  • 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













0












0








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:



  1. rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)

  2. v.in.ogr in Grass GIS 7.6.1

  3. 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.










share|improve this question
















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:



  1. rgdal::readOGR in R (most recent canonical version, GDAL version 2.2.3)

  2. v.in.ogr in Grass GIS 7.6.1

  3. 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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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 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











  • 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





    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











  • 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










1 Answer
1






active

oldest

votes


















0














In v2 of Q you can add it in as a File/System vector layer:



enter image description here



I would suspect you can do this in v3 too.






share|improve this answer























    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
    );



    );













    draft saved

    draft discarded


















    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









    0














    In v2 of Q you can add it in as a File/System vector layer:



    enter image description here



    I would suspect you can do this in v3 too.






    share|improve this answer



























      0














      In v2 of Q you can add it in as a File/System vector layer:



      enter image description here



      I would suspect you can do this in v3 too.






      share|improve this answer

























        0












        0








        0







        In v2 of Q you can add it in as a File/System vector layer:



        enter image description here



        I would suspect you can do this in v3 too.






        share|improve this answer













        In v2 of Q you can add it in as a File/System vector layer:



        enter image description here



        I would suspect you can do this in v3 too.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Apr 5 at 12:28









        artwork21artwork21

        31.1k555120




        31.1k555120



























            draft saved

            draft discarded
















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221

            Creating closest line along the point''s azimuth using PostgreSQL Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

            Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given