Hi,
Personally I would advice to use FILTER for that. FILTER is passed directly to
the PostGIS DB as Part of the SQL WHERE and this way you can distinct more
easily between "FROM" (DATA) and "WHERE" (FILTER).
For example in combination with OSM one can re-use the DATA for different road
categories and distinct which objects to load via FILTER (e.g. FILTER "type in
('primarily', 'primarily_link')" ).
________________________________
Gregor Karzelek
Systemarchitekt
HELLER Ingenieurgesellschaft mbH
Otto-Hesse-Straße 19 / T3
64293 Darmstadt
Tel.: +49 6151 66846-16<tel:+49%206151%2066846-16>
Fax: +49 6151 66846-22<tel:+49%206151%2066846-22>
E-Mail: [email protected]<mailto:[email protected]>
Internet: www.heller-ig.com<http://www.heller-ig.com/>
Geschäftsführer: Dipl.-Ing. Henning Balck, Dipl.-Ing. Christian Komma
Handelsregister: Amtsgericht Darmstadt HRB 8310
Ust.-Ident.-Nr.: DE 217 293 137<tel:217%20293%20137>
Am 07.02.2014 um 16:51 schrieb "Travis Kirstine"
<[email protected]<mailto:[email protected]>>:
What is the best practice for using selecting data with a where clause in
MapServer using PostGIS connection
i.e.
DATA "the_geom from (SELECT gid, the_geom FROM audience_table WHERE audience =
'Farmers') as foo using unique gid using SRID=4326"
OR
DATA "the_geom from audience_table using SRID=4326"
with a class expression
CLASSITEM audience
....
EXPRESSION 'Farmer'
Thanks
_______________________________________________
mapserver-users mailing list
[email protected]<mailto:[email protected]>
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
