A commercial relational database management system.
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
984 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
172 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
233 views
Is it possible to create Domains for an Oracle (non SDE) database?
I have a simple Oracle database (non SDE/Geodatabase) but I want to constrain the values that can be entered into a particular field (ex: the state names that can be stored/entered in a "State" field)
...
2
votes
3answers
542 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 ...
0
votes
1answer
127 views
Is there a way to automatically run the Workflow Manager Postinstallation (WMXPostInstallation.exe)?
I'm looking for a way to script the WMX post-install and, for example, provide the sde connection info as parameters. I don't see any command-line parameters for WMXPostInstallation.exe--are there ...
1
vote
3answers
742 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 ...
7
votes
3answers
1k views
Technical comparison of Oracle and PostgreSQL
I have searched on google and the archives for a technical comparison of Oracle and PostgreSQL (also MySQL), unsuccessfully.
Is there any comparison that covers more than just the basic differences? ...
4
votes
1answer
305 views
Migration from Oracle to PostgreSQL
I emphasise that I am a newbie in databases.
Is it possible to migrate from Oracle database to Postgres?
If yes do you know any tested solutions?
3
votes
1answer
850 views
Can spatial data in Oracle be imported into SQL server?
Oracle supports spatial data and so does SQL Server.
What are the things to consider if we have to migrate spatial data from Oracle to SQL Server?
Are there any features in Oracle that are not there ...
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 ...
3
votes
1answer
857 views
gp.Describe() on sde table
Python newbie needing help with a simple task. I'm trying to create a list of stand-alone tables in an sde workspace.
Code below works just fine to list feature class names and paths and table ...
2
votes
1answer
336 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 ...
3
votes
2answers
344 views
Is there a common interface for ST_Geometry SDO_Geomtry
I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial.
Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...
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 ...
4
votes
1answer
757 views
In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?
I have to query polygons that intersect with one another. Our polygons occasionally contain intersections that aren't intended (meaning just a few vertices cross boundaries). I want to filter out ...
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
0
votes
1answer
245 views
Convert geodata from .rdb and .mpr files
I've got an COM-server and activeX client (looks like delphi app), that display some geodata.
Data stores in files with .rdb and .mpr extensions.
I find out that rdb is oracle database file format. ...
1
vote
0answers
114 views
Can I get the metadata about the themes in Oracle MapViewer?
I am trying to use the MapViewer xml api to generate a dynamic theme (for generic highlighting support), but don't want to expose table names and such to users, I would like then to communicate in ...
3
votes
1answer
526 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
4k 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, ...
