Richard Greenwood wrote:
So in a MapServer itemquery, is GetFeature() or GetNextFeature() being
used? I'm guessing the latter. I'm trying to picture, from a MapServer
perspective, where the senarios you describe would be invoked. Like
when would you do a GetFeature() by FID?
Rich,
Hopefully we
PROTECTED]
Subject: Re: [postgis-users] SQLite and postGIS
On Sun, Apr 13, 2008 at 8:29 PM, Frank Warmerdam <[EMAIL PROTECTED]>
wrote:
> Martin Chapman wrote:
>
> > Rich,
> >
> > One thing you should note about OGR performance when accessing certain
> > databases
On Sun, Apr 13, 2008 at 8:29 PM, Frank Warmerdam <[EMAIL PROTECTED]> wrote:
> Martin Chapman wrote:
>
> > Rich,
> >
> > One thing you should note about OGR performance when accessing certain
> > databases like MySQL, PostgreSQL and SQLite is that OGR uses a strategy
> for
> > these drivers that get
Martin Chapman wrote:
Rich,
One thing you should note about OGR performance when accessing certain
databases like MySQL, PostgreSQL and SQLite is that OGR uses a strategy for
these drivers that gets progressively worse for large datasets. Query
execution is always pretty quick in any database,
Cc: [EMAIL PROTECTED]
Subject: Re: [postgis-users] SQLite and postGIS
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 tex
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, y
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
I should note that ogr2ogr creates a SQLite spatial table even more
easily that SpatiaLite:
ogr2ogr -f "SQLite" dest.db source.shp source
Rich
On Sun, Apr 13, 2008 at 9:26 AM, Richard Greenwood
<[EMAIL PROTECTED]> wrote:
> On Fri, Apr 11, 2008 at 9:29 PM, Frank Warmerdam <[EMAIL PROTECTED]>
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 W
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 t
P Kishor wrote:
On 4/11/08, Richard Greenwood <[EMAIL PROTECTED]> wrote:
Are any of you driving a MapServer layer with Sqlite, and if so, would
you provide an example layer definition? I could sure see a lot of
utility in a spatial database that was somewhere between shapefiles
and PostGIS.
On 4/11/08, Richard Greenwood <[EMAIL PROTECTED]> wrote:
> Are any of you driving a MapServer layer with Sqlite, and if so, would
> you provide an example layer definition? I could sure see a lot of
> utility in a spatial database that was somewhere between shapefiles
> and PostGIS.
as far as I
Are any of you driving a MapServer layer with Sqlite, and if so, would
you provide an example layer definition? I could sure see a lot of
utility in a spatial database that was somewhere between shapefiles
and PostGIS.
Thanks,
Rich
--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com
On 4/11/08, shoaib <[EMAIL PROTECTED]> wrote:
> > I do have one question for you all -- why on earth does Spatialite
> > (and also PostGIS as well as ArcGIS) store the geometry as a BLOB?
> > What are the advantages? Is it space? Is it speed? Both? I can't
> > really understand the reason fo
Ron M wrote:
Stephen Woodbridge wrote:
Databases basically do not work over NFS mounted filesystems because
of locking and caching issues.
Surely that's an exaggeration.
OK, it is a slight exaggeration, but unless you really know what you are
doing you just should stay away from it. I think
Stephen Woodbridge wrote:
Databases basically do not work over NFS mounted filesystems because of
locking and caching issues.
Surely that's an exaggeration.
http://blogs.netapp.com/dave/2007/08/oracle-optimize.html
"Oracle uses NFS to run its applications on tens of thousands
of Linux servers
(the reply may look screwy because I am temporarily saddled with a
hobbled gmail interface on IE something or the other, and it seems to
have a mind of its own)
I unpacked the shapefiles via a module on CPAN and stored the
coordinates as text strings (well, everything is a string for SQLite)
ready
P Kishor wrote:
I actually wrote a pretty useful point-in-polygon routine using Perl
DBD::SQLite unwrapping Shapefiles into a SQLite db and then using
SQLite for boundary matching. It was for a very large p-in-p (7.5
million points against 250k polys) that ArcGIS was choking over. Works
very s
http://imaptools.com/
Best regards, Martin
Sent via BlackBerry by AT&T
-Original Message- From: Stephen Woodbridge
<[EMAIL PROTECTED]>
Date: Mon, 07 Apr 2008 22:02:45 To:[EMAIL PROTECTED], PostGIS Users
Discussion Subject: Re:
[postgis-users] SQLite and postGIS
P Kishor wrote:
rk on this effort because I have
been thinking about doing it myself.
Best regards,
Martin
Sent via BlackBerry by AT&T
-Original Message-
From: Stephen Woodbridge <[EMAIL PROTECTED]>
Date: Mon, 07 Apr 2008 22:02:45
To:[EMAIL PROTECTED], PostGIS Users Discussion
Subject: Re: [p
On 4/7/08, Stephen Woodbridge <[EMAIL PROTECTED]> wrote:
> P Kishor wrote:
>
> > On 4/7/08, Stephen Woodbridge <[EMAIL PROTECTED]> wrote:
> >
> > > Hi Paul,
> > >
> > > I have started using SQLite for some projects, mostly just as a backing
> > > store for manipulating some data. I can't help but
P Kishor wrote:
On 4/7/08, Stephen Woodbridge <[EMAIL PROTECTED]> wrote:
Hi Paul,
I have started using SQLite for some projects, mostly just as a backing
store for manipulating some data. I can't help but think it would be cool if
it would be possible to get something like postGIS running in i
On 4/7/08, Stephen Woodbridge <[EMAIL PROTECTED]> wrote:
> Hi Paul,
>
> I have started using SQLite for some projects, mostly just as a backing
> store for manipulating some data. I can't help but think it would be cool if
> it would be possible to get something like postGIS running in it.
>
> I
William,
Thanks for the pointer. I will check it out.
Doesn't look like they have spatial indexes, but it does look like an
interesting start.
-Steve
William Kyngesburye wrote:
Someone started something already. Basic for now - good for exchanging
geodata.
http://www.gaia-gis.it/spatialit
You are not alone... I have been using SQLite for my web mapping
applications precisely because its so quick to get it running.
I have not had the need to do any advance spatial functions but I can
imagine it would be nice to have.
Has anyone done a preliminary check of how hard it would be to ad
Someone started something already. Basic for now - good for
exchanging geodata.
http://www.gaia-gis.it/spatialite/
On Apr 7, 2008, at 5:34 PM, Stephen Woodbridge wrote:
Hi Paul,
I have started using SQLite for some projects, mostly just as a
backing store for manipulating some data. I ca
Hi Paul,
I have started using SQLite for some projects, mostly just as a backing
store for manipulating some data. I can't help but think it would be
cool if it would be possible to get something like postGIS running in it.
I know you guys did some analysis of various databases a while back w
27 matches
Mail list logo
