Questions tagged [enterprise-geodatabase]

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

258 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
258 views

How to extract xy coordinates to featuretable using ArcGIS web map/app to create points?

I have an ArcGIS online web app to collect points using the services served on our server. The featurelayer exists in our SDE server. How can I extract and update the xy (lat/long) coordinates ...
1
vote
0answers
47 views

Can I install GIS Software on RSS (informix server) running 11.7.fc6

I currently use ArcGIS Server 10.0 and consume data through a db2 database. I recently installed an RSS informix server and was hoping to pull data from this since it is updated real-time versus the ...
1
vote
0answers
131 views

ora-01747: user.table.column, table.column or column description is invalid

everyone. I created a table in oracle with a sde.st_geometry column. I followed the instructions of ArcGIS help to register the table into geodatabase. However, when I try to load data into this ...
1
vote
0answers
272 views

Renaming Feature Class within versioned Feature Dataset

I am working in ArcSDE. I have several feature datasets within an Oracle Enterprise Geodatabase. When I try to rename one of the feature classes that is within a feature dataset it "falls out" of the ...
1
vote
0answers
163 views

ArcMap 10.2.1 issues diffferent SQL than 10.0 for “Select by location”?

I have a large point layer and I'm doing a "Select by Location" to select all points that intersect a specific selected polygon from a polygon table. In ArcMap 10.0 the SQL that was executed ...
1
vote
0answers
585 views

Is there a way to QGis read an SDE.ST_GEOMETRY field?

this is the type and name that Qgis displays for me when I connect with a oracle table,it is not displayed as a geo column, there is a setting I'm missing? Can Qgis Read this type of data?
1
vote
0answers
159 views

Error post installation ArcSDE for SQL server 2008

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then when ...
1
vote
0answers
60 views

ArcGIS Find task performance over SDE

We are having a problem in our Search feature for our app. We are using arcgis published REST services and SDE database. When we try to do our search manually using the REST url, it takes roughly 9 ...
1
vote
0answers
78 views

Multiuser Editing with ArcGIS through LAN

I am working on an ArcObjects application (C#), which is supposed to carry some customized editing operations, the database is ArcSDE based on Postgresql via (accessible via a LAN network). One ...
1
vote
0answers
836 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
1
vote
0answers
408 views

How do I bypass class extensions when reading from ArcSDE with FME 2014?

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data. I am not able to set the Reader to bypass the class ...
1
vote
0answers
77 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
1
vote
0answers
609 views

post instlacion ArcSde 10 "error creating Arcsde direct Connection (-9)

I installed SQL sever 2008'm doing the post installation used ArcSDE 10 these are the steps I am doing in post installation of ArcSDE 10 complete installation. SDE Schema. put the name of my ...
1
vote
0answers
89 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
1
vote
0answers
129 views

Problems with versioning

I have 5 PostgreSQL_PostGIS database in my company and i conneting on them through ArcSDE. Four of database work correctly, only with one i have i realy big problem. When i make two versions of ...
1
vote
0answers
104 views

What is the relationship between Map Service Instances and SDE connections?

We have a GPS project based on ArcGIS Mobile 10.0. There are two web map services and each were kept as Nonpooled with Minimum instances 15 and maximum instances 60 by original developer. The database ...
1
vote
0answers
225 views

“Definition Query on a versioned Geodatabase”

I would like to implement Specific views to the SDE users, based on Definition Queries of common attributes , like Date created > = October 1. But on first look, the definition queries are for "...
1
vote
0answers
96 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
1
vote
0answers
632 views

Why does Append on large annotation layer give WARNING 000594: Input feature falls outside of output geometry domains?

I am trying to Append about 3,000,000 records in an annotation layer to another, empty annotation layer. I'm using ArcCatalog and I get the following error messages: WARNING 000594: Input feature ...
1
vote
0answers
320 views

While Exporting from SDE, null geometry features attack?

I'm working on a layer in an SDE Database (ArcMap 10.1 SP1 for desktop (Build 3143)), I just export to a local working database on my workstation the layer I want to work on and load it back when done....
1
vote
0answers
265 views

How to display labels from many-to-many relationship in ArcGIS 10 using VB.NET?

I have two tables in a geodatabase: parcel; and person 1 or + parcel, can have 1 or + person (relationship is many-to-many) Using VB.NET I can display all the parcel labelled with the "id" ...
1
vote
0answers
437 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
1
vote
0answers
302 views

ESRI AddFeatures call on rest endpoint with attributes

I can add a line feature via the rest endpoint with my hand crafted call from C#. However, if i add any attributes to the call it will fail and say unable to perform operation. All of the fields in ...
1
vote
0answers
198 views

Extract an ArcSDE datasets (rasters/shapefiles) using Python?

I would like to write a Python script to extract/export a dataset (rasters/shapefiles) in ArcSDE. I saw this posts to connect to the server: Define Workspace for SDE Connection in Python But how ...
1
vote
0answers
282 views

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in ...
1
vote
0answers
47 views

Managing outages to make ArcSDE updates?

I would like options to manage ArcSDE outages for making updates to schema, which I am not able to do when users are just reading the feature classes. I would like to not have to stay late to get ...
1
vote
0answers
97 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 ...
1
vote
0answers
49 views

Edits geodatabase

I am trying to reconcile and post the edits. Before doing that I want to manage the edits in such way that the edits are queued before reconcile and post. I am doing this using c#.
1
vote
0answers
424 views

Can feature layer in MXD with joined data from non-geodatabase be published as feature service?

I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
1
vote
0answers
387 views

Creating relationship class in ArcSDE?

I can not seem to create a relationship class in ArcSDE, or at least one that works. I am succseful in creating the class however ArcMap does not recongnize it (there are no related tables shown) and ...
1
vote
0answers
349 views

Loaded shapefile into SDE without spatial proj creates problem

Via a Python script - various shapefiles were loaded into SDE with no spatial reference set. This causes a strange problem - when you view the featureclass in ArcCatalog (geography view) - it shows ...
1
vote
0answers
109 views

Can we do replication and versioning in User schema geodatabases version with sde default version

As both are administrators to their own schemas, is there any possibility to post and reconcile data across schemas?
1
vote
0answers
330 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
1
vote
1answer
752 views

Error when enabling ArcGIS geodatabase

We're trying to enable enterprise geodatabase functionality in an existing PostgreSQL database. We've already created the sde user (set as superuser) & sde schema. We get the following error: "...
1
vote
1answer
113 views

Is it possible to limit export feature class in ArcSDE to only some users?

I'm trying to manage user and their privileges in ArcSDE and sql server 2012. I can privilege the select and edit a layer for users. I can use just two privileges but i want to permit export feature ...
0
votes
0answers
13 views

Editing EGDB data with Portal/Collector: Do error messages from the DB pop up in the app?

Oracle 18c; Portal/ArcGIS Server 10.7.1 I'm considering setting up Portal so that I can edit my on-premise EGDB data in the field using ArcGIS Collector. As part of this implementation, I would have ...
0
votes
0answers
10 views

Prevent users from deleting EGDB tables

Oracle 18c/10.7.1 geodatabase: My geodatabase has an owner/schema/user called OPERATIONS. Operations staff have a direct db connection in ArcMap/Catalog to the OPERATIONS owner. This connection is ...
0
votes
1answer
20 views

Copying feature datasets weekly from EGDB to EGDB (geometric networks included)

I've been trying find a way to copy a few select feature datasets from our main production Enterprise geodatabase environment to a second Enterprise geodatabase. These datasets include geometric ...
0
votes
0answers
46 views

Prevent deletes in a versioned FC at the application level

In Prevent deletes in a versioned FC at the database level (a related question), we determined that it's not possible to prevent deletes from a versioned FC via functionality in the database. As an ...
0
votes
0answers
23 views

Under what circumstances would the _DELETE trigger get called? (_EVW)

Oracle 18c/10.7.1 geodatabase: When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created: V000001_DELETE V000001_INSERT V000001_UPDATE ...
0
votes
0answers
27 views

Create ArcGIS geodatabase domains from a CSV file using Python

I want to create ArcGIS geodatabase domains from a CSV file.The problem is that my output says field values in the row are "None". It doesn't recognize the values in my CSV file. Any ideas ? ...
0
votes
0answers
23 views

How do I set the type of geometry when creating a SQL table?

The table I am trying to recreate has these properties Data Type File Geodatabase Feature Class Feature Type Simple Geometry Type Polygon <<<< WHAT I WANT TO RECREATE My target ...
0
votes
0answers
22 views

Feature class is not imported in ArcSDE in ArcCatalog

I installed ArcEditor and ArcSDE. In my computer ArcEditor 9.3.1, ArcGIS Server 9.3.1, ArcSDE 9.3.1 and Oracle 11g are installed. I did all things by the Guide of ESRI: ArcGIS Server, Configuration ...
0
votes
0answers
16 views

What does the ArcGIS10.2 sde_state_id suffix 'L' mean in delta tables, when read using pyodbc in Python?

Enterprise geodatabase sits in MS SQL Server database. I'm using Python's pyodbc SQL driver to read SDE delta tables. I'm running the following query: select delete_table.SDE_STATE_ID, ...
0
votes
0answers
14 views

Can I prevent Planarize from resetting Domain Values?

Is there some setting I have that is causing this or is this just a BUG in ArcMap? I'm using ArcMap 10.8 with an Enterprise Geodatabase. When I run Planarize on a pair (or more than 2) Road Centerline ...
0
votes
0answers
50 views

ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer

I have data in an Oracle table (11 million records) and would like to insert 2000 records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
0
votes
0answers
24 views

Checkout creation in ArcGIS

I am trying to create a replica checkout to work with from my Enterprise geodatabase which sits in UK however working with that it always give this error of "not being able to reset the foreign key ...
0
votes
0answers
16 views

Map Service: How is the shape column in an XY event layer different from a shape column in a registered view?

I have a non-spatial table with XY columns in an Oracle 18c/10.7.1 geodatabase. With that table, I'm able to create a registered view with a shape column (based on the XY via the st_geometry function)...
0
votes
0answers
114 views

Getting “Workspace Already in Transaction Mode” Error when trying to use updateCursor on versioned sde

There are are numerous post on this error, but I can't seem to find a solution for myself. We have a versioned sde and need to add new fields to some of our feature classes and populate them with an ...
0
votes
0answers
14 views

Database Population in wrong Authentication Type

I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...