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
-1
votes
2answers
109 views

Field mappings remove field from arcpyTable to Table conversion

I want to export a table but would like to remove one of the fields before doing so using arcpy. I'm trying to use field mappings but am missing something: fields = arcpy.ListFields("some_table") ...
1
vote
0answers
52 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 ...
0
votes
0answers
152 views

Invalid column value

I've been working on a script that corrects some links in a few feature classes in an enterprise database I have. The script works fine for the most part. When it gets to a certain feature class my ...
1
vote
1answer
38 views

Schema Locks Starting As Soon As User is Disconnected

I am having continual issues with scheme locks on our ArcSDE database, as soon as users are disconnected schema locks start appearing. We have 20 or so feature classes and it will show anywhere from ...
0
votes
1answer
62 views

Syncing database with ArcMap and ArcSDE?

I am using SQL in Oracle to fill and empty feature class table, basically something like this: INSERT INTO DAMO_W.BRUG (OBJECTID,CODE,NAAM,GLOBALID,SHAPE,CREATED_USER,CREATED_DATE,LAST_EDITED_DATE,...
1
vote
0answers
53 views

ArcPy not seeing ArcSDE datasets from IDLE or PyScripter? [duplicate]

I tested the code below from ArcCatalog 10.5's python console and IDLE+PyScripter. While in ArcCatalog everything works correctly(code is supposed to list available datasets and feature layers), in ...
1
vote
1answer
291 views

Multi client (QGIS.ArcGIS Desktop)/ multi-user editing environment [duplicate]

I'm using ArcGIS Desktop 10.6.1 with PostgreSQL 10.3/PostGIS 2.4 and would like to edit PostgreSQL polygon features regardless of client (QGIS/ArcGIS desktop) without having to create an ArcGIS ...
1
vote
1answer
62 views

Stop ArcGIS 'Geodatabase Adminstration' Reporting Connection as 'DBO' Instead of My Username?

We are running ArcGIS 10.5.1 and MS SQL Server, and using an SDE connection file which is configured to use 'Operating System' credentials. When most users connect, the 'Geodatabase Administration' ...
1
vote
0answers
55 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 ...
2
votes
1answer
59 views

Read SDE Feature Attributes without Arcpy

I've been building some software that reads/writes spatial and non-spatial data out of our SQL SDEs dynamically when called. As I've pointed out before Time Delay in Importing ArcPy , ArcPy takes ...
0
votes
1answer
320 views

“Runtime error: cannot open workspace” after creating a connection file and changing the version [duplicate]

I'm trying to run an update cursor. Usually if I have an issue with databases with enterprise connections, making a connection file clears it up. This time when I tried to execute my code I just get a ...
2
votes
1answer
72 views

Creating Relationship Class- Adding new records to table

I am creating a relationship class inside an SDE Environment (SQL Server 2016). I have a point feature class and a related table. I am trying to add rows to the currently empty table based off ...
0
votes
0answers
83 views

ArcMap PostgreSQL unique sequence

I have connected my ArcMap to my PostgreSQL db using the Create Enterprise Geodatabase tool in ArcMap. I have multiple feature classes and the relevant relationships between them loaded into the db ...
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 ...
0
votes
1answer
186 views

Pirmary key constraint on objectid field

I am trying to copy data from a PostgreSQL (9.4) DB table to an SDE table. Both have an objectid field. If I copy the data from the source table with the OID field, I get an error because the values ...
0
votes
1answer
21 views

MSSQL SDE_GEOMETRYnnn Tables

In my database, I've found a table (SDE_GEOMETRY276) with permissions granted to one user. My first thought was the "276" was either a layer_id or table registration_id. Searching sde_layers and ...
0
votes
1answer
93 views

Accessing ArcSDE feature class with ArcPy?

I have a script that runs perfectly with shapefiles and GDB feature classes but I need to change it to run on feature classes stored on an SDE. However I cannot figure out how to reference them ...
1
vote
1answer
22 views

Retire Dataset with Its Relationship Class

I need to retire datasets from our SDE databases to our Retirement Geodatabase. There are several relationship classes tied to these datasets. How can I export the feature class with its relationship ...
0
votes
1answer
60 views

Do Postgresql sequences work with SDE versioning?

I am migrating data from an older GIS system into an SDE system with PostgreSQL as the database engine. The current system generates a unique tag for several layers, I want to re-create this behavior ...
0
votes
1answer
55 views

Exporting Feature Classes in SDE to shapefiles and tables

How can I export feature classes and tables in SDE to shapefiles and tables? I am able to export the feature classes to shapefiles based on an extent. The problem I am running into is, I want to ...
0
votes
0answers
51 views

Table sde.state_lineages extremely slow

I'm running a ArcGIS 9.3 Oracle SDE geodatabase. Our ArcMap client is extremely slow at displaying versionned feature class. One table seems to be impacted : sde.state_lineages A simple SELECT * FROM ...
0
votes
1answer
25 views

Releasing user-schema locks when updating user-schema

Putting together a scripted event where we update user-schema (prod) in one sde instance from a dev user-schema instance. Both sdes are Oracle 12c. Replication is not used and the destination ...
0
votes
1answer
326 views

Failed to Copy SDE Dataset Error 000260 Using arcpy.Copy_management and arcpy.env.overwriteOutput = True [duplicate]

I thought I could use the arcpy.env.overwriteOutput = True to overwrite the existing datasets within my target SDE "JeffCoGIS.sde"; however, I get an error that states: ExecuteError: ERROR 000260: ...
0
votes
1answer
25 views

Changing cardinality of existing relationship class in enterprise geodatabase?

Is it possible to change the cardinality of an existing relationship class in enterprise geodatabase? I want to alter a 1-m relationship class to m-m
0
votes
0answers
63 views

SDE Table Vs Query Table in ArcMap

I have two SQL table with same columns/field name, but when I open both tables in ArcMap it shows different information in Source Tab. SDE table type shows all of the fields where query table type ...
0
votes
1answer
110 views

Add-In button Click open ArcCatalog window with list of .sde files

I want code to open ArcCatalog window with list of .sde files.The below code always opens an ArcCatalog window with home location. I have to go to database connections from the window which finally ...
3
votes
1answer
128 views

State ID Count after SDE Compression

I have a Enterprise Geodatabase (SDE) in SQL Server 2016. I have a nightly python script to preform some maintenance including the compress function (among other things). I am noticing that the ...
1
vote
1answer
222 views

Field calculator not working with ArcSDE?

I am working directly with ArcSDE and I want to add a field in the attribute table. I am able to add the field but it does not allow me to use the field calculator. Any thoughts?
1
vote
1answer
70 views

Why are short integer fields on SDE auto-updating to Precision 5?

I am having a perceived small issue in Server for ArcGIS (10.3.1 and 10.4.1 on SQL Server) where whenever a Short Integer field is added to a feature class, the Precision auto-updates to Precision: 5 ...
0
votes
1answer
215 views

Access geodatabase simultaneously by several users

We have a requirement to edit a Geodatabase simultaneously by several users. We have several GIS specialists who are loading the data at the same time and each time we have to copy paste the data ...
0
votes
0answers
56 views

How to undelete from ArcGIS versioned table?

We have a versioned table of polygons and one of our users have deleted every geometries. With Oracle's SQL Developer, i can see the table still containing the missing data, along with its Axxxx and ...
1
vote
0answers
106 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
2answers
85 views

Selective attributes not displaying in GeoCortex Essential Manager

I'm having trouble with Geocortex Essential Manager displaying the full set of attributes for a particular feature. Specifically, I have a parcels dataset and 4 related tables. I recently added a new ...
0
votes
1answer
634 views

Getting data source of Feature Layer object in Python script tool?

I am writing a script tool to update some records. I am wanting to use a feature layer as input, to maintain definition queries, selections, etc. I would like to get the data source of the input ...
1
vote
1answer
50 views

Database Connection window inaccessible in background / hidden

I have built an ArcGIS script tool that requires a connection to an external SDE geodatabase. When the script starts, it must first connect to that external Oracle database via the "Database ...
0
votes
1answer
289 views

Register with Geodatabase greyed out

I'm having trouble registering a table with a Geodatabase in an SDE, the option is greyed out. This is a weekly task for me and I have never had this happen before. I receive a new table weekly from ...
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 ...
3
votes
1answer
151 views

create spatial view in postgis on an ArcGIS table with ST_Geometry type

I am working on PostgreSQL 9.4.5 with Postgis 2.2.3. I work on a spatial table created on ArcGIS, with geometry type "ST_POINT". I would like to create a spatial view of that table in postgreSQL ...
-1
votes
1answer
25 views

Featureclass from dev env to test env

I am new to GIS. I have created a geodatabase. And inside this geodatabase i have created a feature class, i created a mxd file to publish feature service. Since this was all in development ...
0
votes
1answer
521 views

Getting user password from ArcSDE using Workspace Properties - python

Looking at this page for getting Workspace Properties I am wondering if there is a simple way to get a Users password from an existing SDE connection on the users machine? Using the code sample from ...
1
vote
1answer
280 views

Writing arcpy.ArcSDESQLExecute connection string for Oracle?

When using arcpy.ArcSDESQLExecute, I was trying to debug why a sql statement was not working and throwing an error. I thought the sde connection file that I was passing might be the problem because I ...
0
votes
1answer
261 views

Why is arcpy.ListUsers() not able to open SDE workspace?

I am working with ArcGIS Pro 2.1 and Python 3.6.2. and I am writing a script that involves the arcpy.ListUsers() function and whenever I run the code I receive the following error: The SDE workspace ...
0
votes
1answer
892 views

Retrieving deleted records from feature dataset in enterprise geodatabase?

I have an enterprise geodatabase with many feature datasets. I was editing one of the feature datasets and accidentally deleted some records from there. I did not realize and stop editing after saving ...
1
vote
0answers
54 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
1answer
283 views

Privileges, Register as Version commands are greyed out when right-clicking a feature class in an ArcSDE geodatabase

When right-clicking a feature class in an ArcSDE geodatabase from ArcGIS Desktop, the 'Privileges', ‘Register As Version’ commands are grayed out even though the user is connected as the data owner, ...
0
votes
0answers
46 views

Store multiple rasters in an enterprise database, independently

I have a large number of rasters with discontinuous data representing management plans for urban green areas which I want to store in an enterprise database independently. I don't want to mosaic the ...
1
vote
0answers
171 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, ...
0
votes
1answer
120 views

Preserving 'Created By' field when appending data in ArcGIS enterprise geodatabase

I am updating the schema of an enterprise geodatabase. My plan is to create an xml document of the database schema, make my changes within the xml editor, and then create a new GDB with the new schema ...
1
vote
1answer
56 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. ...