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
1 answer
24 views

Equivalent to USER_SDO_GEOM_METADATA for SDE.ST_GEOMETRY

Background - SDO_GEOMETRY: If I were to create a function-based spatial index that returns an SDO_GEOMETRY, I would manually insert records into SDO_GEOMETRY's USER_SDO_GEOM_METADATA for these ...
user avatar
  • 754
0 votes
0 answers
10 views

ArcGIS - How do I save layers from an SDE to a layer file?

I have an MXD with layers sourced to SDE feature classes. I am trying to save the layers as layer files. However, I can't get arcpy.SaveToLayerFile_management to do its job. Here's the code I use in ...
user avatar
0 votes
0 answers
15 views

Adding Mosaic Raster into SDE

I am georeferencing OS 25 and 50K TIFF images in ArcGIS Pro. I have created a raster dataset and use the mosaic tool to 'patch' all the SKs together. The data has to sit within SDE to be able to feed ...
user avatar
  • 3
0 votes
1 answer
31 views

Improve performance of startpoint query (ST_GEOMETRY)

I have a SDE.ST_GEOMETRY query in an Oracle 18c EGDB that gets the startpoint of polylines: select objectid, sde.st_geomfromwkb(sde.st_asbinary(sde.st_startpoint(sde.st_geometryn(shape,1))), ...
user avatar
  • 754
0 votes
0 answers
15 views

ERROR 000837: The workspace is not the correct workspace type. in arcpy.management.CreateVersion

I am trying to create version in branch versioning enabled feature service. But my simple code is failing. # Import system modules import arcpy # Set local variables inWorkspace = "https://&...
user avatar
0 votes
1 answer
22 views

Select SDE.ST_GEOMETRY as JSON text (using SQL)

I have a multipart M-enabled SDE.ST_GEOMETRY polyline FC (in an Oracle 18c EGDB): Using SQL, I want to select the geometry as JSON text: {"hasM":true,"paths":[[[0,5,0],[10,10,11....
user avatar
  • 754
0 votes
0 answers
15 views

ST_GEOMETRY feature class: Add a hidden SDO_GEOMETRY column

I have an SDE.ST_GEOMETRY FC in an Oracle 18c EGDB. I want to use Oracle Spatial functions on the data (calculate polyline midpoint, M-values, dynamic segmentation, etc.). Ideally, I'd convert the ...
user avatar
  • 754
0 votes
0 answers
13 views

Create replica failed version not found

I am trying to create a one-way replica, (register with existing data option) for a dataset. When I create replica, following error occurs: I also created a replica with the same databases i.e., ...
user avatar
  • 418
1 vote
1 answer
16 views

Deleted point layer reappears upon refresh in ArcGIS Pro

I've deleted a point layer from a SQL Server geodatabase in ArcGIS Pro (using the Pro UI). The deletion appears successful but upon refresh of the geodatabase, it reappears. I haven't really seen ...
user avatar
0 votes
0 answers
20 views

Editing normal PostGIS layer in ArcMap without installing Enterprise Geodatabase

I have an open-source open-protocol product that uses PostGIS layers in PostgreSQL. I have a client now that wants to use ArcMap with this geographical data. I can connect ArcMap to the database as a ...
user avatar
0 votes
3 answers
101 views

Convert M-enabled SDE.ST_GEOMETRY to SDO_GEOMETRY using SQL

I have an M-enabled SDE.ST_GEOMETRY polyline FC in an Oracle 18c EGDB. select sde.st_astext(shape) as st_to_wkt from test_st_geom MULTILINESTRING M (( 0.0 5.0 -100000.0, 10.0 10.0 -100000.0, 30.0 0.0 -...
user avatar
  • 754
0 votes
0 answers
28 views

‘Could not open SDE workspace’ Error when running Multithreaded Calls on a geoprocessing service

I have a python based geoprocessing service running on arcgis server 10.8 which is deployed on several environments. There is an application that makes multithreaded calls (roughly 9 calls ...
user avatar
  • 1
0 votes
1 answer
50 views

Is a GIS database necessary? Most efficient way? [closed]

I have been tasked with finding an efficient way to store data of thousands of addresses to compare to a broader set of addresses of all retail stores in America. Ideally, I would like the database to ...
user avatar
1 vote
0 answers
13 views

Update a table from a geodatabse

I use a Geodatabase on SQL Server, on which I base myself to configure tables of the bors and maps. I tried to modify a few items in a table in this Geodatabase with a simple query (UPDATE...SET). I ...
user avatar
  • 21
0 votes
1 answer
81 views

Use M Value with POLYLINE.segmentAlongLine

Currently I have a table with Begin and End M measurements. I also have a route feature class. I would like to be able to use the POLYLINE.segmentAlongLine(start_measure, end_measure) method but ...
user avatar
  • 113
0 votes
0 answers
22 views

Intersect points with polygons using SQL Server query from ArcGIS Enterprise Geodatabase

I have 2 databases in ArcGIS Enterprise Geodatabase in SQL Server. One database (DB_A) contains a feature class with points and the other database (DB_B) contains a feature class with polygons. I'd ...
user avatar
  • 271
0 votes
1 answer
27 views

Selecting All Features within Feature Dataset in ArcSDE Database using ArcPy

I'm trying to create a script tool to select all the features within a user-specified area of interest then run the Data Reviewer extension. I've encountered an issue trying to select features from a ...
user avatar
  • 1
0 votes
1 answer
30 views

Manage data versions using JavaScript for ArcGIS Enterprise

I developed a small web application that contains a Map view, and is loaded with features that were published. So I have (FeatureServer, VersionManagementServer). I decided to to add the functionality ...
user avatar
  • 592
-1 votes
1 answer
55 views

ArcGIS Pro 2.7 ArcPy ListDatasets() and ListFeatureClasses() returning empty on SDE workspace

(I know there was a similar question also unanswered ListDatasets() returning empty array on sde workspace, but I couldn't comment on it. Sorry for the duplicate.) I am trying to run a script to ...
user avatar
0 votes
0 answers
31 views

Running a Python script on features in Oracle SDE database

I am running a Python script on data in an Oracle ArcSDE database. My script works exactly as it should locally, but I start getting empty lists as soon as I run it in ArcSDE. Without going into too ...
user avatar
  • 1
0 votes
1 answer
29 views

How does SDE.ST_LENGTH() get calculated?

I have an Oracle 18c SDE.ST_GEOMETRY polyline FC. The lines in the FC have true curves. If I query for the length of the lines in SQL using SDE.ST_LENGTH(SHAPE), how does the length get calculated? ...
user avatar
  • 754
2 votes
2 answers
66 views

Where to see Feature Datasets in SQL Developer

Background: I am a non-GIS programmer, I do however directly work with numerous GIS products and data. Generally I primarily interact with the GIS data directly via the database (Oracle) through SQL ...
user avatar
  • 143
1 vote
1 answer
61 views

Select rows using Python? (without creating a new field or table)

ArcMap 10.7.1 — Oracle 18c SDE.ST_GEOMETRY — Polyline FC Occasionally, we come across scenarios where we want to select rows in a FC in the attribute table, but there isn't a way to run the query ...
user avatar
  • 754
0 votes
1 answer
42 views

Select feature parts and vertices as rows

I have a Oracle 18c SDE.ST_GEOMETRY FC that has multi-part polylines. I want to select the parts and vertices as individual rows in a query: Since we don't have a GetVertices() function in SDE....
user avatar
  • 754
3 votes
1 answer
86 views

Editing vertex without removing true curves using ArcPy

ArcMap 10.7.1 — Oracle 18c SDE.ST_GEOMETRY I have a polyline FC that has true curves. And I have an ArcPy script that updates the M-values of the vertices in the lines: import arcpy connection = &...
user avatar
  • 754
0 votes
0 answers
23 views

What column is true curve data stored in? (SDE.ST_GEOMETRY for Oracle)

I have an Oracle 18c SDE.ST_GEOMETRY polyline FC: The lines in the FC have true curves (aka CAD BLOBs). Question: What column is the true curves data stored in? @Vince mentioned in a comment that ...
user avatar
  • 754
0 votes
0 answers
27 views

Update vertex via SQL — without reconstructing shape

ArcGIS 10.7.1 — Oracle 18c GDB — SDE.ST_GEOMETRY I have a multipart polyline in an SDE.ST_GEOMETRY FC. I want to update the coordinates of a specific vertex with a known value — via SQL. I believe it ...
user avatar
  • 754
1 vote
1 answer
85 views

Determine if a SDO_GEOMETRY line has true curves

Oracle 18c I have an SDO_GEOMETRY table that I created via ArcGIS Desktop 10.7.1. The table has a line that appears to have a true curve in it: However, in a related question, @Vince pointed out that ...
user avatar
  • 754
0 votes
0 answers
19 views

Preserve arcs/curves when converting SDE.ST_GEOMETRY to SDO_GEOMETRY via SQL

ArcGIS 10.7.1; Oracle 18c GDB I have an SDE.ST_GEOMETRY polyline FC that has lines with arcs: In an SQL query, I want to convert the ST_GEOMETRY shape to SDO_GEOMETRY. I can do the conversion by ...
user avatar
  • 754
0 votes
2 answers
46 views

Does Oracle's SDO_Geometry spatial type support arcs?

Oracle 18c GDB; ArcGIS 10.7.1 With ESRI native spatial types, such as SDE.ST_GEOMETRY, we can store "CAD" arcs in the geometry of polyline and polygon features. Question: Does Oracle's ...
user avatar
  • 754
0 votes
0 answers
15 views

SDE.ST_GEOMETRY function returns negative infinity

ArcMap & Enterprise 10.7.1 — Oracle 18c SDE.ST_GEOMETRY — SQL Developer 18.1.0.095 I have an SDE.ST_GEOMETRY polyline FC that is M-enabled: I can query for the M-value of the endpoint of the ...
user avatar
  • 754
0 votes
0 answers
27 views

Batch-replace geometries from one FC to another (via related IDs)

ArcGIS Desktop & Enterprise 10.7.1 — Oracle 18c — SDE.ST_GEOMETRY I have a polyline FC called FC-A. And I have an additional polyline FC called FC-B. I want to update the shapes in FC-A with the ...
user avatar
  • 754
0 votes
0 answers
18 views

Use SDE.ST_GEOMETRY functions in Select by Attributes window

ArcGIS Desktop & Enterprise 10.7.1 — Oracle 18c — Polyline FC registered as versioned (with base). Background: I want to use Oracle SDE.ST_GEOMETRY functions in the Select by Attributes window in ...
user avatar
  • 754
0 votes
0 answers
54 views

Saving edits via session manage in ArcFM using C#

I am trying to save edits using Session manager. But, does not let me save the data, instead it continue show saving session (in taskbar). Sample Code : protected override void OnClick() { ...
user avatar
0 votes
1 answer
78 views

Python Script not working on versioned Feature Class

I have a geoprocessing script that worked great, until moving the data source to a feature dataset where it must be versioned. when this script is pointing to the layer outside the feature dataset, it ...
user avatar
0 votes
0 answers
43 views

ListFields in Feature Classes in Multiple Feature Datasets in Oracle SDE

I need to create individual reports for feature classes that contain the field "FACILITY_STATE" AND "FACILITY_STATE = 'PPC'". These feature classes span multiple feature datasets ...
user avatar
  • 1
0 votes
0 answers
24 views

Dropping and reloading layer on Enterprise/SQL Server

I use ArcPy's MakeXYEventLayer_management and FeatureClassToFeatureClass_conversion tools to generate a feature class from a CSV file. I host this layer on a SQL Server Enterprise Geodatabase, and I ...
user avatar
0 votes
0 answers
181 views

ArcGIS Pro attribute rule fails when collecting from an online map in Field Maps

I am using ArcGIS Field Maps to collect building inspection records to a standalone table by tapping on a feature in a related building layer. (See Inspect—Add a related report.) The inspection table ...
user avatar
  • 29
0 votes
0 answers
41 views

Unable to connect ArcPy with ArcMap to MS SQL Server accessed via ArcSDE

Why can I not connect my ArcPy to our enterprise database hosted on a Microsoft SQL Server? I'm running Python 2.7, ArcMap 10.6.1, MSSQL Server 12.0 (2014) I've created an SDE connection file in ...
user avatar
1 vote
0 answers
17 views

Enable Archiving and Enable Editor Tracking on Oracle SDO

Are enable archiving and enable editor tracking allowed in Oracle database system (SDO)? Since I usually use PostgreSQL, I don't know the features supported by the Oracle database.
user avatar
0 votes
1 answer
27 views

Setting version of ArcMap

I am trying to set the version of SDE by using following code : SET SERVEROUTPUT ON; declare q varchar2(100); ver varchar(10); BEGIN DBMS_OUTPUT.PUT_LINE('HI'); ver := 'PQ_358'; ...
user avatar
0 votes
0 answers
41 views

Versioned view does not reflect the delta changes

I am adding some data using session manager to layer, and saving them. Those changes are visible in delta table in SDE also. But, when I query to count the base table and versioned view result count, ...
user avatar
0 votes
1 answer
52 views

This data is not editable using ArcMap

Bit of a vague one this. I've got a table in an Azure SQL database, which has been enabled as a geodatabase. I'm trying to edit this, but cannot, as I keep getting the following error whenever I try: ...
user avatar
  • 814
0 votes
0 answers
26 views

Appending all of the feature classes in one enterprise database to a template enterprise geodatabase using Model Builder

I am working on moving our GIS data from an old server to a new one. I've created the enterprise geodatabase on the new server, and have imported the schema from the old enterprise geodatabase from ...
user avatar
0 votes
0 answers
65 views

InsertCursor throwing "error return without exception set"

I'm trying write data to an Enterprise geodatabase but it still throws error return without exception set (for clarification - error throws row cursor.insertRow(data). I have method: def ...
user avatar
0 votes
1 answer
74 views

SearchCursor RuntimeError: Underlying DBMS error [ORA-00923: FROM keyword not found where expected]

I need load OBJECTID from remote DB but I'm still getting error: RuntimeError: Underlying DBMS error [ORA-00923: FROM keyword not found where expected] [SDEDO.E_EL_TU][STATE_ID = 22362] I don't know ...
user avatar
0 votes
0 answers
59 views

Setting a .sde connection file as a default value in an ArcPy toolbox

I am building a tool to run some routine data maintenance on an Enterprise geodatabase with Python. I would like to set the default value for one of the parameters to database connection file on disk. ...
user avatar
0 votes
1 answer
75 views

DLL error listing domains in Python script

There is a Python script intended to create a UPDM geodatabase, it receives several parameters, among them, database admin user, database dataowner user, and their passwords. The script runs using the ...
user avatar
  • 734
3 votes
1 answer
2k views

Parsing/converting ISO 8601 datetime fields using pandas

I have a datetime field in a Pandas dataframe that becomes problematic when using ArcGIS Pro to load data from a csv to a table on ArcSDE. The field in Pandas looks like this: 2007-02-01T05:00:00....
user avatar
1 vote
1 answer
84 views

Query for ST_Geometry line vertices via a recursive SQL WITH clause?

I'm exploring ways to get ST_Geometry line vertices as individual rows in a query resultset (via Oracle SQL). The reason being, ST_Geometry doesn't have a GetVertices function (see ESRI idea here). ...
user avatar
  • 754

1
2 3 4 5
29