We’re rewarding the question askers & reputations are being recalculated! Read more.

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
64 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
132 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
139 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
169 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, ...
6
votes
1answer
233 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
294 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
259 views

ESRI SDE 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 this page, it states that the 10.5.x version of ArcGIS ...
1
vote
1answer
355 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
332 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
419 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
92 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 ...
0
votes
1answer
218 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
296 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
225 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
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 ...
2
votes
0answers
89 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
686 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
67 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
92 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
0answers
244 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
240 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
48 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
741 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 ...
3
votes
0answers
693 views

arcpy.ListFeatureClasses returns empty list

I'm working with SDE connection and want to find if a layer exists on a server. Code sample is: ws = r'Database Connections\Connection to sde-srv.sde' # second option to access connection file, same ...
1
vote
1answer
181 views

st_geometry syntax for Oracle Sql

I'm trying to pass in a geometry(polygon) collected as an ESRI.ArcGIS.Client.Geometry.Geometry type on a map and passing it as an IN parameter into an oracle sql query. I'm also trying to use ...
1
vote
2answers
593 views

Slowness query - ArcGIS Server

A viewer is being developed with the Api Javascript of Esri 3.21 and several queries are made through QueryTask to some services that we have published in ArcGIS Server. It has been observed that the ...
1
vote
0answers
519 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 ...
7
votes
2answers
524 views

How are unsaved/temporary edits stored during versioned editing?

In ArcGIS Desktop, I can edit versioned, Oracle tables. I generally edit the default version, and I've registered the tables as versioned with the option to move edits to base. I do things like: ...
0
votes
2answers
586 views

Better approach for selecting related records in multiple featureclasses based on query of related table? (sde/SQL server)

I have an enterprise geodatabase (SQL) that contains a table ("linktable") which has a key field (Main_ID) that is also in up to a dozen related feature classes (via a relationship class). I want ...
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
votes
1answer
617 views

Opening ArcSDE connection file ( .sde ) & checking syntax?

When I used Notepad++ to open ArcSDE connection file(.sde) encoding ANSI, it's just messy code! Is there any application available to open it ? Or anyone can give a sde file example encoding utf-8 ...
1
vote
0answers
34 views

Which Table is Holding Layers Information and Relationship with Actual Tables in Enterprise Geodatabase [closed]

Can you please let me know which table(s) of Enterprise Geodatabase on top of SQL Server contains contains information about layer ID showing on service URL "layers": [ { "id": 0, "name": "...
1
vote
0answers
47 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
50 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 ...
2
votes
0answers
67 views

One way replication - Parent Database read only access [closed]

I am planning to setup one way replication from parent to child . My team only has read access to the parent database (SQL server) and child database is our own managed sql server. Is it possible to ...
0
votes
1answer
240 views

Creating point from lat / lon values stored in two fields?

I'm trying to create a point from latitude & longitude values stored in two fields (lat, lon). I need to perform a transform to get the point from its source coordinate system into the coordinate ...
0
votes
1answer
99 views

Writing domains with coded values in ArcSDE Enterprise Geodatabase

I'm trying to write a new domain and values in our ArcSDE database but I receive the following error: Runtime error Traceback (most recent call last): File "", line 34, in File "c:\program ...
12
votes
3answers
1k views

Create Layer from Selected Features tool: How is the list of features stored?

In ArcGIS Desktop, there is a tool called Create Layer from Selected Features. Using this tool, I can convert a selection to a layer in ArcMap. It's my guess that there is a "list of features" that ...
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 ...
2
votes
2answers
463 views

ArcSDE PostgreSQL mixed environment error connecting to schemas

I have an enabled ArcSDE enterprise geodatabase with PostgreSQL 9.4 and ArcGIS 10.5.1. I am the database administrator and have only 2 other users who I work with use these SDE/DB connections. I ...
0
votes
1answer
62 views

arcpy.da.Editor not saving edits to base Oracle Spatial tables

Can't post code because of Fed policy, so I will ask the question here. We are working on a series of polygon feature classes that are used to define large activity areas. These polygons are modified ...
0
votes
1answer
457 views

Definition Query for records created in the past 30 days in and SQL SDE?

I am stumped as to how to get this to work in ArcMap... I have records being created ever day, and would like to be able to show records on a map that have been created within the last 2 days based ...
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; ...
2
votes
1answer
55 views

How to Modify and Combine rows in an attribute table?

I would like to modify this attribute table. This is an example First arrange column “ORG_FID” in ascending order If the number of rows corresponding to the column “block Number” is same as well as “...
0
votes
1answer
106 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 ...
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 "...
4
votes
3answers
2k views

PostGIS and ArcSDE mixed environment

I am trying to setup up a enterprise geodatabase with ArcGIS 10.4.1 and PostgreSQL 9.4 where I can use PostGIS for my SQL queries in PostgreSQL and have the sde functionality. I have a windows ...
2
votes
1answer
541 views

How to push newly added or updated domain values to ArcGIS rest service?

I'm currently using ArcGIS Server 10.4 for my REST service and ArcGIS Online. I have created a domain list and assigned it to a field. All of it works fine. I'm currently using Oracle for my ...
1
vote
1answer
57 views

Appending problematic polygon from File Geodatabase to Oracle ArcSDE using ArcPy?

I have a File Geodatabase that has some polygons in it. I am using append to copy them to an Oracle SDE 10.2 database. However there are some polygons that when imported have a null value for shape in ...
1
vote
1answer
131 views

What DBMS is used by ArcGIS Online? [closed]

I work in an Oracle shop. My I.T. department uses ArcGIS Online to host data for use in data collection activities. The data goes through a yearly cycle: Export from our Oracle enterprise ...