Posts Tagged ‘dataset lock’

Some useful tips from ESRI

August 16, 2010

Some useful tips which I have read from different blogs/ESRI Forums. All these items are in draft for quite some time, just publishing them today.

1) How to organize hundreds of feature classes in SDE? . This is one of the challenging job during the application design. Again it depends on the business requirement. I would say having 200+ feature class or using higher number of feature class/multiple dataset in web solution is not a correct practice. If it all required, we have to redesign data modelling for such specific requirement. Below are two ESRI Forum threads discussing  the same.

http://forums.esri.com/Thread.asp?c=2&f=59&t=221639&mc=8

http://forums.esri.com/Thread.asp?c=2&f=59&t=147917&mc=8#msgid430706

In general, it is a bad idea using FD to group FCs for two reasons (at least).

a). As you’ve already known, while accessing just one FC, the whole FD is locked. [What do they mean by FD will be locked, is that -A process accessing a feature class within a feature dataset locks all of the feature classes in the feature dataset?].

What for dataset is being used. This is an imaginary folder to store all your feature class .

  • A feature dataset is a collection of related feature classes that share a common coordinate system.
  • Their primary purpose is for organizing related feature classes into a common dataset for building a topology, a network dataset, a terrain dataset, or a geometric network.
  • All feature classes contained within a feature dataset have the same access privileges.
  • To organize feature classes for data sharing
  • Another design factor in organizing feature classes into common feature datasets is the requirement to use a spatial reference
  • Extent set for FD is same for all FC’s

b). When you use one layer in the FD, all the FCs in the FD will be cached, not just the layer you are using.

c). Don’t put any layer/feature class into a feature dataset unless you need it for geodatabase functionality (e.g. geometric network, topology, etc.)

2) How to connect to geodatabase. A quick help ESRI reference link for various type of connection. I always have this link in my favourites.

http://edndoc.esri.com/arcobjects/9.2/NET/c778d2bb-eb36-4793-9c89-20795811c5eb.htm

3) How to find windows operting system version (32/64 bit OS)

  • Click Start, and then click Run.
  • Type sysdm.cpl, and then click OK.
  • Click the General tab. The operating system is displayed as follows:
    • For a 64-bit version operating system: Windows Server 2003 Enterprise x64 Edition appears under System.
    • For a 32-bit version operating system: Windows Server 2003 Enterprise Edition appears under System.

4)  Spatial Analysis Book : A must read book for people doing research by using geographical tools

might find this geospatial analysis book extremely useful. Even if you work with the specific type of analysis by using a certain open source or a popular commercial GIS product (for example, using ESRI Geostatistical Analyst® for coverage analysis), you could get a deeper understanding of raster data properties and learn some more theory behind the interpolation methods you use.

Free online copy is avaiable @http://www.spatialanalysisonline.com/output/

Hope some of these items might be helpful to you.