<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Hi Regina,
<div class=""><br class="">
</div>
<div class="">Sorry about the all over the place character of my list, but we use PostGIS quite a bit.</div>
<div class=""><br class="">
</div>
<div class="">City of Saint Paul, Public Works:</div>
<div class=""><br class="">
</div>
<div class="">
<ul class="MailOutline">
<li class="">Local caching of offsite Geo-data from other gov gencies (About 60 layers in all).
<ul class="">
<li class="">Other Municipalities</li><li class="">Counties</li><li class="">States</li><li class="">Federal</li><li class="">Reginal</li></ul>
</li><li class="">Local caching of offsite Geo-Data related to conveyence sharing
<ul class="">
<li class="">Bike Shares (LIME, BIRD, etc)</li><li class="">Scooter Shares (LIME, NICERIDE, etc)</li><li class="">Car Shares (Car2Go, recently decommissioned)</li></ul>
</li><li class="">AVL (GPS) tracking data storage
<ul class="">
<li class="">Maintenance Fleet Vehicles.</li><li class="">Cell Phone Tracking</li></ul>
</li><li class="">Logging of Spatial requests to Map Services.
<ul class="">
<li class="">Apache logging of Spatial requests to Map Services.</li><li class="">Generation of Time-lapse filmstrips of (on a daily basis):
<ul class="">
<li class="">AVL <a href="https://www.dropbox.com/s/15c6awmbd57vw54/latest.webm?dl=0" class="">Tracking</a>, </li><li class="">Bike/Scooter Shares (just starting this . . .)</li><li class="">Map Service <span class=""><a href="https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0" class="">Activity</a>.</span></li></ul>
</li></ul>
</li><li class="">Property Assessment Analysis (this was a fun one!)
<ul class="">
<li class="">Relating Parcels Frontages to Street and Alley Centerlines and displaying the output on a dynamic Web Map.</li><li class="">Ties together these elements :
<ul class="">
<li class="">Address Database (City), </li><li class="">Parcel Dataset (County REST service cached locally in POSTGIS (Daily)</li><li class="">Street Centerline dataset (City, Public Works - Admin)</li><li class="">Alley Centerline dataset (City, Public Works - Maint.)</li></ul>
</li><li class="">And generates a view like <a href="https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0" class="">this</a> on the fly inside of our (GeoMoose) web interface.</li><li class="">All SQL based (with heavy usage of PostGIS functions).</li></ul>
</li><li class="">Place finder (FIDO). We generate a searchable location database by crwaling all our spatial datasets and loading the data into Postgres/PostGIS for keyword searching.
<ul class="">
<li class="">Any infrastruture ID # can be used to lookup and zoom to in our Mapping interface.</li></ul>
</li><li class="">Photo/Document finder. Similar to FIDO, we use a connection to a MapWarper digitizing service which store sthe data behind the scenes in Postgres/PostGIS and we use the data in the GeoMOOSE webservice for <a href="https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0" class="">Document</a> discovery.
<ul class="">
<li class="">Works with Point, and Polygon georeferncing.</li></ul>
</li><li class="">Street Level photo library (2.5 million street level and oblique photos)
<ul class="">
<li class="">Similar to Google Street View, but higher resolution</li><li class="">Camera focal length and bearing is stored for each photo in Postgres/PostGIS and used to generate a location targeted photo collection result.</li><li class="">A point is picked on a map, and all the photos pointing at the desired location are displayed in the <a href="https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0" class="">response</a>.</li></ul>
</li></ul>
<div class=""><br class="">
</div>
</div>
<div class="">There are a bunch of other other uses as well, but this is the high level stuff.</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Oct 26, 2018, at 12:05 PM, Regina Obe <<a href="mailto:lr@pcorp.us" class="">lr@pcorp.us</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">Hey all. So we've been in talks with our editor about having a 3rd Edition<br class="">
of PostGIS hopefully to be released around the same time as PostGIS 3.0.<br class="">
<br class="">
I think they are more or less sold on the idea except they did ask about<br class="">
current market share and usage.<br class="">
<br class="">
Part of the reason for that is our previous editions focused a lot on "How<br class="">
do I use this function or do this weird sounding thing that only GIS people<br class="">
can make sense of" instead of "How do I do this real world thing"<br class="">
<br class="">
So one of the thoughts was having our table of contents be more like "How do<br class="">
I do this with PostGIS" in somewhat laymen terms that most people can relate<br class="">
to - like Political Districting, Real Estate analysis (walk scores,<br class="">
elevation measurements to determine viablility of building on a plot of<br class="">
land) <br class="">
without scaring people off with "real world things" they can't relate to or<br class="">
in overly techy terms.<br class="">
<br class="">
Also since the 2nd Edition (which was in 2015 super ancient now since the<br class="">
New shiny version at the time was 2.1 and 2.1 is not even supported<br class="">
anymore).<br class="">
Other major thing changed is a lot of people are deploying PostGIS on cloud<br class="">
offerings like Amazon RDS, Microsoft Azure, and Google PostgreSQL for Cloud<br class="">
so we plan to cover a bit about some things relevant in those that may not<br class="">
be relevant when deploying on your own server.<br class="">
<br class="">
That said, if people can respond with what things they are currently using<br class="">
PostGIS for and also what hosting they are using for PostGIS, that would be<br class="">
helpful for us to get a better idea of focus points.<br class="">
<br class="">
It'd be great if you posted on the list, but if you are shy or need your<br class="">
usage anonymized, you can write directly to me.<br class="">
<br class="">
Thanks,<br class="">
Regina<br class="">
<br class="">
_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">
https://lists.osgeo.org/mailman/listinfo/postgis-users</div>
</div>
</blockquote>
</div>
<br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="Apple-interchange-newline">
<br class="">
</div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<div class="wp_quotepage_quote">I took a speed reading course and read ‘War and Peace’ in twenty minutes. It involves Russia.</div>
<div class="wp_quotepage_author">—Woody Allen</div>
</div>
</div>
<br class="">
</div>
</body>
</html>