[mapserver-users] RE OGR csv - no field names

[Simon Mercier]

really not sure CSVT file is supported by ogr, but you can easily define 
field type in VRT

         <Field name="precipitation_mm" src="prec_mm" type="Real"/>
         <Field name="field_1" src="field_1" type="String" width="100" />

On 16-04-25 04:32 PM, Ian Walberg wrote:
>
> 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:smercier at mapgears.com]
> *Sent:* Monday, April 25, 2016 10:31 AM
> *To:* Steve.Toutant at inspq.qc.ca; Ian Walberg <ian.walberg at airborne.aero>
> *Cc:* mapserver-users at lists.osgeo.org; mapserver-users 
> <mapserver-users-bounces at lists.osgeo.org>
> *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, Steve.Toutant at inspq.qc.ca 
> <mailto:Steve.Toutant at inspq.qc.ca> 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 <ian.walberg at airborne.aero>
>     <mailto:ian.walberg at airborne.aero>@lists.osgeo.org*
>     Envoyé par : "mapserver-users"
>     <mapserver-users-bounces at lists.osgeo.org>
>     <mailto:mapserver-users-bounces at lists.osgeo.org>
>
>     2016-04-23 22:50
>
>     	
>
>     A
>
>     	
>
>     "mapserver-users at lists.osgeo.org"
>     <mailto:mapserver-users at lists.osgeo.org>
>     <mapserver-users at lists.osgeo.org>
>     <mailto:mapserver-users at lists.osgeo.org>
>
>     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
>     mapserver-users at lists.osgeo.org
>     <mailto:mapserver-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
>
>     _______________________________________________
>
>     mapserver-users mailing list
>
>     mapserver-users at lists.osgeo.org
>     <mailto:mapserver-users at lists.osgeo.org>
>
>     http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> -- 
> simon mercier
> mapgears
> +1.418.476.7139 p101
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users

-- 
simon mercier
mapgears
+1.418.476.7139 p101

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160425/3ac8cf5b/attachment-0001.html>