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

8
votes
2answers
2k views

Automatic batch update a file geodatabase from shapefiles

Every week I need to update the same shapefiles that are used to produce up to date maps. The files are downloaded from 3 different web-servers. The thing I want to do is to have a script that can ...
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
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 ...
4
votes
1answer
2k views

How to list all of the contents of a geodatabase with arcpy?

This seems like a simple problem, but I have not found a way to accomplish it. I am writing a script that needs to record the paths of everything inside of a geodatabase to a text file, and later copy ...
1
vote
2answers
105 views

Split a Quad to 1:7,500 Question

Here I have 1:24,000k quads. I know how to use the word split toolbox. What I would like to split 24,000K to 1:7,500 or 6,000k. Is there a way around for me to do that ? For example,, if you have one ...
2
votes
1answer
936 views

Exporting PostgreSQL table to FileGDB: wkbUnknown layer geometry type

I'm attempting to export a PostGIS (1.5.3) database table as a File geodatabase using the new FileGDB OGR / GDAL 1.9.0 driver: $ ogr2ogr -overwrite -sql "SELECT * from db_pts LIMIT 1" \ -f ...
3
votes
1answer
195 views

How do you disable archiving for a table?

I would expect to have a Disable Archiving... like I do for a featureclass. But for a table, the Enabled Archiving menu-item is grayed out. Here's the menu for a table: And here's the menu for a ...
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 ...
3
votes
3answers
2k 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 ...
4
votes
1answer
127 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 ...
0
votes
1answer
220 views

Insert cursor raises exception on geodatabase

world, I'm having trouble to insert a line geometry into a personal geodatabase (using Python/ArcGIS 9.3.1). Everything works fine if the target feature is a shapefile. My guess is that calling: ...
5
votes
3answers
1k views

How to repair paths of an unmanaged raster catalog in file GDB?

I'm using ArcGIS 9.3.1 and I have an unmanaged file geodatabase with raster catalogs in it. Tiles are loaded inside the catalog and each tile has a "Full Path" property which is environment specific. ...
12
votes
4answers
13k views

How do I change the data source for all layers in an MXD?

I have an MXD. It connects to about 30 layers in one of our SDE databases. I want to change the SDE database they connect to. Is there a way to do this without having to right-click every layer and ...
3
votes
1answer
1k views

How to edit a given version of geodatabase?

I have a versioned geodatabase. Any of that versions are used only by one user. So then user called "XXX" has a version called "XXX". So then now I want to make a changes on given version, but when I ...
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 ...
5
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 ...
1
vote
1answer
1k views

Add Spatial Database Connection fails?

I created a Database Server (SQL Express 2008.) I created a "New GeoDatabase..." I double-click on "Add Spatial Database Connection." I fill out the dialog and change the transactional version. ...
1
vote
2answers
376 views

How to project ECW with FME?

I would like to project ECW + MITAB with FME to Geodatabase. For example, i have the header MiTab: !table !version 300 !charset WindowsLatin1 Definition Table File "7007_0652_0656_A08.ecw" ...
1
vote
0answers
123 views

ArcGIS, clip issue when using a PGDB

When I clip PolylineMZ feature class inside a Personal Geodatabase it gives odd results for vertices. Vertices are horizontally shifted and do not corespond with original. When I do this in .shp, ...
3
votes
1answer
261 views

SDE Topology dirty areas don't go away

Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...
0
votes
1answer
871 views

Why “DataBase Connections” mapped to “Dataset DataBase Connections” in ArcCatalog?

I am trying to Export data from a geodatabase by a existed sde file(created by ArcCatalog), the Error Messges: Executing: ExportCAD 'DataBase Connections\Connection to ...
6
votes
2answers
895 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
699 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 ...
1
vote
1answer
381 views

How to Create and Rotate Raster Dataset using ArcObjects?

I'm following the "How to create a raster dataset" tutorial: http://help.arcgis.com/en/sdk/10.0/arcobjects_net/conceptualhelp/index.html#//000100000464000000 The questions are: 1) How can I create ...
1
vote
3answers
2k views

How to merge several tables/feature classes into single geodatabase object in ArcObejcts?

My project is ArcGis extension, which uses a specific set of tables and feature classes. I want that this structure to behave like single geodatabase object, so user cannot delete part of it's schema. ...
6
votes
1answer
364 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
1answer
509 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 ...
1
vote
1answer
2k views

Converting Microsoft Visio 2007 .vsd file to xml workspace document (without the macro)

I was just editing my geodatabase schema in Microsoft Visio and noticed that it is the new 2007 version, rather than 2003 which had a handy export tool, therefore I downloaded the ESRIExportToXML ...
4
votes
1answer
148 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 ...
2
votes
2answers
174 views

Understand and use user provided file structure

I have at my disposal a folder with data provided to me by a person that knows nothing about GIS. I have the impression that its file structure was generated by some esri desktop product. I have only ...
2
votes
2answers
214 views

Moving data from columns in a table to rows by a key field?

I would like to shift data found in a column to a row by Key field. I have a table, within a geodatabase, set up similar to what's below. KEY_ Value 123 Yellow 123 Blue 456 Red 456 ...
2
votes
1answer
370 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 ...
3
votes
2answers
2k views

Adding rows of data to a non-spatial table in ArcMap with a SDE SQL Server for Metadata purposes

I'm attempting to use several non-spatial tables to better organize the large set of feature classes I continually add to a SDE Geodatabase (SQL Server Express). So I have several tables setup and ...
8
votes
5answers
9k 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 ...
1
vote
1answer
1k views

How to import/copy geodatabase schema from multiple tables to a single table

I have an existing ArcGIS 10 geodatabase which has a complicated schema containing multiple tables and joins, and I wish to simplify this for faster web delivery. For example, Featureclass1 is ...
4
votes
1answer
291 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.
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 ...
17
votes
8answers
6k 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 ...
4
votes
1answer
2k views

How to let ArcGIS Server see related records in a geodatabase

I have an ArcSDE geodatabase which contains multiple relationship classes. If I add this layer to ArcMap, the relationship is automatically applied (eg, the Identify dialog allows me to drill-down to ...
1
vote
0answers
458 views

Exporting layer selection to a file GDB

I have over sixty layers in a map. These are all grouped by categories. I am trying to figure out the best way to export all the layers for a given selection to a file geodatabase and also maintain ...
3
votes
1answer
1k views

Referencing Feature Dataset in File Geodatabase with ArcPy

It's probably an obvious one but since I'm new to arcpy I'd appreciate any help. I'm trying to develop an arcpy script which will eventually loop through number of rasters and feature classes stored ...
4
votes
5answers
997 views

For a ESRI Geodatabase Feature Class, which table holds the spatial reference?

For a shapefile, the spatial reference / coordinate system information is held in the .prj file. I would like to know which file or table in a geodatabase holds the equivalent information for a ...
3
votes
1answer
540 views

Working with temporary files in ArcObjects using Geodatabases?

My current add-ons rely on shapefiles for working with temporary files. For example, if I run a spatial analyst tool, I create a new shapefile to store the output geometry. ArcGIS stores all temporary ...
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 ...
6
votes
3answers
7k 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 ...
3
votes
3answers
538 views

How to set up a Revision Control for ESRI File Geodatabase?

I'm interested in doing revision control (Mercurial) on some file geodatabases. Does anyone have an idea of which files are important (need to be saved) and which can be ignored? Note that I'm not ...
1
vote
0answers
399 views

Intersecting with Geodatabase.ISpatialFilter - no results

I'm trying to intersect two layers and get resulting features with the following code I've written: ESRI.ArcGIS.Geodatabase.ISpatialFilter spatialFilter = new ...
7
votes
2answers
278 views

.Net Solution Structure for ArcObjects and Geodatabase programming

OK - I understand that this is a bit subjective - but you're the best community forum I've got! So, we are talking about starting a fresh customisation for ArcGIS or a Windows app using Engine. I ...
2
votes
2answers
195 views

How to store large amounts of text in an SDE table

I need to store a lot of text in a field in an SDE registered business table (an ITable, not a featureclass) - let's say 10,000 words roughly. I am using Oracle 10g and ArcSDE 9.1. I am programming ...
3
votes
2answers
702 views

How to use the ISpatialFilter interface with ArcGIS 10.1?

From what I've heard till now: 1) ArcGIS from version 10.1 and forth will only support http connections: local connections will not be supported any longer. 2) The code ESRI.ArcGIS.Carto.IMapServer ...