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.
2
votes
2answers
27 views
Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?
I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user.
I was wondering what the reason for this is?
Thanks.
4
votes
2answers
65 views
What are the benefits of using ArcGIS with Postgresql over simply ArcSDE?
I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
0
votes
1answer
25 views
Migrating Lines to ArcGIS polyline
I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase.
and some data will cause the error.
Its says not enough points for feature class, but when I look ...
0
votes
0answers
16 views
Oracle Feature Class Couldn't Displayed
I got problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on ...
0
votes
0answers
8 views
Export ArcGIS TilePackage from large RasterDataset
We store a large (>1TB) RasterDataset of our Orthoimagery in an ArcSDE 9.3.1 Dataserver (on SQL Server 2008 SP1).
With ArcGIS Server 10.1 we want to export TilePackages of certain areas to use them ...
1
vote
1answer
37 views
How to insert features in a MS SQL based SDE without giving ObjectID s?
I'm trying to load features into ArcSDE without using ArcObjects, and using SQL from my .NET Application instead.
I have followed the answers given in this question: Is it possible to load features ...
2
votes
1answer
48 views
Convert OpenStreetMap schemas to ArcSDE in PostgreSQL database
I am trying to find a way to store OSM Extracts (or possibly the planetfile) in a PostgreSQL database, keep it up to date with diff files and then process the data further with ArcGIS (e.g. Geocoding, ...
0
votes
1answer
33 views
Problem in filling table of ArcSDE feature class in SQL Server 2008?
I have an ArcSDE point feature class and I add it to ArcMap 10.
After that I add some points to it and fill every field for all points in the attribute table and Save Editing.
However, the SQL ...
1
vote
0answers
24 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 ...
3
votes
1answer
59 views
How can I list SDE versions using Python?
I have an SDE geodatabase with different versions for each user.
How can I list each version using Python?
1
vote
1answer
42 views
ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?
In the system I'm building, we've got a facility that can be represented as either a point, or a point within a polygon (the point in the polygon may or may not be the polygon's centroid).
I'm using ...
0
votes
2answers
81 views
How to learn ArcGIS Server? [closed]
I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both.
How can I learn to use it. I want to learn ArcSDE but i am unable to understand it.
Is ArcSDE available with ArcGIS ...
0
votes
1answer
27 views
Why can't a user with db_owner role version data?
I've made an enterprise geodatabase and added a user with db_owner permissions.
When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able ...
0
votes
0answers
33 views
how to access a feature class in SDE using arcpy [duplicate]
I am new to Python and Arcpy. I am trying to access the SDE server to extract some information from feature classes that reside in the server database. I know the name of the feature class and I also ...
3
votes
1answer
71 views
How can I validate a table name on SDE with Oracle backend?
Second title: "Is arcpy.ValidateTableName broken on Oracle?"
I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
5
votes
2answers
105 views
How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?
I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
0
votes
1answer
52 views
Can one edit an ArcSDE Oracle spatial view?
By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned.
I really had it in my head that you can, as long as the objectid column is included in ...
3
votes
1answer
52 views
Synchronizing Changes From File Geodatabase to SDE Geodatabase
I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
3
votes
1answer
71 views
it is possible to undo and redo outside an edit session in Arcobjects?
I would like to know if it is possible to undo and redo changes outside of edit session, i'm working on an ArcSDE versioned 10.1 database?
if yes how i could do it in Arcobjects .NET .
Any help ...
1
vote
0answers
132 views
Is there workaround for very slow ArcSDE 10.1 editing
I'm suffering from very slow editing in SDE from an Arcgis engine application, the SDE database is in local so there's no network issues. but i still ignore the reasons neither how to solve this ...
1
vote
0answers
43 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) ...
2
votes
2answers
122 views
ArcGIS Server Error: “Feature service requires a registered database”
I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
6
votes
1answer
106 views
When to use multiple geodatabases?
I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
1
vote
1answer
71 views
Database Connections folder is empty when viewed with ArcGIS tool
I'm trying to create an ArcGIS tool which accepts an SDE connection file as an input. I made a new interface with an input parameter and set the type to Database Connections. When I open the tool and ...
10
votes
1answer
198 views
Steps for creating an online webmap with editable features using ArcGIS Server/SDE and SQL Server?
EDIT/UPDATE: I'm adding a bounty to this in hopes of obtaining a step-by-step guide to creating an online map with feature editing using the ArcGIS Flex API, SQL Server Express and ArcGIS Server 10.1. ...
2
votes
0answers
66 views
Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET
I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2.
We have a feature class ...
0
votes
0answers
39 views
How to add a column to table with sdelayer command?
I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
2
votes
1answer
50 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
113 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 ...
0
votes
1answer
42 views
What is the process to automatically change a field entry in a related table when entering it in a feature class?
So, I am working to try and develop a code or process that I can run that will allow me to automatically change an XY field in a related table when I change an associated XY field. Let me explain our ...
2
votes
1answer
54 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, ...
1
vote
1answer
39 views
Filter ArcSDE layers of the TOC into a combobox
I've a list of layers of the current workspace in a combobox, but I want to list only the layers of the ArcSDE Connection, not the others I've in the TOC.
How can I filter the name of this layers?
2
votes
1answer
67 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 ...
3
votes
1answer
62 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 ...
0
votes
2answers
61 views
Missing options on database connection in ArcCatalog
I have 2 databases on the same server. I can add connections to them both without a hitch in ArcCatalog (or catalog in ArcMap). The problem is that I seem to be losing some options when right clicking ...
0
votes
0answers
32 views
SDE Connection raise exception
I am supporting a .NET code that is running on ArcGIS Server 10.1, and communicating with ArcSDE Application Server 9.3
There is part of the code that is doing long loop.
And when it comes back to ...
0
votes
0answers
73 views
SDE connection error
In my company we have a number of databases in an MS SQL instance. This morning only 1 database i generating following error when I try to do a direct-connect in ArcCatalog:
Failed to connect to ...
3
votes
1answer
135 views
Arcpy does not execute “CopyFeatures_Management” to write a featureclass to an ArcSDE database
I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of ...
6
votes
1answer
85 views
How to undo ArcGIS “Move Edits to Base” mistake?
I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
1
vote
1answer
159 views
How to manage user privilege on layers to Arcgis 10 Desktop?
Problem:
I am a Computer Analyst on a town hall.
Here we have the sector A and B. Both work in ArcGIS 10 Desktop.
The sector A has granted to access/edit everything. The sector A has all the ...
2
votes
2answers
232 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
1answer
98 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 ...
1
vote
1answer
72 views
Why don't I see ArcSDE service in the Windows services?
I've been thrown into learning how ArcSDE and ArcServer work.
I'm trying to start a service using the default esri_sde on port 5151.
I put it in both the ArcSDE and windows service files.
When I go ...
1
vote
1answer
59 views
“SDE error 6” when publishing GeoServer layer
I have successfully created an ArcSDE datastore in GeoServer 2.2.4. When I try to publish a feature class in the SDE database, the "Compute from data" link returns nothing, and the "Compute from ...
1
vote
0answers
43 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 ...
6
votes
2answers
128 views
How to Export a Personal Geodatabase to ArcSDE
I want to copy/export my personal geodatabase which consists of feature datasets, relationship class etc to an Enterprise geodatabase. What would be the best approach?
0
votes
0answers
83 views
+50
Configuring image popups in a Silverlight application
My Silverlight application contains a points layer which contains paths to a folder of geotagged photos. These points were generated using the GeoTagged Photos to Points tool. I chose not to import ...
1
vote
2answers
48 views
Identifying the Primary Key field of the Layer in ArcGIS Server
I need to get the primary key column of the Particular layer added in the Map.
Usually 'FID' be found for a Shapefile Layer Source and OBJECTID found for a SDE source layer.
Is there any way to ...
1
vote
0answers
69 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 ...
3
votes
1answer
73 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 ...
