<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>If I export a postgis table to geopackage: <br>
</p>
<p>ogr2ogr -f GPKG export.gpkg PG:"host=gis1 user=rjhale
dbname=dbname password=pass" -nln "addresspoints" -sql "select id,
geom, addresses" <br>
</p>
<p>I check the geopackage: <br>
</p>
<pre>rjhale@gis7:~/temp$ ogrinfo -so -al TCStransport.gpkg </pre>
<pre>INFO: Open of `TCStransport.gpkg'</pre>
<pre> using driver `GPKG' successful.</pre>
<pre>
Layer name: addresspoints</pre>
<pre><b>Geometry: Unknown (any)</b></pre>
<pre>Feature Count: 23735
</pre>
<p>Any idea on what I'm doing wrong - the unknown geometry seems to
be causing an issue in another process. If I export without the
SQL statement everything is fine. <br>
</p>
<p>Randy<br>
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
--
Randal Hale
<a class="moz-txt-link-abbreviated" href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>
<a class="moz-txt-link-freetext" href="https://www.northrivergeographic.com">https://www.northrivergeographic.com</a>
(423)653-3611
</pre>
</body>
</html>