Tagged Questions

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.

learn more… | top users | synonyms (1)

1
vote
1answer
614 views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
12
votes
7answers
1k views

How to batch synchronize data from ArcSDE to PostGIS?

Its been suggested that i ask this question again, but perhaps worded differently than how to Bulk load multiple shapefiles into PostGIS. I'm new to postgis and sql but i want to use postgis as a ...
1
vote
0answers
897 views

Edit SDE table with ArcObjects - continued [closed]

Update So, I believe I'm getting closer to being able to edit my sde table, however now I'm getting stuck on this line: Dim updateCursor As ICursor = table2.Update(Nothing, True) With this ...
4
votes
1answer
421 views

Edit SDE table with ArcObjects

The link below provides a code snippet for editing an SDE table with ArcObjects. Are there any other or newer code examples out there of how to edit a SDE table by using ArcObjects? Edit SDE ...
5
votes
2answers
557 views

ArcSDE Geodatabase MS SQL Server restore of .bak file

If we have ArcSDE 9.3.1 running on MSSQL Server 2008 R2 Enterprise and we do a full backup of a geodatabase. Then I try to restore the .bak file to a MSSQL Server 2008 R2 Express on a machine that ...
2
votes
1answer
538 views

How to solve an “Error found when retrieving conflicts.” error in ArcMap?

I uncovered this error when testing ArcMap 10 SP2 for a customer: This occurs when the conflict is detected--ArcMap is attempting to show the conflicts window but fails. I get this error on all ...
2
votes
2answers
784 views

ArcPy Changing Spatial Database Connection

hi we have conveyed our some servers which has ArcGIS application and SDE on it to another server and its ip has changed. now when i want to open my .mxd file it tries to connect remote SDE with old ...
2
votes
1answer
781 views

ArcSde Oracle Maximum number of grids per feature (8000)

I have a problem with the import of data (lines) to ArcSde Oracle. 2011-07-14 12:10:04| 22.9| 0.0|ERROR |Error while executing stream insert operation for table 'CHEMN'.:SDE_ERROR_CODE(-51) ...
0
votes
1answer
369 views

FME ArcSDE… the scale is very small

I have a problem with ArcSde and FME. I try to import some line features to ArcSDE Oracle. When I start the script in FME, I have some errors: impossible to insert linestring in ArcSde because the ...
1
vote
3answers
326 views

Editing non-nullable fields of ArcSDE layers in ArcMap

I'm using ArcSDE layer in my map project in ArcMap 10. Some of the fields of this layer allow null and some don't. I can't edit the non-nullable ones, neither programmatically (IField.Editable is ...
1
vote
4answers
934 views

error in arcsde service

I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database SDE not Running on Server Then I Check the Service esri_sde it has ...
3
votes
1answer
983 views

How do I create a functional spatial index of an ST_Geometry Feature Class in Oracle/SDE?

Copied an SDE feature class (with blob(sdebinary(?) geom) into the same SDE GDB (Oracle 11g/SDE 9.3.1) but with the ST_geometry configuration keyword. I can see that the feature class was created, ...
5
votes
1answer
989 views

ArcObjects: modifying feature field value

I'm developing an ArcMap extension and looking for a way to change feature attributes knowing its feature class and OID (and, presumably, everything else that there is in IFeature). All layers use ...
2
votes
1answer
332 views

ArcSDE 10 FeatureLayer is read only, FeatureTypes property is null, not sure why

I have a WPF FeatureLayer backed by an ArcSDE feature class that I hope to use for editing. After the layer is done initializing its readOnly property is true, I think that this points to some problem ...
7
votes
3answers
287 views

Changing a coded Domain to no codes

If we have coded domains in the geodatabase model, what are any disadvantages to changing the codes to the Description. For example: Existing Coded Domain: Code, Description 1, Single Family ...
8
votes
7answers
3k views

Register SDE view and Layer

I'm building simple views against an ArcSDE Oracle RAC 10g. My SHAPE columns are of SDO_GEOMETRY datatype. ArcSDE 9.3.1. I have several point tables, with the following outline: ID (Guid) Name ...
1
vote
2answers
1k views

How do I use Oracle Locator's mdsys.sdo_geometry with ArcSDE?

I'm using the Oracle Locator MDSYS.SDO_Geometry type to store my spatial information and then accessing it through ArcSDE. I'm confused about how the precision component of the metadata is used and ...
13
votes
3answers
2k views

ArcObjects: Memory leak in IFeatureClass.Search (only on SDE with direct connect)

UPDATE 6/30/11: ESRI Support say they have reproduced the issue and have opened a bug report (NIM070156). I have determined that there is a memory leak (in unmanaged heap memory) that occurs when a ...
3
votes
3answers
201 views

Is there any way to write a snipet of code with function of “SDELayer -o register” command

I try to create a geodatabase using some SQL command and then register some tables of it with SDE. I create an empty geodatabase using sde post installation and then create tables and other database ...
2
votes
1answer
171 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...
2
votes
1answer
446 views

How to insert DateTime null using IRowBuffer

I am using IRowBuffer/IFeatureBuffer to insert fields to SQL Server 2008 DB. When inserting a field I am using: public void SetValue(IRowBuffer buffer, string field, object value) { int ...
2
votes
2answers
231 views

How to perform a “vertical integration” using FME?

I am not a GIS person, but I need to understand an aspect of the project I'm working on. We are taking an ArcSDE layer, and importing it into FME. I now need to do some checking of the data. In ...
9
votes
1answer
533 views

Large Scale Geocoding and Processing in ESRI

Ok, so I guess this kind of a informal query/survey about how big a datasets you are using in your ESRI worlds... I am building and maintaining a statewide dataset, where I have to process down to the ...
2
votes
3answers
541 views

Definition Query to Python script on Oracle 9i and ArcGIS 9.3.1

SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS IS NULL OR SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS = 976 The above is my def query in ArcMap against ArcSDE ...
1
vote
2answers
398 views

Access Feature Classes on Multiple Database Schemas with ArcSDE

I am using ArcObjects to access a GeoDatabase that was set up with ArcSDE 10 and SQL Server 2008 R2. In this particular case, I have some tables set up on alternate schemas (this is to replicate a ...
1
vote
2answers
155 views

Associating data in a form with an SDE Layer

I was wondering if there was a way to associate/persist some data about an SDE featureclass when viewing via ArcCatalog. I know you can have metadata - but I don't want to use that, and I'm pretty ...
4
votes
2answers
605 views

Update ArcMap links to ArcSDE Geodatabase features

I've seen questions about attemting to repair a .mxd file with broken links. What I would like to do is get ahead of this issue and "fix" it before it becomes a problem. I have my data in an ArcSDE ...
6
votes
1answer
564 views

ArcGIS 10 Linux experience

We have ArcGIS 10 installed on a nice clean Linux box. We have developed scripts to run on the Windows desktop development machines, and modified them to run on Linux. Now, if we run the scripts on ...
1
vote
1answer
283 views

How to execute gp.execute ArcSDE tool in C#

So I created an ArcGIS 10 toolbox in ArcSDE and added a tool to it. There are enough examples out there on how to execute a tool.tbx that resides outside SDE or GeoDB. But in C#, how do you use ...
3
votes
2answers
441 views

ArcSDE database connection strings for ArcCatalog

Anyone know where the Database Connection strings are located in Program Files for ArcCatalog? I have all my Database Connection strings fixed and all my scripts use them. My computer went down and ...
1
vote
3answers
741 views

ArcSDE & Oracle & Database Model — Best diagram the system

Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo ...
3
votes
3answers
878 views

How to avoid dbo.arcsde LOCK issue while exporting to ArcSDE

I had a spatial db connection open in arcmap. While exporting to SDE with a console app I get an error in the console: Lock request conflicts with an established lock [DBO]. Does this just mean ...
0
votes
1answer
835 views

How to safely replace ArcGIS SDE feature classes using transactions

I am using C#, ArcGIS Server 10, MS-SQL Server 2008, and I want to replace an ArcGIS SDE feature class inside of a transaction. After the deletion of the feature class, I have to create a new one with ...
2
votes
1answer
218 views

arcgis10: export eventlayer (from querylayer) to ArcSDE

I am not using arcmap but I am creating a arcgis desktop console app. I am pulling an external SQL table in as a querylayer. This table has lat & long so I created an eventlayer (or ...
1
vote
1answer
135 views

Enable Archiving failing on sde 9.3.1 and MS SQL Server 2008

I am trying to enable archiving and am getting this error: Violation of PRIMARY KEY constraint 'archives_pk'. Cannot insert duplicate key in object 'dbo.SDE_archives'. Is this saying that there is ...
4
votes
4answers
294 views

Record Date and User for an edited feature

The client has a Feature Class in SDE 9.3.1. When a feature in the feature class is edited the client wants to automatically record the date/time and who edited it in the feature class attributes. ...
5
votes
2answers
231 views

ArcSDE recently modified geometries

ArcSDE 10 with a MS SQL 2005 backend. I am trying to see the most recently modified geometries using SQL so that I can use it to update another GIS database running PostGIS. Has anyone tried this ...
1
vote
3answers
697 views

Is the “sdetable” command available with ArcGIS Workgroup

Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition? We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from ...
11
votes
2answers
555 views

ArcSDE Best Practices; Your thoughts

After spending a little time Googling for ArcSDE management best practices, I came up empty handed. I have a good understanding of Spatial Databases and their management having implemented several ...
3
votes
1answer
297 views

Publish ArcSDE FeatureService for Versioned Editing

Scenario: I need to Publish a data (from ORACLE ArcSDE) for versioned editing. Each user should be able to connect to his version and edit the data throu web application (Silverlight/JAVA/Flex API). ...
3
votes
2answers
437 views

ArcSDE 9.3.1 -> Performance

We have a number of mapservices in ArcGIS Server 10.0 that reads data from FGDBs. We are now moving that data in to ArcSDE and the plan is to use this data from AGS. Is it better to connect to SDE ...
4
votes
3answers
1k views

Spatial Views in SDE - What causes them to become unregistered from the geodatabase

Spatial views in ArcSDE allow you to join columns from a 'non-spatial' table in the database to a table with a 'geometry column'. They can also allow you to format and choose the attribute columns ...
2
votes
2answers
793 views

Using Flex to display single rasters from raster catalog in ArcSDE/ArcGIS server

One of the front end develoeprs here is having issues displaying, or working out how to display a single raster held in a raster catalog in ArcSDE using the Flex 2.2 API the Raster Catalog holds ...
1
vote
1answer
142 views

ESRI fc is called database.DBO.fcname and version is called SDE.fcname

ArcSDE 9.3.1 and MS SQL 2008 R2 In ArcCatalog the feature class is called database.DBO.fcname and when I look at the connection properties in ArcCatalog the default is called DBO.Default and the other ...
5
votes
3answers
277 views

After running the Version Changes tool ..Export pre-reconcile/post records from parent

I would like to export those records identified as changes after running the Version Changes tool before running Reconcile and Post tools. Preferably with python or having python call a program to do ...
8
votes
4answers
1k views

To what extent is SQL's language accessible via ArcGIS tools?

That question just sounds so redundant... At any rate, I have been asked to explore the uses of SQL in ArcGIS. We use an SDE DB for all server-side storage and DB managing/large-scale editing. ...
3
votes
2answers
293 views

Oracle Linestrings and MultiLinestrings

We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big. We'll here are ...
4
votes
3answers
1k views

Delete a feature data set in SDE 10 programmatically

Is there a way to delete a feature data set and all of its feature classes programmatically either by using custom code or pre-existing command line tools? There is a tool provided by SDE called ...
2
votes
1answer
745 views

Customize geocoding locator styles in an ArcGIS Server environment

Using ArcGIS Desktop, it is relatively straightforward to customize locator styles by editing the corresponding CLS files. We are struggling to do the same in a server environment. We have created a ...
1
vote
2answers
1k views

How can I insert new records to an ArcSDE feature class from a view in ArcSDE

I am wondering how I can both insert new records from a view to a feature class and update data that may be newer in the view than in the feature class. I have been fumbling around in modelbuilder and ...

1 … 3 4 5 6 7