gdal - QGIS Error between EPSG and custom SRC - Geographic Information Systems Stack Exchange

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

还单身的红金鱼 · jquery打印pdf - CSDN文库· 8 月前 ·

爱运动的打火机 · springBoot报错： ...· 9 月前 ·

绅士的电脑桌 · 启动Visual Studio ...· 10 月前 ·

气势凌人的开水瓶 · Jenkins的sshagent/crede ...· 1 年前 ·

从未表白的骆驼 · 万字长文：AIGC技术与应用全解析 - 知乎· 1 年前 ·

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Visit Stack Exchange

Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

This is an error I get since the day I changed to 2.x to 3.x version. Today, I am trying to fix it. I had QGIS 3.10 on Linux Mint from the repositories.

Then, I have uninstalled all, and I have installed from the site

Following instruction, and fixing a issue than unabled to me to configure any things, I got 3.28 version.

But the error I wanted to fix is still there.

Translated (more or less):

No transformation available between EPSG:25830 - ETRS89 / UTM zone 30N and custom SRC: GEOGCRS["unknown",DATUM["unknown",ELLIPSOID["GRS 1…. proj_create_operations: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name

If I start QGIS from console, I get those info (and errors):

using qt5ct plugin
D-Bus global menu: no
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
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
proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name
proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name
And when I try to open a project like the picture, I get those errors:
GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name,
ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name,
prime_meridian_code, area_of_use_auth_name, area_of_use_code,
publication_date, deprecated FROM geodetic_datum WHERE auth_name = ?
AND code = ?: no such column: area_of_use_auth_name GDAL ERROR 1:
PROJ: proj_as_wkt: SQLite error on SELECT name, ellipsoid_auth_name,
ellipsoid_code, prime_meridian_auth_name, prime_meridian_code,
area_of_use_auth_name, area_of_use_code, publication_date, deprecated
FROM geodetic_datum WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_create_from_database:
SQLite error on SELECT name, type, coordinate_system_auth_name,
coordinate_system_code, datum_auth_name, datum_code,
area_of_use_auth_name, area_of_use_code, text_definition, deprecated
FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name Warning 4: Failed to open
/usr/share/qgis/resources/data/world_map.gpkg: Permiso denegado. ERROR
1: PROJ: proj_create_from_database: SQLite error on SELECT name, type,
coordinate_system_auth_name, coordinate_system_code, datum_auth_name,
datum_code, area_of_use_auth_name, area_of_use_code, text_definition,
deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such
column: area_of_use_auth_name Warning 4: Failed to open
/usr/share/qgis/resources/data/world_map.gpkg: Permiso denegado. ERROR
1: PROJ: proj_create_from_database: SQLite error on SELECT name, type,
coordinate_system_auth_name, coordinate_system_code, datum_auth_name,
datum_code, area_of_use_auth_name, area_of_use_code, text_definition,
deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such
column: area_of_use_auth_name ERROR 1: PROJ: proj_identify: SQLite
error on SELECT name, type, coordinate_system_auth_name,
coordinate_system_code, datum_auth_name, datum_code,
area_of_use_auth_name, area_of_use_code, text_definition, deprecated
FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_create_from_database:
SQLite error on SELECT name, type, coordinate_system_auth_name,
coordinate_system_code, datum_auth_name, datum_code,
area_of_use_auth_name, area_of_use_code, text_definition, deprecated
FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name ERROR 1: PROJ: proj_identify: SQLite error on
SELECT name, type, coordinate_system_auth_name,
coordinate_system_code, datum_auth_name, datum_code,
area_of_use_auth_name, area_of_use_code, text_definition, deprecated
FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_as_wkt: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code,
prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name,
area_of_use_code, publication_date, deprecated FROM geodetic_datum
WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name ERROR 1: PROJ: proj_identify: SQLite error on
SELECT name, type, coordinate_system_auth_name,
coordinate_system_code, datum_auth_name, datum_code,
area_of_use_auth_name, area_of_use_code, text_definition, deprecated
FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name GDAL ERROR 1: PROJ: proj_create_from_database:
SQLite error on SELECT name, type, coordinate_system_auth_name,
coordinate_system_code, datum_auth_name, datum_code,
area_of_use_auth_name, area_of_use_code, text_definition, deprecated
FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column:
area_of_use_auth_name
UPDATE
This is shown when I type proj -v
Rel. 6.3.1, February 10th, 2020
<proj>: 
projection initialization failure
cause: no arguments in initialization list
program abnormally terminated
                Could you provide the full definition of "SRC personalizado"? Looking at the provided text, seems that the datum is not properly defined. I assume that you are in Spain. I can only imagine that you use ETRS89 or ED50 for very old data. But "unnamed" does not sound very good..
– Javier
                Nov 1, 2022 at 23:42
                @Javier I forgot to translate it. I think that it can be translated like "custom SRC". I have updated. And yes, from Spain. But I don't understand...I know that ED50 is for old data, but I hadn' t noticed that ETRS89 too. I think that it is the SRC used by Catastro in Spain
– user3733164
                Nov 2, 2022 at 5:32
                What I am asking is for the full wkt, not for the translation. Spanish is not the problem. Let me rephrase the sentence: "I can only imagine that you use ETRS89 (or ED50 for very old data)". So, why do you have in Spain a Custom datum? It is very strange. If it were ETRS89, it should be there as ETRS89, not as "custom" or "unnamed". Maybe if you provide the file we can try to understand more. Where is the file coming from?
– Javier
                Nov 2, 2022 at 7:52
                @Javier. All the layers are setting on EPSG:25830 - -ETRS89/ UTM zone 30N as well as the current project. When I start a new session this info dissappear and puts "custom SRC". I have read about similar problems, but I don't know hox can I solved. Think is related wit libproj. I'll updated my message showing the output of proj -v . Thx!
– user3733164
                Nov 2, 2022 at 8:44
Finnaly looks as I had a similar problems seen here.
I have libproj15 6.3.1-1 package and I had a 8.x proj-data version.
I have downloaded and installed the properly version from here:
https://ubuntu.pkgs.org/20.04/ubuntu-universe-amd64/proj-data_6.3.1-1_all.deb.html and now it works fine. It's something related with the new proj.db in 8.1 can't be readed with libproj 6.3.1
Thanks for the question and your answer. I got this error (no such column: area_of_use_auth_name) on Windows when I used an older version of ogr2ogr.exe. In my case I was using the ogr from the geotools/Mapserver GDAL. When I switched to the Postgres/13/bin/ogr2ogr.exe then the error didn't come up any more.
        Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.

Stack Exchange Network