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: postgis-users@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
