[mapserver-users] how to display datas selected from the combobox in map
hi, ia m newbie to fgs and i have created amap all i have to do is i want to display the name in my map when i selct the name from my combobox as it is already saved in the database will any help me out to overcome this problem any help appreciated thanks in advance syedmohseen ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Problems in making AGG outputformat for WMS
Hi, This MapServer version is 5.2.1 from MS4W, and it tells me for examle: MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG So it should support AGG rendering. Now I have created agg OUTPUTFORMAT about as adviced in http://www.mapserver.org/output/agg.html OUTPUTFORMAT NAME AGG MIMETYPE image/pngagg DRIVER AGG/PNG EXTENSION png IMAGEMODE RGB END However, this mimetype is not included in the WMS 1.1.1 GetCapabilities document GetMap Formatimage/gif/Format Formatimage/png/Format Formatimage/png; mode=24bit/Format If I edit OUTPUTFORMAT to have DRIVER GD/PNG then my own outputformat is included in GetCapabilies. GetMap Formatimage/pngagg/Format Formatimage/gif/Format Formatimage/png/Format Formatimage/png; mode=24bit/Format The problem is that AGG outputformat does not appear on the GetCapabilities and thus WMS clients can not show it on menu. If I edit WMS getMap request manually to use FORMAT=image/pngagg it works. For me this looks like a small bug. Is it perhaps reported already, or even corrected? -Jukka Rahkonen- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Perl mapscript installation problem
Hi, I've tried to install Perl Mapscript... i'm not familiar with perl in general. I've followed the instructions in the readme file and now i got this error when i try a script: Can't locate auto/mapscript/mapObj/swig_scale_.al in @INC (@INC contains: . /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread- multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl) at /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/mapscript.pm line 38 I'm using an OpenSuse. Thanks, Alan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Perl mapscript installation problem
What's the script look like? Alan Boudreault aboudrea...@mapgears.com 03/25/09 7:39 AM Hi, I've tried to install Perl Mapscript... i'm not familiar with perl in general. I've followed the instructions in the readme file and now i got this error when i try a script: Can't locate auto/mapscript/mapObj/swig_scale_.al in @INC (@INC contains: . /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread- multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl) at /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/mapscript.pm line 38 I'm using an OpenSuse. Thanks, Alan ___ 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] ogr connection to postgis problems
I am trying to test a connection to a postgis db using ogrinfo and am having difficulties. I am running the command on the same server that hosts the postgis db. I checked the pg_hba.config file to see if it allows local connections and everything looks OK but I still get Failure when connecting with ogr. Am I missing something? command ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle' pg_hba.conf # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket connections only local all all trust # IPv4 local connections: hostall all 127.0.0.1/32 trust # IPv6 local connections: hostall all ::1/128 trust hostall all 192.168.18.0/24 password -- Travis K. Toronto, Canada She knows there's no success like failure and that failure's no success at all. -Bob Dylan- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] ogr connection to postgis problems
Travis Kirstine wrote: I am trying to test a connection to a postgis db using ogrinfo and am having difficulties. I am running the command on the same server that hosts the postgis db. I checked the pg_hba.config file to see if it allows local connections and everything looks OK but I still get Failure when connecting with ogr. Am I missing something? command ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle' My thoughts: - since you are on the same server, use host=127.0.0.1 - include the port parameter (usually port=5432) -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
Re: [mapserver-users] ogr connection to postgis problems
Jeff McKenna wrote: Travis Kirstine wrote: I am trying to test a connection to a postgis db using ogrinfo and am having difficulties. I am running the command on the same server that hosts the postgis db. I checked the pg_hba.config file to see if it allows local connections and everything looks OK but I still get Failure when connecting with ogr. Am I missing something? command ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle' My thoughts: - since you are on the same server, use host=127.0.0.1 - include the port parameter (usually port=5432) Have you try from the command line: psql -h server34 -U bob earth psql -h localhost -U bob earth psql -U bob earth Should prompt you for the password. Only the last on will use the local socket or named pipe. If the last one works the try: ogrinfo -ro PG:'host= dbname=earth user=bob password=suruncle' ogrinfo -ro PG:'dbname=earth user=bob password=suruncle' and see if either of these work. -Steve W ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problems in making AGG outputformat for WMS
Hi There, It is a bug. ticket related to it is http://trac.osgeo.org/mapserver/ticket/2957 and should be available for the next MapServer release. Best Regards, Rahkonen Jukka wrote: Hi, This MapServer version is 5.2.1 from MS4W, and it tells me for examle: MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG So it should support AGG rendering. Now I have created agg OUTPUTFORMAT about as adviced in http://www.mapserver.org/output/agg.html OUTPUTFORMAT NAME AGG MIMETYPE image/pngagg DRIVER AGG/PNG EXTENSION png IMAGEMODE RGB END However, this mimetype is not included in the WMS 1.1.1 GetCapabilities document GetMap Formatimage/gif/Format Formatimage/png/Format Formatimage/png; mode=24bit/Format If I edit OUTPUTFORMAT to have DRIVER GD/PNG then my own outputformat is included in GetCapabilies. GetMap Formatimage/pngagg/Format Formatimage/gif/Format Formatimage/png/Format Formatimage/png; mode=24bit/Format The problem is that AGG outputformat does not appear on the GetCapabilities and thus WMS clients can not show it on menu. If I edit WMS getMap request manually to use FORMAT=image/pngagg it works. For me this looks like a small bug. Is it perhaps reported already, or even corrected? -Jukka Rahkonen- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Assefa Yewondwossen Software Analyst Email: ass...@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
[mapserver-users] WMS and transparent
I am trying to consume this WMS service with MapServer 5.0.2 as a client and would like to make the background transparent instead of white. Is this possible mapserver? I tried the wms_transparent true, but that didn't seem to work. Thanks for any suggestions. NAME '2003orthos' STATUS ON EXTENT 366751.468 5034450.028 882880.091 5434570.553 UNITS Meters SIZE 600 400 FONTSET '../fonts/fontset.list' SYMBOLSET '../symbols/symbol.sym' IMAGETYPE PNG24 TRANSPARENT TRUE WEB IMAGEURL E:\ms4w\tmp\ms_tmp IMAGEPATH E:\ms4w\tmp\ms_tmp END LAYER NAME ND03 TYPE RASTER OFFSITE 0 0 0 STATUS DEFAULT CONNECTIONTYPE WMS CONNECTION http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_aer ialimages? #MINSCALE 1000 # only display down to this scale #MAXSCALE 24000 METADATA wms_srs EPSG:26914 wms_name ND03 wms_server_version 1.1.1 wms_format image/jpeg wms_styles wms_exceptions application/vnd.ogc.se_inimage END END END End #Map Thanks, Brian ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] WMS and transparent
Hi, jpegs can not be transparent. Only if you switch to another image format like image/png. Best regards, Bart I am trying to consume this WMS service with MapServer 5.0.2 as a client and would like to make the background transparent instead of white. Is this possible mapserver? I tried the wms_transparent true, but that didn't seem to work. Thanks for any suggestions. NAME '2003orthos' STATUS ON EXTENT 366751.468 5034450.028 882880.091 5434570.553 UNITS Meters SIZE 600 400 FONTSET '../fonts/fontset.list' SYMBOLSET '../symbols/symbol.sym' IMAGETYPE PNG24 TRANSPARENT TRUE WEB IMAGEURL E:\ms4w\tmp\ms_tmp IMAGEPATH E:\ms4w\tmp\ms_tmp END LAYER NAME ND03 TYPE RASTER OFFSITE 0 0 0 STATUS DEFAULT CONNECTIONTYPE WMS CONNECTION http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_aer ialimages? #MINSCALE 1000 # only display down to this scale #MAXSCALE 24000 METADATA wms_srs EPSG:26914 wms_name ND03 wms_server_version 1.1.1 wms_format image/jpeg wms_styles wms_exceptions application/vnd.ogc.se_inimage END END END End #Map Thanks, Brian ___ 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] WMS and transparent
Yeah maybe OFFSITE can do this for you, give it a try, it works for normal rasters so why not for a WMS client layer (haven't tried though). Best regards, Bart Thanks for the reply. I was hoping maybe MapServer could consume that jpeg and set the white color to transparent, then mapserver would output a PNG that has transparency to the web client. Does the offsite parameter do this by chance or is there another trick that could be used? -Original Message- From: bart...@osgis.nl [mailto:bart...@osgis.nl] Sent: Wednesday, March 25, 2009 9:47 AM To: Fischer, Brian Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] WMS and transparent Hi, jpegs can not be transparent. Only if you switch to another image format like image/png. Best regards, Bart I am trying to consume this WMS service with MapServer 5.0.2 as a client and would like to make the background transparent instead of white. Is this possible mapserver? I tried the wms_transparent true, but that didn't seem to work. Thanks for any suggestions. NAME '2003orthos' STATUS ON EXTENT 366751.468 5034450.028 882880.091 5434570.553 UNITS Meters SIZE 600 400 FONTSET '../fonts/fontset.list' SYMBOLSET '../symbols/symbol.sym' IMAGETYPE PNG24 TRANSPARENT TRUE WEB IMAGEURL E:\ms4w\tmp\ms_tmp IMAGEPATH E:\ms4w\tmp\ms_tmp END LAYER NAME ND03 TYPE RASTER OFFSITE 0 0 0 STATUS DEFAULT CONNECTIONTYPE WMS CONNECTION http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_aer ialimages? #MINSCALE 1000 # only display down to this scale #MAXSCALE 24000 METADATA wms_srs EPSG:26914 wms_name ND03 wms_server_version 1.1.1 wms_format image/jpeg wms_styles wms_exceptions application/vnd.ogc.se_inimage END END END End #Map Thanks, Brian ___ 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] WMS and transparent
Hi, Or perhaps OFFSITE will have difficulties because jpeg compression makes totally black to almost black. If it works the result could still be only partially transparent image with some non-transparent pixels here and there. -Jukka Rahkonen- Bart wrote: Yeah maybe OFFSITE can do this for you, give it a try, it works for normal rasters so why not for a WMS client layer (haven't tried though). Best regards, Bart Thanks for the reply. I was hoping maybe MapServer could consume that jpeg and set the white color to transparent, then mapserver would output a PNG that has transparency to the web client. Does the offsite parameter do this by chance or is there another trick that could be used? -Original Message- From: bart...@osgis.nl [mailto:bart...@osgis.nl] Sent: Wednesday, March 25, 2009 9:47 AM To: Fischer, Brian Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] WMS and transparent Hi, jpegs can not be transparent. Only if you switch to another image format like image/png. Best regards, Bart I am trying to consume this WMS service with MapServer 5.0.2 as a client and would like to make the background transparent instead of white. Is this possible mapserver? I tried the wms_transparent true, but that didn't seem to work. Thanks for any suggestions. NAME '2003orthos' STATUS ON EXTENT 366751.468 5034450.028 882880.091 5434570.553 UNITS Meters SIZE 600 400 FONTSET '../fonts/fontset.list' SYMBOLSET '../symbols/symbol.sym' IMAGETYPE PNG24 TRANSPARENT TRUE WEB IMAGEURL E:\ms4w\tmp\ms_tmp IMAGEPATH E:\ms4w\tmp\ms_tmp END LAYER NAME ND03 TYPE RASTER OFFSITE 0 0 0 STATUS DEFAULT CONNECTIONTYPE WMS CONNECTION http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_a er ialimages? #MINSCALE 1000 # only display down to this scale #MAXSCALE 24000 METADATA wms_srs EPSG:26914 wms_name ND03 wms_server_version 1.1.1 wms_format image/jpeg wms_styles wms_exceptions application/vnd.ogc.se_inimage END END END End #Map Thanks, Brian ___ 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
[mapserver-users] Oracle Spatial Layer + C# map script
Hi I am using a oracle spatial layer which has roughly 100,000 features. When I call layerObj.getExtents() function, it takes a long time to return. This is the query sent to oracle by map server SELECT SDO_AGGR_MBR(GEOM) AS GEOM from (SELECT GEOM FROM ORSPTL.PARCELS) If I run the query in database, it takes long time to execute. Is there way to optimize this query to execute fast? Also, I see that layer extents are stored in USER_SDO_GEOM_METADATA table. Why is map server not querying against that. Thanks Murty ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Installation Problems
Hello, I am having problem installing mapserver which is as follows. I have already installed png,freetype and pthreads libraries. configuration with libpng,zlib and freetype was successfull. when i am trying to configure GD the error occured which is listed below for your reference. ** Configuration summary for gd 2.0.35: Support for PNG library: yes Support for JPEG library: no Support for Freetype 2.x library: yes Support for Fontconfig library: no Support for Xpm library: no Support for pthreads: yes configure: creating ./config.status config.status: creating Makefile config.status: creating config/Makefile config.status: creating config/gdlib-config config.status: creating test/Makefile config.status: creating config.h config.status: config.h is unchanged config.status: executing depfiles commands I have also tried installing the rpm library and it says cannot create transaction lock control and also when i am trying to query the installed rpm libraries with rpm -qa, in that list i can find all the required libraries installed. Kindly help me in this regard. Regards Praveen ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] ogr connection to postgis problems
2009/3/25 Stephen Woodbridge wood...@swoodbridge.com: Jeff McKenna wrote: Travis Kirstine wrote: I am trying to test a connection to a postgis db using ogrinfo and am having difficulties. I am running the command on the same server that hosts the postgis db. I checked the pg_hba.config file to see if it allows local connections and everything looks OK but I still get Failure when connecting with ogr. Am I missing something? command ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle' My thoughts: - since you are on the same server, use host=127.0.0.1 - include the port parameter (usually port=5432) Have you try from the command line: psql -h server34 -U bob earth psql -h localhost -U bob earth psql -U bob earth Should prompt you for the password. Only the last on will use the local socket or named pipe. If the last one works the try: ogrinfo -ro PG:'host= dbname=earth user=bob password=suruncle' ogrinfo -ro PG:'dbname=earth user=bob password=suruncle' and see if either of these work. I got the query / connection to work, it seems that the -ro flag was causing the problem which is strange. this works ogrinfo -sql 'SELECT * FROM counties' PG:'host= dbname=earth user=bob password=suruncle' this dosen't ogrinfo -ro -sql 'SELECT * FROM counties' PG:'host= dbname=earth user=bob password=suruncle' I'm not sure what the problem is as the user bob has su privileges List of roles Role name | Superuser | Create role | Create DB | Connections | Member of ---+---+-+---+-+--- postgres | yes | yes | yes | no limit| bob | yes | no | yes | no limit| -- Travis K. Toronto, Canada She knows there's no success like failure and that failure's no success at all. -Bob Dylan- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] ogr connection to postgis problems
Travis, this is really weird. I've reviewed a bit the source of the PG driver and the influence of the read-only mode vs update mode is very thin. The only behavioural differences are : 1) the result of TestCapabilities() method depend on it, but ogrinfo doesn't request layer TestCapabilities(). 2) if the PG database has no valid tables (for OGR), its opening will fail in read-only mode, whereas it would succeed in update mode. So in your use case, provided that there's at least one table reported by ogrinfo in update mode, I don't understand why it fails. What's the version of GDAL/OGR you're using ? Le Wednesday 25 March 2009 19:51:39 Travis Kirstine, vous avez écrit : 2009/3/25 Stephen Woodbridge wood...@swoodbridge.com: Jeff McKenna wrote: Travis Kirstine wrote: I am trying to test a connection to a postgis db using ogrinfo and am having difficulties. I am running the command on the same server that hosts the postgis db. I checked the pg_hba.config file to see if it allows local connections and everything looks OK but I still get Failure when connecting with ogr. Am I missing something? command ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle' My thoughts: - since you are on the same server, use host=127.0.0.1 - include the port parameter (usually port=5432) Have you try from the command line: psql -h server34 -U bob earth psql -h localhost -U bob earth psql -U bob earth Should prompt you for the password. Only the last on will use the local socket or named pipe. If the last one works the try: ogrinfo -ro PG:'host= dbname=earth user=bob password=suruncle' ogrinfo -ro PG:'dbname=earth user=bob password=suruncle' and see if either of these work. I got the query / connection to work, it seems that the -ro flag was causing the problem which is strange. this works ogrinfo -sql 'SELECT * FROM counties' PG:'host= dbname=earth user=bob password=suruncle' this dosen't ogrinfo -ro -sql 'SELECT * FROM counties' PG:'host= dbname=earth user=bob password=suruncle' I'm not sure what the problem is as the user bob has su privileges List of roles Role name | Superuser | Create role | Create DB | Connections | Member of ---+---+-+---+-+--- postgres | yes | yes | yes | no limit| bob | yes | no | yes | no limit| ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] msOGRFileNextShape(): OGR error. TopologyException: side location conflict
Hi All, I've found this issue when drawing a map with MapServer in a certain view. By setting the center to a slightly different position the problem disappears and the map is drawn correctly. msDrawMap(): Image handling error. Failed to draw layer named 'MainStreet'.;msOGRFileNextShape(): OGR error. TopologyException: side location conflict 19.0499 47.5334 1.7e-308 Does anyone know where this error is coming from? I've seached for these strings in the MapServer and OGR code but didn't find any hit. Best regards, Tamas ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Move point symbols (water valves) along a line (waterline) depending on scale
I have a point shapefile representing gate valves for waterlines and some of the gate valves are very close to each other and you may or may not be able to view them depending on scale. Is there a way to have MapServer automatically adjust point symbols (water valves) along a line (waterline) so the points are displayed at any scale? ArcGIS does this with a tool called cartographic representation. -- View this message in context: http://n2.nabble.com/Move-point-symbols-%28water-valves%29-along-a-line-%28waterline%29-depending-on-scale-tp2536075p2536075.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] nquery against mysql is ignoring 1 row from resultset
I need help figuring out why mapserver is ignoring one row from my resultset. Ive attached all of the necessary files. testdata.sql - sql commands to setup a simple mysql table with some test data test.map - my mapfile test.ovf - the ogr/mysql file testmap.html - the html template file out.html - the resulting html output my output, out.html, should be an html imagemap with 4 'areas'that match the 4 rows in my db table, but only three areas are being created. mapserver is correctly drawing 4 symbols for the 4 rows in my database table, but it misses the 2nd row in the output when parsing the [featureset][/featureset] sections of the html template file. Can anyone reproduce this problem? Im running the latest version of mapserver on linux, built from source. Please help, Thanks P.Romero _ Internet Explorer 8 – Now Available. Faster, safer, easier. http://clk.atdmt.com/MRT/go/141323790/direct/01/Title: Simple Template For Imagemaps Title: Simple Template For Imagemaps [resultset layer=mypoints] [feature] [/feature] [/resultset] # example map file for creating image maps with mapserver MAP NAME 'basic' SIZE 600 600 EXTENT -100 10 -60 30 IMAGECOLOR 167 200 255 SHAPEPATH /data/shp UNITS DD PROJECTION init=epsg:4326 END IMAGETYPE AGG OUTPUTFORMAT NAME 'AGG' DRIVER AGG/PNG IMAGEMODE RGB END OUTPUTFORMAT NAME 'html' DRIVER 'TEMPLATE' MIMETYPE 'text/html' FORMATOPTION 'FILE=/data/www/html/test/testmap.html' END QUERYMAP STATUS ON STYLE NORMAL END WEB QUERYFORMAT 'html' END WEB IMAGEPATH /tmp/ IMAGEURL /tmp/ MAXSCALE 1550 END LAYER NAME mypoints STATUS DEFAULT CONNECTIONTYPE OGR CONNECTION test.ovf DATA mypoints TYPE POINT TEMPLATE /data/www/html/test/testmap.html CLASS NAME None STYLE SYMBOL 'circle' SIZE 14 COLOR 0 255 0 END END END # Symbols ### SYMBOL NAME 'circle' TYPE ELLIPSE POINTS 1 1 END FILLED TRUE END ENDOGRVRTDataSource OGRVRTLayer name=mypoints SrcDataSourceMYSQL:surf,user=root,password='',host=localhost,port=3306,tables=testdata/SrcDataSource SrcSQLSELECT * FROM surf.testdata order by id asc/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=lng y=lat/ /OGRVRTLayer /OGRVRTDataSource-- phpMyAdmin SQL Dump -- version 3.1.3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 25, 2009 at 11:35 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO; -- -- Database: `surf` -- -- -- -- Table structure for table `testdata` -- CREATE TABLE IF NOT EXISTS `testdata` ( `id` int(11) NOT NULL auto_increment, `name` char(10) NOT NULL, `lat` double NOT NULL, `lng` double NOT NULL, `angl` double NOT NULL, `val1` double NOT NULL, `val2` double NOT NULL, `val3` double NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `testdata` -- INSERT INTO `testdata` (`id`, `name`, `lat`, `lng`, `angl`, `val1`, `val2`, `val3`) VALUES (1, 'test1', 21.25, -86.75, 190, 20.5, 12, 5), (2, 'test2', 30.5, -80.3, 50, 12, 5, 2), (3, 'test3', 27, -95, 33, 3365, 4, 3), (4, 'test4', 17, -90, 15, 74, 4, 6); ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users