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
0
votes
1answer
112 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 ...
1
vote
0answers
31 views

Checking which layer edited under specific version?

I have approx 100 feature class in SDE database. Out of this someone edited 10 in "test_1" version feature class(assumed). Now i want to know with script or manual which feature class is edited under "...
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 ...
2
votes
1answer
561 views

How to push newly added or updated domain values to ArcGIS rest service?

I'm currently using ArcGIS Server 10.4 for my REST service and ArcGIS Online. I have created a domain list and assigned it to a field. All of it works fine. I'm currently using Oracle for my ...
1
vote
1answer
57 views

Appending problematic polygon from File Geodatabase to Oracle ArcSDE using ArcPy?

I have a File Geodatabase that has some polygons in it. I am using append to copy them to an Oracle SDE 10.2 database. However there are some polygons that when imported have a null value for shape in ...
1
vote
1answer
131 views

What DBMS is used by ArcGIS Online? [closed]

I work in an Oracle shop. My I.T. department uses ArcGIS Online to host data for use in data collection activities. The data goes through a yearly cycle: Export from our Oracle enterprise ...
1
vote
0answers
249 views

Esri ST_Geometry functions too slow on Oracle

I'm writing an SQL statement to create a feature class and using st_geometry functions. But it's taking too long. So I begin the statement with a join, which is taking 150-200ms SELECT PRC.OBJECTID ...
0
votes
0answers
129 views

Recalculate XY Extent Option Not Available

I am unable to recalculate the XY extent of a feature class. I am attempting to do so within the Feature Extent tab within the Properties window accessed from ArcCatalog. The Recalculate button, ...
1
vote
2answers
662 views

Using SQL Server 2008 with ArcGIS Server 10.5?

I can't publish data from SQL 2008 Server/Database to our ArcGIS Server 10.5.1. Actually, I can't even register that database at all. Error message is below. Our ArcGIS Server, 10.5.1, has few other ...
6
votes
5answers
575 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 ...
1
vote
1answer
233 views

Deleting feature dataset containing network dataset from ArcSDE database?

I have trouble with deleting unwanted feature datasets from ArcSDE. Datasets contain network datasets which cannot be deleted either and I think they cause the problem. Options to delete or remove ...
1
vote
1answer
205 views

ArcSDESQLExecute seems does not work with startTransaction and commitTransaction

I'm doing some calcultations by ArcSDESQLExecute. The idea is to make some part localy and at the end copy table/featureclass to SDE and make some extra operations by sql. I want to put all sql to ...
1
vote
1answer
76 views

Production Mapping “Load Data” Tool having issues with SDE

I am attempting to use the Production Mapping tool "Load Data" to import data from many personal databases into a new SDE database (SQL server RDBMS). The schema between the PGDB's and SDE is the ...
0
votes
2answers
292 views

Workspace Error type- 000301 for reconcile version

I have a arcpy script to reconcile and post edits from 1 child to 1 parent 9the parent is not the default version). my code: import arcpy print "Preparing to begin Water Version Reconile and POST......
1
vote
0answers
137 views

ArcSDESQLExecute: Mismatching number of BEGIN and COMMIT statements

I have the following sql update query that I am using as part of a larger python script. It essentially takes data from one Feature Class (FC) to update a Versioned View of a different FC. ...
4
votes
2answers
336 views

How is the st_length function stored in an Oracle geodatabase?

How is the st_length function stored in an Oracle geodatabase? Is it in a: PL/SQL function Separate .dll library Somewhere else? I've noticed that the sde.st_length function works, even when the ...
0
votes
1answer
89 views

arcpy.da.SearchCursor feature orders mixed up in Oracle enterprise geodatabase?

Something very weird happen when I use a SearchCursor over a feature class in an Oracle Enterprise Geodatabase The order of the features in the SeachCursors changes depending of the field_names ...
0
votes
1answer
224 views

How to Connect to .geodatabase Replica Created File by ArcMap

I am able to create Two Way Replica from ArcGIS Server 10.4.1 which has a Feature service containing only one Feature Class( Transformers feature class) and I am getting a file like _ags_data{...
1
vote
1answer
421 views

Connecting to Oracle SDE using QGis 2.18 only seeing MDSYS

I am trying to add a layer using the Oracle connection in QGIS. I can connect when I test the connection. But what is returned is only the MDSYS owner (schema) and tables. There is one schema that I ...
2
votes
1answer
101 views

Using ArcGIS Tokens to visualize user authenticated data in Esri Leaflet?

I'm currently using Esri Leaflet with authenticated user services. Authenticated services are set up and work fine for displaying geographic data after login, however, I want to create a dashboard ...
1
vote
1answer
11k views

Python Script to generate log files with time and date and output events and error messages to the log files [closed]

I am writing a python script to reconcile and post my user version edits to a QA/QC version and then finally to the SDE database, the script will also go further to compress, analyze and index the ...
3
votes
0answers
105 views

Importing PostGIS polygon to Esri has negative area and results in null geometry? [closed]

I have data in PostgreSQL with PostGIS that seems fine. I am trying to 'copy' that in to ESRI ArcGIS. I have 4 test rows, 3 import fine. I've also modified a jsfiddle that I found and now has the ...
0
votes
1answer
153 views

How To Publish A Per Replica Enabled Sync Model Feature Service in ArcGIS

I have published a Feature Service (Sync Enabled) to our ArcGIS Server but I am only getting PerLayer Sync Model in the service but I need to have Sync Per Replica Instead. like I didn't see any ...
1
vote
0answers
43 views

Cannot connect to current version of enterprise database (PostgreSQL) through PHP

Very new to PHP, and working on a simple edit page. I'm connecting to multiversioned Postgresql database that I set up in ArcMap using a PHP/HTML file. I'm using the pg_connect command with host/...
0
votes
1answer
44 views

Enterprise Database Workflow with Online Mapping

We bought a trimble units for our operators to collect data out in the field using Collector. We currently have ArcGIS Server 10.3.1 with SQL Server 2012 setup on one of our servers. Our server ...
1
vote
0answers
38 views

SQL Server: Physical Memory and Arc Cursors

I implemented a script recently that uses an update and search cursor on a large feature class database of over 20,000 records. This script runs nightly. This is an SQL Server database with an ArcSDE ...
1
vote
1answer
130 views

Working on databased-stored-geodatabase with a ArcGIS for Desktop standard license?

I'm looking to improve my GIS capabilities within ArcGIS for Desktop environment: I want to work with real geodatabase that is stored on a Microsoft SQL Server (SQLEXPRESS) and to have all abilities ...
3
votes
1answer
164 views

arcpy.mapping.ListLayers returns inconsistent dataSource properties

ArcMap 10.3.1 It seems that the layer object returned by arcpy.mapping.ListLayers will have a full .dataSource property only in a brand new MXD. After changing the target version in the TOC, the same ...
1
vote
0answers
37 views

Why do the values of fields change after choosing unique identifer , SDE

I have a large dataset table from an SDE (SDE is the term my company uses to refer to this .under its properties (Oracle Enterprise Geodatabase). When initiated adding the table dataset to my ArcMap....
-1
votes
1answer
505 views

Unable to post edits to the default database when default version access is “protected”

Users unable to post edits to the default database when set the default version access is “protected”. In the past the default version was publicly accessed, and users can easily the users can use “...
4
votes
1answer
315 views

FME Error when writing to relationship class in ArcSDE Geodatabase writer type

I'm working in the FME workbench through ESRI Data Interoperability extension (ArcGIS 10.4.1). I'm writing to an SDE geodatabase with relationship classes established. When attempting to setup the ...
1
vote
0answers
132 views

Can two feature classes share geometry and have different attributes with ArcGIS Desktop?

Is there a way for two feature class (say parent and child) to share same geometry shape but have their own set of attributes? Features created or updated on parent feature class transfer its geometry ...
0
votes
0answers
41 views

Update service based on enterprise database

So I have an enterprise database on SQL Server which contains a feature class (only points) I add this feature class to a new ArcGIS Desktop project, so there is only this layer in the project. I ...
1
vote
0answers
346 views

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

I'm attempting to publish a feature service to ArcGIS server. I'm running PostgreSQL and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
0
votes
2answers
255 views

Python Script updating default version and child version simultaneously

I am writing a script to auto update attributes for several FCs in my enterprise SDE. I am testing the script and there are no processing bugs however there is strange behavior. When the script ...
1
vote
1answer
199 views

Connect to remote database with arcpy

I'm trying to access a database located on a remote server. I used ArcMap "Create Database Connection" tool on my computer to create a SDE file and I want to use a script to add some data to a table ...
0
votes
1answer
91 views

The size of mdf file is much bigger than its gdb file

The size of mdf file is much bigger than its gdb file. As all the content of mdf file is exported (or imported) to a gdb, the size drops dramatically. The size of mdf is 8GB while its corresponding ...
0
votes
2answers
1k views

ArcSDESQLExecute: How to return column names from queries?

I have an ArcSDESQLExecute python script: import sys import arcpy arcpy.env.workspace = sys.path[0] egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\Connection1.sde") sql_statement = """ ...
0
votes
0answers
84 views

Disabling Login Window on ArcMap?

I would like to know how to disable the login window [PICTURE A] when I start ArcMap ? In the code I am starting ArcMap, but then I get prompted with username and password dialog. How can I disable ...
0
votes
0answers
50 views

View number of edits made in an Enterprise GDB?

I would like to see the total number of edits made in my Default.SDE before the reconcile/post/compress process. I know you can view the number of edits made in versions with the Version Changes tool ...
1
vote
1answer
880 views

Why does Arcpy script to copy Enterprise geodatabase to gdb fail ERROR 000260 only on Facilities Dataset

Using a script that I found on Stack Exchange, I am able to replicate everything in my enterprise geodatabase to file geodatabase except the Facilities dataset. Can anyone help with why only the ...
1
vote
2answers
739 views

Referencing Enterprise Geodatabase feature classes from ArcPy with ArcGIS Pro?

When using ArcPy with the ArcGIS Desktop (10.4.1) architecture I am able to set a variable to a feature class and make a feature layer from it using the code below: rock_unit_table = "Database ...
3
votes
1answer
199 views

Error occured during an attempt to connect 10.1 SDE geodatabase on SQL Server from ArcMap 10.5

I have an SDE geodatabase created and running in version of 10.1 on SQL Server 2008. I was trying to connect to it via an SDE connection file from ArcMap 10.5. An error was thrown out as below while ...
1
vote
1answer
743 views

Using arcpy.da.Editor?

I am working with copies of feature Datasets that come from a versioned SDE. The copies are in an un-versioned 'development' SDE. I am attempting to do a field calculation on a single feature class ...
1
vote
2answers
509 views

Enabling Enterprise Geodatabase in BigSQL Postgres 9.5.x install and ArcGIS Server/Desktop?

I have followed Esri's ArcGIS 10.5 documentation multiple times over: http://desktop.arcgis.com/en/arcmap/10.5/manage-data/gdbs-in-postgresql/setup-geodatabase-postgresql-windows.htm Every time I try ...
1
vote
0answers
342 views

ESRI Table error: does not exist but it does exist in GDB

I am attempting to iterate through all tables in a Enterprise GDB and get all values in second column but I am getting an IOError error: processing... SJLU.FIRE_HYDRANT_PIPE_DIAMR_LK_MV Traceback (...
5
votes
3answers
2k views

ArcMap Append (Data Management) Tool is not working correctly

Software version: ArcMap 10.5 I am attempting to append data from a Shapefile into an existing SDE Geodatabase feature class using the Append (Data Management) tool. The tool runs, and the results ...
1
vote
0answers
120 views

Importing domains to ArcSDE?

Is there a way to import a geodatabase into a sde on the server and keep the sde domains, while adding the new geodatabse domains?
7
votes
4answers
1k views

Restricting values to domain codes (beyond attribute table)?

Geodatabase fields can be assigned domains. ArcGIS Desktop uses the domains as lookup tables (a.k.a. validation tables). When users edit data in the attribute table or attribute editing window, the ...
2
votes
2answers
2k views

Set workspace to SDE version using ArcPy?

My company uses a versioned SDE database to perform edits, update features, etc. I am working on a script that would inevitably update features and would like to set the environment to a specific ...