<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>This is great stuff. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>Darafei "Kom?pa" Praliaskouski<br><b>Sent:</b> Friday, October 26, 2018 3:54 PM<br><b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br><b>Cc:</b> PostGIS Development Discussion <postgis-devel@lists.osgeo.org><br><b>Subject:</b> Re: [postgis-devel] [postgis-users] PostGIS case usages<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Some things I've been using PostGIS for:<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - render OpenStreetMap. That's how I got to know about PostGIS, osm2pgsql, mapnik and its styles. Changing order of things, removing clutter of icons from map, adding clutter of icons you need for this map, getting tile server online. Sorting by area to get smaller polys on top of bigger. ST_PointOnSurface for better icon placement. ST_Linemerge for rendering street labels on lower zooms, when street segments are too small. Rotating house number labels to be parallel to streets. Extruding houses and making a layer of shadows for them.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - extracting some type of data from OpenStreetMap. First osm2pgsql, then debug a WHERE clause in QGIS (in right-click - Filter on layer), then get it out as ST_AsGeoJSON, then publish on <a href="http://geojson.io">geojson.io</a>.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - binning some data. Get some lon, lat, value data, group by ST_Expand(ST_SnapToGrid(geom)), show in QGIS, add transparency to layer, colorize by Graduated in Quantile mode. Look, get insights.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - stealing some data from some web endpoint. Make python func that gets data from some endpoint (for example, OSRM to get a route and travel time from A to B, or google geocoder for some text addresses), store and aggregate that.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - filling tax forms: get taxi trips, calculate start/end boroughs (point-in-poly), check they had toll booth on the way (ST_DWithin), check length (a call to OSRM to snap to roads + ST_Length), check if customer got where they planned to go (ST_Distance / ST_LineLocatePoint).<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - calculating population by some polygons ("zonal statistics"), example "where should I open cafe in Minsk" is <a href="https://github.com/Komzpa/minsk-population">https://github.com/Komzpa/minsk-population</a>.<br><br> - wifi positioning: given this list of wifi mac addresses device sees and last known gps position, and a history of such data for all users, what is more likely position this user is at? (ST_GeometricMedian, weights).<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - generating game map admin boundaries. ST_VoronoiPolygons(settlements), ST_Intersection(voronoi, land), ST_ClusterKMeans(voronoi, num_players), ST_Union() group by cid.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>пт, 26 окт. 2018 г. в 20:05, Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>>:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal>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><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div><p class=MsoNormal>-- <o:p></o:p></p><div><div><p class=MsoNormal>Darafei Praliaskouski<br>Support me: <a href="http://patreon.com/komzpa">http://patreon.com/komzpa</a><o:p></o:p></p></div></div></div></div></body></html>