Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [enterprise-geodatabase]

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

1
vote
0answers
14 views

Geodatabse Compression does not make changes in Base Tables [on hold]

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 ...
-1
votes
0answers
19 views

Extracting specific column from attribute table from multiple feature classes using ArcPy? [on hold]

I have an ArcSDE with multiple feature classes. These all contain multiple layers and all of them have a column in the attribute table called (Load_Date) which is the date that these data were loaded. ...
-2
votes
0answers
14 views

Unable to edit on featuredataset in ArcMap9.2 [duplicate]

When I click on Start Editing button following error occurs: Could not edit the data in the folder or database you selected. The featureclass is currently in load-only mode. What do I need to do to ...
2
votes
2answers
86 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
57 views

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

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
18 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
16 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
0answers
31 views

Restricting values in attribute table (foreign key)? [closed]

I have a table in Microsoft SQL Server with values that I would like to use in the attribute table as the restrictor. This table and the feature class that I would like to edit are saved in an ArcGIS ...
0
votes
1answer
26 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?
0
votes
0answers
19 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
38 views

SDO Oracle Table not recognized as Geometry in QGIS

I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such. I have read the following in the QGIS documentation: Normally, an Oracle Spatial layer is ...
0
votes
0answers
14 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
36 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
22 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
41 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
11 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
16 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
22 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
18 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
56 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
28 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
44 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
17 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
30 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
21 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
28 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
40 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
0answers
64 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
19 views

Exception while trying to sync SQLite to featureserver by Esri Android API after deleting and recreating mapService

I've developed a sample app which has a downloaded SQLite file from sync enabled feature server. for no reason, the feature server stopped and in the Android app, the user couldn't connect to feature ...
0
votes
0answers
55 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
54 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
32 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
42 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
88 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
39 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
1answer
48 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
27 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
31 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
46 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
11 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
24 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
32 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
39 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
76 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
32 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
39 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
88 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
56 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") ...