Rather than use this version tag consider using arcsde and arcgis-10.0 tags

learn more… | top users | synonyms

0
votes
1answer
27 views

arcpy.ListDatasets() returns emtpy list

I'm having trouble getting the ListDatasets (or any of the list functions) to return anything but an empty list when pointed at our SDE geodatabase, but the same code works for a file geodatabase. I ...
0
votes
0answers
26 views

NextBuffer operation takes a long time when there are no rows in a table

We're trying to get data from a table which contains no rows. The query runs fast, but the SDE gets stuck on NextBuffer command. Some code that we're using: IQueryName2 queryName2 = (IQueryName2)new ...
4
votes
3answers
182 views

How to number polygons according to their spatial relationships?

I have, for example, this layer in postgresql (polygons): table : poly (objectid: integer, num: integer, shape: geometry) I want to enumerate the polygons from left to right and top to bottom ...
1
vote
2answers
195 views

How to Register a Spatial View when SDE is direct connect only?

I have an ArcSDE 10.0 set up with MS SQL 2008 R2 Database, on direct connect. There is no service running, nor installed. I have created a spatial view built on a couple of tables. I have followed ...
2
votes
1answer
103 views

Renaming shapefiles with prefix while running arcpy.FeatureClassToGeodatabase

I'm fairly new to the arcpy world. I am trying to create a script in 10.0 that will load a dataset (file geodatabase) into ArcSDE and rename the feature classes with a prefix, i.e. San_Diego_Bay -> ...
1
vote
0answers
72 views

joins relates in arcgis 10 using vb.net

i have Tow tables in geodatabase : parcel and person 1 or + parcel can have 1 or + person (relationship is pll_person) using vb.net i can display all the parcel with annotation "id" what i want ...
3
votes
1answer
125 views

What is the difference between registering with ArcSDE and registering with Geodatabase?

As I understand it : Registering with ArcSDE: gives the possibility to ArcGIS to recognize spatial data stored in a database Registering with Geodatabase: makes it possible for data to participate in ...
1
vote
0answers
170 views

How can I import data from an Oracle datapump into an empty Oracle SDE Geodatabase?

I have a SDE Geodatabase that contains empty layers created using ArcCatalog. I'd like to import data into those layers from a datapump of an Oracle database that has the same structure as the empty ...
0
votes
1answer
85 views

Is it possible to create an “Empty” version of an SDE database?

Is it possible to create an "Empty" version of an SDE database? I have a large default SDE database that I would like to create an empty version for a new project. By "Empty" version I am referring ...
1
vote
1answer
410 views

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
3
votes
1answer
133 views

Problem installing ArcSDE engine plugin for Eclipse

I'm looking for the following jars for the ArcSDE API: jsde_sdk.jar jpe_sdk.jar concurrent.jar icu4_3_2.jar thanks to this answer I've found that they can be gotten installing the ArcSDE engine ...
4
votes
2answers
227 views

ArcSDE Archiving - H tables

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
3
votes
0answers
130 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? ...
2
votes
0answers
71 views

Problem with representation symbology, when copying from SDE 9.3 to 10

We are having problems with our representations when copying from an ArcGIS 9.3 database to a 10.0. Representation symbologies with dash patterns (dots, dotted lines etc.) are reset to default ...
4
votes
1answer
151 views

How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
1
vote
3answers
509 views

Convert Oracle schema to GeoDatabase using Direct Connect only

Either this is a gap in the documentation or I'm really missing something! I know that I can direct connect to an SDE GeoDatabase without needing ArcSDE to be installed on the database server, but I ...
3
votes
1answer
168 views

How can I use the multiversion view trigger to maintain a unique id in ArcMap?

I'm trying to identify the best way to automatically maintain a unique id column in Oracle ArcSDE. I don't want to use a class extension, since I've multiple third party users of the data and it's ...
3
votes
1answer
984 views

Where is the connection file used to connect to ArcSDE 10?

In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008? Some non administrative users are hooking up to SDE as the user 'sde' with db ...
5
votes
2answers
698 views

Permanently replace/update SDE server + service in each SDE Layer in an MXD

Using the mxd.findAndReplaceWorkspacePaths method, if and MXD is updated and the path the the .sde connection file moves again all of the data sources will break again. Is there a method to ...
3
votes
1answer
199 views

Has anyone been successful using the CAST function in ArcMap 10 with ArcSDE 10

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
1
vote
0answers
42 views

ArcSDE database management - options manage outages to make updates

I would like options to manage ArcSDE outages for making updates to schema, which I am not able to do when users are just reading the feature classes. I would like to not have to stay late to get ...
3
votes
1answer
219 views

TO_DATE ORACLE SDE failing

I'm trying to use TO_DATE to query an Oracle SDE dataset. It's not working in the javascript API application so I tried to query the rest end point directly and I get the error: "Unable to perform ...
2
votes
1answer
106 views

ArcSDE 10.0 - Reconcile Post

Is it possible to edit the same feature in sde in two different versions and rec/post version A's edits to the parent. And then rec/post version B's edits of same feature. And then see which vertex ...
2
votes
1answer
590 views

Using primary keys with SDE (Oracle) best practice?

Is it possible, more advisable to assign a primary key to the OBJECTID column in a featureclass in SDE. I am using Oracle and some of my flat tables (junction tables) need to SEE a primary key in the ...
3
votes
1answer
259 views

deleted features not synchronizing in one-way geodatabase replication (ESRI)

I am testing three one way (SDE -> file GDB) replicas. Each replica is derived from a layer created by selection by location from a citywide road dataset, so that each of the three layers is ...
3
votes
1answer
299 views

ARCSDE for Oracle 11g Layer not found (-20)

I am using ARCSDE for Oracle 11g, with Oracle spatial database. I use the sdelayer command ot register my feature class. Surprisingly I get this error of Layer not found(-20) error. The table does ...
5
votes
1answer
230 views

Changes in synchronized replica not shown in ArcMap or ArcCatalog without refreshing

I am synchronizing a one-way replica in ArcEditor using Python. I tried adding RefreshActiveView and RefreshCatalog to the code, but I still need to refresh the synchronized database to see the ...
4
votes
2answers
473 views

Unable to create a geometric network in a PostgreSQL Spatial Database Connection

I've created in ArcCatalog a Spatial Database Connection to an PostgreSQL database server. I've imported there all my data (from a local hard drive) and now I want to edit them. But apparently I ...
2
votes
1answer
672 views

create SDE feature class in MS SQL Server

Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so : I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I ...
3
votes
3answers
599 views

Topology error in ArcGIS for SDE 10. “Cannot create topology”

When trying to create a topology for a polygon feature class in ArcSDE. I right click the feature dataset that the feature class resides and try to create a new topology. I get an error saying, "The ...
0
votes
1answer
431 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?
5
votes
3answers
221 views

What is the best way to search tens of feature datasets for a feature classes in sde and other field filters in ArcCatalog?

I have ~30 feature datasets and ~100 feature classes spread throughout the feature datasets. I would like to search for a feature class by name among the feature datasets. Also, I would like to ...
1
vote
1answer
599 views

Use of esriFieldTypeDate field in Add Features REST service

I need to use Add Features REST service to add a new record to a table in a SDE database. One of the field is type of esriFieldTypeDate, but I don't know how to populate this field in JSON script. An ...
1
vote
1answer
288 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
381 views

How create bulk field aliases for several layers within the same feature using in arcgis-10.0 using python?

I have an arcmap with ~200 layers from the same sde feature class. After I finished adding all the layers it was brought to my attention that we need to add field alaises for the attribute table. ...
0
votes
1answer
485 views

How do I tell my geoprocessing service which sde feature class to update

I want to have a geoprocessing service update sde. I am getting an I/O Error saying data doesn't exist. I imagine because the connection file (copied from my ArcCatalog folder) I placed next to the ...
1
vote
0answers
165 views

create relationship class in SDE

I can not seem to create a relationship class in SDE, or at least one that works. I am succseful in creating the class however arcMap does not recongnize it (there are no related tables shown) and if ...
0
votes
1answer
114 views

Parsing an entire SDE database searching for a field for export

I'm wanting to parse through and entire SDE database (feature dataset, features classes, tables, everything...) searching for a field (compkey) and export the numbers to a txt file.
0
votes
2answers
748 views

Is it possible to upgrade plain database to esri SDE geodatabase in ArcGIS 10.0?

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is). I'd like to convert them to geodatabases, first that 'MS SQL Server 2008', then Oracle. So, leave Oracle for a ...
6
votes
1answer
843 views

ArcSDE 10 on SQL Server 2008 R2 Cluster 64bit or 32bit

I am looking for Tips an Tricks on installing ArcSDE on SQL Server 2008 R2 Cluster. Our IT division would like to have all the databases on their new 2008 cluster. I've only done standard install ...
3
votes
3answers
534 views

merging data in ArcSDE

I need some suggestions/inspiration for a problem we have. The problem: We have an ArcSDE master GIS database. We will edit this data almost exclusively outside of ArcGIS and outside of ArcSDE. In ...
4
votes
1answer
1k 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 ...
2
votes
2answers
163 views

Spatial search to find featureclasses in SDE

Is there a way to find all featureclasses within SDE that fall within a spatial search e.g a user draws a rectangle on screen over a map of the world say. (I would like to do this progrmammatically, ...