<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Afternoon!</p>
<p>I recently upgraded to gdal 2.2.2 from 2.1 on linux and when I
try to use ogr2ogr to append/update an existing table in
PostgreSQL/PostGIS the command fails because it can't apply a
transformation.</p>
<p>The command works fine in gdal 2.1.<br>
</p>
<p>The command I'm using is:<br>
</p>
<blockquote>
<p>ogr2ogr -update -append -gt unlimited -progress -f PostgreSQL
pg:"host=sfngis dbname=witaskewin" input_tlus_pts.shp -nln
fn_sfn.sfn_tlus_flg_pt -lco GEOMETRY_NAME=geom -s_srs
"EPSG:4326" -t_srs "EPSG:3005" -dim 2</p>
</blockquote>
<p>The first part of the error says:<br>
</p>
<blockquote>
<p>ERROR 6: Failed to initialize PROJ.4 with `+proj=longlat
+datum=WGS84 +no_defs'.<br>
unknown elliptical parameter name<br>
ERROR 1: Failed to create coordinate transformation between the<br>
following coordinate systems. This may be because they<br>
are not transformable, or because projection services<br>
(PROJ.4 DLL/.so) could not be loaded.</p>
</blockquote>
<p>Here's the details on the source and target projections:</p>
<blockquote>
<p>ERROR 1: Source:<br>
GEOGCS["WGS 84",<br>
DATUM["WGS_1984",<br>
SPHEROID["WGS 84",6378137,298.257223563,<br>
AUTHORITY["EPSG","7030"]],<br>
AUTHORITY["EPSG","6326"]],<br>
PRIMEM["Greenwich",0,<br>
AUTHORITY["EPSG","8901"]],<br>
UNIT["degree",0.0174532925199433,<br>
AUTHORITY["EPSG","9122"]],<br>
AUTHORITY["EPSG","4326"]]<br>
ERROR 1: Target:<br>
PROJCS["NAD83 / BC Albers",<br>
GEOGCS["NAD83",<br>
DATUM["North_American_Datum_1983",<br>
SPHEROID["GRS 1980",6378137,298.257222101,<br>
AUTHORITY["EPSG","7019"]],<br>
TOWGS84[0,0,0,0,0,0,0],<br>
AUTHORITY["EPSG","6269"]],<br>
PRIMEM["Greenwich",0,<br>
AUTHORITY["EPSG","8901"]],<br>
UNIT["degree",0.0174532925199433,<br>
AUTHORITY["EPSG","9122"]],<br>
AUTHORITY["EPSG","4269"]],<br>
PROJECTION["Albers_Conic_Equal_Area"],<br>
PARAMETER["standard_parallel_1",50],<br>
PARAMETER["standard_parallel_2",58.5],<br>
PARAMETER["latitude_of_center",45],<br>
PARAMETER["longitude_of_center",-126],<br>
PARAMETER["false_easting",1000000],<br>
PARAMETER["false_northing",0],<br>
UNIT["metre",1,<br>
AUTHORITY["EPSG","9001"]],<br>
AXIS["Easting",EAST],<br>
AXIS["Northing",NORTH],<br>
AUTHORITY["EPSG","3005"]]<br>
</p>
</blockquote>
<p>It looks like gdal is able to find libproj.so:</p>
<p>% ldd /usr/lib/libgdal.so | grep proj<br>
libproj.so.12 => /usr/lib/libproj.so.12
(0x00007f1e67458000)<br>
</p>
<pre class="moz-signature" cols="72">--
Kind regards,
Donovan</pre>
</body>
</html>