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
4 answers
109 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 -...
5 votes
6 answers
4k views

ArcMap Append (Data Management) Tool is not working correctly

Software version: ArcMap 10.5 I am attempting to append data from a Shapefile into an existing SDE Geodatabase feature class using the Append (Data Management) tool. The tool runs, and the results ...
0 votes
0 answers
28 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 ...
0 votes
1 answer
45 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))), ...
0 votes
0 answers
28 views

Get map to use ST_GEOMETRY function-based spatial index

SDE.ST_GEOMETRY — Oracle 18c — ArcMap/EGDB 10.7.1: I have a view that returns the startpoint of lines as an ST_GEOMETRY column: create or replace view bc_atn_startpoint_vw as ( select objectid, ...
0 votes
1 answer
52 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 rownum_, ...
0 votes
0 answers
16 views

Saving layers from ArcSDE to layer file using ArcMap

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 ...
2 votes
1 answer
129 views

Function-based spatial index: Use sdo_geometry() constructor instead of custom function?

I have an Oracle 18c table that has XY columns, but not a SHAPE column. I've created a query on the table that dynamically generates an sdo_geometry SHAPE column. sdo_geometry(2001, 26917, ...
0 votes
0 answers
40 views

ora2pg SDO_Geometry to st_geometry

I am trying to migrate my database (Oracle) to postgres using ora2pg (v.23.1). Unfortunately the script converts our SDO_Geometry datatype into shape geometry(GEOMETRY,32632) instead of shape ...
0 votes
1 answer
30 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 ...
3 votes
1 answer
962 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
1 vote
2 answers
1k views

SDO_GEOMETRY view in ArcGIS Desktop

I have an sdo_geometry table that I created using ArcGIS Desktop (by converting an esri.st_geometry table to sdo_geometry). I'm using Oracle Spatial's sdo_geometry datatype because it has linear ...
6 votes
3 answers
4k views

Create an SDO_GEOMETRY view from a non-spatial table?

Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those ...
0 votes
1 answer
255 views

ArcObjects(Java) - register table to geodatabase ESRI 10.3

We are in need of connecting to the Oracle SDE schema for registering Tables to the sde schema using only ArcObjects(Java) is it possible to do that with no dependency. Assume the geodatabase was ...
0 votes
1 answer
54 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: ...
-1 votes
1 answer
114 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
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 ...
0 votes
1 answer
236 views

Create feature class with ArcObjects in SDE geodatabase returns No editable Layer

I Want To create Feature Class in an enterprise geodatabase with ArcObjects. This is the small part of the our plugin. In our case, we want to Create Feature Class in the database Identical to the ...
3 votes
5 answers
265 views

Materialized view with FAST refresh on remote table: How to include a SHAPE column?

I want to create an Oracle materialized view with the fast refresh option on a remote table (in an enterprise GDB). I can do this successfully without a SHAPE column: create materialized view log on ...
7 votes
2 answers
1k views

Get ArcGIS to recognize ST_POINT

I have a SDE.ST_GEOMETRY line feature class. I've created a view on it that returns an st_point column. SELECT OBJECTID, SDE.ST_STARTPOINT(SHAPE) AS START_POINT FROM ENG.ROAD There is a known Oracle ...
0 votes
0 answers
17 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://&...
2 votes
1 answer
61 views

View has no records when viewed in ArcCatalog

I have created a database view in an Oracle-backed Enterprise Geodatabase. I can see data in both of them when I view them using SQL Developer. However, when I look at the view in ArcCatalog (version ...
0 votes
1 answer
24 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....
0 votes
1 answer
28 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 ...
2 votes
1 answer
132 views

Convert ST_POINT subtype to ST_GEOMETRY supertype?

Oracle 18c; ArcGIS 10.7.1 I have a query that produces an ST_POINT column: --Mimics the SDO_GEOMETRY get_vertices function --https://docs.oracle.com/database/121/SPATL/sdo_util-getvertices.htm ...
1 vote
1 answer
116 views

Are XY event layers optimized/indexed on-the-fly?

Oracle 18c; 10.7.1 EGDB; ArcGIS Desktop 10.7.1 I have a non-spatial WORKORDER table that has X & Y columns. The table has 10,000 records. I’ve created an XY event layer from the table in ArcMap. ...
0 votes
0 answers
19 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., ...
0 votes
0 answers
22 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 ...
0 votes
2 answers
76 views

arcpy.SelectLayerByAttribute_management not selecting anything

I need to run a process on selected records only in a feature class stored in Enterprise geodatabase (SQL Server) that meet a certain condition: WC = "Status = 'U' AND IN_City = 'Big City' " ...
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 ...
4 votes
1 answer
426 views

Should slow refresh rate be expected while viewing 1000 points out of 100 million using ArcSDE/Oracle?

Is it normal to experience very slow refresh rate in ArcMap with 1000 points shown out of 100 million using ArcSDE/Oracle? I am testing a setup with ArcSDE/Oracle database to contain geographical data....
2 votes
2 answers
68 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 ...
0 votes
0 answers
29 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 ...
0 votes
1 answer
197 views

With in Version Difference (DifferenceTypeUpdateNoChange) how to pass IQueryFilter in ArcObjects

I want to know only real shape edits between 2 versions. How can I pass iQueryfilter to DifferenceTypeUpdateNoChange? public void DifferenceTypeUpdateNoChange(ITable sourceTable, ITable ...
2 votes
1 answer
696 views

Enterprise geodatabase on PostgreSQL backup and restore

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer. My backup command is as follows. host 5433 pg_dumpall -h localhost -p 5433 -U postgres -c -f "...
0 votes
1 answer
51 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 ...
2 votes
1 answer
291 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 ...
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 ...
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 ...
1 vote
1 answer
87 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). ...
0 votes
0 answers
27 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 ...
2 votes
1 answer
105 views

Selecting polygon feature classes with one record in Oracle geodatabase using SQL query?

I have an Oracle Enterprise geodatabase with many feature classes. I would like a SQL query to find all the polygon feature classes with only one record in its table. So far, I can only query all the ...
0 votes
1 answer
76 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 ...
1 vote
1 answer
65 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 ...
0 votes
1 answer
35 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 ...
-1 votes
1 answer
63 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 ...
1 vote
1 answer
121 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
0 answers
34 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 ...
0 votes
1 answer
33 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? ...
0 votes
1 answer
147 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 ...

1
2 3 4 5
29