[mapserver-users] join shp with csv

[Brent Fraser]

Jörg,

According to the JOIN doc (mapserver.org/mapfile/join.html) on CSV, your 
template should use

name_join: [test_2]</br>

where [test_2] is a concatenation of your JOIN NAME ("test") and the 
column id (2) in the CSV file.

Best Regards,
Brent Fraser

On 3/13/2014 8:09 AM, Jörg Thomsen wrote:
> 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
>>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>