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)

2
votes
1answer
36 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 ...
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
21 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: ...
0
votes
1answer
49 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
60 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 ...
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 ...
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, ...
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: ...
2
votes
2answers
49 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 ...
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 ...
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 ...
0
votes
0answers
53 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 ...
0
votes
0answers
47 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 ...
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
2answers
81 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
1answer
84 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 ...
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
32 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
41 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 ...
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 ...
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
38 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 ...
0
votes
1answer
43 views

Geometric Network Build Error

I'm trying to create a geometric network of pipes, sewer structures (points) and manholes (points) inside a of an SDE. I can create the network in a file geodatabase but when I try creating it inside ...
0
votes
0answers
21 views

Map Control Didn't Show Editing Result

I have created an application with data from SDE Geodatabase (Oracle). I've registered it as version without tick on the option to move edits to base. Anyway, in my application there is a part where ...
0
votes
0answers
66 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 ...
2
votes
1answer
78 views

ERROR 999999: Error executing function - Failed to execute (CopyRaster)

ERROR 999999: Error executing function Unexpected operation No spatial reference exists This is a fragment from my log report: ERROR 999999: Error executing function. Database user ...
1
vote
0answers
22 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 - ...
2
votes
0answers
28 views

How to re-register a one way replica geodatabase

Long story short. Arcmap crashed during one of my regular synchronizations of a replica geodatabase created through one-way replication checkout. Upon reloading it seems to have unregistered the ...
0
votes
1answer
67 views

Using pymssql to create a table using python ArcMap 10.3

I am using ArcMap 10.3 have a my data in a geodatabase (MS SQL Server Express) and I am trying to write a python script that does a bunch of spatial and non-spatial data manipulation. I need to dump ...
2
votes
1answer
59 views

Remove/Hide SHAPE.STArea() & SHAP.STLength() fields

Is there a way to hide SHAPE.STArea() & SHAP.STLength() fields in feature classes in an SDE GDB? I'm working with a client who says that these fields were not in any feature class in the GDB and ...
1
vote
1answer
64 views

ArcGIS Terminology and Data Types

What is the difference between a "Feature Class" and an "SDE Feature Class"? Or a "Table" and an "SDE Table"? When browsing data in ArcCatalog, hosted on the same enterprise gdb, I see these data ...
0
votes
0answers
34 views

inherted .net extension not connecting to arcSDE in ArcMap10.2.2

I have a custom .net extension tool that is supposed to connect to a file geodatabase or SDE (SQL Server). The SDE connection fails to recognize it as valid. The file geodatabase connection works just ...
2
votes
0answers
42 views

Different SRID problem

Hi here is my problem, I have two geodatabases and i import a number(large) of tables from one to another by using arccatolog(ArcGIS 10.2). However the tables and indexes created on them are imported ...
0
votes
0answers
20 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
1
vote
0answers
69 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 ...
0
votes
0answers
102 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 ...
0
votes
2answers
73 views

Privileges for Oracle users created using the ArcGIS Create Database User tool

I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user. I've created a new user named GFPTest using the Create Database User ...
1
vote
0answers
26 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
1answer
50 views

How to change data source of table using arcobjects

Cross post from: https://geonet.esri.com/thread/125010 Does anyone know how to change the data source of a table using arcobjects? I know it can be done with arcpy, but I'm using C#. I've managed to ...
1
vote
1answer
49 views

ArcSdeSqlExecute ArcSDE Error -65

I am trying to Select certain fields, resulting from a join using ArcSDESQLExecute but encounter the following error when I try to include the Shape field: AttributeError: ...
1
vote
0answers
50 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
1answer
40 views

What is the proj4 for World Behrmann (54017)?

I have this in an old SDE database: ...
2
votes
1answer
76 views

Database connection times - PostGreSQL vs Oracle (ArcSDE)

I have 2 SDE instances. Both have the same amount of data (2000 datasets both raster and vector). One is PostGreSQL 9.2 with ArcSDE 10.2.1 One is Oracle 11g with ArcSDE 10.2.1 So basically the ...
1
vote
0answers
35 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?