Steve, Yeah, my poison is Perl. Was just trying to make it simpler is all.
I have a few services already in place like this. A separate service it is then . . . bobb On Jul 11, 2017, at 1:06 PM, Stephen Woodbridge <[email protected]<mailto:[email protected]>> wrote: Bobb, If you using sql you can do this in one pass, just write a trivial php script that returns an image. 1. connect to db 2. sql to query expanded bbox of parcel select st_astext(st_extent(st_expand(geom, delta))) from parcels where pin=? 3. create url to mapserver based on bbox and image size 5. header('Content-type: image/png'); 4. passthru(url); Don't make it more complicated than it needs to be. You can do the same using perl, python, script language of your choice. -Steve On 7/11/2017 12:22 PM, Basques, Bob (CI-StPaul) wrote: Hi Steve, I want to send a CGI request like : ServerName?pin=202923230045 And zoom to the pin (parcel polygon) in the returned image and also add a buffer percentage. This is for a reporting application. I can do it with an intermediate service, but it’s been awhile since I did this, and was wondering if anything new in MapServer might help with this for a single pass approach. The zoom parameters would be hardcoded into the MapFILE in an ideal world, I can build an SQL for this for example, but I recall I couldn’t use the BBOX returned from the SQL as a BBOX for Mapserver parent call, my memory is cloudy on that capability from MapServer though, hence the question. Now that you have me talking it through though, I think the last time I asked about this it was to inquire about possibly chaining more than one MapServer call together to get the result. I think there were fears at the time about possible runaway processes being created . . . . bobb On Jul 11, 2017, at 10:38 AM, Stephen Woodbridge <[email protected]<mailto:[email protected]> <mailto:[email protected]>> wrote: On 7/11/2017 10:39 AM, Basques, Bob (CI-StPaul) wrote: All, It’s probably because it’s Tues. but I think I’ve asked this before in the past . . . I have a DB with PIN numbers for PARCELS and I want to be able to auto-zoom(with buffer) to a PARCEL by just sending in a PIN number via CGI. can the BBOX be pulled from the DB based on the geom in one shot? I’ve done this in the past with a Webservice that went and grabbed the BBOX separately, then assembled the url for getting the graphic back from Mapserver. Bobb, What are you trying to zoom? the image or the client? If it is the client then how is mapserver on the server supposed to tell the client it needs to zoom? You have to query the server to get the bbox then make the client zoom appropriately. For the image, assuming you want a static image showing the parcel, then I would write a php/python/perl script the you pass the PIN to and it does the work to figure out the extents and return the image. -Steve W --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus _______________________________________________ mapserver-users mailing list [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/mapserver-users "If you're going through hell, keep going. “ - Winston Churchill "Be nice to people on your way up because you meet them on your way down." - Jimmy Durante _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/mapserver-users “There is nothing quite so useless as doing with great efficiency something that should not be done at all.” - Peter Drucker
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
