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
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
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
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
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:
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:
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
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
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
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
10 matches
Mail list logo