[gdal-dev] OGR Virtual Format: ERROR 1: Line 6: Didn't find element token after open angle bracket.

[Even Rouault]

Le mercredi 01 juillet 2015 22:46:14, Helmut Kudrnovsky a écrit :
> Hi Even,
> 
> 
> Even Rouault-2 wrote
> 
> > <SrcSQL>
> > SELECT * FROM gbif_gisinput WHERE (decimallongitude >= 0) AND
> > 
> >> (decimallongitude <= 360)
> > 
> > </SrcSQL>
> > Helmut,
> > 
> > This is invalid XML. > and < characters as text must be escaped. So
> > should be:
> > <SrcSQL>
> > SELECT * FROM gbif_gisinput WHERE (decimallongitude >= 0) AND
> > (decimallongitude <= 360)
> > </SrcSQL>
> > Even
> 
> thanks for the hint.
> 
> when using an updated vrt (attached file:  gbif_to_gis_not_working_test.vrt
> <http://osgeo-org.1560.x6.nabble.com/file/n5213867/gbif_to_gis_not_working_
> test.vrt> )
> 
> I get now:
> 
> ogr2ogr filtered9.shp gbif_to_gis_not_working_test.vrt
> ERROR 1: Type mismatch or improper type of arguments to >= operator.
> ERROR 1: SQL statement failed, or returned no layer result:
> SELECT * FROM gbif_gisinput WHERE (decimallongitude >= 0) AND
> (decimallongitude
> <= 360)

Look at the CAST operator : http://gdal.org/ogr_sql.html

> 
> thanks.
> 
> 
> 
> 
> -----
> best regards
> Helmut
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/OGR-Virtual-Format-ERROR-1-Line-6-Didn
> -t-find-element-token-after-open-angle-bracket-tp5213859p5213867.html Sent
> from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com