Questions tagged [enterprise-geodatabase]

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

259 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

Database Population in wrong Authentication Type

I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
0
votes
0answers
18 views

Recalculate extent for versioned featureclass

I try to recalculate extent for FC (versioned). I deleted some objects with null geometry, or with wrong location and reconcile every versions. But I still cannot recalculete extent to new proper ...
0
votes
1answer
50 views

Slow SDE Performance After Append - Geometric Network

I had an odd thing happen today, I do almost daily appends to our fiber network (fiber, splices, etc) and usually, it goes smoothly and with no complications. For some reason, I had an Append stall ...
0
votes
0answers
32 views

Getting SQL explain-plan for ArcGIS Map service

My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse. I'm having some performance issues with the layers/views in the map service. I want to ...
0
votes
0answers
29 views

Creating database connection using ArcCatalog

I'm using ArcCatalog 10.2.2 which is installed on a Windows 2019 Server OS. I'm having trouble creating a database connection. Usually this is a very straight forward process. Put in the server name ...
0
votes
0answers
41 views

Select list of tables and feature classes that have subtypes?

I have tables and feature classes in an Oracle 12c geodatabase (10.7.1). I would like to generate a list of tables and feature classes that have subtypes defined in them. Is there a way to do this ...
0
votes
0answers
23 views

Creating features from related table

I have a M-1 related table (Sales) and a Polygon feature (Parcels) I want to create a point feature for the sales. If I join to the Parcels I only get the first sale to join but I need all of them. ...
0
votes
1answer
17 views

Converted timezone does not display properly in ArcMap

(Oracle 12c geodatabase) I have a view that converts a UTC timestamp to Eastern Time using the from_tz function: create or replace view test_vw as ( select cast(rownum as number(38,0)) as ...
0
votes
0answers
29 views

Selecting using edit tool in ArcMap

I am using ArcMap 10.3.1. When using the edit tool in an edit session to select features and move them, I see the following symptoms: The edit tool draws the rectangle, the attributes briefly show ...
0
votes
0answers
46 views

Get current data source of MXD file

I have a number of MXD files with data sources linking to an Enterprise geodatabase connection string. I would like to update these connection strings with ArcPy programmatically to a new data source, ...
0
votes
0answers
40 views

Updating enterprise feature class using ArcGIS API for Python

I have created a Python script that will turn some CSVs to features in a GDB and I am trying to get the feature class on my local machine to overwrite the feature on our enterprise portal. I have ...
0
votes
0answers
37 views

Replacing data source for group layers from FGDB to ArcSDE with different file names

Being a recent graduate and just started working I'm fairly new with Python, but I'm trying my best to learn and I find it really fun and useful! However, I'm stuck with a problem I can't seem to ...
0
votes
0answers
109 views

ST_TRANSFORM SDE Oracle does not convert the geometry

I try to convert a geometry from 31370 to 3857. But it does not work. The coordinates stay in 31370. DB: Oracle 11 ArcSDE: 10.4.1 The code: select sde.st_srid(shape) ,sde.st_x(shape) as ...
0
votes
0answers
40 views

Select domain's last update date

I have tables in an Oracle 18c GDB that I integrate to a work order management system. I create views on the tables to translate the data. For example, I translate codes to domain descriptions. I ...
0
votes
0answers
22 views

Feature dataset containing road network editing issue

I have created a feature dataset in a enterprise geodatabase. I then imported roads layer and built the topology to check issues and then created a road network. Everything is working fine until I ...
0
votes
0answers
15 views

Prevent row deletion in versioned tables: Put the functionality in ArcMap?

In a related question, I asked how to prevent rows from being deleted from versioned tables using database privileges. Unfortunately, this does not seem to be possible. As an alternative, is there a ...
0
votes
0answers
32 views

ArcGIS feature table SRID is NULL

I am using Oracle to store ArcGIS data. I have created my table named PARCELS from ArcCatalog, and I inserted some data using ArcMap. So when I run the following SQL query: select * from MDSYS....
0
votes
0answers
28 views

Updating enterprise geodatabase using Import XML Workspace document

There are two geodatabases DEV and PROD, DEV has schema changes (new fields, new tables), those changes should be replicated on PROD. An XML schema was generated from DEV, and using the Import XML ...
0
votes
0answers
72 views

Deploy/ Copy Feature Class under users AD account with gis Schema,

This question is regarding to SQL Server 2017 and ArcMap or ArcMap Pro environment. Little history: Currently GIS team deploying/Copying Feature class (FC) from ArcMap 10.4 or Pro under one SQL ...
0
votes
0answers
40 views

Allowing ArcGIS Server accessing our Geodatabase Enterprise over the web

In my organization there is an installation of ArcGIS Server that is linked with an Enterprise geodatabase (PostgreSQL) in a DMZ for editing only over the web. However, we have another installation ...
0
votes
0answers
61 views

Release SDE locks from arcpy.da.Editor in same process

Is it possible to use arcpy.da.Editor and have it release its SDE locks in the same process? I am using arcpy and trying to perform edit operations on an SDE version, then reconcile/post/delete the ...
0
votes
0answers
165 views

Why does opening SDE Workspace Factory ask for credentials again? ArcObjects C#

I'm trying to open SDE Workspace Factory using IWorkspaceFactory.Open I give the complete Property set in the code to open. ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS.esriSystem....
0
votes
0answers
97 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
73 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
26 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
67 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
70 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
34 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
313 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
111 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
64 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
30 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
81 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
64 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
57 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
91 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
170 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
452 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
135 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
152 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
90 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
50 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
800 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
190 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
91 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
74 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
100 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
39 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 ...