Tagged Questions

0
votes
0answers
14 views

Arcpad checkout to an area

I would like to check out data from an SDE database but for performance sake, i prefer to delete all features outside of my survey area. i've tried to copy features in area from sde to a file GDB ...
0
votes
1answer
26 views

Why can't a user with db_owner role version data?

I've made an enterprise geodatabase and added a user with db_owner permissions. When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able ...
3
votes
1answer
69 views

How can I validate a table name on SDE with Oracle backend?

Second title: "Is arcpy.ValidateTableName broken on Oracle?" I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
0
votes
1answer
48 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
3
votes
1answer
69 views

it is possible to undo and redo outside an edit session in Arcobjects?

I would like to know if it is possible to undo and redo changes outside of edit session, i'm working on an ArcSDE versioned 10.1 database? if yes how i could do it in Arcobjects .NET . Any help ...
1
vote
0answers
125 views

Is there workaround for very slow ArcSDE 10.1 editing

I'm suffering from very slow editing in SDE from an Arcgis engine application, the SDE database is in local so there's no network issues. but i still ignore the reasons neither how to solve this ...
6
votes
1answer
106 views

When to use multiple geodatabases?

I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
1
vote
1answer
71 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 ...
0
votes
0answers
37 views

How to add a column to table with sdelayer command?

I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
2
votes
1answer
67 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 ...
6
votes
1answer
85 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
2
votes
2answers
224 views

I need help understanding ArcSDE and Server. How can I access services outside network?

I'm learning about ArcSDE and ArcGIS for Server on my own without any official training. I've successfully installed ArcSDE and Server for 10.1. We are using SQL Server 2012 on a Windows 2012 Server ...
2
votes
1answer
97 views

What is the proper way to delete an SQL Server database in order to delete an SDE geodatabase?

I'm new to this SDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the SDE geodatabase. Is it as easy as right clicking on the database in SQL ...
1
vote
1answer
72 views

Why don't I see ArcSDE service in the Windows services?

I've been thrown into learning how ArcSDE and ArcServer 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 I go ...
1
vote
2answers
47 views

Identifying the Primary Key field of the Layer in ArcGIS Server

I need to get the primary key column of the Particular layer added in the Map. Usually 'FID' be found for a Shapefile Layer Source and OBJECTID found for a SDE source layer. Is there any way to ...
3
votes
1answer
93 views

Is it possible to add arcgis-server services or ArcSDE datasets to Tilemill

Our web design department wants to use mapbox/tilemill to create webmaps for our public websites, but all our data is made available through ArcGIS-server or ArcSDE. Is there some way to use these ...
3
votes
3answers
110 views

How to create feature dataset by pgAdmin(postgres) that can by use in sde conection?

How to create feature dateset in postgres(pgAdmin) that can by use in sde conection (arcgis)?
4
votes
0answers
164 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 ...
2
votes
1answer
207 views

Create dynamically multiple layers in ArcGIS Server 10.1

I am using ArcGIS Server 10.1 and Desktop 10.1 software. I am publishing table from sqlserver to the ArcGIS server, that table (from sqlserver) is updating hourly, and the types are increasing. I ...
1
vote
1answer
103 views

Geodata Service in ArcGIS Java script api (3.1)

Can I use Geodata service in ArcGIS JavaScript API 3.1 ??? Background : I have simple map service and the all attribute data is stored in Sql Server database. I want to perform query operation on map ...
1
vote
1answer
113 views

How to replace corrupt representations stored in a geodatabase using symbology from layer file?

I have a lyr file with symbology that I want to store in the database. Symbolology is already stored in the geodatabase but the symbology levels has been corrupted migrating from 9.3 to 10. Thus, I ...
4
votes
2answers
266 views

How to autonumber fields in versioned ArcGIS 10 SDE?

I want to have a field with autonumbering in ArcGIS. I have a versioned SDE database (SQL server). Thus, using the identity seed attribute in the SQL server is not an option. Is it really not possible ...
1
vote
1answer
192 views

Why does arcpy append from file geodatabase to SDE fail?

I'm trying to append a feature class from a file geodatabase to an Arcsde featureclass using this line of code: arcpy.Append_management("parcel_copy", sde_path+"parcel" ,"NO_TEST") This line works ...
2
votes
1answer
341 views

How do I format SQL queries for use in Arcpy?

I have to make an SQL query on a column having not adequat name "type_borne_id", I couldn't make SQL queries using arcpy.Select_analysis neither selectbyattribute, but when I use select_analysis ...
1
vote
0answers
185 views

How to drop ArcSDE connection using Python scripting?

I want to be able to control connections to ArcSDE via python. Here is my script so far using ESRI's example. import arcpy from arcpy import env env.workspace = r"SDEConnection" fcList = ...
3
votes
1answer
222 views

Duplicate ObjectID in ArcSDE Table

After making a check in from an arcpad AXF file, i remark that there's duplicate object ID records , this Arcsde pgsql table is versioned and edited by Axf checkins and a .net engine application. the ...
6
votes
2answers
297 views

Find Duplicate Feature Classes in ESRI Geodatabase

I have inherited a SDE instance that has 1000+ feature classes within which are around 100 Feature Datasets. I have found through manual exploration that there are at least some Feature Classes that ...
0
votes
0answers
258 views

how to use SQL Server Express (ArcSDE Personal) local geodatabase without elevated privileges

I have SQL Server 2008 Express on my workstation by virtue of having Visual Studio 2010. To ready it for use with ArcGIS, I ran the ArcSDE Personal 'Enabling SQL Server Express to store geodatabases' ...
6
votes
1answer
816 views

Postgresql for Qgis and Arcgis - What to do/What not to do

Is it possible to use postgresql with QGIS and ArcGIS? One database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know that I ...
1
vote
0answers
234 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
4
votes
2answers
159 views

Calculating the space a feature class will use in ArcSDE?

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
0
votes
1answer
256 views

Reconcile and post versions

I want to know if we can post the versions based on events through coding. How we do batch reconcile and post through c# code. Is it possible for automatic replication also?
1
vote
1answer
187 views

ArcSDE for ArcGIS Desktop

I have ArcGIS desktop (info) license. I want to know if I can configure SDE, where in I can work with versioning of geodatabases.
3
votes
1answer
411 views

How can I create an empty feature class in a file geodatabase based on the schema of an SDE feature class?

I have 150+ feature classes in SDE for which I need to create an empty feature class in a file geodatabase. For these feature classes I need to import the attributes and the name of the feature class ...
1
vote
1answer
626 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 ...
1
vote
0answers
211 views

ArcSDE geodatabase for non-spatial data

I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
5
votes
1answer
513 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 ...
3
votes
0answers
152 views

Cartographic Representations Load Rather Than Feature Symbology

We use ArcSDE to allow multiple users (both in my office and elsewhere) to access feature classes that my office maintains. We also use cartographic representations for many of our feature classes. ...
3
votes
0answers
155 views

ArcSDE - How to edit mosaic dataset

I have a mosaic dataset (Raster) in an SDE database. As expected, when I click start editing, ArcMap says that I have to do "Register as Versioned" before, but I can't have a mosaic dataset in a ...
5
votes
2answers
474 views

Options for ArcGIS Server and ArcSDE Hosting

I know this was partially address here, but it was not specific to ESRI products. I want to find some place to create and host map services with ArcGIS Server and ArcSDE. ESRI cloud options are bit ...
5
votes
3answers
335 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 ...
1
vote
1answer
150 views

ArcToolbox Create Replica tool advanced options

I am trying to create a two-way Replica of my SDE database to another SDE database in ArcGIS 10.0 If I use the Create Replica wizard from the 'Distributed Geodatabase' toolbar in ArcMap I am able to ...
2
votes
1answer
154 views

Is there a way to delete definition querys of multiple layers in ArcMap 9.3.1?

I'm searching for a way to freeze/delete definition queries of several layers at once (instead of doing it manually by opening the properties of each layer). I'm working on a SDE 9.3.1 Geodatabase.
7
votes
3answers
1k views

ArcSDE - Is there an automated way of releasing all layers locks?

We have an issue where users do not close ArcGIS and layers get locked, and sometimes this affects our nightly updates for some of the layers. I know you can individually remove a lock using the ...
5
votes
2answers
323 views

What does it mean to QI and how is it done?

I'm new to Esri's Arc* interfaces, and trying to figure out how to register an existing table using the ArcObjects API. The following question answers this to some extent: Is there any way to write a ...
6
votes
1answer
393 views

SQL Server Relationships in ArcSDE

I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
6
votes
2answers
387 views

How is the default label field chosen by ArcMap?

I have 2 questions: I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
5
votes
2answers
343 views

How to convert high precision dataset to low precision

A high precision dataset was loaded from a file geodatabase into arcsde 9.3.1. The dataload was achieved by copy/paste in ArcCatalog. A custom tool (arcobjects) that extracts from the dataset to a ...
4
votes
1answer
175 views

Migrating Feature Datasets from ArcSDE to postgis

I am currently planning the migration of a database from ArcSDE/ Arcmap to postgis / Qgis. The data is stored in raster catalogues and feature datasets. Is there an equivalent to feature datasets ...
4
votes
1answer
216 views

Geometry storage type in geodatabase Oracle 9i with SDE 9.3.1

How do I identify what geometry storage type is being used with a specific geodatabase? Thanks.

1 2