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

7
votes
1answer
130 views

How to split Relationship Class privileges between different users while maintaining referential integrity?

I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' ...
6
votes
4answers
9k 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 ...
6
votes
2answers
4k views

What are spatial and attribute indexes in geodatabases?

What is the difference between a spatial index and an attribute index in an ArcGIS geodatabase? What are their purposes?
6
votes
5answers
2k views

How to process large shapefiles faster in ArcGIS for Desktop?

I have huge line and polygon shapefiles that I want to edit with some geoprocessing tasks (clip, buffer, erase,...). Altough my computer is not that slow, I am annoyed of waiting up to 15 hours for ...
6
votes
3answers
10k views

subtypes vs domains

No luck on the Esri forums, so I thought I would try here. I was trying to determine the best way to standardize my attribute table. I thought first I would just use a coded value domain but I am ...
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
4answers
2k views

Count number of attributes for unique field values in ArcGIS for Desktop?

Running ArcGIS 10.1 for Desktop, I have two feature classes in a geodatabase. One is a point FC for polling stations, the other is a polygon FC for states. The polling station FC contains over 1000 ...
6
votes
4answers
1k views

difference between Simple and Attributed relationship classes?

In the esri geodatabase, what is the difference between Simple and Attributed relationship classes?
6
votes
4answers
417 views

Storing ArcObject inside BLOB or XML field of geodatabase?

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 IFeatureRenderers inside these fields. ...
6
votes
3answers
799 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 ...
6
votes
2answers
1k 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
5answers
3k 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 ...
6
votes
2answers
8k 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 ...
6
votes
2answers
1k views

Inserting table record without geometry into feature class using Python?

I am working with ArcGIS and Python and trying to append table rows into a feature class. You cannot use append and you cannot just make a table view of the feature class and then try to append it ...
6
votes
1answer
853 views

Is this possible with ArcGIS using replication?

I work for a telecom company dealing with fiber management. We have a sister company south of us who we share some fiber and fiber equipment with. Both of us will be using ArcSDE databases. We want ...
6
votes
1answer
1k views

FME - Can I write back into my original file geodatabase

I have a gas pipeline network which I have stored in an File Geodatabase as polylines. I've created an FME workspace to split the pipelines at fittings (valves, reducers, tees, etc) which are stored ...
6
votes
2answers
574 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 ...
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 ...
6
votes
1answer
217 views

How is IValidate.GetInvalidRules supposed to work?

we are currently trying to programmatically validate features against geodatabase-defined rules. This includes attribute rules as well as connectivity and relationship rules. We have consulted the ...
6
votes
1answer
580 views

Can I update features in an SDE database from python without using an ArcEditor License?

I have a non spatial data set that I would like to keep sync'ed in SDE as a spatial set. So I would like to be able to insert, update, and delete without using one of my two ArcEditor licenses since ...
6
votes
1answer
244 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 ...
6
votes
2answers
1k views

GIS Database Migration Project (Oracle to ArcGIS)

I have been tasked with converting an Oracle Database into an ESRI file geodatabase. The data represents a gas network. The client's Oracle database has over 400 tables, 120 of which are spatial. ...
6
votes
2answers
321 views

Modelbuilder Workspaces: Defaults to a folder, would like it to be a geodatabase

I'm having an issue with modelbuilder workspaces. I have created a simple model to clip a raster, run focal statistics on it, and create contours. I have a workspace variable as an input. If I run the ...
6
votes
1answer
383 views

When to use multiple geodatabases?

I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
6
votes
2answers
413 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
6
votes
1answer
407 views

Changes in synchronized replica not shown in ArcMap or ArcCatalog without refreshing

I am synchronizing a one-way replica in ArcEditor using Python. I tried adding RefreshActiveView and RefreshCatalog to the code, but I still need to refresh the synchronized database to see the ...
6
votes
1answer
439 views

Automated geodatabase replication with offline editors

I would like to design an application that would use an SDE database with simple features and a geometric network. That geodatabase would then be replicated out to any number of personal geodatabases ...
6
votes
2answers
214 views

Survey Data to GIS database

This is a General Question on a possible workflow for Survey Data directly to ArcGIS In most GIS/Survey workflows there is a field collection team and backoffice GIS team. When the availability of ...
6
votes
0answers
244 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE ...
6
votes
1answer
424 views

Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase

I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
5
votes
5answers
4k 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 ...
5
votes
4answers
3k 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
3answers
423 views

Using batch files with geodatabases?

I hesitated a bit before asking this, as it isn't necessarily a GIS specific question, though I'm using it to update geodatabases. I have found plenty of hits on a Google search, but frankly, many of ...
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 ...
5
votes
1answer
274 views

When is it better to use 64 bit File GDB access?

The beta 2 release File Geodatabase API includes 64 bit support. Esri says arcobjects is still the "preferred" method to interact with the file gdb. However, arcobjects has no 64 bit support. ...
5
votes
2answers
449 views

How can a 9.2 user access a geodatabase created in 9.3?

I have a colleague that uses 9.2 and has access to our server in which I have multiple geodatabases that were created in 9.3. Is there any way for her to access the data?
5
votes
2answers
1k views

arcpy - how to check if a domain contains a particular coded value?

How can I check if a domain contains a particular coded value? How to check if domain already exists? shows how to verify whether a domain exists in a geodatabase. However, I can't see how to check ...
5
votes
4answers
2k views

Does File Geodatabase performance degrade as it fills up?

I'm having a memory leak issue. Upon investigating this more, it seems the file based geodatabase I write to in a loop, is growing very large, and as it grows, it significantly degrades the ...
5
votes
1answer
648 views

Determining ESRI File Geodatabase release version?

Is there any method in Python, ArcObjects, or the File GDB API for determining the release version (9.3, 10.0, etc.) of a file geodatabase? There is a need to find all of our shared 10.0 version file ...
5
votes
1answer
209 views

Implementing INSPIRE Metadata with Geodatabase

I would like to begin by saying that I have never implemented INSPIRE metadata with my spatial datasets before. I am undertaking a project which requires my geodatabase metadata to be in the standards ...
5
votes
2answers
1k 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 ...
5
votes
2answers
1k views

60GB .gdbtable file in my file geodatabase – what is it, and can I delete or make smaller?

The title says it all really – I have a single file named 'a0000000.gdbtable’ in my default file geodatabase that is 60 GB in size. I have a number of other files with .gdbtable extension that aren't ...
5
votes
1answer
1k 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 ...
5
votes
3answers
4k 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 ...
5
votes
2answers
542 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.
5
votes
2answers
877 views

How do I convert many .dxf files to one gdb file?

I am using ArcView and ArcCatalog 9.2 with the Data Interoperability extension and I have 159 .dxf files that are comprised of 6 files; a dessin DAO, an annotation DAO, a multipatch DAO; a point DAO, ...
5
votes
2answers
2k views

Geodatabase to PostGIS character encoding

Similar to another question I posted previously, I'm trying to import datasets from Esri geodatabases into a PostGIS database directly, and inside the data there are greek letters and symbols that are ...
5
votes
1answer
534 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 ...
5
votes
2answers
864 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 ...
5
votes
1answer
1k views

How to load mdb geodatabases in QGIS for MAC?

I've been unsuccessfully looking for a way to add data from a .mdb geodatabase into QGIS for mac. Using the add vector layer, .mdb is not available in the filetypes, and in the database connection I ...