The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

242 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

Importing XML to specific version of ArcSDE?

I am working in a distributed environment. I've got the data update for a specific version of enterprise geodatabase. Is there any way to import that XML in specific version? We have a province ...
0
votes
0answers
48 views

Foreign key value in destination table is nullified when origin feature is deleted from ArcGIS relationship - workaround?

I have an SDE geodatabase in which I have an origin feature class with relationship classes to several destination feature classes and tables. When a feature is deleted from the origin table, the ...
0
votes
0answers
48 views

Connecting ArcSDE geodatabse 10 from ArcSDE service Version 9.3

I have recently upgraded ArcSDE Geodatabse from 9.3 to 10.0. The applications were using SDE connection through ArcSDE Windows service V 9.3 Now when I tried starting the same ArcSDE windows service ...
0
votes
0answers
21 views

Creating geodatabase, that has all layers used in creating map from different geodatabses?

I have been working on creating a city map, that had layers sourced to different gdbs stored on my desktop, now my final product is ready after 3 months and I have to package the datasets and send ...
0
votes
0answers
77 views

One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
0
votes
0answers
66 views

Using OS authentication for users with period in name when editing PostgreSQL database from ArcMap?

I am trying to set up a PostgreSQL server to integrate our active directory credentials. I can edit the pg_hba.conf file to allow users with an internal IP to connect with OS authentication. host ...
0
votes
2answers
155 views

ArcSDE Enterprise geodatabase compress error

My organisation has ArcSDE enterprise geodatabase(ArcGIS 9.2) with MS SQL Server 2008 as DBMS. When I compress the geodatabase I am getting the follwoing error Failed to compress the database. ...
0
votes
0answers
36 views

Does the geodatabase administrator login rebuild indexes for datasets not owned by the login?

According to the ESRI documentation, the Rebuild Indexes tool is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In ...
0
votes
0answers
19 views

Deleting users and roles on ArcSDE for PostgreSQL geodatabase?

I can easily create users and assign them to roles using the context menus in ArcCatalog or the geoprocessing tools, but how do I delete users and roles? Do I have to go into pgAdmin?
0
votes
0answers
43 views

AddRastersToMosaicDataset_management performs slow

I have an enterprise Geodatabase (SQL Server) on my ArcGIS server machine. I perform my computations on several rasters on another machine (80 *.tif s with mean size of 50kb). When I want to add the ...
0
votes
0answers
27 views

Working with a small spatial extent from a large dataset in ArcMap

I am currently working with large amounts of forest data where surveyors and ecologists measure and assess the quality of the vegetation in the field and send the result as CAD files on a daily basis ...
0
votes
0answers
123 views

Invalid column value

I've been working on a script that corrects some links in a few feature classes in an enterprise database I have. The script works fine for the most part. When it gets to a certain feature class my ...
0
votes
0answers
71 views

ArcMap PostgreSQL unique sequence

I have connected my ArcMap to my PostgreSQL db using the Create Enterprise Geodatabase tool in ArcMap. I have multiple feature classes and the relevant relationships between them loaded into the db ...
0
votes
0answers
50 views

Table sde.state_lineages extremely slow

I'm running a ArcGIS 9.3 Oracle SDE geodatabase. Our ArcMap client is extremely slow at displaying versionned feature class. One table seems to be impacted : sde.state_lineages A simple SELECT * FROM ...
0
votes
1answer
25 views

Releasing user-schema locks when updating user-schema

Putting together a scripted event where we update user-schema (prod) in one sde instance from a dev user-schema instance. Both sdes are Oracle 12c. Replication is not used and the destination ...
0
votes
0answers
51 views

SDE Table Vs Query Table in ArcMap

I have two SQL table with same columns/field name, but when I open both tables in ArcMap it shows different information in Source Tab. SDE table type shows all of the fields where query table type ...
0
votes
0answers
51 views

How to undelete from ArcGIS versioned table?

We have a versioned table of polygons and one of our users have deleted every geometries. With Oracle's SQL Developer, i can see the table still containing the missing data, along with its Axxxx and ...
0
votes
0answers
40 views

Store multiple rasters in an enterprise database, independently

I have a large number of rasters with discontinuous data representing management plans for urban green areas which I want to store in an enterprise database independently. I don't want to mosaic the ...
0
votes
0answers
75 views

Inserting geometry in ArcSDE table?

I have a test point table that created via ArcMap create feature class tool. And I am using ArcGIS 10.5 and PostgreSQL 9.5 database. I am using PG_GEOMETRY. I want to insert a sample point using sql ...
0
votes
1answer
134 views

Create feature class with ArcObjects in SDE geodatabase returns No editable Layer

I Want To create Feature Class in an enterprise geodatabase with ArcObjects. This is the small part of the our plugin. In our case, we want to Create Feature Class in the database Identical to the ...
0
votes
1answer
208 views

How can I set sde object id from QGIS

I have connected a geodatabse that was created by ArcGIS. My geometry type is PG_GEOMETRY. I can connect the database in QGIS and add a feature table as a layer. When I create new spatial data in this ...
0
votes
1answer
105 views

With in Version Difference (DifferenceTypeUpdateNoChange) how to pass IQueryFilter in ArcObjects

I want to know only real shape edits between 2 versions. How can I pass iQueryfilter to DifferenceTypeUpdateNoChange? public void DifferenceTypeUpdateNoChange(ITable sourceTable, ITable ...
0
votes
0answers
122 views

Recalculate XY Extent Option Not Available

I am unable to recalculate the XY extent of a feature class. I am attempting to do so within the Feature Extent tab within the Properties window accessed from ArcCatalog. The Recalculate button, ...
0
votes
0answers
41 views

Update service based on enterprise database

So I have an enterprise database on SQL Server which contains a feature class (only points) I add this feature class to a new ArcGIS Desktop project, so there is only this layer in the project. I ...
0
votes
0answers
83 views

Disabling Login Window on ArcMap?

I would like to know how to disable the login window [PICTURE A] when I start ArcMap ? In the code I am starting ArcMap, but then I get prompted with username and password dialog. How can I disable ...
0
votes
0answers
49 views

View number of edits made in an Enterprise GDB?

I would like to see the total number of edits made in my Default.SDE before the reconcile/post/compress process. I know you can view the number of edits made in versions with the Version Changes tool ...
0
votes
1answer
557 views

Using an ArcSDE Connection through Python

I would like to run a script on a ArcSDE feature class. The script runs perfectly when I hard code a shapefile, but is unable to connect to an ArcSDE database. The purpose of the script is to assign ...
0
votes
1answer
153 views

ArcObjects(Java) - register table to geodatabase ESRI 10.3

We are in need of connecting to the Oracle SDE schema for registering Tables to the sde schema using only ArcObjects(Java) is it possible to do that with no dependency. Assume the geodatabase was ...
0
votes
1answer
71 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
0
votes
0answers
70 views

Return table names for query layers using arcpy

The dataSource property for layers does not return the name of the tables used in query layers. Instead, it returns something like the following: 'Database Connections\\ConnectionFile.sde\\sde.SDE.%...
0
votes
0answers
99 views

Dynamically Create a Foreign Key for Relationship Classes

May be a relativity novice question but my research has turned up no direct answer. I have a feature class of land owner parcels that I would like to preserve its schema. I would like to add fields ...
0
votes
1answer
17 views

TableSet Imported to Table of Contents

If I have a SDE table view between two Feature Classes am I able to drag and drop into ToC or will I have to create a feature class of the tableset? The files are in a SDE database. I would also like ...
0
votes
0answers
38 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
0
votes
0answers
128 views

View Oracle GeoRaster in ArcMap

I have imported SRTM DEM into Oracle 11g using FME.The block size is set to 128X128.I am able to view the data in QGIS,Tatuk and play with it using GDAl command line.Unable to view the same in ArcMap. ...
0
votes
0answers
279 views

Using Geometry commands in MS SQL Server 2008?

I am looking to find the most effect way to use SDE and ST_Geometry SQL commands. Can anyone tell me how/what commands I might use to perform a spatial query in MS Sql Server 2008, to Select ...
0
votes
0answers
27 views

Why can I see the data from a second sde database connection in my database?

I have an sde 9.3 database which when opened in arccatalog shows the data from another sde database. Under settings > Source this is confirmed. Why and how can this happen? The only thing the 2 ...
0
votes
0answers
618 views

Changing layer from ArcSDE connection to file geodatabase using ArcPy?

We are copying data from our corporate office to field offices and we are creating a file geodatabase at these field offices. We are copying the layers that point to sde and they need to point to the ...
0
votes
0answers
300 views

SDE Connection raise exception

I am supporting a .NET code that is running on ArcGIS Server 10.1, and communicating with ArcSDE Application Server 9.3 There is part of the code that is doing long loop. And when it comes back to ...
0
votes
0answers
621 views

Configuring image popups in a Silverlight application

My Silverlight application contains a points layer which contains paths to a folder of geotagged photos. These points were generated using the GeoTagged Photos to Points tool. I chose not to import ...
0
votes
1answer
55 views

How to import data (with schema) from MSSQL to PostgreSQL?

I have an ArcSDE enterprise geodatabase in MS SQL Server 2008. I want to replace MS SQL Server with PostgreSQL. I have setup and created the enterprise geodatabase in PostgreSQL and now want to ...
0
votes
1answer
104 views

ArcSDE to Shapefile Async in .NET

I have a question about exporting an (versioned) featureclass stored in a ArcSDE geodatabase to a shapefile with VB.Net. I've created the code which I think should work fine, but ArcObjects "says no",...
-1
votes
1answer
24 views

Featureclass from dev env to test env

I am new to GIS. I have created a geodatabase. And inside this geodatabase i have created a feature class, i created a mxd file to publish feature service. Since this was all in development ...