Use this tag for questions about the ArcSDE (Spatial Database Engine) component of Esri's ArcGIS for Server that is one way to enable access to spatial data stored in a Relational Database Management Systems (RDBMS).

learn more… | top users | synonyms (1)

0
votes
1answer
51 views

Reconciling version in ArcGIS for Desktop?

When I try to reconcile using ArcGIS for Desktop I got this message: the version could not be reconciled.the number of points is less than required for feature. What should I do? Thank you ...
2
votes
1answer
39 views

Full Text Search in ArcSDE

We have a quite large ArcSDE (~120 versioned feature classes & tables, 1M-3M records) which has Oracle or SQL underlying DBMS. This SDE is exposed through a MapService and we use ArcGIS JS API to ...
1
vote
1answer
291 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
0
votes
2answers
91 views

copy personal access geodatabase with realtionship classes to arcsde sql

how to copy personal access geodatabase with realtionship classes to arcsde sql.used simple copy paste and import ,but didn't get the relationship classes.error:unable to initialize weights in feeder ...
2
votes
2answers
2k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several featuresets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned. We have numerous non-GIS ...
5
votes
3answers
261 views

How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
0
votes
1answer
21 views

Changing ArcSDE connections number without SDE command toolkit?

In arcgis 10.2 is there any way to change the config properties and specifically the max connections of the sde without having to install and use the sde commands?
0
votes
0answers
22 views

Can't create ArcGIS feature class with PG_GEOMETRY keyword

I have enabled a PostgreSQL database as an enterprise geodatabase with ArcCatalog 10.3 (using server license file etc). When I create a new feature class with PG_GEOMETRY keyword, I get an error: ...
3
votes
1answer
1k views

Change ArcSDE data source for mxds in specific folder using ArcPy?

I've searched all the forums and help and have made progess but recently got an error that has thrown me for a loop - also some mxds are not being changed at all! What I'd like my code to do: Iterate ...
0
votes
1answer
63 views

How to disable spatial index creation by ArcSDE for Oracle Spatial

Working with arcsde 10.1 and oracle spatial 11g. I set the feature class in load_only_io before loading shape files. I am using geoprocessing tool (append) in arcgis to load shape file to ...
1
vote
1answer
151 views

Copying representation symbology from one ArcSDE version to another?

We are having problems with our representations when copying from an ArcGIS 9.3 database to a 10.0. Representation symbologies with dash patterns (dots, dotted lines etc.) are reset to default ...
2
votes
1answer
191 views

Join feature classes from two ArcSDE geodatabases with same schema?

I am working with two ArcSDE geodatabases -- one for test, one for production. They both have the same schema. I recalculated an attribute in the test environment and wanted to push that to ...
0
votes
1answer
50 views

How can I change my ArcSDE binary formatted data to MSSQL Geography or Geometry data types?

We are currently using ArcSDE 9.3 to store our Geodata. In a project which is currently being implemented, the software being used can access most data formats including the ArcSDE binary format ...
0
votes
1answer
40 views

address standardizer code in python for street featureclass

In my system I have featureclass Street and having fields. Featureclass : Street Input fields: NAME;STREET_PREFIX;STREET_NAME;STREET_TYPE;STREET_SUFFIX output fields: ...
4
votes
1answer
68 views

Which ArcGIS SDK to use ArcSDE SDK, ArcGis Runtime SDK, ArcObjects SDK?

I have a geodatabase on SQL Server 2008 R2 and ArcGIS 10.2.2 installed. Both are on my local computer. I will interface to a Delphi Application and my aim is to query some records/fields line by ...
2
votes
1answer
216 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
1
vote
0answers
34 views

why is my SDE feature class not showing up in arcmap [closed]

Just wondering if anyone has had a similar problem. We have a feature class on an SDE with about 1500 polygons. The attribute table says everything is there, but when we try to view it in arcmap, ...
1
vote
3answers
240 views

Arcsde - FME - import data

I have a problem with the import of data with FME 2012 and ArcSDE 10. After import, my data are not visibles in ArcMap or ArcCatalog. My layers are registered in ArcSDE. I found a solution: After ...
2
votes
2answers
50 views

how to create a new ArcSDE Service?

I need to create a new sde service with the command line for the first time with mssql on ArcGIS Server 10.0 so that 3rd party software can access it. Direct connect will not work unfortunately. As ...
0
votes
1answer
15 views

Converting ArcSDE to CAD using FME when blockreference involved?

I try to convert some lines from ArcSDE to cad by FME and I have set autocad_original_entity_type=autocad_lwpolyline and autocad_entity=autocad_line,I suppose they will be line but they have been ...
1
vote
0answers
29 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 ...
3
votes
1answer
149 views

ArcGIS 10.3 geocoder

I recently upgraded, desktop, server, engine and SDE to 10.3, and of course had to upgrade some other features and extensions. It seems that now that I've upgraded to 10.3 my new 10.3 geocoders will ...
0
votes
0answers
55 views

Problems with direct connection to ESRI Oracle db for 9.3.1?

I am trying to create a direct connection to ESRI Oracle database for version 9.3.1. When I try to connect I get this error: org.geotools.arcsde.ArcSdeException: Can't create connection to none for ...
5
votes
7answers
5k views

Troubleshoot editing features in feature dataset with ArcMap / ArcSDE Oracle

I am having trouble editing a feature class that is in a feature dataset. We have added just the single feature class as a layer in ArcMap and are using the "Start Editing" function on the Editing ...
1
vote
1answer
386 views

ODBC connection to ArcSDE table shows old version in ArcMap?

I use an ODBC connection to an ArcSDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL ArcSDE server and the connection info matches ...
1
vote
1answer
130 views

Arcpy ListFeatureClasses in same workspace differs when run from ArcMap VS IDLE

This Works The following python script works when connecting to my dev ArcGIS server, from both the ArcMap python window and the IDLE python GUI/shell running on my dev workstation: import arcpy ...
8
votes
0answers
405 views

What qualifications should auditor have to auditing GIS? [closed]

Background summary: Various systems are being audited and GIS is the next to be audited. The initial kick-off for the audit was a meeting between me and a single auditor. Initially, I thought it was ...
1
vote
2answers
82 views

Is it possible to consume ArcGIS Hosted Table into local or ArcSDE geodatabase?

I would like to publish a table to our ArcGIS Online (AGOL) organization account. Is it possible to consume hosted features in AGOL to a local db or ArcSDE database connection? By consume I mean ...
0
votes
0answers
54 views

Accessing Versioned data using database link

I have geodatabase on one Oracle server. The data is versioned. I am trying to access the versioned data from another Oracle server using a database link. While accessing the a feature class named ...
1
vote
1answer
26 views

Unable to execute a python script that was exported from ModelBuilder

I have a model that copies a single F.C form SDE geodatabase to a scratch geodatabase then copies it back with a new name to the same SDE geodatabase again. And this works perfectly form the model. ...
1
vote
1answer
276 views

Database Connections folder is empty when viewed with ArcGIS tool

I'm trying to create an ArcGIS tool which accepts an SDE connection file as an input. I made a new interface with an input parameter and set the type to Database Connections. When I open the tool and ...
2
votes
1answer
169 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
2
votes
2answers
172 views

Finding the Default version in a large linage tree

I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
0
votes
1answer
397 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
0
votes
1answer
85 views

Direct connection from geotools to arcgis 10.3

Is it possible to direcly connect to ESRI 10.3 database using geotools ? I use geotools 13.0 and have ESRI database set up on oracle. Previously I was able to connect to SDE using gt-arcsde-plugin ...
2
votes
3answers
431 views

Update license for enterprise geodatabase with GP/Python?

I am attaching dozens of database files to a SQL Server instance and then I have to run sdesetup command to update the geodatabase license by pointing to my ArcGIS Server license. I am trying to find ...
1
vote
0answers
33 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
1answer
39 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 ...
1
vote
1answer
56 views

migrate to Enterprise GIS

We have basemap with shape file, now we have purchased ArcGIS 10.2 with server and ArcSDE and Oracle. we want to establish Enterprise level so that multiple users can edit without overwrite the source ...
0
votes
0answers
29 views

Is a unioned feature class the fastest/best way to quickly get attributes from multiple feature classes at once?

I've been asked to create a feature class by unioning 18 polygon feature classes together, and retaining only certain attributes. The goal is to have a single feature class that can be queried once to ...
0
votes
0answers
25 views

Python script can't find custom module in ArcSDE

I've been working on a python script for some time. Its working well but I'm having trouble running it in SDE. My main issue is that the python script, when run in SDE, cannot find any of the ...
2
votes
0answers
33 views

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 < -- ...
2
votes
0answers
43 views

ArcSDE reconcile versions and keep edit version in its current state

Reconciling versions makes both target and source(s) point to the same state. I have an arcpy script that essentially will create a version from a parent of the db - in a state that is empty - adds ...
12
votes
5answers
7k views

ArcSDE connection limit exceeded

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
1
vote
2answers
2k views

Delete SDE feature class features with ArcPy

I'm working on a script that will empty my SDE database of all data. How would I go about deleting features from feature classes using ArcPy? I have an SDE connection created with a user that should ...
0
votes
2answers
57 views

Creating model to copy feature classes from ArcSDE to FIle Geodatabase?

I am trying to create a model in ArcGIS that copies the feature classes which are stored in SDE geodatabase “SQL” to file geodatabase “in order to sync my SDE data to FGDB“, here what is the best ...
2
votes
1answer
35 views

How can you tell which port number an existing Database Connection is configured for?

I have a database connection to a postgresql database on a non-default port, 5433. I specify TESTDB,5433 as the instance and I can connect with no errors. If I open that connection properties ...
1
vote
0answers
29 views

Surfacing data in ArcSDE enterprise geodatabases in Portal

Is it possible to use data from ArcSDE geodatabases (hosted in Oracle, in this instance) in Portal webmaps? I've been searching documentation and the internet for a while, and it's implied that it's ...
2
votes
0answers
39 views

Is it possible to replicate an SDE geodatabase including the archive tables?

I have a database in one location which I would like to replicate to another using one-way replication. In testing we haven't been able to replicate the archive tables, which is unfortunate because we ...
1
vote
1answer
251 views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with non-spatial Oracle tables. These tables have a field named 'objectid' because were created originally for inserting/updating records by using ArcGIS instead, not ...