[mapserver-users] Postgres call 2 GetCapabilities attribute listing.

[Jeff McKenna]

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
>> <jmckenna at gatewaygeomatics.com <mailto:jmckenna at gatewaygeomatics.com>>
>> 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
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>