Re: [mapserver-users] join shp with csv

2014-03-13 Thread Jörg Thomsen
boah, your right, thanks! so the join only works with html-templates / text/html output. with text/plain I only see the attributes of the shapefile. (And I tested with text/plain) You saved my day, Jörg Am 13.03.2014 16:59, schrieb Brent Fraser: > Jörg, > > According to the JOIN doc (mapser

Re: [mapserver-users] join shp with csv

2014-03-13 Thread Brent Fraser
Jörg, According to the JOIN doc (mapserver.org/mapfile/join.html) on CSV, your template should use name_join: [test_2] 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:

Re: [mapserver-users] join shp with csv

2014-03-13 Thread 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, tha

Re: [mapserver-users] join shp with csv

2014-03-13 Thread 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. -Jukka Rahkonen- Jörg Thomsen wrote: > Hello Jeff, > > yes, this looks be

Re: [mapserver-users] join shp with csv

2014-03-13 Thread Jörg Thomsen
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 (

Re: [mapserver-users] join shp with csv

2014-03-13 Thread 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

Re: [mapserver-users] join shp with csv

2014-03-13 Thread Jeff McKenna
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

Re: [mapserver-users] join shp with csv

2014-03-13 Thread 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/da

Re: [mapserver-users] join shp with csv

2014-03-13 Thread Jörg Thomsen
Hi, Here's the whole stuff: http://mapmedia.de/mmcloud/public.php?service=files&t=183cade70207677cda0e32c146ff3a3c > ogrinfo join.csv join -summary this works. Jörg Am 13.03.2014 11:41, schrieb Rahkonen Jukka (Tike): > Hi, > > Could you send the whole LAYER section? And if you can put a small

Re: [mapserver-users] join shp with csv

2014-03-13 Thread Rahkonen Jukka (Tike)
Hi, Could you send the whole LAYER section? And if you can put a small shapefile to download I can have a try. About ogrinfo, your command is searching for layer "lookup" from csv file join.csc. It does not have such layer, it has exactly one layer and it is "join". So do ogrinfo join.csv join

[mapserver-users] join shp with csv

2014-03-13 Thread Jörg Thomsen
hi again, I am still preparing my MapServer workshop for FOSGISS in Berlin next week. Last topic is a join-example and I cannot get it to work :( this is my join in the layer: > JOIN > NAME "test" > CONNECTIONTYPE CSV > TABLE "./shapes_join/join.csv" > FROM "osm_id" > TO "1"