Re: [mapserver-users] Retrieve function values from Postgres

2012-12-13 Thread Stephen Woodbridge 


DATA "the_geom from (select * from get_aerosol_data('gas_db', 25.5, 
'2005-3-2 00:00', '2006-3-5 00:00') ) as foo using unique gid using 
srid=4326"


Here is a link that might help:

http://mapserver.org/input/vector/postgis.html

-Steve W

On 12/13/2012 3:24 PM, Lime, Steve D (DNR) wrote:

I believe anything you can stuff in a DATA statement using SQL is legitimate.


From: mapserver-users-boun...@lists.osgeo.org 
[mapserver-users-boun...@lists.osgeo.org] on behalf of Heiko Schröter 
[schro...@iup.physik.uni-bremen.de]
Sent: Tuesday, December 11, 2012 6:13 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Retrieve function  values from Postgres

Hello,

is it possible for mapserver to question a function in a postgres geo
database ?
i.e. this query string inside postgres  works:
"select * from get_aerosol_data('gas_db', 25.5, '2005-3-2 00:00',
'2006-3-5 00:00');"

If it is possible how to translate this into mapserver mapfile syntax ?

Thanks and Regards
Heiko


/mdraid/www/localhost/mapserver/mapserv -v
MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML
SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
SUPPORTS=FASTCGI INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
___
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] Retrieve function values from Postgres

2012-12-13 Thread Lime, Steve D (DNR) 
I believe anything you can stuff in a DATA statement using SQL is legitimate. 


From: mapserver-users-boun...@lists.osgeo.org 
[mapserver-users-boun...@lists.osgeo.org] on behalf of Heiko Schröter 
[schro...@iup.physik.uni-bremen.de]
Sent: Tuesday, December 11, 2012 6:13 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Retrieve function  values from Postgres

Hello,

is it possible for mapserver to question a function in a postgres geo
database ?
i.e. this query string inside postgres  works:
"select * from get_aerosol_data('gas_db', 25.5, '2005-3-2 00:00',
'2006-3-5 00:00');"

If it is possible how to translate this into mapserver mapfile syntax ?

Thanks and Regards
Heiko


/mdraid/www/localhost/mapserver/mapserv -v
MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML
SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
SUPPORTS=FASTCGI INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
___
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] Retrieve function values from Postgres

2012-12-11 Thread Heiko Schröter 

Hello,

is it possible for mapserver to question a function in a postgres geo 
database ?

i.e. this query string inside postgres  works:
"select * from get_aerosol_data('gas_db', 25.5, '2005-3-2 00:00', 
'2006-3-5 00:00');"


If it is possible how to translate this into mapserver mapfile syntax ?

Thanks and Regards
Heiko


/mdraid/www/localhost/mapserver/mapserv -v
MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML 
SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER 
SUPPORTS=FASTCGI INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users