[postgis-users] Using OGR2OGR to export postgis data to other mapinfo
Obe, Regina DND\MIS
robe.dnd at ci.boston.ma.us
Wed Jun 11 08:26:28 PDT 2003
Thanks that worked like a charm.
From: Frank Warmerdam [mailto:warmerdam at pobox.com]
Sent: Wednesday, June 11, 2003 10:36 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Using OGR2OGR to export postgis data to
Obe, Regina DND\MIS wrote:
> Thanks that worked and dumps out the tab file now. Now I feel kind of
> for such a simple solution.
> There is one other problem, which I haven't figured out why it is
> For certain tables with spatial fields, it doesn't generate anything. I
> thought maybe it had to do with the geometry_columns table not having a
> record for a particular table - but doesn't work for some of those either.
> I'm still trouble-shooting that.
I don't know why this would be.
> It also doesn't seem to work for views - even if I put in an entry in
> geometry_columns, although this could be related to problem above.
Right, views are not currently supported to treat as regular layers.
if you use the -sql option to query a view it should work. The -sql option
to ogr2ogr allows you to pass arbitrary SQL queries to PostgreSQL and then
it tries to interprete the result as a spatial or non-spatial table.
> Now my final question -- If I have two spatial fields in a table -- is
> anyway to denote which spatial field to dump out or would I need to
> explicitly specify it in the
> -select option field list?
I don't think it will work with -select since that mechanism only works for
what OGR considers "regular fields" which does not include spatial fields.
However, a -sql query which explicitly includes only one spatial field
be OK. I would add that I never really imagined support for multiple
spatial fields being very useful so I "simplified" things by ignoring the
I set the clouds in motion - turn up | Frank Warmerdam,
warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users