Questions tagged [enterprise-geodatabase]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
7 views

QGIS does not recognize the CRS when the data is provided by SQLServer Database with Esri SDE

We have a MS SQL Server: Microsoft SQL Server 2016 database with SDE from Esri on Windows Server 2012 R2. Loading data into QGIS results in the QGIS unkown CRS dialog. If we don't select one CRS the ...
1
vote
1answer
78 views

Selecting polygon feature classes with one record in Oracle geodatabase using SQL query?

I have an Oracle Enterprise geodatabase with many feature classes. I would like a SQL query to find all the polygon feature classes with only one record in its table. So far, I can only query all the ...
0
votes
1answer
70 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
1answer
29 views

Copying feature datasets weekly from EGDB to EGDB (geometric networks included)

I've been trying find a way to copy a few select feature datasets from our main production Enterprise geodatabase environment to a second Enterprise geodatabase. These datasets include geometric ...
1
vote
1answer
60 views

Disabling Start Editing command using ArcObjects?

How do I disable the Start Editing button in ArcMap when an added ArcSDE database version is the default? IMxDocument pMxdoc = m_application.Document as IMxDocument; IMap pMap = pMxdoc.FocusMap; ...
0
votes
1answer
29 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 rownum_, ...
0
votes
1answer
32 views

What system tables get INSERTS when registering object with Oracle EGDB (ST_Geometry)?

In ArcGIS Desktop, I can register ST_Geometry objects with the geodatabase (Enterprise 10.7.1; Oracle 18c): Register with Geodatabase Register feature classes, tables, views, and raster layers that ...
0
votes
2answers
23 views

Select specific attribute from SDE.ST_Geometry UDT? (without using accessor functions)

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_Geometry polyline feature class. As an experiment/learning exercise, I am trying to learn how to interact directly with the user-defined type (UDT) SHAPE ...
0
votes
0answers
23 views

Does Analyze Actually Do Anything?

I was taught that you need to 'Analyze' each dataset in enterprise databases as much as you can. It was one of those things that I just did, and which I never thought much about. However, I recently ...
3
votes
5answers
137 views

Materialized view with FAST refresh on remote table: How to include a SHAPE column?

I want to create an Oracle materialized view with the fast refresh option on a remote table (in an enterprise GDB). I can do this successfully without a SHAPE column: create materialized view log on ...
0
votes
0answers
18 views

ALTER TABLE in SDE

Is it OK to change the text length of a column in a featureclass in SDE using SQL? Using ALTER TABLE <tablename> ALTER COLUMN <columnname> nvarchar(255); I wonder this because I found ...
2
votes
1answer
16 views

What densification method does SDE.ST_Geometry use to approximate arcs as segments?

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_Geometry polyline FC that has arcs. In a related post, we established that true arcs/curves are only available to ArcObjects, whereas the actual geometry ...
2
votes
1answer
30 views

Convert ST_POINT subtype to ST_GEOMETRY supertype?

Oracle 18c; ArcGIS 10.7.1 I have a query that produces an ST_POINT column: --Mimics the SDO_GEOMETRY get_vertices function --https://docs.oracle.com/database/121/SPATL/sdo_util-getvertices.htm ...
7
votes
2answers
988 views

Get ArcGIS to recognize ST_POINT

I have a SDE.ST_GEOMETRY line feature class. I've created a view on it that returns an st_point column. SELECT OBJECTID, SDE.ST_STARTPOINT(SHAPE) AS START_POINT FROM ENG.ROAD There is a known Oracle ...
0
votes
0answers
20 views

Combine SDE Versions in a SQL View

I have two versions, from same base table, with only one feature class in both that I want to combine in a database view for a presentation. Version feature classes differ both with attributes and ...
0
votes
1answer
34 views

ST_GEOMETRY: spatial column must appear immediately after spatial relationship function for spatial index to be used

The docs for SDE.ST_GEOMETRY have a blurb that says the following: When are spatial indexes used with ST_Geometry? ...the spatial column must appear immediately after the spatial relationship ...
2
votes
2answers
48 views

Reading ESRI SDE data from network port 5151

I am performing a network vulnerability scan of an Android Automotive platform. My setup consists of a Kali Linux machine and an Android Automotive Infotainment System on a local network. During the ...
5
votes
1answer
283 views

Why are z-values replaced with zero after in_memory use in Python?

My script takes separate 3D feature classes, calculates a field, appends to a target feature class, and then deletes the originals. This is a huge data processing task of over 4700 mass point feature ...
1
vote
1answer
435 views

Change Version Option Grayed out in ArcGIS Pro

I am experimenting with versioning data from an SDE database in ArcGIS Pro. I able able to create a new version, no problems, but when I go to change the version in the Data Source tab on the Contents ...
0
votes
0answers
27 views

FME Oracle SDE Invalid column definition

I am using FME on daily basis working with sde feature classes. Sometime I am receiving data with more then hundred columns and when working I receive the following error. The error number from Arc ...
2
votes
1answer
44 views

Function-based spatial index: Use sdo_geometry() constructor instead of custom function?

I have an Oracle 18c table that has XY columns, but not a SHAPE column. I've created a query on the table that dynamically generates an sdo_geometry SHAPE column. sdo_geometry(2001, 26917, ...
5
votes
3answers
4k views

Create an SDO_GEOMETRY view from a non-spatial table?

Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those ...
1
vote
1answer
569 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 ...
1
vote
1answer
23 views

ST_GEOMETRY points: get attribute of intersecting polygon

I have an SDE.ST_GEOEMTRY point feature class. I want to create an SQL query from the points. The query would perform a spatial join/intersection with an SDE.ST_GEOMETRY polygon feature class. An ...
0
votes
2answers
1k views

Changing alias of ArcSDE feature class?

I have a feature class. I want to edit the alias. When I go into the Properties of the FC and try to edit the alias, nothing happens. The field will not accept focus and changes are not allowed. How ...
0
votes
1answer
79 views

Are XY event layers optimized/indexed on-the-fly?

Oracle 18c; 10.7.1 EGDB; ArcGIS Desktop 10.7.1 I have a non-spatial WORKORDER table that has X & Y columns. The table has 10,000 records. I’ve created an XY event layer from the table in ArcMap. ...
5
votes
1answer
7k views

Debugging ERROR 000464: Cannot get exclusive schema lock?

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
3
votes
1answer
875 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
0
votes
1answer
19 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
1answer
100 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
1answer
189 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 ...
2
votes
1answer
417 views

How to identify Unposted/Outstanding (A&D) edits of a version in Enterprise SDE Database using SQL interface?

I am working on ArcSDE10.2.2 Oracle11G(11.2.0.4) enterprise geodatabase with user base 600+ and 2000 versions( Created from DEFAULT). For effective GDB compression and optimized performance delta ...
2
votes
1answer
35 views

Create field on open ArcGIS map - not saved

I am using ArcGIS desktop with an SDE feature layer with enterprise data that I do not have rights to edit. The data changes weekly but I need a field that is sum of 2 current fields without creating ...
0
votes
0answers
44 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 domain codes to domain descriptions. ...
1
vote
1answer
44 views

How to create spatially filtered versions in ArcSDE 10.1?

I am using ArcSDE 10.1 and Oracle 11g, I have a SDE user (parent), and two more users (ex: user1,user2) in my oracle database with required SDE permissions. In my SDE db, i have a polygon ...
0
votes
1answer
204 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
0answers
35 views

Problems with sde.next_rowid, ArcMap still uses 'old' values

Due to reasons beyond the scope of this question, I'm forced to import data into an SQL Server SDE database using SQL statements (importing using ArcGIS is not possible). The data already contains ...
0
votes
0answers
16 views

How does multiuser work with versioned ArcGIS?

I am new at versioned editing and am confused a bit and have some questions. For example I have five editor users and versioned dataset or featureclass. So, Should each editor create their own ...
0
votes
2answers
69 views

Creating feature class on ArcSDE schema with different user

I have created an enterprise geodatabase using ArcCatalog 10.5 on a PostgreSQL database. I have a database admin user named administrator and another user named sde. The geodatabase admin is sde user. ...
1
vote
2answers
992 views

SDO_GEOMETRY view in ArcGIS Desktop

I have an sdo_geometry table that I created using ArcGIS Desktop (by converting an esri.st_geometry table to sdo_geometry). I'm using Oracle Spatial's sdo_geometry datatype because it has linear ...
0
votes
0answers
28 views

Editing and Versioning with ArcGIS Rest API

I'm developing a web app with ArcGIS REST API. I created Version A from default version, made some edits on an event layer where I acquired locks for Route A, then deleted Version A. (The API I called ...
0
votes
1answer
147 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
1answer
35 views

How can a MXD point to a path that does not exist?

We work on ArcMap 10.6, and have MXDs using database connections (.sde files) that point to the C:\ of a user that no longer exists (e.g. C:\users\alpha\test.sde) and certainly, that path doesn’t ...
0
votes
1answer
44 views

SDO_GEOM materialized view: Why is static field slower than dynamic field?

EGDB: Oracle 18c; ArcGIS 10.7.1 External system: Oracle 12c I have a materialized view in an EGDB that syncs data from an external system (on a schedule via a dblink). The materialized view has an ...
0
votes
0answers
29 views

Materialized view breaks when registered with the GDB

EGDB: Oracle 18c/10.7.1 External system: Oracle 12c I have created a non-spatial materialized view in an EGDB that syncs data from an external system (on a 5 second schedule; via a dblink). It is ...
3
votes
1answer
38 views

Use multiprocessing to speed up rebuild index in ArcPy

We are in ArcGIS 10.6.1 (on Windows Server 2012) and Enterprise GeoDatabase Oracle 19c (on Linux). I was wondering if it is feasible to use the Python's ProcessPoolExecutor to open two separate Oracle ...
0
votes
1answer
46 views

ArcSDESQLExecute is not able to DELETE rows in one database but works in other

I have two ESRI enterprise geodatabases on SQLServer: A and B. They are almost the same database (structure) I have this code snippet in python to deleted several rows from versions: def ...
1
vote
1answer
531 views

Enterprise geodatabase on PostgreSQL backup and restore

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer. My backup command is as follows. host 5433 pg_dumpall -h localhost -p 5433 -U postgres -c -f "...
2
votes
1answer
128 views

FME - Cannot load versions in ArcSDE Geodb Writer

I'm attempting to write to a version in a 10.6.1 ArcGIS Enterprise Geodatabase with a SQL Server 2017 Backend. I have created a version in the database and I want FME to write directly to it. I'm ...
5
votes
2answers
4k views

Can ArcPy test for availability of SDE Connection before trying to use it?

In a Python script that I use to publish ArcGIS 10.0 Geoprocessing Services I have some code: arcpy.AddMessage("If process hangs here, check for ArcSDE connections issue by trying to open " + mapFile ...

1
2 3 4 5
28