[mapserver-users] Mapserver and Microsoft SQL Server 2008
Hi I'm looking for a way to switch our current postgre setup to SQL Server 2008. I can get the map data into SQL I just need a way to tell mapserver (in the mapfile) to look at the SQL 2008 database. I found a post relating to a plugin in order to do this: PLUGIN C:\ms4w\plugins\msplugin_mssql2008.dll http://mapserver.gis.umn.edu/development/rfc/ms-rfc-38 But i cannot find the dll anywhere, does it exist, if not when will it be released? Any additional help would be appreciated. Thanks Chris --- South Africas premier free email service - www.webmail.co.za -- For super low premiums, click here http://www.webmail.co.za/dd.pwm ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: AW: [MAPSERVER-USERS] Hiding overviews
Daniel Morissette wrote:
I had a quick look at this thread and it seems to me at first that using
GROUP in all layers corresponding to the same set of overviews should
allow you to turn all of them on/off at once.
I built a small test case and it seems that the root problem is that the
function msOWSMakeAllLayersUnique() produces an exception if any layer
is missing a NAME. In order to allow what you want and make the layer
name really optional we would need to get rid of that exception.
If we modify msOWSMakeAllLayersUnique() to 'continue' the loop instead
of returning an exception when it encounters a NULL layer name as follows...
--- mapows.c(revision 7477)
+++ mapows.c(working copy)
@@ -141,10 +169,7 @@
{
if (GET_LAYER(map, i)-name == NULL || GET_LAYER(map,
j)-name == NULL)
{
- msSetError(MS_MISCERR,
- At least one layer is missing a name in map
file.,
- msOWSMakeAllLayersUnique());
- return MS_FAILURE;
+ continue;
}
if (strcasecmp(GET_LAYER(map, i)-name, GET_LAYER(map,
j)-name) == 0
msRenameLayer((GET_LAYER(map, j)), ++count) != MS_SUCCESS)
... then the following mapfile block...
LAYER
NAME layer1
METADATA
wms_title Layer 1
wms_group_title Group 1
END
GROUP group1
MINSCALE 0
MAXSCALE 1
TYPE RASTER
STATUS ON
DATA layer1.tif
END
LAYER
# NAME intentionally omitted...
METADATA
wms_title Layer 2
END
GROUP group1
MINSCALE 10001
MAXSCALE 10
TYPE RASTER
STATUS ON
DATA layer2.tif
END
... produces the following output in GetCapabilities ... this whole
group can be turned on/off at once using LAYERS=group1 in the GetMap
request. Notice that layer 2 has no name in GetCapabilities which is
what we wanted. Omitting the layer name for layer 1 as well would make
it non-selectable as well:
Layer
Namegroup1/Name
TitleGroup 1/Title
Abstractgroup1/Abstract
Layer queryable=0
Namelayer1/Name
TitleLayer 1/Title
ScaleHint min=0 max=4.98902848429637 /
/Layer
Layer queryable=0
!-- WARNING: Mandatory mapfile parameter 'LAYER.NAME' was missing in
this context. --
TitleLayer 2/Title
ScaleHint min=4.9895273871448 max=49.8902848429637 /
/Layer
/Layer
We would also need to update the WARNING text to say optional instead
of Mandatory.
If this is indeed what you were trying to achieve then please file a
ticket and I'll make the required changes in MapServer 5.2.
Daniel
--
Daniel Morissette
http://www.mapgears.com/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Version 4.6.2 binaries
Hi How can i get the binary files of the Mapserver 4.6.2 version? I can`t find them in the site. Thanks in advance. Juan Luis Cardoso ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Hiding overviews
Daniel Morissette wrote: Well, in the meantime I patched the MapServer code a little bit and made it being an Apache module, reading and parsing the map file only once on startup. Are you serious, mod_mapserver? Holy cow, that would be awesome! I would be VERY interested to hear about stability with prefork MPM, whether it seems production grade, etc. I'd be glad to try it out as a patch to some of our systems (production but willing) and provide feedback. -- Gregor Mosheh / Greg Allensworth, BS, A+ System Administrator HostGIS cartographic development hosting services http://www.HostGIS.com/ Remember that no one cares if you can back up, only if you can restore. - AMANDA ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver and Microsoft SQL Server 2008
Well, my team is taking part in the Microsoft Imagine Cup competition this year, we won our local leg using postgre, but now for the international stage you can understand how having a Microsoft product over an Opensource product will help us... [EMAIL PROTECTED] wrote: I'm looking for a way to switch our current postgre setup to SQL Server 2008. I can get the map data into SQL I just need a way to tell mapserver (in the mapfile) to look at the SQL 2008 database. Just out of curiosity, are you at liberty to divulge any of the details that led you to switch from PostgreSQL to MS SQL? Colin --- South Africas premier free email service - www.webmail.co.za -- For super low premiums, click here http://www.webmail.co.za/dd.pwm ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver and Microsoft SQL Server 2008
[EMAIL PROTECTED] wrote: I'm looking for a way to switch our current postgre setup to SQL Server 2008. I can get the map data into SQL I just need a way to tell mapserver (in the mapfile) to look at the SQL 2008 database. Just out of curiosity, are you at liberty to divulge any of the details that led you to switch from PostgreSQL to MS SQL? Colin ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver and Microsoft SQL Server 2008
[EMAIL PROTECTED] wrote: Well, my team is taking part in the Microsoft Imagine Cup competition this year, we won our local leg using postgre, but now for the international stage you can understand how having a Microsoft product over an Opensource product will help us... Fair enough. I had never heard of the Imagine Cup, but it looks like a interesting competition. Good luck! And, keep PostgreSQL in mind for future projects! :) Colin ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Different data in the same layer
Hi, Check the GROUP parameter in the MapFile Documentation. With this you can merge many layers in one grouped Layer. Regards René Viancos 2008/3/25, Paul Austin [EMAIL PROTECTED]: What I would like to achieve is a WMS server where when the user selects a layer (e.g. Water) that they see Line and Polygon water features rendered where the lines are in the database table water_lines and the polygons are in the table water_polys. All the line features are rendered first with the polygon features rendered on top of those. Is it possible with mapserver to define a layer which gets data from multiple sources? Sort of like nested layers but where the user doesn't see the nested layers. An extension of this would to be also have different tables with data at different scales so the 1:20k data would be in water_20k_lines and the 1:250k would be in water_250k_lines. Throughout all of this the user just sees the Water layer. Cheers, Paul ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- René Felipe Viancos. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Different data in the same layer
Wow, that's very subtle easy to miss! Is there then a way to not have the layers below water show up in the capabilities document? Paul René F. Viancos S. wrote: Hi, Check the GROUP parameter in the MapFile Documentation. With this you can merge many layers in one grouped Layer. Regards René Viancos 2008/3/25, Paul Austin [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: What I would like to achieve is a WMS server where when the user selects a layer (e.g. Water) that they see Line and Polygon water features rendered where the lines are in the database table water_lines and the polygons are in the table water_polys. All the line features are rendered first with the polygon features rendered on top of those. Is it possible with mapserver to define a layer which gets data from multiple sources? Sort of like nested layers but where the user doesn't see the nested layers. An extension of this would to be also have different tables with data at different scales so the 1:20k data would be in water_20k_lines and the 1:250k would be in water_250k_lines. Throughout all of this the user just sees the Water layer. Cheers, Paul ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- René Felipe Viancos. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Problem creating WMS
Hello all: I'm trying to create a WMS, but i need to use it with a client named gvSIG. This program cannot read feature info in type text/html, only gml METADATA wms_title Layer wms_srs EPSG:23030 wms_abstract Layer wms_feature_info_mime_type gml #wms_feature_info_mime_type text/html END That i wanna do is to show a web page or url for feature info. Any ideas? Bernardo Martín García Director Técnico iNCARGiS, C.I.G., S.L. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
