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
3
votes
1answer
914 views

Installing ArcGIS Desktop on Windows 7 (64 bit)

I just reformatted my PC with Win7 64bit to try and take advantage of 64-bit python processing. However I'm not sure what to do here: Our office runs ArcGIS 10.1, TOAD and SDE for Oracle. Toad ...
1
vote
1answer
64 views

Selecting polygon feature classes with one record in Oracle geodatabase using SQL query?

I have an Oracle Enterprise geodatabase with many feature classes. I would like a SQL query to find all the polygon feature classes with only one record in its table. So far, I can only query all the ...
0
votes
0answers
13 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 ...
1
vote
0answers
29 views

Poor performance when adding layer indexed ArcGIS Service layer to AGOL

My data sits in enterprise geoddatabases on Windows Server 2012, SQL Server manager. I often add ArcGIS Server Web services to my AGOL maps and they perform really well. However, when I add a ...
0
votes
0answers
8 views

Recalculate extent for versioned featureclass

I try to recalculate extent for FC (versioned). I deleted some objects with null geometry, or with wrong location and reconcile every versions. But I still cannot recalculete extent to new proper ...
3
votes
1answer
469 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
0
votes
1answer
21 views

Slow SDE Performance After Append - Geometric Network

I had an odd thing happen today, I do almost daily appends to our fiber network (fiber, splices, etc) and usually, it goes smoothly and with no complications. For some reason, I had an Append stall ...
0
votes
2answers
206 views

ArcSDE Enterprise geodatabase compress error

My organisation has ArcSDE enterprise geodatabase(ArcGIS 9.2) with MS SQL Server 2008 as DBMS. When I compress the geodatabase I am getting the follwoing error Failed to compress the database. ...
1
vote
1answer
130 views

Having multiple (seperate) Attachment Tables related to one feature class

Is it possible to have multiple attachment tables related to one feature class? The purpose is to only show specific attachments at certain times. We are trying to only show pertinent attached files/...
1
vote
1answer
274 views

Change Version Option Grayed out in ArcGIS Pro

I am experimenting with versioning data from an SDE database in ArcGIS Pro. I able able to create a new version, no problems, but when I go to change the version in the Data Source tab on the Contents ...
0
votes
1answer
14 views

Converted timezone does not display properly in ArcMap

(Oracle 12c geodatabase) I have a view that converts a UTC timestamp to Eastern Time using the from_tz function: create or replace view test_vw as ( select cast(rownum as number(38,0)) as ...
1
vote
1answer
31 views

ArcPy UpdateCursor: How to find specific row index of dictionary key/value difference?

I have a Python script that hits a REST API and grabs attribute data for rooms in buildings from an IBM Tririga DB. I have an Enterprise geodatabase rooms feature class populated with these same ...
0
votes
1answer
71 views

Projecting features to Enterprise Geodatabase in Oracle gives ERROR 000210: Cannot create output

I am trying to project features from a geodatabase and write into an enterprise geodatabase connection. I have permissions to create data and the name I am using also works, but I keep getting error: ...
7
votes
1answer
765 views

Calling Python through BAT for Scheduled Task

I'm using ArcGIS 10.1 and setting up some scheduled tasks to run on our server. I am calling a python script in a .bat file. When it runs, the connection to our SDE database is "invalid" or do not ...
3
votes
1answer
1k views

ArcPy not executing CopyFeatures_management to write feature class to ArcSDE geodatabase [closed]

I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of them....
5
votes
2answers
808 views

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

I'd like to set up a database environment at home that mimics what I have in the office (Oracle enterprise geodatabase/ESRI's st_geometry). I want to do this for spatial database training purposes in ...
1
vote
2answers
39 views

Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?

I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Reason: So that I can do linear referencing ...
3
votes
1answer
835 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
0
votes
1answer
259 views

How can I set sde object id from QGIS

I have connected a geodatabse that was created by ArcGIS. My geometry type is PG_GEOMETRY. I can connect the database in QGIS and add a feature table as a layer. When I create new spatial data in this ...
0
votes
1answer
58 views

SDE to CSV slow transfer speeds

I'm trying to move a feature class on our network SDE that's made up of polylines as a CSV file to the local machine (or fileGDB but slow speed seems to be the theme regardless of output format) ...
0
votes
2answers
61 views

Convert X & Y columns to a SHAPE column (using a method that would perform well in Portal)

I have a non-spatial table in an external system. The table has X & Y columns. The table will be synced to an Oracle 18c/10.7.1 geodatabase table or FC (via the ArcGIS REST API). There will be ...
1
vote
1answer
714 views

Editing ArcSDE Oracle spatial view

Can you edit an ArcSDE Oracle spatial view? By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as ...
0
votes
0answers
26 views

Getting SQL explain-plan for ArcGIS Map service

My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse. I'm having some performance issues with the layers/views in the map service. I want to ...
0
votes
1answer
82 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
5
votes
1answer
5k views

Debugging ERROR 000464: Cannot get exclusive schema lock?

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
10
votes
1answer
13k views

Creating 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 ...
0
votes
1answer
75 views

Selecting the SHAPE column in Toad

I've noticed that SQL clients select the SHAPE column from SDE.ST_GEOMETRY in different ways: select shape from roads Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,NULL,...
0
votes
1answer
152 views

Porting existing MSSQL database to ArcSDE

I have an existing MSSQL2008R2 database with views each containing a single geometry field along with a big number of "attributes". I would like to be able to do INSERTS, UPDATES, and DELETES on ...
1
vote
1answer
52 views

Converting ArcSDE point data from image to MSSQL geometry

I have a bunch of points in an SDE table which is currently stored in an MSSQL database. The full entry is below, while the data i'm trying to convert from binary to geometry is: ...
3
votes
1answer
124 views

Seeking publicly available ArcSDE Servers to use for developing client applications

I have been asked by our client if I can add the ability to connect to instances of ArcSDE servers from our desktop application. I am sure that we can do this a number of different ways, what I was ...
0
votes
1answer
171 views

ArcObjects(Java) - register table to geodatabase ESRI 10.3

We are in need of connecting to the Oracle SDE schema for registering Tables to the sde schema using only ArcObjects(Java) is it possible to do that with no dependency. Assume the geodatabase was ...
0
votes
1answer
153 views

Create feature class with ArcObjects in SDE geodatabase returns No editable Layer

I Want To create Feature Class in an enterprise geodatabase with ArcObjects. This is the small part of the our plugin. In our case, we want to Create Feature Class in the database Identical to the ...
4
votes
1answer
43 views

Limit users' editing privileges by attribute and role

I have a feature class in an Oracle 12c geodatabase. The feature class has a type column. The column has a coded domain. I would like to limit user's ability to edit the features based on the type ...
1
vote
0answers
25 views

Pre-populating list in Survey123 using SQL Server column

What I currently have is a Survey which enters the data collected from the survey in a SQL Server table, I'd like for one of those columns in that table to become the choices in another survey. If ...
2
votes
1answer
104 views

Get midpoint of SDE.ST_GEOMETRY polylines?

I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1). I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
0
votes
0answers
35 views

Select domain's last update date

I have tables in an Oracle 18c GDB that I integrate to a work order management system. I create views on the tables to translate the data. For example, I translate codes to domain descriptions. I ...
3
votes
1answer
666 views

Overwriting files in ArcSDE with ArcPy gives ERROR 000601

I'm having a great deal of difficulty overwriting files when using ArcSDE. The usual 'arcpy.env.overwriteOutput' method doesn't seem to work. When I run this script: import arcpy from arcpy import ...
1
vote
1answer
73 views

Use SDE.ST_GEOMETRY functions in a custom function

I have a dummy query where I generate an SDE.ST_GEOMETRY point: select shape as srid_test from ( select sde.st_geometry ('point (10.01 50.76)', 4326) as shape from ...
0
votes
1answer
119 views

With in Version Difference (DifferenceTypeUpdateNoChange) how to pass IQueryFilter in ArcObjects

I want to know only real shape edits between 2 versions. How can I pass iQueryfilter to DifferenceTypeUpdateNoChange? public void DifferenceTypeUpdateNoChange(ITable sourceTable, ITable ...
3
votes
0answers
114 views

Arcpy 'Append_management' much slower than ArcMap Tool?

Basically I have a script that grabs data from a web service, parses it, stores it in an intermediary local fgdb, then appends that data to the feature class in the enterprise gdb. The portion of the ...
0
votes
0answers
17 views

Select list of tables and feature classes that have subtypes?

I have tables and feature classes in an Oracle 12c geodatabase (10.7.1). I would like to generate a list of tables and feature classes that have subtypes defined in them. Is there a way to do this ...
0
votes
0answers
27 views

Creating database connection using ArcCatalog

I'm using ArcCatalog 10.2.2 which is installed on a Windows 2019 Server OS. I'm having trouble creating a database connection. Usually this is a very straight forward process. Put in the server name ...
2
votes
0answers
40 views

Duplicate Global IDs within same feature class

I received a geodatabase from a contractor and I observed there are multiple feature classes with column of Global ID type. These Global ID type columns, when I checked data i realized there are ...
3
votes
3answers
2k 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 | +----------...
0
votes
0answers
23 views

Creating features from related table

I have a M-1 related table (Sales) and a Polygon feature (Parcels) I want to create a point feature for the sales. If I join to the Parcels I only get the first sale to join but I need all of them. ...
1
vote
1answer
50 views

“Error 999999: Error executing function - Attribute conversion error” when running RegisterWithGeodatabase

I am using ArcPy to run through all of the spatial views in an enterprise GDB, register them with the GDB, and assign domains to the registered view. It runs great for most of the views in the GDB, ...
1
vote
1answer
409 views

Enterprise geodatabase on PostgreSQL backup and restore

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer. My backup command is as follows. host 5433 pg_dumpall -h localhost -p 5433 -U postgres -c -f "...
2
votes
1answer
929 views

Using sub-query in where statement of query in ArcGIS Map service?

I'm migrating my ArcGIS map services from version 10.0 to 10.2. It uses ArcSDE to manage spatial data in a SQL Server database. I was able to create the map service and everything seems OK. However ...
3
votes
0answers
1k views

Publishing Feature Services from spatial view on ArcGIS Server [closed]

I have a feature class layer and a handful of non spatial plain tables in a 10.1 ArcSDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as ...
1
vote
0answers
25 views

Backup of ArcSDE version

Is there any way how to backup particular version in ArcSDE geodatabase? I want to delete some versions from our geodatabase, but it would be great if I can create backup first and restore version ...