Re: [mapserver-users] Mapserver MS SQL Server Spacial
It is supported. See this sample: http://johanneskebeck.spaces.live.com/blog/cns!42E1F70205EC8A96!7718.entry?_c=BlogPart http://johanneskebeck.spaces.live.com/blog/cns%2142E1F70205EC8A96%217718.entry?_c=BlogPart pcr...@pcreso.com schrieb: --- On Fri, 1/9/09, Richard Greenwood richard.greenw...@gmail.com wrote: From: Richard Greenwood richard.greenw...@gmail.com Subject: Re: [mapserver-users] Mapserver MS SQL Server Spacial To: Donald Kerr donald.k...@dkerr.co.uk Cc: mapserver-users@lists.osgeo.org Date: Friday, January 9, 2009, 4:56 PM On Thu, Jan 8, 2009 at 6:33 AM, Donald Kerr donald.k...@dkerr.co.uk wrote: Is it possible to connect to MS SQL Server Spacial in the same was as PostGis? I do not think that Microsoft SQL Server is officially supported in MapServer yet, however you can get it working using binaries at: http://vbkto.dyndns.org:1280/tests/release-1400-20081013.zip read the thread at: http://mail.google.com/mail/?ui=2ik=a8159b4950view=cvfs=1tf=1ver=a9SCC6X1Wbgam=x_k6ocT3aCEJBf1qUObqFAq=release-1400-20081013.zipsearch=queryth=11cf6af5d8018b96qt=release.1.1400.1.20081013.1.zip.1 The relevant line in the layer object in the MapFile: CONNECTIONTYPE PLUGIN PLUGIN msplugin_mssql2008.dll CONNECTION server=.\SQLEXPRRESS; database=sc_lands; Integrated Security=true DATA geom FROM ownership WITH (INDEX(geom_sidx)) USING SRID=0 USING UNIQUE id HTH, Rich -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com ___ 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] Mapserver MS SQL Server Spacial
You can use the mssql2008 plugin on Windows platforms to access MSSQL2008 spatial, the latest fixes have been incorporated in MapServer version 5.2.1 (2008-12-01) Best regards, Tamas 2009/1/8 Donald Kerr donald.k...@dkerr.co.uk Is it possible to connect to MS SQL Server Spacial in the same was as PostGis? CONNECTIONTYPE postgis CONNECTION user=postgres dbname=MasterMap host=localhost DATA geom FROM topographicline USING UNIQUE toid Or CONNECTIONTYPE postgis CONNECTION user=postgres dbname=MasterMap host=localhost DATA geom FROM (SELECT toid, featurecode, textstring, orientation/10 AS orientation, fontnumber, anchorposition, textstyle, geom FROM cartographictext) AS foo USING UNIQUE toid If not, is there an alternative method without altering the database? Many thanks. Regards, Donald ___ 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] Problem with template
Hi everyone, Before to explain my problem I wish a happy new year. Well, my problem is relationed with a mail than i sent past dicember about problem with template. I define a map file with template definition in layer object (I attach it). I define also MIME format for query in the web object like wms_feature_info_mime_type text/html,text/plain. And finaly I define the templates files (I also attach them). The mapfile define a vector layer from shape file with few atrributes. The problem appears when I perform a GetFeatureinfo request: A GetFeatureInfo request in my web browser like this http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/datos/map/prueba.mapSERVICE=wmsVERSION=1.1.1REQUEST=GetFeatureInfoLAYERS=ENPSTYLES=QUERY_LAYERS=ENPx=300y=300SRS=EPSG:23030BBox= 610822.81,4137430.54,707593.47,4266594WIDTH=800HEIGHT=500INFO_FORMAT=text/html returns this result: GetFeatureInfo results: Layer 'ENP' Feature 6: As you can see, the query doesn't return attribute from shape file. When X,Y coordinates doesn't match with any feature, the request returns: GetFeatureInfo results: Search returned no results. Someone knows the source of the problem. Thanks. - Alexandre Rodier Asistencia Técnica del SIGA Servicio de Información e Integración Ambiental Dirección General de Patrimonio Natural y Biodiversidad Consejería de Agricultura y Agua. c/ Arquitecto Emilio Piñero, 1 Entresuelo C 30.007 Murcia Tel. 968246272 Correo-e: alexandre.rod...@carm.es mailto:alexandre.rod...@carm.es http://www.carm.es/medioambiente http://www.carm.es/medioambiente - prueba.map Description: prueba.map Contador Nombre Categoría Superficie Fecha declaración Más información Superficie geodb Perímetro [lrn] [ENP_NOMBRE] [ENP_CAT] [HECTAREAS] [ENP_FECHA] [LINK] [SHAPE_AREA] [SHAPE_LEN] ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Problem with template
Hola David, No he conseguido aún que me funcionen las plantillas, pero lo que sí he conseguido es que me devuelva todos los atributos en texto plano. Lo he conseguido añadiendo lo siguiente: wms_include_items all en el objeto LAYER. Y entonces me devuelve lo correcto (aunque de momento sin formato html): GetFeatureInfo results: Layer 'ENP' Feature 6: ENP_NOMBRE = 'Carrascoy y El Valle' ENP_CAT = 'Parque Regional' HECTAREAS = '11873.77004420' ENP_FECHA = '20050610' LINK = 'http://www.carm.es/medioambiente/articulos.html?id=2469' SHAPE_AREA = '1.18737700435e+008' SHAPE_LEN = '1.31916887359e+005' En fin, voy a seguir probando. Un saludo. Hi David, Template still does not work, but i get full results with plain text. I get it adding this tag wms_include_items all in the LAYER object. And then it returns correct results (though without html format). Well, I continue testing. Bye. - Alexandre Rodier Asistencia Técnica del SIGA Servicio de Información e Integración Ambiental Dirección General de Patrimonio Natural y Biodiversidad Consejería de Agricultura y Agua. c/ Arquitecto Emilio Piñero, 1 Entresuelo C 30.007 Murcia Tel. 968246272 Correo-e: alexandre.rod...@carm.es http://www.carm.es/medioambiente - De: David Martinez Morata [mailto:dama...@gmail.com] Enviado el: viernes, 09 de enero de 2009 10:23 Para: RODIER BATISSE, ALEXANDRE Asunto: Re: [mapserver-users] Problem with template No se si esto te ayudara, pero elimina ciertos elementos html de tus ficheros plantilla imaginate que los tres forman un solo fichero html, es decir que no cierres el contenido html (/html) en la cabecera ni en el cuerpo, hazlo solo en el pie, no pongas cabeceras a los ficheros cuerpo y pie... Suerte 2009/1/9 RODIER BATISSE, ALEXANDRE alexandre.rod...@carm.es Hi everyone, Before to explain my problem I wish a happy new year. Well, my problem is relationed with a mail than i sent past dicember about problem with template. I define a map file with template definition in layer object (I attach it). I define also MIME format for query in the web object like wms_feature_info_mime_type text/html,text/plain. And finaly I define the templates files (I also attach them). The mapfile define a vector layer from shape file with few atrributes. The problem appears when I perform a GetFeatureinfo request: A GetFeatureInfo request in my web browser like this http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/datos/map/prueba.mapSERVICE=wmsVERSION=1.1.1REQUEST=GetFeatureInfoLAYERS=ENPSTYLES=QUERY_LAYERS=ENPx=300y=300SRS=EPSG:23030BBox= 610822.81,4137430.54,707593.47,4266594WIDTH=800HEIGHT=500INFO_FORMAT=text/html returns this result: GetFeatureInfo results: Layer 'ENP' Feature 6: As you can see, the query doesn't return attribute from shape file. When X,Y coordinates doesn't match with any feature, the request returns: GetFeatureInfo results: Search returned no results. Someone knows the source of the problem. Thanks. - Alexandre Rodier Asistencia Técnica del SIGA Servicio de Información e Integración Ambiental Dirección General de Patrimonio Natural y Biodiversidad Consejería de Agricultura y Agua. c/ Arquitecto Emilio Piñero, 1 Entresuelo C 30.007 Murcia Tel. 968246272 Correo-e: alexandre.rod...@carm.es mailto:alexandre.rod...@carm.es http://www.carm.es/medioambiente http://www.carm.es/medioambiente - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Martinez Morata David Thinking GIS ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RASTER CLASSES AND QUERY ERROR
Dear all, I had some problem to visualize a GRID ESRI, but it was solved passing through a geodatabase, importing the GRID and extracting like other type of raster (img raster in my case). The layer was correctly visualized in the map. But at this level I want to check two points: - if I have a DEM for example (resolution 1 meter) and I want to visualize it with this same resolution, how I can define the class and the the style? The range of height goes from 900 m to 1324 m, but I can not create a class for every meter! Is there a way to represent in continous this range in the map? - for the query on this layer, I proceed in this way: I have an .img image raster and an associated table with a field VALUE with height value, COUNT with number of pixel and OGC_FID, created for the metadata necessary for query. This is a part of the table: VALUE COUNT OGC_FID 900 40730 901 13132 1 902 74752 ... ... And this is a part of the mapfile referred to query on raster: LAYER NAME DEM TYPE raster DATA rrdd33_id TEMPLATE ttt METADATA id_attribute_string OGC_FID|string query_returned_attributes VALUE END ... thanks Simone ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver MS SQL Server Spacial
...but it is by far not that performant, as e.g. MapDotNet is I'm sorry to say that, but that's the way it is.. Tamas Szekeres schrieb: You can use the mssql2008 plugin on Windows platforms to access MSSQL2008 spatial, the latest fixes have been incorporated in MapServer version 5.2.1 (2008-12-01) Best regards, Tamas 2009/1/8 Donald Kerr donald.k...@dkerr.co.uk mailto:donald.k...@dkerr.co.uk Is it possible to connect to MS SQL Server Spacial in the same was as PostGis? CONNECTIONTYPE postgis CONNECTION user=postgres dbname=MasterMap host=localhost DATA geom FROM topographicline USING UNIQUE toid Or CONNECTIONTYPE postgis CONNECTION user=postgres dbname=MasterMap host=localhost DATA geom FROM (SELECT toid, featurecode, textstring, orientation/10 AS orientation, fontnumber, anchorposition, textstyle, geom FROM cartographictext) AS foo USING UNIQUE toid If not, is there an alternative method without altering the database? Many thanks. Regards, Donald ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto: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] Query result attribute sums / totals
On Fri, Jan 9, 2009 at 12:51 AM, Ben Madin b...@remoteinformation.com.au wrote: G'day all, I have a straightforward query setup on a line layer showing movements between locations over a selected time period. When I select query mode, the data is returned beautifully (well, it's nice to see it!) # DateSpecies Number Purpose Origin Destination Movement id 1 07/07/2008 Cattle 40 Slaughter Luangprabang Vientiane Capital More Information 2 15/07/2008 Cattle 7 Sell To Middle Man Luangprabang Vientiane Capital More Information 3 27/07/2008 Cattle 5 Slaughter Luangprabang Vientiane Capital More Information etc However it would be really really great if the total Number over this time could be calculated as a total, and put in the footer row. (I have done this previously using mapscript, but for time reasons don't want to go there at the moment.) Is there an [attribute_sum] type of tag I can embed in the footer... or any other suggestions? You could easily calculate the sum with JavaScript in the browser. Declare a variable total and then for each row, within a JavaScript tag, something like: total += [Number] -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver MS SQL Server Spacial
2009/1/9 Roland Klabunde roland.klabu...@freenet.de ...but it is by far not that performant, as e.g. MapDotNet is I'm sorry to say that, but that's the way it is.. Do you have some measures to compare the performance? As far as I know MapDotNet use this same driver along with MapServer as the drawing kernel. The mssql2008 plugin have been contributed by ISC furthermore. Best regards, Tamas ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver MS SQL Server Spacial
We would normally require an exact measure to interpret this conclusion by describing the test environment settings and the data source settings in both cases. You cannot easily place the equal-sign between the performance of a cgi, fast cgi, or a mapscript application or even a single point layer may highly outperform a layer with complex symbology for instance. Best regards, Tamas 2009/1/9 Roland Klabunde roland.klabu...@freenet.de No, not at all. It is just an impression. I was comparing MapDotNet Ux vs. MS24W. The latter is much more less performing... Tamas Szekeres schrieb: 2009/1/9 Roland Klabunde roland.klabu...@freenet.de mailto: roland.klabu...@freenet.de ...but it is by far not that performant, as e.g. MapDotNet is I'm sorry to say that, but that's the way it is.. Do you have some measures to compare the performance? As far as I know MapDotNet use this same driver along with MapServer as the drawing kernel. The mssql2008 plugin have been contributed by ISC furthermore. Best regards, Tamas ___ 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] Help, Error Message: CGI variable map is not set.
There was an extra space in the address, it works now. boesiii wrote: I just trying to get a static map to show up in my browser. I have a map file created and I have a shapefile. When I type http://127.0.0.1/cgi-bin/mapserv.exe? map=/osgeo4w/apps/tutorial/htdocs/nira1.maplayer=roadsmode=map in the address bar in Firefox. I get an error message loadMap(): Web application error. CGI variable map is not set. What do I need to do get a working static map? -- View this message in context: http://n2.nabble.com/Help%2C-Error-Message%3A-CGI-variable-%22map%22-is-not-set.-tp2129226p2134229.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] website upgrade for older documentation
actually we just need to refer to old documentation for upgrading and porting, thanks though. if possible, we prefer something like http://www.mapserver.org/4.8/mapfile/map.html http://www.mapserver.org/5.2/mapfile/map.html much like http://www.postgresql.org/docs/8.1/interactive/sql-select.html http://www.postgresql.org/docs/8.1/static/sql-select.html http://www.postgresql.org/docs/8.2/interactive/sql-select.html http://www.postgresql.org/docs/8.2/static/sql-select.html On Thu, Jan 8, 2009 at 2:31 PM, Dan Little danlit...@yahoo.com wrote: Zach, Not trying to be a pushy guy... but is there a feature missing in 5.0 prevents you from upgrading? - Original Message From: zach cruise zachc1...@gmail.com To: Jeff McKenna jmcke...@gatewaygeomatics.com Cc: mapserver-users@lists.osgeo.org Sent: Thursday, January 8, 2009 12:31:26 PM Subject: Re: [mapserver-users] website upgrade for older documentation thanks. any way to search 4.8 documentation? any one got archived copy other than http://web.archive.org/web/20060701050731/http://mapserver.gis.umn.edu/? On Thu, Jan 8, 2009 at 12:21 PM, Jeff McKenna wrote: zach cruise wrote: On Wed, Jan 7, 2009 at 5:29 PM, zach cruise wrote: great website upgrade at http://www.mapserver.org/. how can i search for older documentation like with postgresql.org? The current (5.2.1) documents should have MapServer version references inside them for specific functionality (such as a specific mapfile parameter added in 5.0). -jeff -- Jeff McKenna FOSS4G 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 ___ 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] Imagemap size doesn't match display map
Soren, I think that you are running into the issue where a WMS request can return non-square pixels, and that the ratio of height:width in your extent is not the same as the ratio of height:width in your image size. If you can make this as a regular CGI call, you won't see this problem. If you need to use WMS, make sure that you make the ratio's the same. e.g. 500/275 does not equal 60/26. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of sscottgis Sent: Friday, January 09, 2009 12:48 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Imagemap size doesn't match display map I have created an imagemap/image for the lower 48 states using 2 mapfiles to define the polygons following the demo in the wiki. They noted that if you use separate maps, the SIZE and EXTENT should be the same. I have those set the same in both files, but the imagemap that gets returned is vertically squished. Here's the map file for the imagemap layer: MAP NAME droughtplan_imgmap STATUS ON SIZE 500 275 # set projection for map PROJECTION init=epsg:4326 END EXTENT -126 24 -66 50 UNITS METERS STATUS ON IMAGECOLOR 255 255 255 WEB IMAGEPATH e:/ms4w/tmp/ms_tmp/ IMAGEURL /ms_tmp/ END #QUERYMAP # STATUS ON # STYLE NORMAL #END LAYER NAME droughtplans_imgmap STATUS DEFAULT TYPE POLYGON DATA ../data/droughtplans_imgmap TEMPLATE planbody.html HEADER planheader.html FOOTER planfooter.html CLASSITEM State CLASS COLOR -1 -1 -1 NAME State OUTLINECOLOR 110 110 110 END END END END and the file for the display layer: MAP NAME droughtplan_wms STATUS ON SIZE 500 275 # set projection for map PROJECTION init=epsg:4326 END EXTENT -126 24 -66 50 UNITS METERS STATUS ON IMAGECOLOR 255 255 255 # image format OUTPUTFORMAT NAME png DRIVER GD/PNG MIMETYPE image/png IMAGEMODE RGB EXTENSION png END WEB IMAGEPATH e:/ms4w/tmp/ms_tmp/ IMAGEURL /ms_tmp/ HEADER ../templates/query_header.html FOOTER ../templates/query_footer.html END QUERYMAP STATUS ON STYLE NORMAL END LAYER NAME droughtplans STATUS DEFAULT TYPE POLYGON DATA ../data/droughtplans DUMP TRUE HEADER ../templates/ndmc_query_header.html TEMPLATE ../templates/ndmc_query_body.html CLASSITEM Status CLASS COLOR 255 255 255 OUTLINECOLOR 110 110 110 EXPRESSION 0 NAME No Plan SYMBOL 0 END CLASS COLOR 139 209 0 OUTLINECOLOR 110 110 110 EXPRESSION 1 NAME Emphasizing Mitigation SYMBOL 0 END CLASS COLOR 255 255 0 OUTLINECOLOR 110 110 110 EXPRESSION 2 NAME Emphasizing Response SYMBOL 0 END CLASS COLOR 255 128 0 OUTLINECOLOR 110 110 110 EXPRESSION 3 NAME Emphasizing Disaster SYMBOL 0 END CLASS COLOR 255 0 0 OUTLINECOLOR 110 110 110 EXPRESSION 4 NAME Local Plans SYMBOL 0 END END END END The header and footer are the basic map tags described in the wiki, but with the map height and width set to the 500, 275 dimensions from the files. Here's the body template: area shape=poly coords=[shpxy precision=0 proj=image] href=http://myserver/Resources/state.aspx?state=[State]; title=[State] alt=[State] and the call to the image layer (these are part of an ASP.NET 2.0 web page and added as part of an httprequest): http://myserver/cgi-bin/mapserv.exe?map=/ms4w/apps/drmon/service/drought plans_wms.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetMapLAYERS=droughtpla nsWIDTH=500HEIGHT=275srs=EPSG:4326styles=defaultformat=image/pngbb ox=-126,24,-66,50 I've got the extents and sizes set to the same 500, 275 dimensions everywhere, but the imagemap is still flattened (more like a box at 500 x 200). Everything else works fine--all of the areas are defined, the links work,etc; it just isn't aligned properly. Is there something missing or something else going on here? Any help/ideas are greatly appreciated. Soren -- View this message in context: http://n2.nabble.com/Imagemap-size-doesn%27t-match-display-map-tp2134663 p2134663.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list
[mapserver-users] on Mapserver and php5_MapScript
As I write this line is highlighted in black php5_MapScript code in mapfile LAYER NAMEPeru_dep DATAdepartamentos.shp STATUS ON TYPEPOLYGON CLASSITEM NOMB_DEP CLASS NAMELIMA *EXPRESSION /LIMA/* STYLE COLOR 200 150 2 OUTLINECOLOR0 0 0 END END y los quiero pasar a PHP version php coce // Creamos un Layer dentro de nuestro MapObj y seteamos sus propiedades $jLayer = ms_newLayerObj($jMap); $jLayer-set( name, Peru_dep); $jLayer-set( type, MS_LAYER_POLYGON); $jLayer-set( status, MS_ON); $jLayer-set( data, departamentos.shp); $jLayer-set( classitem, NOMB_DEP); //Creamos un classObj dentro del LayerObj $jClass = ms_newClassObj($jLayer); $jClass-set( name, LIMA); *$jClass-set( Expression, /LIMA/);* //Creamos un styleObj dentro del classObj $jStyle = ms_newStyleObj($jClass); $jStyle-color-setRGB(200, 150, 2); $jStyle-outlinecolor-setRGB(200, 200, 200); ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Path for errorfile
G'day Daniel, On 09/01/2009, at 10:47 PM, Daniel Morissette wrote: You are correct that relative paths are not supported for MS_ERRORFILE. You could file a ticket about this, and if/when time permits we'll look at the implications of supporting relative paths in all possible scenarios and see if this could safely be added. i.e. it may be possible to get predictable results with a relative path only when setting MS_ERRORFILE in the mapfile but not when setting it via an environment variable, we'll have to see. Thanks for the response, I have submitted it as a low priority enhancement (#2853), maybe just updating the documentation to clarify this point is enough for now. (Because I'm building on Mac OSX and deploying on FreeBSD, I'm a shameless user of relative references!) cheers Ben -- Ben Madin REMOTE INFORMATION t : +61 8 9192 5455 f : +61 8 9192 5535 m : 0448 887 220 Broome WA 6725 b...@remoteinformation.com.au Out here, it pays to know... ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Query result attribute sums / totals
G'day Richard, On 09/01/2009, at 10:30 PM, Richard Greenwood wrote: On Fri, Jan 9, 2009 at 12:51 AM, Ben Madin b...@remoteinformation.com.au wrote: However it would be really really great if the total Number over this time could be calculated as a total, and put in the footer row. You could easily calculate the sum with JavaScript in the browser. Declare a variable total and then for each row, within a JavaScript tag, something like: total += [Number] thank you - works perfectly! (and knowing this works opens up enormous opportunities for enhancing the output) cheers Ben -- Ben Madin REMOTE INFORMATION t : +61 8 9192 5455 f : +61 8 9192 5535 m : 0448 887 220 Broome WA 6725 b...@remoteinformation.com.au Out here, it pays to know... ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users