Tagged Questions

0
votes
0answers
15 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 ...
3
votes
1answer
71 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 ...
3
votes
1answer
134 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 ...
1
vote
1answer
157 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 ...
2
votes
2answers
207 views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
6
votes
1answer
95 views

What is the overall architecture of ArcSDE, and how does it fit into the enterprise?

I'm finding many gaps in my understanding of ArcSDE, particularly as it relates to Oracle. I just can't quite wrap my brain around the overall architecture of it, and how it fits into an enterprise. ...
5
votes
2answers
132 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
8
votes
3answers
277 views

How to identify “true arcs” in Arcmap?

This is really annoying: the only good way of creating circles in ArcMap is using true arc, (compound curves) but I need to convert those to vertex (densifying) because of a compatibility problem. I ...
3
votes
0answers
146 views

ArcSDE Database Refactoring Tools?

We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas. But we also work with GIS applications using esri ...
3
votes
1answer
405 views

ArcGIS Query Layer performance documentation or feedback

I first tried asking this question in the ArcGIS forums but as is common I got a total of 0 responses. I'm willing to accept this may be due to a lack of knowledge on the subject, but I'm optimistic. ...
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 ...
4
votes
2answers
159 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 ...
6
votes
2answers
353 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 ...
2
votes
3answers
537 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 ...
5
votes
3answers
336 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 ...
4
votes
2answers
427 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 ...
4
votes
2answers
302 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 ...
4
votes
1answer
216 views

Geometry storage type in geodatabase Oracle 9i with SDE 9.3.1

How do I identify what geometry storage type is being used with a specific geodatabase? Thanks.
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 ...
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, ...
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 ...
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 ...
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
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
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 ...
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
1answer
435 views

Filter features with multi-table joins in ESRI Silverlight/REST API

We have a rather involved data warehouse (SDE 9.3.1 / Oracle 11g) that contains a single related point feature class. Our (analytical) application should allow users to construct complex, ad hoc ...
2
votes
1answer
335 views

Oracle tracing, bind variables, and ArcSDE

Oracle tracing with TKPROF is the recommended way to troubleshoot data access performance problems with SDE/Oracle. Unfortunately, queries that differ in any way are considered "different" and ...
5
votes
1answer
197 views

Versioning commercial datasets in ArcSDE + Oracle

We are building an application with several spatial tables, provided by a commercial vendor, at its core. The vendor provides updates quarterly. We maintain several tables of our own, derived from ...
2
votes
2answers
574 views

How to add a Database Server in Catalog?

I have ArcSDE on an Oracle database and I want to add a database server connection to ArcCatalog, I've seen several sites but they don't say what I have to write down. Let me explain: From the tree ...
2
votes
1answer
531 views

ArcSDE: connecting via LDAP Authentication

I was wondering if anyone has a sample connection string for SQLPlus using LDAP Authentication. I am also trying to specify in the connection string the database I wish to use. Thanks, CDB
3
votes
1answer
522 views

Unable to Reconcile

I'm quite familiar with the ArcSDE model and a few days ago we have major power issues here. My problem (and this is a BIG one) is that one of the users, made thousands of edits correcting data, and ...
4
votes
6answers
3k views

Troubleshoot editing features in feature dataset with ArcMap / ArcSDE Oracle

I am having trouble editing a feature class that is in a feature dataset. We have added just the single feature class as a layer in ArcMap and are using the "Start Editing" function on the Editing ...
3
votes
2answers
1k views

Cannot spatially select from Oracle view based featurelayer in ArcMap

I'm hoping someone has seen this before and has a solution. I've exhausted all my ideas. I having problems with the selection and identify tool in ArcMap. I have a point feature class, zlevels, ...