Tagged Questions

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.

learn more… | top users | synonyms (1)

2
votes
1answer
10 views

Which geodatabase type is most appropriate for both open source and ESRI use?

Main Question: Is there a geodatabase type that seamlessly works with both ESRI and open source products? Details: My company currently passes around geodata in various vector and raster file ...
1
vote
0answers
42 views

How to add a column to table with sdelayer command?

I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
0
votes
0answers
28 views

ESRI AddFeatures call on rest endpoint with attributes

I can add a line feature via the rest endpoint with my hand crafted call from C#. However, if i add any attributes to the call it will fail and say unable to perform operation. All of the fields in ...
1
vote
0answers
143 views

Is there workaround for very slow ArcSDE 10.1 editing

I'm suffering from very slow editing in SDE from an Arcgis engine application, the SDE database is in local so there's no network issues. but i still ignore the reasons neither how to solve this ...
0
votes
1answer
53 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
3
votes
2answers
49 views

Problems displaying joined attribute data through ArcGIS Server

I have an ArcSDE feature class in an ArcMap MXD which I have 'joined' to a view into an external SQL database table, that is connected via an OLE DB connection. In the MXD the join works perfectly; I ...
2
votes
1answer
29 views

Arcpad checkout to an area

I would like to check out data from an SDE database but for performance sake, i prefer to delete all features outside of my survey area. i've tried to copy features in area from sde to a file GDB ...
2
votes
2answers
35 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.
6
votes
1answer
63 views

ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field. In order to help themselves, they asked me to implement a particular ...
0
votes
0answers
88 views
+50

Configuring image popups in a Silverlight application

My Silverlight application contains a points layer which contains paths to a folder of geotagged photos. These points were generated using the GeoTagged Photos to Points tool. I chose not to import ...
5
votes
2answers
105 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 ...
0
votes
1answer
25 views

Migrating Lines to ArcGIS polyline

I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase. and some data will cause the error. Its says not enough points for feature class, but when I look ...
4
votes
2answers
68 views

What are the benefits of using ArcGIS with Postgresql over simply ArcSDE?

I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
0
votes
0answers
16 views

Oracle Feature Class Couldn't Displayed

I got problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on ...
0
votes
0answers
9 views

Export ArcGIS TilePackage from large RasterDataset

We store a large (>1TB) RasterDataset of our Orthoimagery in an ArcSDE 9.3.1 Dataserver (on SQL Server 2008 SP1). With ArcGIS Server 10.1 we want to export TilePackages of certain areas to use them ...
1
vote
1answer
40 views

How to insert features in a MS SQL based SDE without giving ObjectID s?

I'm trying to load features into ArcSDE without using ArcObjects, and using SQL from my .NET Application instead. I have followed the answers given in this question: Is it possible to load features ...
0
votes
1answer
42 views

What is the process to automatically change a field entry in a related table when entering it in a feature class?

So, I am working to try and develop a code or process that I can run that will allow me to automatically change an XY field in a related table when I change an associated XY field. Let me explain our ...
3
votes
1answer
55 views

Convert OpenStreetMap schemas to ArcSDE in PostgreSQL database

I am trying to find a way to store OSM Extracts (or possibly the planetfile) in a PostgreSQL database, keep it up to date with diff files and then process the data further with ArcGIS (e.g. Geocoding, ...
0
votes
1answer
35 views

Problem in filling table of ArcSDE feature class in SQL Server 2008?

I have an ArcSDE point feature class and I add it to ArcMap 10. After that I add some points to it and fill every field for all points in the attribute table and Save Editing. However, the SQL ...
1
vote
0answers
228 views

Is it possible to create an updateable spatial view?

1- I have encountered a problem relating with sde commands for creating sde_ view and also sde_table . I used appropriate codes but an error massage occured during execution. the related codes: ...
3
votes
1answer
59 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?
2
votes
1answer
448 views

How to insert DateTime null using IRowBuffer

I am using IRowBuffer/IFeatureBuffer to insert fields to SQL Server 2008 DB. When inserting a field I am using: public void SetValue(IRowBuffer buffer, string field, object value) { int ...
6
votes
1answer
86 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
1
vote
1answer
43 views

ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?

In the system I'm building, we've got a facility that can be represented as either a point, or a point within a polygon (the point in the polygon may or may not be the polygon's centroid). I'm using ...
2
votes
1answer
99 views

What is the proper way to delete an SQL Server database in order to delete an SDE geodatabase?

I'm new to this SDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the SDE geodatabase. Is it as easy as right clicking on the database in SQL ...
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
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 ...
0
votes
2answers
82 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...
3
votes
1answer
89 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 ...
10
votes
1answer
198 views

Steps for creating an online webmap with editable features using ArcGIS Server/SDE and SQL Server?

EDIT/UPDATE: I'm adding a bounty to this in hopes of obtaining a step-by-step guide to creating an online map with feature editing using the ArcGIS Flex API, SQL Server Express and ArcGIS Server 10.1. ...
0
votes
1answer
28 views

Why can't a user with db_owner role version data?

I've made an enterprise geodatabase and added a user with db_owner permissions. When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able ...
0
votes
0answers
33 views

how to access a feature class in SDE using arcpy [duplicate]

I am new to Python and Arcpy. I am trying to access the SDE server to extract some information from feature classes that reside in the server database. I know the name of the feature class and I also ...
2
votes
1answer
52 views

Display ArcSDE-metadata in Browser

Is there a good tool / technique to display ArcSDE-metadata in a webbrowser? We want to provide user without GIS-knowledge with a user friendly tool to explore our SDE metadata catalog. We are using ...
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
72 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 ...
6
votes
1answer
826 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 ...
3
votes
1answer
53 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 ...
6
votes
1answer
107 views

When to use multiple geodatabases?

I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
1
vote
0answers
43 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
2
votes
2answers
130 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 ...
1
vote
4answers
941 views

error in arcsde service

I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database SDE not Running on Server Then I Check the Service esri_sde it has ...
1
vote
1answer
71 views

Database Connections folder is empty when viewed with ArcGIS tool

I'm trying to create an ArcGIS tool which accepts an SDE connection file as an input. I made a new interface with an input parameter and set the type to Database Connections. When I open the tool and ...
4
votes
2answers
160 views

Calculating the space a feature class will use in ArcSDE?

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
2
votes
0answers
70 views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
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 ...
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 ...
0
votes
2answers
62 views

Missing options on database connection in ArcCatalog

I have 2 databases on the same server. I can add connections to them both without a hitch in ArcCatalog (or catalog in ArcMap). The problem is that I seem to be losing some options when right clicking ...
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 ...
2
votes
1answer
54 views

Strange ArcSDE error inserting null into state_locks

I'm working with a heavily customized version of ArcMap 9.3.1. It's heavily customized, but it mostly uses class extensions and special validations. Environment: ArcSDE installed in: linux, ...
1
vote
1answer
39 views

Filter ArcSDE layers of the TOC into a combobox

I've a list of layers of the current workspace in a combobox, but I want to list only the layers of the ArcSDE Connection, not the others I've in the TOC. How can I filter the name of this layers?

1 2 3 4 5 … 7