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)

0
votes
0answers
24 views

Trouble Creating Raster Catalog in SDE [on hold]

I would like to create a raster catalog in an enterprise geodatabase/sde connection. For SDE is a config keyword needed, the defaults which appear are geography and geometry, neither of these bypass ...
1
vote
0answers
30 views

What are some advantages to using ArcSDE in your organization? [on hold]

This is somewhat a general topic, but I need some advantages to using ArcSDE in my organization. We actually have SDE for our webmapping software, but we are unable to edit it using ArcGIS basic ...
5
votes
0answers
58 views

How to compare two Geodatabases

I would like to compare the data of two geodatabases, in SDE or a file geodatabase, to detect the changes occured between them , i've tried to compare the Xml workspace document of both databases ...
1
vote
0answers
17 views

Shoehorning hierarchial data into MS SQL ArcGIS SDE

So, I've been tasked with creating a set of tables to store hierarchical data within an SDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
1
vote
1answer
26 views

Query SDE to display records created for 'X' date/time

I am looking to query our SDE to display feature classes modified beginning from January 1, 2013 to today. I am using Microsoft SQL Server Management Studio, and as it stands searching through dbo ...
1
vote
0answers
60 views

Running python script outside of Arcmap's python console

My codes works fine in Arcmap's python windows. But when I try to run it in a command promt windows, It says that; ERROR 000837: The workspace is not the correct workspace type. But it works fine ...
0
votes
1answer
26 views

registering or unregistering as versioned a future dataset with python

As you know, you can store feature classes in arcsde in two ways. Firts, in the root path: sde_conn_file.sde/FeatureClass Second, in a dataset: sde_conn_file.sde/DataSet/FeatureClass How can I ...
1
vote
1answer
29 views

ArcGIS Server 10.1 GP Service non-functional after ArcSDE restart

every night, the Oracle/ArcSDE server gets restarted. As a result, some, but not all, map and GP services require a restart to be functional afterwards. Can others confirm this experience and share ...
2
votes
1answer
48 views

What's the proper way of deleting versioned data from an SDE geodatabase?

I haven't really read this anywhere. What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables? Do I need to unversion the ...
4
votes
2answers
128 views

How to transfer attributes to thousands of local points from ArcSDE feature class with millions of polygons?

I have a set of points and a huge feature class with topographic information (OS MasterMap for who knows it). I'm talking millions of polygons huge. I want to transfer attributes of the polygons to ...
0
votes
1answer
34 views

How to list all of feature class in SDE?

I am getting a problem: my SDE contains some feature classes, but after using the statement: var namesEnum = workspace.DatasetNames[esriDatasetType.esriDTFeatureClass]; var tempName = ...
4
votes
3answers
66 views

Preparations for a transition to ArcSDE [closed]

So I'm a GIS Intern for a city government, we are preparing to purchase ArcSDE and implement it to our current GIS setup. I'm curious as to what should be done before it is purchased. Our GIS consists ...
0
votes
0answers
23 views

ArcGIS Find task performance over SDE

We are having a problem in our Search feature for our app. We are using arcgis published REST services and SDE database. When we try to do our search manually using the REST url, it takes roughly 9 ...
1
vote
2answers
39 views

Using Python to connect to Multiple SDE Database Connections

I am writing a script that accesses multiple sde Database connections. I have set the script to include accessing the environment workspace: import arcpy arcpy.GetParameterAsText(0) ...
2
votes
1answer
61 views

How can I import the export file (*.sdx) from ArcSDE9.3 to ArcSDE10.1?

We got some files (*.sdx) from our clients using sdeexport from ArcSDE 9.3. We only have ArcSDE 10.1. We tried to use sdeimport command like this: sdeimport -o create -t NHDFCODE -f ...
0
votes
0answers
17 views

return to newline arcgis/arcSDE/postgres labeling

i have two tables : parcel and owners with many to many relation ship so i want to print owners name in my parcels (type polygon), so i coded using .net a function that create field in parcel ...
0
votes
0answers
25 views

View for SDE Permissions for SQLServer

Does anyone know the correct tables and joins to write a view to see the permissions on objects in SDE? Here is what I had in 9.3 and it doesn't seem to work (ie., all Permissions are Edit b/c the ...
4
votes
1answer
63 views

What is the correct order for compressing, rebuilding indexes and updating statistics in ArcGIS?

I want to script out the compressing, rebuilding of indexes and updating statistics on our SDE databases, but I want to make sure I have the correct order for these to run. What would be the correct ...
1
vote
0answers
29 views

Multiuser Editing with ArcGIS through LAN

I am working on an ArcObjects application (C#), which is supposed to carry some customized editing operations, the database is ArcSDE based on Postgresql via (accessible via a LAN network). One ...
3
votes
0answers
51 views

What are the pros/cons of using an MSSQL SDE Database rather than a File-gdb in ArcGIS Server

I have taken over an ArcSDE 9.3 Enterprise database setup which has around 80% of it´s vector data in an MSSQL SDE Database system and 20% in FileGDB on the application server. I am trying to ...
2
votes
2answers
66 views

Is there a way to do a python batch script for Analyze and Compress on SDE Databases?

I created and modified python scripts based off of ERSI's example (http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000v7000000), however, what would be great is to be able to batch ...
0
votes
1answer
28 views

Issues while changing ArcSDE from a Workgroup to Domain Environment

Our organisation was a having a multi-user Geodatabase ( ArcSDE 10.1 gateway on an Oracle 11 g DB) in a Workgroup configuration. The type of Authentication for DB connection was "Database ...
0
votes
1answer
115 views

Why do existing map services run slow after updating to ArcGIS 10.2.1 for Server?

Has anyone had any issues with existing map services after updating to ArcGIS Server 10.2.1? After updating they are running slow and causing my ArcGIS Javascript app to crash. All of our GIS ...
1
vote
0answers
66 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
0
votes
0answers
31 views

How to best create linked pdf to point data in ArcGIS server 10 sde 9.3?

I would like to create point data which offers a link to open a pdf file which I will have on my server. I have just read about "attatchments" which are new to ArcGIS 10, but this option isn´t ...
1
vote
0answers
33 views

arcgis 10.2 spatial stored procedure in oracle throws pls-00707 compilation error

Package def: create or replace PACKAGE POSEIDON_PACK AS procedure tester; END POSEIDON_PACK; Body: create or replace PACKAGE BODY POSEIDON_PACK AS procedure tester as d number; begin ...
2
votes
1answer
52 views

how do you manage columns in an ArcSDE/Oracle feature class?

Our enterprise has a long history with Oracle and ArcSDE. And lots of tension between the Oracle people and GIS people. Oracle folk often don't like the requirement of using expensive 'nonstandard' ...
0
votes
0answers
71 views

No domain coded values on REST Arcgis 10.2

We have created a map service using version 10.2 from a map which all layers data source are point to an SDE connection service using DB2 database. However, the coded value domain not appear in the ...
1
vote
0answers
44 views

How do I bypass class extensions when reading from ArcSDE with FME 2014?

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data. I am not able to set the Reader to bypass the class ...
0
votes
2answers
36 views

How to maintain many-to-many relationship between feature class and table with multiple disconnected editors?

I have an application coded with VB.NET (ArcGIS Engine) and its functionality is: digitize a parcel and enter information for its owners, so i have a M-N relationship between them. every parcel has ...
3
votes
0answers
105 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
1
vote
1answer
40 views

Rebuilding Indexes in SDE Database throws “Could not get a lock.” error

While trying to do some maintenance on our SDE database but i am always getting a "Could not get a lock." error on the details section of the process. Do i need to setup something for me to ...
0
votes
1answer
74 views

Mysterious Data loss after compressing SDE database

I suffer sometimes from data loss in SDE database exactly after compressing database. i mean by data loss that some data remains in its prior state before edits, but this problem do not affect the ...
1
vote
0answers
44 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
0
votes
1answer
74 views

How to fix spatial reference error on CopyFeatures ArcGIS tool?

When I run the CopyFeatures tool to copy features from an ArcSDE geodatabase to another empty ArcSDE geodatabase (no features, no tables), I get the following result: The error message is about the ...
2
votes
1answer
43 views

For loop within SDE

I have a list of SDE connection files in a folder in my computer. I can use arcpy.listWorkspaces("*", "SDE") to find the workspaces. But I then want to dig deeper into each of the SDE files and list ...
3
votes
0answers
43 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
0
votes
0answers
18 views

Why can I see the data from a second sde database connection in my database?

I have an sde 9.3 database which when opened in arccatalog shows the data from another sde database. Under settings > Source this is confirmed. Why and how can this happen? The only thing the 2 ...
1
vote
2answers
82 views

How is it possible to publish data with ArcGIS Server without creating ArcSDE service or using ArcSDE?

I am still relatively new to the ESRI server techologies. I have server1 which runs ArcGIS server 10.0 and when I look at which processes running on this server I see ArcSOM.exe, ArcSOCMON.exe and ...
1
vote
1answer
45 views

Should large Basemaps be stored in DBMS via ArcSDE?

As I understand it, the SDE Geodatabase provides the technology for Multiuser databases, Versioning, replication and other Geodatabase functionality. In my organisation, this could be useful for ...
5
votes
2answers
101 views

What is the maximum number of features a SDE featureclass can hold?

I have a SDE 10.0 Geodatabase based on MS SQL 2008. I'm running a continuous process where about 6400 point features are written to a feature-class every hour. I need it to be a featureclass, since ...
0
votes
1answer
26 views

What is the relationship between the SOC and the DBMS?

I have read lots of documentation about ArcSDE 9.3 recently but there are still are few things I don´t quite understand because I have not installed the infrastructure myself. If the SOM manages the ...
0
votes
1answer
26 views

Maintain Feature Data without Creating It

I work in City Gov. We utilize County Assessor data (Parcels) as they are updated from the Assessors office. Currently we store then in our Enterprise SDE system. As we get new updates, we have to ...
0
votes
1answer
48 views

How to find out if an ArcGIS Server SOM or SOC is installed on a machine?

I need to create a visual map of my current ArcGIS Server system including where software and data are installed. The System comprises of MSSQL, ArcSDE 9.3, ArcIMS, ArcGIS Server 10.0, and various ...
2
votes
1answer
46 views

How to stop transfer of large raster into arcsde geodatabase

I have just realised that I will not have enough space on my harddrive to accomodate a raster which is being copied into an arcsde geodatadatabase. I am afraid, that if I stop the process in ...
1
vote
1answer
69 views

Import OSM data into ArcSDE using osm2pgsql

I am trying to import OpenStreetMap (osm) data into a PostGRES database using OSM2PGSQL, and then I need to convert that data so I can use it in ArcSDE/ArcGIS Desktop 10.2. Here is what I do: ...
1
vote
1answer
131 views

Why does copying ArcSDE datasets and features in Python give ERROR 000732 & 000735?

Go easy, I'm new to python I keep getting a kick back that says this: ERROR 000732: Input Features: Dataset 'Database Connections\Wyoming.sde\Supporting_MT_DBO_Geology' does not exist or is not ...
2
votes
0answers
74 views

Issues importing feature class to SDE SQL Server 2012

I have received an error indicating there could be issues with my geometry when attempting to import a feature class into SDE. I ran the check geometry tool. No issues. I have removed all fields ...
0
votes
1answer
44 views

How to force deletion of corrupt ArcSDE Raster?

ArcSDE 9.3 / ArcGIS Server 10.0 / ArcCatalog Advanced 10.0 After an unsuccessful attempt at creating a mosiac, ArcCatalog refuses to allow deletion of the corrupt Raster file. The Mosiac creation ...
1
vote
1answer
63 views

Not enough memory in the file group “Primary”: SDE Database error with MSSQL

I got this error message whilst trying to load data into a raster in ArcMap 10.0. Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Eine neue Seite für die sde-Datenbank konnte nicht ...