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.
6
votes
1answer
825 views
Postgresql for Qgis and Arcgis - What to do/What not to do
Is it possible to use postgresql with QGIS and ArcGIS? One database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know that I ...
7
votes
3answers
294 views
ArcSDE - use native geometry types for later migration away from SDE?
Background: We have a non-spatial reporting web application with a SQL Server backend. We would like to add a spatial component to this application: serve up some basemaps, serve up points and ...
1
vote
0answers
110 views
Replicate ESRI ArcSDE Geodatabases in Google Earth Enterprise Fusion
Can we setup an automatic replication of an ArcSDE geodatabase into a Google Earth Enterprise Fusion periodically - weekly/monthly? The replication needs to be performed one way - from ArcSDE to ...
6
votes
3answers
868 views
Python script - how to avoid exclusive schema lock error?
I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only".
My problem is that I can't avoid that these ...
0
votes
0answers
97 views
Problem with connecting QGIS to ArcSDE
I am working with ArcSDE (9.3.1) data in QGIS(1.7.4) added via a .vrt file. The geometry displays no problem and appears to function normally.
The expected field names appear in the attribute table ...
0
votes
0answers
76 views
Best practice for using users loading data into ArcMap from SDE [closed]
What is the best way for GIS users (i.e. consumers of data not power users) to load data into ArcMap from SDE?
A read-only file location that stores layer files that point to the SDE data?
Use an ...
1
vote
0answers
42 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
238 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 ...
-4
votes
1answer
484 views
How to script a csv to file geodatabase tool?
I have many separate field data files in CSV format and I wish to automatically convert these CSV files into a geodatabase to be able to load them into a schema I created for them in my new ArcSDE ...
9
votes
2answers
343 views
Migration from ArcSDE (SQL Server) to PostGIS (PostgreSQL)
We've got all the geospatial information of our company within an ArcSDE Database (over SQL Server):
points (locations of the antennas),
lines (elevation, rivers),
polygons (protected areas, ...
6
votes
3answers
1k views
How to delete feature class features faster (ArcPy)
I have written this script that recurses through all feature classes in a given set of feature datasets and deletes all their features. It appears to do the job but it runs pretty slowly. Is there ...
2
votes
1answer
807 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 ...
3
votes
1answer
584 views
Error importing XML workspace document to file geodatabase
Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
2
votes
1answer
86 views
Finding the Default version in a large linage tree
I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
3
votes
2answers
619 views
Using PHP with a web application?
I have been working on creating a web mapping application using ArcServer 10 and the JavaScript API. Recently I was told that queries need to be run using PHP due to prior work by another team. The ...
4
votes
1answer
290 views
SDE analysis - file locking logistics - ArcSDE 10 on MSSQL
I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks.
I have a interpretable ...
2
votes
0answers
213 views
How to get WKT from SHAPE column in the ArcSDE geodatabase?
I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
2answers
193 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 ...
4
votes
2answers
160 views
Calculating the space a feature class will use in ArcSDE?
Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
1
vote
1answer
1k views
ArcSDE error: “Maximum number of connections to instance exceeded ”
I have an ArcSDE error: " *Failed to connect to database. Maximum number of connections to instance exceeded "
Did what ESRI recommended :"
Check the value set for the CONNECTIONS parameter in ...
0
votes
1answer
260 views
Reconcile and post versions
I want to know if we can post the versions based on events through coding.
How we do batch reconcile and post through c# code. Is it possible for automatic replication also?
4
votes
0answers
246 views
Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase
I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
1
vote
0answers
41 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#.
3
votes
1answer
482 views
ArcSDE desktop license
I am using the ArcGISDesktop student license. I want to work on versioning and geodatabase replication.
Is it possible to set up ArcSDE with the same license and work on versioning and replication?
1
vote
1answer
133 views
Versioning geodatabases
I am trying to reconcile and post the edits. I would like to know if I can post the versions to two different parents. Could some one help me with c# coding on how to do this.
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
251 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 ...
1
vote
1answer
239 views
Delta tables for versioning
I am doing versioning of sde. I have done this using the ArcMap. I want to look at the delta tables in sql server.
In sql, I don't see the delta tables. I just see few tables named as a144.
How do I ...
1
vote
1answer
187 views
ArcSDE for ArcGIS Desktop
I have ArcGIS desktop (info) license. I want to know if I can configure SDE, where in I can work with versioning of geodatabases.
3
votes
1answer
413 views
How can I create an empty feature class in a file geodatabase based on the schema of an SDE feature class?
I have 150+ feature classes in SDE for which I need to create an empty feature class in a file geodatabase. For these feature classes I need to import the attributes and the name of the feature class ...
2
votes
1answer
111 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 ...
1
vote
0answers
72 views
Storing Shapes in database
What is more effective? Storing Shapes as shape column (http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/topology_basics.htm) in database? Or maybe store shapes in seperate tables ...
2
votes
0answers
56 views
ArcSDE Feature View in a GeoDatabase other than the Feature's Database
here is the problem I have been struggling with:
We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
1
vote
1answer
637 views
Delete SDE feature class features with ArcPy
I'm working on a script that will empty my SDE database of all data. How would I go about deleting features from feature classes using ArcPy?
I have an SDE connection created with a user that should ...
2
votes
0answers
228 views
Can a spatial View in ArcSDE be viewed in ArcCatalog?
Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table?
I have a feature class table and an attribute table ...
1
vote
1answer
202 views
How to run “sdetable register” command in SQL Server?
I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2.
I tried to run the ...
1
vote
1answer
182 views
How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?
I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
1
vote
0answers
213 views
ArcSDE geodatabase for non-spatial data
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 ...
2
votes
0answers
155 views
Importing Rasters to ArcSDE 9.3.1 using sderaster
OK, I am trying to import a raster to 11g using the sderaster command. It is a stand alone jpg with a world file associated, and pyramids.
Am I right in assuming I cannot import a JPG, I can only ...
6
votes
2answers
355 views
Oracle / SDE: ST_GEOMETRY or SDE Compressed Binary
I read data from a SDE database (Oracle) directly. How do I know, which format is used to store the geometry data? Do I have to check the DataType for the geometry column or is this information ...
5
votes
1answer
524 views
Reset Object ID After Truncating Table In SQL Server
I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
2
votes
3answers
540 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 ...
1
vote
2answers
414 views
Select and highlight features
I have 2 ESRI feature layers on my map; points and polylines. I can select them just fine either by rectangle or polygon. What I am missing is how to highlight (larger size and different color) the ...
3
votes
0answers
152 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
155 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 ...
5
votes
2answers
476 views
Options for ArcGIS Server and ArcSDE Hosting
I know this was partially address here, but it was not specific to ESRI products. I want to find some place to create and host map services with ArcGIS Server and ArcSDE. ESRI cloud options are bit ...
5
votes
3answers
337 views
How not to Copy Features when too many would be output?
This question has already been posed to the ArcGIS Geoprocessing forum but I have had no responses there.
I have a 3.5 million polygon layer (cadastre) stored in Oracle via ArcSDE. I use a polygon ...
1
vote
1answer
221 views
ArcMap - ODBC connection to SDE table shows an old version?
I use an ODBC connection to an SDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL SDE server and the connection info matches what I ...
2
votes
2answers
327 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 ...
4
votes
1answer
956 views
Registering SQL Spatial View in ArcSDE and updating Row_ID
I am having issues registering an inner join SQL view with a spatial column in ArcSDE. Any help would be much appreciated.
Here is the background info:
ArcSDE 10, SQL Server Enterprise 2008 R2, SQL ...
