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

2018-08-23 Thread Basques, Bob (CI-StPaul)
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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2018-08-23 Thread Lime, Steve D (MNIT)
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-boun...@lists.osgeo.org] On 
Behalf Of Basques, Bob (CI-StPaul)
Sent: Thursday, August 23, 2018 10:58 AM
To: mapserver-users@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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2018-08-23 Thread 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) 
mailto:steve.l...@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-boun...@lists.osgeo.org] On 
Behalf Of Basques, Bob (CI-StPaul)
Sent: Thursday, August 23, 2018 10:58 AM
To: mapserver-users@lists.osgeo.org<mailto:mapserver-users@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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users