P Kishor wrote:
On 4/13/08, Richard Greenwood <[EMAIL PROTECTED]> wrote:
I should note that ogr2ogr creates a SQLite spatial table even more
 easily that SpatiaLite:
   ogr2ogr -f "SQLite" dest.db source.shp source

Thanks Rich. You made my day. I am drawing a layer with about 185K
rows, and, yes, there is a time lag, but this is out-of-the-box
performance.

One question -- the above ogr2ogr command, for me, does not seem to
cooperate when adding multiple shapefiles to the same db. If I do like
so

ogr2ogr -f "SQLite" dest.db source1.shp source2.shp source3.shp

Puneet,

That was a hopeful guess at ogr2ogr syntax, but it is one db to one db
at a time.

You could use:

ogr2ogr -f sqlite dest.db source1.shp
ogr2ogr -update dest.db source2.shp
ogr2ogr -update dtest.db source3.shp

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to