Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,322
questions
1
vote
0answers
23 views
Esri ArcObjects - getting geometry directly from SHAPE value ID
I've been teaching myself ESRI ArcObjects in C# over the past few weeks, I'm still very new in the ArcObjects world.
All of our data is in an Enterprise geodatabase on a MS SQL Server database.
I've ...
0
votes
1answer
36 views
Is Enterprise GIS license required to use Production Mapping license? [closed]
I'm looking to build up a hybrid GIS Enterprise environment whereby multiple users can access data at the same time via Arcmap. If possible, we'd like to not have to spend a fortune doing this. My ...
2
votes
1answer
97 views
Is the ObjectId value guaranteed to be unique after features are deleted and re-created in an enterprise geodatabase?
I'm working with an enterprise MS SQL Server geodatabase which is accessed via SDE. ArcGIS manages ObjectId values such that they are uniquely assigned as features are added to the geodatabase.
My ...
2
votes
1answer
16 views
Area Attribute in Feature Classes Gets Renamed to full FeatureClassName.AREA
I have a number of feature classes in an Oracle-backed Enterprise Geodatabase which have an attribute called "AREA" which is type double. All of these feature classes are part of the ...
0
votes
0answers
21 views
How do I set the type of geometry when creating a SQL table?
The table I am trying to recreate has these properties
Data Type File Geodatabase Feature Class
Feature Type Simple
Geometry Type Polygon <<<< WHAT I WANT TO RECREATE
My target ...
0
votes
1answer
37 views
ArcGIS10.2 SDE relationship class referencing a deleted feature - how to clean up relationship class?
I am looking for a smart approach to cleaning up a relationship class, which consists of relationships that look at previously deleted objects.
To illustrate, we have db.schema.SITE (spatial), db....
0
votes
0answers
22 views
Feature class is not imported in ArcSDE in ArcCatalog
I installed ArcEditor and ArcSDE. In my computer ArcEditor 9.3.1, ArcGIS Server 9.3.1, ArcSDE 9.3.1 and Oracle 11g are installed. I did all things by the Guide of ESRI: ArcGIS Server, Configuration ...
0
votes
0answers
14 views
What does the ArcGIS10.2 sde_state_id suffix 'L' mean in delta tables, when read using pyodbc in Python?
Enterprise geodatabase sits in MS SQL Server database. I'm using Python's pyodbc SQL driver to read SDE delta tables. I'm running the following query:
select
delete_table.SDE_STATE_ID,
...
-1
votes
1answer
44 views
This version of Geodatabase is incompatible with dataset and cannot open it using ArcGIS Pro
This implementation is done in ArcGIS Pro .Net SDK and has an Enterprise geodatabase. We had a polyline feature layer and move functionality was implemented in this. The functionality was working fine ...
2
votes
1answer
32 views
How are Modifications and Deletions represented when looking at enterprise geodatabase delta (add, delete) tables?
I'm trying to understand how to make sure a delete is a proper delete and not a modification, and vice versa. I'm using ArcGIS 10.2 and Enterprise geodatabase on MS SQL Server.
See below SQL:
select ...
1
vote
0answers
31 views
ArcSDE version status stuck in 33554433
One of our ArcSDE versions (esri v10.1 and oracle 11g) in SDE.Versions table shows a 'status' field value of 33554433 instead of the usual 0, 1, 2 for private, public, protected. I understand this is ...
1
vote
1answer
29 views
ArcGIS client user connection hanging when connecting to PostgreSQL geodatabase
ArcGIS Catalog and Pro are both hanging when I try to connect as a user that is a member of a role. I think it is related to the SDE schema permissions but I'm not sure.
I have an enterprise ...
0
votes
0answers
14 views
Can I prevent Planarize from resetting Domain Values?
Is there some setting I have that is causing this or is this just a BUG in ArcMap? I'm using ArcMap 10.8 with an Enterprise Geodatabase. When I run Planarize on a pair (or more than 2) Road Centerline ...
0
votes
0answers
40 views
ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer
I have data in an Oracle table (11 million records) and would like to insert 2000
records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
0
votes
1answer
21 views
FME Desktop 2019.2 Geodatabase_SDE writer copies Dataset parameter from reader when I said not to
I'm using FME 2019.2, Geodatabase_SDE reader and writer with different connection files.
I have one database "Operations" with user1 and another database "Data_Sources" with user2. They both support ...
1
vote
1answer
35 views
Parse SQL geometry Value to Arcpy Python geometry object
I'm trying to get a multiPolgon value returned from an SQL query (SQL Server 2014) to a an Arcpy Geometry Object. I know this is very easy I just am missing something.Whats confusing is this is a ...
0
votes
0answers
24 views
Checkout creation in ArcGIS
I am trying to create a replica checkout to work with from my Enterprise geodatabase which sits in UK however working with that it always give this error of "not being able to reset the foreign key ...
0
votes
0answers
15 views
Map Service: How is the shape column in an XY event layer different from a shape column in a registered view?
I have a non-spatial table with XY columns in an Oracle 18c/10.7.1 geodatabase.
With that table, I'm able to create a registered view with a shape column (based on the XY via the st_geometry function)...
0
votes
1answer
45 views
Do feature classes need to be versioned for editing with ArcGIS Collector/feature service?
I have an Oracle 18c/10.7.1 geodatabase with feature classes that have the following properties:
Unversioned
SDO_GEOMETRY datatype
Registered with the GDB
My organization plans to serve up the ...
2
votes
2answers
167 views
+50
Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)
I have an Oracle 18c/10.7.1 geodatabase that has:
A sidewalk polyline feature class (existing features)
And a sidewalk inspection point feature class (the features are created via ArcGIS Collector/...
2
votes
1answer
48 views
FME - Cannot load versions in ArcSDE Geodb Writer
I'm attempting to write to a version in a 10.6.1 ArcGIS Enterprise Geodatabase with a SQL Server 2017 Backend. I have created a version in the database and I want FME to write directly to it. I'm ...
0
votes
0answers
92 views
Getting “Workspace Already in Transaction Mode” Error when trying to use updateCursor on versioned sde
There are are numerous post on this error, but I can't seem to find a solution for myself. We have a versioned sde and need to add new fields to some of our feature classes and populate them with an ...
1
vote
0answers
55 views
Use a non-GDB SDO_GEOMETRY table in a map service?
I have a table with an SDO_GEOMETRY column (points) in an external system.
The external system is an Oracle 12c database; it is not a geodatabase.
I want to serve up the SDO_GEOMETRY table to a map ...
1
vote
0answers
39 views
Updating field from table used as source in network dataset
I have a Feature Dataset that contains a Network Dataset and a Feature Class (as a source of Network Dataset) in enterprise geodatabase (PostgreSQL). The Feature Dataset is versioned because we want ...
0
votes
0answers
14 views
Database Population in wrong Authentication Type
I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
1
vote
0answers
47 views
Poor performance when adding layer indexed ArcGIS Service layer to AGOL
My data sits in enterprise geoddatabases on Windows Server 2012, SQL Server manager.
I often add ArcGIS Server Web services to my AGOL maps and they perform really well. However, when I add a ...
0
votes
0answers
17 views
Recalculate extent for versioned featureclass
I try to recalculate extent for FC (versioned). I deleted some objects with null geometry, or with wrong location and reconcile every versions. But I still cannot recalculete extent to new proper ...
0
votes
1answer
47 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
140 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
199 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
87 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
30 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
42 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 ...
2
votes
1answer
89 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
97 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
29 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
35 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
210 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
101 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
135 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, ...
2
votes
1answer
130 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
52 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
18 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
53 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
15 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
71 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
38 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 ...
