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

[George Silva]

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