Questions tagged [enterprise-geodatabase]

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

259 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
160 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. ...
1
vote
0answers
46 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/...
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
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
vote
0answers
144 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 ...
1
vote
0answers
389 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 ...
1
vote
0answers
400 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 (...
1
vote
0answers
147 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?
1
vote
0answers
537 views

ArcCatalog open sde geodb fails: “possibly sdehome/temp is full”

I'm trying to open a connection to an sde geodatabase with ArcCatalog 10.4.1 that was previously working. But now I get the error: "possibly $SDEHOME/temp is full" and ArcCatalog crashes. Does ...
1
vote
0answers
170 views

Selecting records in SDE using table join in ArcPy

I am in the process of writing an Arc Tool that will create a point feature class in SDE from field data. The incoming data already has a UUID (in field [UID]) that is brought over with the incoming ...
1
vote
0answers
92 views

SQL trigger that dissolves feature class based on multilabel fields

I am about write an SQL trigger which dissolves a feature class based on 5 fields, I used to do this using dissolve tool in the Arcmap as the following screenshots: Now, I need this process to be ...
1
vote
0answers
26 views

Creating a version to host only proposed infrastructure, that is reconciled and posted when the work is completed?

I have come across a scenario where I have been asked to find a way to create a version that stems off of a DEFAULT version of ArcGIS Server and hosts only proposed infrastructure data. This is being ...
1
vote
0answers
241 views

SDE.ST_INTERSECTS fails to find point

The following query fails to find a point that is less than 3 meters from the buffered point: SELECT NODE_ID FROM ZLEVEL WHERE SDE.ST_INTERSECTS( ZLEVEL.SHAPE, SDE.ST_BUFFER(SDE.ST_POINT(...
1
vote
0answers
157 views

How do you remove the ArcSDE connection from an MXD entirely?

I want to remove all connections to the SDE from a number of MXDs that I am using. I have re-set the data sources in each layer in the MXD to a local gdb but still get prompted with the Database ...
1
vote
0answers
351 views

Fail to Copy and Paste feature class

I am trying to copy a polygon feature class from a sde geodatabase and paste it into a file geodatabase but got the message saying "Failed to paste XXX A row with this OID already exists". No same ...
1
vote
0answers
90 views

Why does an empty, non-spatial table get flagged as Is_Simple=False in an SQL query?

I've created an empty table in an Oracle geodatabase. It was created in ArcCatalog by using the catalog tree >> New >> Table tool. The table is registered with the geodatabase and is not registered as ...
1
vote
0answers
761 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
1
vote
0answers
37 views

bring back column info in sde descendant version

I have a feature class registered as versioned in sde with editor tracking turned on. In my edit version, I was updating one field for all records but forgot to turn off the editor tracking before ...
1
vote
0answers
155 views

One way Replica deleted feature not synchronizing when I synchronize

I have created one-way replicas from 50 geodatabases to one geodatabase (Arcsde. With PostgSQL 9.2) After that, I update my feature class in parent geodatabase, but when I synchronize the replica the ...
1
vote
0answers
132 views

Unable to add feature class based on database view in ArcMap

To solve Rendering features based on relationships using ArcGIS for Server?, we created a view in the database that joins the two tables together. That works fine. I see the feature class in ...
1
vote
0answers
20 views

Connect to certain timestamp for child version

In ArcMap you can connect either to a historical marker or to a specified timespan by changing the version within the subtab Historic. I am however not quite sure on which parent-version this new ...
1
vote
0answers
39 views

Successfully added a Database Server but nothing inside (ArcCatalog)

I'm just a newbie in using ArcGIS. I'm trying to create a Web editing application in ArcGIS Server Manager like this post does here, but after added a Database Server i realize that there is nothing ...
1
vote
0answers
426 views

'sdetable' is not recognized as an internal or external command

I try use arcpy.JoinField_management(inFeatures, inField, joinTable, joinField, fieldList) to join SQL server database tables to shapefiles directly, using an ArcSDE connection. The database ...
1
vote
0answers
337 views

Releasing all schema locks in ArcGIS GDB

We use ArcGIS 10.3 products (Server, Desktop) with Oracle database. Our problem is we can not make any schema changes because of shared schema locks unless we stop all services and kill all database ...
1
vote
0answers
103 views

FME: floating point precision issues (ArcSDE / FGDB)

I am working on a (generic) FME Workbench that clips and exports data from ArcSDE database into the File Geodatabase (FGDB) format. The SDE features are clipped using an AOI, that arrives in the ...
1
vote
0answers
57 views

Geoserver not displaying ArcSDE versioned table data as it is updated

Has anybody managed to get GeoServer 2.8 with the ArcSDE plugin (ArcSDE 10.0) to retrieve updates to data as soon as they are made when data is retrieved from a SDE view? The SDE view is in Oracle 11....
1
vote
0answers
80 views

ArcSDE post installation error?

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 I ...
1
vote
0answers
549 views

Registering database to ArcGIS for Server gives null error?

I'm trying to register a database to ArcGIS for Server 10.2.0 from the web server manager using sde file from ArcMap. The connection works fine in ArcMap. But when registering I'm only getting a "...
1
vote
0answers
201 views

How to reconnect Arc GIS Schematics diagrams to GIS data in another oracle/SDE

My problem: An Arc GIS Schematics diagram export with versioned oracle/sde GIS features can't be reconnected to GIS data on another oracle/sde instance. I'm working on a project where in the first ...
1
vote
0answers
81 views

Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases

So here's the situation - at the moment I am having a problem where the more feature classes I load into a ArcGIS 10.2 enterprise geodatabase in PostgreSQL, the slower the connection time becomes. I ...
1
vote
0answers
787 views

ArcGIS Versioning - Conflicts option greyed out / disabled

I'm relatively new to the world of Versioning and using SDE databases, and have come across a problem that I can't solve. Summed up - the Conflicts option/button is greyed out/disabled, and I know ...
1
vote
0answers
104 views

Why is arcpy ChangePrivileges_management adding a second feature class to map?

I am new to GIS and pretty new to python, so sorry if this is ugly code. I am creating a feature class in a postgres database if it does not already exist and the user wants it created. That works ...
1
vote
0answers
40 views

ArcSDE Enterprise Geodatabase - XML and Tolerance Issue

I set up an ArcSDE Enterprise Geodatabase in SQL Server 2012. I imported the XML file from the Utility and Pipeline Data Model without any modifications. I am now running into an issue: the XY ...
1
vote
0answers
47 views

Reviewing over 600 version conflicts?

I'm fairly new to working with versioned geodatabases and have found that one of my versions has over 600 conflicts which require review and replacing. I suspect that all objects will need to be ...
1
vote
0answers
280 views

Migrating ArcSDE data to Oracle Spatial?

We've got all the geospatial information of our company within an ArcSDE Database (over oracle Server): points lines polygons We consume these data with ArcGIS Desktop and with ArcGIS Server. We ...
1
vote
0answers
64 views

Can privileges be set to allow certain users read/write access to a protected version?

I have multiple versions of a database (some protected and some public). Would it be possible to allow some of the database users read/write access to the protected versions? I have read of protected ...
1
vote
0answers
60 views

In ArcSDE, SQL Studio Manager 2012, How to get pixel data using a point layer?

I was using 'where' and 'ST_Intersects' with polygon data to get values 'under' my point layer. Example: Select rd.[FORESTNAME] as Forest, Count(Distinct morel.[OBJECTID]) AS Observations From [dbo]...
1
vote
0answers
192 views

FME Writing metadata to ArcGIS Online

I am trying to figure out how to write metadata to ArcGIS Online Feature Service from ORACLE SDE and how to update the existing Feature Service metadata, using FME or other tools. I am able to read ...
1
vote
0answers
420 views

Exporting data from ArcSDE gdb atribute table to file or personal geodatabase?

I'm currently learning GIS and I'm working on a project, I'm doing my own research and trying to accomplish the following with or without Python: Export data from an ArcSDE geodatabase attribute ...
1
vote
0answers
202 views

Importing XML workspace file without losing z and m parameters?

I am attempting to import an XML Workspace document (database schema) from a file geodatabase into an SDE geodatabase sitting on top of Postgres. The steps I am taking are: In ArcCatalog - right-...
1
vote
0answers
797 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
1
vote
0answers
833 views

Need to connect ArcSDE dataset using QGIS Desktop and Oracle database

I am working in GIS domain using ESRI technology. I want to use QGIS desktop to access ArcSDE dataset from a local machine. I have already installed Oracle Client 10g and QGIS Desktop 2.8.1 through ...
1
vote
0answers
100 views

How to recover from deleting the symbolid of a arcgis annotation feature class?

I have arcgis 10.1 (arcinfo license) and I am using a versionned database (arcsde) with SQL Server. I have accidentally deleted the symbolid of one of my annotation feature classes. All annotations ...
1
vote
0answers
330 views

ArcSDESQLExecute to query and update from multiple SDE Databases

I am trying to use ArcSDESQLExecute to return the results of a join and then write the return query into a Feature Class located in a different database. Using Microsoft SQL Server and Arc10.2.2 Is ...
1
vote
0answers
213 views

Using FME, Is there a way to transfer Metadata from an SDE FeatureClass to a Shapefile (shp.xml)

Is there a way to transfer, using FME, the metadata from an SDE featureclass to a shapefile?
1
vote
0answers
337 views

Get Feature Count

My situation is as below, Database 1 : SDE database.Topo Feature Class : 170 Database 2 : SDE database.AOI Feature Class : 1 I want to get feature count of 170 feature classes base on selected AOI ...
1
vote
0answers
68 views

Verify Geodatabase Integrity?

I'm regularly backing up an ArcSDE Geodatabase. The backup is done by using arcpy.Copy_management to copy datasets from SDE to a local File GeoDatabase. How can I verify the integrity of the back up ...
1
vote
0answers
48 views

Using REST Services acquiring limited data from DataBase like LayerDefinition

I am working with ArcGIS Server 10.2 and MS SQL DB. I have a requirement in which i need to retrieve limited data using a query from a bulk data using the same Map Service REST URL which can give me ...
1
vote
0answers
160 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...
1
vote
0answers
250 views

Layers are not visible after restarting GeoServer

I have ArcSDE connection on GeoServer. In order to make GeoServer faster I have restarted it. After restarting my published layers (datas) are not visible. When I publish this layer again, GeoServer ...