[postgis-users] Re: Speeding up SQLiteGIS

[mchapman at texelinc.com]

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
> 
>