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
28
votes
8answers
10k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
28
votes
3answers
11k views

What is difference between ArcSDE and spatially enabled databases?

When would you want to use ArcSDE (available as ArcGIS Server Basic license level) versus a spatially enabled database? What are the trade-offs on either side? What are the benefits on either side?...
27
votes
5answers
23k views

Is ArcSDE no longer needed at ArcGIS 10.1?

Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able ...
22
votes
2answers
4k views

Which geodatabase type is most appropriate for both open source and ESRI use?

Main Question: Is there a geodatabase type that seamlessly works with both ESRI and open source products? Details: My company currently passes around geodata in various vector and raster file ...
20
votes
0answers
4k views

Connecting ArcSDE to QGIS? [closed]

I have a need to be able to connect to and edit ArcSDE data in QGIS. This question has been asked before as: Is it possible to connect to ArcSDE using QGIS? https://hub.qgis.org/wiki/17/...
19
votes
7answers
5k views

Migrating 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 ...
16
votes
3answers
4k views

Addressing Memory leak in IFeatureClass.Search (only on SDE with direct connect) of ArcObjects?

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 tool in my .NET/C#...
15
votes
3answers
5k views

Selecting ArcSDE polygon by point in ArcGIS Desktop using ArcPy?

I keep thinking that I must be missing something, but there does not seem to be a tool in ArcGIS 10 to select features (in particular polygons) from a layer at a point (X,Y) location via ArcPy. The ...
14
votes
4answers
29k views

Define Workspace for SDE Connection in Python

How do we define SDE Connection for workspace in Python Scripting?
14
votes
2answers
6k views

Efficiently selecting related records using ArcPy?

Below is the code I'm using to replicate the "related tables" button in ArcMap. In ArcMap that button selects features in one feature class or table based on the selection of features in another ...
13
votes
2answers
6k views

What are benefits of using ArcGIS with PostgreSQL over simply ArcSDE?

I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed (...
13
votes
2answers
649 views

Getting differences between old and new versions of ArcSDE database?

Is there a tool or a process that can reveal changes made to the schema of an ArcSDE database when comparing two versions of the same database hosted on different servers? I have an old database ...
13
votes
1answer
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 ...
13
votes
4answers
9k views

Is it possible to connect to ArcSDE using QGIS?

Is anyone aware of any plugins, or any other way to connect and view data from an ArcSDE database in QGIS desktop?
13
votes
2answers
2k views

Migration from ArcSDE (SQL Server) to PostGIS (PostgreSQL)

We've got all the geospatial information of our company within an ArcSDE Database (over SQL Server): points (locations of the antennas), lines (elevation, rivers), polygons (protected areas, ...
12
votes
3answers
17k 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 ...
12
votes
3answers
1k views

Create Layer from Selected Features tool: How is the list of features stored?

In ArcGIS Desktop, there is a tool called Create Layer from Selected Features. Using this tool, I can convert a selection to a layer in ArcMap. It's my guess that there is a "list of features" that ...
12
votes
6answers
5k views

Identifying true curves/arcs in ArcMap?

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 need info for geodatabase ...
12
votes
5answers
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 ...
12
votes
2answers
1k views

Managing ArcSDE?

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 ...
12
votes
1answer
780 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 ...
12
votes
1answer
1k views

Steps for creating an online webmap with editable features using ArcGIS Server/SDE and SQL Server?

EDIT/UPDATE: I'm adding a bounty to this in hopes of obtaining a step-by-step guide to creating an online map with feature editing using the ArcGIS Flex API, SQL Server Express and ArcGIS Server 10.1. ...
12
votes
0answers
412 views

Why do file geodatabase and SDE readers produce different fme_geometry types? [closed]

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE 9....
11
votes
7answers
8k 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 (...
11
votes
3answers
716 views

Searching many feature datasets for ArcSDE feature classes using 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 ...
11
votes
4answers
7k views

Avoiding exclusive schema lock error with ArcPy?

I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only". My problem is that I can't avoid that these ...
11
votes
1answer
687 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 ...
10
votes
4answers
2k 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. However,...
10
votes
1answer
578 views

What is ArcSDE API used for?

To create applications that manipulate ArcObjects there is the VBA and Java runtimes. To create application that process data with ArcToolbox tools, there is ArcPy for Python. Today, I discovered ...
10
votes
3answers
906 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
10
votes
3answers
6k views

How to connect QGIS to SDE?

I read your amazing solution in this topic Is it possible to connect to ArcSDE using QGIS?. Unfortunately I'm not so expert in open-source products (we use only Esri suite) and I need to ask you some ...
10
votes
1answer
13k views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
10
votes
2answers
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 ...
10
votes
2answers
11k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
10
votes
4answers
3k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
9
votes
4answers
12k views

Copying ArcSDE geodatabase to file geodatabase using ArcPy?

I would like to make an exact copy (domains, feature datasets, feature classes, etc.) of an SDE database to a file geodatabase. I have tried several possibilities, including: using the Copy (Data ...
9
votes
2answers
2k views

In a versioned geodatabase, what impact do delta tables and the state tree have on query performance?

We have a versioned arcsde geodatabase (arcgis 9.3.1 on oracle 10g) with a fairly complex data model that includes about 100 featureclasses and non spatial tables, a geometric network and many ...
9
votes
1answer
877 views

Is there a way to check if data was versioned using “move edits to base” option?

Is there a way to check if data was versioned using "move edits to base" option? Preferably through ArcGIS itself or using Python, but any way will work. EDIT Is there way to see if this box was ...
9
votes
1answer
4k views

Using PostgreSQL with QGIS and ArcGIS?

Is it possible to use PostgreSQL with QGIS and ArcGIS? i.e. one database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know ...
9
votes
1answer
1k views

SQL Server Relationships in ArcSDE?

I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
9
votes
1answer
630 views

Changing to Historical version using ArcPy?

I am having an issue trying to change to a historical version on an SDE feature class using Python and arcpy.ChangeVersion_management. I am able to manually change the version to a specific date and ...
9
votes
1answer
518 views

Is it possible to replicate an SDE geodatabase including the archive tables?

I have a database in one location which I would like to replicate to another using one-way replication. In testing we haven't been able to replicate the archive tables, which is unfortunate because we ...
9
votes
1answer
824 views

Out of Server Memory when reconciling a large edit session in ArcObjects

One of our users has been periodically experiencing Out of Server Memory errors with ArcSDE 10.0 when trying to reconcile a large edit session. VMware ESX Instance: Windows Server 2008 R2 Datacenter ...
9
votes
1answer
1k 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 ...
8
votes
3answers
9k views

Deleting feature class features faster using ArcPy?

I have written this script that recurses through all feature classes in a given set of feature datasets and deletes all their features. It appears to do the job but it runs pretty slowly. Is there ...
8
votes
2answers
917 views

Why shouldn't data be loaded into enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is?
8
votes
7answers
8k 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 ...
8
votes
1answer
523 views

Performing Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...
8
votes
3answers
3k views

Permanently replace/update server/service in each ArcSDE Layer in 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 ...
8
votes
3answers
1k views

ArcSDE - use native geometry types for later migration away from SDE?

Background: We have a non-spatial reporting web application with a SQL Server backend. We would like to add a spatial component to this application: serve up some basemaps, serve up points and ...