On Mar 2, 2017, at 6:03 PM, Stephen Woodbridge <[email protected]<mailto:[email protected]>> wrote:
What is you current sql that is not getting the features that cross the window? Hi Steve, Right now I’m just using the regular WFS calling structure from MapServer: DATA “wkb_geometry from cache.sprws_distribution_mains using unique ogc_fid" 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: select * from cache.sprws_distribution_mains where ST_Crosses(ST_GeomFromText(‘POLYGON((576741 157601,576959 157601,576959 157601,576741 157750,576741 157601))’,200068), wkb_geometry) That is using the same BBOX values that are being passed in via the WFS call to the mapserver mapfile. 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. bobb 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 _______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users I took a speed reading course and read ‘War and Peace’ in twenty minutes. It involves Russia. —Woody Allen
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
