Tag Archives: Heads up!
Hey folks, just a heads up that the videos of the tech session presentations from this years Dev Summit are online and can be found HERE
If you want to use Microsoft’s geometry or geography spatial types with ArcGIS 9.3.1, you should install the SQL Server 2008 Native Client on your ArcGIS client computers.
Not everyone will run into a problem when querying the geometry and geography types in SQL Server 2008 from ESRI software; it depends on how up-to-date your Windows system is.
However, if you get a deferred prepare error when displaying or querying feature classes that contain Microsoft geometry or geography columns AND a SQL trace shows this error occurred when you queried a feature class containing a geometry or geography column: “Error 206, Operand type clash: image is incompatible with geometry”, THEN you should try installing the SQL Server 2008 Native Client.
You can download and install the SQL Server Native Client from the Microsoft site HERE
This post was contributed by Kim Peter from the ArcSDE team
The Geodatabase Toolset (GDBT) for ArcCatalog is now available for 9.3 and 9.3.1. Download the toolset for free off of the ESRI downloads page.
The GDBT is an unsupported extension to ArcGIS Desktop which provides a collection of tools that you can use to troubleshoot, monitor, and investigate ArcSDE geodatabases.The GDBT works with geodatabases stored on SQL Server, Oracle, Informix, DB2, or PostgreSQL databases. It provides a wide variety of information including:
- The total number of rows in the add and delete tables
- Users connected to the geodatabase and locked schemas
- A graphic of the state tree lineage
- Detailed information of a features class spatial index
- Parent-child relationships between versions for version management
- Table and Index Statistics for geodatabase stored in an Oracle database
After you download and install the GDBT you can access a help file to learn more about the toolset. It can be found in Start > All Programs > Geodatabase Toolset > Geodatabase Toolset User Guide.
There is also a support forum available for interacting with other GDBT users.
Note: The GDBT is an “unsupported” extension so ESRI Technical Support is not available for the toolset.
A new instructional series podcast is available called Migrating from Single-user Geodatabases to Multiuser Geodatabases. The podcast provides reasons to migrate from MS Access personal or file geodatabases to multiuser geodatabases. It also highlights some key concepts to be aware of before migrating as well as GIS data migration methods.
Read the Transcript
Listen to the Podcast
Well the conference is over and it’s back to Redlands. We’ve been getting a lot of good feedback about the tech sessions and demo theatres, I’ll get the Geodatabase Essentials sessions on here later this week. I hope everyone who attended the conference got a lot out of it and had fun in the process. It certainly is helpful for us to get a feel for the types of projects our users are involved with and see how the software is being used.
This post is just a heads up about some suggested training for people who want to learn more about the geodatabase. There is a whole suite of training courses available.
If you’re interested check out Traing Spotlight: The Geodatabase
There is a new tab on the Geodatabase Resource Center that opens up a Community Page. This page is similar to those found on other resource center pages but is geared towards geodatabase topics of course.
There are four sections of the Community page:
Blog – A list of recent posts from this here blog you’re reading
Media Gallery – Video content from conferences, the help system, whatever we feel like putting up, etc…. There’s an RSS feed on this one if you wanna be pinged when new vids are uploaded.
Forums – Links taking you to geodatabase related forum threads
Knowledge Base – Links taking you to geodatabase related technical articles
This makes for a good collection of geodatabase resources so be sure to check it out.
ESRI has a Channel on YouTube called ESRI TV which serves as a good place to find helpful videos and demos. It’s worth checking out and mining for any areas that interest you.
Here are some geodatabase related entries:
Managing Geodatabase Topology with ArcEditor
ArcGIS Diagrammer – Demonstration Video
ArcGIS User Guide for Water Distribution Network Editing Template
There is also a handy 4 part Data Management series:
Create, Update, and manage asset information using ArcGIS Desktop
Experienced desktop user employing ArcEditor in a Planning Department
Experienced desktop user employing ArcEditor in a PWD
We’ve added a new article to the Geodatabase SDK entitled “Common Geodatabase API Programming Mistakes”. It’s a list of mistakes we’ve seen a lot of users make and that will cause either unwanted behavior or a performance hit. This is going to be a living document – as our users come to us with questions or problems we’ll be adding to this accordingly.
The article can be found here
On Monday afternoon at the 2009 ESRI Developer Summit we’ll be presenting a pre-summit seminar called “Developer’s Guide to the Geodatabase”. A lot of the material in this article will be referenced during that presentation. Hope to see you there.
This post was provided by geodatabase product engineer Kasia Tuszynska.
This post is an FYI for users who are planning to implement an enterprise ArcSDE geodatabase on PostgreSQL (for Windows) and intend to use the PostGIS Open Source spatial type. Note that PostGIS is not included with ArcGIS Server Enterprise and must be downloaded from online sources. We currently support PostgreSQL version 8.3.0 and PostGIS version 1.3.2.
For new set-ups, the enterprise ArcSDE installer will check for the existence of a PostgreSQL instance. If it determines that PostgreSQL is not installed, it will launch a PostgreSQL installation wizard. A module called Application Stack Wizard is part of the installation wizard, and it enables the set up of additional components, one of which is PostGIS.
If the PostGIS option is selected in the installer, the Application Stack Wizard will make a connection to the Internet and display the available releases of PostGIS for download.
By default, the Application Stack Wizard will only access the latest version of PostGIS from the internet, version 1.3.5 – which is not currently supported. One of the great things about open source software is that by nature is updated frequently. Unfortunatly this makes it very difficult to coordinate the latest PostGIS release with our software release cycles. We currently support PostGIS version 1.3.2 and this is the version you should use with your enterprise ArcSDE geodatabase on PostgreSQL (for Windows). You can obtain a copy of PostGIS version 1.3.2 from the PostGIS website.
ESRI’s Training and Education department is now offering several learning pathways. These learning pathways define a set of ESRI training courses which are designed to focus on a particular aspect of GIS.
Specific to the geodatabase among these is a Geodatabase Management Learning Pathway. This pathway consists of 5 courses chosen from a select list of topics geared towards designing, implementing and managing geodatabases in a multiuser environment. Completing the courses awards you with a pathway certificate.
The training and education site also has a number of instructor led and virtual campus courses (some of which are free) that revolve around geodatabase topics. Click HERE to view a list. These courses offer valuable insight and are a great resource for getting trained in specific areas.