Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I believe I know the answer, but I wanted to ask. Is there a way to create a Personal Geodatabase in QGIS? I know QGIS can view Personal Geodatabases, but can one be created? I have a project where the client is requiring a small spatial database (they are very low on the tech level, so I do not want to jump into PostGIS etc etc). They also only use ArcGIS. I would like to do the project in QGIS, hense my question.

Thanks in advance....

share|improve this question
add comment

2 Answers 2

up vote 10 down vote accepted

According to the GDAL docs:

OGR optionally supports reading ESRI Personal GeoDatabase .mdb files via ODBC. Personal GeoDatabase is a Microsoft Access database with a set of tables defined by ESRI for holding geodatabase metadata, and with geometry for features held in a BLOB column in a custom format (essentially Shapefile geometry fragments). This drivers accesses the personal geodatabase via ODBC but does not depend on any ESRI middle-ware.

Writing a personal geodatabase on the other hand, is another story. Access mdb is a proprietary file format and open source projects like QGIS tend to stay away from them. I did see an old open source project called MDB Tools which aims to

MDB Tools is an open source suite of libraries and utilities to read (and soon write) MDB database files.

I'm not sure how far along their goal that project is though. So no, I don't think you can create personal geodatabase files using QGIS as of now or any time soon.

As for your client's request, @Ragi has just finished writing an ArcGIS plugin that let's you use OGR sources, this includes Spatialite and PostGIS. That way you can use ArcGIS and PostGIS ( or Spatialite, whichever you prefer ). You might want to give it a try.

I hope that helps.

share|improve this answer
add comment

QGIS uses the OGR library for the majority of it's GIS format access. The Personal GDB access falls under this grouping.

Based on the OGR Vector Format's page here: OGR Vector Formats

The ESRI Personal GeoDatabase driver does not have Creation support.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.