[mapserver-users] long-running postgres queries initiated by mapserver

Hi All- I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm using postgres as the data storage container, and mapserver is primarily serving WFS requests. Sometimes, people do WFS queries that take a very long time (searching for virginia on a nation-wide layer) and eventually

[mapserver-users] Re: Clipping returned WFS data to the requesting bounding box

Any takers? I was just thinking, is there a native way using filters to clip the returned data inside mapserver? I couldn't find any, but perhaps I was not looking in the right place. -- View this message in context:

[mapserver-users] Re: Clipping returned WFS data to the requesting bounding box

I've actually now just discovered a way that works for me. I did forget to mention that we are using PostGIS. We now use the aforementioned: DATA wkb_geometry FROM (SELECT ST_Intersection(f.wkb_geometry, !BOX!) AS wkb_geometry, column1, column2, column3 FROM flood as f) AS subquery USING

[mapserver-users] Re: Mr Sid vs ECW

I've never tested them side-by-side but my coworkers claim ECW is faster than MrSid. Sorry I don't have any numbers for you. I've been using ECW though and it's pretty great, performance-wise for big images. -Matt Mendick -- View this message in context:

[mapserver-users] Re: Limiting the execution time of mapserver

Thanks for the reply - where would you put this limit statement? I've tried putting it in the DATA section, like so: DATA wkb_geometry from (select * from parcels LIMIT 100) as subquery using unique ogc_fid using srid=4326 or DATA wkb_geometry from (select * from parcels) as subquery using

[mapserver-users] Re: WFS featureislike and bbox filter required?

Thanks for the response, it certainly was possible but I checked, and they are filled in. They are currently set to a global extent (my ingestion is fairly automated and I didn't want to calculate the extent programatically because that takes a long time). However, when I change to the correct

[mapserver-users] WFS featureislike and bbox filter required?

Hi All- I'm trying to query mapserver's wfs service (layer's data is backed by postgis) using the following post: (excuse the parentheses instead of 's, they are from some debug code) (wfs:GetFeature service=WFS version=1.1.0 resultType='results' xmlns:wfs=http://www.opengis.net/wfs;

[mapserver-users] Re: quick question from mapserver beginner!

You first have to make sure you are outputting the image as a png or some other image format that supports transparency. Like this, at the base of the mapfile: OUTPUTFORMAT NAME mypng DRIVER GD/PNG IMAGEMODE RGB

[mapserver-users] Re: Combination of MapServer and Desktop GIS

You could also use something more specific to caching wms tiles like tilecache. (http://tilecache.org/) It works pretty well for me, it considerably speeds up the serving of our tiles. -Matt Mendick -- View this message in context:

[mapserver-users] postgres fulltext search

We have set up a WFS service connected with postgres loaded up with some substantial datasets of ~120 million rows. We have run into users wanting to utilize the filter PropertyIsLike. The search string and a wildcard character are specified, and mapserver does a search against postgres,

[mapserver-users] Re: postgres fulltext search

Correct, that is what I'm asking ultimately. What is the attributal equivalent to !BBOX! if it exists? -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009128.html Sent from the Mapserver - User mailing list archive at Nabble.com.

[mapserver-users] Re: postgres fulltext search

Andy- Thanks a ton for taking a look at this for me. In looking around some more talking about variable substitution, I found that I can do a FILTER like you mentioned in the layer section of the mapfile. I could do a: FILTER city @@ ts_vector('%mycitysearch%') and then in the mapserver