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

[Noli Sicad]

Kumar,

OK. I did this command as you suggested.

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

But still no Harvest.sqlite is created.

Please tell what is the right order of the arguments. Suggest any
command combination.

Noli

On 2/11/10, Chaitanya kumar CH <chaitanya.ch at gmail.com> wrote:
> Noli,
>
> Your destination file has to be before the source file.
>
> On Thu, Feb 11, 2010 at 6:19 PM, Noli Sicad <nsicad at gmail.com> wrote:
>
>> 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
>> >
>>
>
>
>
> --
> Best regards,
> Chaitanya kumar CH.
> /tʃaɪθənjə/ /kʊmɑr/
> +91-9848167848
> 17.241582N 80.142635E
>