[gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite
Chaitanya kumar CH
chaitanya.ch at gmail.com
Thu Feb 11 07:56:30 EST 2010
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
> 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.
> 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
Chaitanya kumar CH.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the gdal-dev