<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="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Oops, some of my example links in the previous message got duplicated, sorry about that, here it is again:</div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<br class="">
</div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
—————————</div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<br class="">
</div>
<div 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/6xip29f9xdwqz4g/Screen%20Shot%202018-10-30%20at%205.06.03%20PM.png?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/b9xp0vp0qro5oga/Screen%20Shot%202018-10-30%20at%205.18.26%20PM.png?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/huwr7326hzlgp3s/Screen%20Shot%202018-10-30%20at%205.27.14%20PM.png?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 class=""><br class="">
<blockquote type="cite" class="">
<div class=""><br class="">
</div>
</blockquote>
</div>
</div>
</div>
</div>
</body>
</html>