Five reasons why you should be using the File Geodatabase

re: Five reasons why you should be using the File Geodatabase

moreati — Mon, 02 Jun 2008 21:38:53 GMT

File Geodatabase is a huge step up from Shapefile and Personal Geodatabase. It's superior in so many ways. I would love to recommend it, but I can't because it's proprietary.

At the 2006 User Conference when File Geodatabases were the buzz ESRI promised an open API. I believe it was even in Jack Dangermond's closing speech.

After 2 years, the only way to read and write a File Geodatabase is through ArcGIS. As an archival & publishing format it's worse than Shapefile, with which ESRI improved the industry greatly by publishing openly.

Please publish File Geodatabase as an open standard, so that your customers can gain the full benefit.

Sincerely, Alex Willmer

re: Five reasons why you should be using the File Geodatabase

bhemens — Mon, 02 Jun 2008 23:01:12 GMT

We've been using the file geodatabase format in the office for over a year, and feel that it's one of the most solid developments ESRI has produced in years.

However, our clients use a wide variety of tools, GIS & non-GIS, as do we - until the file geodatabase is released as an open standard, we are loathe to use it for more than small-scope, special projects. It seems the similarity to the coverage extends beyond the superficial resemblance of a file directory containing lots of black box files.

Thanks, Brendan Hemens

Editing with File Geodatabases

jak-c — Tue, 03 Jun 2008 21:18:55 GMT

"This means that User A can edit the Roads Feature Class at the same time as User B edits the Parcels Feature Class."

Ive not really used F-GDB and im still using Personal GDB as majority of clients are still on 9.1

Id like to know more about editing the GDB over a network and how it deals with multiple people editing the layers. If person 1 is editing Layer A, will person 2 be locked out from editing A - will they be warned?

Can layers be protected, or perhaps only certain users given editing rights?

I know this is more SDE level stuff, but would be good to know.

I did some testing with multiple editing with personal geodatabases and although it is not recommended, it did seem to work out ok if there arent too many users.

Please discuss...

re: Five reasons why you should be using the File Geodatabase

usernameforme — Wed, 04 Jun 2008 14:53:43 GMT

Other points to consider to make the FGDB a standard worth adopting :

1) Full SQL support for subqueries (an area where the PGDB trumps the FGDB)

2) ST_GEOMETRY and spatial SQL support

Props to ESRI for making the FGDB platform-independent and for the performance enhancements- yet to make the format notable outside of the ESRI context, an open API is a bare minimum.

re: Five reasons why you should be using the File Geodatabase

brentardenpierce — Thu, 05 Jun 2008 20:11:12 GMT

First off, thanks for all the constructive comments! Generating candid discussion on geodatabase functionality was one of the main goals of this blog. We think it is great that people are using the File Geodatabase and we will continue to improve this data source to meet your needs. To that end, any feedback you give is taken very seriously by the team and greatly appreciated.

With feedback from many team members I tried to answer some of the questions that were raised in the comments to this point:

>> Re: Open FGDB API

We are still investigating an open API to the File Geodatabase and do not intend the File Geodatabase format to be viewed as proprietary. The most important requirement in the first release was to create a very good Geodatabase to serve the needs of ArcGIS users. Broadening that out to other environments was recognized as an important goal early on, and is something that we are working towards.

>> Re: FGDB Edit Model

If person 1 has started an edit session on feature class A, person 2 will not be able to start an edit session on A. An appropriate message will be generated. However, person 2 will be able to add A to their map, and create selections and so on.

As to assigning access rights, the File Geodatabase does not yet have the concept of GRANT/REVOKE similar to a DBMS. Access rights can be controlled using the normal operating system file permission mechanism.

With respect to multi-user editing and user access rights, it is important to remember that the File Geodatabase is not intended to be a full multi-user DBMS. When desigining the File Geodatabase we didn’t see the need to lock down the whole geodatabase if a user was editing on class.

>> Re: Subqueries in FGDB

The File Geodatabase supports several types of sub-queries, but not all. In particular, it does not yet support correlated sub-queries. Other types of sub-queries work just fine. Having said that, the intention is that additional SQL functionality will be added to File Geodatabase in order to meet user and developer requirements. The most common requests are for ORDER BY and SELECT DISTINCT, both of which are quite likely to be slated for a future release.

Hope this helps clear things up and thanks for the feedback.

re: Five reasons why you should be using the File Geodatabase

jaykayone — Thu, 05 Jun 2008 20:29:07 GMT

One big issue we have with file geodatabases is that they are very slow and can make bizarre errormessages when they are stored on a network drive.

As long as they are on a local disk, everything is perfect but when they are distant, pGDB beats 10x them in performance

re: Five reasons why you should be using the File Geodatabase

usernameforme — Fri, 27 Feb 2009 21:39:24 GMT

My wishes have been granted:

http://www.gaia-gis.it/spatialite/

Is ESRI planning on supporting SpatiaLite?