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)

4
votes
3answers
2k views

Is there a way to see the coded value domain list of possible values from arcmap 9.3.1?

Is there a way to see the possible values of a specific coded value domain in arcmap 9.3.1 (I have no access to the SDE which holds all the data in arcCatalog)?
4
votes
1answer
1k views

Granting permission in ArcSDE geodatabasewhen layers are inside 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 ...
4
votes
1answer
144 views

Does ST_GEOMETRY support Linear Referencing

I am wondering if the ArcGIS ST_GEOMETRY provides Linear Referencing functions, such as creating a point based on a given measurement, like Oracle Spatial. I couldn't find any function like that in ...
4
votes
2answers
7k views

What is the difference between ArcSDE and ArcGIS Server?

I have been working with ArcGIS Desktop where I use ArcMap for doing GIS work. Can anyone please explain to me in simple words What is ArcSDE and ArcGIS server? These can be independent dedicated ...
4
votes
1answer
832 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 ...
4
votes
1answer
875 views

Access Metadata from ArcSDE-tables using python

Is it possible to access the metadata of a feature class in a ArcSDE-data, using arcpy / python (on Arcgis 10.0). I suppose I could export the metadata to xml and parse the xml, but is there a more ...
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
1answer
32 views

Are ESRI spatial views regenerated whenever they are queried?

If a spatial view contains data "joined" from multiple tables, will all the tables be queried whenever a query is executed against the spatial view? We have some spatial views and whenever we run a ...
4
votes
2answers
79 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
4
votes
1answer
2k views

ORA-28595: Extproc agent : Invalid DLL Path

I'm trying to create a table with spatial column in oracle and insert data into it. I'm using ArcSDE and Oracle. The version of Oracle is 11.2.0, the version of ArcSDE is 10.0. My create statement ...
4
votes
1answer
360 views

Does ArcSDE require Oracle Spatial rather than Oracle Locator licensing for any functionality when working with SDO_GEOMETRY?

I'm looking for specific information on whether the ESRI suite requires Oracle Spatial for any of the functionality, or if Locator is always sufficient for working with SDO_GEOMETRY objects? Do you ...
4
votes
1answer
5k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
4
votes
3answers
2k views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
4
votes
2answers
3k 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 ...
4
votes
3answers
2k views

Spatial Views in SDE - What causes them to become unregistered from the geodatabase

Spatial views in ArcSDE allow you to join columns from a 'non-spatial' table in the database to a table with a 'geometry column'. They can also allow you to format and choose the attribute columns ...
4
votes
1answer
408 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! ...
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 ...
4
votes
1answer
66 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field ...
4
votes
1answer
103 views

Update value in domain and same should reflect in attribute field

I have a SDE GDB, where i have no. of domains created. we have created domain for state names, which is used by all feature classes to update their respective state name. Now i have discovered that ...
4
votes
1answer
162 views

How can I programatically register a feature class as versioned

Is there a way to programatically register a feature class as versioned? I'm able to register aFeatureDatasetwith the IVersionObject3 interface, but not an individual feature class.
4
votes
1answer
534 views

How to populate SQL options for ModelBuilder parameter from ArcSDE feature class?

I am creating a very basic model tool for a class project and I am running into trouble getting the SQL values to populate. I have read the ArcGIS 10: How to populate SQL options for parameter in tool ...
4
votes
2answers
672 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 ...
4
votes
1answer
244 views

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 ...
4
votes
1answer
266 views

Using xml workspace to overwrite geodatabase in ArcGIS Server 10 with ArcSDE for SQL Server?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
4
votes
2answers
471 views

Calculating space 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 ...
4
votes
2answers
2k views

What is the best way to migrate an SDE Database

We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database. ArcSDE 9.3.1 on Linux SLES 4 Now, what is the best way to do ...
4
votes
2answers
932 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 ...
4
votes
2answers
481 views

ArcObjects ISQLSyntax with Oracle DB esriSQL_DelimitedIdentifierPrefix issue

New to stack exchange, heading over from the esri forums, it is great! I am trying to produce a query that I can use across all workspaces, naturally using ISQLSyntax. The problem I'm having is that ...
4
votes
2answers
363 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
4
votes
1answer
330 views

Identifying geometry storage type in geodatabase stored in Oracle?

How do I identify what geometry storage type is being used with a specific geodatabase stored in Oracle 9i via ArcSDE 9.3.1?
4
votes
2answers
7k views

Error accessing spatial database connection with ArcGIS 10

I set up a new SDE database with ArcGIS 10 and everything appeared to go correctly. The service is running and I'm able to view the database in SQL Server. However, when I try to access the spatial ...
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 ...
4
votes
1answer
36 views

Auto-generated field in ArcSDE for end user

The objective: Create a process where a coworker can open an .MXD, start editing, add a feature to represent a complaint, then add records in a related table to represent an inspection. Along the way, ...
4
votes
2answers
72 views

Is there a LINQ-provider for GeoDatabase

I want to query my ArcSDE geodatabase using LINQ but I don´t know if there is an ESRI-provider that may also read geometries and which is able to handle archiving as well. Thus I´d like to read data ...
4
votes
1answer
325 views

Which ArcGIS SDK to use ArcSDE SDK, ArcGis Runtime SDK, ArcObjects SDK?

I have a geodatabase on SQL Server 2008 R2 and ArcGIS 10.2.2 installed. Both are on my local computer. I will interface to a Delphi Application and my aim is to query some records/fields line by ...
4
votes
1answer
408 views

Populate X and Y fields in SDE Point Data Using SQL trigger

Here is my situation. I am running ESRI ArcGIS Server and Desktop 10.2 on SQL Server 2008 R2. I would like to populate the Latitude and Longitude fields from point data (Signs data collected using ...
4
votes
1answer
171 views

Attribute Indexes ArcSDE 9.3.1 for Attribute Joins on GUID field types

I create my joins on primary/foreign keys that are guids...I don't seem to be able to create an index on this field in my target table. After joining to this table it takes 4 minutes to open the ...
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 ...
4
votes
0answers
147 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
4
votes
0answers
238 views

How to repair Geometric Network in Versioned ArcSDE Geodatabase?

Our Versioned ArcSDE workflow has a feature dataset with Geometric Network in the parent (Default), which users derive in their own versions. It is now observed that in some versions, the geometric ...
4
votes
1answer
731 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 ...
3
votes
3answers
547 views

Can ArcGIS Server be called ArcSDE? I'm confused about terminology

I'm confused about some ESRI terminology. If I have ArcGIS 10.1 Server installed and we use Enterprise geodatabases with versioning capabilities but we use direction connections does this have ...
3
votes
3answers
2k views

Tracking change with ArcSDE/Oracle

I'm looking for the simplest way to track changes ([delete, update, create] feature(s)) made to the DEFAULT version of a given feature class in ArcSDE(10) and Oracle(11g). Qualifier: I am not a dba ...
3
votes
2answers
150 views

Can feature classes have the same name in two different feature datasets?

I have an SDE Database called "Vector" which contains many feature datasets eg. Region_1, Region_2 etc. I have to reproject the feature classes inside these datasets. Instead of creating a new ...
3
votes
2answers
2k views

ListFeature classes in SDE

I have this code: def backSDE(ActiveSDE): arcpy.env.overwriteOutput = True arcpy.env.workspace = ActiveSDE fcs = arcpy.ListFeatureClasses() print fcs #Databases ActiveSDE = ...
3
votes
3answers
1k views

Cause of selected [ArcSDE 10] feature dataset does not contain any feature classes which can participate in topology?

When trying to create a topology for a polygon feature class in ArcSDE 10. I right click the feature dataset that the feature class resides and try to create a new topology. I get an error saying, ...
3
votes
3answers
970 views

Transfering a lot of features from geodatabases?

I'm having a problem where I need to export a large amount of content from 2 geodatabases of different nature (SDE -> File). I have three options: Spatial Select, a regular SQL select and the full ...
3
votes
2answers
431 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
2answers
350 views

Creating a weekly FGDB backup of ArcSDE?

I need to create a script that will copy our county's parcel data, maintained in SDE/SQL, to a file geodatabase. This script will be run as a scheduled task over the weekend. What GP tool do you ...
3
votes
1answer
2k 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?