<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0"></p>
<div>Probably my favorite use of PostGIS at my place of employment is with pgRouting and trails -- we calculate and cache trail routes on a 3D network, which allows us to automatically extract elevation profiles, and gives better time estimates for walking
and horseback riding (using Tobler's function <a href="https://en.wikipedia.org/wiki/Tobler%27s_hiking_function" class="OWAAutoLink" id="LPlnk686596" previewremoved="true">
https://en.wikipedia.org/wiki/Tobler%27s_hiking_function</a>).</div>
<div><br>
</div>
<div>See e.g. <a href="https://raw.githubusercontent.com/cleveland-metroparks/trailsforthepeople/master/trail.PNG" class="OWAAutoLink" id="LPlnk240294" previewremoved="true">https://raw.githubusercontent.com/cleveland-metroparks/trailsforthepeople/master/trail.PNG</a>
<p></p>
</div>
<div><br>
</div>
<div>You can play with it here:</div>
<div>https://maps.clevelandmetroparks.com</div>
<div>Cheers,</div>
<div>Best,</div>
<div>Steve</div>
<br>
<p></p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="WordSection1">
<p class="MsoNormal"><img alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" height="122" hspace="12" width="90" style="user-select: none;" src="http://sig.cmparks.net/cmp-ms-90x122.png">
<span style="font-size:14pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"><strong>Stephen V. Mather</strong></span><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"></span></span><span style="font-size:11pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif"><span style="font-family:Helvetica,sans-serif">GIS Manager</span><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"></span></span><span style="font-size:9pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif"><span style="font-family:Helvetica,sans-serif">(216) 635-3243 (Work)
</span></span><span style="font-size:11pt; color:rgb(31,73,125); font-family:Helvetica,sans-serif"><a target="_blank" href="http://www.clemetparks.com" tabindex="0" id="LPNoLP"><span style="font-family:Helvetica,sans-serif"><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif">clevelandmetroparks.com</span></span></a></span></p>
<p class="MsoNormal"></p>
<br>
<br>
<br>
</div>
</div>
<div></div>
</div>
</div>
</div>
</div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Regina Obe <lr@pcorp.us><br>
<b>Sent:</b> Friday, October 26, 2018 1:05:52 PM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Cc:</b> 'PostGIS Development Discussion'<br>
<b>Subject:</b> [postgis-users] PostGIS case usages</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hey all. So we've been in talks with our editor about having a 3rd Edition<br>
of PostGIS hopefully to be released around the same time as PostGIS 3.0.<br>
<br>
I think they are more or less sold on the idea except they did ask about<br>
current market share and usage.<br>
<br>
Part of the reason for that is our previous editions focused a lot on "How<br>
do I use this function or do this weird sounding thing that only GIS people<br>
can make sense of" instead of "How do I do this real world thing"<br>
<br>
So one of the thoughts was having our table of contents be more like "How do<br>
I do this with PostGIS" in somewhat laymen terms that most people can relate<br>
to - like Political Districting, Real Estate analysis (walk scores,<br>
elevation measurements to determine viablility of building on a plot of<br>
land) <br>
without scaring people off with "real world things" they can't relate to or<br>
in overly techy terms.<br>
<br>
Also since the 2nd Edition (which was in 2015 super ancient now since the<br>
New shiny version at the time was 2.1 and 2.1 is not even supported<br>
anymore).<br>
Other major thing changed is a lot of people are deploying PostGIS on cloud<br>
offerings like Amazon RDS, Microsoft Azure, and Google PostgreSQL for Cloud<br>
so we plan to cover a bit about some things relevant in those that may not<br>
be relevant when deploying on your own server.<br>
<br>
That said, if people can respond with what things they are currently using<br>
PostGIS for and also what hosting they are using for PostGIS, that would be<br>
helpful for us to get a better idea of focus points.<br>
<br>
It'd be great if you posted on the list, but if you are shy or need your<br>
usage anonymized, you can write directly to me.<br>
<br>
Thanks,<br>
Regina<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</span></font></div>
</body>
</html>