Questions tagged [enterprise-geodatabase]

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

242 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
399 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
758 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
115 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
261 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
166 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
21 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
41 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
35 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
30 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
74 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
27 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
33 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
76 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
26 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
53 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
152 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
46 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
48 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
55 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
36 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
89 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
16 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
51 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
169 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
55 views

Selecting polygon feature classes with 1 record in ArcSDE using SQL query?

I have an ArcSDE database with many feature classes.I would like SQL query to find all the polygon feature classes with only record in its table. So far, i can only query all the feature classes. ...
1
vote
0answers
161 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
343 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
36 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
0answers
230 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
47 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
499 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
17 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
46 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
49 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
46 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
51 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
245 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
1answer
69 views

Production Mapping “Load Data” Tool having issues with SDE

I am attempting to use the Production Mapping tool "Load Data" to import data from many personal databases into a new SDE database (SQL server RDBMS). The schema between the PGDB's and SDE is the ...
1
vote
0answers
132 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
42 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/...
1
vote
0answers
38 views

SQL Server: Physical Memory and Arc Cursors

I implemented a script recently that uses an update and search cursor on a large feature class database of over 20,000 records. This script runs nightly. This is an SQL Server database with an ArcSDE ...
1
vote
0answers
37 views

Why do the values of fields change after choosing unique identifer , SDE

I have a large dataset table from an SDE (SDE is the term my company uses to refer to this .under its properties (Oracle Enterprise Geodatabase). When initiated adding the table dataset to my ArcMap....
1
vote
0answers
130 views

Can two feature classes share geometry and have different attributes with ArcGIS Desktop?

Is there a way for two feature class (say parent and child) to share same geometry shape but have their own set of attributes? Features created or updated on parent feature class transfer its geometry ...
1
vote
0answers
333 views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running PostgreSQL and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
1
vote
0answers
333 views

ESRI Table error: does not exist but it does exist in GDB

I am attempting to iterate through all tables in a Enterprise GDB and get all values in second column but I am getting an IOError error: processing... SJLU.FIRE_HYDRANT_PIPE_DIAMR_LK_MV Traceback (...
1
vote
0answers
118 views

Importing domains to ArcSDE?

Is there a way to import a geodatabase into a sde on the server and keep the sde domains, while adding the new geodatabse domains?
1
vote
0answers
376 views

ArcCatalog open sde geodb fails: “possibly sdehome/temp is full”

I'm trying to open a connection to an sde geodatabase with ArcCatalog 10.4.1 that was previously working. But now I get the error: "possibly $SDEHOME/temp is full" and ArcCatalog crashes. Does ...