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
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
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
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
18 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
22 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
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 ...
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
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
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 ...
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
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
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 ...
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 ...
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
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 ...
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 ...
3
votes
0answers
73 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 ...
0
votes
0answers
34 views

Is there a way to deploy Oracle Instant Client with an ArcGIS Add-In to access geodatabase objects?

I would like to open a feature class stored in an Oracle Enterprise geodatabase from an ArcGIS 10.4.1 Add-In without installing an Oracle Client on the end-user machine. Currently, I can use the ...
1
vote
0answers
29 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
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 ...
1
vote
0answers
40 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
41 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. ...
3
votes
0answers
39 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
37 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
20 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
80 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
34 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
26 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
33 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
24 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
121 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
84 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
0answers
22 views

How to update geometry in PostGIS for features that are in an ArcGIS enterprise geodatabase (SDE)?

UpdateGeometrySRID is not working for some reason, I think this may be due to it being an enterprise geodatabase? I also tried the manual version of UpdateGeometrySRID, where you alter the table and ...
0
votes
0answers
28 views

How to interpret SDE.ST_GEOMETRY.POINTS

In the documentation says is "Contains the byte stream of the point coordinates that define the geometry"... but how does one extract the points from the binary? I'm NOT looking for ST_TOTEXT, that's ...
0
votes
1answer
30 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
35 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 ...
0
votes
0answers
67 views

SDO Oracle Table not recognized as Geometry in QGIS

I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such. I have read the following in the QGIS documentation: Normally, an Oracle Spatial layer is ...
0
votes
0answers
42 views

Repoint enterprise geodatabase connection using ArcPy in ArcGIS Pro

I have an ArcPy script that changes the connection parameters for every item in a layer file from a SQL Server connection to a PostGIS connection. This script works perfectly in ArcGIS Python version ...
1
vote
1answer
50 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
26 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
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
14 views

Update a join table in SDE

I'm trying to make edits to a versioned SDE Feature Class. I joined a table that contained a list of all the point IDs that need to be updated. I called these PT_ID1 and joined them with PT_ID in the ...
1
vote
1answer
24 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
30 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 –...