[mapserver-users] sql clause in DATA
Rahkonen Jukka
jukka.rahkonen at mmmtike.fi
Sat Jul 13 04:06:12 PDT 2013
Hi,
Sure, like this
CONNECTIONTYPE POSTGIS
CONNECTION "host=localhost dbname=postgis user=www-data password=www-data port=5432"
DATA "way from (select way,osm_id ,landuse, name from osm_polygon where landuse is not null) as foo using unique osm_id using srid=3857"
Even better, this is documented
http://mapserver.org/input/vector/postgis.html
-Jukka Rahkonen-
________________________________
Ahmet Temiz wrote:
hello
Is there any way to insert a sql query into a connection string as:
DATA 'PG: dbname=tr2 host=localhost ...
I want to manipulate ms - layer changing data line using java mapscript .
regards
--
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Planlama ve Zarar Azaltma Dairesi Başkanlığı
________________________
Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
More information about the MapServer-users
mailing list