Hi,
I downloaded FWTools 2.4.7 (Jan 19, 2010) for windows and installed.
I suppose there is support for converting CSV table to SQLite Table in
this version. Now, how do i convert my CSV table to SQLite
ogr2org - f SQLite HarvestArea1.csv Harvest.sqlite -dsco SPATIALITE=YES
It seems that this
Noli,
There must have been some error message. What did you get?
On Thu, Feb 11, 2010 at 5:11 PM, Noli Sicad wrote:
> Hi,
>
> I downloaded FWTools 2.4.7 (Jan 19, 2010) for windows and installed.
> I suppose there is support for converting CSV table to SQLite Table in
> this version. Now, how d
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
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 wrote:
> OK. Sorry
> This is the error,
>
> FAILURE:
> Unable to open datasource `harvest.sqlite' with the following drivers.
> -> ESRI Shapefile
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 fi
Noli,
Your destination file has to be before the source file.
On Thu, Feb 11, 2010 at 6:19 PM, Noli Sicad 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
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 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 w
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 wrote:
> I'm not sure if the version of