Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL + PostGIS - "mining" FGDC metadata of GIS datasets

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: Greg Cocks <gcocks(at)stoller(dot)com>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: PostgreSQL + PostGIS - "mining" FGDC metadata of GIS datasets
Date: 2009-01-21 20:59:50
Message-ID: 232B5217AD58584C87019E8933556D110113423820@redmx2.esri.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Greg,
I found some more information that can be useful to your cause.
If I understand your project correctly, you want to extract the metadata from the geodatabase and make it available as information it's self. ESRI has two products that do that: Metadata Server and Portal Took Kit, they each do it a little differently and use different underlying products. So, perhaps their implementations can help you in planning your project. The help for both of those products are freely available on line.

As to the fundamental issue of using the metadata stored by the geodatabase, the metadata is ultimately stored as a blob in one of the geodatabase tables found in the database, to extract or read that blob you will need either ArcObject or use the ArcSDE C api. Below, is a link to a short KB article and a link to a discussion forum on the subject. 
http://kbplus/kbdoc.asp?dbid=23024
http://forums.esri.com/thread.asp?c=2&f=59&t=110313#314199

Best Wishes,
Kasia 

In response to

Responses

pgsql-novice by date

Next:From: Greg CocksDate: 2009-01-21 21:10:39
Subject: Re: PostgreSQL + PostGIS - "mining" FGDC metadata of GIS datasets
Previous:From: Christopher BrowneDate: 2009-01-21 19:31:30
Subject: Re: removing leading and trailing blanks from every row in a table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group