ArcSDE (Spatial Database Engine) is a server-software sub-system (by ESRI) that enables the usage of Relational Database Management Systems (RDMS) for spatial data.
2
votes
1answer
218 views
arcgis10: export eventlayer (from querylayer) to ArcSDE
I am not using arcmap but I am creating a arcgis desktop console app.
I am pulling an external SQL table in as a querylayer. This table has lat & long so I created an eventlayer (or ...
2
votes
1answer
745 views
Customize geocoding locator styles in an ArcGIS Server environment
Using ArcGIS Desktop, it is relatively straightforward to customize locator styles by editing the corresponding CLS files. We are struggling to do the same in a server environment.
We have created a ...
2
votes
1answer
435 views
Filter features with multi-table joins in ESRI Silverlight/REST API
We have a rather involved data warehouse (SDE 9.3.1 / Oracle 11g) that contains a single related point feature class. Our (analytical) application should allow users to construct complex, ad hoc ...
2
votes
1answer
336 views
Oracle tracing, bind variables, and ArcSDE
Oracle tracing with TKPROF is the recommended way to troubleshoot data access performance problems with SDE/Oracle. Unfortunately, queries that differ in any way are considered "different" and ...
2
votes
1answer
531 views
ArcSDE: connecting via LDAP Authentication
I was wondering if anyone has a sample connection string for SQLPlus using LDAP Authentication. I am also trying to specify in the connection string the database I wish to use.
Thanks,
CDB
2
votes
1answer
353 views
Has anyone successfully made a FeatureLayer from a view in DB2 and ArcSDE 10?
Lately it seems like every new ESRI feature fails for me - I must be cursed. I'm testing the use of a FeatureLayer to see if helps display and query features using the JavaScript API 2.0.
This layer ...
2
votes
1answer
47 views
Convert OpenStreetMap schemas to ArcSDE in PostgreSQL database
I am trying to find a way to store OSM Extracts (or possibly the planetfile) in a PostgreSQL database, keep it up to date with diff files and then process the data further with ArcGIS (e.g. Geocoding, ...
2
votes
2answers
122 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 ...
2
votes
0answers
66 views
Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET
I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2.
We have a feature class ...
2
votes
0answers
180 views
Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?
Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
2
votes
0answers
114 views
How to compress enterprise geodatabase with stored procedure?
I'm looking for a stored procedure in ArcSDE for SQL Server which performs geodatabase compression to include it in our daily maintenance plan. Is there any such thing in ArcSDE 10.0?
2
votes
0answers
212 views
How to get WKT from SHAPE column in the ArcSDE geodatabase?
I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
56 views
ArcSDE Feature View in a GeoDatabase other than the Feature's Database
here is the problem I have been struggling with:
We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
2
votes
0answers
225 views
Can a spatial View in ArcSDE be viewed in ArcCatalog?
Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table?
I have a feature class table and an attribute table ...
2
votes
0answers
155 views
Importing Rasters to ArcSDE 9.3.1 using sderaster
OK, I am trying to import a raster to 11g using the sderaster command. It is a stand alone jpg with a world file associated, and pyramids.
Am I right in assuming I cannot import a JPG, I can only ...
2
votes
2answers
794 views
Using Flex to display single rasters from raster catalog in ArcSDE/ArcGIS server
One of the front end develoeprs here is having issues displaying, or working out how to display a single raster held in a raster catalog in ArcSDE using the Flex 2.2 API
the Raster Catalog holds ...
1
vote
4answers
935 views
error in arcsde service
I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database
SDE not Running on Server
Then I Check the Service esri_sde it has ...
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.
1
vote
2answers
1k views
How do I use Oracle Locator's mdsys.sdo_geometry with ArcSDE?
I'm using the Oracle Locator MDSYS.SDO_Geometry type to store my spatial information and then accessing it through ArcSDE. I'm confused about how the precision component of the metadata is used and ...
1
vote
1answer
195 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 ...
1
vote
1answer
201 views
How to run “sdetable register” command in SQL Server?
I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2.
I tried to run the ...
1
vote
1answer
220 views
ArcMap - ODBC connection to SDE table shows an old version?
I use an ODBC connection to an SDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL SDE server and the connection info matches what I ...
1
vote
1answer
901 views
Trouble creating ArcSDE Connection File
I'm having trouble creating a ArcSDE Connection File. When I bring up the GP tool to do this, I enter the folder I was save the sde file to, enter an name for the file 'MySDEConnect.sde', enter the ...
1
vote
2answers
155 views
Associating data in a form with an SDE Layer
I was wondering if there was a way to associate/persist some data about an SDE featureclass when viewing via ArcCatalog.
I know you can have metadata - but I don't want to use that, and I'm pretty ...
1
vote
3answers
698 views
Is the “sdetable” command available with ArcGIS Workgroup
Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition?
We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from ...
1
vote
1answer
42 views
ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?
In the system I'm building, we've got a facility that can be represented as either a point, or a point within a polygon (the point in the polygon may or may not be the polygon's centroid).
I'm using ...
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 ...
1
vote
1answer
158 views
How to manage user privilege on layers to Arcgis 10 Desktop?
Problem:
I am a Computer Analyst on a town hall.
Here we have the sector A and B. Both work in ArcGIS 10 Desktop.
The sector A has granted to access/edit everything. The sector A has all the ...
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
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 ...
1
vote
1answer
111 views
Multiple-machine deployment scenario. Solutions?
I have a virtual machine (let's call it machine no.1) on which I have installed Microsoft SQL Express 2008 R+ ArcSDE 10.0+ ArcGIS Desktop 10.0 +ArcGIS Server 10.0. Everything is connected and works ...
1
vote
1answer
133 views
Versioning geodatabases
I am trying to reconcile and post the edits. I would like to know if I can post the versions to two different parents. Could some one help me with c# coding on how to do this.
1
vote
1answer
239 views
Delta tables for versioning
I am doing versioning of sde. I have done this using the ArcMap. I want to look at the delta tables in sql server.
In sql, I don't see the delta tables. I just see few tables named as a144.
How do I ...
1
vote
2answers
1k views
How can I insert new records to an ArcSDE feature class from a view in ArcSDE
I am wondering how I can both insert new records from a view to a feature class and update data that may be newer in the view than in the feature class. I have been fumbling around in modelbuilder and ...
1
vote
2answers
1k views
How do I programmatically update/recreate an ArcSDE feature class from external sql data?
I have an ArcSDE feature class that contains project points based on xy data from an external SQL databaes. (Not a geodb). I am looking for the best way to "recreate" the ArcSDE feature class from the ...
1
vote
1answer
1k views
Product License not initialized error when trying to open an SDE connection in ArcObjects
I am trying to connect to create connection in using ArcObjects using the code below.
IPropertySet propertySet = new PropertySet();
IWorkspaceFactory sdeWsFactory = new SdeWorkspaceFactory();
...
1
vote
1answer
59 views
“SDE error 6” when publishing GeoServer layer
I have successfully created an ArcSDE datastore in GeoServer 2.2.4. When I try to publish a feature class in the SDE database, the "Compute from data" link returns nothing, and the "Compute from ...
1
vote
2answers
48 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 ...
1
vote
2answers
201 views
arcsde - index LOADING/FAILED/UNUSABLE
I have a problem with import data with fme and arcsde.
I have a loop of import data in the same arcsde table.
I have a problem with index :
Error while executing stream insert operation for table
...
1
vote
1answer
635 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
1answer
181 views
How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?
I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
1
vote
2answers
409 views
Select and highlight features
I have 2 ESRI feature layers on my map; points and polylines. I can select them just fine either by rectangle or polygon. What I am missing is how to highlight (larger size and different color) the ...
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 ...
1
vote
1answer
338 views
Copying and renaming files on SDE connection
I have a script that renames and copies files (feature classes) on an SDE connection. This script works just fine if the feature class name does not start with an 'S'. If the feature class name does ...
1
vote
1answer
624 views
Add Spatial Database Connection fails
Has anyone else come across this problem? I created a Database Server (SQL Express 2008.) I created a "New GeoDatabase..." I double-click on "Add Spatial Database Connection." I fill out the dialog ...
1
vote
1answer
614 views
ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services
I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008.
When I make a spatial db connection in ArcCatalog (direct ...
1
vote
3answers
326 views
Editing non-nullable fields of ArcSDE layers in ArcMap
I'm using ArcSDE layer in my map project in ArcMap 10. Some of the fields of this layer allow null and some don't. I can't edit the non-nullable ones, neither programmatically (IField.Editable is ...
1
vote
2answers
398 views
Access Feature Classes on Multiple Database Schemas with ArcSDE
I am using ArcObjects to access a GeoDatabase that was set up with ArcSDE 10 and SQL Server 2008 R2. In this particular case, I have some tables set up on alternate schemas (this is to replicate a ...
1
vote
1answer
283 views
How to execute gp.execute ArcSDE tool in C#
So I created an ArcGIS 10 toolbox in ArcSDE and added a tool to it.
There are enough examples out there on how to execute a tool.tbx that resides outside SDE or GeoDB.
But in C#, how do you use ...
