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
156 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
297 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
151 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
197 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
190 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
74 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
586 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
355 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
260 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
308 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
93 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
309 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 ...
1
vote
0answers
158 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.
0
votes
0answers
31 views

Changing alias of ArcSDE feature class?

I have a feature class. I want to edit the alias. When I go into the Properties of the FC and try to edit the alias, nothing happens. The field will not accept focus and changes are not allowed. How ...
0
votes
0answers
33 views

Is it possible to create a spatial view with arcpy?

We currently use an extension in ArcMap that was created in house to make a spatial view from two tables on an SDE server. The first table is a SDE Feature Class of all US postal zip codes (polygon). ...
0
votes
0answers
22 views

Changing names of versions that have a child

Is it possible to change the name of a version that currently has a child associated with it?
0
votes
0answers
15 views

How to edit ArcGIS archive layer?

I am working in the ArcGIS enterprise Geo database environment. all feature data sets are enabled for archiving. When I was editing the default feature data set some important data was deleted by a ...
0
votes
0answers
51 views

Database connection fails when using db authentication, succeeds using OS

When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get the lovely "Connection was attempted with an ...
0
votes
0answers
49 views

ArcCatalog Unable to Connect to Database (Invalid object name SDE_table_registry)

Trying to make a database connection in ArcCatalog The ArcServer is on a separate vm than the SQL Server vm. When I attempt to connect to the database using integrated security I get the error: ...
0
votes
0answers
52 views

Establishing direct connection to ESRI geodatabase on Oracle hangs while not in debug mode

Recently I have been trying to establish direct connection to oracle geodatabase using Java API. The problem is, that when I execute the code, the connection works fine only in debug mode when I ...
0
votes
0answers
54 views

Using Arcpy to Update Data Source Does Not Update Related Tables

I have a python script that updates the data source of mxd's from staging to production. Here is an example of the code: import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Project\MyMap.mxd") for lyr ...
0
votes
0answers
29 views

Troubles setting correct projection in SDE

I have to transformate data and change the coordinate system but have troubles to set it correct programmatically. I have: ArcGIS 10.2 / MS SQL-Server 10.0.5520 / sde 10.2.2 My steps: 1) Some ...
0
votes
0answers
63 views

ArcGIS Versioning - Conflicts option greyed out / disabled

I'm relatively new to the world of Versioning and using SDE databases, and have come across a problem that I can't solve. Summed up - the Conflicts option/button is greyed out/disabled, and I know ...
0
votes
0answers
29 views

How to get metadata about Esri Geodatabase Replica synchronization

I'm using ArcObjects for .NET to create an one-way replica from my geodata-service (master) to an ArcSDE geodatabase (slave). During synchronization I do need metadata about the incoming changes to ...
0
votes
0answers
35 views

Unable to create multiple geodatabases in ArcSDE?

I am trying to create multiple instances in arcsde 10.3. Able to create and run the first instance. But, when I tried to run the second instance it throws error(attached) in create/enable geodatabase ...
0
votes
0answers
32 views

Multiple editors

I am trying to have multiple editors editing the same layer at the same time. I am running ArcInfo v10.2 and have set up a SDE connection using sqlexpress. I have created a geodatabase on my personal ...
0
votes
0answers
29 views

Reviewing version conflicts - over 600!

I'm fairly new to working with versioned geodatabases and have found that one of my versions has over 600 conflicts which require review and replacing. I suspect that all objects will need to be ...
0
votes
0answers
60 views

Can't create address locator in SQL Express GDB

I am working out of a SQL Express ArcSDE geodatabase with ArcGIS 10.3.0 Standard and would like to create a composite address locator based on streets and parcels. I can copy and rebuild a streets ...
0
votes
0answers
32 views

libst_raster_pg.dll for PostgreSQL 9.2

I need to store my raster in an enterprise geodatabase with st_raster data type. Copying libst_raster_pg.dll from C:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\PostgreSQL\9.2\Windows64 ...
0
votes
0answers
41 views

Can't create ArcGIS feature class with PG_GEOMETRY keyword

I have enabled a PostgreSQL database as an enterprise geodatabase with ArcCatalog 10.3 (using server license file etc). When I create a new feature class with PG_GEOMETRY keyword, I get an error: ...
0
votes
0answers
161 views

Problems with direct connection to ESRI Oracle db for 9.3.1?

I am trying to create a direct connection to ESRI Oracle database for version 9.3.1. When I try to connect I get this error: org.geotools.arcsde.ArcSdeException: Can't create connection to none for ...
0
votes
0answers
70 views

Accessing Versioned data using database link

I have geodatabase on one Oracle server. The data is versioned. I am trying to access the versioned data from another Oracle server using a database link. While accessing the a feature class named ...
0
votes
0answers
32 views

Is a unioned feature class the fastest/best way to quickly get attributes from multiple feature classes at once?

I've been asked to create a feature class by unioning 18 polygon feature classes together, and retaining only certain attributes. The goal is to have a single feature class that can be queried once to ...
0
votes
0answers
37 views

Python script can't find custom module in ArcSDE

I've been working on a python script for some time. Its working well but I'm having trouble running it in SDE. My main issue is that the python script, when run in SDE, cannot find any of the ...
0
votes
0answers
24 views

Map Control Didn't Show Editing Result

I have created an application with data from SDE Geodatabase (Oracle). I've registered it as version without tick on the option to move edits to base. Anyway, in my application there is a part where ...
0
votes
0answers
38 views

inherted .net extension not connecting to arcSDE in ArcMap10.2.2

I have a custom .net extension tool that is supposed to connect to a file geodatabase or SDE (SQL Server). The SDE connection fails to recognize it as valid. The file geodatabase connection works just ...
0
votes
0answers
24 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
0
votes
0answers
190 views

Need to connect ArcSDE dataset using QGIS Desktop and Oracle database

I am working in GIS domain using ESRI technology. I want to use QGIS desktop to access ArcSDE dataset from a local machine. I have already installed Oracle Client 10g and QGIS Desktop 2.8.1 through ...
0
votes
0answers
37 views

Trouble with select by attribute on ArcSDE

I am having trouble with some extracts on a csv table on ArcSDE. Verifying my expression results in the following pop up: "The expression was verified successfully but no records were returned."
0
votes
0answers
48 views

View Oracle GeoRaster in ArcMap

I have imported SRTM DEM into Oracle 11g using FME.The block size is set to 128X128.I am able to view the data in QGIS,Tatuk and play with it using GDAl command line.Unable to view the same in ArcMap. ...
0
votes
0answers
24 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
120 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
191 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
92 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
313 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
132 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
40 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
80 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 ...