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.
4
votes
0answers
165 views
How to register a Stored Procedure in ArcSDE?
I just registered a SQL Server view with ArcSDE through
sdetable -o register [...].
I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view?
EDIT
...
4
votes
0answers
414 views
ARCMAP ERROR 000464: Cannot get exclusive schema lock
I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error...
ERROR 000464: Cannot get exclusive schema lock. ...
4
votes
0answers
246 views
Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase
I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
3
votes
1answer
58 views
How can I list SDE versions using Python?
I have an SDE geodatabase with different versions for each user.
How can I list each version using Python?
3
votes
2answers
326 views
Visualize feature class with many relationship classes?
I have a feature class in a geodatabase that I want to review.
It has many relationship classes - possibly a hundred or more. If I load the feature class into ArcMap and identify one of the ...
3
votes
1answer
476 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
2answers
440 views
ArcSDE database connection strings for ArcCatalog
Anyone know where the Database Connection strings are located in Program Files for ArcCatalog? I have all my Database Connection strings fixed and all my scripts use them. My computer went down and ...
3
votes
4answers
757 views
Creating a multiversioned view with ArcSDE and SQL Server 2008 R2
I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2.
Everything appears to be working correctly with one exception: The ...
3
votes
2answers
172 views
Is it possible to load features into ArcSDE without using ArcObjects?
I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary.
It seems like it would be relatively easy to create new ...
3
votes
2answers
372 views
Has anyone successfully implemented a web service that sits on top of ArcSDE (SQL Server 2008)?
Here's the situation. We have planned point locations that lie within predefined polygonal project areas. Our IT department currently has these polygonal project areas in SQL Server 2008 as geography ...
3
votes
1answer
71 views
How can I validate a table name on SDE with Oracle backend?
Second title: "Is arcpy.ValidateTableName broken on Oracle?"
I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
3
votes
1answer
287 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
737 views
how to grant permission in SDE geoDB,when layers are inside a geometric network
When I use sdetable command to grant pemission to a table that located in a SDE SQL server geodatabase it works properly,this table is a non-spatial table which is in geodatabase immediately,I mean ...
3
votes
2answers
226 views
Can ArcHydro Tools be used on a network in an SDE enterprise geodatabase?
Most of the documentation for ArcHydro Tools discusses their use on data in ESRI's personal and file geodatabases. Is it possible to use ArcHydro Tools to set network flow direction on a networked ...
3
votes
1answer
88 views
Are there any publicly available ArcSDE Servers I can use for developing client applications
I have been asked by our client if I can add the ability to connect to instances of ArcSDE servers from our desktop application.
I am sure that we can do this a number of different ways, what I was ...
3
votes
2answers
610 views
Using PHP with a web application?
I have been working on creating a web mapping application using ArcServer 10 and the JavaScript API. Recently I was told that queries need to be run using PHP due to prior work by another team. The ...
3
votes
1answer
563 views
Can ArcPy test for availability of SDE Connection before trying to use it?
In a Python script that I use to publish ArcGIS 10.0 Geoprocessing Services I have some code:
arcpy.AddMessage("If process hangs here, check for ArcSDE connections issue by trying to open " + mapFile ...
3
votes
1answer
796 views
Editing with ArcGIS Silveright
I am using the ArcGIS Silverlight API to edit data in an ArcSDE SQL Server geodatabase.
I have been told that any editable feature classes must be registered as versioned in ArcCatalog before they ...
3
votes
3answers
454 views
PostGIS + ArcSDE mixed environment
I'm trying out a mixed environment here at work with PostGIS and ArcSDE together.
I'm having some problems creating feature classes with custom SRIDs. I imagined that all that I needed to do was ...
3
votes
1answer
521 views
Unable to Reconcile
I'm quite familiar with the ArcSDE model and a few days ago we have major power issues here.
My problem (and this is a BIG one) is that one of the users, made thousands of edits correcting data, and ...
3
votes
1answer
202 views
Power Outage and ArcSDE
I'm working on a hostile environment. Power outages, despite our efforts to minimize them, are often here.
Yesterday we had a power outage and we had 2 ArcSDE databases working. I have two sets of ...
3
votes
2answers
274 views
How does ESRI, and how should anyone, transform a coordinate that lies outside a grid transform (e.g. NADCON)?
As I understand it, a datum transform (e.g. urn:ogc:def:coordinateOperation:EPSG::1241) based on a grid interpolation method, e.g. NADCON, is undefined outside of the grid of points. Therefore the ...
3
votes
1answer
51 views
Synchronizing Changes From File Geodatabase to SDE Geodatabase
I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
3
votes
1answer
69 views
it is possible to undo and redo outside an edit session in Arcobjects?
I would like to know if it is possible to undo and redo changes outside of edit session, i'm working on an ArcSDE versioned 10.1 database?
if yes how i could do it in Arcobjects .NET .
Any help ...
3
votes
1answer
62 views
Attaching files to features: File server vs SDE attachment
I have some files that I would like to attach to my sde features. Files are small in size ( <40 KB) and have 1:1 relation to features.
I wonder which method is superior, specially in terms of ...
3
votes
1answer
134 views
Arcpy does not execute “CopyFeatures_Management” to write a featureclass to an ArcSDE database
I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of ...
3
votes
3answers
111 views
How to create feature dataset by pgAdmin(postgres) that can by use in sde conection?
How to create feature dateset in postgres(pgAdmin) that can by use in sde conection (arcgis)?
3
votes
1answer
224 views
Duplicate ObjectID in ArcSDE Table
After making a check in from an arcpad AXF file, i remark that there's duplicate object ID records , this Arcsde pgsql table is versioned and edited by Axf checkins and a .net engine application. the ...
3
votes
1answer
412 views
How can I create an empty feature class in a file geodatabase based on the schema of an SDE feature class?
I have 150+ feature classes in SDE for which I need to create an empty feature class in a file geodatabase. For these feature classes I need to import the attributes and the name of the feature class ...
3
votes
1answer
981 views
How do I create a functional spatial index of an ST_Geometry Feature Class in Oracle/SDE?
Copied an SDE feature class (with blob(sdebinary(?) geom) into the same SDE GDB (Oracle 11g/SDE 9.3.1) but with the ST_geometry configuration keyword. I can see that the feature class was created, ...
3
votes
2answers
292 views
Oracle Linestrings and MultiLinestrings
We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big.
We'll here are ...
3
votes
3answers
572 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 ...
3
votes
1answer
795 views
How to create Stored Procedure in versioned SDE_SQLServer geodatabase using DDL?
I've almost used SQL server_SDE geodatabases for 3 years in GIS projects and I don't know how can I create a stored procedure in geodatabase.I use ESRI case tool to create a geodatabase in ...
3
votes
1answer
93 views
Is it possible to add arcgis-server services or ArcSDE datasets to Tilemill
Our web design department wants to use mapbox/tilemill to create webmaps for our public websites, but all our data is made available through ArcGIS-server or ArcSDE. Is there some way to use these ...
3
votes
1answer
75 views
Problem installing ArcSDE engine plugin for Eclipse
I'm looking for the following jars for the ArcSDE API:
jsde_sdk.jar
jpe_sdk.jar
concurrent.jar
icu4_3_2.jar
thanks to this answer I've found that they can be gotten installing the ArcSDE engine ...
3
votes
2answers
118 views
Why I see different data from PostGIS and ArcSDE
I have installed ArcSDE 10 on PostgreSQL 8.4.3 with PostGIS 1.4.2. I did some tests.
I imported one feature layer with 8500 features into ArcSDE through ArcCatalog. and I deleted 8499 features in ...
3
votes
1answer
404 views
ArcGIS Query Layer performance documentation or feedback
I first tried asking this question in the ArcGIS forums but as is common I got a total of 0 responses. I'm willing to accept this may be due to a lack of knowledge on the subject, but I'm optimistic. ...
3
votes
1answer
582 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
1answer
343 views
Extract data from QueryLayer to Shapefile
I have a QueryLayer that I need to export as a shape file.
This was previously implemented as an ArcSDE feature class which we converted to a QueryLayer (running against SQLServer) in order to have ...
3
votes
3answers
878 views
How to avoid dbo.arcsde LOCK issue while exporting to ArcSDE
I had a spatial db connection open in arcmap. While exporting to SDE with a console app I get an error in the console:
Lock request conflicts with an established lock [DBO].
Does this just mean ...
3
votes
1answer
297 views
Publish ArcSDE FeatureService for Versioned Editing
Scenario: I need to Publish a data (from ORACLE ArcSDE) for versioned editing. Each user should be able to connect to his version and edit the data throu web application (Silverlight/JAVA/Flex API).
...
3
votes
2answers
437 views
ArcSDE 9.3.1 -> Performance
We have a number of mapservices in ArcGIS Server 10.0 that reads data from FGDBs.
We are now moving that data in to ArcSDE and the plan is to use this data from AGS.
Is it better to connect to SDE ...
3
votes
2answers
1k views
Cannot spatially select from Oracle view based featurelayer in ArcMap
I'm hoping someone has seen this before and has a solution. I've exhausted all my ideas. I having problems with the selection and identify tool in ArcMap.
I have a point feature class, zlevels, ...
3
votes
1answer
73 views
Running Regular Queries Through ArcSDE
Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
3
votes
0answers
227 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
0answers
66 views
How to enable SDE Archiving with python and the SDE api ArcGIS 10.0
I have a script that does some register as versioned and updating privileges. How would I call into the c api for ArcSDE to enable archiving with python?
...
3
votes
0answers
146 views
ArcSDE Database Refactoring Tools?
We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas.
But we also work with GIS applications using esri ...
3
votes
0answers
152 views
Cartographic Representations Load Rather Than Feature Symbology
We use ArcSDE to allow multiple users (both in my office and elsewhere) to access feature classes that my office maintains. We also use cartographic representations for many of our feature classes.
...
3
votes
0answers
155 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 ...
3
votes
0answers
139 views
SDE Topology dirty areas don't go away
Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...
