Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,280
questions
0
votes
0answers
18 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 ...
0
votes
0answers
14 views
XSD to PostgreSQL
I want to create from CitygmGML ADE XSD file a PostgreSQL database schema. I have used Altova XMLSpy but the results were not satisfying.
Is there a method to do that or a database that is created ...
0
votes
0answers
19 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 ...
6
votes
1answer
124 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
68 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
26 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
22 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
25 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
16 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
27 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
72 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
32 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
106 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
74 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
21 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
27 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
71 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
44 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
51 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 ...
