[Qgis-user] Assistance with high-level use case of QGIS for commercial use

[Brent Wood]

Hi Dave,
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.

the sqls for the overlay to return the text file could just about be as simple as:
copy feature from txtfile;
select f.id, f.lat, f.lon, p.id 
   from polygon p, feature f 
   where ST_Contains(p.poly, ST_SetSRID(ST_Makepoint(f.lon, f.lat),4326));
drop feature;

The first loads the text file into a database table - at potentially 10,000's per second...

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.

The point table is then deleted.

You just need to wrap this up in your preferred scripting language to make it web accessible.
HTH,

Brent Wood

      From: Dave Tobias <terra2you at gmail.com>
 To: qgis-user at lists.osgeo.org 
 Sent: Saturday, February 27, 2016 11:26 AM
 Subject: [Qgis-user] Assistance with high-level use case of QGIS for commercial use
   
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: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.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.Thanks in advance - hopefully I'm sending to the correct forum!

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160227/8e34987b/attachment.html>