Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [enterprise-geodatabase]

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

4
votes
0answers
611 views

How to hide system tables of oracle in sde connection?

I connected to oracle 11g r2 with ArcGIS 10.2 using SDE connection. The connection is ok but in the connection i see system tables of APEX_030200 and other schemas. Same question is in the Geonet ...
4
votes
0answers
424 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
4
votes
0answers
259 views

Attaching old archive table (_h) back to original feature class on re-enabling geodatabase archiving?

I'm trying to figure out a way to update the schema of an archived feature class. There was a lot of discussion about this from 2012 and prior. https://geonet.esri.com/message/115340#115340 < -- ...
4
votes
0answers
184 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
3
votes
0answers
538 views

arcpy.ListFeatureClasses returns empty list

I'm working with SDE connection and want to find if a layer exists on a server. Code sample is: ws = r'Database Connections\Connection to sde-srv.sde' # second option to access connection file, same ...
3
votes
0answers
92 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
3
votes
0answers
197 views

Where do field aliases reside in an SDE database?

If I want to get field aliases for an SDE table through pure SQL, what table do I query? My geodatabase was created with ArcGIS 10.1 in an Oracle database.
3
votes
0answers
131 views

Any way to speed up an append of data to SDE database while it is still versioned?

My group works on a database and about once a month I receive data that must be appended. This process has required me to reconcile and post all versions to default. I then pull down the database ...
3
votes
0answers
783 views

How to correctly uncompress and re-compress an msd file using 7zip from command line

I am trying to uncompress and recompress both the msd and sd file so as to tweak some things I want. In fact I want to get inside the layers folder and for each layer.xml file to string replace the ...
3
votes
0answers
247 views

Which edition of ArcGIS for Server and which capacity level?

I need to define the edition of ArcGIS for Server product to invest for a small scale oil & gas company. What we need is to be able to: Work on a geodatabase with 2-3 concurrent desktop users ...
3
votes
0answers
47 views

Shoehorning hierarchial data into ArcSDE for MS SQL Server?

I've been tasked with creating a set of tables to store hierarchical data within an ArcSDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
3
votes
0answers
390 views

What are the pros/cons of using an MSSQL SDE Database rather than a File-gdb in ArcGIS Server

I have taken over an ArcSDE 9.3 Enterprise database setup which has around 80% of it´s vector data in an MSSQL SDE Database system and 20% in FileGDB on the application server. I am trying to ...
3
votes
0answers
585 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
3
votes
0answers
771 views

ArcGIS 10.1 & SQL Server 2012

We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012. Here are the things that we tried to fix the issue: - ...
3
votes
0answers
2k views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGIS 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got two layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
0answers
235 views

ArcSDE Database Refactoring Tools?

We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas. But we also work with GIS applications using esri ...
3
votes
0answers
1k views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
19 views

Editing Parcel Fabric in Versioned Geodatabase

We keep our parcel fabric in a SDE database with an intermediate staging version that multiple users post changes to from their own personal edit versions. We're able to edit the parcel fabric ...
2
votes
0answers
32 views

ArcMap Date values lose precision after copying feature class from fGDB to SDE GDB

I have some data in a file geodatabase feature class including some date fields. The precision on the date fields is to milliseconds and this is important. When I copythe feature class from the fGDB ...
2
votes
0answers
49 views

Copying/Inserting features AND user-defined Attributes as input to existing feature class in SDE using ArcPy?

import os, arcpy, zipfile, glob # INPUT ZIP FILE infile = arcpy.GetParameterAsText(0) path = "D:\Database_Connections" NAME = arcpy.GetParameterAsText(1) CODE = arcpy.GetParameterAsText(2) SOURCE = ...
2
votes
0answers
113 views

arcpy feature class to feature class error going from enterprise GDB to FGDB

I have a simple python script that was working fine for copying data from an SDE enterprise database connections to a FGDB. import os,sys,arcpy arcpy.env.overwriteOutput=True base_layers=r'Database ...
2
votes
0answers
741 views

SQL Server 2014 Failure to access the DBMS server 08S01

After upgrading our esri sde database from SQL Server 2008 to 2014 I am experiencing issues when overwriting some of our larger datasets. After some amount of time the overwriting process abruptly ...
2
votes
0answers
172 views

Importing raster dataset in ArcSDE/PostgreSQL/Postgis database useable in QGIS and ArcGIS?

I want to import a raster dataset in my database (PostgreSQL 9.4, Postgis 2.1), the catch is that I also want the raster to be viewed in QGIS via a Postgis connection. Importing feature classes in ...
2
votes
0answers
48 views

Loading layer from ArcSDE for SQL Server Database using PyQGIS?

I am use this code to load a layer from ArcSDE SQL Server database, but it only loads a table. uri = QgsDataSourceURI() uri.setConnection("localhost","", "arcsde", "sa", "****") uri.setDataSource('...
2
votes
0answers
41 views

No data found error when reconciling version in sde

I got an error when reconciling a version in the sde database and it seems sde cannot find the data in one table with a specific STATE_ID (for example STATE_ID = 12345 for table abc). In the delta ...
2
votes
0answers
130 views

Can shp2sde on ArcSDE 9.3 server operate with SDE 10.3 database?

We have 2 servers running ArcSDE 9.3, and one Oracle database at SDE 9.3. Only one of the ArcSDE 9.3 servers is to be upgraded to ArcSDE 10.3, and the Oracle SDE database will be migrated from SDE 9.3 ...
2
votes
0answers
165 views

Esri ST_Geometry function to make line from points

I'm attempting to write a SQL statement that joins two point feature classes, both in an Oracle ArcSDE geodatabase using ST_Geometry, and selects a line geometry connecting the points of each ...
2
votes
0answers
88 views

ArcSDE In a version geodatabase, snap tool does not work on a database feature class

I am setting up a series of tasks for technicians to complete. To finish the map template they will be working from, I must snap leak points to gas mains using the snap tool. However, after running ...
2
votes
0answers
172 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...
2
votes
0answers
134 views

Autonumbering using ArcGIS Web AppBuilder?

I work for a water utility division and we are using ArcMap 10.1 with attribute assistant. I used the AutoNumber method to auto increment and populate a field with the next highest integer. ...
2
votes
0answers
194 views

Different SRID problem

I have two geodatabases and I import a large number of tables from one to another by using ArcCatalog (ArcGIS 10.2). However the tables and indexes created on them are imported with different srid. ...
2
votes
0answers
157 views

Pulling ArcSDE feature classes from current map to fieldmapping as DETable?

I'm working with SDE layers in arcmap. trying to avoid pointing to the sde file itself. I've tried workspace.Pathname, it was empty for sde remote workspace. I've also tried IName from workspace, ...
2
votes
0answers
295 views

arcpy geoprocessing service with sde database produces no output url

I'm trying to use a geoprocessing script to clip some data and return to the user (via url) the path to a zip file with the results of the clip. I also need to connect to an sde database. I can get ...
2
votes
0answers
321 views

Update Attribute based on spatial location

I want to spatially (Spatial Join) update few fields, not all, from another feature class. Is there any way to select and update few fields instead of all the fields from the other layer and ...
2
votes
0answers
2k views

Update Existing Feature Class by Replacing Features with Updated Versions from a Shapefile

I have a feature class in a versioned ArcSDE geodatabase with archiving enabled. I receive regular updates for this data in shapefile format. I want to be able to replace any features that have ...
2
votes
0answers
314 views

Editing versioned view in ArcSDE 10.1 error

I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete ...
2
votes
0answers
845 views

Bulk insert into MS SQL Creating ObjectID's

I am running an ETL from a spatial view into publication database. The view has results in duplicate ObjectID's. I started working with the get_ids SP example from ESRI, but that seems to be built ...
2
votes
0answers
146 views

Cannot Save Edits to File Geodatabase Replica in QGIS 2.2

When trying to edit a File Geodatabase Replica in QGIS 2.2, everything works as expected until the user saves their edits. When pressing save, all edits revert back to their original state with no ...
2
votes
0answers
313 views

Issues importing feature class to SDE SQL Server 2012

I have received an error indicating there could be issues with my geometry when attempting to import a feature class into SDE. I ran the check geometry tool. No issues. I have removed all fields ...
2
votes
0answers
262 views

Data loss after compressing geodatabase in ArcSDE

I suffer sometimes from data loss after compressing ArcSDE geodatabase, this geodatabase contains versioned feature classes, so the compressing script reconciles and compress the geodatabase: # ...
2
votes
0answers
96 views

Can .Net version of ArcGIS Server expose Oracle spatial data without ArcSDE, or is this limited to Java version?

I'm planning a new deployment of ArcGIS Server and I want to avoid using ArcSDE if possible. My vendor requires that we store our spatial data in Oracle and we prefer to use Microsoft server ...
2
votes
0answers
65 views

How to know Who is reconciling the Version to DEFAULT(Parent) in Geodatabase

We have Public DEFAULT version and working Versions(Child) have been created directly from DEFAULT. We have also provided Reconcile-Post Option to group of Users placed at separate locations. Hence ...
2
votes
0answers
1k views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
2
votes
0answers
54 views

Is it possible to re-point operational layers ArcGIS Mobile projects v.3.0

We have an ArcGIS mobile project with two operational layers for data collection. The layers source from a GIS server on the cloud, running on top of an SDE. The database has a feature dataset, and ...
2
votes
0answers
553 views

View in ArcSDE 10.1 Problem

I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In ...
2
votes
0answers
396 views

How to compress enterprise geodatabase with stored procedure?

I'm looking for a stored procedure in ArcSDE for SQL Server which performs geodatabase compression to include it in our daily maintenance plan. Is there any such thing in ArcSDE 10.0?
2
votes
0answers
752 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
2
votes
0answers
115 views

Storing Shapes in database

What is more effective? Storing Shapes as shape column (http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/topology_basics.htm) in database? Or maybe store shapes in seperate tables ...
2
votes
0answers
72 views

ArcSDE Feature View in a GeoDatabase other than the Feature's Database

here is the problem I have been struggling with: We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
2
votes
0answers
259 views

Importing Rasters to ArcSDE 9.3.1 using sderaster

OK, I am trying to import a raster to 11g using the sderaster command. It is a stand alone jpg with a world file associated, and pyramids. Am I right in assuming I cannot import a JPG, I can only ...