#Geodatabase Talk - Episode 9 - SDE (Spatial Database Engine)

The #geodatabase is a technology developed by #Esri that abstracts the underlying storage medium into another layer. By doing that you get interesting functionalities like domains, feature classes, tables, feature datasets across multiple databases from file based to enterprise RDBMS like Oracle, PostgreSQL, SQLServer DB2 etc. The communication between the client and the enterprise geodatabase is done through the spatial database engine. We explain that layer in this episode.

Boost your GIS knowledge by grabbing my books ——————————————————————— - [x] Learning ArcGIS Geodatabase https://goo.gl/csQdCX - [x] Administering ArcGIS for Server https://goo.gl/zvYCRg - [x] ArcGIS By Example https://goo.gl/yJKSqB - [x] Building Web Applications with ArcGIS https://goo.gl/brgKUJ Watch my top GIS videos ———————————— - [x] Support IGeometry on paypal: https://goo.gl/wZ8hSh - [x] Full ArcGIS Javascript API Series Playlist http://bit.ly/2zf7G80 - [x] Full Multi-User Geodatabase Playlist https://goo.gl/nSgYnM - [x] Full ArcGIS Pro 2.x Playlist https://goo.gl/2j4NoZ - [x] Full ArcGIS By Example (C#) [Phonatech] Playlist https://goo.gl/FwdrHa - [x] Full ArcGIS Server Playlist https://goo.gl/nkfM6Q

Set up an ArcGIS Desktop Development Environment

In this video, we discuss how to setup an ArcGIS Desktop environment for development from scratch. We start with a clean 8.1 Windows machine and then we install the required software. These are the list of software required.



1. ArcGIS Desktop 10.4.1

2. Visual Studio Community 2015

3. ArcObjects SDK For Microsoft .NET Framework



Download ArcGIS for 60 days, details here:



http://www.husseinnasser.com/2016/04/arcobjects-sdk-available-for-download.html



Download Visual Studio 2015 Community

https://www.visualstudio.com/downloads/





Questions and comments are welcomed!



-Hussein Nasser

The Unorthodox Way to Compress a Replication-Enabled Versioned GeoDatabase to State 0

If you landed here chances you lost hope of all the links and by-the-book ways to compress your geodatabase. You probably have a versioned geodatabase that no matter how many times you compress, no matter how many users you kick out, how many connections you kill; The state is not set to zero.

You have one version SDE.DEFAULT and it is still pointing to state 8549347 or whatever and this state is referencing thousand of edits. So you are stuck with a huge performance issue on your database because of all the queries to the A and D table. Even if you reconcile and post all versions you still can't seem to get to state 0. Usually replication might cause this, so you might have few hidden versions pointing to state 0 . Therefore compress command will get confused when these versions with state 0.


BEFORE YOU DO THIS, BACKUP YOUR DATABASE, DO AN ORACLE DUMP OR A SQL SERVER BACKUP. ALTHOUGH THIS THING WORKED FOR ME THREE TIMES I CAN'T GUARANTEE JACK.


Buckle up, we are about to open the hood of the SDE Technology and loose few bolts in the SDE engine, change a fuse or two, start the engine manually and put the hood back.


1- Fireup your DBMS, connect as SDE user.

2- Open the SDE.VERSIONS

3- You may skip this to 4 if you just want to do the fix, else continue reading if you want to know how this works

Name: The Version Name
Owner: Who created the version
Version_ID: An ID for the version
Status: A status that tells whether this version if private, public, protected or even system
State_ID: To what state this version is pointing, the state
Description: Text, description of the version
Parent_Name: This is a stupid field, bad ERM design, there is a parent_version_id so we can get the name of the parent. Unless they did it like to avoid joining, thus speed up the query response time, then they are smart and I am sorry.
Parent_Owner: again, stupid field, never mind.
Parent_Version_ID: The parent version id there you go.
creation_time: when did this version is created

4- Now you might have different values, but look at the whole structure it should be the same

5- The geodatabase is not compressing because there are two states pointing to zero which makes the compress command thinks everything is rosy. So take your screwdriver lets screw this DB.

6- We will do a manual reconcile to those two hidden versions to point to the same state id as the default (that is reconciling basically) Change the state 0 in those two version to the state_id of the default as follows

7- Save and close

8- Go run the compress command

sdeversion -o compress [-N]  -u sde -p sde_password -i arcsde_service -s server_name
-D database

You should now see your state tree set to zero.

17 Free GIS ESRI Courses [Professional Certifications]

Upon completion of each of the following free Online GIS courses, you get a professional certification that will help you pimp your resume. All you need to do is to follow the training, then do an small exam after that, if you pass the exam you get the certificate.

I just got certified using ArcPad in a 3 Hours course. You will be needing an ESRI Global Account

Field GIS ArcPad Certificate

Free GIS ESRI Courses with Certification

Turning Data into Information Using ArcGIS 10 

Duration: 6 modules (18 hours)

Introduction to ArcGIS 9 Geostatistical Analyst

Duration: 1 module (3 hours)

Getting Started with GIS (for ArcGIS 9.2-9.3)

Duration: 3 modules (9 hours)

GIS for Humanitarian Mine Action

Duration: 8 modules (24 hours)

Getting Started with GIS (for ArcGIS 10)

Duration: 3 modules (9 hours) 

Working with ArcPad 7

Duration: 1 module (3 hours) 

Introduction to GIS Data ReViewer

Duration: 1 module (3 hours) 

Introduction to Map Production System-Atlas

Duration: 1 module (3 hours) 

ArcGIS Data Interoperability Basics

Duration: 1 module (3 hours) 

Using ArcMap in ArcGIS Desktop 10

Duration: 1 module (3 hours) 

Using Python in ArcGIS Desktop 10

Duration: 1 module (3 hours)

Editing in ArcGIS Desktop 10

Duration: 1 module (3 hours)

Mobile GIS: Creating Web Maps for Lightweight Mobile Apps

Duration: 1 module (3 hours) 

Mobile GIS: Using the ArcGIS for iOS Application

Duration: 1 module (3 hours)

Hazus-MH Overview and Installation (for ArcGIS 9.3.1/Hazus-MH MR5)

Duration: 1 module (3 hours)   

Basics of Geographic Coordinate Systems (for ArcGIS 10)

Duration: 1 module (3 hours)  

Field GIS: Collecting and Editing Data Using ArcPad 10

Duration: 1 module (3 hours)