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 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 -summary > > This is not your fault, obviously the one who wrote the documentation > remembers all the GDAL commands with eyes shut but author did not remember > that documentation is meant for wider audience. I would have written the > command without layer name but used the generally working switch -al (all > layers) instead. > > ogrinfo -al -so lookup.csv > > -Jukka Rahkonen- > > > Jörg Thomsen wrote: > > > >> 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" >>> # TO "0" >>> # TO "tab_1" >>> # TO "osm_id" >>> TYPE ONE-TO-ONE >>> END >> >> the first lines of the csv: >>> osm_id;name_join >>> 21484050;Karlshorst >>> 21484076;Schmöckwitz >>> 21484102;Adlershof >>> 27380127;Bohnsdorf >>> 28094136;Schöneberg >> >> and here is the featureonfo-output: >> GetFeatureInfo results: >> >> Layer 'places' >> Feature 137: >> osm_id = '560483810' >> name = 'Neu-Hohenschönhausen' >> type = 'suburb' >> population = ''' >> >> no 'name_join' :( >> >> 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! >> >> This is my only hint but unfortunatly I don't know what ogr wants to tell me. >> >> regards, Jörg >> >> >> -- >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Aufwind durch Wissen! >> >> Qualifizierte Open Source Schulungen bei der http://www.foss-akademie.de/ >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> >> >> _________________________________________________ >> >> MapMedia >> Kartographie und raumbezogene Informationssysteme >> >> Gillweg 3, 14193 Berlin >> fon: +49 30 89 06 82-70 >> fax: +49 30 89 09 53-21 >> mail: [email protected] >> net: www.mapmedia.de >> _________________________________________________ >> >> >> Geschäftsführer: G. v. Tschirnhaus, J. Thomsen, P. Stamm Registergericht, >> Berlin >> - Amtsgericht Charlottenburg, HRB 89625, Umsatzsteuer-Identnummer: DE >> 813794062 _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
