<br clear="all">Hi everyone<div><br></div><div>I'm using OGR with the SQLite driver, calling </div><div><br></div><div>OGR::DataSource::ExecuteSQL ()</div><div><br></div><div>By examining the sqlite file I've discovered that the geometry column is named , well, GEOMETRY. </div>
<div><br></div><div>So I do something like</div><div><br></div><div>SELECT name, GEOMETRY as G from world</div><div><br></div><div>which gives me a resulting layer with these two columns. But when copying that layer using </div>
<div><br></div><div>OGRDataSource::CopyLayer ( )</div><div><br></div><div>I'm getting </div><div><br></div><div><span style=" color:#000000;">In GetNextRawFeature(): sqlite3_step() : not an error</span></div><div><span style=" color:#000000;"><br>
</span></div><div><span style=" color:#000000;">I guess that the geometry BLOB column is not recognized as geometry during the copy, maybe. </span></div><div><span style=" color:#000000;"><br></span></div><div><span style=" color:#000000;">So : Does anyone know how to do these kinds of SQL operations that preserve the geometry column in a way that can be used in subsequent operations, like layer copying ? </span></div>
<div><span style=" color:#000000;"><br></span></div><div><span style=" color:#000000;"> Also, the OGRAPI does not seem to support any notion of geometry column name. Anyone know a way around this ? </span></div><div><br></div>
<div> </div><div>Cheers, </div><div>Anders<br><div>-- <br><br>________________________________________________________<br><br>Anders Moe<br><br>Technical Manager<br>Geocap<br>w: +47 22 95 56 66<br><a href="mailto:anders.moe@geocap.no">anders.moe@geocap.no</a><br>
________________________________________________________<br><br><br><br> <br><br>
</div></div>