[mapserver-users] Mapserver search performance
Hello Everyone, I have programmed a GIS application using Mapserver, Google maps and Tilecache. The functionality of this GIS application is to extract the data (from the dbf file) for all features (Points) within a randomly drawn user shape and doing some statistical operation on that data. I use an NQUERY mode with MAPSHAPE attribute to get all the data for the user drawn shape. Mapserver takes aout 5-10 seconds for a small shape (a couple of square miles) but as the shape gets bigger (hundreds of square miles), the time taken to fetch all data related to the features/points lying in the shape grows exponentially (Upto 2 hours for some shapes). Until now, we were restricting the maximum area a shape can have but we have to get rid of that. Is there a way to improve the performance in any way? Will SHPTREE work for this purpose? The features are currently points only but we may move to polygons in future. We use the .shp files for the shapes. Is it advantageous to move to a database instead? If yes, what database works best? What I did notice is that for any given request to mapserver, however large the shape, the CPU utilization never crosses 12%. Can we improve performance by increasing the RAM or maybe move to a solid state hard drive? There is also the possibility of moving this application to Cloud computing. Anything that will improve the performance actually. Can someone point me in the right direction as to what might be the current bottleneck? T current setup is on windows and uses MS4W on an Apache server. Thanks, Varun ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Transparency of overlapping PNG-symbols [solved]
Hello thomas, thomas bonfort thomas.bonf...@gmail.com, [20110408 - 16:52:53] Given the artifact, I'd say that you are using the GD renderer. Are you sure it's the AGG one that is being selected when you create that image? At least I was, yes, but after looking at the _right_ mapfile it was missing the AGG-rendering-options. setting the following helps. IMAGETYPE aggpng #8bit png, supports transparency. OUTPUTFORMAT NAME aggpng DRIVER AGG/PNG MIMETYPE image/png ## transparency only with RGBA Image Mode ## mapserver had to be compiled -with-experimental-png IMAGEMODE RGBA EXTENSION png FORMATOPTION QUANTIZE_FORCE=ON FORMATOPTION QUANTIZE_COLORS=256 FORMATOPTION QUANTIZE_NEW=ON TRANSPARENT ON END Best regards Stephan 2011/4/8 Lime, Steve D (DNR) steve.l...@state.mn.us: Can you share the batnight.png file? Any difference if you remove TRANSPARENT 0? It shouldn't have any effect since transparency is picked up from the pixmap. By chance does this work ok in 6.0? Steve -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner signature.asc Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Transparency of overlapping PNG-symbols [solved]
Ok, thanks. could you check the same mapfile with GD on mapserver 6.0 to see if the issue still exists? thomas On Mon, Apr 11, 2011 at 09:39, Stephan Holl stephan.h...@intevation.de wrote: Hello thomas, thomas bonfort thomas.bonf...@gmail.com, [20110408 - 16:52:53] Given the artifact, I'd say that you are using the GD renderer. Are you sure it's the AGG one that is being selected when you create that image? At least I was, yes, but after looking at the _right_ mapfile it was missing the AGG-rendering-options. setting the following helps. IMAGETYPE aggpng #8bit png, supports transparency. OUTPUTFORMAT NAME aggpng DRIVER AGG/PNG MIMETYPE image/png ## transparency only with RGBA Image Mode ## mapserver had to be compiled -with-experimental-png IMAGEMODE RGBA EXTENSION png FORMATOPTION QUANTIZE_FORCE=ON FORMATOPTION QUANTIZE_COLORS=256 FORMATOPTION QUANTIZE_NEW=ON TRANSPARENT ON END Best regards Stephan 2011/4/8 Lime, Steve D (DNR) steve.l...@state.mn.us: Can you share the batnight.png file? Any difference if you remove TRANSPARENT 0? It shouldn't have any effect since transparency is picked up from the pixmap. By chance does this work ok in 6.0? Steve -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Transparency of overlapping PNG-symbols [solved]
Hello thomas, thomas bonfort thomas.bonf...@gmail.com, [20110411 - 09:41:54] Ok, thanks. could you check the same mapfile with GD on mapserver 6.0 to see if the issue still exists? We will do so when we have set up a MS6-Box, which will be the case soon since my collegue björn is going to package MS6 shortly in the future. Best Stephan thomas On Mon, Apr 11, 2011 at 09:39, Stephan Holl stephan.h...@intevation.de wrote: Hello thomas, thomas bonfort thomas.bonf...@gmail.com, [20110408 - 16:52:53] Given the artifact, I'd say that you are using the GD renderer. Are you sure it's the AGG one that is being selected when you create that image? At least I was, yes, but after looking at the _right_ mapfile it was missing the AGG-rendering-options. setting the following helps. IMAGETYPE aggpng #8bit png, supports transparency. OUTPUTFORMAT NAME aggpng DRIVER AGG/PNG MIMETYPE image/png ## transparency only with RGBA Image Mode ## mapserver had to be compiled -with-experimental-png IMAGEMODE RGBA EXTENSION png FORMATOPTION QUANTIZE_FORCE=ON FORMATOPTION QUANTIZE_COLORS=256 FORMATOPTION QUANTIZE_NEW=ON TRANSPARENT ON END Best regards Stephan 2011/4/8 Lime, Steve D (DNR) steve.l...@state.mn.us: Can you share the batnight.png file? Any difference if you remove TRANSPARENT 0? It shouldn't have any effect since transparency is picked up from the pixmap. By chance does this work ok in 6.0? Steve -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner signature.asc Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
VS: [mapserver-users] Mapserver search performance
Hi, Shptree will help and stopwatch will tell you how much. Without spatial index Mapserver needs to go through the whole shapefile every time. Have a try, it will not take very many seconds to run shptree. Make different requests, take times with and without .qix files and you will some numbers. Change the requests and request order (query 1 with .qix/withour qix, query 2 without .qix/with .qix) so that you can see if you are actually testing the speed of disk access and memory cache access and not the effect of having spatial index. By adding DEBUG 5 for your layer you don't need stopwatch but you'll get timings into ms_errorfile. -Jukka Rahkonen- Varun saraf wrote: Hello Everyone, I have programmed a GIS application using Mapserver, Google maps and Tilecache. The functionality of this GIS application is to extract the data (from the dbf file) for all features (Points) within a randomly drawn user shape and doing some statistical operation on that data. I use an NQUERY mode with MAPSHAPE attribute to get all the data for the user drawn shape. Mapserver takes aout 5-10 seconds for a small shape (a couple of square miles) but as the shape gets bigger (hundreds of square miles), the time taken to fetch all data related to the features/points lying in the shape grows exponentially (Upto 2 hours for some shapes). Until now, we were restricting the maximum area a shape can have but we have to get rid of that. Is there a way to improve the performance in any way? Will SHPTREE work for this purpose? The features are currently points only but we may move to polygons in future. We use the .shp files for the shapes. Is it advantageous to move to a database instead? If yes, what database works best? What I did notice is that for any given request to mapserver, however large the shape, the CPU utilization never crosses 12%. Can we improve performance by increasing the RAM or maybe move to a solid state hard drive? There is also the possibility of moving this application to Cloud computing. Anything that will improve the performance actually. Can someone point me in the right direction as to what might be the current bottleneck? T current setup is on windows and uses MS4W on an Apache server. Thanks, Varun ___ 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] Tag SYMBOL - CENTER/ORIGIN
Hallo List, in the Document http://mapserver.org/trunk/development/rfc/ms-rfc-45.html is mentioned the tag CENTER / ORIGIN for SYMBOL: was this feature already implemented? if yes, in which Mapserver version? Greetings, Tommaso ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Tag SYMBOL - CENTER/ORIGIN
No, it was not implemented, and is on hold until someone funds it. regards, thomas On Mon, Apr 11, 2011 at 10:54, tommaso tommas...@googlemail.com wrote: Hallo List, in the Document http://mapserver.org/trunk/development/rfc/ms-rfc-45.html is mentioned the tag CENTER / ORIGIN for SYMBOL: was this feature already implemented? if yes, in which Mapserver version? Greetings, Tommaso ___ 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: VS: [mapserver-users] Mapserver search performance
Thanks a lot for the quick reply. I will give it a try. On Mon, Apr 11, 2011 at 1:50 PM, Rahkonen Jukka jukka.rahko...@mmmtike.fi wrote: Hi, Shptree will help and stopwatch will tell you how much. Without spatial index Mapserver needs to go through the whole shapefile every time. Have a try, it will not take very many seconds to run shptree. Make different requests, take times with and without .qix files and you will some numbers. Change the requests and request order (query 1 with .qix/withour qix, query 2 without .qix/with .qix) so that you can see if you are actually testing the speed of disk access and memory cache access and not the effect of having spatial index. By adding DEBUG 5 for your layer you don't need stopwatch but you'll get timings into ms_errorfile. -Jukka Rahkonen- Varun saraf wrote: Hello Everyone, I have programmed a GIS application using Mapserver, Google maps and Tilecache. The functionality of this GIS application is to extract the data (from the dbf file) for all features (Points) within a randomly drawn user shape and doing some statistical operation on that data. I use an NQUERY mode with MAPSHAPE attribute to get all the data for the user drawn shape. Mapserver takes aout 5-10 seconds for a small shape (a couple of square miles) but as the shape gets bigger (hundreds of square miles), the time taken to fetch all data related to the features/points lying in the shape grows exponentially (Upto 2 hours for some shapes). Until now, we were restricting the maximum area a shape can have but we have to get rid of that. Is there a way to improve the performance in any way? Will SHPTREE work for this purpose? The features are currently points only but we may move to polygons in future. We use the .shp files for the shapes. Is it advantageous to move to a database instead? If yes, what database works best? What I did notice is that for any given request to mapserver, however large the shape, the CPU utilization never crosses 12%. Can we improve performance by increasing the RAM or maybe move to a solid state hard drive? There is also the possibility of moving this application to Cloud computing. Anything that will improve the performance actually. Can someone point me in the right direction as to what might be the current bottleneck? T current setup is on windows and uses MS4W on an Apache server. Thanks, Varun ___ 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] box substitution for ogr layers
Hello, Is it possible to have a !BOX! substitution for an OGR layer (CONNECTION value) ? The box substitution seems only available to postgis layers. What I'm trying to have is something like: MAP ... LAYER NAME world_borders TYPE POLYGON CONNECTIONTYPE OGR CONNECTION http://www.example.com/world_borders.json?bbox=!BOX!; ... END END Regards, fredj -- Frédéric Junod Camptocamp SA ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer 6: ESRI Grid display with KMZ output
Hi, If you are willing to share a sample map file + this particular format file, I can look into the kmz output issue. If that is the case, wither send me the sample or open a trac bug and attche the data. Please assign the bug to me (assefa). Assefa On 08/04/2011 8:09 AM, Cécile Alfred wrote: Hi, I try to use Mapserver 6 beta 5 to generate kmz output with several type of input data (geotiff, shape and esri ascii grid): It is OK with geotiff and shape but there is no result with grd (empty image in temp). If I try to generate png output it's OK for all. Thank you for help Kelly ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Assefa Yewondwossen Software Analyst Email: yass...@dmsolutions.ca http://www.dmsolutions.ca/ Phone: (613) 565-5056 (ext 14) Fax: (613) 565-0925 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] box substitution for ogr layers
On 11-04-11 06:01 AM, Frederic Junod wrote: Hello, Is it possible to have a !BOX! substitution for an OGR layer (CONNECTION value) ? The box substitution seems only available to postgis layers. What I'm trying to have is something like: MAP ... LAYER NAME world_borders TYPE POLYGON CONNECTIONTYPE OGR CONNECTION http://www.example.com/world_borders.json?bbox=!BOX!; ... END END fredj, This seems like a plausible thing to add but I'm hesitant to do it at this late point in the release cycle. Could you file an enhancement ticket with the request? Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, warmer...@pobox.com light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| Geospatial Programmer for Rent ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] fastcgi mode with raster layer?
I've just activated the fastcgi mode (RHEL5 - Mapserver 5.6.3 - Httpd) on my server. is it normal to have no speed increase for a raster layer? Does the fastcgi mode is optimized mainly for database layers as Oracle or PostGIS? thank you in advance. MartinOuellet ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] fastcgi mode with raster layer?
Martin, you'll have to set explicitly the CONNECTION POOL setting to get a persistant DB connection for a specific layer. See: http://mapserver.org/mapfile/layer.html (search for pooling) Alan On April 11, 2011 01:22:11 pm Martin Ouellet wrote: I've just activated the fastcgi mode (RHEL5 - Mapserver 5.6.3 - Httpd) on my server. is it normal to have no speed increase for a raster layer? Does the fastcgi mode is optimized mainly for database layers as Oracle or PostGIS? thank you in advance. MartinOuellet -- Alan Boudreault Mapgears http://www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] fastcgi mode with raster layer?
Martin, fastcgi will essentially give you speedups in these two cases: * with slow-to-open data connections (i.e. oracle, some gdal/ogr datasources?) if you use CLOSE_CONNECTION=DEFER * and/or when the cost of creation of a process becomes non negligible compared to the time that the mapserv process will actually be running for each request. basically, there is little advantage of using fastcgi if your map draws are heavy, or if you are not using oracle connections. YMMV, -- thomas On Mon, Apr 11, 2011 at 19:22, Martin Ouellet geomart...@gmail.com wrote: I've just activated the fastcgi mode (RHEL5 - Mapserver 5.6.3 - Httpd) on my server. is it normal to have no speed increase for a raster layer? Does the fastcgi mode is optimized mainly for database layers as Oracle or PostGIS? thank you in advance. MartinOuellet ___ 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] box substitution for ogr layers
On Mon, Apr 11, 2011 at 3:56 PM, Frank Warmerdam warmer...@pobox.com wrote: On 11-04-11 06:01 AM, Frederic Junod wrote: Hello, Is it possible to have a !BOX! substitution for an OGR layer (CONNECTION value) ? The box substitution seems only available to postgis layers. What I'm trying to have is something like: MAP ... LAYER NAME world_borders TYPE POLYGON CONNECTIONTYPE OGR CONNECTION http://www.example.com/world_borders.json?bbox=!BOX!; ... END END fredj, This seems like a plausible thing to add but I'm hesitant to do it at this late point in the release cycle. Could you file an enhancement ticket with the request? http://trac.osgeo.org/mapserver/ticket/3827 Regards, fredj -- Frédéric Junod Camptocamp SA ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] fastcgi mode with raster layer?
Hi, I have a feeling that there is a difference also when the raster layer is used through a big tileindex which is collecting thousands or tens of thousands of images. I do not have any reliable numbers available right now, though. thomas bonfort wrote: Martin, fastcgi will essentially give you speedups in these two cases: * with slow-to-open data connections (i.e. oracle, some gdal/ogr datasources?) if you use CLOSE_CONNECTION=DEFER * and/or when the cost of creation of a process becomes non negligible compared to the time that the mapserv process will actually be running for each request. basically, there is little advantage of using fastcgi if your map draws are heavy, or if you are not using oracle connections. YMMV, -- thomas On Mon, Apr 11, 2011 at 19:22, Martin Ouellet geomart...@gmail.com wrote: I've just activated the fastcgi mode (RHEL5 - Mapserver 5.6.3 - Httpd) on my server. is it normal to have no speed increase for a raster layer? Does the fastcgi mode is optimized mainly for database layers as Oracle or PostGIS? thank you in advance. MartinOuellet ___ 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 mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: making POINT with SQL
Hi Jukka, This is the error in the debug file: Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named 'test'. in /xxx/xx/xx/xxx.php on line 992 Warning: [MapServer Error]: msPOSTGISLayerParseData(): Error parsing POSTGIS data variable. Must contain 'geometry_column from table_name' or 'geom from (subselect) as foo' (couldnt find ' from '). More help: Error with POSTGIS data variable. You specified '%data%'. Standard ways of specifiying are : (1) 'geometry_column from geometry_table' (2) 'geometry_column from (sub query) as foo using unique column name using SRID=srid#' Make sure you put in the 'using unique column name' and 'using SRID=#' clauses in. For more help, please see http://postgis.refractions.net/documentation/ Mappostgis.c - version of Jan 23/2004. in /var/www/html/dev/jmonestel/trunk/app/lib/mapaMapscriptF.class.php on line 992 This is my Layer: LAYER NAME test TYPE POINT STATUS ON connectiontype POSTGIS connection dbname= user=x host=x port=x data %data% projection proj=latlong ellps=WGS84 datum=WGS84 end CLASS NAME juan STYLE SYMBOL 'juan2' COLOR 0 119 255 SIZE 2 END END END # layer My %data% is geo_coordenada FROM (select cod_referencia as oid, geo_coordenada, ind_cor from ponto_referencia where cod_referencia = 1 ) as map using SRID=4326 The SQL brings me an geo info (010120E61079E9263108DC42C08716D9CEF75338C0) that in text is = POINT(-37.719 -24.328) -Original Message- From: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi] Sent: Thu 4/7/2011 3:35 PM To: Juan Carlos Monestel; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] RE: making POINT with SQL Hi, First add DEBUG 5, it may generate some interesting information for you into ms_errorfile. Next, comment out maxscale to be sure it is not preventing the rendering. Change it to MAXSCALEDENOM later, maxscale is not to be used any more. Add PROJECTION into your LAYER for getting more control on what is happening. And tell us the exact request you were using. Very often a blank map without any errors means that Mapserver does not find data from the requested map window, and very often it is because of some misconfiguration or misunderstanding with projections. -Jukka Rahkonen- Juan Carlos Monestel wrote: Hi it is not drawing and no error occurs -Original Message- From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us] Sent: Thu 4/7/2011 2:43 PM To: Juan Carlos Monestel; mapserver-users@lists.osgeo.org Subject: RE: making POINT with SQL What does not working mean? Steve From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Juan Carlos Monestel Sent: Thursday, April 07, 2011 12:04 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] making POINT with SQL Hello I'm trying to make an POINT in the map but it's not working this is my Layer layer name ponto connectiontype POSTGIS connection dbname= user=x host=x port=x data geo_info from table type point status on metadata tile_source nocache end maxscale 301 class style size 4 symbol circulo color 0 0 0 end style size 1 symbol circulo color 255 255 255 end end end The SQL brings me an geo info (010120E61079E9263108DC42C08716D9CEF75338C0) that in text is = POINT(-37.719 -24.328) Any Ideas ? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] RE: making POINT with SQL
Hi, Your %data% looks rather similar than the example. You seem to miss using unique, try what happens if you add it. -Jukka Rahkonen- Juan Carlos Monestel wrote: Hi Jukka, This is the error in the debug file: Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named 'test'. in /xxx/xx/xx/xxx.php on line 992 Warning: [MapServer Error]: msPOSTGISLayerParseData(): Error parsing POSTGIS data variable. Must contain 'geometry_column from table_name' or 'geom from (subselect) as foo' (couldnt find ' from '). More help: Error with POSTGIS data variable. You specified '%data%'. Standard ways of specifiying are : (1) 'geometry_column from geometry_table' (2) 'geometry_column from (sub query) as foo using unique column name using SRID=srid#' Make sure you put in the 'using unique column name' and 'using SRID=#' clauses in. For more help, please see http://postgis.refractions.net/documentation/ http://postgis.refractions.net/documentation/ Mappostgis.c - version of Jan 23/2004. in /var/www/html/dev/jmonestel/trunk/app/lib/mapaMapscriptF.class.php on line 992 This is my Layer: LAYER NAME test TYPE POINT STATUS ON connectiontype POSTGIS connection dbname= user=x host=x port=x data %data% projection proj=latlong ellps=WGS84 datum=WGS84 end CLASS NAME juan STYLE SYMBOL 'juan2' COLOR 0 119 255 SIZE 2 END END END # layer My %data% is geo_coordenada FROM (select cod_referencia as oid, geo_coordenada, ind_cor from ponto_referencia where cod_referencia = 1 ) as map using SRID=4326 The SQL brings me an geo info (010120E61079E9263108DC42C08716D9CEF75338C0) that in text is = POINT(-37.719 -24.328) -Original Message- From: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi mailto:jukka.rahko...@mmmtike.fi ] Sent: Thu 4/7/2011 3:35 PM To: Juan Carlos Monestel; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] RE: making POINT with SQL Hi, First add DEBUG 5, it may generate some interesting information for you into ms_errorfile. Next, comment out maxscale to be sure it is not preventing the rendering. Change it to MAXSCALEDENOM later, maxscale is not to be used any more. Add PROJECTION into your LAYER for getting more control on what is happening. And tell us the exact request you were using. Very often a blank map without any errors means that Mapserver does not find data from the requested map window, and very often it is because of some misconfiguration or misunderstanding with projections. -Jukka Rahkonen- Juan Carlos Monestel wrote: Hi it is not drawing and no error occurs -Original Message- From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us mailto:steve.l...@state.mn.us ] Sent: Thu 4/7/2011 2:43 PM To: Juan Carlos Monestel; mapserver-users@lists.osgeo.org Subject: RE: making POINT with SQL What does not working mean? Steve From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org mailto:mapserver-users-boun...@lists.osgeo.org ] On Behalf Of Juan Carlos Monestel Sent: Thursday, April 07, 2011 12:04 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] making POINT with SQL Hello I'm trying to make an POINT in the map but it's not working this is my Layer layer name ponto connectiontype POSTGIS connection dbname= user=x host=x port=x data geo_info from table type point status on metadata tile_source nocache end maxscale 301 class style size 4 symbol circulo color 0 0 0 end style size 1 symbol circulo color 255 255 255 end end end The SQL brings me an geo info (010120E61079E9263108DC42C08716D9CEF75338C0) that in text is = POINT(-37.719 -24.328) Any Ideas ? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: Problems with Query Template (Chameleon)
Not a Chameleon user so I may not be of much help. Any errors being logged? What does the template file look like? It’s possible that ms4w_2.3.1’s MapServer did not require a magic string be on the first line of the template. In new versions it is required. Basically the first line of a template must contain the string “MapServer Template”. Typically you’d put that in a HTML comment, e.g.: !—MapServer Tempate -- ...template follows... That’s my first guess anyway. Steve From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andy Hird Sent: Friday, April 08, 2011 3:00 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Problems with Query Template (Chameleon) Hi there - really need some help if you can please regarding Template Query feature, and I have googled to exhaustion :-/ Background: I have an existing Map file referencing MapInfo Tab files running under ms4w_2.3.1 chameleon_ms4w-2.4.1 I have installed ms4w - V3.0.1 and chameleon V2.6.0 Copied my Map file across and made the necessary adjustments to get it working. However when using the Query Widget (info of layers at mouse click) against MapInfo Layers it is no longer returning results, and yet it did previously. My knowledge is not that great in php etc – but I suspect that its requiring a dbf rather than MapInfo Tab as it does work with a shp, dbf set of files. Can Anyone help please as I really struggling – ideally I just want to use the old widget. However If someone can provide example of placing a button on a html page that would call query functionality that would be very helpful too. Thanks in advance Andy The information contained in or attached to this message is the responsibility of the sender and is meant for the confidential use of the intended recipients. It does not necessarily represent the position of Aligned Assets. If you are not an intended recipient you are notified that you have received this communication in error and that review, dissemination or copying of this communication is prohibited. If you have received this in error, please notify us. Aligned Assets Limited Unit 5 River Court Albert Drive Sheerwater Woking GU21 5RP Company Registration No: 4610724 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users