<div dir="ltr"><div>Hi all. It was suggested to be that I reach out to this mailing list and ask for help. I've been stuck on this problem for months.</div><div><br></div>I have nationwide data inside 2 postgis db on a 9.6 postgresql cluster on AWS (32GB RAM, Ubuntu 16.04 LTS) that I'm querying against an arbitrary feature (ST_intersects & ST_contains) with a Ubuntu 17 running tileoven. I cannot appropriately get the tiles to render in the GUI without various errors, or crashes. The queries work fine when I run them individually outside of tilemill inside pgadmin, however they do take a lot of time. I am able to get some tiles to render in the GUI, but with missing blocks missing at various zoom levels.<div><br></div><div>Current set of confusing errors:<br> <div>
<span style="color:rgb(36,39,41);font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(238,238,238);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Postgis Plugin: Null connection</span> </div><div><br></div><div>and</div><div><br></div><div>
<span style="color:rgb(36,39,41);font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(238,238,238);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">PostGIS: geometry name lookup failed for table ''. Please manually provide the 'geometry_field' parameter or add an entry in the geometry_columns for ''.</span>
<br><div><div><br></div><div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><br class="gmail-Apple-interchange-newline">For visual reference, this is an example of what tilemill looks like after I try loading a few layers (out of 70). </div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><a href="https://imgur.com/z4ccymr" style="color:rgb(17,85,204)">https://imgur.com/z4ccymr</a></div>
<br></div><div><br></div><div>I found that resetting the cluster can help reduce errors next time I load, but this always comes back. I just want to export.mbtiles. I've tried all kinds of configurations, operating systems, working locally, etc. The only thing that seems to "work" is not using Postgis, by introducing file geodatabases or shapefiles as layers, however this defeats the point of this exercise, which is to query out each map feature based on an arbitrary intersecting feature which is computed using Rgdal during the creation of the .mml tilemill project file. </div><div><br></div><div>Any thoughts or ideas?</div><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><table cellpadding="0" cellspacing="0" style="border-collapse:collapse;font-size:10pt;color:rgb(68,68,68);width:515px;font-family:ARIAL"><tbody><tr><td valign="top" colspan="2" style="padding:0px 0px 10px;font-size:14pt;font-family:Arial;width:514px;vertical-align:top"><strong><span style="font-size:14pt;color:rgb(0,14,88)">Robert Sellers</span></strong><br><span style="font-size:10pt;color:rgb(135,135,135)">Data Scientist</span></td></tr><tr><td valign="top" colspan="2" style="padding:10px 0px 0px;font-size:10pt;border-top:1px solid rgb(0,14,88);font-family:Arial;color:rgb(44,44,44);vertical-align:top"><span style="font-size:10pt"><strong>Azimuth1</strong><br></span><span style="font-size:10pt">m: + 610 406 1521<br></span><span style="font-size:10pt">e: <a href="mailto:robert.sellers@azimuth1.com" target="_blank">robert.sellers@azimuth1.com</a><br></span></td></tr><tr><td valign="top" style="padding:10px 0px;font-size:10pt;font-family:Arial;vertical-align:top"><strong><a href="http://www.azimuth1.com/" style="background-color:transparent;color:rgb(0,140,186)" target="_blank"><span style="font-size:10pt;color:rgb(0,14,88)">www.azimuth1.com</span></a></strong></td><td valign="top" align="right" style="padding:10px 0px;font-size:10pt;font-family:Arial;vertical-align:top;text-align:right"><span><a href="https://www.linkedin.com/in/robertwsellers/" style="background-color:transparent;color:rgb(0,140,186)" target="_blank"><img alt="LinkedIn icon" border="0" width="16" height="16" src="https://signature-generator.cdn.codetwo.com/images/sky/ln.png" style="border: 0px; vertical-align: middle; height: 16px; width: 16px;"></a></span> <span><a href="https://twitter.com/the_delineator" style="background-color:transparent;color:rgb(0,140,186)" target="_blank"><img alt="Twitter icon" border="0" width="16" height="16" src="https://signature-generator.cdn.codetwo.com/images/sky/tt.png" style="border: 0px; vertical-align: middle; height: 16px; width: 16px;"></a></span></td></tr><tr></tr></tbody></table></div></div>
</div></div></div></div>