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

1
vote
3answers
2k 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 ...
1
vote
1answer
310 views

How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?

I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
1
vote
0answers
322 views

Can feature layer in MXD with joined data from non-geodatabase be published as feature service?

I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
1
vote
1answer
372 views

fail to create relationship class

I am trying to make a relationship class between two tables, but I get this message at the end: " Failed to create the specified relationship class". Can you tell me why? Thanks, Ligia Sorry I ...
2
votes
1answer
448 views

Subtypes in ArcGIS

I've created a subtype field in my attribute table, but now I want to change the codes. How do I do that? ArcCatalog doesn't enable editing my subtype. Thanks for help.
2
votes
4answers
915 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
0answers
153 views

Opening File GDB in Samba throws exception - but only in VS2010 debug mode

I'm accessing a file geodatabase through a mapped network drive pointing to a unix machine running Samba. When I start the app from within VS2010, I get a COM exception when I attempt to open the ...
2
votes
1answer
507 views

How to switch to a GDB created in the middle of a script

EDIT: Here's my full script and hopefully a better way of explaining what I need done: #Import import arcpy, sys, os # Set environment settings arcpy.env.workspace = sys.argv[1] inFiles = ...
17
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 ...
18
votes
2answers
16k 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 ...
3
votes
1answer
866 views

IFeature.set_Shape The coordinates or measures are out of bounds

I'm trying to add a point to my map, but something with the way I used shp2sde create caused me to have a incorrect spatial extent or something. So I'm getting "out of bounds" error. How do I go ...
2
votes
1answer
394 views

Shapes of this entity type not allowed in this layer when CreateFeature() is called

I have the following code that calls on a remote geodatabase server. Everything is connected and working, but when I try to add a point and use featureclass.CreateFeature();, it shuts down. At first ...
1
vote
0answers
279 views

Does anyone know a script to make annotation & point data remain constant regardless of scale

I have a series of maps to create for a project (30+ maps). The maps will be at varying scales (roughly between 1:1000 and 1:6000). I have a geodatabase containing various annotation and point ...
0
votes
1answer
325 views

How to update raster or feature layers being used by ArcGIS Server by a Model

I have a mxd file that contains a few raster and feature layers that was published by ArcGIS Server as a map service. Meanwhile, a model was created to update the contents of the raster and feature ...
4
votes
2answers
386 views

Failure to Delete Vector File from Personal Geodatabase - ArcGIS 9.3

I have a personal geodatabase - based on an MS Access .mdb file - from which I cannot delete an old feature class. The tables relating to the feature class have been deleted from the .mdb, but the ...
0
votes
2answers
1k views

Enabling SQL Server 2008 database to access it as Esri geodatabase via ArcSDE using ArcGIS 10.0?

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is). I'd like to convert them to geodatabases, first that 'MS SQL Server 2008', then Oracle. So, leave Oracle for a ...
7
votes
2answers
1k 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
5k 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
1k 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
103 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
805 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
183 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
913 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
124 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
211 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. ...
10
votes
4answers
1k 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 ...
8
votes
4answers
10k 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
938 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 ...
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 ...
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
302 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
122 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
234 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
824 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
741 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
630 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
333 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
313 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
476 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
141 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
485 views

Why does Erase give ERROR 999999 (Error executing function Invalid Topology Negative point valence)?

I am getting the following error when I try to erase a set of data from a file within a gdb. Any idea on what to do? I have done repair geometry multiple times on the input/erase datasets. I have 16GB ...
2
votes
2answers
165 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 ...
1
vote
2answers
194 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
317 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 ...