Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,257
questions
0
votes
0answers
22 views
Convert array of points to polyline and validate completely within boundary or not [on hold]
When I ran this:
polyline = arcpy.Polyline(array, arcpy.SpatialReference(4326))
INSIDE_FLAG = polyline.within(SDESomepolygon)
for example array values:
25.80886, -80.189
25.808474, -80.189014
25....
3
votes
0answers
38 views
Arcpy 'Append_management' much slower than ArcMap Tool?
Basically I have a script that grabs data from a web service, parses it, stores it in an intermediary local fgdb, then appends that data to the feature class in the enterprise gdb.
The portion of the ...
0
votes
0answers
23 views
Is there a way to deploy Oracle Instant Client with an ArcGIS Add-In to access geodatabase objects?
I would like to open a feature class stored in an Oracle Enterprise geodatabase from an ArcGIS 10.4.1 Add-In without installing an Oracle Client on the end-user machine.
Currently, I can use the ...
1
vote
0answers
27 views
Esri enterprise GDB features showing as non-spatial table in QGIS [closed]
Why are Esri's Enterprise geodatabase 10.4.1 (in MS SQL Server 2012) feature classes showing as non-spatial table/spatial type is 'no Geometry' in QGIS?
The storage properties of the feature class ...
0
votes
1answer
19 views
Arcpy SDE Connection Getting Invalid Path? [closed]
I literally copied and pasted the file path (r'C:\Users\myName\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\mydatabase.sde'), but after I run my script, I always get the error saying error 267, the ...
1
vote
0answers
38 views
How to transfer data from a version to default version in ArcMap? [closed]
I have lost all data from default version and also from the base tables in Oracle. But luckily, there is a version that has all the data in it. I have reconciled and posted that version to default but ...
1
vote
0answers
34 views
Attribute objects in Enterprise geodatabase automatically
There is a Enterprise geodatabase (MS SQL Server, ArcGIS), it has about 100 feature classes. It is necessary to automate the process of populating a unique number to each object in the database. ...
3
votes
0answers
33 views
Limit users' editing privileges by attribute and role
I have a feature class in an Oracle 12c geodatabase.
The feature class has a type column. The column has a coded domain.
I would like to limit user's ability to edit the features based on the type ...
0
votes
0answers
34 views
Allowing ArcGIS Server accessing our Geodatabase Enterprise over the web
In my organization there is an installation of ArcGIS Server that is linked with an Enterprise geodatabase (PostgreSQL) in a DMZ for editing only over the web.
However, we have another installation ...
1
vote
1answer
12 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
73 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
26 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
18 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
30 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
24 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
106 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
68 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
21 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
21 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
30 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
24 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
45 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
23 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
42 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
23 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
43 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
12 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
19 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
27 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
21 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
89 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
37 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
48 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
37 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
25 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
36 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
41 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
85 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
22 views
Exception while trying to sync SQLite to featureserver by Esri Android API after deleting and recreating mapService [closed]
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
65 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
64 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
43 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
110 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
41 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
85 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
29 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 ...
