Re: [mapserver-users] date format?
Hi David, a belated thank you for this tip - I didn't think of trying to do it in the select statement. For the record here is the syntax I used: SELECT DATE_FORMAT(My_DATE_FieldName,'%W %M %D, %Y') ... etc. produces a nice date like: Monday September 20th, 2004 thanks again, Sacha On Wed, Jul 30, 2008 at 1:13 PM, Fawcett, David <[EMAIL PROTECTED]> wrote: > Have you tried using a date format function in your SQL statement? > http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#func > tion_date-format > > David. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Sacha > Black > Sent: Wednesday, July 30, 2008 3:07 PM > To: mapserver-users@lists.osgeo.org > Subject: Re: [mapserver-users] date format? > > > I've got point data in a MySQL database that I am displaying in my map. > I'd like to label the points with a date, but the date format stored in > the database looks like this: > > "2008-06-17 00:00:00" > > and we would like to put a label on the map in some kind of more user > friendly format (and omitting the time portion which we do not need) > is this kind of re-formatting for labels possible in Mapserver? Prefer > not to create a new field in the DB as there are thousands of records... > > any ideas? > > sacha > > > Fri May 9 09:53:29 EDT 2008 > > Hi list, > > using a shapefile with a Date column, is it possible to change the date > format (string) that Mapserver will use in the WFS GetFeature output? > > Now it outputs: > > 19690101 > > whereas we would want 1969-01-01 > > Best regards, > Bart > ___ > 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] date format?
I've got point data in a MySQL database that I am displaying in my map. I'd like to label the points with a date, but the date format stored in the database looks like this: "2008-06-17 00:00:00" and we would like to put a label on the map in some kind of more user friendly format (and omitting the time portion which we do not need) is this kind of re-formatting for labels possible in Mapserver? Prefer not to create a new field in the DB as there are thousands of records... any ideas? sacha Fri May 9 09:53:29 EDT 2008 Hi list, using a shapefile with a Date column, is it possible to change the date format (string) that Mapserver will use in the WFS GetFeature output? Now it outputs: 19690101 whereas we would want 1969-01-01 Best regards, Bart ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Mapscript Legend question
after some flailing, was able to answer my own question: $oMap->legend->imagecolor->setRGB(0,255,0); will override the mapfile and turn the legend backgound green. sacha On Wed, Mar 26, 2008 at 5:51 PM, Sacha Black <[EMAIL PROTECTED]> wrote: > hi list, > > right now I do this to get a legend from my map file: > > $oImg=$oMap->drawLegend(); > $oImg->saveImage($szImg.'_legend',$oMap); > copy($szImg.'_legend', $szImg.'_legend.png'); > $legendW = $oImg->width; > $legendH = $oImg->height; > $oImg->free(); > > my question is: is it possible to request the basic legend with a > different background color than the background color specified in the > mapfile? better yet, is there a way to specify that the background is > transparent ? > > thanks for any suggestions, > > sacha > > [apologies if this is a very basic mapscript question, but i couldn't > find the answer I was looking for when I searched.] > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapscript Legend question
hi list, right now I do this to get a legend from my map file: $oImg=$oMap->drawLegend(); $oImg->saveImage($szImg.'_legend',$oMap); copy($szImg.'_legend', $szImg.'_legend.png'); $legendW = $oImg->width; $legendH = $oImg->height; $oImg->free(); my question is: is it possible to request the basic legend with a different background color than the background color specified in the mapfile? better yet, is there a way to specify that the background is transparent ? thanks for any suggestions, sacha [apologies if this is a very basic mapscript question, but i couldn't find the answer I was looking for when I searched.] ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Icon as Inline feature (Annotation layer)
thanks Steve - that did the trick. sb On Wed, Mar 12, 2008 at 4:14 PM, Stephen Woodbridge <[EMAIL PROTECTED]> wrote: > Sacha, > > You nned to add a color to the CLASS so it will render. COLOR 0 0 0 > will work fine as and it is not used but mapserv will not runder the > layer without a COLOR tag. > > -Steve W > > > > Sacha Black wrote: > > hi, > > > > is use of a PIXMAP icon as an inline feature possible? I just want to > > drop an icon in the center of my map. > > > > I thought that something like the below would work, but I don't seem > > to get anything to draw (in the middle of a 500x500 image). Am I > > missing something very basic, or is this just a wrong idea? > > > > sacha > > > > > > -fwd--> > > > > Symbol > >name 'red_star' > > TYPE PIXMAP > > IMAGE "symbols\star.gif" > > end > > > > > > LAYER > > NAME my_star > > TYPE annotation > > STATUS ON > > TRANSFORM false > > FEATURE > > POINTS 250 250 END > > TEXT ' ' > > END > > CLASS > > STYLE > >SYMBOL 'red_star' > > END > > LABEL > > TYPE TRUETYPE > > FONT Sans > > SIZE 8 > > COLOR 0 0 255 > > OUTLINECOLOR 255 255 255 > > POSITION UR > > END > > END > > END > > ___ > > 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] Icon as Inline feature (Annotation layer)
hi, is use of a PIXMAP icon as an inline feature possible? I just want to drop an icon in the center of my map. I thought that something like the below would work, but I don't seem to get anything to draw (in the middle of a 500x500 image). Am I missing something very basic, or is this just a wrong idea? sacha -fwd--> Symbol name 'red_star' TYPE PIXMAP IMAGE "symbols\star.gif" end LAYER NAME my_star TYPE annotation STATUS ON TRANSFORM false FEATURE POINTS 250 250 END TEXT ' ' END CLASS STYLE SYMBOL 'red_star' END LABEL TYPE TRUETYPE FONT Sans SIZE 8 COLOR 0 0 255 OUTLINECOLOR 255 255 255 POSITION UR END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [MAPSERVER-USERS] Tile4ms pre-cached images loses quality
Ambastha, are you also trying to use AGG here ? with tile.php? if so you might be affected by this discussion / solution from the Ka-Map list: http://www.nabble.com/Ka-map-and-AGG-%2B-AlphaSolved-%28need-confirm%29-to15973299.html Sacha On Tue, Mar 11, 2008 at 8:51 PM, riteshambastha <[EMAIL PROTECTED]> wrote: > > Dear Mapserver Geniuses, > > I have used pre-caching script for my ka-map based map. The pre-cached > images doesn't retain the same quality compared to on-the-fly generation of > images. I am using png24 outputformat. Is it true that the tiled pre-cached > images normally lose their quality? Is there any solution for solving this > issue? > > Your suggestions will be highly appreciated. > > Regards, > Ambastha > -- > View this message in context: > http://www.nabble.com/Tile4ms-pre-cached-images-loses-quality-tp15997333p15997333.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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
