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.
1
vote
1answer
207 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
186 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
224 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
162 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
370 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
561 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
567 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
465 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
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 ...
5
votes
2answers
484 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
348 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
228 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
358 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
987 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 ...
1
vote
1answer
153 views
ArcToolbox Create Replica tool advanced options
I am trying to create a two-way Replica of my SDE database to another SDE database in ArcGIS 10.0
If I use the Create Replica wizard from the 'Distributed Geodatabase' toolbar in ArcMap I am able to ...
6
votes
2answers
904 views
In a versioned geodatabase, what impact do delta tables and the state tree have on query performance?
We have a versioned arcsde geodatabase (arcgis 9.3.1 on oracle 10g) with a fairly complex data model that includes about 100 featureclasses and non spatial tables, a geometric network and many ...
1
vote
0answers
200 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 ...
4
votes
2answers
816 views
What is the best way to migrate an SDE Database
We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database.
ArcSDE 9.3.1 on Linux SLES 4
Now, what is the best way to do ...
2
votes
1answer
161 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.
7
votes
3answers
1k views
ArcSDE - Is there an automated way of releasing all layers locks?
We have an issue where users do not close ArcGIS and layers get locked, and sometimes this affects our nightly updates for some of the layers. I know you can individually remove a lock using the ...
1
vote
0answers
154 views
ArcObjects .NET 9.3 upgrade to 10 breaks IRasterDataset.Copy(…) code
I have to upgrade an application from ArcObjects 9.3 (C# .NET) to 10. Unfortunately, there seems to be some incompatibility regarding the IRasterDataset.Copy method. The following code worked fine in ...
5
votes
2answers
335 views
What does it mean to QI and how is it done?
I'm new to Esri's Arc* interfaces, and trying to figure out how to register an existing table using the ArcObjects API. The following question answers this to some extent:
Is there any way to write a ...
3
votes
1answer
349 views
Extract data from QueryLayer to Shapefile
I have a QueryLayer that I need to export as a shape file.
This was previously implemented as an ArcSDE feature class which we converted to a QueryLayer (running against SQLServer) in order to have ...
4
votes
2answers
889 views
Adding data from a SQL Server Spatial database to ArcMap or ArcEngine application with ArcObjects for better performance
I have an ArcSDE geodatabase stored in MS SQL Server 2008 R2. The datasets in this geodatabase range from 10 record to 7 million records and there is a mixture of tables and spatial datasets (SQL ...
4
votes
2answers
641 views
Where are imported Mosaic Dataset images stored on ArcSDE server?
I am trying to learn more about Mosaic Datasets and specifically how they interact with ArcSDE (SQL Server 2008). I read in How raster data is stored in a geodatabase that "...In the case of the ...
1
vote
1answer
343 views
Copying and renaming files on SDE connection
I have a script that renames and copies files (feature classes) on an SDE connection. This script works just fine if the feature class name does not start with an 'S'. If the feature class name does ...
4
votes
5answers
1k views
Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?
I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system.
I need an exact copy of the ...
1
vote
1answer
646 views
Add Spatial Database Connection fails
Has anyone else come across this problem? I created a Database Server (SQL Express 2008.) I created a "New GeoDatabase..." I double-click on "Add Spatial Database Connection." I fill out the dialog ...
4
votes
2answers
443 views
How to allow more polyline vertices for a ST_GEOMETRY in Oracle/SDE?
I'm receiving an error writing geometry (in ArcObjects) that has a large number of vertices (around 900). So big, but not ridiculously big. I would expect this to be no problem and I don't recall ...
2
votes
3answers
603 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)?
1
vote
0answers
77 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?
6
votes
2answers
664 views
How are Class Extensions associated with a Feature Class in ArcGIS v10?
In ArcGIS 9.x if a Feature Class is registered with a Class Extension the CLSID of the extension is recorded in a table in the sde schema called sde.GDB_OBJECTCLASSES (EXTCLSID field).
However in ...
13
votes
2answers
200 views
Is there a good way to get a diff between an old and a new version of an SDE database?
Is there a tool or a process that can reveal changes made to the schema of an SDE database when comparing two versions of the same database hosted on different servers?
I have an old database that ...
3
votes
1answer
155 views
SDE Topology dirty areas don't go away
Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...
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 ...
6
votes
1answer
406 views
SQL Server Relationships in ArcSDE
I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
5
votes
1answer
378 views
How to check whether a fc is registered as versioned or not using python
How can I check whether or not a feature class is versioned using python? I'm trying to register feature classes using a python script. Before I do this I need to check whether a feature class is ...
6
votes
2answers
401 views
How is the default label field chosen by ArcMap?
I have 2 questions:
I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
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 ...
5
votes
3answers
4k views
Define Workspace for SDE Connection in Python
How do we define SDE Connection for workspace in Python Scripting. Its urgent please need your suggestion. Thanks
5
votes
2answers
349 views
How to convert high precision dataset to low precision
A high precision dataset was loaded from a file geodatabase into arcsde 9.3.1. The dataload was achieved by copy/paste in ArcCatalog.
A custom tool (arcobjects) that extracts from the dataset to a ...
4
votes
1answer
180 views
Migrating Feature Datasets from ArcSDE to postgis
I am currently planning the migration of a database from ArcSDE/ Arcmap to postgis / Qgis. The data is stored in raster catalogues and feature datasets. Is there an equivalent to feature datasets ...
6
votes
1answer
184 views
Automated geodatabase replication with offline editors
I would like to design an application that would use an SDE database with simple features and a geometric network. That geodatabase would then be replicated out to any number of personal geodatabases ...
4
votes
2answers
308 views
ArcObjects ISQLSyntax with Oracle DB esriSQL_DelimitedIdentifierPrefix issue
New to stack exchange, heading over from the esri forums, it is great!
I am trying to produce a query that I can use across all workspaces, naturally using ISQLSyntax. The problem I'm having is that ...
6
votes
1answer
315 views
Can I update features in an SDE database from python without using an ArcEditor License?
I have a non spatial data set that I would like to keep sync'ed in SDE as a spatial set. So I would like to be able to insert, update, and delete without using one of my two ArcEditor licenses since ...
4
votes
1answer
304 views
DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset
I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format:
id pointid sensor measdatetime measvalue
50345 500 ...
7
votes
2answers
282 views
Very slow connections to ArcSDE with over 20,000 datasets
I have a problem with ArcSDE that I have never come accross before and I was wondering if anyone could shed any light on this problem.
Problem ArcSDE 9.3.1:
Connnecting to an ArcSDE instance ...
4
votes
1answer
115 views
Attribute Indexes ArcSDE 9.3.1 for Attribute Joins on GUID field types
I create my joins on primary/foreign keys that are guids...I don't seem to be able to create an index on this field in my target table. After joining to this table it takes 4 minutes to open the ...
0
votes
0answers
448 views
ARCSDE; creating new geodatabase in database servers in arccatalog
I use arcsde 9.3. I want to access a geodatabase on mobile. when I want to create new geodatabase in the list of database servers in arccatalog the error is "error creating geodatabase no arcsde ...
