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

[Simon Greener]

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 <georger.silva at gmail.com> 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" <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.
>>>
>>
>>
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> 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: 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