[mapserver-users] join shp with csv

[Jörg Thomsen]

Am 13.03.2014 14:39, schrieb Rahkonen Jukka (Tike):
> Hi,
> 
> I have had no time to look at your files but I see that ogrinfo reports osm_id as a string. Write .csvt file http://www.gdal.org/ogr/drv_csv.html for converting it to integer, perhaps join requires same data types.

good idea, thanks.
But doesn't help.

I have updated the online files, perhaps you'll have some time within
the next few days.

Jörg

> 
> -Jukka Rahkonen-
> 
> Jörg Thomsen wrote:
> 
>> Hello Jeff,
>>
>> yes, this looks better.
>>> $ ogrinfo ./shapes_join/join.csv join -summary
>>> INFO: Open of `./shapes_join/join.csv'
>>>       using driver `CSV' successful.
>>>
>>> Layer name: join
>>> Geometry: None
>>> Feature Count: 208
>>> Layer SRS WKT:
>>> (unknown)
>>> osm_id: String (0.0)
>>> name_join: String (0.0)
>>
>> but the join in mapserver still doesn't work.
>>
>> Jörg
>>
>>
>> Am 13.03.2014 13:39, schrieb Jeff McKenna:
>>> On 2014-03-13, 9:36 AM, Jeff McKenna wrote:
>>>> On 2014-03-13, 7:07 AM, Jörg Thomsen wrote:
>>>>>
>>>>>
>>>>> $ ogrinfo join.csv lookup -summary
>>>>>  INFO: Open of `join.csv'
>>>>>        using driver `CSV' successful.
>>>>>  FAILURE: Couldn't fetch requested layer lookup!
>>>>>
>>>>> This is my only hint but unfortunatly I don't know what ogr wants to
>>>>> tell me.
>>>>>
>>>>
>>>> You seem to be following my examples very closely from
>>>> http://www.mapserver.org/mapfile/join.html#example-3-join-from-shape-
>>>> dataset-to-csv-file which is good, but be careful, "lookup" in my
>>>> example is the OGR layername; in your case it will be different.  You
>>>> should just try "ogrinfo join.csv" to get a list of available layers
>>>> through OGR.  See some examples of that in action:
>>>> http://mapserver.org/input/vector/ogr.html#how-to-use-ogrinfo
>>>>
>>>
>>> Ah but I almost forgot the most important switch for layernames:
>>> ""ogrinfo join.csv -summary"
>>>
>>> Good luck there!
>>>
>>> -jeff
>>>
>>>
>>>
>>>
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>