ArcSDE (Spatial Database Engine) is a server-software sub-system (by ESRI) that enables the usage of Relational Database Management Systems (RDMS) for spatial data.
5
votes
3answers
4k views
Define Workspace for SDE Connection in Python
How do we define SDE Connection for workspace in Python Scripting. Its urgent please need your suggestion. Thanks
11
votes
7answers
3k views
Versioning with ArcSDE - Is it possible to cancel or reject edits once they've been posted?
I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
6
votes
1answer
833 views
Postgresql for Qgis and Arcgis - What to do/What not to do
Is it possible to use postgresql with QGIS and ArcGIS? One database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know that I ...
15
votes
4answers
5k views
ArcSDE 10.1 no longer needed?
Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able ...
12
votes
7answers
1k views
How to batch synchronize data from ArcSDE to PostGIS?
Its been suggested that i ask this question again, but perhaps worded differently than how to Bulk load multiple shapefiles into PostGIS.
I'm new to postgis and sql but i want to use postgis as a ...
13
votes
3answers
2k views
ArcObjects: Memory leak in IFeatureClass.Search (only on SDE with direct connect)
UPDATE 6/30/11: ESRI Support say they have reproduced the issue and have opened a bug report (NIM070156).
I have determined that there is a memory leak (in unmanaged heap memory) that occurs when a ...
17
votes
3answers
3k views
What is the difference between ESRI's SDE and Geospatial dbs?
When would you want to use ESRI SDE (I think it is called Server but I forget the level - please feel free to edit) versus a spatially enabled database. What are the trade-offs on either side? What ...
9
votes
5answers
3k 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?
13
votes
2answers
197 views
Is there a good way to get a diff between an old and a new version of an SDE database?
Is there a tool or a process that can reveal changes made to the schema of an SDE database when comparing two versions of the same database hosted on different servers?
I have an old database that ...
4
votes
5answers
1k views
Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?
I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system.
I need an exact copy of the ...
2
votes
1answer
267 views
How to cast SDE table to IFeatureClassLoad
How do you cast an SDE table to IFeatureClassLoad using ArcObjects? I'm getting an error with this attempt below which is not the correct method:
Dim pSDEFeatWksp As IFeatureWorkspace = ...
6
votes
2answers
389 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 ...
6
votes
5answers
780 views
Troubleshooting ArcObjects performance problems
We have developed a relatively complex geoprocessing routine using a C# / ArcObjects (COM) / ArcGIS Server 9.3.1 / ArcSDE 9.3.1 / Oracle 11g stack. Running the routine on a complete dataset takes ...
6
votes
3answers
2k views
When to store geometries using SQL-server geometry datatypes or ArcSDE?
With the release of SQL Server 2008 Microsoft added geometry data types. So geometries can now in an ESRI enviroment be either be stored using SQL-Server datatypes or ArcSDE datatypes.
A colleague ...
5
votes
2answers
3k views
How does one access a featurelayer in SDE via Python?
I am trying to use Arcpy to run the CopyFeatures_management script so that I can copy a featurelayer in SDE.
What do I use for the input (and output, for that matter, since I'll be copying the layer ...
5
votes
4answers
1k views
Will PostgreSQL 9 work with ArcGIS 10?
I realize it is not listed as a supported Database. I am interested to see if anyone has tried to install and use it.
5
votes
3answers
2k views
ArcGIS Server won’t release SDE table locks
My ArcGIS Server services are locking tables in SDE. This is a problem if I need to edit or overwrite them. Unfortunately the locks don't go away upon stopping the services. The only solution I have ...
4
votes
2answers
428 views
How to allow more polyline vertices for a ST_GEOMETRY in Oracle/SDE?
I'm receiving an error writing geometry (in ArcObjects) that has a large number of vertices (around 900). So big, but not ridiculously big. I would expect this to be no problem and I don't recall ...
2
votes
1answer
116 views
Steps to create an interface Editing ArcSDE Layers in a web service online. Similar to ArcGIS Desktop
The initial idea is to make a multiuser web service for editing versions of an ArcSDE geodatabase online (each version for each user. Is it possible to acces through a password and user name?).
Can I ...
2
votes
2answers
1k views
How do I access versioned spatial data in SDE with SQL queries?
We're running SDE and have several featuresets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned.
We have numerous non-GIS ...
3
votes
1answer
588 views
Error importing XML workspace document to file geodatabase
Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
3
votes
3answers
201 views
Is there any way to write a snipet of code with function of “SDELayer -o register” command
I try to create a geodatabase using some SQL command and then register some tables of it with SDE.
I create an empty geodatabase using sde post installation and then create tables and other database ...
2
votes
2answers
131 views
ArcGIS Server Error: “Feature service requires a registered database”
I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
6
votes
3answers
872 views
Python script - how to avoid exclusive schema lock error?
I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only".
My problem is that I can't avoid that these ...
4
votes
1answer
290 views
SDE analysis - file locking logistics - ArcSDE 10 on MSSQL
I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks.
I have a interpretable ...
4
votes
1answer
424 views
Edit SDE table with ArcObjects
The link below provides a code snippet for editing an SDE table with ArcObjects. Are there any other or newer code examples out there of how to edit a SDE table by using ArcObjects?
Edit SDE ...
3
votes
0answers
232 views
Error opening feature class from SDE (which can be opened in another application)
We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g.
I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
1answer
296 views
Where can I get jsde_sdk.jar for ArcSDE 10?
I had an environment working with no problems, with Geonetwork harvesting metadata from ArcSDE 9.3. It was done trhu the following libraries, copied from the ArcSDE installation to the Geonerwork lib ...
3
votes
1answer
484 views
ArcSDE desktop license
I am using the ArcGISDesktop student license. I want to work on versioning and geodatabase replication.
Is it possible to set up ArcSDE with the same license and work on versioning and replication?
3
votes
3answers
577 views
Is it possible to create a python script to rec/post versions?
I’m trying to set up a python script so that I can schedule our rec/post to run on a server. I’ve created a model with the Reconcile Version tool, with the option to Post checked on. I then export ...
1
vote
1answer
113 views
How to replace corrupt representations stored in a geodatabase using symbology from layer file?
I have a lyr file with symbology that I want to store in the database. Symbolology is already stored in the geodatabase but the symbology levels has been corrupted migrating from 9.3 to 10. Thus, I ...
1
vote
1answer
904 views
Trouble creating ArcSDE Connection File
I'm having trouble creating a ArcSDE Connection File. When I bring up the GP tool to do this, I enter the folder I was save the sde file to, enter an name for the file 'MySDEConnect.sde', enter the ...
1
vote
0answers
902 views
Edit SDE table with ArcObjects - continued [closed]
Update
So, I believe I'm getting closer to being able to edit my sde table, however now I'm getting stuck on this line:
Dim updateCursor As ICursor = table2.Update(Nothing, True)
With this ...
