Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,301
questions
0
votes
0answers
14 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
60 views
Projecting features to Enterprise Geodatabase in Oracle gives ERROR 000210: Cannot create output
I am trying to project features from a geodatabase and write into an enterprise geodatabase connection. I have permissions to create data and the name I am using also works, but I keep getting error:
...
1
vote
2answers
31 views
Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?
I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase.
I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL.
Reason: So that I can do linear referencing ...
0
votes
2answers
60 views
Convert X & Y columns to a SHAPE column (using a method that would perform well in Portal)
I have a non-spatial table in an external system. The table has X & Y columns.
The table will be synced to an Oracle 18c/10.7.1 geodatabase table or FC (via the ArcGIS REST API). There will be ...
0
votes
0answers
26 views
Getting SQL explain-plan for ArcGIS Map service
My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse.
I'm having some performance issues with the layers/views in the map service.
I want to ...
1
vote
0answers
24 views
Pre-populating list in Survey123 using SQL Server column
What I currently have is a Survey which enters the data collected from the survey in a SQL Server table, I'd like for one of those columns in that table to become the choices in another survey.
If ...
1
vote
1answer
31 views
ArcPy UpdateCursor: How to find specific row index of dictionary key/value difference?
I have a Python script that hits a REST API and grabs attribute data for rooms in buildings from an IBM Tririga DB. I have an Enterprise geodatabase rooms feature class populated with these same ...
1
vote
1answer
72 views
Use SDE.ST_GEOMETRY functions in a custom function
I have a dummy query where I generate an SDE.ST_GEOMETRY point:
select
shape as srid_test
from
(
select
sde.st_geometry ('point (10.01 50.76)', 4326) as shape
from
...
0
votes
0answers
27 views
Creating database connection using ArcCatalog
I'm using ArcCatalog 10.2.2 which is installed on a Windows 2019 Server OS. I'm having trouble creating a database connection.
Usually this is a very straight forward process.
Put in the server name ...
0
votes
0answers
17 views
Select list of tables and feature classes that have subtypes?
I have tables and feature classes in an Oracle 12c geodatabase (10.7.1).
I would like to generate a list of tables and feature classes that have subtypes defined in them.
Is there a way to do this ...
2
votes
1answer
96 views
Get midpoint of SDE.ST_GEOMETRY polylines?
I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1).
I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
2
votes
0answers
40 views
Duplicate Global IDs within same feature class
I received a geodatabase from a contractor and I observed there are multiple feature classes with column of Global ID type.
These Global ID type columns, when I checked data i realized there are ...
0
votes
0answers
23 views
Creating features from related table
I have a M-1 related table (Sales) and a Polygon feature (Parcels)
I want to create a point feature for the sales. If I join to the Parcels I only get the first sale to join but I need all of them.
...
1
vote
1answer
43 views
“Error 999999: Error executing function - Attribute conversion error” when running RegisterWithGeodatabase
I am using ArcPy to run through all of the spatial views in an enterprise GDB, register them with the GDB, and assign domains to the registered view. It runs great for most of the views in the GDB, ...
1
vote
1answer
51 views
Converting ArcSDE point data from image to MSSQL geometry
I have a bunch of points in an SDE table which is currently stored in an MSSQL database.
The full entry is below, while the data i'm trying to convert from binary to geometry is: ...
1
vote
0answers
25 views
Backup of ArcSDE version
Is there any way how to backup particular version in ArcSDE geodatabase?
I want to delete some versions from our geodatabase, but it would be great if I can create backup first and restore version ...
1
vote
1answer
14 views
Extract subtype codes and descriptions in a view
I have an Oracle 10.7.1 geodatabase that has tables and feature classes with subtypes.
How can I extract the codes and descriptions from the subtypes in a view?
3
votes
0answers
52 views
Registered view gets buggy when database link added [closed]
I have a view in an Oracle 12c geodatabse:
create or replace view parcel_vw as (
select
p.*
from
parcel p
left join
for_gis.gis_locations@gistomax loc --<-- Join to database link
...
0
votes
1answer
14 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 ...
5
votes
1answer
67 views
Get notification if feature service fails?
I have ArcGIS 10.7.1 feature services that occasionally fail/have errors.
The feature services are used to integrate/sync records to a separate work order management system. As such, the broken ...
2
votes
1answer
25 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
37 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
29 views
Selecting using edit tool in ArcMap
I am using ArcMap 10.3.1.
When using the edit tool in an edit session to select features and move them, I see the following symptoms:
The edit tool draws the rectangle, the attributes briefly show ...
0
votes
0answers
32 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
30 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
26 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
137 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
84 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
33 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
23 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
73 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
38 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
35 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 codes to domain descriptions.
I ...
0
votes
1answer
42 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
22 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
30 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
27 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
19 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
24 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
44 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
35 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
27 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
38 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
18 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
88 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
100 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
42 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
16 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 ...
3
votes
0answers
110 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 ...
