date:20130423

[mapserver-users] sreera...@eisplc.com

2013-04-23 Thread Sreeraj K

sreera...@eisplc.com

 

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

[mapserver-users] mapserver tracking - location solutions

2013-04-23 Thread Sreeraj K

Hello, On browsing through, there are lot many optional download packages
under mapserver download.

How can I determine which will be more suitable for location based
applications like vehicle tracking/personal tracking?

 

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

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., so don't bother yourself. I'll 
write another one for myself, though I'm an ASP.net guy, not a python fan. 
Anyway, Thanks for your nice comment 




 From: Robert Sanson 
To: MapServer ; Saka Royban 
 
Sent: Wednesday, April 24, 2013 1:31 AM
Subject: Re: [mapserver-users] Any way for WFS-T with SQL Server?
 

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 in SQL-Server 
via OGR when the user need to print a PDF map.

Regards,

Robert

>>> Saka Royban  23/04/2013 9:20 p.m. >>>
Hi all.
I've asked this question in MS4W mailing list but it sounds no help.
I know that mapserver uses tinyOWS for WFS-T but as appears to me, just PostGIS 
is supported.
Is there any way to use WFS-T with backend SQL Server in MS4W (or even in Linux 
version of MapServer)?

Regards



This email and any attachments are confidential and intended solely for the 
addressee(s). If you are not the intended recipient, please notify us 
immediately and then delete this email from your system.

This message has been scanned for Malware and Viruses by Websense Hosted 
Security.
www.websense.com___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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 was testing with the brand new MS4W 3.1.0-beta1.
> The issue with a link to test data is in 
> https://github.com/mapserver/mapserver/issues/4636
> 

Hi Jukka, you can check the exact versions used in the MS4W environment
through this link on your machine:
http://127.0.0.1/README_INSTALL.html#mapserver-build-environment

GDAL build used was 1.10.0-RC4

-jeff




-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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 in SQL-Server 
via OGR when the user need to print a PDF map.

Regards,

Robert

>>> Saka Royban  23/04/2013 9:20 p.m. >>>
Hi all.
I've asked this question in MS4W mailing list but it sounds no help.
I know that mapserver uses tinyOWS for WFS-T but as appears to me, just PostGIS 
is supported.
Is there any way to use WFS-T with backend SQL Server in MS4W (or even in Linux 
version of MapServer)?

Regards



This email and any attachments are confidential and intended solely for the 
addressee(s). If you are not the intended recipient, please notify us 
immediately and then delete this email from your system.

This message has been scanned for Malware and Viruses by Websense Hosted 
Security.
www.websense.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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://my.server.fi/cgi-bin/iwms1

If I change url to use https then MapCache throws an error and nothing appears 
into server logs. If someone can confirm that https is not supported I will 
make a feature request and suggestion to mention this limitation in the 
Mapcache documentation.

-Jukka Rahkonen-

Martin Kofahl wrote:

>  According to http://mapserver.org/mapcache/config.html you can simply add 
> the athorization header to the http section:

  Basic [base64_encoded value from 
name,password]

You may use http://www.base64encode.org/ to encode your Username and Password, 
written as username,password -> encodes to dXNlcm5hbWUscGFzc3dvcmQ=, so the 
full configuration for this login will be:

Basic dXNlcm5hbWUscGFzc3dvcmQ=

Matrin

2013/4/12 Rahkonen Jukka 
mailto:jukka.rahko...@mmmtike.fi>>
Hi,

Is it possible to configure Mapcache to use a WMS source which is using http 
Basic authentication through https?  Are there some hidden/undocumented 
parameters for that or would it work simply by giving the service URL as

https://user:passw...@vmap0.tiles.osgeo.org/wms/vmap0

-Jukka Rahkonen-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

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 and large 
selection sets

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); 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 reasonable time (a couple seconds on 1100 records).  Where it's bogging 
down is in a for or a while loop, iterating through the result set.

From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 1:04 PM
To: Bistrais, Bob; 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 by-pass MapScript altogether.

Steve

From: Bistrais, Bob [mailto:bob.bistr...@maine.gov]
Sent: Tuesday, April 23, 2013 11:57 AM
To: Lime, Steve D (MNIT); 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

Here it is:

SiteID: [SiteID]
Basic Structure [BasicStruc]
Barrier Class: [BarrierCla]
Site Status: [SiteStatus]
Date: [Date_]
Stream: [Stream]
Town: [Town]
UTM East: [UTMEast]
UTM North: [UTMNorth]
Road Name: [RoadName]
Road Type: [RoadType]
Road Class: [RoadClass]
Number of Culverts: [NumberOfCu]
Material: [Material]
Specific Struct Type: [SpecificSt]
Inlet Cond: [InletCondi]
Blocked: [Blocked]
Inlet Water Depth: [InletWater]
Inlet Span: [InletSpan]
Inlet Clearance: [InletClear]
Crossing Structure Length: [CrossingSt]
Outlet Cond: [OutletCond]
Outlet Water Depth: [OutletWate]
Outlet Drop: [OutletDrop]
Outlet Span: [OutletSpan]
OutletClearace: [OutletClea]
Crossing Substrate: [CrossingSu]
Substrate Cond: [SubstrateC]
Condition: [Condition]
Fill Height: [FillHeight]
Bankfull Width: [BankfullWi]
BAT Count US: [batCountUS]
BAT Count DS: [batCountDS]
Sum Habitat Units: [Sum_HabUni]
US Blocked Miles: [USBlockedM]
US Blocked Alwife Pond Ac: [USBlockedA]
Comments: [Comments]

Photos:[SiteID]

From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 12:56 PM
To: Bistrais, Bob; 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 processquerytemplate and large 
selection sets

I've run into a problem when running queries with a large number of results (in 
my test case, over 1000 records, point locations, shape file).  After some 
testing, I found the problem wasn't the query itself- I did a queryByAttributes 
and it told me the records were selected within a couple seconds.  On further 
investigation, the problem seems to be when calling the processquerytemplate 
method.  The process takes a long time, often timing out beyond 30 seconds.  I 
am also suspicious that the result set is getting processed in such a way that 
we are reiterating over records.

Has anyone had a similar problem, and are there any suggestions ?

Here is a code excerpt, I hope it's enough to help...

$layer->queryByAttributes($queryItem,$queryExp,MS_MULTIPLE);
$numResults = $layer->getNumResults();
$layer->open();

for($i=0;$i<$layer->getNumResults();$i++){
$shape=$layer->getShape($layer->getResult($i));
$foundShapes[] = $shape;
$fields = array();
array_push($fields, 'wkt_geometry text');
foreach($attributes as $attribute) {
array_push($fields, $attribute.' text');
}
array_push($results,$map->processquerytemp

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); mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 reasonable time (a couple seconds on 1100 records).  Where it's bogging 
down is in a for or a while loop, iterating through the result set.

From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 1:04 PM
To: Bistrais, Bob; 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 by-pass MapScript altogether.

Steve

From: Bistrais, Bob [mailto:bob.bistr...@maine.gov]
Sent: Tuesday, April 23, 2013 11:57 AM
To: Lime, Steve D (MNIT); 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

Here it is:

SiteID: [SiteID]
Basic Structure [BasicStruc]
Barrier Class: [BarrierCla]
Site Status: [SiteStatus]
Date: [Date_]
Stream: [Stream]
Town: [Town]
UTM East: [UTMEast]
UTM North: [UTMNorth]
Road Name: [RoadName]
Road Type: [RoadType]
Road Class: [RoadClass]
Number of Culverts: [NumberOfCu]
Material: [Material]
Specific Struct Type: [SpecificSt]
Inlet Cond: [InletCondi]
Blocked: [Blocked]
Inlet Water Depth: [InletWater]
Inlet Span: [InletSpan]
Inlet Clearance: [InletClear]
Crossing Structure Length: [CrossingSt]
Outlet Cond: [OutletCond]
Outlet Water Depth: [OutletWate]
Outlet Drop: [OutletDrop]
Outlet Span: [OutletSpan]
OutletClearace: [OutletClea]
Crossing Substrate: [CrossingSu]
Substrate Cond: [SubstrateC]
Condition: [Condition]
Fill Height: [FillHeight]
Bankfull Width: [BankfullWi]
BAT Count US: [batCountUS]
BAT Count DS: [batCountDS]
Sum Habitat Units: [Sum_HabUni]
US Blocked Miles: [USBlockedM]
US Blocked Alwife Pond Ac: [USBlockedA]
Comments: [Comments]

Photos:[SiteID]

From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 12:56 PM
To: Bistrais, Bob; 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 processquerytemplate and large 
selection sets

I've run into a problem when running queries with a large number of results (in 
my test case, over 1000 records, point locations, shape file).  After some 
testing, I found the problem wasn't the query itself- I did a queryByAttributes 
and it told me the records were selected within a couple seconds.  On further 
investigation, the problem seems to be when calling the processquerytemplate 
method.  The process takes a long time, often timing out beyond 30 seconds.  I 
am also suspicious that the result set is getting processed in such a way that 
we are reiterating over records.

Has anyone had a similar problem, and are there any suggestions ?

Here is a code excerpt, I hope it's enough to help...

$layer->queryByAttributes($queryItem,$queryExp,MS_MULTIPLE);
$numResults = $layer->getNumResults();
$layer->open();

for($i=0;$i<$layer->getNumResults();$i++){
$shape=$layer->getShape($layer->getResult($i));
$foundShapes[] = $shape;
$fields = array();
array_push($fields, 'wkt_geometry text');
foreach($attributes as $attribute) {
array_push($fields, $attribute.' text');
}
array_push($results,$map->processquerytemplate(array(), false));

$layer->close();

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

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 reasonable time (a couple seconds on 1100 records).  Where it's bogging 
down is in a for or a while loop, iterating through the result set.

From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 1:04 PM
To: Bistrais, Bob; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 by-pass MapScript altogether.

Steve

From: Bistrais, Bob [mailto:bob.bistr...@maine.gov]
Sent: Tuesday, April 23, 2013 11:57 AM
To: Lime, Steve D (MNIT); 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

Here it is:





SiteID: [SiteID]
Basic Structure [BasicStruc]
Barrier Class: [BarrierCla]
Site Status: [SiteStatus]
Date: [Date_]
Stream: [Stream]
Town: [Town]
UTM East: [UTMEast]
UTM North: [UTMNorth]
Road Name: [RoadName]
Road Type: [RoadType]
Road Class: [RoadClass]
Number of Culverts: [NumberOfCu]
Material: [Material]
Specific Struct Type: [SpecificSt]
Inlet Cond: [InletCondi]
Blocked: [Blocked]
Inlet Water Depth: [InletWater]
Inlet Span: [InletSpan]
Inlet Clearance: [InletClear]
Crossing Structure Length: [CrossingSt]
Outlet Cond: [OutletCond]
Outlet Water Depth: [OutletWate]
Outlet Drop: [OutletDrop]
Outlet Span: [OutletSpan]
OutletClearace: [OutletClea]
Crossing Substrate: [CrossingSu]
Substrate Cond: [SubstrateC]
Condition: [Condition]
Fill Height: [FillHeight]
Bankfull Width: [BankfullWi]
BAT Count US: [batCountUS]
BAT Count DS: [batCountDS]
Sum Habitat Units: [Sum_HabUni]
US Blocked Miles: [USBlockedM]
US Blocked Alwife Pond Ac: [USBlockedA]
Comments: [Comments]

Photos:[SiteID]



From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 12:56 PM
To: Bistrais, Bob; 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 processquerytemplate and large 
selection sets

I've run into a problem when running queries with a large number of results (in 
my test case, over 1000 records, point locations, shape file).  After some 
testing, I found the problem wasn't the query itself- I did a queryByAttributes 
and it told me the records were selected within a couple seconds.  On further 
investigation, the problem seems to be when calling the processquerytemplate 
method.  The process takes a long time, often timing out beyond 30 seconds.  I 
am also suspicious that the result set is getting processed in such a way that 
we are reiterating over records.

Has anyone had a similar problem, and are there any suggestions ?

Here is a code excerpt, I hope it's enough to help...

$layer->queryByAttributes($queryItem,$queryExp,MS_MULTIPLE);
$numResults = $layer->getNumResults();
$layer->open();

for($i=0;$i<$layer->getNumResults();$i++){
$shape=$layer->getShape($layer->getResult($i));
$foundShapes[] = $shape;
$fields = array();
array_push($fields, 'wkt_geometry text');
foreach($attributes as $attribute) {
array_push($fields, $attribute.' text');
}
array_push($results,$map->processquerytemplate(array(), false));

$layer->close();


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

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 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Weisbender, Eric
Sent: Wednesday, April 17, 2013 11:40 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Query one return multiple

Hello list,

I was wondering if there is a way to query a point and return not only 
attributes for that point but the next points attribute in order in the dbf.  
Thanks in advance.

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

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 by-pass MapScript altogether.

Steve

From: Bistrais, Bob [mailto:bob.bistr...@maine.gov]
Sent: Tuesday, April 23, 2013 11:57 AM
To: Lime, Steve D (MNIT); mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

Here it is:





SiteID: [SiteID]
Basic Structure [BasicStruc]
Barrier Class: [BarrierCla]
Site Status: [SiteStatus]
Date: [Date_]
Stream: [Stream]
Town: [Town]
UTM East: [UTMEast]
UTM North: [UTMNorth]
Road Name: [RoadName]
Road Type: [RoadType]
Road Class: [RoadClass]
Number of Culverts: [NumberOfCu]
Material: [Material]
Specific Struct Type: [SpecificSt]
Inlet Cond: [InletCondi]
Blocked: [Blocked]
Inlet Water Depth: [InletWater]
Inlet Span: [InletSpan]
Inlet Clearance: [InletClear]
Crossing Structure Length: [CrossingSt]
Outlet Cond: [OutletCond]
Outlet Water Depth: [OutletWate]
Outlet Drop: [OutletDrop]
Outlet Span: [OutletSpan]
OutletClearace: [OutletClea]
Crossing Substrate: [CrossingSu]
Substrate Cond: [SubstrateC]
Condition: [Condition]
Fill Height: [FillHeight]
Bankfull Width: [BankfullWi]
BAT Count US: [batCountUS]
BAT Count DS: [batCountDS]
Sum Habitat Units: [Sum_HabUni]
US Blocked Miles: [USBlockedM]
US Blocked Alwife Pond Ac: [USBlockedA]
Comments: [Comments]

Photos:[SiteID]



From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 12:56 PM
To: Bistrais, Bob; 
mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 processquerytemplate and large 
selection sets

I've run into a problem when running queries with a large number of results (in 
my test case, over 1000 records, point locations, shape file).  After some 
testing, I found the problem wasn't the query itself- I did a queryByAttributes 
and it told me the records were selected within a couple seconds.  On further 
investigation, the problem seems to be when calling the processquerytemplate 
method.  The process takes a long time, often timing out beyond 30 seconds.  I 
am also suspicious that the result set is getting processed in such a way that 
we are reiterating over records.

Has anyone had a similar problem, and are there any suggestions ?

Here is a code excerpt, I hope it's enough to help...

$layer->queryByAttributes($queryItem,$queryExp,MS_MULTIPLE);
$numResults = $layer->getNumResults();
$layer->open();

for($i=0;$i<$layer->getNumResults();$i++){
$shape=$layer->getShape($layer->getResult($i));
$foundShapes[] = $shape;
$fields = array();
array_push($fields, 'wkt_geometry text');
foreach($attributes as $attribute) {
array_push($fields, $attribute.' text');
}
array_push($results,$map->processquerytemplate(array(), false));

$layer->close();


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

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

2013-04-23 Thread Bistrais, Bob

Here it is:





SiteID: [SiteID]
Basic Structure [BasicStruc]
Barrier Class: [BarrierCla]
Site Status: [SiteStatus]
Date: [Date_]
Stream: [Stream]
Town: [Town]
UTM East: [UTMEast]
UTM North: [UTMNorth]
Road Name: [RoadName]
Road Type: [RoadType]
Road Class: [RoadClass]
Number of Culverts: [NumberOfCu]
Material: [Material]
Specific Struct Type: [SpecificSt]
Inlet Cond: [InletCondi]
Blocked: [Blocked]
Inlet Water Depth: [InletWater]
Inlet Span: [InletSpan]
Inlet Clearance: [InletClear]
Crossing Structure Length: [CrossingSt]
Outlet Cond: [OutletCond]
Outlet Water Depth: [OutletWate]
Outlet Drop: [OutletDrop]
Outlet Span: [OutletSpan]
OutletClearace: [OutletClea]
Crossing Substrate: [CrossingSu]
Substrate Cond: [SubstrateC]
Condition: [Condition]
Fill Height: [FillHeight]
Bankfull Width: [BankfullWi]
BAT Count US: [batCountUS]
BAT Count DS: [batCountDS]
Sum Habitat Units: [Sum_HabUni]
US Blocked Miles: [USBlockedM]
US Blocked Alwife Pond Ac: [USBlockedA]
Comments: [Comments]

Photos:[SiteID]



From: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Sent: Tuesday, April 23, 2013 12:56 PM
To: Bistrais, Bob; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] problem with processquerytemplate and large 
selection sets

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 processquerytemplate and large 
selection sets

I've run into a problem when running queries with a large number of results (in 
my test case, over 1000 records, point locations, shape file).  After some 
testing, I found the problem wasn't the query itself- I did a queryByAttributes 
and it told me the records were selected within a couple seconds.  On further 
investigation, the problem seems to be when calling the processquerytemplate 
method.  The process takes a long time, often timing out beyond 30 seconds.  I 
am also suspicious that the result set is getting processed in such a way that 
we are reiterating over records.

Has anyone had a similar problem, and are there any suggestions ?

Here is a code excerpt, I hope it's enough to help...

$layer->queryByAttributes($queryItem,$queryExp,MS_MULTIPLE);
$numResults = $layer->getNumResults();
$layer->open();

for($i=0;$i<$layer->getNumResults();$i++){
$shape=$layer->getShape($layer->getResult($i));
$foundShapes[] = $shape;
$fields = array();
array_push($fields, 'wkt_geometry text');
foreach($attributes as $attribute) {
array_push($fields, $attribute.' text');
}
array_push($results,$map->processquerytemplate(array(), false));

$layer->close();


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

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 processquerytemplate and large 
selection sets

I've run into a problem when running queries with a large number of results (in 
my test case, over 1000 records, point locations, shape file).  After some 
testing, I found the problem wasn't the query itself- I did a queryByAttributes 
and it told me the records were selected within a couple seconds.  On further 
investigation, the problem seems to be when calling the processquerytemplate 
method.  The process takes a long time, often timing out beyond 30 seconds.  I 
am also suspicious that the result set is getting processed in such a way that 
we are reiterating over records.

Has anyone had a similar problem, and are there any suggestions ?

Here is a code excerpt, I hope it's enough to help...

$layer->queryByAttributes($queryItem,$queryExp,MS_MULTIPLE);
$numResults = $layer->getNumResults();
$layer->open();

for($i=0;$i<$layer->getNumResults();$i++){
$shape=$layer->getShape($layer->getResult($i));
$foundShapes[] = $shape;
$fields = array();
array_push($fields, 'wkt_geometry text');
foreach($attributes as $attribute) {
array_push($fields, $attribute.' text');
}
array_push($results,$map->processquerytemplate(array(), false));

$layer->close();

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

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

2013-04-23 Thread Saka Royban

Thanks Jukka
OGR supports writing in SQL Server. So, maybe i can do some kind of simulation 
for WFS-T behavior and use that library to save returned data from client into 
SQL Server. Any idea?

The problem with Geoserver is that - as stated in its website- it supports SQL 
Server 2008 and i'm using 2012 version.




 From: Rahkonen Jukka 
To: 'MapServer'  
Sent: Tuesday, April 23, 2013 2:14 PM
Subject: Re: [mapserver-users] Any way for WFS-T with SQL Server?
 


 
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 it sounds no help.
I know that mapserver uses tinyOWS for WFS-T but as appears to me, just PostGIS 
is supported.
Is there any way to use WFS-T with backend SQL Server in MS4W (or even in Linux 
version of MapServer)?
 
Regards
 
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[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 going to *
http://localhost* everything looks as it should according to the
documentation.

Then I downloaded the pmapper 4.3.1 application package, extracted the
files to my C drive and copied them into the ms4w folder. I refreshed the
Apache MS4W Web Server application and refreshed the local host page and
the pmapper package appeared on the localhost accordingly. However, when I
tried to start the demo application I received the following error message:
*Not Found. The requested URL /pmapper/ was not found on this server.*
*
*
I tried again with another application package (Chameleon 2.4.1), but the
same message appears.

Do you have any suggestions on how to resolve this problem?

Thanks a lot. Kind regards,

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

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 it sounds no help.
I know that mapserver uses tinyOWS for WFS-T but as appears to me, just PostGIS 
is supported.
Is there any way to use WFS-T with backend SQL Server in MS4W (or even in Linux 
version of MapServer)?

Regards

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

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

2013-04-23 Thread Saka Royban

Hi all.
I've asked this question in MS4W mailing list but it sounds no help.
I know that mapserver uses tinyOWS for WFS-T but as appears to me, just PostGIS 
is supported.
Is there any way to use WFS-T with backend SQL Server in MS4W (or even in Linux 
version of MapServer)?

Regards___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] sreera...@eisplc.com

[mapserver-users] mapserver tracking - location solutions

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

Re: [mapserver-users] Something wrong with Spatialite

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

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

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

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

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

Re: [mapserver-users] Query one return multiple

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

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

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

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

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

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

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

17 matches

Site Navigation

Mail list logo

Footer information