: Re: [postgis-users] advice for quicker display?
Actually it does NOT exist in the sub-query. Mapserver modifies the
query because it needs the label text. So you sub-query needs to have
ALL potential columns that you might need explicitly referenced.
DATA "the_geom from (select gid, map_b
: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen
Woodbridge
Sent: Wednesday, February 15, 2012 3:06 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] advice for quicker display?
Actually it does NOT exist
om out again.
-Original Message- From:
postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
Sandro Santilli Sent: Wednesday, February 15, 2012 2:50 PM To:
PostGIS Users Discussion Subject: Re: [postgis-users] advice for
quicker display
oun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Sandro
Santilli
Sent: Wednesday, February 15, 2012 2:50 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] advice for quicker display?
On Wed, Feb 15, 2012 at 02:26:19PM -0500, Bistrais, Bob
strk;
>
>
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net
> [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen
> Woodbridge
> Sent: Wednesday, February 15, 2012 12:26 PM
> To: postgis-users@postgis.refractions.
-although the column gid does exist.
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen
Woodbridge
Sent: Wednesday, February 15, 2012 12:26 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgi
tgis.refractions.net] *On Behalf Of
*Juan Marín Otero
*Sent:* Tuesday, February 14, 2012 3:13 PM
*To:* PostGIS Users Discussion
*Subject:* Re: [postgis-users] advice for quicker display?
You can find the documentation here. Also look at
ST_SimplifyPreserveTopology, might be better depending on how str
m
Sent: Tuesday, February 14, 2012 2:44 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] advice for quicker display?
Also,
In Postgis you can use the ST_Simplfy() function in mapserver zoom (scale
dependent) layers. So you have one dataset, and as you zoom out you display
features
Sent: Tuesday, February 14, 2012 2:26 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] advice for quicker display?
To expand on that, the basic understanding is that file level access to
data
(e.g. shapefile) will always be faster for the entire dataset (all
things
b
; *Sent:* Tuesday, February 14, 2012 2:44 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] advice for quicker display?
>
> ** **
>
> Also,
>
> In Postgis you can use the ST_Simplfy() function in mapserver zoom (scale
> dependent) layers. So you hav
, February 14, 2012 2:44 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] advice for quicker display?
Also,
In Postgis you can use the ST_Simplfy() function in mapserver zoom
(scale dependent) layers. So you have one dataset, and as you zoom out
you display features represented by
That is the name you are giving the index. It is good practice for the
name to include the table & column(s) the index applies to in the
name you give it.
--- On Wed, 2/15/12, Bistrais, Bob wrote:
From: Bistrais, Bob
Subject: Re: [postgis-users] advice for quicker display?
T
r than a file streaming from disk. Note that on good
hardware with an well optimised database even this difference can be minimised.
Cheers,
Brent Wood
--- On Wed, 2/15/12, Stephen Woodbridge wrote:
From: Stephen Woodbridge
Subject: Re: [postgis-users] advice for quicker display?
To:
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
Stephen V. Mather
Sent: Tuesday, February 14, 2012 2:26 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] advice for quicker display?
To expand on that, the basic understanding is that file level access to
stgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen
Woodbridge
Sent: Tuesday, February 14, 2012 2:15 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] advice for quicker display?
On 2/14/2012 1:57 PM, Bistrais, Bob wrote:
> As some of you already know, I'
On 2/14/2012 1:57 PM, Bistrais, Bob wrote:
As some of you already know, I’m a newbie to PostGIS and have just
barely got a test PostGIS database up and running. So, my latest
question is in regards to draw times. I created a statewide parcel layer
from a shapefile. At statewide scale, when the ap
On Feb 14, 2012, at 12:57 PM, Bistrais, Bob wrote:
> As some of you already know, I'm a newbie to PostGIS and have just
> barely got a test PostGIS database up and running. So, my latest
> question is in regards to draw times. I created a statewide parcel
> layer from a shapefile. At statewide
As some of you already know, I'm a newbie to PostGIS and have just
barely got a test PostGIS database up and running. So, my latest
question is in regards to draw times. I created a statewide parcel
layer from a shapefile. At statewide scale, when the application loads,
the parcel data draws far
18 matches
Mail list logo