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.
3
votes
2answers
61 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 ...
3
votes
2answers
84 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 ...
3
votes
0answers
268 views
Error opening feature class from SDE (which can be opened in another application)
We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g.
I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
0answers
79 views
How to enable SDE Archiving with python and the SDE api ArcGIS 10.0
I have a script that does some register as versioned and updating privileges. How would I call into the c api for ArcSDE to enable archiving with python?
...
3
votes
0answers
148 views
ArcSDE Database Refactoring Tools?
We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas.
But we also work with GIS applications using esri ...
3
votes
0answers
159 views
Cartographic Representations Load Rather Than Feature Symbology
We use ArcSDE to allow multiple users (both in my office and elsewhere) to access feature classes that my office maintains. We also use cartographic representations for many of our feature classes.
...
3
votes
0answers
158 views
ArcSDE - How to edit mosaic dataset
I have a mosaic dataset (Raster) in an SDE database. As expected, when I click start editing, ArcMap says that I have to do "Register as Versioned" before, but I can't have a mosaic dataset in a ...
3
votes
3answers
204 views
Is there any way to write a snipet of code with function of “SDELayer -o register” command
I try to create a geodatabase using some SQL command and then register some tables of it with SDE.
I create an empty geodatabase using sde post installation and then create tables and other database ...
2
votes
3answers
564 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 ...
2
votes
2answers
239 views
Short name for SDE featureclass?
Is there an ArcObjects function to get a short name version of an SDE featureclass?
For example if my featureclass is:
FOOSCHEMA.BARLAYER
How do I just get "BARLAYER".
Or is it just a simple case ...
2
votes
3answers
704 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 ...
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
1k views
How do I access versioned spatial data in SDE with SQL queries?
We're running SDE and have several featuresets 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 ...
2
votes
2answers
294 views
I need help understanding ArcSDE and Server. How can I access services outside network?
I'm learning about ArcSDE and ArcGIS for Server on my own without any official training.
I've successfully installed ArcSDE and Server for 10.1.
We are using SQL Server 2012 on a Windows 2012 Server ...
2
votes
2answers
190 views
Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?
I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)??
Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
2
votes
1answer
884 views
Feature Class To Geodatabase => ERROR 000210: Cannot create output
error messages:
Executing: FeatureClassToGeodatabase E:\jags20120321.mdb\ch_cs "Database Connections\Connection to localhost.sde" "Database Connections\Connection to localhost.sde"
Start Time: Sat ...
2
votes
3answers
1k views
Unable to edit data in an ArcSDE geodatabase
I'm dealing for the first time with an ArcSDE geodatabase so I'm facing simple problems to you. ESRI help wasn't of much help (to a begginer at least).
I can't edit my data in ArcMap, most probably ...
2
votes
1answer
168 views
Connect to ArcSDE geodatabase over LAN?
I am running ArcGIS Server 10, with ArcSDE 10. I have a geodatabase that I would like my colleague to connect to over the LAN at our office. How do I go about doing this? I would prefer a list of ...
2
votes
2answers
1k views
Create ArcSDE Database from ArcCatalog
Is there a way to create a spatial database from ArcCatalog that also creates the ArcSDE user, repository, and service.
Basically, I am trying to do everything that the ArcSDE Post Installation does, ...
2
votes
1answer
119 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 ...
2
votes
1answer
397 views
How do I format SQL queries for use in Arcpy?
I have to make an SQL query on a column having not adequat name "type_borne_id", I couldn't make SQL queries using arcpy.Select_analysis neither selectbyattribute, but when I use select_analysis ...
2
votes
3answers
600 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)?
2
votes
2answers
155 views
How to store large amounts of text in an SDE table
I need to store a lot of text in a field in an SDE registered business table (an ITable, not a featureclass) - let's say 10,000 words roughly. I am using Oracle 10g and ArcSDE 9.1.
I am programming ...
2
votes
2answers
298 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
2answers
1k 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 ...
2
votes
2answers
259 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 ...
2
votes
1answer
117 views
SQL Plus error using sdeversion
I'm new to SQL Plus and I have a question. I've created several versions of a feature class located on a SDE database. I want to use ArcSDE Administration Commands found here but I'm getting an error ...
2
votes
2answers
356 views
Understanding How ArcGIS Displays Non Spatial Data Created in Microsoft Access
I am working on getting American Community Survey(ACS) data into SDE table format. I have managed to import all the text files downloaded from ACS into excel and then imported to Access for further ...
2
votes
1answer
221 views
Is there an se_toolkit version for ArcSDE 10?
I have the one for 9.3 downloaded--is there a version for ArcSDE 10? So far my 9.3 version of se_toolkit is working against 10 geodatabases, but I've only tried a couple of the tools(sdeping and ...
2
votes
1answer
183 views
Query for Selecting only Selected Fc's from a GDB
I need to version n number of fc's which start with sde."ENT-QA". I need to select only those feature classes and run versioning for it. Can anyone help me in writing the query for selecting only fc's ...
2
votes
1answer
274 views
How to cast SDE table to IFeatureClassLoad
How do you cast an SDE table to IFeatureClassLoad using ArcObjects? I'm getting an error with this attempt below which is not the correct method:
Dim pSDEFeatWksp As IFeatureWorkspace = ...
2
votes
2answers
232 views
How to perform a “vertical integration” using FME?
I am not a GIS person, but I need to understand an aspect of the project I'm working on.
We are taking an ArcSDE layer, and importing it into FME. I now need to do some checking of the data. In ...
2
votes
3answers
551 views
Definition Query to Python script on Oracle 9i and ArcGIS 9.3.1
SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS IS NULL OR SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS = 976
The above is my def query in ArcMap against ArcSDE ...
2
votes
2answers
589 views
How to add a Database Server in Catalog?
I have ArcSDE on an Oracle database and I want to add a database server connection to ArcCatalog, I've seen several sites but they don't say what I have to write down. Let me explain:
From the tree ...
2
votes
3answers
870 views
how to configure an arcgis server service to enable multiple editing
I'm using ArcGIS Server 9.3.1, ArcSDE, VS.NET 2008 and I'm trying to enable a service to be edited multiple times, the service its going to be public and it will be used to report emergencies and ...
2
votes
3answers
651 views
Can you set the PostGIS SRID when creating a Feature class through ArcCatalog?
I have ArcSDE installed in a Postgresql database and I am using PostGIS geometry. I'm not a DB minded person so feel free to let me know if my process is not right.
I create my feature class in ...
2
votes
2answers
404 views
Edits in SDE not showing up in AGS 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 ...
2
votes
1answer
38 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
201 views
ArcSDE: Specifying fields to not allow null values
I have a feature class in SDE that has various fields where the setting AllowNulls is set to FALSE.
When creating a feature in ArcMap in this feature class it still allows nulls to be specified in ...
2
votes
1answer
256 views
validate SDE features within arcObjects (cant use sdeLayer)
I'm trying to sweep through a feature class checking for invalid features (and log the invalid features).
Would IValidation.Validate work or does that just check for rules?
If not I'm guessing I ...
2
votes
1answer
159 views
Is there a way to delete definition querys of multiple layers in ArcMap 9.3.1?
I'm searching for a way to freeze/delete definition queries of several layers at once (instead of doing it manually by opening the properties of each layer). I'm working on a SDE 9.3.1 Geodatabase.
2
votes
2answers
804 views
ArcPy Changing Spatial Database Connection
hi we have conveyed our some servers which has ArcGIS application and SDE on it to another server and its ip has changed. now when i want to open my .mxd file it tries to connect remote SDE with old ...
2
votes
1answer
336 views
ArcSDE 10 FeatureLayer is read only, FeatureTypes property is null, not sure why
I have a WPF FeatureLayer backed by an ArcSDE feature class that I hope to use for editing. After the layer is done initializing its readOnly property is true, I think that this points to some problem ...
2
votes
1answer
641 views
How to create SDE GDB without post installation?
Is there any way to create a SDE sqlserver2008 geodatabase without :
SDE post-installation execution on the server
having sde service running on the server
and using :
execution of some DDL ...
2
votes
2answers
432 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 ...
2
votes
3answers
60 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 ...
2
votes
1answer
132 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 ...
2
votes
1answer
57 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, ...
2
votes
1answer
75 views
Join feature classes from two ArcSDE geodatabases with same schema?
I am working with two ArcSDE geodatabases -- one for test, one for production. They both have the same schema. I recalculated an attribute in the test environment and wanted to push that to ...
2
votes
1answer
228 views
Create dynamically multiple layers in ArcGIS Server 10.1
I am using ArcGIS Server 10.1 and Desktop 10.1 software.
I am publishing table from sqlserver to the ArcGIS server, that table (from sqlserver) is updating hourly, and the types are increasing.
I ...
