<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=us-ascii"><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:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.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;}
/* List Definitions */
@list l0
{mso-list-id:182210252;
mso-list-type:hybrid;
mso-list-template-ids:-851005748 1752479754 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.75in;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:3.25in;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.75in;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1386022167;
mso-list-type:hybrid;
mso-list-template-ids:-182952010 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.75in;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:3.25in;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.75in;
text-indent:-9.0pt;}
@list l2
{mso-list-id:1783496920;
mso-list-type:hybrid;
mso-list-template-ids:-524625010 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l2:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>I’d like to release PostGIS 3.1.0alpha1 in 1 to 2 weeks and preferably before we do PostGIS 3.0.1.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Reasons<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l2 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>I’d like to test our first git release on a non-stable branch as we changed the tagging to not have the old svn number. I don’t think we’ve backported this change to 3.0 branch yet, or maybe we have and I missed it. But if packagers have no issue with the change (Raul did some work in this area which should hopefully make packagers happy), then we can make it in 3.0.1.<o:p></o:p></p><p class=MsoListParagraph>Hopefully this will encourage packagers spin a release if we have a release tag. Chris Berg said debian absolutely needs a release tag before they will provide a package, but he things Bas would be willing to for an alpha. I haven’t asked Devrim, but I think he follows the same rule - NO TAG NO PACKAGING<o:p></o:p></p><p class=MsoListParagraph><o:p> </o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l2 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Some people have shown interest in new changes – e.g. This cool new thing - <a href="https://postgis.net/docs/manual-dev/ST_HexagonGrid.html">https://postgis.net/docs/manual-dev/ST_HexagonGrid.html</a><o:p></o:p></p><p class=MsoListParagraph>ST_TileEnvelope margin addition - <a href="https://postgis.net/docs/manual-dev/ST_TileEnvelope.html">https://postgis.net/docs/manual-dev/ST_TileEnvelope.html</a> (though this seems to be missing in our What’s new section cause it wasn’t tagged quite right – I’ll fix that.<o:p></o:p></p><p class=MsoListParagraph><a href="https://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewFunctions_3_1">https://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewFunctions_3_1</a> <o:p></o:p></p><p class=MsoListParagraph><o:p> </o:p></p><p class=MsoListParagraph>A lot of these folks rely on packagers to get their binaries. Velix (on IRC) said he’d try to break stuff if debian packaging carries it. In particular he’s interested in the hexagon and Square thingy.<o:p></o:p></p><p class=MsoListParagraph><o:p> </o:p></p><p class=MsoNormal>Other things I’d like to do before alpha release which I’m hoping to get done this week<o:p></o:p></p><p class=MsoListParagraph style='margin-left:.75in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Troubleshoot and fix failure under windows of shp2pgsql - <a href="https://winnie.postgis.net:444/job/PostGIS_EDB_Regress_winnie/10256/console">https://winnie.postgis.net:444/job/PostGIS_EDB_Regress_winnie/10256/console</a><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'>BEGIN<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'>psql:E:/jenkins/postgis/tmp/3.1.0dev_pg12_geos3.8.0_gdal2.4.3w64/loader.out:4: ERROR: relation "loadedshp" already exists<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'>-----------------------------------------------------------------------------<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../loader/ReprojectPtsD ..... ok in 2698 ms<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../loader/ReprojectPtsGeog ........ ok in 3430 ms<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../loader/ReprojectPtsGeogD ........ ok in 4287 ms<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../loader/Latin1 .... ok in 11635 ms<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../loader/Latin1-implicit .... ok in 1461 ms<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../loader/mfile .... ok in 3279 ms<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'> ../dumper/literalsrid ... failed (dumping: /projects/postgis/tmp/3.1.0dev_pg12_geos3.8.0_gdal2.4.3w64/dumper-literalsrid.err)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'>-----------------------------------------------------------------------------<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'>Error in psSHP->sHooks.FWrite() while writing object of 28 bytes to .shp file: No error<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'>Error writing shape 0<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'><o:p> </o:p></span></p><p class=MsoListParagraph style='margin-left:.75in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='font-size:11.5pt;color:#333333'><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.5pt;color:#333333'> Take a look at transifex and translation doc building. I think they are broken but been afraid to look.<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.5pt;font-family:"Courier New";color:#333333'><o:p> </o:p></span></p><p class=MsoListParagraph><o:p> </o:p></p></div></body></html>