You could also generate a GetFeatureInfo call and parse the
attributes/columns returned with JavaScript or some JavaScript framework
I imagine.
Anyway yes it sounds like you know the way forward.
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
On 2017-01-10 1:11 PM, Basques, Bob (CI-StPaul) wrote:
Hi Jeff,
PHP = Yucky!!
I was trying to go the route of all OGC calls. The idea is to possibly
expand on the options for configuring GeoMOOSE, where you would be able
to configure a filtering process on a layer by layer basis. I know I
can make it all work by hardcoding things. It’s just that the data is
variable from the database (as it should be) and I wanted to be able to
populate the distinct list upon query vs hardcoding it.
The SLD path might be the best “OGC” based approach, but it end up as a
two stage query this way. I’m still investigating things. Maybe I
should just hardcode for the first pass and try some different
approaches after the fact. Hmm, a thought, I could use a Template
populated from a SQL call for the list, but it’s not OGC anymore . . .
I have many potential uses for this on a layer by layer basis.
Thanks for the response.
bobb
On Jan 10, 2017, at 10:50 AM, Jeff McKenna
<[email protected] <mailto:[email protected]>>
wrote:
Hi Bob,
I personally think you are over-complicating this: if you have full
access to the PG instance, it's easiest to have your form submit a
short PHP script (mapscript isn't even needed) that executes a
"pg_query" returning your distinct column names.
That's the easiest way.
If you must stick with WMS etc, you could use a mapscript wrapper to
capture something like a GetFeatureInfo request (that lists all
attributes) and populate your form (see wrapper doc
http://mapserver.org/ogc/mapscript.html).
But if this was me I would create a short pg_query script.
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
On 2017-01-10 11:52 AM, Basques, Bob (CI-StPaul) wrote:
All,
Anyone have an example of how to set up a postgres call in mapfile that
is used to output a GetCapabilities attribute listing? I think I said
that correctly. :c)
I have a layer set up as a WMS service from Postgres, I want to provide
a GetCapabilities result for a “select distinct column” call to populate
a layering filtering form. Is this even a WMS thing?
I anticipate that this particular set of unqiue values will be added to
over time in the database and thus without my knowing it. I think I
could generate a SLD on the fly with the list as a call result, but that
seems overly complicated for some reason.
Maybe this is a DescribeLayer function?? Or do I need to move to a WFS
service?
Thanks
bobb
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
