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)

1
vote
0answers
27 views

Can I install GIS Software on RSS (informix server) running 11.7.fc6

I currently use ArcGIS Server 10.0 and consume data through a db2 database. I recently installed an RSS informix server and was hoping to pull data from this since it is updated real-time versus the ...
1
vote
0answers
46 views

ora-01747: user.table.column, table.column or column description is invalid

everyone. I created a table in oracle with a sde.st_geometry column. I followed the instructions of ArcGIS help to register the table into geodatabase. However, when I try to load data into this ...
1
vote
0answers
52 views

Renaming Feature Class within versioned Feature Dataset

I am working in ArcSDE. I have several feature datasets within an Oracle Enterprise Geodatabase. When I try to rename one of the feature classes that is within a feature dataset it "falls out" of the ...
1
vote
0answers
72 views

Editing versioned view in ArcSDE 10.1 error

I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete ...
1
vote
0answers
117 views

Changing default precision and scale of number fields in ArcSDE geodatabase table?

After I change the precision and scale for my short, long, float, and double field types when creating a table in ArcMap SDE geodatabase, ArcMap will reset my precision and scale to default values. ...
1
vote
0answers
68 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
1
vote
0answers
233 views

Using arcpy.CopyFeatures_management results in a 000210 using a database connection that does not contain saved credentials

Currently have a problem running CopyFeatures_management in ESRI's ArcGIS 10.1 The following shows two Enterprise Geodatabase connection files. One includes the username and password and the other ...
1
vote
0answers
162 views

Running python script outside of Arcmap's python console

My codes works fine in Arcmap's python windows. But when I try to run it in a command promt windows, It says that; ERROR 000837: The workspace is not the correct workspace type. But it works fine ...
1
vote
0answers
43 views

Multiuser Editing with ArcGIS through LAN

I am working on an ArcObjects application (C#), which is supposed to carry some customized editing operations, the database is ArcSDE based on Postgresql via (accessible via a LAN network). One ...
1
vote
0answers
277 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
1
vote
0answers
69 views

How do I bypass class extensions when reading from ArcSDE with FME 2014?

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data. I am not able to set the Reader to bypass the class ...
1
vote
0answers
54 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
1
vote
0answers
54 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
1
vote
0answers
60 views

Problems with versioning

I have 5 PostgreSQL_PostGIS database in my company and i conneting on them through ArcSDE. Four of database work correctly, only with one i have i realy big problem. When i make two versions of ...
1
vote
0answers
89 views

Why might ArcPy, TableToTable, MakeQueryTable and ArcSDE have performance issue in IDLE?

I have written a Python script tool to do: Make Query Table Table To Table (with fieldmapping). The code is nothing more than arcpy.MakeQueryTable("table1;table2;table3", ...
1
vote
0answers
69 views

What is the relationship between Map Service Instances and SDE connections?

We have a GPS project based on ArcGIS Mobile 10.0. There are two web map services and each were kept as Nonpooled with Minimum instances 15 and maximum instances 60 by original developer. The database ...
1
vote
0answers
94 views

“Definition Query on a versioned Geodatabase”

I would like to implement Specific views to the SDE users, based on Definition Queries of common attributes , like Date created > = October 1. But on first look, the definition queries are for ...
1
vote
0answers
73 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
1
vote
0answers
130 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
1
vote
0answers
266 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
1
vote
0answers
121 views

How to display labels from many-to-many relationship in ArcGIS 10 using VB.NET?

I have two tables in a geodatabase: parcel; and person 1 or + parcel, can have 1 or + person (relationship is many-to-many) Using VB.NET I can display all the parcel labelled with the ...
1
vote
0answers
223 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) ...
1
vote
0answers
119 views

Extract an ArcSDE datasets (rasters/shape files) using python?

I would like to write a python script to extract/export a dataset (rasters/shape files) in ArcSDE. I saw this posts to connect to the server: Define Workspace for SDE Connection in Python But how ...
1
vote
0answers
168 views

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in ...
1
vote
0answers
177 views

Best practice for loading shapefiles into ArcSDE geodatabase using web application

We are developing a web GIS using Flexviewer and we want to allow users to upload a shp file and insert it into a ArcSDE geodatabase. I think there are two steps at least. upload the shp file (zip) ...
1
vote
0answers
45 views

Managing outages to make ArcSDE updates?

I would like options to manage ArcSDE outages for making updates to schema, which I am not able to do when users are just reading the feature classes. I would like to not have to stay late to get ...
1
vote
0answers
69 views

sdequery.exe: When using functions as column names (-C parameter), how do you escape the comma for functions with parameters?

Using sdequery, I'm specifically trying to return sys_context('USERENV', 'SESSIONID'). user and sysdate work fine. Functions with single parameters work fine. But as soon as I use a function with ...
1
vote
0answers
499 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
1
vote
0answers
44 views

Edits geodatabase

I am trying to reconcile and post the edits. Before doing that I want to manage the edits in such way that the edits are queued before reconcile and post. I am doing this using c#.
1
vote
0answers
329 views

Can feature layer in MXD with joined data from non-geodatabase be published as feature service?

I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
1
vote
0answers
210 views

Creating relationship class in ArcSDE?

I can not seem to create a relationship class in ArcSDE, or at least one that works. I am succseful in creating the class however ArcMap does not recongnize it (there are no related tables shown) and ...
1
vote
0answers
288 views

Loaded shapefile into SDE without spatial proj creates problem

Via a Python script - various shapefiles were loaded into SDE with no spatial reference set. This causes a strange problem - when you view the featureclass in ArcCatalog (geography view) - it shows ...
1
vote
0answers
89 views

Can we do replication and versioning in User schema geodatabases version with sde default version

As both are administrators to their own schemas, is there any possibility to post and reconcile data across schemas?
1
vote
0answers
297 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
0
votes
0answers
20 views

How to …NonRelational geoDB to Relational geoDB

I have Access personal database without any relations and would like to import all data in SQL using ARCSDE Personal and build relations. This is bad structured database and I just couldn't figure out ...
0
votes
0answers
31 views

Unable to create multiversion view in ArcSDE 10.2 and Oracle 11g

I couldnt create a multiversion view using 10.2. I registered feature dataset as versioned, it created MV view for one class but didnt create the MV view for the other one. Even I tried creating the ...
0
votes
0answers
26 views

How to correctly uncompress and re-compress an msd file using 7zip from command line

I am trying to uncompress and recompress both the msd and sd file so as to tweak some things I want. In fact I want to get inside the layers folder and for each layer.xml file to string replace the ...
0
votes
0answers
82 views

Error selecting geometry from Oracle DB

I'm trying to select a geometry column as well-known text from a feature class in an Oracle 11g/ArcSDE 10.1 geodatabase. (This is in a Python script using pypyodbc as a driver). This is my SQL: ...
0
votes
0answers
39 views

What is the most efficient method for deleting row/features from a versioned FC in python?

I'm trying to delete all records from a feature class in SDE and then append new data using python. My dataset is versioned in SDE. I've tried Truncate Table (doesn't work with versioned tables), ...
0
votes
0answers
15 views

How to see original versions of imported features with archiving enabled

I recently imported several feature classes into an ArcSDE Oracle database, registered them as versioned, and then enabled archiving. I was under the impression that I would be able to see a ...
0
votes
0answers
30 views

Web Editing Versioned Enterprise GDB

I would like to implement a web editing environment where edits are posted to a version of a database (delta tables) not too default. The idea behind this is so that any edits made through a web app ...
0
votes
0answers
128 views

ORA-04043: object ST_GEOMETRY_SHAPELIB_PKG does not exist

I uninstalled ArcSDE using the esri.exe, and dropped user sde through running the sql statement "drop user sde cascade". Now I want to reinstall ArcSDE. The installation runs successfully, but when I ...
0
votes
0answers
42 views

Exporting ArcSDE feature class to shapefile using OGR?

I'd like to export data from ArcSDE for SQL Server to SHP. I've tried first to run this python script in QGIS: http://trac.osgeo.org/gdal/browser/trunk/autotest/ogr/ogr_sde.py But finally I've got ...
0
votes
0answers
50 views

How to get ArcSDE plugin working with Geoserver 2.5.1

I'm trying to get the ESRI ArcSDE plugin to work with my instance of Geoserver. This is my current setup: Tomcat 7 GeoServer 2.5.1 ArcSDE Plugin for GeoServer 2.5.1 WEB-INF\lib\icu4j-3.4.4.jar ...
0
votes
0answers
48 views

Is there a way to QGis read an SDE.ST_GEOMETRY field?

this is the type and name that Qgis displays for me when I connect with a oracle table,it is not displayed as a geo column, there is a setting I'm missing? Can Qgis Read this type of data?
0
votes
0answers
36 views

Query's “Get Unique Values” includes case variants that don't exist in attribute table

I ran a query on an ArcSDE 10.2 Feature Class to find features that do not follow our office's standard of being in uppercase. The "Get Unique Values" seems to return values that do not exist in the ...
0
votes
0answers
57 views

Error post installation ArcSDE for SQL server 2008

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then ...
0
votes
0answers
46 views

SQL Server 2012 spatial check constraints disabled after migration from 2008

Currently we are using SQL Server 2008 geometry datatyped columns in our databases. These are registered with ESRIs enterprise geodatabase repository, so every spatial table has a check constraint ...
0
votes
0answers
89 views

Entity Framework 6 and ST_Geometry column type

I have ArcSDE 9.3 database and I'm trying to use EF6 with it. When I generate the model from database, I get the following message: The data type 'st_geometry' is currently not supported for the ...
0
votes
0answers
14 views

Where are the settings that control when clustering starts and stops?

We have a SDE set up on a SQL Server and we're using the Silverlight API. Our layer has buildings on it. The flare clustering and large clusters show when the map is opened and the actual buildings ...