Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

253 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
405 views

How to compress enterprise geodatabase with stored procedure?

I'm looking for a stored procedure in ArcSDE for SQL Server which performs geodatabase compression to include it in our daily maintenance plan. Is there any such thing in ArcSDE 10.0?
2
votes
0answers
763 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
2
votes
0answers
123 views

Storing Shapes in database

What is more effective? Storing Shapes as shape column (http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/topology_basics.htm) in database? Or maybe store shapes in seperate tables ...
2
votes
0answers
72 views

ArcSDE Feature View in a GeoDatabase other than the Feature's Database

here is the problem I have been struggling with: We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
2
votes
0answers
259 views

Importing Rasters to ArcSDE 9.3.1 using sderaster

OK, I am trying to import a raster to 11g using the sderaster command. It is a stand alone jpg with a world file associated, and pyramids. Am I right in assuming I cannot import a JPG, I can only ...
2
votes
0answers
262 views

ArcObjects .NET 9.3 upgrade to 10 breaks IRasterDataset.Copy(…) code

I have to upgrade an application from ArcObjects 9.3 (C# .NET) to 10. Unfortunately, there seems to be some incompatibility regarding the IRasterDataset.Copy method. The following code worked fine in ...
2
votes
0answers
167 views

How can I upload an annotation featureclass to ArcSDE using C#?

I can upload the shape files to ArcSDE database successfully,but I fail to upload annotation featureclass.
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
31 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 ...
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 ...
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 ...
1
vote
0answers
44 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
0answers
53 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
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 ...
1
vote
0answers
27 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 ...
1
vote
0answers
45 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. ...
1
vote
0answers
74 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 ...
1
vote
0answers
40 views

arcpy.da.ListSubtypes returns empty IOError on 64bit

I'm trying to use “ListSubtypes” function in ArcGIS Python. It works on 32bit environment (f.e. - Desktop), but it does not work in 64bit (f.e. - Server) and returns IOError without any information –...
1
vote
0answers
166 views

Recovering accidental edits through ArcGIS Pro Version Changes window?

We have a situation with our ArcSDE where features were accidentally deleted inside a version and we would like to recover those changes. We cannot undo edits because they were saved in a previous ...
1
vote
0answers
35 views

Using primary key in ArcSDE Enterprise Geodatabase with MS SQL Server?

Does setting a primary key constraint in a field obstruct the compression of a versioned geodatabase? I read someone mentioning that the primary key in a versioned geo-database will cause problem ...
1
vote
0answers
36 views

Add spatial index to versioned feature class

I try to add spatial index to versioned feature class (Oracle SDE) using toolbox "Add Spatial Index" in ArcGIS 10.6 . When I try it as Data owner I have error message -"Tool must be run as owner of ...
1
vote
0answers
106 views

Setting PostgreSQL privileges for ArcGIS?

I'm migrating from SQL Server and setting up my first PostgreSQL server for use with ArcGIS. I've followed esri tutorials and related how-tos. I'll be using a versioned editing environment, as I ...
1
vote
0answers
28 views

Considerations for projecting enterprise database to a new coordinate system

I currently maintain an enterprise geodatabase where the data is projected in a state plane coordinate system. Recently the data has extended past state boundaries. The data units are in feet and ...
1
vote
0answers
70 views

Appending polygon features from file geodatabase table to SDE table?

I am facing an issue while appending the feature class to ArcSDE feature class. All the I am trying to append the gdb feature classs data, I can see that the geometry is either changed and some cases ...
1
vote
0answers
247 views

How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned?

How can I create a trigger to capture when a field is changed from one value to another if my data is versioned? I am not able to run an UPDATE trigger and grab ':new' and ':old' values because with ...
1
vote
0answers
59 views

Where is XSD file for XML found in Gdb_Items table?

I would like to be able to deserialize the xml in Gdb_items table using .NET. The xml in an sde geodatabase appears to be the same as the xml returned using the File GDB API. I tried using xsd.exe ...
1
vote
0answers
67 views

ArcGIS PostgreSQL Trigger

I currently have a trigger defined in my database which executes when my edits in ArcMap are saved using the AFTER INSERT ON method. Is there anyway to execute this trigger without having to select ...
1
vote
0answers
58 views

Editing Spatial View in ArcMap?

Can spatial views be edited via ArcMap and, if it is possible, then how do I do it? I do have my Enterprise Geodatabase on Oracle.
1
vote
0answers
40 views

Cannot Create Topology in SDE

I am trying create a topology for a zoning dataset in my SDE feature dataset. I've run into a few issues. First off was an issue with versioning that this questions resolved: How to solve "Cannot ...
1
vote
0answers
159 views

Layers from a PostgreSQL/ArcSDE database connection are not showing in ArcGIS

We have a PostgreSQL/PostGIS SDE enabled database, but lately there is a strange issue when adding layers from this database to ArcMap or ArcGIS Pro. We can connect to the database without any issues ...
1
vote
0answers
18 views

What is Oracle/ArcSDE doing to my simple WKT Conversions?

I have no way to explain the output of the following: DECLARE splitGeom sde.ST_Geometry; stas CLOB; BEGIN SELECT sde.st_geomfromtext( 'POLYGON ((468221.1280508253 ...
1
vote
0answers
56 views

Copying/Inserting features AND user-defined Attributes as input to existing feature class in SDE using ArcPy?

import os, arcpy, zipfile, glob # INPUT ZIP FILE infile = arcpy.GetParameterAsText(0) path = "D:\Database_Connections" NAME = arcpy.GetParameterAsText(1) CODE = arcpy.GetParameterAsText(2) SOURCE = ...
1
vote
0answers
188 views

How to Unregister Replicas that have an invalid data-set information using ARCGIS REST APIs Version(10.2.1)

I am writing an application which will UnRegister replicas that are currently available. I managed to unregester new replicas which have the latest Server Url address stored in the DATASET_INFO field, ...
1
vote
1answer
71 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 ...
1
vote
0answers
211 views

ArcGIS SDE next rowid value doesn't increase at a constant rate

Using ArcGIS 10.5.1 and Postgresql 9.5 database, I created a point feature class named Locations. After I inserted 8 points in my Locations table, the objectid value of last row is 8. An hour later, ...
1
vote
1answer
480 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 "...
1
vote
0answers
38 views

Unable to store relative pathnames to data sources in ArcGIS Publisher

The Publisher extension in ArcGIS Desktop 10.5.1 isn't saving the relative data source for our enterprise geodatabase layers. The data sources are referencing the enterprise geodatabase directly ...
1
vote
1answer
339 views

Change Version Option Grayed out in ArcGIS Pro

I am experimenting with versioning data from an SDE database in ArcGIS Pro. I able able to create a new version, no problems, but when I go to change the version in the Data Source tab on the Contents ...
1
vote
0answers
78 views

ArcGIS Enterprise Geodatabase - MSSQL Server Permisions & Schemes

I have an active directory group called GIS_Admins. I have created a Server Login that points to this group and the group is mapped to a user for the appropriate database. The User has been made a ...
1
vote
0answers
652 views

GDAL with ArcSDE driver

I am attempting to use GDAL/OGR to read from an SDE enabled database (MS SQL). I have tried the steps located here but do not have access to the database server. I am also using a GDAL installation ...
1
vote
0answers
18 views

Using output Feature Dataset of Import XML Workspace process as parameter for continued processing in same model?

I am setting up a model for some automated SDE creation. As of now, I manually import XML Workspace schema to a new SDE database, then run a model where I manually input the created Feature Dataset ...
1
vote
0answers
51 views

How do I get the coordinates of the nearest point on a polygon?

The following SQL uses ST_Geometry to return a resultset of 10 records, ordered by distance from a fixed location (a point geometry) to the nearest point of the polygon. How do I get the coordinates ...
1
vote
0answers
61 views

Moving annotations, or texts, without making changes in enterprise geodatabase?

I'm working in a company, producing cadastral maps in ArcGIS where some clients prefer the maps being delivered in a .dwg-format. We're using a tool which preserves the feature class styles when ...
1
vote
0answers
50 views

Converting dimension feature class into standard feature class using ArcGIS Desktop?

I have found very little information regarding if it is possible to convert a dimension feature class into a standard feature class. This would hypothetically be done in an SDE environment. Our theory ...
1
vote
1answer
55 views

Disabling Start Editing command using ArcObjects?

How do I disable the Start Editing button in ArcMap when an added ArcSDE database version is the default? IMxDocument pMxdoc = m_application.Document as IMxDocument; IMap pMap = pMxdoc.FocusMap; ...
1
vote
0answers
31 views

Checking which layer edited under specific version?

I have approx 100 feature class in SDE database. Out of this someone edited 10 in "test_1" version feature class(assumed). Now i want to know with script or manual which feature class is edited under "...
1
vote
0answers
292 views

Esri ST_Geometry functions too slow on Oracle

I'm writing an SQL statement to create a feature class and using st_geometry functions. But it's taking too long. So I begin the statement with a join, which is taking 150-200ms SELECT PRC.OBJECTID ...
1
vote
0answers
156 views

ArcSDESQLExecute: Mismatching number of BEGIN and COMMIT statements

I have the following sql update query that I am using as part of a larger python script. It essentially takes data from one Feature Class (FC) to update a Versioned View of a different FC. ...
1
vote
0answers
46 views

Cannot connect to current version of enterprise database (PostgreSQL) through PHP

Very new to PHP, and working on a simple edit page. I'm connecting to multiversioned Postgresql database that I set up in ArcMap using a PHP/HTML file. I'm using the pg_connect command with host/...