Noli,<br><br>Your destination file has to be before the source file.<br><br><div class="gmail_quote">On Thu, Feb 11, 2010 at 6:19 PM, Noli Sicad <span dir="ltr"><<a href="mailto:nsicad@gmail.com">nsicad@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Yes, this is what I am trying to ask.<br>
<br>
from file:///C:/Program%20Files/FWTools2.4.7/html/drv_sqlite.html<br>
<br>
# Duplicate the sample database provided with SpatiaLite (does not<br>
need explicit linking with SpatiaLite)<br>
ogr2ogr -f SQLite testspatialite.sqlite test-2.3.sqlite -dsco SPATIALITE=YES<br>
<br>
from file:///C:/Program%20Files/FWTools2.4.7/html/drv_csv.html<br>
<br>
ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_XYZ<br>
<br>
Now, any suggestion how I reorganise the arguments?<br>
<br>
Meanwhile, I am using spatial_tools from spatialite some success using<br>
import of dbf tables into spatialite tables but the problem is the<br>
primary key. CVS and DBF tables does not contain any information of<br>
primary key. Hence, no go for sqlite conversion. Convert tables in<br>
sqlite is still useless for SQL querying.<br>
<font color="#888888"><br>
Noli<br>
</font><div><div></div><div class="h5"><br>
<br>
On 2/11/10, Chaitanya kumar CH <<a href="http://chaitanya.ch" target="_blank">chaitanya.ch</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>> wrote:<br>
> Noli,<br>
><br>
> There was a problem with the order of the arguments in your command.<br>
> <a href="http://gdal.org/ogr2ogr.html" target="_blank">http://gdal.org/ogr2ogr.html</a><br>
><br>
> On Thu, Feb 11, 2010 at 5:37 PM, Noli Sicad <<a href="mailto:nsicad@gmail.com">nsicad@gmail.com</a>> wrote:<br>
><br>
>> OK. Sorry<br>
>> This is the error,<br>
>><br>
>> FAILURE:<br>
>> Unable to open datasource `harvest.sqlite' with the following drivers.<br>
>> -> ESRI Shapefile<br>
>> -> MapInfo File<br>
>> -> UK .NTF<br>
>> -> SDTS<br>
>> -> TIGER<br>
>> -> S57<br>
>> -> DGN<br>
>> -> VRT<br>
>> -> REC<br>
>> -> Memory<br>
>> -> BNA<br>
>> -> CSV<br>
>> -> NAS<br>
>> -> GML<br>
>> -> GPX<br>
>> -> KML<br>
>> -> GeoJSON<br>
>> -> Interlis 1<br>
>> -> Interlis 2<br>
>> -> GMT<br>
>> -> SQLite<br>
>> -> ODBC<br>
>> -> PGeo<br>
>> -> OGDI<br>
>> -> PostgreSQL<br>
>> -> MySQL<br>
>> -> XPlane<br>
>> -> AVCBin<br>
>> -> AVCE00<br>
>> -> DXF<br>
>> -> Geoconcept<br>
>> -> GeoRSS<br>
>> -> GPSTrackMaker<br>
>> -> VFK<br>
>><br>
>> On 2/11/10, Chaitanya kumar CH <<a href="http://chaitanya.ch" target="_blank">chaitanya.ch</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>> wrote:<br>
>> > Noli,<br>
>> ><br>
>> > There must have been some error message. What did you get?<br>
>><br>
><br>
><br>
><br>
> --<br>
> Best regards,<br>
> Chaitanya kumar CH.<br>
> /tʃaɪθənjə/ /kʊmɑr/<br>
> +91-9848167848<br>
> 17.241582N 80.142635E<br>
><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br>/tʃaɪθənjə/ /kʊmɑr/ <br>+91-9848167848<br>17.241582N 80.142635E<br>