<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1456514555526_43141">Hi Dave,</div><div id="yui_3_16_0_1_1456514555526_43107"><br></div><div dir="ltr" id="yui_3_16_0_1_1456514555526_43108">If you don't require any desktop mapping, just a web accessible spatial overlay operation, I'd have thought using Postgis to store your polygon layer(s) & to carry out the overlay operation, then return the txt file would be simpler & easier, via any sort of scripted web interface.<br></div><div id="yui_3_16_0_1_1456514555526_43104"><br><span></span></div><div id="yui_3_16_0_1_1456514555526_43247" dir="ltr">the sqls for the overlay to return the text file could just about be as simple as:</div><div id="yui_3_16_0_1_1456514555526_43325" dir="ltr"><br></div><div id="yui_3_16_0_1_1456514555526_43370" dir="ltr"><i>copy feature from txtfile;<br></i></div><div id="yui_3_16_0_1_1456514555526_43252" dir="ltr"><i>select f.id, f.lat, f.lon, p.id <br></i></div><div id="yui_3_16_0_1_1456514555526_43404" dir="ltr"><i> from polygon p, feature f <br></i></div><div id="yui_3_16_0_1_1456514555526_44669" dir="ltr"><i id="yui_3_16_0_1_1456514555526_44732"> where ST_Contains(p.poly, ST_SetSRID(ST_Makepoint(f.lon, f.lat),4326));<br><span></span></i></div><div id="yui_3_16_0_1_1456514555526_43250"><i>drop feature;</i><br><span></span></div><div id="yui_3_16_0_1_1456514555526_43251"><br><span></span></div><div id="yui_3_16_0_1_1456514555526_44670">The first loads the text file into a database table - at potentially 10,000's per second...<br></div><div id="yui_3_16_0_1_1456514555526_44672"><br><span></span></div><div id="yui_3_16_0_1_1456514555526_44674">The second creates a point geometry from the point coordinates, sets the coordinate reference system for this to lat/long, and returns the point values as well as those of any polygon on your polygon dataset which the point lies within.<br><span></span></div><div id="yui_3_16_0_1_1456514555526_44720"><br></div><div id="yui_3_16_0_1_1456514555526_44721">The point table is then deleted.<br><span></span></div><div id="yui_3_16_0_1_1456514555526_44676"><br><span></span></div><div id="yui_3_16_0_1_1456514555526_44722">You just need to wrap this up in your preferred scripting language to make it web accessible.</div><div id="yui_3_16_0_1_1456514555526_44751"><br></div><div id="yui_3_16_0_1_1456514555526_44752" dir="ltr">HTH,<br><span></span></div><div id="yui_3_16_0_1_1456514555526_44753"><br><span></span></div><div id="yui_3_16_0_1_1456514555526_44754"><span></span></div><div id="yui_3_16_0_1_1456514555526_43106" class="qtdSeparateBR">Brent Wood<br><br></div><div style="display: block;" class="yahoo_quoted"> <div style="font-family: verdana, helvetica, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Dave Tobias <terra2you@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> qgis-user@lists.osgeo.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Saturday, February 27, 2016 11:26 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Qgis-user] Assistance with high-level use case of QGIS for commercial use<br> </font> </div> <div class="y_msg_container"><br><div id="yiv5528720040"><div dir="ltr">I'm new to QGIS and have been a very long time user of a commercial GIS solution. Their fee to deploy a mapservice has opened my eyes to other options. I use the term mapservice loosely because what I want to deploy won't even have a map GUI. It is quite simple actually:<div>I would like to deploy QGIS such that multiple non--GIS users can use their individual secure logins to upload a .txt file (in a prescribed format) which will contain a feature ID, latitude and longitude coordinate for each row. Then in batch mode, the program would then overlay the points with a polygon layer I maintain on that server. The output would be a .txt file containing the input attributes plus 1 attribute added to each row from the polygon layer. No map display needed, no other user interaction. This is a simple geospatial operation for which they will pay a nominal fee.</div><div>I was able to do this same operation manually with QGIS desktop and I see there is an API to perform the operation as a script. So...are there any barriers to me doing this with QGIS/QGIS Server? Is there support for this use-case already? I searched but didn't come up with any concrete examples in the forums already - a few were interactive apps, but I need mine to run in batch mode.</div><div>Thanks in advance - hopefully I'm sending to the correct forum!</div><div><br></div></div></div><br>_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br><br></div> </div> </div> </div></div></body></html>