[gdal-dev] ogr and mdb conversion

[Chris Green]

Very constructive suggestion!

 

OGR2OGR works fine from mdb to a shape file, so the problem obviously lies in MySQL’s ability to handle certain types of feature. I will have to decide which way to go next… 

 

 

Much appreciated.

 

From: Chaitanya kumar CH [mailto:chaitanya.ch at gmail.com] 
Sent: 27 October 2011 15:28
To: Chris Green
Cc: gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] ogr and mdb conversion

 

Chris,

Try to convert the data to some other format using ogr2ogr. GML or Shapefile are very convenient.

On Thu, Oct 27, 2011 at 7:17 PM, Chris Green <chris.green at ibstv.co.uk> wrote:

Hi

 

I’m trying to get to a point where I can publish an .mdb dataset on Mapserver. Having tried for nearly a week to get OGR and the PGeo driver working on Linux (and not being willing to tackle building the MDB driver which involves compiling GDAL/OGR 1.9), I decided to try and get round my problem by using OGR2OGR to convert my .mdb dataset to MySQL offline, then connect Mapserver to MySQL (something I am doing already).

 

But now I have a different problem. I can open my .mdb file with OGRInfo and OGR2PGR starts off converting the data but then trips up with the error “ERROR 1: Terminating translation prematurely after failed translation of layer ….”. If I tell OGR2OGR to –skipfailures it continues to the end of the file having missed perhaps 60% of the features.

 

There is no additional information about the nature of the translation error. Looking at the features in Microsoft Access I see no obvious reason why some should be successfully translated and others should fail. 

 

I realise that MySQL is not the best database for spatial data but I really don’t want to have to change it, and anyway I am not sure whether this problem is caused by OGR2OGR, or by the .mdb file, or by MySQL.

 

Does anyone have any suggestions as to how I could establish why these errors occur?

 

 

 

Chris

 

 

 


_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev




-- 
Best regards,
Chaitanya kumar CH.

+91-9494447584
17.2416N 80.1426E

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20111027/41233152/attachment.html