[mapserver-users] PGeo (Personal Geodatabases) options under Linux

[Dan Little]

I am making the gross assumption that someone, who is producing the PGeo file is on Windows and that person(s) would be available to do the conversion...


----- Original Message ----
> From: Stephen Woodbridge <woodbri at swoodbridge.com>
> To: Dan Little <danlittle at yahoo.com>
> Cc: Chuck Jungmann <chuck at cpjj.net>; mapserver-users at lists.osgeo.org
> Sent: Sun, November 29, 2009 10:22:37 PM
> Subject: Re: [mapserver-users] PGeo (Personal Geodatabases) options under Linux
> 
> Dan Little wrote:
> > not that this answers the problem... but is there any reason this
> > cannot be exported to a shapefile and then served with mapserver?
> 
> Good question. I think you would have to do that on a Windows box because the 
> MDBTools on Linux is just not up to the task. If you could export it on Linux 
> then you could also probably serve it directly via mapserver and ogr.
> 
> -Steve W
> 
> > ----- Original Message ----
> >> From: Chuck Jungmann To: Stephen Woodbridge
> >> Cc: mapserver-users at lists.osgeo.org Sent:
> >> Fri, November 27, 2009 5:17:03 PM Subject: Re: [mapserver-users]
> >> PGeo (Personal Geodatabases) options under Linux
> >> 
> >> I've read that page several times. I have also built MDBTools,
> >> unixODBC and GDAL from CVS sources and applied patches, etc, so I
> >> could try to trace execution to the errors.  What I've found are
> >> instances where the code ultimately ends up in an empty function
> >> that simply returns SQL_SUCCESS or SQL_OK or whatever without doing
> >> anything.  That seems to be why MDBTools has trouble with "SELECT
> >> COUNT(*) FROM xxx" and why it can't find a primary key.
> >> 
> >> While I can see that these database features are not working, it's
> >> also possible that they are not necessary.  I'm wondering if anyone
> >> has had success, either despite these errors, or by not
> >> encountering these errors, in which case I may find some success if
> >> I can duplicate their environment.
> >> 
> >> Thanks for the quick reply, Chuck Jungmann
> >> 
> >> On Fri, 2009-11-27 at 18:00 -0500, Stephen Woodbridge wrote:
> >>> Chuck Jungmann wrote:
> >>>> I have a Personal Geodatabase (PGeo) from which I would like to
> >>>> display layers in MapServer on Ubuntu 9.04.  I have been
> >>>> fighting with MDBTools, unixODBC, and GDAL for what seems like
> >>>> forever.  The ogrinfo and isql fail with Segmentation Faults.
> >>>> 
> >>>> I have two questions:
> >>>> 
> >>>> 1. Has anyone successfully used a PGeo file to display maps on
> >>>> MapServer under Linux?  Perhaps my efforts were doomed from the
> >>>> start.
> >>>> 
> >>>> 2. Since GDAL is using ODBC to read the MDB file, would using
> >>>> ODBC to access MySQL be a transparent replacement, assuming I
> >>>> copy all of the tables and indexes from the PGeo file to MySQL?
> >>>> Has anyone done this? I don't want to waste a lot of time on
> >>>> this if it's another dead end.
> >>> Chuck,
> >>> 
> >>> There was a recent thread related to these problems on the GDAL
> >>> list. Frank posted the follow link and commented that there are
> >>> also probable some open bugs. Evidently, the mdbtools are not
> >>> well supported and buggy which makes using them problematic.
> >>> 
> >>> http://trac.osgeo.org/gdal/wiki/mdbtools
> >>> 
> >>> Check out this thread on the gdal-dev archives: [gdal-dev] mdb to
> >>> shape conversion: no geometry exported
> >>> 
> >>> -Steve
> >>> 
> >> _______________________________________________ mapserver-users
> >> mailing list mapserver-users at lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> > 
> > 
> > 
> >