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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Spatialys - Geospatial professional services http://www.spatialys.com _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
