George, Send me an email explaining just what it was that you could not get working (are you running on Windoze or Linux?). If you want I can get xmlstarlet to generate XSLT and send them to you once I get the XSLT working.
regards S On Mon, 20 Oct 2008 09:10:36 +1100, George Silva <[EMAIL PROTECTED]> wrote: > Hello Simon and PostGIS users. > > I have received you conversor i still could not work with it. > > Our project in sourceforge did not moved since we last talked. My new > job taking up a lot of time and now ill be sent to field. > > I would like to invite anyone that wishes to continue the sourceforge > project. > > Simon Greener escreveu: >> 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. >>> >> >> >> >> > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- 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
