Questions tagged [file-geodatabase]
File geodatabases are a proprietary data format created by ESRI.
949
questions
0
votes
0answers
40 views
Joining Table attribute to Map attributes without matching properties
I have a Dataset (10Gb) that I imported to QGIS 3.22.
It contains multiple tables and maps.
The first map categorizes land usage (HWRM_HWRK_LN) and I was able to attribute a color gradient.
The four ...
0
votes
0answers
33 views
Importing .gdb to QGIS but still need to combine shapefiles and tables [closed]
I have a .gdb folder that I imported to QGIS.
Screenshot Album
Keep in mind I am fairly new to GIS Data in general.
This file (.gdb) contains five maps, one is a shapefile and the others I am not sure....
0
votes
1answer
21 views
Many to many relationship class with ArcGIS Desktop using only two table
In database discussions, for creating many to many relationship class we must create a third table to relate two other tables.
However, in ArcGIS for creating many to many relationship class we just ...
0
votes
1answer
28 views
Bringing in ARC gdb into QGIS 3.16
Trying to bring in an ARC gdb folder into QGIS 3.16 using the Vector import tool but it keeps saying it is not a valid or recognised data source.
Layer -> add Layer -> Add Vector Layer
using ...
1
vote
1answer
59 views
Broken/missing projection when opening GDB?
I've loaded a GDB Esri in QGIS, however, When I open the layers, those have a different location. I think that the prj file is broken, null or QGIS can't identify correctly.
Anyone have this issue or ...
1
vote
0answers
18 views
recover corrupted file geodatabase (corruption after adding a new field)
I was trying to add a field in one of the feature class of my file geodatabase, but there was a small network failure and the operation corrupted my feature class.
I would like to recover this fgdb, ...
0
votes
1answer
25 views
Reading values from file Geodatabase table and assigning those values to variable [closed]
I created a table using the zonal statistics as a table tool which contains some percentile values of a raster (90%, 75%, etc). The table is 1 row and contains the percentile values. I want to take ...
0
votes
2answers
38 views
PostgreSQL to FileGDB doesn't keep joins
I'm trying to convert my geospatial PostgreSQL tables to a FileGDB (geodatabase) by using this command:
ogr2ogr --config FGDB_BULK_LOAD YES -f "FileGDB" C:\data.gdb -append -overwrite -...
1
vote
0answers
27 views
Opening file geodatabase with raster datasets in QGIS 3
I wish to open a file geodatabase created using ArcGIS version 9 with QGIS 3. I am able to load the file using QGIS but only polygons are appearing but not the raster datasets. How do I deal with this?...
0
votes
0answers
56 views
What is function of .horizon files in file geodatabase?
What is the function of the .horizon files that are present whenever a file geodatabase is created in ArcMap, I understand it is all proprietary formats for Esri, but is there any explanation?
I have ...
1
vote
1answer
52 views
Set FME Writer to always output to the same location as the Reader
Is it possible to set the Writer in FME to always write to the same location as the Reader (ideally a FeatureReader) so that the output is always saved in the same folder location as the input?
...
1
vote
1answer
30 views
Use FME to expose each feature from feature class
I have a feature class in a geodatabase which usually has between 1-300 features.
I would like to use FME to expose each feature and create an individual shapefile for each, based on an attribute.
For ...
0
votes
0answers
30 views
Accessing TIFF files in file geodatabase outside of ArcGIS Pro
I am working with many .tif files in a file geodatabase in ArcGIS Pro. However, I want to use these files in a Python script outside of ArcGIS Pro.
How do I access the files in the file geodatabase?
I ...
-4
votes
1answer
36 views
How to select geometry column to use in Create Database View tool in ArcGIS Pro?
I have a geodatabase locally and when I try to do simple query using Create Database View like:
SELECT Name, sum(Area) as Areaa, Shape
FROM houses
GROUP BY Name, Shape,Area
it returns that the ...
0
votes
1answer
69 views
Creating new feature classes from tuple using ArcPy
I have point Feature Class that includes 49 OID. After that I have a Tuple that includes random set of OID from point feature class for example new_OID = ('10,24,38,41', '17,26,34,47', '5,7,18,25', '7,...
3
votes
0answers
91 views
Why does arcpy.da.Walk work differently when used with file geodatabase (gdb) and personal geodatabase (mdb)?
Why does arcpy.da.Walk give different output with identical File (GDB) and Personal (MDB) Geodatabases?
Example:
I am using ArcMap 10.4.1
r'D:\SCRipt\New.mdb' is a copy of r'D:\SCRipt\New.gdb'
db =...
3
votes
1answer
59 views
.gdb table creation speed
I'm trying to convert a shapefile containing N single point shapes to a .gdb using the FileGDBAPI for C++ from Esri.
The structure of the shapefile is:
x | y | date1 | date2 | ...
1
vote
0answers
36 views
An Invalid SQL statement was used with SearchCursor
The code:
import arcpy
fc = r'C:\Users\xxxx\OneDrive - xxxx\Documents\ArcGIS\Projects\xxxx_Test\FinalUnions_VTDs.gdb\New_Final_VTD_SplitLayer'
prevFieldValueList = []
counter = 1
with arcpy.da....
1
vote
0answers
21 views
How to use Java for desktop GIS development on Linux system
I need to use Java language for desktop GIS development on Linux system. I need to perform read and write operations on FGDB databases, rasters, and vectors. First, I tried to use GDAL, but GDAL is ...
0
votes
0answers
49 views
How to read and write Esri FileGeodatabase (FileGDB) in Linux by Java language？
I need to read and write Esri FileGDB in a Linux system (Centos).I have installed GDAL and compiled the Java package.Then, I tried to use FileGDB API to accomplish the task, but it does not support ...
0
votes
1answer
36 views
How to add user input shapefile as a parameter into "GDB Creator" Python Script tool
I created a Python Script tool to create a GDB inside of a user defined folder path. I am trying to find a way to add another parameter in my script tool for a user to input a shapefile after they ...
1
vote
0answers
26 views
Taking multiple geodatabases created in first tool and using those as output locations for second tool in ModelBuilder of ArcGIS Pro
I am using ArcGIS Pro.
I created a ModelBuilder tool that selects the information from my feature class table, groups it by its unique attribute, and makes a file geodatabase and new feature class ...
0
votes
1answer
48 views
Importing .gdb file in desktop ArcMap
When I am importing .gdb file in QGIS, I cannot see the all years data.
I am trying to import the .gdb folder in ArcMap using the following step:
Add data -> connect to folder -> folder.gdb
But ...
1
vote
2answers
117 views
Opening .gdbtable file in QGIS
I am trying to open the .gdbtable file in QGIS.
I have tried:
'open data source' -> vector -> vector databese -> a0000000a.gdbtable -> open
It gives me following error.
a0000000a....
0
votes
0answers
29 views
How to install/write Esri file geodatabase (*.gdb) in QGIS after QGIS installation on Mac
I have to write some data into *.gdb format in QGIS 3.20. I am aware that since 3.2 QGIS has native support of reading the *.gdb files. However, I have to Export/Save As/ Esri file geodatabase.
I've ...
0
votes
0answers
7 views
Why is all .gdb data displaying in GEO except one file feature class?
I am using the InformCAD and GEO products by Central Square Technologies to update our EMS maps with data I curated using ArcGIS 10.2.
All of the data is collected in an .mpx file which is what GEO ...
1
vote
0answers
41 views
Open rasters in ESRI .gdb format with QGIS 3.10
I got a .gdb file (v. 10 and v. 10.5) that include rasters. I don't have any ESRI tools and would like to open the rasters in QGIS v. 3.10. Is there any way to extract the rasters from the .gdb file ...
0
votes
0answers
15 views
ArcMap - Update SQL geodatabase from File geodatabase, no replicas
This is a recovery situation, when we have a backup of a MS SQL geodatabase that contains all the tables and features, and we have a newer gdb file geodatabase backup that contains some of the tables ...
0
votes
1answer
40 views
Performing ST_Distance query in file geodatabase using ArcGIS Pro
I'm trying to create a view in ArcGIS Pro that joins attributes from two feature classes. The features need to be joined by an ID field and by distance. I want the features in the TABLE1_ERASE layer ...
1
vote
2answers
206 views
Converting "string" date to "date" format using FME
I have a string field with values such as 04.07.21 and I am trying to write to GDB but it's not working because date format is expected and string is provided.
How can I convert these values (04.07.21)...
0
votes
1answer
47 views
Can't open .gdb folder with related files in ArcMap 10.7
I am wondering if someone here might be able to help me troubleshoot opening a .gdb folder in ArcMap. I have already tried using Add Layer, Connect to Folder under Catalog, Open, and dragging and ...
1
vote
1answer
40 views
Joining ArcMap to Excel table but join fields not showing up in join dialog
I have datasets in a File GDB Feature Class and an Excel table. I want to join them on a field named JOINFIELD. I have the same field name in the FC & in the top line of a column in the Excel ...
0
votes
1answer
43 views
Joining and exporting tables from multiple geodatabases using ArcGIS Pro
I am trying to join two tables that each exist in multiple geodatabases, and then export the joined product to a .dbf table. This works until I try to use Iterate Workspace to loop over multiple ...
1
vote
0answers
9 views
What is a good way to store a large (tiled) geo raster?
I have a large geotiff raster map (after compression 88 GB) as a series of 919 geotiff-tiles. How can I turn these into a practical file solution (e.g. one file) that allows me to efficiently work ...
1
vote
1answer
51 views
Joining points to closest line with summary of attributes using GeoPandas
I have a streets line dataset and a GPS Ping point dataset which contains speed. I'm trying to join the points to the closest street within 15m to get an average speed along each segment.
More details:...
1
vote
1answer
109 views
Back-up Feature Services with a script
Goal: I want to create copies of feature services and save them in a FGDB in a network folder on my machine. The overall purpose of the script is to have back-ups of my authoritative feature services ...
4
votes
1answer
61 views
Creating file geodatabase feature class without system fields
Is there a way to create a feature class without the SHAPE_LENGTH and SHAPE_AREA?
Only way I seem to be able to do this is to create a new feature class by right clicking fgdb> New > Feature ...
1
vote
3answers
70 views
How to add a new field and overwrite existing feature class by using FME 2021
What I am trying is to add a new field to an existing feature class in file GDB, overwrite this feature class and continue with processing. So far I tried to read that feature class connect to ...
1
vote
0answers
38 views
Why does a .gdb I created with GDAL double in size after it's been modified in ArcMap?
I created a large (over 200 million features) .gdb file with Python/GDAL. I had to move it to my Windows machine to add and calculate a column in Arc, since I couldn't figure out how to do with GDAL. ...
0
votes
0answers
77 views
FileGDB In GDAL Docker container with dot net core
Currently, I am using this docker image pepperlk/gdal that has FileGDB built in and working via command line.
Details here:
gdalinfo --version
GDAL 3.3.0beta1-b75f14ab12155c6b6f4544a9894c41f2f9a7d241, ...
2
votes
1answer
51 views
Failure when trying to write/update some features in FME
By means of FME 2021, I am trying to update one column in a Point feature class inside FileGDB (FME: writer). Updates are comming from another feature class (FME: reader). I dont have unique ID but I ...
2
votes
1answer
37 views
How to extract Metadata from File Geodatabase using Ogr2ogr?
The Ogr2Ogr doc says:
GetLayerDefinition a_layer_name” and “GetLayerMetadata a_layer_name” can be used as special SQL requests to get respectively the definition and metadata of a FileGDB table as ...
0
votes
1answer
326 views
Python script to import CSV data to a geodatabase
I am trying to import CSV data into an existing geodatabase in ArcMap. I want to import to the existing geodatabase fields to ensure my CSV data satisfies whatever rules are set up in the geodatabase.
...
2
votes
1answer
43 views
Adding multiple features from GDB files using PyQGIS
I tried to add all features from a GDB with PyQGIS.
layer = QgsVectorLayer(r"path.gdb")
QgsProject.instance().addMapLayer(layer)
This source code, only add one feature from GDB, but ...
0
votes
0answers
47 views
How can I load a very large raster (or portion of it) into R from an ArcGIS file geodatabase using R-Bridge (arcgisbinding)?
I have a large raster stored in an ArcGIS geodatabase (dimensions: 105,000x260,000) that I am trying to load in R. I have tried the following:
library(arcgisbinding)
arc.check_product()
gdb <- &...
0
votes
1answer
39 views
Exporting shapefiles to file geodatabase results in no coordinate system (ArcMap)
I export shapefiles with a defined coordinate system to a file geodatabase assigning the export coordinate system same as input file, but when I try to import them back into the project from the file ...
2
votes
3answers
143 views
How to update one column in file GDB by using FME?
I have one point shape file (in FME: reader) file which I exported to Geodatabase (in FME: writer). Meanwhile I edited only some features (lines on table) on my point shape file in one column. Now I ...
0
votes
0answers
25 views
Importing feature class keeping relationship classes to annotation using ArcMap
I have a project I've been working on for a few years using 10.2
In the past I have been able to update the gdb by importing data from a shapefile to an existing feature class. ArcMap would tell me ...
0
votes
1answer
86 views
Cannot import .gdb into QGIS
I have been supplied .gdb data and have extracted directories, but when I follow all directions from multiple sources I still get this error. have updated from 3.16 to 3.18, still cannot get it to ...
0
votes
1answer
22 views
Creating Subtypes in ArcMap
I want to create Subtypes for a feature class, but the option is not active.
Under Feature Class Property I created some Fields, but the Subtypes tab is not active.
I can't choose Subtype Field and ...
