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

[Ian Walberg]

Simon,

We tried this yesterday but could not see how to include the sql statement in the vrt file so that mapserver got an fid for each record.

Thanks

Ian

-----Original Message-----
From: Simon Mercier [mailto:smercier at mapgears.com] 
Sent: Tuesday, April 26, 2016 8:01 AM
To: Ian Walberg <ian.walberg at airborne.aero>; mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] RE OGR csv - no field names

Ian

Try with FID field, OGR generate this ID for you. But you should try use your own ID field for consistency between version of your data (if needed). I tested with my demo data and I can select FID even if it doesn't exist in source file.

<OGRVRTDataSource>
     <OGRVRTLayer name="Inventory">
<SrcDataSource>/home/smercier/data/vrt/Inventory.csv</SrcDataSource>
         <GeometryType>wkbPoint</GeometryType>
         <LayerSRS>EPSG:4326</LayerSRS>
         <GeometryField encoding="PointFromColumns" x="longitude" 
y="latitude"/>
         <Field name="site_name" src="SiteName"/>
         <Field name="site_phone" src="SitePhone"/>
         <Field name="site_type" src="SiteType"/>
         <Field name="address" src="address"/>
         <Field name="site_aed_placement" src="AEDPlacementLocation"/>
     </OGRVRTLayer>
</OGRVRTDataSource>

smercier at optimus: $ ogrinfo Inventory.vrt -sql "select fid from Inventory"
INFO: Open of `Inventory.vrt'
       using driver `VRT' successful.

Layer name: Inventory
Geometry: Point
Feature Count: 117
Extent: (-80.977043, 0.000000) - (0.000000, 43.978620) Layer SRS WKT:
GEOGCS["WGS 84",
     DATUM["WGS_1984",
         SPHEROID["WGS 84",6378137,298.257223563,
             AUTHORITY["EPSG","7030"]],
         AUTHORITY["EPSG","6326"]],
     PRIMEM["Greenwich",0,
         AUTHORITY["EPSG","8901"]],
     UNIT["degree",0.0174532925199433,
         AUTHORITY["EPSG","9122"]],
     AUTHORITY["EPSG","4326"]]
fid: Integer (0.0)
OGRFeature(Inventory):1
   fid (Integer) = 1
   POINT (-80.2171407 43.4970847)

OGRFeature(Inventory):2
   fid (Integer) = 2
   POINT (-80.5357573 43.8367679)

OGRFeature(Inventory):3
   fid (Integer) = 3
   POINT (0 0)
....


On 16-04-25 07:11 PM, Ian Walberg wrote:
> Jeff,
>
> Many thanks that worked great.
>
> Next is there any way of getting the row ID as part of the data passed to mapserver?
>
> We are planning to serve this data as a WFS layer.
>
> Thanks
>
> Ian
>
> -----Original Message-----
> From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] 
> On Behalf Of Jeff McKenna
> Sent: Monday, April 25, 2016 3:03 PM
> To: mapserver-users at lists.osgeo.org
> Subject: Re: [mapserver-users] RE OGR csv - no field names
>
> On 2016-04-25 6:49 PM, Simon Mercier wrote:
>> 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"
>> />
>>
> Simon is right, very nice, specifying the field name to classify in the vrt works, for a csv without field names:
>
> <OGRVRTDataSource>
>       <OGRVRTLayer name="occurrence">
>           <SrcDataSource relativeToVRT="1">CSV:occurrence.txt</SrcDataSource>
>           <GeometryType>wkbPoint</GeometryType>
>           <LayerSRS>WGS84</LayerSRS>
>           <GeometryField encoding="PointFromColumns" x="field_37"
> y="field_38"/>
>           <Field name="name" src="field_51" type="String" width="100"/>
>       </OGRVRTLayer>
> </OGRVRTDataSource>
>
>
>
> LAYER
>     NAME "occurrence"
>     TYPE POINT
>     STATUS ON
>     CONNECTIONTYPE OGR
>     CONNECTION "../occurrence.vrt"
>     CLASSITEM "name"
>     CLASS
>       NAME "Occurrences"
>       EXPRESSION "ttt"
>       STYLE
>         SYMBOL 7
>         SIZE 10
>         COLOR 0 0 0
>       END
>     END
> END # Layer
>
>
> -jeff
>
>
>
>
>
> --
> Jeff McKenna
> MapServer Consulting and Training Services 
> http://www.gatewaygeomatics.com/
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> 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