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

17
votes
8answers
5k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

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 ...
19
votes
2answers
18k 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 ...
9
votes
5answers
6k 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 ...
26
votes
5answers
10k 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 ...
8
votes
4answers
8k 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 ...
7
votes
1answer
4k 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 ...
2
votes
1answer
164 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 ...
1
vote
2answers
2k 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 ...
5
votes
4answers
370 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
9k 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
4answers
1k views

Export to a Shapefile and maintain Domain Coded Values

I maintain a complex parcel fabric that uses coded value domains for a few fields. These are short integer fields with values from 1 - 6. These values represent say 1:Integrated Registered Survey ...
5
votes
2answers
911 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
245 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 ...
2
votes
1answer
168 views

ArcGIS Attribute Subdomain?

Is there a way to create attribute subdomains in ArcGIS with clauses? For example, if I'm editing a line feature class of pipes, I create a domain for the pipe type to be either plastic or metal. I ...
17
votes
1answer
3k 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 ...
11
votes
1answer
4k views

Differences between Raster Dataset, Raster Catalog, and Raster Mosaic

I have about 40 scanned, colorful Geology maps that are GeoTiffs. I want to bring them into an Esri FileGeodatabase to lower their size, combine them as one and display them with a mostly transparent ...
10
votes
3answers
3k 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 ...
4
votes
4answers
5k 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 ...
2
votes
3answers
2k views

Creating unique IDs for file geodatabase using ArcGIS for Desktop?

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 ...
2
votes
4answers
980 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. ...
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
620 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 ...
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 ...
6
votes
3answers
2k views

What are convenient uml tools to create geodatabase models?

I used to model databases with Microsoft Office Visio, then export the model to xml and import geodatabase schema to GDB with ArcGIS tools. Since Microsoft no longer support Visio export to xml, what ...
5
votes
2answers
4k views

Trouble creating a query table

I need to join one feature class and one table. This is a one to multiple join, therefore, my only option seems to be by creating a query table. My problem is that the fields I want to join do not ...
4
votes
1answer
320 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 ...
16
votes
8answers
10k 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 ...
14
votes
2answers
1k 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 ...
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 ...
8
votes
1answer
186 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 ...
6
votes
2answers
810 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 ...
6
votes
3answers
729 views

What is ArcGIS for Desktop (and Geodatabase) equivalent to Regions of ArcInfo Workstation Coverages?

Here's one for those who've been around the block a few times. ArcInfo Workstation from days of yore had an intelligent data model called Regions or Region sub coverages. With this model one could ...
4
votes
1answer
208 views

Difference between registering with ArcSDE and registering with Geodatabase?

As I understand it : Registering with ArcSDE: gives the possibility to ArcGIS to recognize spatial data stored in a database Registering with Geodatabase: makes it possible for data to participate ...
10
votes
3answers
5k 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
580 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
4answers
4k 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 ...
6
votes
1answer
181 views

One-to-many relationship classe(s)/table(s) used for monitoring

I realize that this may be a bit simplistic for this blog, so I apologize in advance. However, for someone with a working knowledge of ArcGIS, I've had issues figuring this out on my own. I have a ...
4
votes
2answers
118 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
4
votes
1answer
146 views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
4
votes
3answers
2k 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 ...
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
288 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
1k 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 ...
2
votes
0answers
214 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, ...
2
votes
1answer
352 views

Is PPDM Lite still available as a Geodatabase template?

I have been looking for a Geodatabase template that conforms to the PPDM Lite standard and believe that one was previously available here. However, that page no longer exists and no Geodatabase ...
11
votes
2answers
752 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
773 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
6k 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
994 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 ...