Thanks for the ideas. I think the vrt file needs the csv fields to have names unless I misunderstand.
CSVT file – does this specify the column/field data type? Can the name be specified as well? Regards Ian From: Simon Mercier [mailto:[email protected]] Sent: Monday, April 25, 2016 10:31 AM To: [email protected]; Ian Walberg <[email protected]> Cc: [email protected]; mapserver-users <[email protected]> Subject: Re: [mapserver-users] RE OGR csv - no field names why not use a vrt file instead! http://www.gdal.org/drv_vrt.html <OGRVRTDataSource> <OGRVRTLayer name="precipitation"> <SrcDataSource>precipitation.csv</SrcDataSource> <GeometryType>wkbPoint</GeometryType> <LayerSRS>EPSG:4326</LayerSRS> <GeometryField encoding="PointFromColumns" x="lon" y="lat"/> <Field name="precipitation_mm" src="prec_mm"/> </OGRVRTLayer> </OGRVRTDataSource> On 16-04-25 08:01 AM, [email protected]<mailto:[email protected]> wrote: I don't know why LABELITEM 'filed_3' would not work in your case You can try to specify column names by using a .csvt file http://www.gdal.org/drv_csv.html Example: https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/ Ian Walberg <[email protected]><mailto:[email protected]>@lists.osgeo.org Envoyé par : "mapserver-users" <[email protected]><mailto:[email protected]> 2016-04-23 22:50 A "[email protected]"<mailto:[email protected]> <[email protected]><mailto:[email protected]> cc Objet [mapserver-users] OGR csv - no field names Folks, Can a csv file with no field names as the first row be used as an OGR source? GDAL creates dummy field names, are these passed to mapserver? OGRFeature(USA-Hilton):652 field_1 (String) = -74.16958 field_2 (String) = 40.73526 field_3 (String) = Penn Station What do we need in the layer to make this work? LABELITEM 'name' - this throws an error, 'field_3' does not seem to work either. CONNECTIONTYPE OGR CONNECTION 'Stations.csv' Thanks Ian _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users -- simon mercier mapgears +1.418.476.7139 p101
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
