[postgis-users] Re: Speeding up SQLiteGIS

[Stephen Woodbridge]

Mark,

That would be great. I just finished reading through all the Spatialite 
documentation and they have much of what is needed. It looks like the 
major missing pieces are the spatial index and adding the geos 
functionality. You are right that the spatial index will be the tricky 
piece and this is the one that I'm worried about because with it, 
Spatialite will only be useful for small data sets.

-Steve

mchapman at texelinc.com wrote:
> Stephen,
> 
> I am going to take a crack at putting together a requirements doc for
> SQLiteGIS.  It will be basic, but will identify what is needed to add
> geometry st_etc functions and other required custom procs sqlite
> would need in order to do some of what postgis does.  The tricky part
> will be integrating with the sqlite indexes.
> 
> Martin
> 
> Sent via BlackBerry by AT&T
> 
> -----Original Message----- From: Stephen Woodbridge
> <woodbri at swoodbridge.com>
> 
> Date: Sun, 13 Apr 2008 23:31:42 To:Martin Chapman
> <mchapman at texelinc.com> Cc:'Richard Greenwood'
> <richard.greenwood at gmail.com>, punkish at eidesis.org, 'PostGIS Users
> Discussion' <postgis-users at postgis.refractions.net> Subject: Re:
> Speeding up SQLiteGIS
> 
> 
> Martin Chapman wrote:
>> That is also what GDAL uses (proj4).  I will take a look at
>> SpatiaLite. Does he support a lot of other vector formats?
> 
> I don't think he needs to support a lot of vector formats, becuase
> that is what ogr does. PostGIS does not support lots of vector
> formats. But ogr2ogr lets you load lots of vector formats into either
> of these.
> 
> Best regards, -Stephen
> 
>> Best regards, Martin
>> 
>> 
>> -----Original Message----- From: Richard Greenwood
>> [mailto:richard.greenwood at gmail.com] Sent: Sunday, April 13, 2008
>> 9:06 PM To: Martin Chapman Cc: Stephen Woodbridge;
>> punkish at eidesis.org; PostGIS Users Discussion Subject: Re: Speeding
>> up SQLiteGIS
>> 
>> On Sun, Apr 13, 2008 at 8:53 PM, Martin Chapman
>> <mchapman at texelinc.com> wrote:
>> 
>>> 5.  I think a good improvement to the SQLite OGR driver would be
>>> to add spatial reference support.
>> The SpatiaLite guy seems to support SRSs. He has a transform() 
>> function which apparently is based on Proj.4 see: 
>> http://www.gaia-gis.it/spatialite/SpatiaLite-tutorial.html#t5
>> 
>> 
>