A Personal Geodatabase is an ESRI-specified GIS database, in Microsoft Access (.mdb) format.

learn more… | top users | synonyms (1)

2
votes
3answers
70 views

Converting personal geodatabase .mdb file to .gdb

Is it possible to convert an MS Access personal geodatabase file to a SDE enterprise geodatabase file format? What kind of python scripting would it entail? I need to convert it in such way to ...
1
vote
0answers
19 views

Migrate MS Access Data into Oracle DB

I was sent some old MS Access files that contained survey data and served as a "file geodatabase". I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning. I ...
0
votes
1answer
37 views

How to add mdb geodatabase layer (feature class) to QGIS project using python?

I want to add a feature class of a personal geodatabase mdb to my qgs project by code (a plugin I am working on). I am using a command similar to that used for adding shapefiles, but this is not ...
0
votes
0answers
22 views

Finding What version a PGDB is programtically

So i have a list of 681 personal geodatabases. I want to figure out what version (9.x, 8.x, 10.x) these things are. So i want to write a program that will read the filepath from a database table and ...
1
vote
2answers
49 views

How to use an IF THEN statement in an sql Select expression?

I need to select the top 3 records from a table, but depending on an inline variable from an iteration, occasionally one of those top 3 records should not be selected and should be replaced by the top ...
1
vote
1answer
6 views

Generate Statistics from check-out GDB While performing Check-in

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. How to generate statistics of the edits performed on the check-out GDB, before check-in. for example: i want to have ...
1
vote
0answers
172 views

Failed to Connect to database: Underlying database error occured

I'm trying to connect to a personal database in ArcGIS 10.2 that contains work that I've spent the last two weeks working on but I am now receiving an error: Failed to connect to database. An ...
1
vote
1answer
17 views

Error 001156. increasing the length of text limit [duplicate]

I'm fairly new to ArcGIS for Desktop and i want to import my excel table to my personal gdb but i end up getting an error code:001156 and my import fails. I soon found out that it was the lengthy ...
1
vote
1answer
28 views

32bit to 64bit topology errors

Can generating a shapefile from a pgdb cause topology errors due to floating point conversion? I am running into gaps in a line layer of really small distances (order of 10^-4; CRS EPSG:2227 usft). ...
0
votes
0answers
26 views

Data migration through ETL Tool from file to personal geodatabase with existing geometric network and cardinality rule?

I want to perform data migration through ETL tool from file geodatabase to personal geodatabase with existing geometric network and cardinality rule. Please describe how to migrate?
1
vote
0answers
43 views

Converting MDB File With Unicode Characters

I'm using C# wrapper of GDAL and I'm having a problem converting MDB file that contains unicode characters. Lets take for example conversion to KML file, non-English characters are replaced by '?' ...
2
votes
2answers
96 views

Writing data into Esri *.mdb personal geodatabase using QGIS?

I have an empty *.mdb database that I have to fill with data. The problem is that I cannot install ArcGIS for Desktop on Ubuntu, so I decided to do it using QGIS 2.0.1 with a Grass plugin. However, ...
1
vote
1answer
75 views

Join Attributes by Location: .mdb and shapefile in QGIS

I can join attributes by location in QGIS using 2 shapefiles. However, I do not know how to do the join when one of my files is in a .mdb format while the other is a shapefile.
0
votes
1answer
118 views

Create FeatureClass in Personal Geodatabase and store data

I have to create a new featureClass in my existing personal GeoDatabase. And save some polylines into this featureClass. How can i do it? I need c# code to do this. Edit: I have a problem during ...
2
votes
1answer
131 views

Query to select MIN and MAX values by groups

In ArcMap 10 i'm working in a Personal Geodatabase where the points (see screenshot below) represent the number of each house in the street. Each point has an ObjectID. This ObjectID is an unique ...
0
votes
0answers
324 views

How to access a .mdb file (Microsoft Access) in Qgis (with windows 7)?

I've a very big problem. I need to connect shapes from a polygon layer with a .mdb file (built by Microsoft Access) in Qgis 1.8 (with windows 7), but I can't access it. Can anyone give me some help?
2
votes
3answers
703 views

How to auto increment a field in a feature class?

So I'm relatively new to ArcGIS and ArcCatalog. I have created a field name of PROJECTID in a feature class in a Personal Geodatabase. The data type is TEXT. This will be a ten digit ID. The first ...
1
vote
1answer
65 views

How to get replaceDataSource to work with personal geodatabase?

I am having trouble using the arcpy.mapping's replaceDataSource with a personal geodatabase. The script runs, but does nothing if I run the script in the python window of ArcMap. If I run it in ...
0
votes
0answers
50 views

Personal Geodatabase not recognized when connecting to folder

I am trying to connect to a personal geodatabase I created in Catalog. When I navigate to the location of the geodatabase, it isn't displayed. It seems to not be recognized. Any ideas?
-2
votes
1answer
359 views

ArcGIS Python Add in: Pass Entry from Combo Box (in Toolbar) to mdb [duplicate]

How do you update the python addin wizard code to write directly into access or pgdb? I have a combo box and need to have my users enter data into the combobox to write into the database. Can someone ...
1
vote
5answers
295 views

Alternative backup File or Personal Geodatabase

I'm wondering if there is a way around or an alternative way to backup a File or Personal Geodatabase. For example: If I have a very large dataset within the File or Personal Geodatabase and I want ...
0
votes
0answers
39 views

The topology cannot be validated because it is checked out

when I try to validate an existing topologiy in my personal GDB I got this error "the topology cannot be validated because it is checked out". How to solve it? thanks! It is a personal GDB. I'm ...
0
votes
1answer
117 views

Do Personal Geodatabases show up when trying to Export Data using ArcGIS 10.1 SP 1 (on Windows 7)?

I work with ArcGIS 10.1 SP 1 (on Windows 7), and I tried to export a feature layer to a personnal geodatabase using "right click in the table of content > data > export data". However, when I select ...
2
votes
2answers
179 views

Trouble Copying Data into File Geodatabase from Personal Geodatabase

I've been unable to successfully copy and paste personal geodatabase feature classes to a new file geodatabase in ArcCatalog 10.1. As the screenshot shows, the Data Transfer dialog box contains all ...
1
vote
3answers
668 views

How to Convert a Number to Percentage in Field Calculator

Using ArcGIS 10.2 and Personal geodatabase,I have a field with values of Numbers like 0.461538 and Type of "Double" can you please let me know how I can Export them to new Field in Percentage Format ...
2
votes
0answers
323 views

import esri Personal Geodatabase (.mdb) to PostGIS

I would like to import an esri Personal Geodatabase (.mdb) to PostGIS. I have tried to follow the blog post: How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux I installed the GDAL ...
2
votes
3answers
539 views

How to acquire schema lock is one already exists?

I'm trying to delete a feature class from a feature dataset or to add a field to it, but I keep getting an error message (pics attached below). I have imported a geometric network I've created from ...
7
votes
4answers
2k views

How do I open personal geodatabase in QGIS 2.0?

Good afternoon. I am trying to use an ArcGIS (10.2) personal database MDB as a container for data to pass to a QGIS user. I formerly used QGIS 1.8 for Mac OSX, and after some fiddling around, I was ...
1
vote
0answers
153 views

Personal Geodatabase not recognized as valid datasource in the last QGIS Windows Weekly build (64 bits)

I was using Personal Geodatabases in QGIS without any problem but it's stopped to work since I installed the last 64 bits weekly build for Windows (1.9.0-35-Setup-x86_64). I'm now receiving an ...
2
votes
1answer
61 views

Can I make an ESRI checkout replica from a checkout replica?

If I create a checkout from a clients geodatabase, can I then turn around and put that replica on our ArcGIS Server and create a couple replicas from it? So, then, our replicas would be synced to the ...
2
votes
1answer
92 views

Load PGDB with filename

this is my first question here and I have done extensive searches but still can't find the (full?) answer I'm looking for. Hopefully someone can help! I am loading a number of personal geodatabases ...
0
votes
0answers
192 views

Export From PGDB to ArcSde Using C#

I need help exporting a personal geodatabase Feature Class to an ArcSDE geodatabase using C# ArcObjects with ArcGIS 9.3. I just want to replicate the tool Feature Class to Feature Class ...
1
vote
1answer
143 views

Access Personal geodatabase using java

Following example through ESRI is to access the features of file geodatabase (GDB) , ...
31
votes
7answers
10k views

Whether to use File Geodatabase (*.gdb), Personal Geodatabase (*.mdb) or shapefiles?

I am a bit confused on the topic of geodatabases. Previously, I have used geodatabases as an easy way to keep all files together rather than having dozens of shapefiles all over the place. And it's ...
6
votes
1answer
186 views

How much database bloat is reasonable?

I use personal geodatabases to hold all the data for my projects (probably around 10-20 feature classes across 2-4 datasets on average). I use the personal gdb because I like being able to hook into ...
1
vote
1answer
153 views

Check Personal Geodatabase attribute against external MySQL database?

I have a Personal Geodatabase to which editors enter values from some field inputs. I would like some of the entries, eg Project No ( whose name is unique and has some some related attributes like ...
1
vote
0answers
976 views

Cannot Import Feature Class into Personal Geodatabase in ArcGIS 10.1

My objective is really simple. I have a shapefile and would like to convert it to a Feature Class. My goal is to use HEM tools, which I think requires me to convert my shapefile of interest to a ...
1
vote
0answers
83 views

Copying Features from One ArcMap window to another, without losing Related Tables

In our current workflow we are working in a Personal Geodatabase with few features and related tables , many persons will be working in different schemes. When we need to merge these schemes\Pgdb to ...
6
votes
2answers
551 views

How to Export a Personal Geodatabase to ArcSDE

I want to copy/export my personal geodatabase which consists of feature datasets, relationship class etc to an Enterprise geodatabase. What would be the best approach?
8
votes
3answers
433 views

Is there a way to tell the geodatabase version using Python?

I want to find out if either a file or personal geodatabase is 9.3, 10.0, 10.1, etc Is there a way to do this using Python?
6
votes
2answers
462 views

Read an ArcGIS Feature dataset using GDAL

I am new to GDAL in Python and would like to use it to create a list of populated layers in a ArcGIS mdb Feature datasets. I have the code below that provides a list of all the populated layers but ...
2
votes
2answers
205 views

Driver Error : DTM to Raster using GDAL_GRID

I am looking to interpolate a DTM (eventually over 4,000 DTMs) that is in a personal geodatabase format. I would like to do this in as few step as possible, eventually writing a batch script to do ...
3
votes
0answers
64 views

Rasterization tools for vector datasets with styles

I have hundreds of Personal Geodatabases and I want to create one georeferenced TIFF for each one. Each PGDB has the same feature classes ('CotourLines', 'Hidrography', etc) for what I have some ...
2
votes
1answer
79 views

Latitude and Longitudes are replaced with zeros when importing excel 2007 worksheet into personal geodatabase

I am trying to import an Excel 2007 data set into a personal geodatabase so I can convert coordinate systems. The data set includes point locations in Decimal Degrees. When I import the Excel ...
3
votes
2answers
487 views

Why does ArcMap connect to a Personal Geodatabase (PGDB) even when no feature classes (or tables?) are referenced in the MXD?

I have an odd question from a user in the same goverment that I work for. When he opens a .MXD-project in ArcMAP a Personal Geodatabase also opens that is not part of the project and does not have ...
6
votes
2answers
2k views

Is there a way to create a Personal Geodatabase in QGIS?

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 ...
10
votes
3answers
1k views

Can ESRI Personal Geodatabase be viewed with any software other than ArcGIS?

Is it possible to open a PGDB file in software other than ArcGIS? i.e are there any opensource software available just for viewing the data?
2
votes
1answer
47 views

When Zooming Personal Geodatabase Feature Class Error came

When i joined two different feature class attribute table while i have to zooming the PGDB feature class , drawing error will come. I have attached an example image to show the problem. Thanks to ...
5
votes
1answer
2k views

how does a personal-gdb work from a MS Access perspective?

I am trying to get a better general understanding of how ArcGIS works with MS Access when using a personal geodatabase. If I create a new pgdb and then import a very simple shapefile and finally look ...
3
votes
1answer
172 views

Append feature layer from one personal geodatabase to another using .Net

I currently have a client that still uses personal geodatabases (Access files). I currently have to open up ArcCatalog and manually append any FeatureLayers that are contained in the original personal ...