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)

1
vote
0answers
3 views

Converting standard to feature linked annotation?

Is there a way in ArcGIS 10.2.2 & ArcSDE 9.3 to convert standard annotation to feature linked annotation?
0
votes
1answer
24 views

Repair/Check for empty geometry in SDE?

I understand that the standard validation/repair tools are not for use with SDE's and that ESRI needs to fix this, but are there work-arounds for at least checking where there might be empty geometry ...
1
vote
0answers
12 views

ArcSDE PostgreSQL configuration parameters for Spatial Index?

I wonder why there is not any configuration parameter (DEFAULT Keyword) for spatial indexes in Arcsde for postgres. In ArcSDE for Oracle we have S_STORAGE,S_INDEX_SP_FID,S_INDEX_ALL parameter for ...
4
votes
2answers
771 views

Calculate Field based on field value in a second table

I have a table in a MSSQL Server Enterprise SDE database. I need to join a table from a MS SQLExpress Workgroup SDE database and then calculate 11 fields in the Enterprise table based on values in ...
0
votes
1answer
32 views

select by location point in polygon with sql query

I have 2 tables table a this one a polygon layer with 10000 records table b this one a point layer with 600000 records in postgresql geodatabase i select a polygon feature with the query by input ...
2
votes
2answers
1k views

Connecting Desktop to SQL Server 2012 SP1 via ArcGIS Server 10.1 very slow?

We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
0
votes
1answer
20 views

Transforming takes long time with st_transform

I have two shape files contains considerably large data. I exported them to my geodatabase(using arccatolog), which takes 2 days. The problem is their srid must be changed. So i tried creating new ...
2
votes
1answer
142 views

Choosing specific ArcSDE version to create replica geodatabase from?

I'm trying to automate the process of exporting a replica geodatabase using the geoprocessing tools and eventually a Python script. I can't figure out how to create the replica from a specific ...
0
votes
1answer
20 views

It possible to query/convert LONG RAW (SDEBINARY) from SQL?

Curently we have ArcSDE 9.3/Oracle10, and layers in SDEBINARY. It is possible to make queries with SDE.ST_GEOMETRY or SDO_GEOMETRY commands ?
1
vote
1answer
316 views

Expecting ArcSDE service in Windows services?

I've been thrown into learning how ArcSDE and ArcGIS Server work. I'm trying to start a service using the default esri_sde on port 5151. I put it in both the ArcSDE and windows service files. When ...
2
votes
1answer
1k views

Deleting SQL Server database in order to delete ArcSDE geodatabase?

I'm new to this ArcSDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the ArcSDE geodatabase. Is it as easy as right clicking on the database in ...
0
votes
1answer
56 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
44 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
93 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
1k 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
262 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
22 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
23 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
68 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
154 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
194 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
54 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
42 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
76 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
35 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
241 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
51 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 ...
1
vote
1answer
16 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
151 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
60 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
133 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
83 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
27 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
279 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
172 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
400 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
92 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
433 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
37 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
40 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 ...