ESRI geodatabase is a particular database schema designed by ESRI for managing "layers", "versioning", "topology" and other ESRI application specific storage requirements.
6
votes
1answer
106 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
1answer
181 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 ...
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
2answers
172 views
Which free/cheap tools can open ESRI Geodatabase Files?
Ok I don't need anything advanced, I just don't know anything about this GIS business. I'm trying to get local parcel information and the government site states it is in "ESRI geodatabase format." ...
5
votes
1answer
235 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
353 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
1answer
86 views
How much database bloat is reasonable?
I use personal geodatabases to hold all the data for my projects (probably around 10-20 feature classes across 2-4 datasets on average). I use the personal gdb because I like being able to hook into ...
5
votes
2answers
134 views
How can I find out Persional GeoDatabase version?
I am working ArcMap software. How can I find out Personal Geodatabase Version?
I have client file. But I want to find out which version they have to used.
I am looking for your guidance
5
votes
2answers
625 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
4answers
4k 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 ...
5
votes
4answers
996 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
2answers
2k 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 ...
5
votes
2answers
253 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
1k 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
2answers
781 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 ...
5
votes
1answer
79 views
What is a good way to share a GeoDatabase over the internet?
I've got a large, greater than 10 GB, File GeoDatabase on a remote server. I created this GeoDatabase some time ago and am looking to have local access to it. Now I can't simply burn it to a disk or ...
5
votes
3answers
442 views
How do I render data quicker in Arcmap?
Is there a way around to speed up the data into ArcMap ? When I converted the raster to polygon and some data would load up quicker and some other load slow. I am wondering if I could add the spatial ...
5
votes
1answer
428 views
Issues Accessing ESRI File Geodatabase within Quantum GIS Desktop
I am trying to access ESRI file gdb from Quantum GIS. I am on Windows 7, 64-bit. I have found many useful threads on how to set up this functionality within Quantum GIS. The method I went for is ...
5
votes
1answer
95 views
How to Add FileGDB driver to PyGDAL installation
I installed ArcGIS 10.0 and it installed Python 2.6.5 with it. Later, I installed pyGDAL using the windows installer within that Python installation. I cannot find a specific place where GDAL is ...
5
votes
0answers
97 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 ...
5
votes
0answers
149 views
Plugin Workspace: when to close an OleDbDataReader?
I'm developing a plugin workspace for ArcGIS. Internally, the plugin uses an OleDBconnection. All of the sample code I see seems to stress the importance of closing and disposing the connection.
...
5
votes
0answers
117 views
Applying schema changes on a esri geodatabase two-way replica set
I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica ...
5
votes
1answer
159 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 ...
5
votes
2answers
343 views
How to convert high precision dataset to low precision
A high precision dataset was loaded from a file geodatabase into arcsde 9.3.1. The dataload was achieved by copy/paste in ArcCatalog.
A custom tool (arcobjects) that extracts from the dataset to a ...
4
votes
2answers
1k views
What are spatial and attribute indexes?
What is the difference between a spatial index and an attribute index.
What are their purposes?
4
votes
3answers
3k 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 ...
4
votes
3answers
300 views
Looking for good resources for batch files in relation to databases/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 ...
4
votes
3answers
1k 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 ...
4
votes
4answers
285 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 ...
4
votes
2answers
482 views
How to programmatically work with featureclasses from multiple geodatabases?
I have produced a Python script which creates multiple buffers of specific (listed) featureclasses within a geodatabase. This is achieved by running each feature through a for loop.
I would like to ...
4
votes
1answer
333 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 ...
4
votes
2answers
98 views
Can you create feature classes with the same name in different feature dataset
I've searched but can't seem to find any info on this which is surprising as this should be an easy one to answer.
I'm using ArcGIS 9.3 and trying to create a feature class called 'cadastre' in ...
4
votes
5answers
1k 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 ...
4
votes
3answers
3k 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 ...
4
votes
4answers
294 views
Record Date and User for an edited feature
The client has a Feature Class in SDE 9.3.1. When a feature in the feature class is edited the client wants to automatically record the date/time and who edited it in the feature class attributes.
...
4
votes
3answers
244 views
Modeling a GeoDatabase for whole world
My recent assignment is to model a multi-user geodatabase for the whole world using the ESRI platform. This geodatabase contains administrative layers and topographic layers. The schema is to be ...
4
votes
2answers
63 views
Duplicate an in use GeoDatabase
I'm wondering if there is anyway to duplicate an in use ESRI File GeoDatabase.
The GeoDatabase I have is being used by ArcServer for a few of our web mapping applications. Now I understand I could ...
4
votes
2answers
162 views
Calculate Field based on field value in a second table
I have a table in a MSSQL Server Enterprise SDE database. I need to join a table from a MS SQLExpress Workgroup SDE database and then calculate 11 fields in the Enterprise table based on values in ...
4
votes
1answer
1k views
Export all coded value domains from a geodatabase
On the ESRI-L mailing list this morning there was a question about how to see or export all the coded value domains for a geodatabase. The goal is to present the content of the domains in a tabular ...
4
votes
2answers
405 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 ...
4
votes
1answer
89 views
Importing legacy shapefiles and attribute information to geodatabase
I am trying to take older sewer/water system shapefile data with limited, but important attribute information and importing it in to a feature class in a geodatabase, while keeping the attribute ...
4
votes
2answers
479 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 ...
4
votes
3answers
63 views
How to transform FileGDB featureclasses from custom local coordinate system?
Background: Started working for company that is in middle of system-wide IT upgrade including GIS data. Existing in-house data is in a FileGDB, is in an assumed coordinate system and represents 1000 ...
4
votes
1answer
172 views
String format for geodatabases in ArcPy scripts
Several ArcPy functions take strings as geodatabase identifiers. I've looked through the ESRI docs, but can't find a good reference for the various acceptable formats. I'm looking for examples of ...
4
votes
1answer
1k 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 ...
4
votes
5answers
2k views
How do I build a form within ArcMap?
I am building a file geodatabase using ArcGIS. The gdb is going to be distributed to dozens of 'stand alone' machines. End users are expected to populate the gdb with data. End users do have ArcGIS ...
4
votes
2answers
145 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. ...
4
votes
1answer
337 views
python crashes creating many Feature Classes in multiple Feature Datasets
I'm trying to populate a Geodatabase with roundabout 60 Datasets with a new Featureclass for each Dataset. To do this, i wrote a python-standalone-script that loops through these datasets and creates ...
4
votes
1answer
114 views
Attribute Indexes ArcSDE 9.3.1 for Attribute Joins on GUID field types
I create my joins on primary/foreign keys that are guids...I don't seem to be able to create an index on this field in my target table. After joining to this table it takes 4 minutes to open the ...
4
votes
1answer
216 views
Geometry storage type in geodatabase Oracle 9i with SDE 9.3.1
How do I identify what geometry storage type is being used with a specific geodatabase? Thanks.
