[postgis-users] SQLite and postGIS

[Frank Warmerdam]

P Kishor wrote:
> On 4/13/08, Richard Greenwood <richard.greenwood at gmail.com> 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, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org