[postgis-users] Load ESRIgeodatabase XML t directly into PostGIS?

[Obe, Regina]

Todd,
 
Hmm I think this is the first time someone has asked about this.
 
What exactly does an ESRI XML workspace document look like and what do
you plan to do with it once it is loaded in.  Does it define meta data
of tables, actually contain data etc?
 
The only thoughts that come to mind are
1) Using the XML built-in functionality in PostgreSQL 8.3+ 
http://wiki.postgresql.org/wiki/XML_Support (although I think most of
this functionality is for storing xml as a field, querying an xml field
or outputting to relational data to xml so may not be what you need)
 
2) Write an XSLT to transform the ESRI XML workspace to some meaningful
sql statements that can be piped to psql, which may or may not be
trivial depending on what you are trying to do but will provide a
hands-off approach if you can actually get it working and would probably
be useful to others.
 
Hope that helps,
Regina
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Todd
Fagin
Sent: Thursday, October 16, 2008 8:14 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Load ESRIgeodatabase XML t directly into
PostGIS?



Greetings,

 

I am quite new to PostGIS and have a question about loading an ESRI XML
Workspace Document.  I have done a quick search of the archives from
this year, but haven't found any topics on the matter.  If this has been
addressed before, though, I apologize.

 

The question is actually just that: we have an ESRI XML Workspace
Document.  Is it possible to load this schema directly into PostGIS? 

 

I know that OGR <http://www.gdal.org/ogr/drv_pgeo.html>  supports
reading ESRI Personal Geodatabase files, so I could theoretically load
the XML document into a .mdb. However, the goal is to bypass this
intermediate step and go straight to PostGIS.

 

Thank you in advance,

 

Todd Fagin

 

Coordinate Solutions, Inc.

2804 NW 18th St.

Oklahoma City, OK 73107

405.740.4324 (voice)

904.471.5548 (fax)

www.coordinatesolutions.com

 

 

 



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081016/97d2777f/attachment.html>