GIS Stack Exchange
GIS Stack Exchange

Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

ArcSDE is a component of ArcGIS for Server which enables ArcGIS client products and ArcObjects applications to access spatial data stored a Relational Database Management Systems (RDBMS). It presents that data as an Enterprise Geodatabase by either leveraging the underlying datastore's functionality (e.g., spatial indexes, xml fields, etc), or provides a default implementation if specific functionality is missing and thus cannot be delegated.

1468 questions
12
votes
2 answers

Managing ArcSDE?

After spending a little time Googling for ArcSDE management best practices, I came up empty handed. I have a good understanding of Spatial Databases and their management having implemented several large scale Oracle Spatial databases, but wanted to…
OptimizePrime
  • 2,359
  • 18
  • 20
7
votes
2 answers

Very slow connections to ArcSDE with over 20,000 datasets

I have a problem with ArcSDE that I have never come accross before and I was wondering if anyone could shed any light on this problem. Problem ArcSDE 9.3.1: Connnecting to an ArcSDE instance (Oracle Spatial) with over 20,000 datasets (raster)…
Vidar
  • 1,870
  • 1
  • 16
  • 37
5
votes
3 answers

Retrieving feature outside of ArcSDE into IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the Entity Framework Power Tools to accomplish this. …
lintmouse
  • 307
  • 4
  • 10
4
votes
1 answer

Power Outage and ArcSDE

I'm working on a hostile environment. Power outages, despite our efforts to minimize them, are often here. Yesterday we had a power outage and we had 2 ArcSDE databases working. I have two sets of connections, that are essencially equal. The only…
George Silva
  • 6,298
  • 3
  • 36
  • 71
4
votes
1 answer

What are SRIDs like 30008 in an SDE geodatabase?

When I look at the SDE.ST_GEOMETRY_COLUMNS table of my SDE database I'm seeing mostly recognizable four-digit values, but a number of columns have SRIDs like 300006, 300008, and 300047. I can't find descriptions of these anywhere and they aren't…
bertday
  • 1,305
  • 12
  • 25
3
votes
2 answers

ArcSDE 9.3.1 -> Performance

We have a number of mapservices in ArcGIS Server 10.0 that reads data from FGDBs. We are now moving that data in to ArcSDE and the plan is to use this data from AGS. Is it better to connect to SDE using Direct Connect or going through the ArcSDE…
user2449
  • 163
  • 4
3
votes
1 answer

Seeking publicly available ArcSDE Servers to use for developing client applications

I have been asked by our client if I can add the ability to connect to instances of ArcSDE servers from our desktop application. I am sure that we can do this a number of different ways, what I was looking for was a server I could connect to whilst…
Andy Cheetham
  • 31
  • 2
3
votes
1 answer

ArcSDE desktop license

I am using the ArcGISDesktop student license. I want to work on versioning and geodatabase replication. Is it possible to set up ArcSDE with the same license and work on versioning and replication?
sri
  • 81
  • 1
  • 3
2
votes
1 answer

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 look at the delta tables?
sri
  • 81
  • 1
  • 3
2
votes
0 answers

Can shp2sde on ArcSDE 9.3 server operate with SDE 10.3 database?

We have 2 servers running ArcSDE 9.3, and one Oracle database at SDE 9.3. Only one of the ArcSDE 9.3 servers is to be upgraded to ArcSDE 10.3, and the Oracle SDE database will be migrated from SDE 9.3 to SDE 10.3. The hope is that the sdp2sde…
Geoff
  • 121
  • 2
2
votes
1 answer

Connect to ArcSDE geodatabase over LAN?

I am running ArcGIS Server 10, with ArcSDE 10. I have a geodatabase that I would like my colleague to connect to over the LAN at our office. How do I go about doing this? I would prefer a list of simple steps than a link to the ESRI Web Help URL.
Jonathan
  • 21
  • 1
1
vote
1 answer

Query SDE to display records created for 'X' date/time

I am looking to query our SDE to display feature classes modified beginning from January 1, 2013 to today. I am using Microsoft SQL Server Management Studio, and as it stands searching through dbo tables but can't find any information that would…
MDHald
  • 1,871
  • 13
  • 20
1
vote
1 answer

Enable Archiving failing on sde 9.3.1 and MS SQL Server 2008

I am trying to enable archiving and am getting this error: Violation of PRIMARY KEY constraint 'archives_pk'. Cannot insert duplicate key in object 'dbo.SDE_archives'. Is this saying that there is already a primary key in the dbo.SDE_archives table…
Justin
  • 3,400
  • 3
  • 32
  • 56
1
vote
1 answer

ESRI fc is called database.DBO.fcname and version is called SDE.fcname

ArcSDE 9.3.1 and MS SQL 2008 R2 In ArcCatalog the feature class is called database.DBO.fcname and when I look at the connection properties in ArcCatalog the default is called DBO.Default and the other versions are called SDE.versionname1 and…
Justin
  • 3,400
  • 3
  • 32
  • 56
1
vote
0 answers

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in Toad SQL editor like other sql statements. Please…
user14637
  • 11
  • 1
1
2