Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

Filter by
Sorted by
Tagged with
5 votes
1 answer
400 views

Address locator not using modified .cls file

I have made a customization to the US Streets locator style for our application. We've changed "SR" to map to "STATE ROAD" instead of "HC" in the us_addr.cls file in the C:\Program Files (x86)\ArcGIS ...
user avatar
  • 345
2 votes
1 answer
577 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 ...
user avatar
  • 1,987
2 votes
1 answer
530 views

Can GeoServer 2.0.2 access ArcSDE 10.0 databases?

It looks like ArcSDE 10.0 databases are not yet supported... At least documentation on the geoserver-2.0.2-arcsde-plugin doesn't appear to address it specifically, and I can't get it to work. Is ...
user avatar
3 votes
3 answers
4k views

Table to Table script fails when copying to SDE

Since TBL2SDE no longer exists (we're running a 64-bit server and ArcGIS 10 doesn't include that executable on a 64-bit installation) I've been using the Table to Table script in ArcToolbox to copy ...
user avatar
  • 1,966
2 votes
1 answer
567 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 ...
user avatar
  • 1,987
4 votes
1 answer
2k views

Creating Stored Procedure in versioned SDE_SQLServer geodatabase using DDL?

I've almost used SQL server_SDE geodatabases for 3 years in GIS projects and I don't know how can I create a stored procedure in geodatabase.I use ESRI case tool to create a geodatabase in ArcCatalog(...
user avatar
  • 804
6 votes
5 answers
1k views

Troubleshooting ArcObjects performance problems

We have developed a relatively complex geoprocessing routine using a C# / ArcObjects (COM) / ArcGIS Server 9.3.1 / ArcSDE 9.3.1 / Oracle 11g stack. Running the routine on a complete dataset takes many,...
user avatar
  • 1,987
2 votes
2 answers
299 views

Keeping SDE for data maintenance, but use postgis for display

We build and maintain GIS data in a production environment with SDE on SQL 2008. We also have a need to open up WMS and WFS that will make a complete ESRI solution really expensive. With an ArcGIS ...
user avatar
1 vote
2 answers
3k views

How do I programmatically update/recreate an ArcSDE feature class from external sql data?

I have an ArcSDE feature class that contains project points based on XY data from an external SQL database. (Not a geodb). I am looking for the best way to "recreate" the ArcSDE feature class from the ...
user avatar
  • 392
5 votes
4 answers
2k views

Creating a multiversioned view with ArcSDE and SQL Server 2008 R2

I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2. Everything appears to be working correctly with one exception: The ...
user avatar
5 votes
2 answers
1k views

ArcSDE for PostgreSQL installation

I am trying to install ArcSDE 10 for PostgreSQL in CentOS. I tried doing that but am stuck with same errors repeatedly and am thinking of giving one more shot from the scratch. I just want to make ...
user avatar
  • 163
5 votes
1 answer
235 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 ...
user avatar
  • 1,987
11 votes
1 answer
722 views

Is it possible to maintain primary keys on versioned featureclasses without arcobjects code?

Since it is not a good idea to use ObjectIDs as primary keys in relationships, some other column will need to be used. Is it possible to use DBMS sequences to populate primary key columns in ...
user avatar
12 votes
3 answers
20k views

How does one access a featurelayer in SDE via Python?

I am trying to use Arcpy to run the CopyFeatures_management script so that I can copy a featurelayer in SDE. What do I use for the input (and output, for that matter, since I'll be copying the layer ...
user avatar
  • 1,966
3 votes
1 answer
1k views

Editing with ArcGIS API for Silveright?

I am using the ArcGIS Silverlight API to edit data in an ArcSDE SQL Server geodatabase. I have been told that any editable feature classes must be registered as versioned in ArcCatalog before they ...
user avatar
7 votes
5 answers
2k views

ArcSDE installation with PostgreSQL (error - 1015)

I am trying to install ArcSDE for Postgresql on CentOS 5.5 in i686 architecture. I have successfully installed and configured Postgresql. I did SDE pre-installation and as ArcSDE user, run the ArcSDE ...
user avatar
  • 163
2 votes
2 answers
803 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 ...
user avatar
  • 530
7 votes
2 answers
3k views

ArcSDE - where to start?

As I long ago figured out that I need more complex query-asking abilities (other than the standard select provided by arcgis), and as I will someday have to admin a small scale SDE database that will ...
user avatar
  • 3,207
7 votes
0 answers
633 views

What qualifications should auditor have to auditing GIS? [closed]

Background summary: Various systems are being audited and GIS is the next to be audited. The initial kick-off for the audit was a meeting between me and a single auditor. Initially, I thought it was ...
user avatar
  • 14.4k
3 votes
1 answer
177 views

Viewing ST_MULTIPOLYGON data from ArcSDE DB2

We have inherited some tables that were created with ArcGIS/ArcSDE, and the data in these is still being used by our main web application to perform some spatial lookups. The queries are pretty ...
user avatar
  • 131
3 votes
3 answers
1k views

Transfering a lot of features from geodatabases?

I'm having a problem where I need to export a large amount of content from 2 geodatabases of different nature (SDE -> File). I have three options: Spatial Select, a regular SQL select and the full ...
user avatar
  • 6,250
4 votes
1 answer
2k views

Granting permission in ArcSDE geodatabasewhen layers are inside geometric network?

When I use sdetable command to grant pemission to a table that located in a SDE SQL server geodatabase it works properly, this table is a non-spatial table which is in geodatabase immediately, I mean ...
user avatar
  • 804
2 votes
3 answers
1k views

how to configure an arcgis server service to enable multiple editing

I'm using ArcGIS Server 9.3.1, ArcSDE, VS.NET 2008 and I'm trying to enable a service to be edited multiple times, the service its going to be public and it will be used to report emergencies and ...
user avatar
  • 530
2 votes
1 answer
933 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
user avatar
  • 2,332
3 votes
3 answers
1k views

Can you set the PostGIS SRID when creating a Feature class through ArcCatalog?

I have ArcSDE installed in a Postgresql database and I am using PostGIS geometry. I'm not a DB minded person so feel free to let me know if my process is not right. I create my feature class in ...
user avatar
  • 2,999
5 votes
1 answer
2k views

ArcSDE - Registering table with Geography spatial column fails with error -138 (SQL Server 2008)

I have a table of point features I am trying to register with ArcSDE (9.3.1 on SQL Server 2008) using the following command: sdelayer -o register -l ThirdPartyWellsSurface,Shape -e np -C OBJECTID,SDE ...
user avatar
  • 12.6k
4 votes
2 answers
561 views

Has anyone successfully implemented a web service that sits on top of ArcSDE (SQL Server 2008)?

Here's the situation. We have planned point locations that lie within predefined polygonal project areas. Our IT department currently has these polygonal project areas in SQL Server 2008 as geography ...
user avatar
  • 12.6k
2 votes
2 answers
2k views

Create ArcSDE Database from ArcCatalog

Is there a way to create a spatial database from ArcCatalog that also creates the ArcSDE user, repository, and service. Basically, I am trying to do everything that the ArcSDE Post Installation does, ...
user avatar
4 votes
2 answers
11k views

Error accessing spatial database connection with ArcGIS 10

I set up a new SDE database with ArcGIS 10 and everything appeared to go correctly. The service is running and I'm able to view the database in SQL Server. However, when I try to access the spatial ...
user avatar
7 votes
2 answers
2k views

How do you connect to a SDE instance on EC2?

We are exploring using Amazon EC2 with ArcGIS Server - and none of us has any experience with it. The question "How can we, from within our intranet, connect to the remote SDE instance in the EC2 ...
user avatar
  • 12.6k
10 votes
2 answers
1k views

Find duplicate vertices in SQL Server geometry line (ArcSDE)

I have a line in a ZM polyline featureclass that has a invalid geometry. My suspicion is that the line doubles back on itself somewhere, which I've found SQL Server doesn't like. Anyone know of a ...
user avatar
  • 12.6k
4 votes
1 answer
468 views

Remove ArcSDE repository and associated files from PostGresql DB

A bit of background first. I have a PostGres DB with PostGIS, I also have ArcSDE installed in this DB and all feature classes created through ArcSDE are using the PG_Geometry. Everything works well! ...
user avatar
7 votes
3 answers
4k views

When to store geometries using SQL-server geometry datatypes or ArcSDE?

With the release of SQL Server 2008 Microsoft added geometry data types. So geometries can now in an ESRI enviroment be either be stored using SQL-Server datatypes or ArcSDE datatypes. A colleague ...
user avatar
4 votes
2 answers
2k views

ArcSDE 10.0 giomgr Error During Post Install

I just installed ArcSDE 10.0 and ran the post install once to test the install and it ran great. Today I tried to run another post install to create another database and I get the error: "Parameter ...
user avatar
  • 887
13 votes
1 answer
3k views

Why do simple joins on small datasets slow down ArcMap so badly?

ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is ...
user avatar
  • 12.6k
12 votes
1 answer
813 views

Stop ArcMap from probing missing data sources on launch

When migrating a map from one environment to another (say, from an existing client environment to our development environment) we're often given MXD documents that represent the map. These documents ...
user avatar
  • 5,734
3 votes
3 answers
623 views

PostGIS + ArcSDE mixed environment

I'm trying out a mixed environment here at work with PostGIS and ArcSDE together. I'm having some problems creating feature classes with custom SRIDs. I imagined that all that I needed to do was ...
user avatar
  • 6,250
2 votes
2 answers
645 views

ArcSDE edits not showing up in ArcGIS Server Geodata Service?

I've got an ArcGIS Server GeoData service against an SDE MSSql database. When changes are made to the source data, the edits don't appear to show up in the GeoData service. If I restart the ...
user avatar
  • 1,151
8 votes
4 answers
2k views

Will PostgreSQL 9 work with ArcGIS 10?

I realize it is not listed as a supported Database. I am interested to see if anyone has tried to install and use it.
user avatar
  • 661
3 votes
1 answer
1k 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 ...
user avatar
  • 6,250
2 votes
1 answer
999 views

Is there any way to perform spatial filter on multiple layers together?

I have a scenario where a featureclass[Child Version] is queried for some overlapping features on [SDE.DEFAULT] Version using ISpatialFilter, After getting few result, these features are looped and ...
user avatar
  • 309
4 votes
1 answer
239 views

Power Outage and ArcSDE

I'm working on a hostile environment. Power outages, despite our efforts to minimize them, are often here. Yesterday we had a power outage and we had 2 ArcSDE databases working. I have two sets of ...
user avatar
  • 6,250
2 votes
1 answer
418 views

Has anyone successfully made a FeatureLayer from a view in DB2 and ArcSDE 10?

Lately it seems like every new ESRI feature fails for me - I must be cursed. I'm testing the use of a FeatureLayer to see if helps display and query features using the JavaScript API 2.0. This layer ...
user avatar
1 vote
1 answer
4k views

Product License not initialized error when trying to open an SDE connection in ArcObjects

I am trying to connect to create connection in using ArcObjects using the code below. IPropertySet propertySet = new PropertySet(); IWorkspaceFactory sdeWsFactory = new SdeWorkspaceFactory(); ...
user avatar
  • 345
12 votes
5 answers
10k views

Dealing with ArcSDE connection limit exceeded?

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
user avatar
  • 1,987
2 votes
2 answers
822 views

Big IRowBuffer problem

I have a small software that connects to a database (SQLServer) reads a few values and transfers them to a SDE Oracle instance (11g). The problem is: I have over half million records that I need to ...
user avatar
  • 6,250
4 votes
2 answers
538 views

Visualize feature class with many relationship classes?

I have a feature class in a geodatabase that I want to review. It has many relationship classes - possibly a hundred or more. If I load the feature class into ArcMap and identify one of the features,...
user avatar
  • 5,734
8 votes
7 answers
9k 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 ...
user avatar
  • 5,734
3 votes
2 answers
2k 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, ...
user avatar
  • 345
5 votes
3 answers
1k views

SDE views not showing values in joined table

I created an SDE view between a point feature class and a table (stored in SDE) - the join is done on a text field called RFRNC. I changed the view so that it is now a LEFT OUTER JOIN in line with ...
user avatar
  • 1,831