[mapserver-users] Another related SHPXY question, about Crossing window vs within for TEMPLATED output.

[Stephen Woodbridge]

On 3/2/2017 5:20 PM, Basques, Bob (CI-StPaul) wrote:
> All,
>
> So, I’ve got my cool LISP output template working nicely.  I even have
> more than one Layer working from a single Template, but, I just
> discovered that if a line does not originate or terminate inside of my
> BBOX of interest, then it’s not considered part of the result set.
>
> The question is (and I bet this is going to be related to my datasource,
> which is Postgres) is there a over-ride that can be used in MapServer
> for grabbing from the Postgres service based on a crossing window vs a
> within (features completely within) the window of interest?  A slighting
> related piece would also be, would I get a clipped feature, or the real
> feature no matter where the BEGIN/END nodes were located?
>
> I think I can modify the SQL in the connection to do the crossing
> window, so I’m not out completely here.

What is you current sql that is not getting the features that cross the 
window?

I've never had a problem like that with mapserver, so I'm wondering how 
you are generating the problem.

Mapserver has substition variable like !BBOX! or something like that 
which gets replaced with the BBOX of the window getting requested.

geom from (select * from table where geom && !BBOX!) using ...

I don't remember the exact syntax off the top of my head, but give me a 
shout if you can't figure it out.

-Steve W


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus