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)

6
votes
2answers
1k views

How do you connect to a SDE instance on EC2?

We are exploring using Amazon EC2 with ArcGIS Server - and none of us has any experience with it. The question "How can we, from within our intranet, connect to the remote SDE instance in the EC2 ...
10
votes
2answers
896 views

Find duplicate vertices in SQL Server geometry line (ArcSDE)

I have a line in a ZM polyline featureclass that has a invalid geometry. My suspicion is that the line doubles back on itself somewhere, which I've found SQL Server doesn't like. Anyone know of a ...
2
votes
0answers
162 views

How can I upload an annotation featureclass to ArcSDE using C#?

I can upload the shape files to ArcSDE database successfully,but I fail to upload annotation featureclass.
4
votes
1answer
409 views

Remove ArcSDE repository and associated files from PostGresql DB

A bit of background first. I have a PostGres DB with PostGIS, I also have ArcSDE installed in this DB and all feature classes created through ArcSDE are using the PG_Geometry. Everything works well! ...
6
votes
3answers
3k 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 ...
4
votes
2answers
2k views

ArcSDE 10.0 giomgr Error During Post Install

I just installed ArcSDE 10.0 and ran the post install once to test the install and it ran great. Today I tried to run another post install to create another database and I get the error: "Parameter ...
13
votes
1answer
2k views

Why do simple joins on small datasets slow down ArcMap so badly?

ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is ...
12
votes
1answer
690 views

Stop ArcMap from probing missing data sources on launch

When migrating a map from one environment to another (say, from an existing client environment to our development environment) we're often given MXD documents that represent the map. These documents ...
3
votes
3answers
497 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 ...
2
votes
2answers
553 views

ArcSDE edits not showing up in ArcGIS Server Geodata Service?

I've got an ArcGIS Server GeoData service against an SDE MSSql database. When changes are made to the source data, the edits don't appear to show up in the GeoData service. If I restart the ...
7
votes
4answers
2k 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.
3
votes
1answer
945 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 ...
2
votes
1answer
759 views

Is there any way to perform spatial filter on multiple layers together?

I have a scenario where a featureclass[Child Version] is queried for some overlapping features on [SDE.DEFAULT] Version using ISpatialFilter, After getting few result, these features are looped and ...
4
votes
1answer
226 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 ...
2
votes
1answer
395 views

Has anyone successfully made a FeatureLayer from a view in DB2 and ArcSDE 10?

Lately it seems like every new ESRI feature fails for me - I must be cursed. I'm testing the use of a FeatureLayer to see if helps display and query features using the JavaScript API 2.0. This layer ...
1
vote
1answer
2k views

Product License not initialized error when trying to open an SDE connection in ArcObjects

I am trying to connect to create connection in using ArcObjects using the code below. IPropertySet propertySet = new PropertySet(); IWorkspaceFactory sdeWsFactory = new SdeWorkspaceFactory(); ...
12
votes
5answers
8k views

ArcSDE connection limit exceeded

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
2
votes
2answers
574 views

Big IRowBuffer problem

I have a small software that connects to a database (SQLServer) reads a few values and transfers them to a SDE Oracle instance (11g). The problem is: I have over half million records that I need to ...
3
votes
2answers
432 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 features,...
6
votes
7answers
6k views

Troubleshoot editing features in feature dataset with ArcMap / ArcSDE Oracle

I am having trouble editing a feature class that is in a feature dataset. We have added just the single feature class as a layer in ArcMap and are using the "Start Editing" function on the Editing ...
3
votes
2answers
2k 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, ...
5
votes
3answers
1k views

SDE views not showing values in joined table

I created an SDE view between a point feature class and a table (stored in SDE) - the join is done on a text field called RFRNC. I changed the view so that it is now a LEFT OUTER JOIN in line with ...
3
votes
2answers
359 views

Transforming 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 lat/...
4
votes
2answers
271 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 ...
4
votes
2answers
850 views

ArcSDE 10 and PostgreSQL 8.3 vs 8.4

We have recently upgraded our ArcSDE 9.3 instance to ArcSDE 10. I was hoping to upgrade postgresql 8.3 to 8.4 at the same time. Although ArcSDE 10 supports 8.4, it turns out that the ArcSDE wizards ...
2
votes
6answers
2k views

How can I connect to a PostGIS database from ArcCatalog 9.3 via ArcSDE?

I have a problem connecting to my postgis database via ArcSDE in Arc Catalog. When i want to establish connection to my database i get an error:
2
votes
2answers
417 views

Using ArcSDE on an Oracle DB, how can I tell which users have permissions to a Feature Class

I created a new Feature Class, and I assigned some users SELECT privileges to that Feature Class. I want to look at the list of users that I have assigned privileges to, how do I do that? Updated ...
2
votes
3answers
2k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several feature sets 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 ...
0
votes
1answer
132 views

Retrieving attribute's domain using ArcIMS ActiveX Connector?

I have an ArcIMS Image Service that's consuming data stored in an ArcSDE database (both v9.3.1). Many of the layers have attribute columns that use coded value domains defined in the SDE database, ...
0
votes
2answers
193 views

APDM - error exporting database from Oracle

I have a fairly large database on a slow network and I am using a third party tool to update data which calculates other fields and so on. I have a guid string with an empty box (weird glyph - seen ...
6
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 ...
2
votes
2answers
2k views

Restart IIS Admin Service or Recycle Default App Pool?

A weekly maintenance process requires stopping ArcGIS Server and ArcSDE services. After restarting all the services, is it better to restart IIS Admin Service or recycle Default App Pool? I currently ...
12
votes
4answers
6k views

Is it possible to connect to ArcSDE using QGIS?

Is anyone aware of any plugins, or any other way to connect and view data from an ArcSDE database in QGIS desktop?
21
votes
3answers
8k views

What is difference between ArcSDE and spatially enabled databases?

When would you want to use ArcSDE (available as ArcGIS Server Basic license level) versus a spatially enabled database? What are the trade-offs on either side? What are the benefits on either side?...