<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">Hi Josh, </div>
<div class="moz-cite-prefix">From my experience, many network
utilities management applications are deployed using QGIS. From
wastewater to optical networks, I've seen every thematic field
covered. <br>
The full power is released when relying on a postgis database that
will allow to push strong network topology rules and business
rules in the database model. </div>
<div class="moz-cite-prefix">This way, you can play with various
web, desktop or mobile clients. </div>
<div class="moz-cite-prefix">QGIS is especially strong by its
ability to open long transactions and evaluate all database
trigger functions on the fly. Paris Waste water application for
instance uses extensively linear referencing to locate different
equipment. Moving or creating those events is extremly simple and
performant when interacting with database functions. </div>
<div class="moz-cite-prefix">The whole topology of the network is
also rebuilt and constrained by the database, which makes it a lot
more robust for users, who have a lot less data validation steps
to do in the client side. </div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">PyQGIS is interesting and can carry a
good part of the business logic, but you will invest a lot in only
QGIS desktop client. You will have to reimplement similar rules in
a web environnement if you also use QGIS server, or Android mobile
apps (Qfield / Mergin for instance). <br>
This can be probably achievable also with other database like
Oracle, but transaction handling will be less powerful as the main
traction is around postgis .</div>
<div class="moz-cite-prefix">All the best</div>
<div class="moz-cite-prefix">Régis </div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 1/22/26 18:39, Josh Otwell via
QGIS-Developer wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CALORAiBmN=VKct2aYMvHmnjKKNUx7GsEWyBNuQmb-S+5cjxUSw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>
<p class="gmail-isSelectedEnd">Hello QGIS Developers,</p>
<p class="gmail-isSelectedEnd">I’m looking for input on
additional QGIS + Python use cases that are especially
valuable in the energy/utilities sector, beyond the GIS/GDB
editing and general geoprocessing I’m already doing.</p>
<p class="gmail-isSelectedEnd">My goal is to avoid a
“tool-first” mindset and instead understand where QGIS truly
shines (or where plugins / PyQGIS automation can add the
most leverage) for linear infrastructure
workflows—pipelines, electric lines, fiber, and related
asset data.</p>
<p class="gmail-isSelectedEnd">In particular, I’m very
interested in linear referencing approaches where point
features can be automatically ordered and assigned
stationing/measure values along a line or route. If there
are established patterns, recommended plugins, or PyQGIS
examples you’ve found reliable for this, I’d appreciate any
pointers.</p>
<p class="gmail-isSelectedEnd">More broadly, I’d welcome
examples of:</p>
<ul>
<li>
<p class="gmail-isSelectedEnd">Common utility/energy
workflows where QGIS + PyQGIS provides a strong
advantage</p>
</li>
<li>
<p class="gmail-isSelectedEnd">Automation patterns you’ve
seen work well for QA/QC, reporting, or data
synchronization</p>
</li>
<li>
<p class="gmail-isSelectedEnd">Any pitfalls or “gotchas”
you’d suggest I watch for when building scripted
workflows</p>
</li>
</ul>
<p>Thanks in advance for any guidance or references you can
share.</p>
</div>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div><br>
</div>
Josh Otwell
<div>318.243.2075<br>
<div><a href="mailto:josh.otwell@averylandservices.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">josh.otwell@averylandservices.com</a><br>
</div>
</div>
<div>Web and Systems Developer</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
QGIS-Developer mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-Developer@lists.osgeo.org">QGIS-Developer@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>