Tagged Questions

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)

5
votes
1answer
77 views

Automate loading a table into SDE

How can I automatically load a table stored on a network share into SDE when the original table is edited? Environment is ESRI 10.1 ArcSDE on SQL Server. Preference for python or existing GP tools. ...
1
vote
1answer
43 views

QGIS 2.2 crashes when saving digitized data in ArcSDE 10.1

I am using QGIS 2.2 with ArcSDE 10.1 for Oracle 11gR2 I have created a polygon feature class with SDO_geometry, when trying to save the digitized data QGIS crashes. Please help, I want to edit the ...
1
vote
1answer
195 views

Secure credentials for scheduled python script targeting ArcSDE 10.1 on AWS

I have a python script that will be used as a scheduled task. Our dba team is wanting the credentials to be as secure as possible. I would say that using the os security system as far as locking ...
1
vote
1answer
124 views

ArcSDE/SQL Server Permissions

I have an enterprise geodatabase with about 20 users. Each user has a corresponding schema. When in Arc Catalog, if only the owned schema box is checked in SQL Management studio I receive a ...
2
votes
0answers
110 views

Bulk insert into MS SQL Creating ObjectID's

I am running an ETL from a spatial view into publication database. The view has results in duplicate ObjectID's. I started working with the get_ids SP example from ESRI, but that seems to be built ...
1
vote
0answers
42 views

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

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
1answer
145 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 ...
2
votes
0answers
26 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 ...
0
votes
1answer
144 views

arcpy.ListDatasets() returns emtpy list

I'm having trouble getting the ListDatasets (or any of the list functions) to return anything but an empty list when pointed at our SDE geodatabase, but the same code works for a file geodatabase. I ...
2
votes
0answers
74 views

Cannot Save Edits to File Geodatabase Replica in QGIS 2.2

When trying to edit a File Geodatabase Replica in QGIS 2.2, everything works as expected until the user saves their edits. When pressing save, all edits revert back to their original state with no ...
1
vote
1answer
54 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
153 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
74 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
41 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
80 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
194 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
83 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
113 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
29 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 ...
2
votes
1answer
153 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
165 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
54 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
43 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 ...
3
votes
1answer
233 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
43 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
85 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
121 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
53 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
309 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
248 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
1answer
57 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-field 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 ...
2
votes
1answer
217 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' ...
3
votes
1answer
262 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
65 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
77 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
188 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
100 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
153 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
53 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
197 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
49 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
70 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
19 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
145 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
61 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
202 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
31 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
28 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
135 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
54 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 ...