<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<blockquote type="cite"
cite="mid:CAE4vF2dOhYOe_KmyV=GOLMXjwk0mhiUFv2izWPozvhEb178nvg@mail.gmail.com">
<div dir="ltr">
<div>
<div class="gmail-snippet-clipboard-content
gmail-position-relative gmail-overflow-auto">
<pre><code>$ terracotta optimize-rasters ../NaturalnessBZHv1.tif -o optimized/
proj_create_from_database: SQLite error on SELECT name, coordinate_system_auth_name, coordinate_system_code, geodetic_crs_auth_name, geodetic_crs_code, conversion_auth_name, conversion_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM projected_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name</code></pre>
</div>
</div>
</div>
</blockquote>
<code>This error suggests that the PROJ library that is running
finds the proj.db database of another version. So you have likely
a mix of 2 PROJ versions. I see that
<a class="moz-txt-link-freetext" href="https://github.com/DHI-GRAS/terracotta/blob/main/environment.yml">https://github.com/DHI-GRAS/terracotta/blob/main/environment.yml</a>
depends on rasterio, and if you use a binary wheel it will ship
with a PROJ binary,</code><br>
<blockquote type="cite"
cite="mid:CAE4vF2dOhYOe_KmyV=GOLMXjwk0mhiUFv2izWPozvhEb178nvg@mail.gmail.com">
<div dir="ltr">
<div>
<div class="gmail-snippet-clipboard-content
gmail-position-relative gmail-overflow-auto">
<pre><code>
Optimizing 1 file on 1 process
NaturalnessBZHv1.tif ... (1/1)
proj_create_from_database: SQLite error on SELECT name, coordinate_system_auth_name, coordinate_system_code, geodetic_crs_auth_name, geodetic_crs_code, conversion_auth_name, conversion_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM projected_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name
free(): invalid pointer
Aborted (core dumped)
</code></pre>
</div>
<p dir="auto">Any idea/help on how to fix this ?</p>
<p dir="auto">I have no problem on archlinux, with proj 8.0.0
and python 3.9.9</p>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
PROJ mailing list
<a class="moz-txt-link-abbreviated" href="mailto:PROJ@lists.osgeo.org">PROJ@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/proj">https://lists.osgeo.org/mailman/listinfo/proj</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>