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 ...
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 ...
7
votes
4answers
10k views

Debugging RuntimeError: workspace already in transaction mode from arcpy.da.UpdateCursor and ArcSDE feature classes?

I am making my first attempt at editing an ArcSDE feature class with python through a da.UpdateCursor. I'm essentially taking code I've written for a file geodatabase feature class and applying it to ...
2
votes
1answer
466 views

SQLServer Shapefile Export won't load in MongoDB due to self intersection

I am having an issue loading a handful of GeoJSON files that were created from a shapefile export from SQLServer into MongoDB. This polygon will not load in MongoDB because of two duplicate vertices ...
14
votes
4answers
29k views

Define Workspace for SDE Connection in Python

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

Numbering polygons according to their spatial relationships?

I have, for example, this layer in postgresql (polygons): table : poly (objectid: integer, num: integer, shape: geometry) I want to enumerate the polygons from left to right and top to bottom like ...
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 ...
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 ...
5
votes
1answer
268 views

Why are z-values replaced with zero after in_memory use in Python?

My script takes separate 3D feature classes, calculates a field, appends to a target feature class, and then deletes the originals. This is a huge data processing task of over 4700 mass point feature ...
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 ...
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#...
6
votes
1answer
3k views

How to Keep Database and Server Connections active

It seems like everyday I go to publish a service or connect to my SDE I get messages that I can't connect. It is particularly annoying when trying to publish a service to ArcServer. The connections ...
6
votes
3answers
883 views

Can primary keys and foreign keys be used in versioned geodatabases?

I've been brushing up on relational database design theory, and I keep coming across primary keys (PKs) and foreign keys (FKs). PKs and FKs are said to be pillars of relational database design and ...
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 ...
4
votes
3answers
2k views

PostGIS and ArcSDE mixed environment

I am trying to setup up a enterprise geodatabase with ArcGIS 10.4.1 and PostgreSQL 9.4 where I can use PostGIS for my SQL queries in PostgreSQL and have the sde functionality. I have a windows ...
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?
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 ...
4
votes
1answer
3k views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
3
votes
1answer
800 views

Using PostGIS geometry for ArcSDE database?

I just enabled my PostgreSQL/PostGIS database with ArcSDE. Since I did this, when I copy and paste a dataset into my database via ArcCatalog, the dataset is not visible in QGIS. This is because ...
2
votes
1answer
1k views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
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 ...
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 ...
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?...
8
votes
4answers
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.
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 ...
5
votes
1answer
1k views

Editing PostgreSQL geodatabase table using ArcPy?

I'm trying to update a table using a python script and it's not working. The table resides in a postgres geodatabase and is versioned. I have also verified my user permissions (I'm the admin). The ...
5
votes
2answers
22k views

Difference between ArcSDE and ArcGIS Server?

What is the difference between ArcSDE and ArcGIS Server?
3
votes
3answers
3k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several feature sets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned. We have numerous non-GIS ...
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 ...
7
votes
1answer
3k views

Check whether a feature class is registered as versioned using Python

How can I check whether or not a feature class is versioned using Python? I'm trying to register feature classes using a python script. Before I do this I need to check whether a feature class is ...
7
votes
1answer
588 views

Get ArcMap to recognize ST_POINT (SDE.ST_GEOMETRY)

I have a sde.st_geometry line feature class called ROADS. I've created a view using a st_geometry function called st_startpoint which returns an st_point column. st_point is a subclass of st_geometry; ...
6
votes
5answers
543 views

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

I'm considering switching some of my tables in an Oracle enterprise geodatabase from versioned to unversioned. The pros of having unversioned tables would be: Simpler, traditional database design ...
6
votes
3answers
3k views

Reconcile Versioned Geodatabase with only DEFAULT version?

Follow up to this: Spatial Database Connection String I am trying to reconcile a versioned geodatabase that has only one version, DEFAULT. I am following the steps from the ESRI documentation: A ...
5
votes
2answers
2k views

Populate X and Y fields in SDE Point Data Using SQL trigger

Here is my situation. I am running ESRI ArcGIS Server and Desktop 10.2 on SQL Server 2008 R2. I would like to populate the Latitude and Longitude fields from point data (Signs data collected using ...
3
votes
2answers
1k views

List of all fields and their domains, for each table using SQL (table_name, field_name, domain_name)

I'm trying to list all fields (in all tables in an Oracle geodatabase) and the cv domains that they use. +------------+------------+-------------+ | table_name | field_name | domain_name | +----------...
3
votes
1answer
2k views

ArcSDE desktop license

I am using the ArcGISDesktop student license. I want to work on versioning and geodatabase replication. Is it possible to set up ArcSDE with the same license and work on versioning and replication?
3
votes
2answers
3k views

Delete SDE feature class features with ArcPy

I'm working on a script that will empty my SDE database of all data. How would I go about deleting features from feature classes using ArcPy? I have an SDE connection created with a user that should ...
2
votes
1answer
794 views

Get GDAL up and running with ArcSDE enabled

I want to migrate rasters from ArcSDE 9.2 to Postgresql. I have access to a ArcSDE server with several large raster datasets (mosaics) in ArcSDE 9.2. I can use ArcCatalog, ArcMap and ArcToolbox to ...
7
votes
6answers
5k views

Copying entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system. I need an exact copy of the ...
6
votes
2answers
2k views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...
3
votes
1answer
394 views

ArcGIS sde i5,i6,i7 tables

I have created an ArcGIS enterprise geodatabase. There are i5, i6,... i30 tables in the sde schema of my geodatabase. What do these tables do?
2
votes
2answers
2k views

arcpy.env.overwriteOutput = True not working for one dataset

I am doing a basic copy from sde database to file geodatabase. I have a loop going through each feature dataset in the sde database, this loop is really basic it just uses arcpy.Copy_Management to ...
2
votes
1answer
716 views

How to cast SDE table to IFeatureClassLoad

How do you cast an SDE table to IFeatureClassLoad using ArcObjects? I'm getting an error with this attempt below which is not the correct method: Dim pSDEFeatWksp As IFeatureWorkspace = ...
1
vote
3answers
2k views

Why can't I open this workspace?

I used python add in to make a tool bar in Arcmap that edits features on a map. It works on a file geodatabase, but not on an ArcSDE version one. I've been getting an FDO error: 0. The solutions that ...
1
vote
0answers
83 views

ArcMap Replication tool does not synchronize changes made from database tool i.e SQL Developer? [closed]

I want to synchronize some datasets and feature classes from Oracle to MS SQL Server using ArcMap replication tools. Both databases are geodatabase enabled. I don't want to replicate/synchronize data ...
1
vote
1answer
345 views

arcpy.PackageWorkspace doesn't keep reference to SDE enterprise geodatabase

I am publishing a geoprocessing service on ArcGIS Server v10.3.0 that updates data on an ArcSDE Enterprise Geodatabase. I have the following at the beginning of my script: arcpy.env.workspace = "...
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 ...
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 ...
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 ...
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 ...