Another option would be to use the csv ogr driver and set the outputformat http://mapserver.org/output/ogr_output.html
Mike ---- Michael Smith US Army Corps Remote Sensing GIS/Center [email protected] -----Original Message----- From: <[email protected]> on behalf of Matej Mailing <[email protected]> Date: Tuesday, September 8, 2015 at 8:03 PM To: "Lime, Steve D (MNIT)" <[email protected]> Cc: "[email protected]" <[email protected]> Subject: Re: [mapserver-users] CSV from Mapscript results >Thanks, Steve. > >It looks I will choose the 2nd option as well. What I don't like with >this "direct" approach though is not using already existing Mapfile >with DATA, CONNECTION and everything set - basically it creates >another point where this data needs to be set and changed for example >when changing access rights, moving data to new server etc., it >increases complexity. > >As far as I have checked, there is no for example getData() method to >get the DATA variable, set in the Mapfile. (Perhaps the reason is that >since there is no set, there is no get method as well :-)) >However, in this case this would be useful or perhaps I am just >thinking in the wrong direction? :-) > >Thanks, >Matej > > >2015-09-08 18:07 GMT+02:00 Lime, Steve D (MNIT) <[email protected]>: >> You have two options: >> >> 1 - use query templates to render the result as CSV >> 2 - use whatever tool your programming language gives you and just >>loop through the results and dump to CSV >> >> Personally since you're using MapScript I'd opt for 2 for a couple of >>reasons: you have total control that way and for larger result sets it's >>likely to be more performant since the whole CSV file wouldn't need to >>be constructed in memory like templates would. >> >> Steve >> >> -----Original Message----- >> From: [email protected] >>[mailto:[email protected]] On Behalf Of Matej >>Mailing >> Sent: Tuesday, September 08, 2015 5:30 AM >> To: [email protected] >> Subject: [mapserver-users] CSV from Mapscript results >> >> Hi, >> >> what would be the best way to create a CSV from Mapscript query results? >> >> Thanks, >> Matej >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >_______________________________________________ >mapserver-users mailing list >[email protected] >http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
