Re: [mapserver-users] Any way for WFS-T with SQL Server?

2013-04-23 Thread Rahkonen Jukka
Hi, TinyOWS supports only PostGIS and you can't do WFS-T against your SQL Server with Mapserver family. Try Geoserver instead http://docs.geoserver.org/stable/en/user/data/database/sqlserver.html -Jukka Rahkonen- Saka Royban wrote: Hi all. I've asked this question in MS4W mailing list but

[mapserver-users] error with installation application packages for MS4W

2013-04-23 Thread Suzanne Maas
Dear all, I am a novice to MS4W and web mapping applications, and got recommended the MS4W to start building up a web map. I have installed the MS4W 3.0.6 package directly on my C drive (so C:\ms4w). I am running on Windows 7 and using a Chrome browser. The installation seems succesful and when

Re: [mapserver-users] problem with processquerytemplate and large selection sets

2013-04-23 Thread Lime, Steve D (MNIT)
What does the template look like? --Steve From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Bistrais, Bob Sent: Friday, April 19, 2013 3:29 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] problem with

Re: [mapserver-users] problem with processquerytemplate and large selection sets

2013-04-23 Thread Bistrais, Bob
Here it is: !-- MapServer Template -- bSiteID:/b [SiteID]br/ bBasic Structure/b [BasicStruc]br/ bBarrier Class:/b [BarrierCla]br/ bSite Status:/b [SiteStatus]br/ bDate:/b [Date_]br/ bStream:/b [Stream]br/ bTown:/b [Town]br/ bUTM East:/b [UTMEast]br/ bUTM North:/b [UTMNorth]br/ bRoad Name:/b

Re: [mapserver-users] problem with processquerytemplate and large selection sets

2013-04-23 Thread Lime, Steve D (MNIT)
Hmmm... so this is just a TEMPLATE 'thisfile' setting in the mapfile and not using the new-style templates. It really should be quite efficient. Are your timings internal or external to MapServer? I'm curious if this could be a PHP issue. Can you do your query against the CGI/FastCGI and

Re: [mapserver-users] Query one return multiple

2013-04-23 Thread Lime, Steve D (MNIT)
I don't think so. If feature ids are sequential you might be able to link to a query that would get you the next feature. Depends on what client environment you're using. You could do this with MapScript though. Steve From: mapserver-users-boun...@lists.osgeo.org

Re: [mapserver-users] problem with processquerytemplate and large selection sets

2013-04-23 Thread Bistrais, Bob
Not sure what you meant by internal/external timings? I do know that we are running MapServer in a FastCGI mode. I'm also in a GeoMoose framework, so I'm not sure how to run it outside of MapScript (open for suggestions). But one thing I do know is that the QueryByAttributes occurs in a

Re: [mapserver-users] problem with processquerytemplate and large selection sets

2013-04-23 Thread Lime, Steve D (MNIT)
I mean did you add timing statements to the PHP code or did you muck about in the MapServer/MapScript source. It's possible that PHP is slow, not the specific MapServer calls. From: Bistrais, Bob [mailto:bob.bistr...@maine.gov] Sent: Tuesday, April 23, 2013 12:48 PM To: Lime, Steve D (MNIT);

Re: [mapserver-users] problem with processquerytemplate and large selection sets

2013-04-23 Thread Bistrais, Bob
OK, I hadn't done that. I'll try that later this afternoon and see what turns up. From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us] Sent: Tuesday, April 23, 2013 1:51 PM To: Bistrais, Bob; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] problem with processquerytemplate

Re: [mapserver-users] MapCache and WMS source with Basic Auth

2013-04-23 Thread Rahkonen Jukka
Hi, I can't get so far as testing the headers because it looks like MapCache cannot use https. I can see from the logs that MapCache tries to connect our server with plain http but is will fail because we demand https http urlhttp://my.server.fi/cgi-bin/iwms1/url /http If I change

Re: [mapserver-users] Any way for WFS-T with SQL Server?

2013-04-23 Thread Robert Sanson
I have implemented a variation of WFS-T using dedicated Python scripts in the cgi-bin directory to run the queries against SQL-Server. The format of data between the Python scripts and my OpenLayers client that I use is GeoJSON or WKT. Mapserver is not involved directly, but can render the data

Re: [mapserver-users] Something wrong with Spatialite

2013-04-23 Thread Jeff McKenna
On 2013-04-21 6:17 PM, Rahkonen Jukka wrote: Hi, I can't get Spatialite views or SQL selects to work as data source with recent Mapserver versions. I created an issue and made a simple test database and corresponding mapfile for if someone wants to make a test in different environment. I

Re: [mapserver-users] Any way for WFS-T with SQL Server?

2013-04-23 Thread Saka Royban
Thanks a lot for your help Jeff, i wasn't aware of ZOO project, so i'm gonna give it a try and see how it behaves with multiple user editing. Thaaks for your introduction Robert, I wonder if i can have a copy of your python script. If it involves some kind of licenses for your company or etc.,