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
75 views

Problem with double field type in postgis database

I have connection to PostGIS spatial database through ArcSDE, and all double type numeric fields are cutting numbers after comma. Does anyone know how can I fix this problem?
0
votes
2answers
78 views

database using arcgis [closed]

i want to know, can arcgis software do the database such as oracle or ms access?? for example, create own database and form?? and can the database in arcgis read the programmer program such as from ...
2
votes
0answers
127 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
1answer
553 views

Convert from Geometry to SDE Binary storage type in SDE database

We have been battling performance issues between SQL 2012 and ArcGIS 10.1. One of the most common solution is to convert to SDE Binary storage. We know that this storage type is not as dynamic as the ...
1
vote
1answer
330 views

Why does FeatureClassToFeatureClass field mapping create shapefile with no attribute values on local machine from ArcSDE?

I have inherited taking over and supporting and ArcSDE GIS database. We have a process that we must do every 6 months to export certain features from the ArcSDE database into shape files so that they ...
3
votes
1answer
517 views

How to edit PostgreSQL geodatabase table using ArcPy?

I'm trying to update a table using a python script and it's not working. The table resides in a postgres geodatabase and is versioned. I have also verified my user permissions (I'm the admin). The ...
0
votes
0answers
288 views

post instlacion ArcSde 10 "error creating Arcsde direct Connection (-9)

I installed SQL sever 2008'm doing the post installation used ArcSDE 10 these are the steps I am doing in post installation of ArcSDE 10 complete installation. SDE Schema. put the name of my ...
1
vote
0answers
59 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
4
votes
1answer
200 views

Does ArcSDE require Oracle Spatial rather than Oracle Locator licensing for any functionality when working with SDO_GEOMETRY?

I'm looking for specific information on whether the ESRI suite requires Oracle Spatial for any of the functionality, or if Locator is always sufficient for working with SDO_GEOMETRY objects? Do you ...
0
votes
1answer
59 views

How to store both fixed and variable attributes as a feature class?

I have a live data feeds as an XML file from the Internet. I need to use Python and ArcPy lib to store each feed as a point feature in a feature class of an ArcSDE datbase. The xml looks like: ...
5
votes
1answer
175 views

Is there a way to check if data was versioned using “move edits to base” option?

Is there a way to check if data was versioned using "move edits to base" option? Preferably through ArcGIS itself or using Python, but any way will work. EDIT Is there way to see if this box was ...
4
votes
1answer
127 views

ArcGIS Displays Wrong Date

I have a postgres database with a series of fields that includes a date field in MM/DD/YYYY format. Through ArcSDE it displays in Arc in a weird format with the wrong date and some made up time. When ...
2
votes
0answers
373 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: - ...
1
vote
1answer
86 views

Error in GUID fields using “Simple Data Loader”

I have a replicated table in my SQL Server (PE_AMB_ANP), that table has a field named "rowguid" (rowguid is auto generated) When I try yo load data, the field appear matched with 'none', but when the ...
3
votes
1answer
214 views

Moving Versioned Data between different geodatabases

Can you please let me know how to migrate feature class which is registered as version and archiving is enabled on it From: Database Environment: ArcSDE 9.3, RHEL 5, Oracle 11.2.0.2 To Database ...
1
vote
1answer
219 views

Registering a SDE Service in 10.1 with Command Line

I am installing ArcSDE on a new development box. I have executed the setup.exe, created an Enterprise database called "GDB123" and created a new sde service called "sde_123". I need some ...
4
votes
1answer
97 views

What maintenance should I do for PostGres database?

I'm getting familiarized with using PostGres for ArcGIS. I've only ever used SQL Server. I was successful in setting up an SDE database within PostGres 9.2, but I'm not sure what type of maintenance I ...
1
vote
1answer
111 views

Matching sde database port to FME Reader?

I had been trying to connect a MSSQL Server/SDE 9.3 to an FME (2013) Reader for 2 days until I noticed from an earlier fme project that each sde Database has a unique port number. I thought the sde ...
4
votes
1answer
152 views

Should slow refresh rate be expected while viewing 1000 points out of 100 million using ArcSDE/Oracle?

Is it normal to experience very slow refresh rate in ArcMap with 1000 points shown out of 100 million using ArcSDE/Oracle? I’am testing a setup with ArcSDE/Oracle database to contain geographical ...
1
vote
0answers
22 views

Fix broken SDE layers with Arcpy - unexpected error [duplicate]

We are in the middle of our ArcGIS 9.3 to 10.1 migration project and we have a lot of custom map documents (from different users) that among others, point to our current 9.3 SDE database. After our ...
1
vote
0answers
66 views

Problems with versioning

I have 5 PostgreSQL_PostGIS database in my company and i conneting on them through ArcSDE. Four of database work correctly, only with one i have i realy big problem. When i make two versions of ...
3
votes
2answers
482 views

Why unable to edit ArcSDE from multiple computers on LAN using custom ArcGIS Engine application?

I cannot edit an ArcSDE database from multiple computers on a LAN network using a custom ArcGIS Engine application, I have tried both versioned and non-versioned feature classes, but they cannot be ...
1
vote
1answer
1k views

Failure to Access DBMS Server Error - ArcGIS/Postgres

If connected to an SDE enabled Postgres database via ArcGIS (10.1) for a long period of time, maybe an hour +, I will often receive an error from ArcGIS stating "Failure to access the DBMS Server[my ...
0
votes
1answer
51 views

How can I list version name in my silverlight application?

I need to populate combobox with arcsde version name in my silverlight 5 application. Please give me some suggestions.
2
votes
1answer
329 views

gdal_translate produces tif with different colors as original

I am using SDE as my raster data source with the ultimate goal to tile this dataset: I am running the following gdal_translate command to generate the initial VRT: gdal_translate -projwin 390605 ...
0
votes
1answer
48 views

Poor Temporal Raster Performance over REST

When trying to consume temporal rasters (float values) served from ArcGIS Server over a REST endpoint, the results served up are "wonky". One or two time steps will deliver data as expected but in ...
1
vote
1answer
96 views

ArcSDE Java API: Find centroid of SeShape object?

I've inherited an ArcSDE 9.3 Java app that needs some fixing. The basic task is to find the centroid of a polygon retrieved from an SDE geodatabase, but lately it's been returning the 0th vertex ...
0
votes
2answers
132 views

ArcSDE 10.1 Spatial View with no records

I can create a spatial view and it renders fine in catalog and ags. But if i modify the sql OR if a situation arises that makes my view devoid of records then all of the sudden sde and ags get really ...
8
votes
1answer
206 views

How to perform Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...
2
votes
1answer
248 views

How to write an SQL query to select recently edited features with Editor Tracking enabled?

Conditions: ArcGIS for Desktop 10.2 and ArcSDE 10.1 Is there a way to select recently edited features using the automatically populated fields that Editor Tracking uses? The new Editor Tracking ...
1
vote
1answer
51 views

How can I avoid creating a new cursor object repeatedly while counting features in a large SDE Database?

I would like to get a script running much faster than it is now. The script completes on my machine in about 33 minutes. It generates a report that counts features with specific attributes in one ...
8
votes
4answers
1k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
1
vote
1answer
274 views

How can I use a sub-query in where statement of a query in ArcGIS 10.2 Map service?

I'm migrating my ArcGIS map services from version 10.0 to 10.2. It uses ArcSDE to manage spatial data in a SQL Server database. I was able to create the map service and everything seems OK. However ...
2
votes
2answers
158 views

Change SDE Version in ArcGIS JavaScipt API depending on connected user

I am programming for an web editing application with ArcGIS API for JavaScript. I've published a version of ArcSDE with Feature Acces and I need to know how can I change in the web application from ...
5
votes
1answer
221 views

How to build query expression to display text from one-to-many relationship in ArcMap?

I have two tables in an enterprise geodatabase stored in PostgreSQL and accessed via ArcSDE: parcel and person 1 or + parcel can have 1 or + person (relationship is pll_person) I can display all ...
2
votes
3answers
401 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
3answers
282 views

How to register as versioned using SDELayer?

This is the normal process using ArcCatalog : I want to automate this process using sdeLayer or any tools - does anybody have an idea as to how to do it? there is an application sdelayer ...
4
votes
2answers
586 views

Checking current user privileges for an SDE dataset with Python/arcpy

I am managing data distribution via an ArcSDE Oracle gdb to a number of users (schemas?), each of which can only have read only access to datasets they have requested access to, and have then been ...
4
votes
3answers
282 views

How to number polygons according to their spatial relationships?

I have, for example, this layer in postgresql (polygons): table : poly (objectid: integer, num: integer, shape: geometry) I want to enumerate the polygons from left to right and top to bottom ...
3
votes
3answers
350 views

Can ArcGIS Server be called ArcSDE? I'm confused about terminology

I'm confused about some ESRI terminology. If I have ArcGIS 10.1 Server installed and we use Enterprise geodatabases with versioning capabilities but we use direction connections does this have ...
0
votes
1answer
131 views

Problem with ArcGIS annotation

i have a problem with annotation (ok i will explain) : in database i have : parcelle : a geometry table that contain polygons personne : a table contain parcel's owners pll_personne : is the ...
0
votes
0answers
218 views

Nullable fields in feature service will not save with null values

I created my file gdb schema in Diagrammer, which included setting up several coded value domains, and applying them to fields in the feature class. All the fields have their Required property as the ...
2
votes
1answer
552 views

ArcGIS 10.0 get sde information out of .mxd

The overall goal here is to iterate through several directories of .mxd files and document which SQL Server instance of SDE they are pointing to, with the database name and feature class names. All ...
2
votes
2answers
792 views

How to copy selected features from one sde to another using ArcObjects?

Assuming I have two SDEs or other datasources with the same datamodel. One contains features the other one is empty. In ArcMap I have layers from both datasources in my table of contents. Now I would ...
0
votes
1answer
824 views

How to resolve ArcGIS for Desktop Error (SDE has lost its connection with underlying DBMS[ORA-03114:not connected ORACLE])? [duplicate]

How to resolve this issue when user leaves the system idle for one hour and again trying to connect Database, It encounters the Connection error message and then user should close the ArcGIS and ...
4
votes
1answer
249 views

How to populate SQL options for ModelBuilder parameter from ArcSDE feature class?

I am creating a very basic model tool for a class project and I am running into trouble getting the SQL values to populate. I have read the ArcGIS 10: How to populate SQL options for parameter in tool ...
2
votes
0answers
72 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 ...
1
vote
0answers
98 views

Why might ArcPy, TableToTable, MakeQueryTable and ArcSDE have performance issue in IDLE?

I have written a Python script tool to do: Make Query Table Table To Table (with fieldmapping). The code is nothing more than arcpy.MakeQueryTable("table1;table2;table3", ...
1
vote
1answer
418 views

Arcsde and Oracle on same machine but while creating a Enterprise Geodatabase giving TNS Error

I have Installed Arcgis Desktop 10.2 and Oracle 11G and Arcsde 10.2 and oracle Client When I am Creating a Enterprise Geodatabase it is giving me this error: ORA-12154: TNS:could not resolve the ...
1
vote
3answers
955 views

ArcGIS Copy Features tool extremely slow when exporting to ArcSDE?

I have about 10 points in a file gdb that I am attempting to copy over to an sde feature set. In arcpy and in model builder it takes about a minute to execute. Do you know of any tips to speed this ...