On 4/13/08, Richard Greenwood <[EMAIL PROTECTED]> wrote: > On Fri, Apr 11, 2008 at 9:29 PM, Frank Warmerdam <[EMAIL PROTECTED]> wrote: > > Puneet, Rich, > > > > SQLite is already supported as a spatial database by OGR. The caveat > > is that in GDAL 1.5 it is just using a text column with WKT geometries so > > the spatial performance is not great. > > > > To use this with MapServer you would use CONNECTIONTYPE OGR and the > > CONNECTION string would be the path for the sqlite database. The > > DATA statement should hold the table name be accessed. > > > Totally cool! > > I used SpatiaLite (http://www.gaia-gis.it/spatialite/) LoadShapefile() > function to import a shapefile into a SQLite db. The geometries are > stored as BLOBs in a field named "geom" Then: > sqlite> alter table ownership add column WKT_GEOMETRY; > sqlite> update ownership set WKT_GEOMETRY=astext(geom); > > Getting MapServer to use the SQLite table was very easy. Recent > versions of MS4W have SQLite support in GDAL. So simply adding > CONNECTIONTYPE OGR > CONNECTION "path/to/SQLite.db" > gets MapServer drawing geometries from SQLite. > > I'm playing with a table containing about 15,000 polygons and > performance is fine. > > Thanks Frank, for pointing me in the right direction. > > Rich >
Two days ago I wrote -- > I am pretty confident > that we shall see this ability sooner rather than later (a hunch, > nonetheless, a confident hunch). that was indeed sooner than even I expected. Development with SQLite is just so easy that all other advantages that other more complicated solutions may have just become less important. Good going Rich. Puneet. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users