[Gdal-dev] Mapinfo performance - tabfile spatial index

[Martin Hodder]

If you have MapInfo you could export to MIF and then get MapInfo to import
the file. MapInfo will then build the spatial index correctly

Regards

Martin
-----Original Message-----
From: gdal-dev-bounces at xserve.flids.com
[mailto:gdal-dev-bounces at xserve.flids.com] On Behalf Of Daniel Morissette
Sent: 22 July 2004 13:54
To: Jeremy Palmer
Cc: gdal-dev at xserve.flids.com
Subject: Re: [Gdal-dev] Mapinfo performance - tabfile spatial index

Jeremy Palmer wrote:
> Hi,
> 
> I'm having problems with the performance of gdal created MapInfo tab files
> from a postgis database. It seems that the tab file does not get spatially
> index upon creation... I used OGR2OGR to extract geometries from a postgis
> database. The source postgis table has a 'geometry' type. The command I
used
> to create the table was:
> 
> ogr2ogr -f "Mapinfo File" parcel PG:dbname=testgis -sql "SELECT id
> translate(shape, 160,0,0) FROM crs_parcel" -nln parcel -a_srs "EPSG:4167"
> 
> My question is: I'm I doing something wrong with the creation of the file,
> or is it just that the MapInfo driver does not support spatial indexing?
> 

I don't think you're doing something wrong. The MapInfo TAB driver does 
create a spatial index but it is not always properly balanced, that 
could explain the poor performance in some cases. Unfortunately there is 
not much you can do about this, unless you feel like spending time 
understanding and improving the generation of the spatial index in the 
code (or are able to fund someone to do it).

Daniel
-- 
------------------------------------------------------------
  Daniel Morissette               dmorissette at dmsolutions.ca
  DM Solutions Group              http://www.dmsolutions.ca/
------------------------------------------------------------

_______________________________________________
Gdal-dev mailing list
Gdal-dev at xserve.flids.com
http://xserve.flids.com/mailman/listinfo/gdal-dev