<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19597"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=263552922-24092020><FONT color=#000080
size=2 face=Arial>wrong link - here it goes <A
href="https://github.com/karstenv/dynamic_layers_qgis">https://github.com/karstenv/dynamic_layers_qgis</A></FONT></SPAN></DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> karsten [mailto:karsten@terragis.net]
<BR><B>Sent:</B> Thursday, September 24, 2020 15:29<BR><B>To:</B> 'PostGIS Users
Discussion'<BR><B>Subject:</B> RE: [postgis-users] Promoting PostgreSQL and
PostGIS to wider business intelligence community<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=024502022-24092020><FONT color=#000080
size=2 face=Arial>Ruven: yes interesting thoughts and probably you
are correct with many of your points.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024502022-24092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=024502022-24092020><FONT color=#000080
size=2 face=Arial>Regarding if PostGIS has a relevance to be used
directly: that is a hard one to answer - depending what tools and skills a
user has available in the tool belt </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024502022-24092020><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=024502022-24092020><FONT color=#000080
size=2 face=Arial>However, in order to throw something into the example mix
here is a GitHUB repro <A
href="https://www.youtube.com/watch?v=92EC-cZWEUc&feature=youtu.be">https://www.youtube.com/watch?v=92EC-cZWEUc&feature=youtu.be</A> where
I have some examples on how PostGIS and dynamic layers can be used in QGIS
desktop. </FONT></SPAN><SPAN class=024502022-24092020><FONT color=#000080 size=2
face=Arial>The repro also has some more advanced uses of plpython functions that
enable cool dynamic data visualizations e.g. of dynamic weather data via PostGIS
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024502022-24092020><FONT color=#000080
size=2 face=Arial>If anyone is interested there is a link to a video talk from
QGIS NA 2020 with more details on there as well ...</FONT></SPAN><BR></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left><SPAN
class=024502022-24092020><FONT color=#000080 size=2
face=Arial>Cheers</FONT></SPAN></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left><SPAN
class=024502022-24092020><FONT color=#000080 size=2
face=Arial>Karsten</FONT> </SPAN></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left><FONT size=2
face=Tahoma><B>From:</B> postgis-users
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of
</B>ruvenml@beamerbrooks.com<BR><B>Sent:</B> Thursday, September 24, 2020
15:10<BR><B>To:</B> postgis-users@lists.osgeo.org<BR><B>Subject:</B> Re:
[postgis-users] Promoting PostgreSQL and PostGIS to wider business intelligence
community<BR></FONT><BR></DIV>
<DIV></DIV><FONT face="Helvetica, Arial, sans-serif">I doubt whether PostGIS has
any direct value whatsoever for desktop application users. At a very
minimum, using PostGIS directly requires a knowledge of SQL.
In fact, the more knowledge of SQL a user has, the more powerful PostGIS will
be. SQL is usually taught in a database course which, in many
computer science curriculums, is taught in the second or third year, not to end
users in another occupation.<BR><BR>Business intelligence systems such as Power
BI and Tableau can connect directly to PostGIS data bases and provide end user
commands and operations for querying and modifying those databases. GIS
systems such as ArcGIS and QGIS provide similar capabilities. End
users can get nearly all of the power of PostGIS without having to learn
anything outside of the business intelligence system or the GIS system.
<BR><BR>PostGIS is probably best reserved for people who have a programming
background and whose jobs or avocations involve doing things that are difficult
or impossible to do in existing business intelligence or GIS applications.
There seem to be more than enough people like that to keep the PostGIS
developers quite busy.<BR><BR>Ruven
Brooks<BR><BR><BR><BR><BR><BR><BR><BR></FONT><BR>
<DIV class=moz-cite-prefix>On 9/24/2020 3:58 PM, Shaozhong SHI wrote:<BR></DIV>
<BLOCKQUOTE
cite=mid:CA+i5Jwa-Pikp3MY6xTvkR48txJpQa7OO-HEwT9CET+1LNty4yQ@mail.gmail.com
type="cite">
<DIV dir=ltr>Though we have got some good examples of serving data
to wider business intelligence community, we are still interested in
finding excellent, compelling examples for showing the value of
PostgreSQL/PostGIS as a data service to desktop application users.
<DIV><BR></DIV>
<DIV>I just wonder whether there are excellent examples, for general users to
appreciate?</DIV></DIV><BR>
<FIELDSET class=mimeAttachmentHeader></FIELDSET> <PRE class=moz-quote-pre wrap="">_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</A>
<A class=moz-txt-link-freetext href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</A></PRE></BLOCKQUOTE><BR></BODY></HTML>