Re: [mapserver-users] postgis layer draws much slower than psql select statement

2013-12-03 Thread thomas bonfort
Paul, if you add a DEBUG 2 to your LAYER definition, you'll also get some debugging info as to what is happening inside mapserver's postgis driver, along with the query that is actually sent by mapserver to postgis (as mapserver adds some spatial filtering to account for the current map view).

Re: [mapserver-users] postgis layer draws much slower than psql select statement

2013-12-03 Thread Moen, Paul T.
Perfect answer Thomas! After adding DEBUG 2 in my layer, I see that the actual select statement is select label,encode(ST_AsBinary(ST_Force_2D(the_geom),'NDR'),'hex') as geom,site_id from (select (count(*)/((date '8-31-2013'- date '4-1-2013')+1)::numeric=0.98) as list,

[mapserver-users] shapefile polygon, overlapping dashed outline displays incorrectly

2013-12-03 Thread Heidi Ochis
I have a shapefile which is a polygon drawn as a line with a dash-dot- dash pattern. Because the polygon edges overlap each other (it is a county file) the lines don't show up correctly due to the misalignment of the dash pattern. This question was posted in 2009, but I do not see any