Re: [mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases

[karsten]

 Dear Seth,

Thanks so much for sharing your experiences. Also that it works well is
great. 
The naming of the driver thus does not reflect that it does suports more
than only version 2008 ;)
Hope this answer will help out others as well.

Cheers
Karsten

-Original Message-
From: Seth G [mailto:se...@geographika.co.uk] 
Sent: Tuesday, February 07, 2017 12:18
To: kars...@terragis.net; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Will Mapserver work with newer Microsoft SQL
Server Spatial Databases

Hi Karsten,

We were running a production system with MS SQL 2012 for 4 years without any
problems. We briefly moved to SQL 2014, and are now on SQL 2016 again
without issues.

Tamas Szekeres does a great job of maintaining and improving the MS SQL
driver - https://github.com/mapserver/mapserver/blob/master/mapmssql2008.c

The OGR driver also works, but I found it to be much less flexible in terms
of complex SQL and adding filters.

Regards,

Seth


On 07/02/2017 21:12, karsten wrote:
>   
> Dear All,
>
> I am trying to find out if MapServer (and/or OGR) will work with 
> spatial databases newer than Microsoft SQL Server 2008. I know that 
> the drivers work with that older version but did not want to promise 
> to a client that it would. At this point I am not able to test it 
> directly because I do not have access to a Microsoft SQL Server 2012 or
newer to verify.
> Does anyone have experience and succeed with this or anyone who can 
> share their experiences ?
>
> Cheers
> Karsten
>
> www.terragis.net
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases

[Seth G]

Hi Karsten,

We were running a production system with MS SQL 2012 for 4 years without 
any problems. We briefly moved to SQL 2014, and are now on SQL 2016 
again without issues.


Tamas Szekeres does a great job of maintaining and improving the MS SQL 
driver - https://github.com/mapserver/mapserver/blob/master/mapmssql2008.c


The OGR driver also works, but I found it to be much less flexible in 
terms of complex SQL and adding filters.


Regards,

Seth


On 07/02/2017 21:12, karsten wrote:
  
Dear All,


I am trying to find out if MapServer (and/or OGR) will work with spatial
databases newer than Microsoft SQL Server 2008. I know that the drivers work
with that older version but did not want to promise to a client that it
would. At this point I am not able to test it directly because I do not have
access to a Microsoft SQL Server 2012 or newer to verify.
Does anyone have experience and succeed with this or anyone who can share
their experiences ?

Cheers
Karsten

www.terragis.net

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases

[karsten]

 
Dear All,

I am trying to find out if MapServer (and/or OGR) will work with spatial
databases newer than Microsoft SQL Server 2008. I know that the drivers work
with that older version but did not want to promise to a client that it
would. At this point I am not able to test it directly because I do not have
access to a Microsoft SQL Server 2012 or newer to verify.
Does anyone have experience and succeed with this or anyone who can share
their experiences ? 

Cheers
Karsten

www.terragis.net

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Setting a point into postgresql

[Ahmed Tolba]

Hi All,
I’m trying to set a point xyz, which represents longitude altitude latitude, 
but when I create the feature, I get Error 1 Can’t find transcation response.

The Geometry field is set by this in the database:

ALTER TABLE poiserver ALTER COLUMN geom TYPE GEOMETRY(POINTZ,4326) USING 
ST_Force3D(geom);

Thanks
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] group and subgroup

[Yves Jacolin]

Something like this:
LAYER
  NAME "layer1"
  GROUP "mygroup"
  STATUS ON
  METADATA
"
*wms_layer_group" "test/test2"*
  END
END

LAYER
  NAME "layer2"
  GROUP "mygroup"
  STATUS ON
  ...
  METADATA
"
*wms_layer_group" "test/test2"*  END
END

LAYER
   NAME test2
END

Note that curently you should create a fake layer (test2) to call test2 to
"merge" layer1 and layer2. Thomas Bonfort created last week a PR in MS to
let the user to call test2 without the fake layer.

See https://github.com/mapserver/mapserver/pull/5371

Y.

2017-02-06 21:47 GMT+01:00 :

> Another way to do it, is with "
> *wms_layer_group"*
>
> as decribed here; http://mapserver.org/ogc/wms_server.html
> But that might be a little more complicated but allows You more levels of
> subgroups.
>
> Lars S.
>
> -Originalmeddelande-
> > Från: "Stephen Woodbridge" 
> > Till: mapserver-users@lists.osgeo.org
> > Datum: 2017-02-06 21:34
> > Ämne: Re: [mapserver-users] group and subgroup
>
> >
> > On 2/6/2017 3:11 PM, milad nidal wrote:
> > > Hi,
> > > I'd like to create a subgroup with 2 layers. is-it posible?
> > > I tried what is menionned in the mapserver,s doc but it did not work.
> > > something like (groupe : test and subgroup test2 with layer1 and layer
> 2
> > > in the subgroup)
> > > Thanks
> >
> > Try this:
> >
> > LAYER
> >   NAME "layer1"
> >   GROUP "mygroup"
> >   STATUS ON
> >   ...
> > END
> >
> > LAYER
> >   NAME "layer2"
> >   GROUP "mygroup"
> >   STATUS ON
> >   ...
> > END
> >
> > Now you can request layer "mygroup" and both layers will be activated.
> >
> > -SteveW
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> >
> > ___
> > mapserver-users mailing list
> > mapserver-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> --
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>



-- 
Responsable Formation et Support
Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex

Tel (France) : +33 4 58 48 20 43 (new !)
Tel (Suisse) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
Fax : 04 79 70 15 81

Mail : yves.jaco...@camptocamp.com
http://www.camptocamp.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users