Tag Info

Hot answers tagged

12

It can be viewed in Quantum GIS, a popular open source desktop gis application. Choose Layer > Add Vector Layer and select Personal Geodatabase from File Types. It will display all feature classes. But advanced ESRI features like Network and Topology will not be visible.


10

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


8

It is possible that there is something wrong with resolution and tolerance in PGDB. Take a look at sections X,y resolution and X,y tolerance in this topic. Try increasing these values. What coordinate system are you using? What values are set for resolution and tolerance?


8

It looks like there are a few things that can cause an Access database to grow excessively. Row Locking is discussed in this Stackexchange question: MS-Access database getting very large during inserts It looks like the suggested solution is to turn off Row-Locking in the database. This is something that is turned off on the Access database itself, not ...


6

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.


6

You are in for a world of hurt (but I know that part of the answer doesn't help). If you don't mind the reduced speed - put it on a network share where only a few users have write permissions to the file and the others only have read. From ESRI-L (in the comment below) Give all users full file permissions to the folder (allowing them to create, read and ...


6

To answer the first part of your question, I think it helps to look at the additional text in the Creating Attribute Indexes help file about Multi-column indexes. The order in which fields appear in a multicolumn index is important. In a multicolumn index with column A preceding column B, column A will be used to conduct the initial search. Also, ...


4

There are at least 9 top reasons to use File Geodatabase over Personal Geodatabase. Unfortunately, there are still a lot more reasons to keep the old PGDB around; your dilemma being one of them. (no ESRI publication on this topic) I believe the primary purpose of FGDB over PGDB is storage capacity and performance of spatial data (drawing speed, retrieval, ...


3

You can use the AccessWorkspaceFactory instead. There are (at least) 3 ways to connect to a personal geodatabase. The simplest is probably the IWorkspaceFactory.OpenFromFile method, e.g.: //For example, pathToFile= "C:\\myData\\mypGDB.mdb". static IWorkspace openFromFile_pGDB_Workspace(String pathToFile)throws Exception{ IWorkspaceFactory ...


3

I think the short answer is no. You would need an sde gdb to make the second replica. The esri distributed database model is fully and clearly documented. In the Esri pdf doc- The following describes each technique: „ Geodatabase replication: Geodatabase replication allows you to distribute data across two or more geodatabases such that edits can be ...


3

It looks like you may be having an issue with the resolution setting of your Feature Dataset. Since you are using a Feature Dataset, you need to set an appropriate XY Tolerance, as mentioned in step 7 of the article "Creating a feature dataset". By default the XY tolerance should be sufficient (and in the case of WGS84, the resolution units are degrees). ...


3

Esri's online help (see two links below as examples) discourages users from opening Personal Geodatabases stored in Microsoft Access using Access so I think your phrase "futile because pgdb technology is proprietary and no detailed publicly available knowledge exists" probably sums it up. http://support.esri.com/es/knowledgebase/techarticles/detail/31599 ...


3

As I understand it, you're saying your mdb has multiple tables (e.g., a table for "municipal water systems", a table for "sewer systems", etc), and you want to get the feature count for a specific table. If that's the case, you can just get the feature count of the specific table (dataset/layer/etc) name that you want to look at. if layer.GetName() == ...


3

It is a little difficult to understand your problem without hearing what your code outputs. I don't know if it is a cut and pase error or not, but I am guessing that you want to indent the last three lines of your code so that they get executed within the loop. import osgeo.ogr as ogr driver = ogr.GetDriverByName('PGeo') ds = driver.Open(database) ...


2

You didn't specify what version of ArcGIS you're using, but the Distributed Geodatabase toolbar should be available. This toolbar contains an Extract Data wizard, which should accomplish what you're trying to do. Try following these steps from the Esri help: Copying a geodatabase using Extract Data Wizard in ArcMap


2

Provided you're not intending to work with complex features (networks, annotation) then you're looking at the IFeatureDataConverter interface. The current API is documented here: http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#/ConvertFeatureClass_Method/0025000002w8000000/ The only example I could find is a bit outdated, but ...


2

you can use IWorkspaceFactory.GetClassID() method...i just tested on 9.3 and it gives me two values.. AccessWorkspaceFactory -> {DD48C96A-D92A-11D1-AA81-00C04FA33A15} FileGDBWorkspaceFactory -> {71FE75F0-EA0C-4406-873E-B7D53748AE7E} the code i used is below.. IWorkspaceFactory factory = new FileGDBWorkspaceFactoryClass(); ...


2

If you are just after detecting a file vs personal gdb, you could just do a Directory.Exists on the path (file gdbs are directories and personal gdb is for files). I don't know of a recommended method of determining this, but I have this in an extension method GetWorkspaceContainerType(this IWorkspace workspace) sorry, can't post the entire method. You ...


2

You may have hit a data corruption issue as detailed in Esri technical article 41119. The error message matches. A file geodatabase may become corrupted that is on a remote Win7 or certain Windows Server boxes. The problem is caused by one of several Microsoft updates and has a patch. Excerpted from the article: The update for KB 2732673 has been ...


2

It doesn't look like the Java-based MDB driver is included in the most recent GDAL-Complete framework. Please file a request with kyngchaos.com, though understand there may be issues with creating a one-size-fits-all package installer (see JAVA note below). IMHO, the Java-based MDB driver is the only reliable means of reading MDB files for Mac OS X, as of ...


1

og2ogr can source data using an SQL query statement instead of just a layer name. The following query selects data from the "Routes_Master" layer and adds a table column "tablename" set to "table1". select *,'table1' AS 'tablename' from Routes_Master As a command... ogr2ogr -sql "select *,'table1' AS 'tablename' from Routes_Master" PG:"*" A.mdb ...


1

Access based personal geodatabases are limited to a single editor at a time, however other users will still be able to view the data while it is being edited. And anyone who has the correct permissions (Read/write/change I think) will be able to edit. This is the same for file based geodatabases. in the Esri realm Personal SDE is the lowest level of ...


1

Once you have a reference to the workspace, you can use this function to find out what kind of data source it is. You can find a list of all workspace factory UID values here Public Function GetCategory(ByVal pWorkspace As ESRI.ArcGIS.Geodatabase.IWorkspace) As String Dim sClassID As String sClassID = pWorkspace.WorkspaceFactory.GetClassID.Value ...


1

You can use the IWorkspace.WorkspaceFactory property (returns an IWorkspaceFactory reference) to check which whether the workspace object was created from an AccessWorkspaceFactory, FileGDBWorkspaceFactory, or other.



Only top voted, non community-wiki answers of a minimum length are eligible