[mapserver-users] Search in MapServer.org does not work

The search window opens, but no search result is shown. In the debug console I get: GET http://mapserver.org/_sources/MIGRATION_GUIDE.txt 404 (Not Found) Tx Martin -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Search-in-MapServer-org-does-not-work-tp5231150.html

Re: [mapserver-users] Documentation index missing on mapserver.org (Was: Re: Search in MapServer.org does not work)

Hi Jeff, while looking into this pls check on how the search is working. e.g. seaching for "Layer" you get to a lot of stuff but NOT the "Layer" chapter. Some results are about "OpenLayers" ("layer" being part of the word...) but if you search for "Openlayers" you don't even get the main

[mapserver-users] MS SQL server - OGR 5 times slower compared to Mapserver plugin?

We noticed that typical WMS response times using the OGR layer type for MS SQL server are 5 times slower compared to the MapServer MS SQL plugin. Maybe the OGR driver does not properly use the spatial index and always let's MapServer filter the relevant geometries? Do other users have a similar

Re: [mapserver-users] MS SQL server - OGR 5 times slower compared to Mapserver plugin?

Hi Seth, here the relevant (anonymized) sections in the mapfile: CONNECTION "MSSQL:Server=myserver;uid=user;pwd=password;Database=mydatabase;Integrated Security=false" CONNECTIONTYPE OGR DATA "SELECT * FROM ASSETS.Parcels" As a consequence of the slow OGR performance we didn't do lot

[mapserver-users] Oracle Layer: how to set context prior to fetching the data

One of the Oracle based sources we are publishing is using Oracle context variables to enable Oracle's fine grained access control. So we are in the need to set these context variables (e.g. current username) prior to doing the select defined by MapServer's DATA statement. In other applications we

Re: [mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

Hi Steve, Is this resolved in MapServer 7.0 for Oracle, too? Or just for PostGIS? Tx Martin -- View this message in context: http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988p5255260.html Sent from the Mapserver - User

Re: [mapserver-users] Oracle SYSDATE in EXPRESSION

Or you could create a calculated column in the data statement, call it e.g. "AGE" being the result of the difference of your original date column and the oracle sysdate. Then you can easily use that "AGE" column to do your styling. HTH Martin -- View this message in context:

Re: [mapserver-users] Oracle SYSDATE in EXPRESSION

I tried this DATA statement successfully with Oracle: DATA "GEOLOC FROM (SELECT GEOLOC,OBJECTID,START_DATE, (SYSDATE-START_DATE)/365 as age FROM SPATIAL_TABLE) USING UNIQUE OBJECTID SRID 27700" [AGE] can then be used in any styling. Martin -- View this message in context:

[mapserver-users] OS Mastermap - styling

I'm trying to use mapserver to publish OS Mastermap data. Biggest challenge to me is the extensive styling. Does anybody here have experience with properly styled OSMM data in mapserver? I see that OS offers SLD styling definitions for download but I don't have any experience with mapserver and

Re: [mapserver-users] Oracle Layer: how to set context prior to fetching the data

Hi Mike, I've tried this and in principle this works but sometimes it seems to me that the context setting in the function happens AFTER the query has been executed so that only a second call to the query gives the correnct number of rows. Any idea on how to enforce that the context setting will