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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Todd > Fagin > Sent: Thursday, October 16, 2008 8:14 AM > To: [email protected] > 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: [EMAIL PROTECTED] 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
