Use this tag for questions about the ArcSDE (Spatial Database Engine) component of Esri's ArcGIS for Server that is one way to enable access to spatial data stored in a Relational Database Management Systems (RDBMS).

learn more… | top users | synonyms (1)

1
vote
0answers
19 views

FME Writing metadata to ArcGIS Online

I am trying to figure out how to write metadata to ArcGIS Online Feature Service from ORACLE SDE and how to update the existing Feature Service metadata, using FME or other tools. I am able to read ...
1
vote
1answer
29 views

Is it possible to limit export feature class in ArcSDE to only some users?

I'm trying to manage user and their privileges in ArcSDE and sql server 2012. I can privilege the select and edit a layer for users. I can use just two privileges but i want to permit export feature ...
1
vote
1answer
35 views

migrate to Enterprise GIS

We have basemap with shape file, now we have purchased ArcGIS 10.2 with server and ArcSDE and Oracle. we want to establish Enterprise level so that multiple users can edit without overwrite the source ...
0
votes
0answers
23 views

Is a unioned feature class the fastest/best way to quickly get attributes from multiple feature classes at once?

I've been asked to create a feature class by unioning 18 polygon feature classes together, and retaining only certain attributes. The goal is to have a single feature class that can be queried once to ...
0
votes
0answers
22 views

Python script can't find custom module in ArcSDE

I've been working on a python script for some time. Its working well but I'm having trouble running it in SDE. My main issue is that the python script, when run in SDE, cannot find any of the ...
2
votes
0answers
24 views

Geodatabase Archiving

I'm trying to figure out a way to update the schema of an archived feature class. There was a lot of discussion about this from 2012 and prior. https://geonet.esri.com/message/115340#115340 < -- ...
5
votes
3answers
250 views

How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
2
votes
0answers
24 views

ArcSDE reconcile versions and keep edit version in its current state

Reconciling versions makes both target and source(s) point to the same state. I have an arcpy script that essentially will create a version from a parent of the db - in a state that is empty - adds ...
1
vote
1answer
282 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
12
votes
5answers
7k views

ArcSDE connection limit exceeded

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
1
vote
1answer
139 views

Copying representation symbology from one ArcSDE version to another?

We are having problems with our representations when copying from an ArcGIS 9.3 database to a 10.0. Representation symbologies with dash patterns (dots, dotted lines etc.) are reset to default ...
1
vote
2answers
2k views

Delete SDE feature class features with ArcPy

I'm working on a script that will empty my SDE database of all data. How would I go about deleting features from feature classes using ArcPy? I have an SDE connection created with a user that should ...
0
votes
2answers
42 views

Creating model to copy feature classes from ArcSDE to FIle Geodatabase?

I am trying to create a model in ArcGIS that copies the feature classes which are stored in SDE geodatabase “SQL” to file geodatabase “in order to sync my SDE data to FGDB“, here what is the best ...
2
votes
1answer
32 views

How can you tell which port number an existing Database Connection is configured for?

I have a database connection to a postgresql database on a non-default port, 5433. I specify TESTDB,5433 as the instance and I can connect with no errors. If I open that connection properties ...
1
vote
0answers
23 views

Surfacing data in ArcSDE enterprise geodatabases in Portal

Is it possible to use data from ArcSDE geodatabases (hosted in Oracle, in this instance) in Portal webmaps? I've been searching documentation and the internet for a while, and it's implied that it's ...
2
votes
0answers
27 views

Is it possible to replicate an SDE geodatabase including the archive tables?

I have a database in one location which I would like to replicate to another using one-way replication. In testing we haven't been able to replicate the archive tables, which is unfortunate because we ...
1
vote
1answer
200 views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with non-spatial Oracle tables. These tables have a field named 'objectid' because were created originally for inserting/updating records by using ArcGIS instead, not ...
2
votes
2answers
602 views

Error with da.UpdateCursor and SDE feature classes

I am making my first attempt at editing an ArcSDE feature class with python through a da.UpdateCursor. I'm essentially taking code I've written for a file geodatabase feature class and applying it to ...
1
vote
0answers
17 views

Importing XML workspace file without losing z and m parameters?

I am attempting to import an XML Workspace document (database schema) from a file geodatabase into an SDE geodatabase sitting on top of Postgres. The steps I am taking are: In ArcCatalog - ...
1
vote
3answers
229 views

Arcsde - FME - import data

I have a problem with the import of data with FME 2012 and ArcSDE 10. After import, my data are not visibles in ArcMap or ArcCatalog. My layers are registered in ArcSDE. I found a solution: After ...
2
votes
1answer
46 views

ERROR 999999: Error executing function - Failed to execute (CopyRaster)

ERROR 999999: Error executing function Unexpected operation No spatial reference exists This is a fragment from my log report: ERROR 999999: Error executing function. Database user ...
0
votes
1answer
40 views

Geometric Network Build Error

I'm trying to create a geometric network of pipes, sewer structures (points) and manholes (points) inside a of an SDE. I can create the network in a file geodatabase but when I try creating it inside ...
0
votes
0answers
17 views

Map Control Didn't Show Editing Result

I have created an application with data from SDE Geodatabase (Oracle). I've registered it as version without tick on the option to move edits to base. Anyway, in my application there is a part where ...
0
votes
1answer
52 views

Exporting data from ArcSDE gdb atribute table to file or personal geodatabase?

I'm currently learning GIS and I'm working on a project, I'm doing my own research and trying to accomplish the following with or without Python: Export data from an ArcSDE geodatabase attribute ...
2
votes
1answer
199 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
2
votes
0answers
25 views

How to re-register a one way replica geodatabase

Long story short. Arcmap crashed during one of my regular synchronizations of a replica geodatabase created through one-way replication checkout. Upon reloading it seems to have unregistered the ...
0
votes
1answer
43 views

Using pymssql to create a table using python ArcMap 10.3

I am using ArcMap 10.3 have a my data in a geodatabase (MS SQL Server Express) and I am trying to write a python script that does a bunch of spatial and non-spatial data manipulation. I need to dump ...
12
votes
1answer
592 views

Stop ArcMap from probing missing data sources on launch

When migrating a map from one environment to another (say, from an existing client environment to our development environment) we're often given MXD documents that represent the map. These documents ...
13
votes
1answer
2k views

Why do simple joins on small datasets slow down ArcMap so badly?

ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is ...
5
votes
3answers
2k views

How to copy an SDE geodatabase to a file geodatabase using Python?

I would like to make an exact copy (domains, feature datasets, feature classes, etc.) of an SDE database to a file geodatabase. I have tried several possibilities, including: using the Copy (Data ...
2
votes
1answer
33 views

Remove/Hide SHAPE.STArea() & SHAP.STLength() fields

Is there a way to hide SHAPE.STArea() & SHAP.STLength() fields in feature classes in an SDE GDB? I'm working with a client who says that these fields were not in any feature class in the GDB and ...
0
votes
0answers
34 views

inherted .net extension not connecting to arcSDE in ArcMap10.2.2

I have a custom .net extension tool that is supposed to connect to a file geodatabase or SDE (SQL Server). The SDE connection fails to recognize it as valid. The file geodatabase connection works just ...
-1
votes
0answers
24 views

Import dataset from ArcSDE to local folder using ArcObjects?

Am new for ArcObjects. I need to copy the listed Data set from ArcSDE server to local Encrypted folder.
1
vote
1answer
62 views

ArcGIS Terminology and Data Types

What is the difference between a "Feature Class" and an "SDE Feature Class"? Or a "Table" and an "SDE Table"? When browsing data in ArcCatalog, hosted on the same enterprise gdb, I see these data ...
2
votes
1answer
153 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
2
votes
0answers
35 views

Different SRID problem

Hi here is my problem, I have two geodatabases and i import a number(large) of tables from one to another by using arccatolog(ArcGIS 10.2). However the tables and indexes created on them are imported ...
0
votes
0answers
20 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
1
vote
0answers
53 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
0
votes
0answers
74 views

Need to connect ArcSDE dataset using QGIS Desktop and Oracle database

I am working in GIS domain using ESRI technology. I want to use QGIS desktop to access ArcSDE dataset from a local machine. I have already installed Oracle Client 10g and QGIS Desktop 2.8.1 through ...
0
votes
2answers
453 views

Cannot register a Feature dataset

I am having an issue trying to register a dataset, and being able to edit a featureclass within it. I am new to SDE so please bear with my explanation. I read online you cannot register a feature ...
0
votes
2answers
43 views

Privileges for Oracle users created using the ArcGIS Create Database User tool

I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user. I've created a new user named GFPTest using the Create Database User ...
0
votes
1answer
361 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
12
votes
5answers
5k views

Is it possible to connect to ArcSDE using QuantumGIS?

Is anyone aware of any plugins, or any other way to connect and view data from an ArcSDE database in Quantum GIS desktop?
1
vote
0answers
22 views

How to recover from deleting the symbolid of a arcgis annotation feature class?

I have arcgis 10.1 (arcinfo license) and I am using a versionned database (arcsde) with SQL Server. I have accidentally deleted the symbolid of one of my annotation feature classes. All annotations ...
3
votes
1answer
335 views

ArcSDE - How to edit mosaic dataset

I have a mosaic dataset (Raster) in an SDE database. As expected, when I click start editing, ArcMap says that I have to do "Register as Versioned" before, but I can't have a mosaic dataset in a ...
1
vote
1answer
44 views

How to change data source of table using arcobjects

Cross post from: https://geonet.esri.com/thread/125010 Does anyone know how to change the data source of a table using arcobjects? I know it can be done with arcpy, but I'm using C#. I've managed to ...
1
vote
1answer
40 views

ArcSdeSqlExecute ArcSDE Error -65

I am trying to Select certain fields, resulting from a join using ArcSDESQLExecute but encounter the following error when I try to include the Shape field: AttributeError: ...
1
vote
0answers
31 views

ArcSDESQLExecute to query and update from multiple SDE Databases

I am trying to use ArcSDESQLExecute to return the results of a join and then write the return query into a Feature Class located in a different database. Using Microsoft SQL Server and Arc10.2.2 Is ...
6
votes
2answers
921 views

How is the default label field chosen by ArcMap?

I have 2 questions: I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
1
vote
1answer
29 views