ESRI geodatabase is a particular database schema designed by ESRI for managing "layers", "versioning", "topology" and other ESRI application specific storage requirements.

learn more… | top users | synonyms

15
votes
8answers
4k views

Versioning with ArcSDE - Is it possible to cancel or reject edits once they've been posted?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
20
votes
5answers
7k views

How to migrate GDB data into PostGIS without ESRI apps?

Can you tell me how I can load geodatabase data into PostGIS without having to install ESRI apps? The solution I found online talked about using ArcGIS to convert GDB to SHP and then importing SHP to ...
24
votes
8answers
10k views

Open Source Tool capable of reading Esri File Geodatabase (.gdb)?

I have an ESRI File Geodatabase (.gdb) file that I would like to convert to shapefile (or any other non-proprietary format). Are there any Open Source tools to do so?
9
votes
4answers
3k views

How to reorder fields (permanently) in a file geodatabase

Using ArcGIS 10.0, is it possible to reorder the fields in a file geodatabase, and have the order persisted to the database? We considered exporting to XML, and writing a parser to change the field ...
8
votes
2answers
4k views

Issues with large datasets

I am trying to run an Intersect process in arcgis 10 sp 3 with 2 file sets (aspect and slope) from up to a 1m DEM across an area of 65,000sq km. The aspect has 9,930,384 records and the slope has ...
7
votes
4answers
6k views

Trouble importing Feature Classes into Feature Datasets

I'm sure there must be a simple reason for this but I can't seem to be able to import a shp file or a feature class from another file or sde geodatabase into a Feature Dataset without getting an ...
18
votes
2answers
13k views

How to access file geodatabase in Qgis? [duplicate]

How does one access data from an Esri file geodatabase in Quantum GIS? I've seen snippets of conversation that indicate it's possible with qgis 1.7+ and gdal 1.9+ but no clear recipe. I recognize ...
7
votes
1answer
2k views

How to update the length property of a feature class field?

I have a feature class with a string field that I want to update the length from 10 to 25. Is there a way or a tool to update this property without having to create a new field and using field ...
5
votes
4answers
340 views

Can I store an ArcObject inside a BLOB or XML field?

I'm having this crazy idea here...Is it possible to store an ESRI object inside a blob field inside a geodatabase? If not, perhaps a serialized XML representation? I'm thinking about storing ...
8
votes
2answers
8k views

How do you create 9.3 version of a geodatabase in ArcMap 10?

Under the What's new for geodatabases in ArcGIS 10 Esri talks about an optional parameter that allows you to create a 9.3 GDB [GeoDataBase] in version 10. I can not find any other info. Any help on ...
5
votes
2answers
629 views

How to check if domain already exists?

I am trying to check the existence of domains in my file geodatabase which contains 4 domains (automatically populated after I created some annotation feature classes). My code is as follows: import ...
3
votes
2answers
237 views

Can a Geometric network be hosted in a Spatial Data Service?

I'm wanting to deploy a geometric network to Sql Azure, where clients can trace through it. The Spatial Data Services Deployment Utility allows me to deploy each featureclass from a geometric network ...
12
votes
6answers
5k views

Bulk field rename in file geodatabase

I have a file geodatabase with several hundred feature classes in it. Some feature classes have a field that got named incorrectly, and it got named "SCHEMA_FEATURECLASS_ENTITY" instead of just ...
9
votes
1answer
875 views

How to get the size of a file geodatabase feature class on disk?

Is there a simple way to determine the amount of hard drive space a feature class takes up? I feel like I'm missing something simple, but I don't recall a method that does so. You would think that ...
4
votes
4answers
3k views

Search if field exists in feature class

I have a few dozen feature classes, one of which contains the field I am looking for. They are stored in several different file geodatabases. Is there a quick way of searching each feature class to ...
1
vote
2answers
819 views

How to list Feature Classes of Multiple geodatabase in Multiple Folder?

I'm new in python scripting and try to list polyline feature classes of multiple Geodatabases. The Geodatabases are in many nested folders.For example in folder "A" I have 20 folders and in each ...
2
votes
4answers
802 views

How to distinguish between File and Personal Geodb workspace?

I am looking for a way - given an IWorkspace object - to check if it was created from a Personal-GDB or a File-GDB. I tried using IWorkspace.WorkspaceFactory to check if it's an instance of e.g. ...
1
vote
3answers
1k views

creating unique ID-s for my file geodatabase

I use ArcEditor licence level, ArcGIS 10.0 version, and we're talking about a file geodatabase. I have several feature classes (electric energy domain) and I want to connect them using relationship ...
4
votes
5answers
2k views

Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system. I need an exact copy of the ...
3
votes
2answers
424 views

Using ArcObjects, how to convert an Access table into a proper geodatabase table?

I have inherited an ArcGIS application that creates a number of access database tables. I'd like to use ArcObjects to convert them to proper geodatabase tables, which I understand to mean simply ...
16
votes
1answer
2k views

What are Esri Geodatabases?

What are the various formats/storage technologies which fall under the name Esri Geodatabase? What are the most important differences between them? and (briefly) what are the mainstream means to ...
10
votes
4answers
903 views

Performance - using multiple file geodatabases as opposed to one

I'm trying to decide the best way to organize my data for an ArcEngine application. I am particularly interested in map display and query speed. Currently I have all of my data separated into separate ...
6
votes
2answers
1k views

Creating geodatabase from CSV using python

I have a file with weather data (daily) for multiple weather stations for multiple years. I am looking for some python script to automate the database creation process and its interpolation on a daily ...
14
votes
2answers
790 views

What is the best practice for data management? [duplicate]

I have always been curious how other folks are storing their spatial data. Outside of an enterprise environment where much data is stored in enterprise geodatabases, is it better to store data per ...
16
votes
7answers
7k views

ArcCatalog 10.0 complains that spatial references don't match between a feature dataset and a feature class that have the same coordinate system?

I have a feature dataset that is using the GCS_WGS_1984 as the geographic coordinate system. It includes a few feature classes. This feature dataset is itself in a file geodatabase that contains a ...
10
votes
2answers
3k views

How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux

We have esri Personal Geodatabases that we need to import into PostGIS. Ultimately, we'd like to allow people to upload an MDB on a web server, and have it import the layers into PostGIS. On ...
4
votes
1answer
137 views

Where can I find the various Esri tools to design a geodatabase?

There is a confusing multitude of tools written by Esri and others (some supported, some unsupported) for designing and diagramming a geodatabase. Here is an attempt at creating a definitive list of ...
8
votes
1answer
138 views

How to perform Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...
8
votes
3answers
2k views

Exporting arcgis features with attachments

Arcgis 10 features the new ability to add attachments to individual features to feature classes stored in a geodatabase. One use of this would be to add multiple pictures to a specific location, fire ...
6
votes
2answers
585 views

How is the default label field chosen by ArcMap?

I have 2 questions: I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
2
votes
1answer
39 views

Transfer subtype Descriptions form long integer value into a string at new diffrent field

I need to convert entire geodatebase into shp files.One of the layers have 30 subtypes. I want and maintain the subtype data. Is there a way to Automatically populate the name of the subtype (Transfer ...
9
votes
3answers
4k views

How to list feature classes with active “attribute domains”?

I have an Esri file geodatabase with attribute domains defined. I need to delete some of the attribute domains but can't because "The domain is used by an attribute rule.". How might I discover which ...
8
votes
3answers
351 views

How to mirror two geodatabases on the fly?

I'm new to arcgis and its applications. We have the full suite of arcgis solutions (arcgis server, desktop, arcgis sde) We have a requirement... geodatabase (A & B) A & B reside on 2 ...
8
votes
3answers
3k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
4
votes
3answers
2k views

How to a sync file geodatabase across multiple office locations?

I am planning to have a work project with multiple file geodatabases, fgdb (consisting of images, grids, feature class, etc) and these will be passed along to three regional offices and will sit on ...
3
votes
2answers
264 views

Why can't I see all records in my personal GDB in QGIS?

I am running QGIS 1.8. I have a layer from an ESRI Personal GDB. There are 431 features in the layer. When you load the layer into QGIS, and look at the Metadata properties, it shows the number of ...
3
votes
1answer
872 views

Error importing XML workspace document to file geodatabase

Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
3
votes
4answers
2k views

Is there any place in which I can find a list of invalid database characters for ArcGIS 10?

Relating to my question about the split tool here, as suggested I ask a new question: is there any place with a list of invalid characters to use in a database in ArcGIS 10? edit: It is in relation ...
3
votes
1answer
857 views

How do I move and/or rename a file geodatabase?

I am expanding the scope of an existing file geodatabase so I would like to move it up a folder hierarchy as well as rename it. For both of these operations, is it as simple as moving the folder via ...
3
votes
3answers
227 views

Is there any way to write a snipet of code with function of “SDELayer -o register” command

I try to create a geodatabase using some SQL command and then register some tables of it with SDE. I create an empty geodatabase using sde post installation and then create tables and other database ...
2
votes
0answers
185 views

Symbology levels are ignored in ArcGIS 10

I have a problem migrating from a ArgGIS 9.3 to a 10 geodatabase (both sde and file gdb). The symbology levels stored in the 9.3 database are not transferred. When migrated to ArcGIS 10.0, ...
11
votes
2answers
643 views

When is it safe to use ObjectIDs as keys in a relationship class?

I've always avoided using ObjectIDs when defining relationship classes. It is my understanding that some actions on a geodatabase will re-set objectIDs (like import/export). However I do see a lot ...
6
votes
1answer
540 views

How to programmatically determine the size of a feature class in a file geodatabase?

My answer to the question How to get the size of a file geodatabase feature class on disk? shows how one can enable a column in ArcCatalog showing the file size of FGDB feature classes in the contents ...
6
votes
2answers
4k views

How to add feature class from ESRI personal geodatabase (.mdb) in QGIS

How do you add a feature class in a ESRI personal gdb in qgis. I understand this can be done through the option add vector layer and select geodatabase. But what after that ? It doesn't allow me to ...
5
votes
2answers
2k views

Data organization strategies for .csv and .shp

I'm organizing a large amount of data for a project and the data is stored in .csv format, with a code to relate each row to a polygon in a .shp. I was planning on converting the .csv data into .dbf ...
4
votes
2answers
375 views

QGIS saving analysis output as Postgis table

i am using QGIS and Postgis together. I can load data in Postgis and than i import it to QGIS. But i am trying to save an analysis output (example: buffer analysis, voronoi polygon or SEXTANTE ...
4
votes
2answers
770 views

Is there a performance hit from using a Feature Dataset?

I vaguely remember being taught not to use a Feature Dataset to make things "look neat" in the database, and that the Feature Dataset should only be used when there was some sort of spatial ...
3
votes
3answers
646 views

Using PostgreSQL with ArcGIS

Have mercy ... with Stackexcachange I'm not yet so familiar, so this is initially somewhat opaque. I try to do my best to organize this thread as well as possible. Recently I've started to get WFS ...
3
votes
0answers
706 views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
3answers
1k views

ESRI File GeoDatabase: Unicode/Codepage problem - Convert UTF-8 to ANSI

I have a Codepage issue, and for now I am a bit stumpped My original source data contains multiple country data delivered in SHP (UTF-8). The data is then merged into a File GeoDB as the data is too ...