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
0
votes
0answers
26 views

Selecting the SHAPE column in Toad

I've noticed that SQL clients select the SHAPE column from SDE.ST_GEOMETRY in different ways: select shape from roads where Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,...
0
votes
0answers
24 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
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
16 views

Hiding one field of geodatabase for some users

I have ArcGIS Server 10.3 and SQL Server 2008. I have a geodatabase which is connected to SQL Server by using ArcSDE. My users connect to the database by IP address and Username and password. I want ...
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
23 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 prepare & translate the data for the integration. For example, I translate ...
0
votes
0answers
19 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
1answer
19 views

Register view with geodatabase fails (view selects table from different user)

I have two users/schemas in an Oracle 18c geodatabase (10.7.1): USER_A USER_B Scenario 1: I can create a view in USER_A: SELECT * FROM USER_A.TEST_TBL. I am able to successfully register the ...
0
votes
0answers
15 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 ...
1
vote
1answer
69 views

Production Mapping “Load Data” Tool having issues with SDE

I am attempting to use the Production Mapping tool "Load Data" to import data from many personal databases into a new SDE database (SQL server RDBMS). The schema between the PGDB's and SDE is the ...
6
votes
3answers
4k views

Checking current user privileges for ArcDE dataset with ArcPy

I am managing data distribution via an ArcSDE Oracle gdb to a number of users (schemas?), each of which can only have read only access to datasets they have requested access to, and have then been ...
1
vote
1answer
51 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; ...
1
vote
2answers
28 views

Prevent row deletion in versioned tables using database privileges

I have versioned tables in an Oracle geodatabase (versioned with the option to move edits to base). I would like to prevent users from deleting rows from the tables when using ArcGIS Desktop. (With ...
0
votes
0answers
12 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 ...
1
vote
1answer
103 views

Adding geodatabase connection from another PC to SQL server 2014?

I have a problem that I can not solve. I install SQl server 2014 and create Test1 database on My PC. Now I want to add Geodatabase connection in Arccatalog on Another PC. But it error below. Firewall ...
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
0answers
23 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
16 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 ...
1
vote
0answers
21 views

Unexpected query layer results: Why does unioning with DUAL fix it?

Simple Query: I have a query that connects to a table in a work order management database (Oracle 12c; non-GDB). select wo.wonum from maximo.workorder wo The query returns 428 records in ...
1
vote
1answer
55 views

Selecting polygon feature classes with 1 record in ArcSDE using SQL query?

I have an ArcSDE database with many feature classes.I would like SQL query to find all the polygon feature classes with only record in its table. So far, i can only query all the feature classes. ...
6
votes
5answers
547 views

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

I'm considering switching some of my tables in an Oracle enterprise geodatabase from versioned to unversioned. The pros of having unversioned tables would be: Simpler, traditional database design ...
5
votes
1answer
778 views

Which ArcGIS SDK to use ArcSDE SDK, ArcGIS Runtime SDK, ArcObjects SDK?

I have a geodatabase on SQL Server 2008 R2 and ArcGIS 10.2.2 installed. Both are on my local computer. I will interface to a Delphi Application and my aim is to query some records/fields line by line,...
0
votes
2answers
154 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. ...
3
votes
1answer
828 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. ...
2
votes
0answers
42 views

ArcMap replication tool does not synchronize changes made in versioned view from SQL Developer!

I am trying to replicate a feature class from Oracle to MSSQL Server using one-way replication(parent-child) replication. The replication works when edits are made from ArcMap,since I have to insert ...
0
votes
1answer
206 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
50 views

SDE to CSV slow transfer speeds

I'm trying to move a feature class on our network SDE that's made up of polylines as a CSV file to the local machine (or fileGDB but slow speed seems to be the theme regardless of output format) ...
0
votes
0answers
26 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 ...
1
vote
0answers
74 views

Recovering accidental edits through ArcGIS Pro Version Changes window?

We have a situation with our ArcSDE where features were accidentally deleted inside a version and we would like to recover those changes. We cannot undo edits because they were saved in a previous ...
2
votes
1answer
8k views

Bulk inserting with Python and cx_Oracle into st_geometry enabled table?

I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE. I could do it with the method execute() of cx_Oracle but ...
1
vote
1answer
24 views

Versioned View vs Database View in enterprise databases

While researching database views related to enterprise geodatabases I was trying to distinguish the difference between the database and versioned views. Is it just the fact that database views with ...
0
votes
1answer
25 views

Connecting to *.sde file in database IDE

I have no experience with connecting to ArcSDE databases other than opening user on prod.sde connection files in Catalog, so I have no intuition for entering information about hosts/servers/etc. In ...
2
votes
1answer
129 views

Accessing information about ArcSDE historical markers via arcpy or SQL?

I would like to be able to access the list of historical markers that is presented in the "Change Version" dialog in ArcMap - https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/...
5
votes
1answer
5k 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. ...
0
votes
0answers
13 views

Assigning the same schema to multiple users in an enterprise geodatabase?

When I add a user to the database via ArcCatalog > Adminstration > Add User, it creates a schema for the user, and sets that schema as the default schema for the user. From then on, when the user ...
0
votes
1answer
563 views

Getting data source of Feature Layer object in Python script tool?

I am writing a script tool to update some records. I am wanting to use a feature layer as input, to maintain definition queries, selections, etc. I would like to get the data source of the input ...
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 ...
-3
votes
3answers
3k views

Copying table in ArcGIS Desktop and keeping same feature ID (objectID)?

What geoprocessing tool can I use to copy a table from an ArcSDE Geodatabase to a Personal Geodatabase, keeping the feature ID (objectID)?
1
vote
1answer
71 views

Optimizing slow multi cursor approach?

I designed a workflow, that although functional, is very slow and prone to errors. I am sure there is a better approach, but I cannot wrap my head around it. The environment is ArcGIS arcpy (Python 3),...
0
votes
1answer
31 views

Create different Server Database Connection file for ArcGIS Server

I would like to register database with ArcGIS Server. I know it is done through ArcGIS Server Manager under Site / Data Stores / Register: Database. I am also aware there can be different connection ...
2
votes
3answers
41 views

Check in all tables in database if two fields are not null, with ArcPy?

I would like to check two fields in each tables which name start with X_ into a database ! I've started to write something like : arcpy.env.workspace = "C:/myWorkspace.sde" tables = arcpy.ListTables(...
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
133 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 ...
1
vote
1answer
141 views

Reading .sde connection file without Esri softwares?

I would like to be able to read connection properties from an sde file without any Esri dependencies such as Arcpy, ArcObjects etc. Is this possible?
0
votes
0answers
15 views

Derive Event Measures Error Message?

Getting an Underlying DBMS Error message (ORA-20025: Not owner of state 1087699.ORA-06512: at “SDE.VERSION_USER_DDL” As anyone seen this type of error and how all the sudden would this become an ...
0
votes
0answers
278 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 ...
2
votes
0answers
102 views

Exporting Query Layer (stand-alone table) to file geodatabase?

I'm using an SQL query (from MS SQL Server) on an enterprise DB connection, and am able to create a stand-alone table from the "Make Query Layer" tool. After this table (stand-alone query table) is ...
0
votes
1answer
35 views

Arcpy SDE Connection Getting Invalid Path? [closed]

I literally copied and pasted the file path (r'C:\Users\myName\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\mydatabase.sde'), but after I run my script, I always get the error saying error 267, the ...
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 ...
1
vote
1answer
343 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 "...