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
vote
1answer
24 views

ArcObjects - IFeature HasOID property returning false when there is clearly an OID [closed]

When inspecting features in my featureclass, I am checking to see if a feature has an OID using the HasOID property. Even though the feature(s) clearly has an ID on visual inspection (via ArcMap), the ...
3
votes
1answer
84 views

Performance of arcpy.Exists() in SQL Server enterprise gdb environment

While iterating on a list containing table names, I used arcpy.Exists() to check if a table/featureclass exists. This action is very time consuming. I've ended up using a database approach select ...
0
votes
0answers
37 views

Release SDE locks from arcpy.da.Editor in same process

Is it possible to use arcpy.da.Editor and have it release its SDE locks in the same process? I am using arcpy and trying to perform edit operations on an SDE version, then reconcile/post/delete the ...
1
vote
0answers
27 views

Oracle Enterprise GeoDatabase force logging vs nologging [closed]

Our production Enterprise GeoDatabase running on Oracle has been configured at the database level to force logging. ArcSDE DBTUNE defines many tables and indexes by default to be NOLOGGING for ...
2
votes
0answers
36 views

Having functional copy of geodatabase in same SQL Server instance? [closed]

Having an Esri Enterprise geodatabase, I want to have a copy of the database in order to make some tests. I have an instance of SQL Server, and I do not want the overhead of installing and maintain ...
1
vote
0answers
25 views

Geodatabse Compression does not make changes in Base Tables [closed]

This question has been asked here GDB Compression Not Updating Base Tables, but the solution provided is not what I am looking for. I have registered a feature class and made some edits in that ...
2
votes
2answers
126 views

How to make ArcMap aware of the changes that are made in base table? [duplicate]

I am using ArcMap One-way replication tool to synchronize feature classes from Oracle to MS SQL Server (once a day), but replication only works for the versioned data with move edits to base option as ...
1
vote
0answers
91 views

ArcMap Replication tool does not synchronize changes made from database tool i.e SQL Developer? [closed]

I want to synchronize some datasets and feature classes from Oracle to MS SQL Server using ArcMap replication tools. Both databases are geodatabase enabled. I don't want to replicate/synchronize data ...
0
votes
0answers
24 views

How to update geometry in PostGIS for features that are in an ArcGIS enterprise geodatabase (SDE)?

UpdateGeometrySRID is not working for some reason, I think this may be due to it being an enterprise geodatabase? I also tried the manual version of UpdateGeometrySRID, where you alter the table and ...
0
votes
0answers
32 views

How to interpret SDE.ST_GEOMETRY.POINTS

In the documentation says is "Contains the byte stream of the point coordinates that define the geometry"... but how does one extract the points from the binary? I'm NOT looking for ST_TOTEXT, that's ...
0
votes
1answer
31 views

Seeking Public ArcSDE Server?

I am product testing and would like a sample ArcSDE server to connect to for testing. Does anyone know of ones that are still out there available?
1
vote
0answers
38 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 ...
0
votes
0answers
64 views

Repoint enterprise geodatabase connection using ArcPy in ArcGIS Pro

I have an ArcPy script that changes the connection parameters for every item in a layer file from a SQL Server connection to a PostGIS connection. This script works perfectly in ArcGIS Python version ...
1
vote
1answer
58 views

Connect to a SQL Server database from MS Access [closed]

I have an existing Microsoft SQL Server database which has been configured as an Enterprise geodatabase. I want to access it in MS Access in order to extract data to populate a form. What is the ...
0
votes
2answers
28 views

Storing related tables and toolboxes within feature dataset?

I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset ...
0
votes
1answer
53 views

SDE to CSV slow transfer speeds

I'm trying to move a feature class on our network SDE that's made up of polylines as a CSV file to the local machine (or fileGDB but slow speed seems to be the theme regardless of output format) ...
0
votes
0answers
15 views

Update a join table in SDE

I'm trying to make edits to a versioned SDE Feature Class. I joined a table that contained a list of all the point IDs that need to be updated. I called these PT_ID1 and joined them with PT_ID in the ...
1
vote
1answer
24 views

arcpy Select_analysis where_clause objectid [closed]

Trying to copy features from sde to fgdb but only when the objectid is below a certain number. outpath = r'C:\Users\CHOK\Desktop\SDE Conversion Project\TEST.gdb' query = '"objectid" < ' + "'121'" ...
1
vote
0answers
31 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 –...
2
votes
0answers
31 views

Editing Parcel Fabric in Versioned Geodatabase

We keep our parcel fabric in a SDE database with an intermediate staging version that multiple users post changes to from their own personal edit versions. We're able to edit the parcel fabric ...
0
votes
0answers
123 views

Why does opening SDE Workspace Factory ask for credentials again? ArcObjects C#

I'm trying to open SDE Workspace Factory using IWorkspaceFactory.Open I give the complete Property set in the code to open. ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS....
1
vote
0answers
88 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 ...
0
votes
1answer
60 views

How to import data (with schema) from MSSQL to PostgreSQL?

I have an ArcSDE enterprise geodatabase in MS SQL Server 2008. I want to replace MS SQL Server with PostgreSQL. I have setup and created the enterprise geodatabase in PostgreSQL and now want to ...
0
votes
0answers
18 views

Importing XML to specific version of ArcSDE?

I am working in a distributed environment. I've got the data update for a specific version of enterprise geodatabase. Is there any way to import that XML in specific version? We have a province ...
0
votes
0answers
61 views

Foreign key value in destination table is nullified when origin feature is deleted from ArcGIS relationship - workaround?

I have an SDE geodatabase in which I have an origin feature class with relationship classes to several destination feature classes and tables. When a feature is deleted from the origin table, the ...
1
vote
0answers
28 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 ...
0
votes
0answers
53 views

Connecting ArcSDE geodatabse 10 from ArcSDE service Version 9.3

I have recently upgraded ArcSDE Geodatabse from 9.3 to 10.0. The applications were using SDE connection through ArcSDE Windows service V 9.3 Now when I tried starting the same ArcSDE windows service ...
2
votes
1answer
43 views

How to hide certain views from ArcCatalog?

I have users that connect to an enterprise geodatabase via OS authentication. They use a couple of methods: An .SDE connection in ArcMap A ODBC connection for MS Office The users need to be able to ...
0
votes
0answers
21 views

Creating geodatabase, that has all layers used in creating map from different geodatabses?

I have been working on creating a city map, that had layers sourced to different gdbs stored on my desktop, now my final product is ready after 3 months and I have to package the datasets and send ...
1
vote
1answer
167 views

Reading .sde connection file without Esri softwares?

I would like to be able to read connection properties from an sde file without any Esri dependencies such as Arcpy, ArcObjects etc. Is this possible?
0
votes
0answers
100 views

One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
0
votes
1answer
98 views

Portal And ArcSDE Geodatabase: Feature Datasets or Not

We recently had a health check with an Esri representative, to look at our Portal system. After looking at our ArcSDE enterprise geodatabase she said it was organized very well with everything put ...
0
votes
0answers
79 views

Using OS authentication for users with period in name when editing PostgreSQL database from ArcMap?

I am trying to set up a PostgreSQL server to integrate our active directory credentials. I can edit the pg_hba.conf file to allow users with an internal IP to connect with OS authentication. host ...
1
vote
0answers
50 views

Understanding terminologies on Esri ArcSDE [closed]

I am new to ArcSDE. Can anyone help me understand the differences between versioning, replication, synchronization, archiving, editor tracking, and schema change? Their concepts are similar to me. ...
1
vote
1answer
178 views

Execute Oracle stored procedure from ArcSDESQLExecute

I'm attempting to execute an Oracle 12c stored procedure using ArcSDESQLExecute: import arcpy egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\con1.sde") sql = '''execute update_sle (...
0
votes
1answer
42 views

Why shouldn't you edit in a replicated database

Say you replicate a database to another database. Are there any reasons you wouldn't want to edit your replicated data other than having different data in the replica database than in the database you ...
0
votes
2answers
182 views

ArcSDE Enterprise geodatabase compress error

My organisation has ArcSDE enterprise geodatabase(ArcGIS 9.2) with MS SQL Server 2008 as DBMS. When I compress the geodatabase I am getting the follwoing error Failed to compress the database. ...
0
votes
0answers
41 views

Does the geodatabase administrator login rebuild indexes for datasets not owned by the login?

According to the ESRI documentation, the Rebuild Indexes tool is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In ...
1
vote
0answers
34 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
83 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 ...
0
votes
0answers
23 views

Deleting users and roles on ArcSDE for PostgreSQL geodatabase?

I can easily create users and assign them to roles using the context menus in ArcCatalog or the geoprocessing tools, but how do I delete users and roles? Do I have to go into pgAdmin?
1
vote
0answers
27 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 ...
0
votes
0answers
48 views

AddRastersToMosaicDataset_management performs slow

I have an enterprise Geodatabase (SQL Server) on my ArcGIS server machine. I perform my computations on several rasters on another machine (80 *.tif s with mean size of 50kb). When I want to add the ...
1
vote
0answers
57 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 ...
0
votes
2answers
129 views

Connect QGIS to Esri geodatabase hosted on RDBMS (PostgreSQL)

I have an ArcGIS 10.5.1 enterprise geodatabase hosted on PostgreSQL 9.4 (non-PostGIS enabled, but with SDE.ST_Geometry support). I'd like to add some feature classes as layers in QGIS. How can I do ...
2
votes
0answers
49 views

ArcMap Date values lose precision after copying feature class from fGDB to SDE GDB

I have some data in a file geodatabase feature class including some date fields. The precision on the date fields is to milliseconds and this is important. When I copythe feature class from the fGDB ...
0
votes
1answer
60 views

Updating/modifying Network Dataset roads source in Enterprise Geodatabase (ArcSDE) using ArcPy?

I am trying to create a Python script that automate the update of roads source used in a network dataset stored in a Enterprise Geodatabase (SDE). In short, I want to truncate the roads feature class ...
1
vote
0answers
172 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 ...
0
votes
0answers
27 views

Working with a small spatial extent from a large dataset in ArcMap

I am currently working with large amounts of forest data where surveyors and ecologists measure and assess the quality of the vegetation in the field and send the result as CAD files on a daily basis ...
-1
votes
2answers
104 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") ...