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)

5
votes
2answers
389 views

Is it possible to force uppercase in a geodatabase string field?

I have certain string fields in my geodatabase tables with which I would like to enforce an all-uppercase rule. These fields are ones that do not lend themselves to domains (such as address fields). ...
5
votes
1answer
942 views

How to determine using Python whether ArcSDE table is registered with geodatabase?

In an effort to improve my Python skills, I am trying to build code to automate the Compress and Analyze commands for our SQL 2008 R2 SDE database (code below). The Compress code works as does the ...
5
votes
2answers
821 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 ...
5
votes
3answers
2k 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 ...
5
votes
2answers
608 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.
5
votes
3answers
676 views

How not to Copy Features when too many would be output?

This question has already been posed to the ArcGIS Geoprocessing forum but I have had no responses there. I have a 3.5 million polygon layer (cadastre) stored in Oracle via ArcSDE. I use a polygon ...
5
votes
3answers
1k views

Merging edited data back into ArcSDE master geodatabase?

I need some suggestions/inspiration for a problem we have. The problem: We have an ArcSDE master GIS database. We will edit this data almost exclusively outside of ArcGIS and outside of ArcSDE. In ...
5
votes
3answers
3k views

Debugging RuntimeError: workspace already in transaction mode from arcpy.da.UpdateCursor and ArcSDE feature classes?

I am making my first attempt at editing an ArcSDE feature class with python through a da.UpdateCursor. I'm essentially taking code I've written for a file geodatabase feature class and applying it to ...
5
votes
1answer
366 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 ...
5
votes
3answers
524 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
5
votes
1answer
3k views

ArcObjects: modifying feature field value

I'm developing an ArcMap extension and looking for a way to change feature attributes knowing its feature class and OID (and, presumably, everything else that there is in IFeature). All layers use ...
5
votes
3answers
5k views

Error 001359 when publishing map service to ArcGIS server?

I encountered this error when trying to publish a map service to an ArcGIS Server 10.1 (installed on linux). --------------------------- Service Publishing Result --------------------------- ...
5
votes
2answers
2k views

Where can I get jsde_sdk.jar for ArcSDE 10?

I had an environment working with no problems, with Geonetwork harvesting metadata from ArcSDE 9.3. It was done trhu the following libraries, copied from the ArcSDE installation to the Geonerwork lib ...
5
votes
2answers
1k views

Where are imported Mosaic Dataset images stored on ArcSDE server?

I am trying to learn more about Mosaic Datasets and specifically how they interact with ArcSDE (SQL Server 2008). I read in How raster data is stored in a geodatabase that "...In the case of the ...
5
votes
2answers
1k views

Quickest way to Copy single selected polygon from large ArcSDE feature class?

I have selected a single polygon, which is large but not massively complex, from an ArcSDE 9.3 for Oracle feature class with 3.5 million polygons using ArcGIS Desktop 10.0 SP3. I would simply like ...
5
votes
1answer
225 views

Versioning commercial datasets in ArcSDE + Oracle

We are building an application with several spatial tables, provided by a commercial vendor, at its core. The vendor provides updates quarterly. We maintain several tables of our own, derived from ...
5
votes
1answer
55 views

Can ArcGis accept SQL field names with spaces?

Im working on an integration project that is providing data from our billing system to ArcGis. Field names can include spaces which are acceptable in SQL Server if enclosed in brackets eg: [Street ...
5
votes
1answer
2k views

ORA-28595: Extproc agent : Invalid DLL Path

I'm trying to create a table with spatial column in oracle and insert data into it. I'm using ArcSDE and Oracle. The version of Oracle is 11.2.0, the version of ArcSDE is 10.0. My create statement is:...
5
votes
1answer
335 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 ...
5
votes
1answer
1k views

ArcGIS Query Layer performance documentation or feedback

I first tried asking this question in the ArcGIS forums but as is common I got a total of 0 responses. I'm willing to accept this may be due to a lack of knowledge on the subject, but I'm optimistic. ...
5
votes
1answer
345 views

Address locator not using modified .cls file

I have made a customization to the US Streets locator style for our application. We've changed "SR" to map to "STATE ROAD" instead of "HC" in the us_addr.cls file in the C:\Program Files (x86)\ArcGIS ...
5
votes
2answers
1k views

ArcSDE for PostgreSQL installation

I am trying to install ArcSDE 10 for PostgreSQL in CentOS. I tried doing that but am stuck with same errors repeatedly and am thinking of giving one more shot from the scratch. I just want to make ...
5
votes
1answer
53 views

Finding SDE permissions on feature class using ArcPy?

I am writing an arcpy script where an SDE feature class is removed then recreated. I need to set permissions on the recreated feature class that match the permissions before it was removed. Is there ...
5
votes
1answer
52 views

Auto-generated field in ArcSDE for end user

The objective: Create a process where a coworker can open an .MXD, start editing, add a feature to represent a complaint, then add records in a related table to represent an inspection. Along the way, ...
5
votes
1answer
71 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field NUMBERCYLA....
5
votes
1answer
175 views

Automate loading a table into SDE

How can I automatically load a table stored on a network share into SDE when the original table is edited? Environment is ESRI 10.1 ArcSDE on SQL Server. Preference for python or existing GP tools. ...
5
votes
1answer
155 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 ...
5
votes
1answer
294 views

Why Can't ArcPy Search the Newly Created Feature

I'm running the following tool in ArcGIS 10. I have an ArcPy Script like this: import arcpy from arcpy import env env.workspace=r"C:/sde/lcimrl.sde" fc="SDE.ATTACHMENTS\SDE.attachment_points" fcRows =...
5
votes
1answer
275 views

Using xml workspace to overwrite geodatabase in ArcGIS Server 10 with ArcSDE for SQL Server?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
5
votes
2answers
365 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
5
votes
1answer
2k views

ArcSDE - Registering table with Geography spatial column fails with error -138 (SQL Server 2008)

I have a table of point features I am trying to register with ArcSDE (9.3.1 on SQL Server 2008) using the following command: sdelayer -o register -l ThirdPartyWellsSurface,Shape -e np -C OBJECTID,SDE ...
5
votes
1answer
361 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 line,...
5
votes
1answer
482 views

Populate X and Y fields in SDE Point Data Using SQL trigger

Here is my situation. I am running ESRI ArcGIS Server and Desktop 10.2 on SQL Server 2008 R2. I would like to populate the Latitude and Longitude fields from point data (Signs data collected using ...
5
votes
1answer
1k views

How to compare two Geodatabases

I would like to compare the data of two geodatabases, in SDE or a file geodatabase, to detect the changes occured between them , i've tried to compare the Xml workspace document of both databases ...
5
votes
2answers
7k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
5
votes
1answer
166 views

Why are z-values replaced with zero after in_memory use in Python?

My script takes separate 3D feature classes, calculates a field, appends to a target feature class, and then deletes the originals. This is a huge data processing task of over 4700 mass point feature ...
5
votes
1answer
2k views

ARCMAP ERROR 000464: Cannot get exclusive schema lock

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
5
votes
1answer
517 views

Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?

I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
5
votes
1answer
2k views

Reset Object ID After Truncating Table In SQL Server

I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
5
votes
3answers
1k views

SDE views not showing values in joined table

I created an SDE view between a point feature class and a table (stored in SDE) - the join is done on a text field called RFRNC. I changed the view so that it is now a LEFT OUTER JOIN in line with ...
5
votes
1answer
760 views

How to register a Stored Procedure in ArcSDE?

I just registered a SQL Server view with ArcSDE through sdetable -o register [...]. I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view? EDIT ...
5
votes
2answers
1k views

Unable to create a geometric network in a PostgreSQL Spatial Database Connection

I've created in ArcCatalog a Spatial Database Connection to an PostgreSQL database server. I've imported there all my data (from a local hard drive) and now I want to edit them. But apparently I ...
5
votes
3answers
355 views

After running the Version Changes tool ..Export pre-reconcile/post records from parent

I would like to export those records identified as changes after running the Version Changes tool before running Reconcile and Post tools. Preferably with python or having python call a program to do ...
4
votes
2answers
1k views

Is there a SDE command to export/import feature class schema only without data?

I'm using ArcGIS Server 10.0, ArcSDE 10.0 and Oracle 11g. I'd like to create a sde export of my layers' schema. The export would be used to create easily those layer in a new database instance. Do ...
4
votes
2answers
740 views

Benefit of using GlobalIDs in ArcSDE geodatabase?

This may be somewhere, but I can't find a clear answer on exactly the benefit of GlobalIDs are in a database. What are the benefits of using these in an organization that has about 6 people editing ...
4
votes
3answers
455 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 ...
4
votes
1answer
246 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 ...
4
votes
1answer
1k views

Editing ArcSDE table with ArcObjects?

The link below provides a code snippet for editing an ArcSDE table with ArcObjects. Are there any other or newer code examples out there of how to edit an ArcSDE table by using ArcObjects? Edit ...
4
votes
1answer
463 views

Scheduled Task - calling python through BAT

I'm using ArcGIS 10.1 and setting up some scheduled tasks to run on our server. I am calling a python script in a .bat file. When it runs, the connection to our SDE database is "invalid" or do not ...
4
votes
3answers
7k views

Unable to edit data in an ArcSDE geodatabase

I'm dealing for the first time with an ArcSDE geodatabase so I'm facing simple problems to you. ESRI help wasn't of much help (to a begginer at least). I can't edit my data in ArcMap, most probably ...