[mapserver-users] join shp with csv

[Lars Lingner]

Hi Jörg,

On 13.03.2014 11:07, Jörg Thomsen wrote:
[...]
> 
> tried upper und lower cases for column-names
> 
> funny: the only output in errorlog (level5) is:
>> [Thu Mar 13 10:48:52 2014].209278 msSearchDiskTree(): Search returned no results. Unable to open spatial index for /home/user/data/mapserverIIWS/./shapes_join/places_join.qix. In most cases you can safely ignore this message, otherwise check file names and permissions.
>> [Thu Mar 13 10:48:52 2014].209678 freeLayer(): freeing layer at 0x9451cd8.
> 'Search returned no results.' but there are results....
> 
> 
> $ ogrinfo join.csv lookup -summary
>  INFO: Open of `join.csv'
>        using driver `CSV' successful.
>  FAILURE: Couldn't fetch requested layer lookup!
> 

I don't have a working example anymore. But I can remember I used a vrt
[1] for processing CSV files. Here is a snipped I used working with toll
data [2]:

<OGRVRTDataSource>
    <OGRVRTLayer name="mautdaten">
        <SrcDataSource>mautdaten.csv</SrcDataSource>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="lon" y="lat"/>
    </OGRVRTLayer>
</OGRVRTDataSource>


Lars


[1] http://www.gdal.org/ogr/drv_vrt.html
[2] http://wiki.openstreetmap.org/wiki/Mautdaten