[mapserver-users] join shp with csv

[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 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