<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Even,</tt><tt><br>
</tt><tt><br>
</tt><tt>here is the complete output:</tt><tt><br>
</tt>
<blockquote><tt>Shape: DBF Codepage = LDID/87 for
D:/act_docs_pierluigi/act_dev/test_gdal_sqlite/xrs_2010jan21_mf2_geometry_polygons.shp</tt><tt><br>
</tt><tt>Shape: Treating as encoding 'ISO-8859-1'.</tt><tt><br>
</tt><tt>OGR:
OGROpen(D:/act_docs_pierluigi/act_dev/test_gdal_sqlite/xrs_2010jan21_mf2_geometry_polygons.shp/00440BB0)
succeeded as ESRI Shapefile.</tt><tt><br>
</tt><tt>SQLITE: OGR style SQLite DB found !</tt><tt><br>
</tt><tt>SQLITE: Spatialite not available. Implementing a few
functions</tt><tt><br>
</tt><tt>OGR2SQLITE: sqlite3_declare_vtab(CREATE TABLE
"xrs_2010jan21_mf2_geometry_polygons"("et" FLOAT,"utc"
VARCHAR(25),"met" VARCHAR(11),"tint" FLOAT,"SunPosX_J2"
FLOAT,"SunPosY_J2" FLOAT,"SunPosZ_J2" FLOAT,"SCPosX_J2"
FLOAT,"SCPosY_J2" FLOAT,"SCPosZ_J2" FLOAT,"SCVelX_J2"
FLOAT,"SCVelY_J2" FLOAT,"SCVelZ_J2" FLOAT,"TargPlanet"
VARCHAR(22),"TP_PosX_J2" FLOAT,"TP_PosY_J2" FLOAT,"TP_PosZ_J2"
FLOAT,"TP2SunX_J2" FLOAT,"TP2SunY_J2" FLOAT,"TP2SunZ_J2"
FLOAT,"TP2SunX_TF" FLOAT,"TP2SunY_TF" FLOAT,"TP2SunZ_TF"
FLOAT,"TP2SC_x_J2" FLOAT,"TP2SC_y_J2" FLOAT,"TP2SC_z_J2"
FLOAT,"TP2SC_x_TF" FLOAT,"TP2SC_y_TF" FLOAT,"TP2SC_z_TF"
FLOAT,"TP_VelX_J2" FLOAT,"TP_VelY_J2" FLOAT,"TP_VelZ_J2"
FLOAT,"TPtrueAnom" FLOAT,"SC2TPctrD" FLOAT,"SubSCLAT"
FLOAT,"SubSCLON" FLOAT,"NADIR_ALT" FLOAT,"SubSolLAT"
FLOAT,"SubSolLON" FLOAT,"sc_inst" VARCHAR(22),"N_BsightV"
VARCHAR(22),"FOV_0" FLOAT,"BS_x_J20" FLOAT,"BS_y_J20"
FLOAT,"BS_z_J20" FLOAT,"BS_x_TBF0" FLOAT,"BS_y_TBF0"
FLOAT,"BS_z_TBF0" FLOAT,"BS_pLon0" FLOAT,"BS_pLat0"
FLOAT,"BS_pEmi0" FLOAT,"BS_pInc0" FLOAT,"BS_pPha0"
FLOAT,"SUN2grnd0" FLOAT,"BS_RA0" FLOAT,"BS_Dec0"
FLOAT,"BS_twist0" FLOAT,"TangHght0" FLOAT,"TH_Lon0"
FLOAT,"TH_Lat0" FLOAT,"pNearTBFx0" FLOAT,"pNearTBFy0"
FLOAT,"pNearTBFz0" FLOAT,"sc2BSdist0" FLOAT,"FOV_1"
FLOAT,"BS_x_J21" FLOAT,"BS_y_J21" FLOAT,"BS_z_J21"
FLOAT,"BS_x_TBF1" FLOAT,"BS_y_TBF1" FLOAT,"BS_z_TBF1"
FLOAT,"BS_pLon1" FLOAT,"BS_pLat1" FLOAT,"BS_pEmi1"
FLOAT,"BS_pInc1" FLOAT,"BS_pPha1" FLOAT,"SUN2grnd1"
FLOAT,"BS_RA1" FLOAT,"BS_Dec1" FLOAT,"BS_twist1"
FLOAT,"TangHght1" FLOAT,"TH_Lon1" FLOAT,"TH_Lat1"
FLOAT,"pNearTBFx1" FLOAT,"pNearTBFy1" FLOAT,"pNearTBFz1"
FLOAT,"sc2BSdist1" FLOAT,"FOV_2" FLOAT,"BS_x_J22"
FLOAT,"BS_y_J22" FLOAT,"BS_z_J22" FLOAT,"BS_x_TBF2"
FLOAT,"BS_y_TBF2" FLOAT,"BS_z_TBF2" FLOAT,"BS_pLon2"
FLOAT,"BS_pLat2" FLOAT,"BS_pEmi2" FLOAT,"BS_pInc2"
FLOAT,"BS_pPha2" FLOAT,"SUN2grnd2" FLOAT,"BS_RA2"
FLOAT,"BS_Dec2" FLOAT,"BS_twist2" FLOAT,"TangHght2"
FLOAT,"TH_Lon2" FLOAT,"TH_Lat2" FLOAT,"pNearTBFx2"
FLOAT,"pNearTBFy2" FLOAT,"pNearTBFz2" FLOAT,"sc2BSdist2"
FLOAT,"FOV_3" FLOAT,"BS_x_J23" FLOAT,"BS_y_J23" FLOAT,"BS_z_J23"
FLOAT,"BS_x_TBF3" FLOAT,"BS_y_TBF3" FLOAT,"BS_z_TBF3"
FLOAT,"BS_pLon3" FLOAT,"BS_pLat3" FLOAT,"BS_pEmi3"
FLOAT,"BS_pInc3" FLOAT,"BS_pPha3" FLOAT,"SUN2grnd3"
FLOAT,"BS_RA3" FLOAT,"BS_Dec3" FLOAT,"BS_twist3"
FLOAT,"TangHght3" FLOAT,"TH_Lon3" FLOAT,"TH_Lat3"
FLOAT,"pNearTBFx3" FLOAT,"pNearTBFy3" FLOAT,"pNearTBFz3"
FLOAT,"sc2BSdist3" FLOAT,"FOV_4" FLOAT,"BS_x_J24"
FLOAT,"BS_y_J24" FLOAT,"BS_z_J24" FLOAT,"BS_x_TBF4"
FLOAT,"BS_y_TBF4" FLOAT,"BS_z_TBF4" FLOAT,"BS_pLon4"
FLOAT,"BS_pLat4" FLOAT,"BS_pEmi4" FLOAT,"BS_pInc4"
FLOAT,"BS_pPha4" FLOAT,"SUN2grnd4" FLOAT,"BS_RA4"
FLOAT,"BS_Dec4" FLOAT,"BS_twist4" FLOAT,"TangHght4"
FLOAT,"TH_Lon4" FLOAT,"TH_Lat4" FLOAT,"pNearTBFx4"
FLOAT,"pNearTBFy4" FLOAT,"pNearTBFz4" FLOAT,"sc2BSdist4"
FLOAT,"FOV_5" FLOAT,"BS_x_J25" FLOAT,"BS_y_J25" FLOAT,"BS_z_J25"
FLOAT,"BS_x_TBF5" FLOAT,"BS_y_TBF5" FLOAT,"BS_z_TBF5"
FLOAT,"BS_pLon5" FLOAT,"BS_pLat5" FLOAT,"BS_pEmi5"
FLOAT,"BS_pInc5" FLOAT,"BS_pPha5" FLOAT,"SUN2grnd5"
FLOAT,"BS_RA5" FLOAT,"BS_Dec5" FLOAT,"BS_twist5"
FLOAT,"TangHght5" FLOAT,"TH_Lon5" FLOAT,"TH_Lat5"
FLOAT,"pNearTBFx5" FLOAT,"pNearTBFy5" FLOAT,"pNearTBFz5"
FLOAT,"sc2BSdist5" FLOAT,"FOV_6" FLOAT,"BS_x_J26"
FLOAT,"BS_y_J26" FLOAT,"BS_z_J26" FLOAT,"BS_x_TBF6"
FLOAT,"BS_y_TBF6" FLOAT,"BS_z_TBF6" FLOAT,"BS_pLon6"
FLOAT,"BS_pLat6" FLOAT,"BS_pEmi6" FLOAT,"BS_pInc6"
FLOAT,"BS_pPha6" FLOAT,"SUN2grnd6" FLOAT,"BS_RA6"
FLOAT,"BS_Dec6" FLOAT,"BS_twist6" FLOAT,"TangHght6"
FLOAT,"TH_Lon6" FLOAT,"TH_Lat6" FLOAT,"pNearTBFx6"
FLOAT,"pNearTBFy6" FLOAT,"pNearTBFz6" FLOAT,"sc2BSdist6"
FLOAT,"BS2SCv_ang" FLOAT,"IFOVatrack" FLOAT,"IFOVxtrack"
FLOAT,"a-smear" FLOAT,"x-smear" FLOAT,"a-azimuth"
FLOAT,"BLatStart" FLOAT,"BLonStart" FLOAT,"BLatEnd"
FLOAT,"BLonEnd" FLOAT,"MET" VARCHAR(15),"EDRFILE"
VARCHAR(14),OGR_STYLE VARCHAR HIDDEN,"GEOMETRY"
BLOB_POLYGON_2D))</tt><tt><br>
</tt><tt>ERROR 1: Cannot create virtual table for layer
'xrs_2010jan21_mf2_geometry_polygons' : CREATE VIRTUAL: invalid
SQL statement : CREATE TABLE
"xrs_2010jan21_mf2_geometry_polygons"("et" FLOAT,"utc"
VARCHAR(25),"met" VARCHAR(11),"tint" FLOAT,"SunPosX_J2"
FLOAT,"SunPosY_J2" FLOAT,"SunPosZ_J2" FLOAT,"SCPosX_J2"
FLOAT,"SCPosY_J2" FLOAT,"SCPosZ_J2" FLOAT,"SCVelX_J2"
FLOAT,"SCVelY_J2" FLOAT,"SCVelZ_J2" FLOAT,"TargPlanet"
VARCHAR(22),"TP_PosX_J2" FLOAT,"TP_PosY_J2" FLOAT,"TP_PosZ_J2"
FLOAT,"TP2SunX_J2" FLOAT,"TP2SunY_J2" FLOAT,"TP2SunZ_J2"
FLOAT,"TP2SunX_TF" FLOAT,"TP2SunY_TF" FLOAT,"TP2SunZ_TF"
FLOAT,"TP2SC_x_J2" FLOAT,"TP2SC_y_J2" FLOAT,"TP2SC_z_J2"
FLOAT,"TP2SC_x_TF" FLOAT,"TP2SC_y_TF" FLOAT,"TP2SC_z_TF"
FLOAT,"TP_VelX_J2" FLOAT,"TP_VelY_J2" FLOAT,"TP_VelZ_J2"
FLOAT,"TPtrueAnom" FLOAT,"SC2TPctrD" FLOAT,"SubSCLAT"
FLOAT,"SubSCLON" FLOAT,"NADIR_ALT" FLOAT,"SubSolLAT"
FLOAT,"SubSolLON" FLOAT,"sc_inst" VARCHAR(22),"N_BsightV"
VARCHAR(22),"FOV_0" FLOAT,"BS_x_J20" FLOAT,"BS_y_J20"
FLOAT,"BS_z_J20" FLOAT,"BS_x_TBF0" FLOAT,"BS_y_TBF0"
FLOAT,"BS_z_TBF0" FLOAT,"BS_pLon0" FLOAT,"BS_pLat0"
FLOAT,"BS_pEmi0" FLOAT,"BS_pInc0" FLOAT,"BS_pPha0"
FLOAT,"SUN2grnd0" FLOAT,"BS_RA0" FLOAT,"BS_Dec0"
FLOAT,"BS_twist0" FLOAT,"TangHght0" FLOAT,"TH_Lon0"
FLOAT,"TH_Lat0" FLOAT,"pNearTBFx0" FLOAT,"pNearTBFy0"
FLOAT,"pNearTBFz0" FLOAT,"sc2BSdist0" FLOAT,"FOV_1"
FLOAT,"BS_x_J21" FLOAT,"BS_y_J21" FLOAT,"BS_z_J21"
FLOAT,"BS_x_TBF1" FLOAT,"BS_y_TBF1" FLOAT,"BS_z_TBF1"
FLOAT,"BS_pLon1" FLOAT,"BS_pLat1" FLOAT,"BS_pEmi1"
FLOAT,"BS_pInc1" FLOAT,"BS_pPha1" FLOAT,"SUN2grnd1"
FLOAT,"BS_RA1" FLOAT,"BS_Dec1" FLOAT,"BS_twist1"
FLOAT,"TangHght1" FLOAT,"TH_Lon1" FLOAT,"TH_Lat1"
FLOAT,"pNearTBFx1" FLOAT,"pNearTBFy1" FLOAT,"pNearTBFz1"
FLOAT,"sc2BSdist1" FLOAT,"FOV_2" FLOAT,"BS_x_J22"
FLOAT,"BS_y_J22" FLOAT,"BS_z_J22" FLOAT,"BS_x_TBF2"
FLOAT,"BS_y_TBF2" FLOAT,"BS_z_TBF2" FLOAT,"BS_pLon2"
FLOAT,"BS_pLat2" FLOAT,"BS_pEmi2" FLOAT,"BS_pInc2"
FLOAT,"BS_pPha2" FLOAT,"SUN2grnd2" FLOAT,"BS_RA2"
FLOAT,"BS_Dec2" FLOAT,"BS_twist2" FLOAT,"TangHght2"
FLOAT,"TH_Lon2" FLOAT,"TH_Lat2" FLOAT,"pNearTBFx2"
FLOAT,"pNearTBFy2" FLOAT,"pNearTBFz2" FLOAT,"sc2BSdist2"
FLOAT,"FOV_3" FLOAT,"BS_x_J23" FLOAT,"BS_y_J23" FLOAT,"BS_z_J23"
FLOAT,"BS_x_TBF3" FLOAT,"BS_y_TBF3" FLOAT,"BS_z_TBF3"
FLOAT,"BS_pLon3" FLOAT,"BS_pLat3" FLOAT,"BS_pEmi3"
FLOAT,"BS_pInc3" FLOAT,"BS_pPha3" FLOAT,"SUN2grnd3"
FLOAT,"BS_RA3" FLOAT,"BS_Dec3" FLOAT,"BS_twist3"
FLOAT,"TangHght3" FLOAT,"TH_Lon3" FLOAT,"TH_Lat3"
FLOAT,"pNearTBFx3" FLOAT,"pNearTBFy3" FLOAT,"pNearTBFz3"
FLOAT,"sc2BSdist3" FLOAT,"FOV_4" FLOAT,"BS_x_J24"
FLOAT,"BS_y_J24" FLOAT,"BS_z_J24" FLOAT,"BS_x_TBF4"
FLOAT,"BS_y_TBF4" FLOAT,"BS_z_TBF4" FLOAT,"BS_pLon4"
FLOAT,"BS_pLat4" FLOAT,"BS_pEmi4" FLOAT,"BS_pInc4"
FLOAT,"BS_pPha4" FLOAT,"SUN2grnd4" FLOAT,"BS_RA4"
FLOAT,"BS_Dec4" FLOAT,"BS_twist4" FLOAT,"TangHght4"
FLOAT,"TH_Lon4" FLOAT,"TH_Lat4" FLOAT,"pNearTBFx4"
FLOAT,"pNearTBFy4" FLOAT,"pNearTBFz4" FLOAT,"sc2BSdist4"
FLOAT,"FOV_5" FLOAT,"BS_x_J25" FLOAT,"BS_y_J25" FLOAT,"BS_z_J25"
FLOAT,"BS_x_TBF5" FLOAT,"BS_y_TBF5" FLOAT,"BS_z_TBF5"
FLOAT,"BS_pLon5" FLOAT,"BS_pLat5" FLOAT,"BS_pEmi5"
FLOAT,"BS_pInc5" FLOAT,"BS_pPha5" FLOAT,"SUN2grnd5"
FLOAT,"BS_RA5" FLOAT,"BS_Dec5" FLOAT,"BS_twist5"
FLOAT,"TangHght5" FLOAT,"TH_Lon5" FLOAT,"TH_Lat5"
FLOAT,"pNearTBFx5" FLOAT,"pNearTBFy5" FLOAT,"pNearTBFz5"
FLOAT,"sc2BSdist5" FLOAT,"FOV_6" FLOAT,"BS_x_J26"
FLOAT,"BS_y_J26" FLOAT,"BS_z_J26" FLOAT,"BS_x_TBF6"
FLOAT,"BS_y_TBF6" FLOAT,"BS_z_TBF6" FLOAT,"BS_pLon6"
FLOAT,"BS_pLat6" FLOAT,"BS_pEmi6" FLOAT,"BS_pInc6"
FLOAT,"BS_pPha6" FLOAT,"SUN2grnd6" FLOAT,"BS_RA6"
FLOAT,"BS_Dec6" FLOAT,"BS_twist6" FLOAT,"TangHght6"
FLOAT,"TH_Lon6" FLOAT,"TH_Lat6" FLOAT,"pNearTBFx6"
FLOAT,"pNearTBFy6" FLOAT,"pNearTBFz6" FLOAT,"sc2BSdist6"
FLOAT,"BS2SCv_ang" FLOAT,"IFOVatrack" FLOAT,"IFOVxtrack"
FLOAT,"a-smear" FLOAT,"x-smear" FLOAT,"a-azimuth"
FLOAT,"BLatStart" FLOAT,"BLonStart" FLOAT,"BLatEnd"
FLOAT,"BLonEnd" FLOAT,"MET" VARCHAR(15),"EDRFILE"
VARCHAR(14),OGR_STYLE VARCHAR HIDDEN,"GEOMETRY" BLOB_POLYGON_2D)</tt><tt><br>
</tt><tt>SQLITE: OGR style SQLite DB found !</tt><tt><br>
</tt><tt>ERROR 1: In ExecuteSQL(): sqlite3_prepare(select * from
xrs_2010jan21_mf2_geometry_polygons):</tt><tt><br>
</tt><tt> no such table: xrs_2010jan21_mf2_geometry_polygons</tt><tt><br>
</tt><tt>OGR: Unloading VirtualOGR module</tt><tt><br>
</tt><tt>SQL syntax error: In ExecuteSQL(): sqlite3_prepare(select
* from xrs_2010jan21_mf2_geometry_polygons):</tt><tt><br>
</tt><tt> no such table: xrs_2010jan21_mf2_geometry_polygons</tt><tt><br>
</tt></blockquote>
<tt><br>
</tt><tt>And this is the output of the "ogrinfo" command:</tt><tt><br>
</tt>
<blockquote><tt>Shape: DBF Codepage = LDID/87 for
xrs_2010jan21_mf2_geometry_polygons.shp</tt><tt><br>
</tt><tt>Shape: Treating as encoding 'ISO-8859-1'.</tt><tt><br>
</tt><tt>OGR:
OGROpen(xrs_2010jan21_mf2_geometry_polygons.shp/00FC5F78)
succeeded as ESRI Shapefile.</tt><tt><br>
</tt><tt>OGR: GetLayerCount() = 1</tt><tt><br>
</tt><tt><br>
</tt><tt>INFO: Open of `xrs_2010jan21_mf2_geometry_polygons.shp'</tt><tt><br>
</tt><tt> using driver `ESRI Shapefile' successful.</tt><tt><br>
</tt><tt><br>
</tt><tt>Layer name: xrs_2010jan21_mf2_geometry_polygons</tt><tt><br>
</tt><tt>Geometry: Polygon</tt><tt><br>
</tt><tt>Feature Count: 16</tt><tt><br>
</tt><tt>Extent: (-155.072038, -8.925269) - (-28.963009, 6.616499)</tt><tt><br>
</tt><tt>Layer SRS WKT:</tt><tt><br>
</tt><tt>(unknown)</tt><tt><br>
</tt><tt>et: Real (24.15)</tt><tt><br>
</tt><tt>utc: String (25.0)</tt><tt><br>
</tt><tt>met: String (11.0)</tt><tt><br>
</tt><tt>tint: Real (24.15)</tt><tt><br>
</tt><tt>SunPosX_J2: Real (24.15)</tt><tt><br>
</tt><tt>SunPosY_J2: Real (24.15)</tt><tt><br>
</tt><tt>SunPosZ_J2: Real (24.15)</tt><tt><br>
</tt><tt>SCPosX_J2: Real (24.15)</tt><tt><br>
</tt><tt>SCPosY_J2: Real (24.15)</tt><tt><br>
</tt><tt>SCPosZ_J2: Real (24.15)</tt><tt><br>
</tt><tt>SCVelX_J2: Real (24.15)</tt><tt><br>
</tt><tt>SCVelY_J2: Real (24.15)</tt><tt><br>
</tt><tt>SCVelZ_J2: Real (24.15)</tt><tt><br>
</tt><tt>TargPlanet: String (22.0)</tt><tt><br>
</tt><tt>TP_PosX_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP_PosY_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP_PosZ_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SunX_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SunY_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SunZ_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SunX_TF: Real (24.15)</tt><tt><br>
</tt><tt>TP2SunY_TF: Real (24.15)</tt><tt><br>
</tt><tt>TP2SunZ_TF: Real (24.15)</tt><tt><br>
</tt><tt>TP2SC_x_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SC_y_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SC_z_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP2SC_x_TF: Real (24.15)</tt><tt><br>
</tt><tt>TP2SC_y_TF: Real (24.15)</tt><tt><br>
</tt><tt>TP2SC_z_TF: Real (24.15)</tt><tt><br>
</tt><tt>TP_VelX_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP_VelY_J2: Real (24.15)</tt><tt><br>
</tt><tt>TP_VelZ_J2: Real (24.15)</tt><tt><br>
</tt><tt>TPtrueAnom: Real (24.15)</tt><tt><br>
</tt><tt>SC2TPctrD: Real (24.15)</tt><tt><br>
</tt><tt>SubSCLAT: Real (24.15)</tt><tt><br>
</tt><tt>SubSCLON: Real (24.15)</tt><tt><br>
</tt><tt>NADIR_ALT: Real (24.15)</tt><tt><br>
</tt><tt>SubSolLAT: Real (24.15)</tt><tt><br>
</tt><tt>SubSolLON: Real (24.15)</tt><tt><br>
</tt><tt>sc_inst: String (22.0)</tt><tt><br>
</tt><tt>N_BsightV: String (22.0)</tt><tt><br>
</tt><tt>FOV_0: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J20: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J20: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J20: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF0: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF0: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF0: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon0: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat0: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi0: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc0: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha0: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd0: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA0: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec0: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist0: Real (24.15)</tt><tt><br>
</tt><tt>TangHght0: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon0: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat0: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx0: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy0: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz0: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist0: Real (24.15)</tt><tt><br>
</tt><tt>FOV_1: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J21: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J21: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J21: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF1: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF1: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF1: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon1: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat1: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi1: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc1: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha1: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd1: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA1: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec1: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist1: Real (24.15)</tt><tt><br>
</tt><tt>TangHght1: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon1: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat1: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx1: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy1: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz1: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist1: Real (24.15)</tt><tt><br>
</tt><tt>FOV_2: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J22: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J22: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J22: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF2: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF2: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF2: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon2: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat2: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi2: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc2: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha2: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd2: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA2: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec2: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist2: Real (24.15)</tt><tt><br>
</tt><tt>TangHght2: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon2: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat2: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx2: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy2: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz2: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist2: Real (24.15)</tt><tt><br>
</tt><tt>FOV_3: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J23: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J23: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J23: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF3: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF3: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF3: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon3: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat3: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi3: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc3: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha3: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd3: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA3: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec3: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist3: Real (24.15)</tt><tt><br>
</tt><tt>TangHght3: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon3: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat3: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx3: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy3: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz3: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist3: Real (24.15)</tt><tt><br>
</tt><tt>FOV_4: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J24: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J24: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J24: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF4: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF4: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF4: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon4: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat4: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi4: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc4: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha4: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd4: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA4: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec4: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist4: Real (24.15)</tt><tt><br>
</tt><tt>TangHght4: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon4: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat4: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx4: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy4: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz4: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist4: Real (24.15)</tt><tt><br>
</tt><tt>FOV_5: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J25: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J25: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J25: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF5: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF5: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF5: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon5: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat5: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi5: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc5: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha5: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd5: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA5: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec5: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist5: Real (24.15)</tt><tt><br>
</tt><tt>TangHght5: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon5: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat5: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx5: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy5: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz5: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist5: Real (24.15)</tt><tt><br>
</tt><tt>FOV_6: Real (11.0)</tt><tt><br>
</tt><tt>BS_x_J26: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_J26: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_J26: Real (24.15)</tt><tt><br>
</tt><tt>BS_x_TBF6: Real (24.15)</tt><tt><br>
</tt><tt>BS_y_TBF6: Real (24.15)</tt><tt><br>
</tt><tt>BS_z_TBF6: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLon6: Real (24.15)</tt><tt><br>
</tt><tt>BS_pLat6: Real (24.15)</tt><tt><br>
</tt><tt>BS_pEmi6: Real (24.15)</tt><tt><br>
</tt><tt>BS_pInc6: Real (24.15)</tt><tt><br>
</tt><tt>BS_pPha6: Real (24.15)</tt><tt><br>
</tt><tt>SUN2grnd6: Real (24.15)</tt><tt><br>
</tt><tt>BS_RA6: Real (24.15)</tt><tt><br>
</tt><tt>BS_Dec6: Real (24.15)</tt><tt><br>
</tt><tt>BS_twist6: Real (24.15)</tt><tt><br>
</tt><tt>TangHght6: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lon6: Real (24.15)</tt><tt><br>
</tt><tt>TH_Lat6: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFx6: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFy6: Real (24.15)</tt><tt><br>
</tt><tt>pNearTBFz6: Real (24.15)</tt><tt><br>
</tt><tt>sc2BSdist6: Real (24.15)</tt><tt><br>
</tt><tt>BS2SCv_ang: Real (24.15)</tt><tt><br>
</tt><tt>IFOVatrack: Real (24.15)</tt><tt><br>
</tt><tt>IFOVxtrack: Real (24.15)</tt><tt><br>
</tt><tt>a-smear: Real (24.15)</tt><tt><br>
</tt><tt>x-smear: Real (24.15)</tt><tt><br>
</tt><tt>a-azimuth: Real (24.15)</tt><tt><br>
</tt><tt>BLatStart: Real (24.15)</tt><tt><br>
</tt><tt>BLonStart: Real (24.15)</tt><tt><br>
</tt><tt>BLatEnd: Real (24.15)</tt><tt><br>
</tt><tt>BLonEnd: Real (24.15)</tt><tt><br>
</tt><tt>MET: String (15.0)</tt><tt><br>
</tt><tt>EDRFILE: String (14.0)</tt><tt><br>
</tt></blockquote>
<tt><br>
</tt><tt>Thanks a lot!</tt><tt><br>
</tt><tt>Pierluigi</tt><br>
<br>
<div class="moz-cite-prefix">Il 10/02/2015 18:49, Even Rouault ha
scritto:<br>
</div>
<blockquote cite="mid:201502101849.31932.even.rouault@spatialys.com"
type="cite">
<pre wrap="">Le mardi 10 février 2015 18:20:12, Pierluigi Guasqui a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Even,
I set the environment variable CPL_DEBUG=ON and rerun my code. I found
the statement you mentioned:
SQLITE: OGR style SQLite DB found !
SQLITE: Spatialite not available. Implementing a few functions
OGR2SQLITE: sqlite3_declare_vtab(CREATE TABLE
"xrs_2010jan21_mf2_geometry_polygons"("et" FLOAT,"utc" VARCHAR(25), ...
but then it printed the following error:
ERROR 1: Cannot create virtual table for layer
'xrs_2010jan21_mf2_geometry_polygons' : CREATE VIRTUAL: invalid SQL
statement : CREATE TABLE "xrs_2010jan21_mf2_geometry_polygons"("et"
FLOAT,"utc" VARCHAR(25), ...
SQLITE: OGR style SQLite DB found !
ERROR 1: In ExecuteSQL(): sqlite3_prepare(select * from
xrs_2010jan21_mf2_geometry_polygons):
no such table: xrs_2010jan21_mf2_geometry_polygons
OGR: Unloading VirtualOGR module
</pre>
</blockquote>
<pre wrap="">
Could you paste the full (untruncated) statement ?
And the output of "ogrinfo -al -so yourshapefile.shp" also
</pre>
<blockquote type="cite">
<pre wrap="">
Any idea why I am getting this error?
Thank you!
Pierluigi
Il 10/02/2015 13:42, Even Rouault ha scritto:
</pre>
<blockquote type="cite">
<pre wrap="">Le mardi 10 février 2015 12:47:46, Pierluigi Guasqui a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Hi All!
I am using the GDAL/OGR functions to query a shapefile. This is a sample
code I have been successfully running so far:
OGRDataSource *poDS = OGRSFDriverRegistrar::Open(
"some/path/to/myshapefile.shp" );
OGRLayer *poLayer = poDS->ExecuteSQL( "select * from myshapefile",
NULL, NULL );
// ...
// fetching result features from "poLayer"
// ...
poDS->ReleaseResultSet( poLayer );
OGRDataSource::DestroyDataSource(poDS);
As you can see, I am currently using the OGR SQL dialect, as I am
passing NULL as the third parameter of the OGRDataSource::ExecuteSQL
function.
Now I am trying to extend the SQL syntax to be able to use the OGR
SQLite dialect. I have successfully recompiled GDAL 1.11.1 with SQLite
support (version 3.8.5) but when I try to execute the same sample code
(passing "SQLITE" as the 3rd argument of the OGRDataSource::ExecuteSQL
function) I am getting the following error:
In ExecuteSQL(): sqlite3_prepare(select * from myshapefile): no
such table: myshapefile
What is the table name that contains the shapefile features that I can
use in my SQL queries?
</pre>
</blockquote>
<pre wrap="">
Pierluigi,
That should work... If you tried to configure GDAL several times, perhaps
you should do a make clean.
Could you try defining CPL_DEBUG=ON as environment variable and rerun
your code. You should normally see a statement like the following one to
create the SQLite virtual table that matches the shapefile layer :
OGR2SQLITE: sqlite3_declare_vtab(CREATE TABLE "poly"("AREA"
FLOAT,"EAS_ID" FLOAT,"PRFEDEA" VARCHAR(16),OGR_STYLE VARCHAR
HIDDEN,"GEOMETRY"
BLOB_POLYGON_2D_50000))
Even
</pre>
</blockquote>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Pierluigi Guasqui
Software Engineer
Applied Coherent Technology Corporation (ACT)
<a class="moz-txt-link-abbreviated" href="http://www.actgate.com">www.actgate.com</a></pre>
</body>
</html>