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
1answer
265 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
74 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
266 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
112 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
1k 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
59 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
418 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
19 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
223 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
26 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
959 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
510 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
547 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
2k 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
57 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
526 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
67 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
199 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
235 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
81 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
votes
1answer
503 views

Does Spatial Index make feature class faster? [closed]

Does spatial index make dataset work faster? Are there any disadvantages in having it? All datasets in my sde don't have a spatial index. I thought I should add it to make things faster
4
votes
1answer
719 views

Using database connections in ArcPy with ArcGIS Pro (arcgispro-py3)?

Since Pro stores database connections in a project, how do we connect to a database from within a standalone python script? For example below is how I would have previously connected in ArcGIS 10.5 ...
1
vote
1answer
1k views

CreateEnterpriseGeodatabase_management fails on PostgreSQL claiming ST_GEOMETRY not present

I have a PostgreSQL server (9.3.10) already setup for ArcGIS enterprise GDBs with one GDB already in it (created in the past, with ArcGIS 10.3 I believe). I am using ArcGIS 10.5.1 on my client to ...
3
votes
1answer
468 views

Can't find feature classes when creating SDE connection file with credentials

EDIT: When I try to access the workspace properties of the connection file, it says that the method workspaceType doesn't exist for describing data. When I use the regular 'Database Connections\myDB....
0
votes
0answers
100 views

Inserting geometry in ArcSDE table?

I have a test point table that created via ArcMap create feature class tool. And I am using ArcGIS 10.5 and PostgreSQL 9.5 database. I am using PG_GEOMETRY. I want to insert a sample point using sql ...
4
votes
0answers
23 views

Replacing polygon within composite relationship without deleting tabular record? [duplicate]

I have a geodatabase that contains a table, a point feature class, and a polygon feature class. Each record in the table has both a related point and a related polygon, so all one-to-one ...
0
votes
2answers
195 views

Having trouble starting an edit session on SDE with edit permissions set for user

I have at least 15 people editing on one of our Enterprise SDE Geodatabases. I set up another user to edit and it is giving me an error I can't figure out. I set the same exact permissions as the ...
0
votes
1answer
86 views

Snapping doesn't work when many enterprise layers load

I am using Arcmap 10.6, when I have only limited number of enterprise layers loaded, the snapping experience process is painful. My cursor turns to "Busy" shape (the blue circle) and can't snap to the ...
0
votes
1answer
171 views

ArcSde for Sql Server 2014 enterprise

I Want to Add Database Server in ArcCatalog. My Database is Sql Server 2014 enterprise;When I try, It returns that "Connections to this edition of the database Server are not Supported". I Searched ...
0
votes
1answer
200 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 ...
1
vote
0answers
246 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, ...
7
votes
1answer
439 views

Using ArcPy or SQL methods to truncate data from ArcSDE feature classes and tables?

There are a handful of ArcPy methods for truncating data in a table. It's also possible to do a direct SQL command to truncate a table (e.g. TRUNCATE TABLE DBO.VALVES) via a Python library (e.g. ...
0
votes
1answer
553 views

Query for tables that are not registered with option to move edits to base

I have an Oracle enterprise geodatabase. In theory, all 500+ tables in the database should be registered as versioned, with the option to move edits to base. However, it has come to my attention that ...
1
vote
2answers
324 views

Checking ArcSDE Compatibility with SQL Server

I am trying to find if I can use ESRI sde 10.5.1 with a SQL Server 2016 SP1. I am not able to find this information. What I've found so far: On the Microsoft SQL Server database requirements for ...
1
vote
1answer
558 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
1answer
460 views

Reading an OGR VRT with geometry from an Oracle OCI data source

I am having trouble creating/reading OGR VRT files from an Oracle OCI data source. I am running GDAL 2.2.1 on Windows 7 Professional SP1. My data source is an Oracle 11g (11.2.0.4.0) 64bit database ...
3
votes
1answer
698 views

ArcGIS sde i5,i6,i7 tables

I have created an ArcGIS enterprise geodatabase. There are i5, i6,... i30 tables in the sde schema of my geodatabase. What do these tables do?
4
votes
1answer
137 views

ArcGIS database feature class editor default version settings

I created an enterprise geodatabase with ArcCatalog 10.5 in my PostgreSQL database. And I created feature class in database. But when I add feature class in arcmap, I need to change the editor ...
1
vote
1answer
678 views

How can I set sde object id from QGIS

I have connected a geodatabse that was created by ArcGIS. My geometry type is PG_GEOMETRY. I can connect the database in QGIS and add a feature table as a layer. When I create new spatial data in this ...
0
votes
1answer
415 views

QGIS geometry insert on ArcGIS sde table gives st_geometry error

I have created an enterprise geodatabase with ArcGIS 10.5 in a PostgreSQL 9.5 database. And I set the PostGIS template to my database. So when I create a feature class in database, I can add this ...
2
votes
0answers
292 views

Export Query Layer does not return all values [closed]

When I create a query layer, the attribute table has 1004 records. When I attempt to export this data to a file geodatabase, it only has 523 records. I have tried exporting to a personal geodatabase, ...
1
vote
0answers
42 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 ...
2
votes
0answers
146 views

Joining an ArcGIS Enterprise Database to another SQL database [closed]

I'm curious if it is possible to join an ArcGIS enterprise database to a separate SQL Server. My intention is to have 1 unique attribute on the ArcGIS layer that can reference the row in the SQL table ...
2
votes
1answer
1k views

Can't Register table with Geodatabase - ArcGIS 10.5, PostgresSQL 9.5

I have made connection to a postgresql database in ArcGIS Catalog from Database connections . pgAdmin shows the database owner is 'postgres' so i have made the connection with user 'postgres'. I ...
4
votes
2answers
88 views

Keeping Default Version of Geodatabase protected?

I have a multiuser geodatabase with Oracle Enterprise RDBMS. The Version of the geodatabase is 10.4.1 and Oracle 11g. We have over 35 data editors with the flat version tree, each user having their ...
0
votes
1answer
146 views

Reason for a Data Loss While Making Schema Changes on SDE - Oracle DB [closed]

I am not an expert when it comes to Administering Multi-User Geodatabase. However, I refer to Esri's documentation for best practices and efficient workflows before putting on my GIS Admin's hat to ...
1
vote
1answer
495 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
1answer
425 views

Improving poor performance of ArcPy update cursor with ArcSDE and Editor? [closed]

I am using ArcGIS 10.5 in an ArcSDE environment. I have two tables, they are the exact same table schemas, but one is being edited and those edits are being pushed to the main table. I am a little ...
1
vote
0answers
91 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 ...
0
votes
3answers
1k views

Save Edits Error, SDE

We have SDE Running on SQL Server 2008. I have one user that receives this error once in a while, and not sure why he is the only one receiving it. I have not seen this error before. I checked ...

1
3 4
5
6 7
28