ArcPy geoprocessing package

Esri has introduced in ArcGIS 10 a new geoprocessing package ArcPy, which is based on Python – a popular open scripting language. This module is supposed to replace the previously used in ArcGIS 9.3 arcgisscripting module and contains a plenty of new functions that could help you to be more efficient when managing your GIS [...]

Read Full Post »

Configuring ArcGIS Server for SQL Server course

Recently I have been teaching an ArcGIS Server Enterprise Configuration and Tuning for SQL Server course that Esri also now offers for ArcGIS 10. Originally, it was designed for the previous versions, but it has been rewritten and updated in order to reflect the new interface and functionality of the version 10. The course is [...]

Read Full Post »

Creating ArcSDE services

Today I would like to discuss a fairly typical scenario, which is when you have worked with an ArcSDE database on a development server and then have backed it up and restored it on a production server. After running all the required scripts and eventually after doing user mappings, you will have moved to the [...]

Read Full Post »

Change sde layers path

If you have an .mxd document that has a large number of layers and you have to use another sde database as a source of data, which includes the same feature classes and tables (for instance, when moving from a development to a production server), you might need to change source paths for those layers. [...]

Read Full Post »

PostgreSQL and ArcSDE

ESRI ArcGIS 9.3 version has support for one more database management system (DBMS) for storing our spatial datasets. In addition to the ability of using Microsoft SQL Server, Oracle, IBM DB2 and Informix, PostgreSQL can be used now as well. In this post, I would like to give a brief review of this DBMS and [...]

Read Full Post »

Useful SQL statements and ArcSDE commands

ArcSDE A lot of work during administration of ArcSDE includes managing sde instances. I just wanted to write down some of the most useful and often used ArcSDE administration commands I have been using for a while. Parameters embraced in <> are defined by user; so, if we have “<servicename>” that would result to “esri_sde”. [...]

Read Full Post »

ArcSDE database model migration

There are still many users who use multiple spatial database model with ArcSDE at their organizations, even though ESRI have, for a long time, recommended using single database model. Multiple spatial database model basically implies that one will store all spatial data and ArcSDE system tables in one DBMS spatial database (let’s call it SDE) [...]

Read Full Post »