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

Noli Sicad nsicad at gmail.com
Thu Feb 11 14:38:46 EST 2010


Even,
Thanks for pointing this out.

Kumar noticed that the "- f" there was space in between. The correct
syntax is "-f"

This one (below) is working.

ogr2ogr - f SQLite Harvest.sqlite HarvestArea1.csv  -dsco SPATIALITE=YES

Noli


On 2/12/10, Even Rouault <even.rouault at mines-paris.org> wrote:
> I'm not sure if the version of sqlite3.dll included in latest FWTools is
> recent enough to support reading and/or creation of spatialite databases.
>
> See http://bugzilla.maptools.org/show_bug.cgi?id=2099
>
> Le Thursday 11 February 2010 13:15:23 Chaitanya kumar CH, vous avez écrit :
>> 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?
>
>
>


More information about the gdal-dev mailing list