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.
0
votes
1answer
26 views
Understanding ArcGIS Server connection types
Being relatively new to ESRI ArcGIS Server I have a question regarding the storage of ESRI SDE Databases - AGS 10.0 Enterprise and ArcSDE 9.3.
Firstly the naming of the whole structure gets ...
0
votes
1answer
26 views
arcpy update cursor: can't connect to a database table
I am using updateCursor to retrieve some rows from a non spatial table using a connection of type "Spatial Database Connection" (That creates a .sde file) from ArcCatalog.
However, it doesn't work, ...
3
votes
2answers
28 views
ArcSDE command registration issues
I have an ArcSDE 10.0 enabled SQL Server 2008 R2 database on a development server. We are using TeamCity to run continual deployment to this development server, which runs through the following steps:
...
0
votes
0answers
48 views
Export From PGDB to ArcSde Using C#
I need help exporting a personal geodatabase Feature Class to an ArcSDE geodatabase using C# ArcObjects with ArcGIS 9.3. I just want to replicate the tool Feature Class to Feature Class ...
2
votes
1answer
47 views
Installing ArcGIS 10.1 on SQL Server 2008 R2 Cluster
We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the ...
1
vote
1answer
49 views
Trigger a python script to run after a row is added to the feature class
I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
1
vote
1answer
25 views
Add features to main SDE Table with geotools
Sorry for my english, I hope you can understand ;)
I'am using geotools 8.4 version. I try to copy all features from SDE Table(TEST.DBO.MM_SOURCE) to another SDE Table(TEST.DBO.MM_TEST). All features ...
17
votes
2answers
473 views
Which geodatabase type is most appropriate for both open source and ESRI use?
Main Question: Is there a geodatabase type that seamlessly works with both ESRI and open source products?
Details: My company currently passes around geodata in various vector and raster file ...
3
votes
2answers
52 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
103 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
33 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
25 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
11 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
54 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 ...
3
votes
1answer
65 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
43 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 ...
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 ...
3
votes
1answer
64 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
53 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
88 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 ...
3
votes
2answers
63 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 ...
0
votes
1answer
33 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
81 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
115 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
69 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
66 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
76 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 ...
7
votes
1answer
343 views
Is there workaround for very slow ArcSDE 10.1 data display
I'm suffering from very slow viewing data of and ArcSDE database from an Arcgis engine application, the SDE database is in localhost so there's no network issues. but i still don't know the reasons ...
1
vote
0answers
58 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
192 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
111 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
82 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
216 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
94 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
35 views
ESRI AddFeatures call on rest endpoint with attributes
I can add a line feature via the rest endpoint with my hand crafted call from C#. However, if i add any attributes to the call it will fail and say unable to perform operation.
All of the fields in ...
1
vote
0answers
54 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
3answers
62 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
134 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
45 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
58 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
45 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
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 ...
3
votes
1answer
72 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
67 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
35 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
85 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
162 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
102 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
222 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 ...
