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
2
votes
1answer
66 views

Geodatabase to UML

I want to convert geodatabase to the UML diagram in order to analyze the relations and the attribute of the gdb file. Is there a method for this transformation?
2
votes
1answer
54 views

Get the list of map services where table “xyz” is used

I have an SDE feature class: And I'm looking to find, to how many map services it is pointing. There are like duplicate map services pointing to same table, so I was trying to figure out how many ...
0
votes
0answers
74 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
1answer
60 views

Editing Point Data Layer made from Database Table using ArcGIS Pro?

I have a project in ArcGIS Pro which is connected to a SQL Server Database. I made a point feature layer from one of the tables however I cannot add points to the layer. I connected to the database ...
6
votes
1answer
162 views

ArcPy UpdateCursor auto pausing after every 1000 records

I have an update cursor running that updates a field based on a lookup table (Python dictionary). The cursor completes fine, but seems to pause and hold after each 1000 records - I have a test in it ...
1
vote
2answers
168 views

Why do arcpy.GetCount_management and arcpy.ArcSDESQLExecute yield different row counts?

I was benchmarking which method was faster for counting the number of rows in a table, when something curious happened: import arcpy import os import time test_tuple = ("path\to\connection", "...
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 ...
1
vote
0answers
29 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
113 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 Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,NULL,...
0
votes
0answers
250 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
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. ...
0
votes
1answer
226 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
23 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
2answers
134 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
43 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....
1
vote
0answers
32 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 ...
2
votes
0answers
47 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
0answers
100 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
1answer
62 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
308 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 ...
1
vote
1answer
200 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
501 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
47 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(...
2
votes
0answers
465 views

Arcpy 'Append_management' much slower than ArcMap Tool?

Basically I have a script that grabs data from a web service, parses it, stores it in an intermediary local fgdb, then appends that data to the feature class in the enterprise gdb. The portion of the ...
1
vote
0answers
38 views

Esri enterprise GDB features showing as non-spatial table in QGIS [closed]

Why are Esri's Enterprise geodatabase 10.4.1 (in MS SQL Server 2012) feature classes showing as non-spatial table/spatial type is 'no Geometry' in QGIS? The storage properties of the feature class ...
0
votes
1answer
48 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 ...
1
vote
0answers
47 views

How to transfer data from a version to default version in ArcMap? [closed]

I have lost all data from default version and also from the base tables in Oracle. But luckily, there is a version that has all the data in it. I have reconciled and posted that version to default but ...
1
vote
0answers
47 views

Attribute objects in Enterprise geodatabase automatically

There is a Enterprise geodatabase (MS SQL Server, ArcGIS), it has about 100 feature classes. It is necessary to automate the process of populating a unique number to each object in the database. ...
4
votes
1answer
80 views

Limit users' editing privileges by attribute and role

I have a feature class in an Oracle 12c geodatabase. The feature class has a type column. The column has a coded domain. I would like to limit user's ability to edit the features based on the type ...
0
votes
0answers
42 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 ...
1
vote
1answer
45 views

ArcObjects - IFeature HasOID property returning false when there is clearly an OID [closed]

When inspecting features in my featureclass, I am checking to see if a feature has an OID using the HasOID property. Even though the feature(s) clearly has an ID on visual inspection (via ArcMap), the ...
3
votes
1answer
126 views

Performance of arcpy.Exists() in SQL Server enterprise gdb environment

While iterating on a list containing table names, I used arcpy.Exists() to check if a table/featureclass exists. This action is very time consuming. I've ended up using a database approach select ...
0
votes
0answers
99 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 ...
1
vote
0answers
49 views

Oracle Enterprise GeoDatabase force logging vs nologging [closed]

Our production Enterprise GeoDatabase running on Oracle has been configured at the database level to force logging. ArcSDE DBTUNE defines many tables and indexes by default to be NOLOGGING for ...
2
votes
0answers
64 views

Having functional copy of geodatabase in same SQL Server instance? [closed]

Having an Esri Enterprise geodatabase, I want to have a copy of the database in order to make some tests. I have an instance of SQL Server, and I do not want the overhead of installing and maintain ...
1
vote
0answers
29 views

Geodatabse Compression does not make changes in Base Tables [closed]

This question has been asked here GDB Compression Not Updating Base Tables, but the solution provided is not what I am looking for. I have registered a feature class and made some edits in that ...
2
votes
2answers
293 views

How to make ArcMap aware of the changes that are made in base table? [duplicate]

I am using ArcMap One-way replication tool to synchronize feature classes from Oracle to MS SQL Server (once a day), but replication only works for the versioned data with move edits to base option as ...
1
vote
0answers
181 views

ArcMap Replication tool does not synchronize changes made from database tool i.e SQL Developer? [closed]

I want to synchronize some datasets and feature classes from Oracle to MS SQL Server using ArcMap replication tools. Both databases are geodatabase enabled. I don't want to replicate/synchronize data ...
0
votes
1answer
35 views

Seeking Public ArcSDE Server?

I am product testing and would like a sample ArcSDE server to connect to for testing. Does anyone know of ones that are still out there available?
1
vote
0answers
153 views

Describe FeatureClass shape type, can't get past error (object has no attribute 'shapeType')

My code: import arcpy, csv, os # Create a Describe object gdb = r"Database Connections\GISUSER.sde" desc = arcpy.Describe(gdb) full_path = False # Specify whether dataset name should be full or ...
1
vote
1answer
160 views

Connect to a SQL Server database from MS Access [closed]

I have an existing Microsoft SQL Server database which has been configured as an Enterprise geodatabase. I want to access it in MS Access in order to extract data to populate a form. What is the ...
0
votes
2answers
81 views

Storing related tables and toolboxes within feature dataset?

I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset ...
0
votes
1answer
79 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) ...
1
vote
1answer
29 views

arcpy Select_analysis where_clause objectid [closed]

Trying to copy features from sde to fgdb but only when the objectid is below a certain number. outpath = r'C:\Users\CHOK\Desktop\SDE Conversion Project\TEST.gdb' query = '"objectid" < ' + "'121'" ...
1
vote
0answers
53 views

arcpy.da.ListSubtypes returns empty IOError on 64bit

I'm trying to use “ListSubtypes” function in ArcGIS Python. It works on 32bit environment (f.e. - Desktop), but it does not work in 64bit (f.e. - Server) and returns IOError without any information –...
2
votes
0answers
43 views

Editing Parcel Fabric in Versioned Geodatabase

We keep our parcel fabric in a SDE database with an intermediate staging version that multiple users post changes to from their own personal edit versions. We're able to edit the parcel fabric ...
0
votes
0answers
243 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....
1
vote
0answers
457 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 ...
0
votes
1answer
110 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
0answers
133 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 ...

1 2
3
4 5
28