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

3
votes
1answer
899 views

Can you create a ArcGIS 9.3 esri-geodatabase in ArcGIS 10?

Dooes anyone know if it's possible to create a v9.3 geodatabase from ArcGIS 10? Opening them is not a problem, but I haven't found a way to create one without going back to 9.3 and doing it there.
3
votes
1answer
1k views

how to grant permission in SDE geoDB,when layers are inside a geometric network

When I use sdetable command to grant pemission to a table that located in a SDE SQL server geodatabase it works properly,this table is a non-spatial table which is in geodatabase immediately,I mean ...
3
votes
1answer
2k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
3
votes
2answers
262 views

Explicitly locking a file geodatabase

I need to lock a file geodatabase (or only a single Mosaic dataset) at the beginning of a python script (and release it in the end).. I looked and looked and couldn't find any explicit arcpy command ...
3
votes
1answer
175 views

Synchronizing Changes From File Geodatabase to SDE Geodatabase

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
3
votes
1answer
104 views

How to validate Personal Geodatabase against XML schema?

Is their any tool in arcgis model builder which can validate a personal geodatabase and a XML schema to give out an report saying if the gdb is validated or not ...
3
votes
2answers
276 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

Where is connection file used to connect ArcMap to ArcSDE?

In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008? Some non administrative users are hooking up to SDE as the user 'sde' with db ...
3
votes
1answer
972 views

ESRI File Geodatabase - Trying to use CURRENT TIME in Definition Query

Is it me, or are the date functions in the file geodatabase a total nightmare. Anyway, I am trying to set up a fairly simple definition query that contains a subquery with a date comparison. My ...
3
votes
1answer
178 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 ...
3
votes
3answers
1k 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 ...
3
votes
2answers
2k views

Reading Coded Domains from ArcSDE 10 RDBMS using SQL/ADO.net

I need to read ArcGIS Domain Coded Value pairs (value/description) from SQL Server / Oracle in SQL (i.e. not using ArcObjects). This is an XML field. I can get the domain definition thus select ...
3
votes
1answer
1k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
3
votes
2answers
291 views

Getting line FID from polygon ITopologyGraph

I want to export polygon Arc list to txt file for that I created topologygraph for personal geodatabase feature class (polygon) using ITopologyGraph::build. I got polygon FIDs but I am not getting ...
3
votes
2answers
251 views

What is ArcCatalog?

What is it, what does it do, and how is it related to geodatabases?
3
votes
2answers
380 views

How to add data to relationship table in ArcGIS 10.1 database design?

I have created 2 tables HORSE and VENDOR and a relationship table VENDOR_HORSE With the foreign key in Horse being the Primary key in VENDOR (VendorID) and the foreign key in VENDOR being the primary ...
3
votes
1answer
361 views

How to Create a Version 10 File Geodatabase from an XML from ArcGIS 9.2?

A client has given me an XML document for the schema of an ArcGIS 9.2 Geodatabase. The final goal will be to create a version 10 version of the geodatabase but the client doesn't have version 10 yet. ...
3
votes
1answer
247 views

Using CAST function in ArcMap 10 with ArcSDE?

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
3
votes
2answers
1k views

Merge an entire Geodatabase in ESRI ModelBuilder

How can I merge an entire Geodatabase in the ESRI (ArcView) ModelBuilder? I have several FeatureClasses created into the GDB and in the model I plan to merge them all. Right now I have imported all ...
3
votes
1answer
170 views

Append feature layer from one personal geodatabase to another using .Net

I currently have a client that still uses personal geodatabases (Access files). I currently have to open up ArcCatalog and manually append any FeatureLayers that are contained in the original personal ...
3
votes
1answer
293 views

Deleted features not synchronizing in one-way (ArcSDE to File Geodatabase) geodatabase replication?

I am testing three one way (ArcSDE 10 -> File Geodatabase) replicas. Each replica is derived from a layer created by selection by location from a citywide road dataset, so that each of the three ...
3
votes
1answer
1k views

How do I copy the coded value for a field and not the raw value?

I am working with ArcGIS 10 and I have added a field in a feature class and am attempting to copy the text from another field's coded values, but the field calculator is simply copying the "code" text ...
3
votes
1answer
835 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 ...
3
votes
2answers
351 views

Locks not being released in Linux held File Geodatabases

We have a system with 2 SOC servers, and one SOM server, acting on a shared storage area. We have had performance issues for years, and believe we have worked out why. There are several file ...
3
votes
1answer
1k views

How to create Stored Procedure in versioned SDE_SQLServer geodatabase using DDL?

I've almost used SQL server_SDE geodatabases for 3 years in GIS projects and I don't know how can I create a stored procedure in geodatabase.I use ESRI case tool to create a geodatabase in ...
3
votes
5answers
3k views

How to re-enable coded value domain descriptions?

I have got a Personal Geodatabase with a feature class and several coded value domains. Domains are assigned to some of the attributes of said feature class. Domains are correctly defined and match ...
3
votes
1answer
204 views

Triggers for delta tables

I have been facing an issue to capture the delta updates on SDE. We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
3
votes
2answers
463 views

Execute SQL in File Geodatabase

Is there a way to execute SQL queries on file geodatabase from Python? I'm looking for the same functionality provided by arcpy.ArcSDESQLExecute for SDE databases. Thanks,
3
votes
1answer
200 views

Pdf layers to Geodatabase

We had a drawing as a PDF , with Geolocation and layer information available. We tried to export that as an Xml ( current tree) option in Adode reader and tried to import it in a new File geodatabase. ...
3
votes
2answers
213 views

Running Regular Queries Through ArcSDE

Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
3
votes
1answer
961 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
2answers
254 views

Geocode a table, then append more rows to the table

I'm starting on a project with ArcGIS 10 where I'll be doing quite a bit of geocoding addresses. I understand the basics of how to do that. But a frustration on an earlier similar project is that ...
3
votes
1answer
93 views

How can I have my map open in the center of my visitors IP address?

I have a map of all restaurants in Florida. I would like to have the center of the map be the address of the visitors IP. How can I do this?
3
votes
1answer
891 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 ...
3
votes
1answer
220 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 ...
3
votes
2answers
1k 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 ...
3
votes
2answers
240 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 ...
3
votes
0answers
129 views

ESRI geodatabase, Oracle spatial performance

We are storing data in a Geodatabase on Oracle 11g using Oracle Spatial with SDO_Geometry, and then consuming that using ArcGIS server 10.2.1. The performance is very slow, because we are talking ...
3
votes
0answers
137 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
3
votes
1answer
125 views

Shp to featuredataset (GeoDB)

I'm trying to import a shapefile into a featuredataset under a geodatabase using FeatureDataConverter.ConvertFeatureClass. All the examples that I found are not concerning the import under an existing ...
3
votes
0answers
149 views

QGIS does not read ESRI Geodatabase correctly

I have a geodatabase from the EPA that does not seem to me reading correctly with Quantum GIS. When I open the attribute table the first two columns have the same data. The first column is CERCLA_ID ...
3
votes
0answers
838 views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
0answers
92 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' ...
3
votes
0answers
1k views

How to open a file geodatabase with tables and relationships in QGIS?

How can I open or connect to an ESRI file geodatabase in QGIS? I don't want to only see the features (shapes), I want to make sure that tables and relationships are opened correctly, too. Thanks in ...
3
votes
0answers
56 views

ESRI Maps with Ravis Visual graph

How can we integrate ARCGIS maps with Ravis Birds eye's Visualgraph ? My intension is to place the ravis visual graph over the map and the nodes of the visual graph must be placed on their specific ...
3
votes
2answers
627 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 ...
3
votes
3answers
230 views

Is there any way to write a snipet of code with function of “SDELayer -o register” command

I try to create a geodatabase using some SQL command and then register some tables of it with SDE. I create an empty geodatabase using sde post installation and then create tables and other database ...
2
votes
2answers
234 views

Problem with Coordinate Tolerances when I export my .shp files to .mdb

When I export my shapefile to a personal geodatabase using ArcMap, the result is not the same as the original database. I do not know how to solve this problem.
2
votes
4answers
840 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 ...
2
votes
2answers
471 views

Migrate from ArcGIS 10.2 GDB to 10.0

I need to export data from an ArcGIS 10.2 File Geodatabase (GDB) to an older version, so that users running an older version can access the data. Similarly, I would like to save a .mxd file to an ...