[mapserver-users] Need example of using a tabular select to retieve metadata for a label

[Basques, Bob (CI-StPaul)]

Steve,

Fuuny,  I already figured out that I (or mapserver) needs a spatial element as a return.  I thought about the Extent idea as well, and have been working on using a dummy point in a dummy table to get around it, but maybe the extent piece is the way to go, and it would be a good addition to the metadata anyway.  I can just add the City Bounds enmasse to begin with, and adjust as needed down the line.

bobb



On Aug 23, 2018, at 3:49 PM, Lime, Steve D (MNIT) <steve.lime at state.mn.us<mailto:steve.lime at state.mn.us>> wrote:

I think you’d have to associate geometries with the text regardless since MapServer will always apply a spatial filter (based on extent) in addition to whatever non-spatial filter you populate. I could see tying the extent of your project – either a rect or some fancy geometry to each bit of disclaimer text so the spatial filter would always evaluate to true. Might also be possible to use non-map coordinates. You see that typically with inline layers. I might have other ideas if you provided a bit more detail…

--Steve

From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Basques, Bob (CI-StPaul)
Sent: Thursday, August 23, 2018 10:58 AM
To: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: [mapserver-users] Need example of using a tabular select to retieve metadata for a label

I’m trying to use a tabular (no spatial field) SQL metadata call to populate a disclaimer notice in a image output.

Anyone tried this and have an example handy?

Thanks

bobb




I took a speed reading course and read ‘War and Peace’ in twenty minutes. It involves Russia.
—Woody Allen



The third-rate mind is only happy when it is thinking with the majority. The second-rate mind is only happy when it is thinking with the minority. The first-rate mind is only happy when it is thinking.
—A. A. Milne

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180823/8f527135/attachment.htm>