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

[Chaitanya kumar CH]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100211/1d769ab0/attachment.html