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:[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
--
simon mercier
mapgears
+1.418.476.7139 p101
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
