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

[Simon Greener]

I have done some work converting the XML Schema of the GeoDatatabase XML documents to SQL statements that can define tables etc. There are lots of issues with the conversion I have done but a lot of these are due to the length of the names used in the ESRI starter models being greater than that which is allowed under Oracle (30 - as it is the main conversion I have aimed my work at). My PostGIS conversion works but still needs a lot of work. I used xmlstarlet to do the work: if you want to use native XSLT then you can get xmlstarlet to produce the required XSLT. I sent my work to "George R. C. Silva" <georger.silva at gmail.com> lf http://sourceforge.net/projects/envirodata but have not heard what has been done with what I sent.
S
 On Fri, 17 Oct 2008 01:18:37 +1100, Obe, Regina <robe.dnd at cityofboston.gov> wrote:

> 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.



-- 
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
  Email: simon at spatialdbadvisor.com
  Voice: +613 9016 3910
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3