[gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

[Noli Sicad]

Yes, this is what I am trying to ask.

from file:///C:/Program%20Files/FWTools2.4.7/html/drv_sqlite.html

 # Duplicate the sample database provided with SpatiaLite (does not
need explicit linking with SpatiaLite)
ogr2ogr -f SQLite testspatialite.sqlite test-2.3.sqlite  -dsco SPATIALITE=YES

from file:///C:/Program%20Files/FWTools2.4.7/html/drv_csv.html

ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_XYZ

Now, any suggestion how I reorganise the arguments?

Meanwhile, I am using spatial_tools from spatialite some success using
import of dbf  tables into spatialite tables but the problem is the
primary key.  CVS and DBF tables does not contain any information of
primary key. Hence, no go for sqlite conversion. Convert tables in
sqlite is still useless for SQL querying.

Noli


On 2/11/10, Chaitanya kumar CH <chaitanya.ch at gmail.com> wrote:
> Noli,
>
> There was a problem with the order of the arguments in your command.
> http://gdal.org/ogr2ogr.html
>
> On Thu, Feb 11, 2010 at 5:37 PM, Noli Sicad <nsicad at gmail.com> wrote:
>
>> OK. Sorry
>> This is the error,
>>
>> FAILURE:
>> Unable to open datasource `harvest.sqlite' with the following drivers.
>>  -> ESRI Shapefile
>>  -> MapInfo File
>>  -> UK .NTF
>>  -> SDTS
>>  -> TIGER
>>  -> S57
>>  -> DGN
>>  -> VRT
>>  -> REC
>>  -> Memory
>>  -> BNA
>>  -> CSV
>>  -> NAS
>>  -> GML
>>  -> GPX
>>  -> KML
>>  -> GeoJSON
>>  -> Interlis 1
>>  -> Interlis 2
>>  -> GMT
>>  -> SQLite
>>  -> ODBC
>>  -> PGeo
>>  -> OGDI
>>  -> PostgreSQL
>>  -> MySQL
>>  -> XPlane
>>  -> AVCBin
>>  -> AVCE00
>>  -> DXF
>>  -> Geoconcept
>>  -> GeoRSS
>>  -> GPSTrackMaker
>>  -> VFK
>>
>> On 2/11/10, Chaitanya kumar CH <chaitanya.ch at gmail.com> wrote:
>> > Noli,
>> >
>> > There must have been some error message. What did you get?
>>
>
>
>
> --
> Best regards,
> Chaitanya kumar CH.
> /tʃaɪθənjə/ /kʊmɑr/
> +91-9848167848
> 17.241582N 80.142635E
>