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 https://en.wikipedia.org/wiki/Tobler%27s_hiking_function).
See e.g. https://raw.githubusercontent.com/cleveland-metroparks/trailsforthepeople/master/trail.PNG You can play with it here: https://maps.clevelandmetroparks.com Cheers, Best, Steve [http://sig.cmparks.net/cmp-ms-90x122.png] Stephen V. Mather GIS Manager (216) 635-3243 (Work) clevelandmetroparks.com<http://www.clemetparks.com> ________________________________ From: postgis-users <postgis-users-boun...@lists.osgeo.org> on behalf of Regina Obe <l...@pcorp.us> Sent: Friday, October 26, 2018 1:05:52 PM To: postgis-users@lists.osgeo.org Cc: 'PostGIS Development Discussion' Subject: [postgis-users] PostGIS case usages Hey all. So we've been in talks with our editor about having a 3rd Edition of PostGIS hopefully to be released around the same time as PostGIS 3.0. I think they are more or less sold on the idea except they did ask about current market share and usage. Part of the reason for that is our previous editions focused a lot on "How do I use this function or do this weird sounding thing that only GIS people can make sense of" instead of "How do I do this real world thing" So one of the thoughts was having our table of contents be more like "How do I do this with PostGIS" in somewhat laymen terms that most people can relate to - like Political Districting, Real Estate analysis (walk scores, elevation measurements to determine viablility of building on a plot of land) without scaring people off with "real world things" they can't relate to or in overly techy terms. Also since the 2nd Edition (which was in 2015 super ancient now since the New shiny version at the time was 2.1 and 2.1 is not even supported anymore). Other major thing changed is a lot of people are deploying PostGIS on cloud offerings like Amazon RDS, Microsoft Azure, and Google PostgreSQL for Cloud so we plan to cover a bit about some things relevant in those that may not be relevant when deploying on your own server. That said, if people can respond with what things they are currently using PostGIS for and also what hosting they are using for PostGIS, that would be helpful for us to get a better idea of focus points. It'd be great if you posted on the list, but if you are shy or need your usage anonymized, you can write directly to me. Thanks, Regina _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
