<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Mar 2, 2017, at 6:03 PM, Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com" class="">woodbri@swoodbridge.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">
<blockquote type="cite" class=""><br class="">
</blockquote>
</div>
</div>
</blockquote>
<div><br class="">
</div>
<br class="">
<blockquote type="cite" class="">
<div class="">
<div class=""><br class="">
What is you current sql that is not getting the features that cross the window?<br class="">
</div>
</div>
</blockquote>
<div><br class="">
</div>
Hi Steve,<br class="">
<div><br class="">
</div>
Right now I’m just using the regular WFS calling structure from MapServer:</div>
<div><br class="">
</div>
<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class="">
<div>DATA “wkb_geometry from cache.sprws_distribution_mains using unique ogc_fid"</div>
</blockquote>
<div><br class="">
</div>
<div>The end of the day yesterday I figured out a Crossing window select via psql that does return the lines that crossed the view port. That looks like this:</div>
<div><br class="">
</div>
<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class="">
<div>
<div>select </div>
</div>
<div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>* </div>
</div>
<div>
<div>from </div>
</div>
<div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>cache.sprws_distribution_mains </div>
</div>
<div>
<div>where</div>
</div>
<div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>ST_Crosses(ST_GeomFromText(‘POLYGON((576741 157601,576959 157601,576959 157601,576741 157750,576741 157601))’,200068), wkb_geometry)</div>
</div>
</blockquote>
<div class=""><br class="">
</div>
That is using the same BBOX values that are being passed in via the WFS call to the mapserver mapfile.<br class="">
<div>
<div><br class="">
</div>
<div>Problem there though, is now I need to pass in the WFS BBOX window to the custom select. It looks like if there is no vertex inside of the requested BBOX then the line feature is not output in the TEMPLATE. I’ll go through and test it all again to be
sure though.</div>
<div><br class="">
</div>
<div>bobb</div>
<div><br class="">
</div>
<div><br class="">
</div>
</div>
<div>
<blockquote type="cite" class="">
<div class="">
<div class=""><br class="">
I've never had a problem like that with mapserver, so I'm wondering how you are generating the problem.<br class="">
<br class="">
Mapserver has substition variable like !BBOX! or something like that which gets replaced with the BBOX of the window getting requested.<br class="">
<br class="">
geom from (select * from table where geom && !BBOX!) using ...<br class="">
<br class="">
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.<br class="">
<br class="">
-Steve W<br class="">
<br class="">
<br class="">
---<br class="">
This email has been checked for viruses by Avast antivirus software.<br class="">
<a href="https://www.avast.com/antivirus" class="">https://www.avast.com/antivirus</a><br class="">
<br class="">
_______________________________________________<br class="">
mapserver-users mailing list<br class="">
mapserver-users@lists.osgeo.org<br class="">
https://lists.osgeo.org/mailman/listinfo/mapserver-users</div>
</div>
</blockquote>
</div>
<br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="Apple-interchange-newline">
<br class="">
</div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<div class="wp_quotepage_quote">I took a speed reading course and read ‘War and Peace’ in twenty minutes. It involves Russia.</div>
<div class="wp_quotepage_author">—Woody Allen</div>
</div>
</div>
<br class="">
</body>
</html>