Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [personal-geodatabase]

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

1
vote
1answer
46 views

ArcGIS Pro Python arcpy.CreatePersonalGDB_management

I have an ArcGIS Pro Python script (please note it's version 3+ and to be precise shows as 3.66) and when I run the following command, I get an error. arcpy.CreatePersonalGDB_management(...
2
votes
0answers
268 views

Opening personal geodatabases (*.mdb) in QGIS 3.4.1?

I was successfully able to open *.mdbs in my previous version of QGIS on Windows 10 64 bit, but since the Madeira update (3.4.1, 64 bit) they no longer work. Getting a "Layer is not valid" error ...
0
votes
0answers
319 views

Turning .mdb file into shapefile using QGIS?

I have been trying to work with an .mdb file for hours with no success. I'm working on a project in which a require a shapefile, the government gave me the info in an .mdb file. I had never worked ...
1
vote
1answer
96 views

Can shapefiles have image attachments?

I know feature classes inside a File geodatabase or personal geodatabase can have attachments enabled. Can a shapefiles have image attachments?
1
vote
1answer
197 views

Change multiple polygons' area from square degrees to square meter in attribute table with QGIS

I imported an ESRI personal geodatabase vector file (.mdb file) into QGIS, when I open the attribute table, it seems the the shape_area unit is in square degree. I changed the project properties to a ...
2
votes
1answer
44 views

Convert .mdb file shape area and length units to meter with Qgis

I have a personal geodatabase file (.mdb file), I open it with QGIS Las Palmas on windows 7. It is displayed perfect, but when I open table attributes for polygons, shape_area and shape_length have an ...
1
vote
0answers
94 views

How to edit a layer from a personal geodatabase in QGIS [duplicate]

I want to open and edit layers from a personal geodatabase in QGIS. I have read this post and I follow the ODBC way to open a personal geodatabase in QGIS with success. However, I cant edit layers in ...
0
votes
1answer
91 views

Converting shapes in a personal geodatabase to GeoJSON

Sorry if the question is too broad or not exact, but I'm pretty new in this area and not really sure about the namings and so on. I have got an MS Access Personal Geo Database which is created either ...
3
votes
1answer
122 views

ArcObjects spatial filter not working for File Geodatabase

I do not know why my tool no longer functions properly when working in a file geodatabase (FGDB), as opposed to the personal geodatabases (PGDB) used in the past. The tool is used to find feature in ...
5
votes
1answer
435 views

How to read a feature class in an Esri Personal GeoDatabase using R?

I have feature classes in a personal geodatabase on a Win 8.1 machine (r 3.4.2, rgdal 1.2-15) and, as mentioned here, there is a requirement for Access users to also interact with them. I have ...
5
votes
1answer
1k views

Opening Esri Personal Geodatabase (*.mdb) using QGIS

I wanted to open an ESRI personal database (.mdb format) into 64-bit QGIS 2.18.14 on a 64-bit Windows 7 laptop with 64-bit MS Office 2010 installed. On my all 32- bit desktop, all I have to do is drag ...
1
vote
1answer
142 views

Output Location for ModelBuilder?

What I am trying to accomplish in ModelBuilder is netting road buffers and stream buffers from forest polygons. I do not know python and I am relatively new to ModelBuilder. I attached the start of ...
1
vote
1answer
53 views

Geoprocessing tool- output file path location for personal geodatabase in ArcGIS Server

I want to know about using a geoprecessing tool: How do I define an output file path location for a personal geodatabase in an ArcGIS Server geoprocessing folder path?
2
votes
1answer
309 views

Why can't I create a feature class in ArcCatalog when using a .MDB file?

I am trying to use an access database with geographic information in ArcCatalog. I created the database as a .accdb and backsaved to a .mdb format. I can create a 'shapefile', but not a 'File and ...
2
votes
1answer
1k views

Add File/personal Geodatabse to Geoserver

Is it possible to add file or personal geodatabase to Geoserver? If not, how we can get rid of shapefile limitations in Geoserver (without using a database like PostGIS)?
-2
votes
1answer
34 views

Editing feature class without creating separate output?

I have a feature class in my geodatabase and I would like to convert multi-parts to single-parts using the following syntax: MultipartToSinglepart_management (in_features, out_feature_class) Is ...
1
vote
0answers
168 views

Creating a domain based off specific attribute selection or lookup table in ArcGIS/Access?

Is it possible to have a domain on a database in ArcGIS that creates a drop down pick list on an attribute then have the next field have a domain based on that section? For example: Field A - choose ...
1
vote
1answer
40 views

ArcPy script not finding empty values in Text fields?

I have written a script that checks populated (or empty) values off of coded value and range domains. It works well with the range domains. It finds empty fields as well as values that are out of ...
1
vote
0answers
204 views

Joining a .dbf table to a feature class in a personal geodatabase only matches 90% of the records

The matching ID fields are identical, there are no extraneous spaces or anything like that. I exported the feature class and table to a gdb, and it joins all but one record (still no difference in the ...
1
vote
0answers
50 views

What to do with unused layers in my personal geodatabase

I have a question about my personal geodatabase. You can see it at the picture below. I started with the database in Arcmap with my normal data (Black sea, Danube, East Aegean and West Aegean). In ...
3
votes
1answer
194 views

Edited metadata disappears in ArcCatalog

I'm quite new to GIS (being a student) and I have to edit the metadata for a couple of layers in my personal geodatabase. The problem I have is when I'm editing the metadata for the rasters it keeps ...
1
vote
0answers
34 views

How to add automatically a color for a query made in Access

I made an Access database with my polygons and my Exceltable with data about floods. I linked the specific row to my shapefile table and made a query table of it. With the manual way I gave the ...
2
votes
1answer
91 views

Adding editable Excel (or Access) table in ArcMap?

I have flood data from the past ten years written in an Excel table. Now I would like to connect the table to ArcMap, so I can join it with the shapefiles. Normally this isn't that hard, but because ...
1
vote
2answers
42 views

Limited entries on field (ArcGIS 10.1)

I'm formatting a Personal Geodatabase on ArcGIS 10.1 and I came across a important issue. I have this particular field that I want to limit to 5 particular entries. So, the result being that I don't ...
7
votes
1answer
3k views

Does ArcGIS Pro support personal geodatabases (mdb)?

Does ArcGIS Pro support mdb or not? In ArcGIS Pro,I can't find anywhere can load data from mdb; I have not find the help page.
1
vote
2answers
65 views

Ordering Feature Attributes

I have a polygon feature layer I am updating within a personal geodatabase. I have ordered my attributes in the table in a certain way for data entry. Every time I re-open the feature for editing, I ...
0
votes
1answer
271 views

SQL date Query of personal geodatabase in ModelBuilder with inline variable

In ModelBuilder I'm trying to create a table from a subset of dates in a Personal geodatabase table. I'm using "Make Table view" tool. The date field in the table is [DateCreated]. I have two model ...
0
votes
2answers
60 views

SQL expression for largest number in Table

With "select by attributes" I would like to select the largest number in a column of an attribute table. How would be the SQL expression for that? I don't want to select it by hand, because I will ...
2
votes
1answer
85 views

How to copy a line feature into a polygon personal geodatabase feature class?

I have a line shapefile with a proposed hiking trail. I am trying to copy this feature into a larger geodatabase feature class. The feature class is set to polygons. Is there a way I can just ...
1
vote
1answer
89 views

ArcGIS Personal Geodatabase

I'm working with a lot of shapes and raster files in one map document (.mxd) in ArcMap and I would like to send the project to another person that works with me. I would like to know if there is a ...
0
votes
2answers
387 views

Importing data from personal geodatabase to Excel and/or Access?

My dataset it much more than what ArcGIS 10.3 can export to a .xls file so I was told that I could write the data to a personal geodatabase which I then could import to excel and/or access. I tried to ...
3
votes
1answer
944 views

QGIS managing relationships

Coming from an ESRI background I'm used to ESRI geodatabases (.mdb or .gdb). In those databases, I could create feature classes, tables and relationships between them. Every time I loaded a feature ...
0
votes
0answers
141 views

Can GlobalMapper open Personal Grodatabase (MDB( without ArcGID license?

I am wondering if GlobalMapper can read an .mdb geodatabase without an ESRI license? I have encountered some apps that can not read a .gdb without the license but can read an .mdb, so wondering if ...
1
vote
2answers
152 views

Model to create layer from joined MS access table

I am using arc10. I created some queries in MS access that I can open up in arcmap utilizing the database connections. It works fairly well but is rather slow. I wanted to know if there is a model ...
0
votes
1answer
228 views

Creating Replica using ArcPY with check_out type

I am running the following command in python and it works fine no error but it does not generate a mdb in output path folder and give me the input path result as output child source arcpy....
4
votes
1answer
851 views

Data Insertion from .CSV file to a Feature Class attribute Table in ArcGIS for Desktop?

I am working on water network in ArcGIS 10.2. I am trying to insert data from a data.csv file to an existing feature class House Meter in personal GDB. One method I know to use is the join data.csv ...
0
votes
0answers
57 views

MAX value in SQL

I have used a variation of this sql statement successfully in the past but can't get it to work now. I have a table named "RS_Event_All_NE_25_Weekdays" in a personal geodatabase running on arcmap 10.2....
5
votes
1answer
570 views

UpdateCursor gives Too few parameters Expected 1?

Can anyone tell me why my script isn't working? I can't figure out where I went wrong. I am working with an Access personal geodatabase. Adding a field, then updating that field with yes if the field ...
2
votes
1answer
53 views

Self-intersecting after exporting .shp from Personal GeoDatabase

I have a Feature Dataset in a Personal Geodatabase, with resolution = 0.00000001 and tolerance = 0.000000005. I am exporting the Polygon Feature Classes to shapefiles, after setting Resolution = 0....
2
votes
1answer
714 views

Transfer data from access mdb to personal geodatabase (OLE, Python scripting)

I am very new in Python. And I guess I need to use lots of Python here. I have MS Access 2003-2007 database (mdb format) and personal geodatabase (mdb). I created a tool in Access that imports data ...
2
votes
1answer
536 views

Link Excel Table to Access/Arcmap Personal Geodatabase Table

My overall goal: My coworkers have an excel table which they update/use frequently. The table is not in a format that arcmap can decipher. Therefore, I've created a locked sheet (in the format I ...
3
votes
1answer
429 views

How to find Coordinate System of datasets inside MDB and GDB

I have been given some ESRI personal geodatabase files (MDB) and file geodatabase files (GDB). I don't know the coordinate system(s) for these files. Is there a way to do this without using ESRI ...
2
votes
1answer
106 views

Personal geodatabase items have an exclamation (!) in ArcMap

A user in our department is having a problem accessing personal geodatabase data in ArcCatalog and ArcMap. Receiving error message: Failed to connect to database. An underlying database error ...
0
votes
1answer
83 views

ArcGIS Select largest N rows in group

I have feature class (Name: V1) in personal geodatabase with columns: Height [float] and Id [int] representing group number I need to do SQL query that will select eight highest 'Height' values in ...
2
votes
3answers
1k views

ZIP and import to ArcGIS online a personal geodatabase

This may sound dumb, but how do you zip a personal geodatabase in order to import it to ArcGIS online? Are there other ways to import the geodatabase, different from the one below? ArcGIS Online ...
5
votes
1answer
666 views

Using Python to discriminate Personal Geodatabases and MS Access Databases

I need to list a server's geodatabases, to analyze and process them. My users are however creating both personal geodatabases and MS Access geodatabases. Listing mdb files reports both types of ...
1
vote
1answer
2k views

Creating new layer from selection in ArcPy? [closed]

arcpy.SelectLayerByAttribute_management() helps in selection but I am unable to create a new layer from the selection arcpy.MakeFeatureLayer_management() for generating new layer file but it gives an ...
2
votes
1answer
74 views

Does it matter whether I use ArcCatalog or Access to compact a geodatabase?

I've been tasked with compacting some of the personal geodatabases (MDB files) in our office every few weeks. These reside on a couple of separate file servers. I have been using ArcCatalog to do ...
2
votes
1answer
230 views

Using ArcObjects to search or to obtain count (IQueryFilter) from selection set?

This only appears to be an issue with Personal Geodatabases (MS Access back end)... I need to search within an existing selection set to populate an ICursor. My main objective is to test whether my ...
1
vote
1answer
206 views

Problem using ogr2ogr to convert postGIS table to personal geodatabase

I need to convert a PostGIS table to a personal geodatabase using ogr2ogr. I can convert tables to a shapefile without a problem but whenever I try to convert it to .mdb using the ODBC driver, I get ...