DBF to Shape OGR JOIN, PHP crashes

[Christopher R. Thorne]

Thanks Frank,
I have a few more questions:

1) Do I have to OGR index the shapefile (dbf) with the same id index as 
well? I already have given it a qix.

2) If I wanted to shp tileindex my shape file because the layer could be 
as large as 100 mb. where I would shp2tile the shape and index by using 
tile4ms. How would that work with an CONNECTIONTYPE OGR? AM I, even 
permitted to use TILEINDEX? If no, are there other options?

3) Can I OGR index a group of shape files (with the same attributes) and 
join that group with a DBF group (with the same attributes)?

Thanks
Chris




Frank Warmerdam wrote:
> On 9/15/05, Christopher R. Thorne <christhorne at sympatico.ca> wrote:
> 
>>What do you mean an "OGR style index"? This maybe my problem. ;)
> 
> 
> Chris, 
> 
> The OGR Shapefile driver supports using indexes to accelerate
> simple attribute lookups (for unique ids).  To create the corresponding
> index do something like:
> 
>  ogrinfo abc.shp -sql "create index on abc using abc_id"
> 
> This is mentioned briefly near the bottom of the OGR SQL page at:
> 
>   http://www.gdal.org/ogr/ogr_sql.html
> 
> Note that the indexes need to be dropped and rebuilt if you change
> the file.  They aren't maintained on the fly.
> 
> Best regards,


-- 
Christopher R. Thorne, GIS Specialist
-
christhorne at sympatico.ca
Tel:(613)523-6593, Ottawa ON Canada
-----------------------------