search

isce-framework / fringe

Fine Resolution InSAR With Generalized Eigenvectors (FRInGE)
Apache License 2.0
80 stars 42 forks source link

ERROR 1: PROJ: proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name #43

Open mohseniaref-InSAR opened 3 years ago

mohseniaref-InSAR commented 3 years ago

Hi

What this error could be related?

tops2vrt.py -i ../update/merged/ -s coreg_stack -g geometry -c slcs -B -24.6 -24.2 -66 -65.3 ´´´ number of SLCs discovered: 82 we assume that the SLCs and the vrt files are sorted in the same order creating directory: slcs write vrt file for each SLC ... 1 / 82: slcs/20141018.vrt 2 / 82: slcs/20141111.vrt 3 / 82: slcs/20141205.vrt 4 / 82: slcs/20141229.vrt 5 / 82: slcs/20150122.vrt 6 / 82: slcs/20150215.vrt 7 / 82: slcs/20150227.vrt 8 / 82: slcs/20150323.vrt 9 / 82: slcs/20150416.vrt 10 / 82: slcs/20150603.vrt 11 / 82: slcs/20150627.vrt 12 / 82: slcs/20150721.vrt 13 / 82: slcs/20150814.vrt 14 / 82: slcs/20150907.vrt 15 / 82: slcs/20151001.vrt 16 / 82: slcs/20160528.vrt 17 / 82: slcs/20160808.vrt 18 / 82: slcs/20160901.vrt 19 / 82: slcs/20161001.vrt 20 / 82: slcs/20161025.vrt 21 / 82: slcs/20161118.vrt 22 / 82: slcs/20161212.vrt 23 / 82: slcs/20170105.vrt 24 / 82: slcs/20170129.vrt 25 / 82: slcs/20170222.vrt 26 / 82: slcs/20170306.vrt 27 / 82: slcs/20170318.vrt 28 / 82: slcs/20170330.vrt 29 / 82: slcs/20170411.vrt 30 / 82: slcs/20170423.vrt 31 / 82: slcs/20170505.vrt 32 / 82: slcs/20170517.vrt 33 / 82: slcs/20170529.vrt 34 / 82: slcs/20170610.vrt 35 / 82: slcs/20170622.vrt 36 / 82: slcs/20170704.vrt 37 / 82: slcs/20170716.vrt 38 / 82: slcs/20170728.vrt 39 / 82: slcs/20170809.vrt 40 / 82: slcs/20170821.vrt 41 / 82: slcs/20170902.vrt 42 / 82: slcs/20170914.vrt 43 / 82: slcs/20170926.vrt 44 / 82: slcs/20171008.vrt 45 / 82: slcs/20171020.vrt 46 / 82: slcs/20171101.vrt 47 / 82: slcs/20171113.vrt 48 / 82: slcs/20171125.vrt 49 / 82: slcs/20171207.vrt 50 / 82: slcs/20180112.vrt 51 / 82: slcs/20180124.vrt 52 / 82: slcs/20180205.vrt 53 / 82: slcs/20180217.vrt 54 / 82: slcs/20180301.vrt 55 / 82: slcs/20180313.vrt 56 / 82: slcs/20180325.vrt 57 / 82: slcs/20180406.vrt 58 / 82: slcs/20180418.vrt 59 / 82: slcs/20180430.vrt 60 / 82: slcs/20180512.vrt 61 / 82: slcs/20180524.vrt 62 / 82: slcs/20180605.vrt 63 / 82: slcs/20180816.vrt 64 / 82: slcs/20180828.vrt 65 / 82: slcs/20180909.vrt 66 / 82: slcs/20181003.vrt 67 / 82: slcs/20181027.vrt 68 / 82: slcs/20181108.vrt 69 / 82: slcs/20181120.vrt 70 / 82: slcs/20181202.vrt 71 / 82: slcs/20181214.vrt 72 / 82: slcs/20181226.vrt 73 / 82: slcs/20190107.vrt 74 / 82: slcs/20190119.vrt 75 / 82: slcs/20190131.vrt 76 / 82: slcs/20190212.vrt 77 / 82: slcs/20190224.vrt 78 / 82: slcs/20190308.vrt 79 / 82: slcs/20190320.vrt 80 / 82: slcs/20190401.vrt 81 / 82: slcs/20190413.vrt 82 / 82: slcs/20190425.vrt creating stack directory: coreg_stack finding bbox based on geo coordinates of [-24.6, -24.2, -66.0, -65.3] ... 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_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 x min-max: 25091 48113 y min-max: 5522 7268 write vrt file for stack directory creating geometry directory: geometry write vrt file for geometry dataset

´´´

hardreddata commented 3 years ago

It sounds like a proj version issue.

See https://community.rstudio.com/t/sf-installation-issues-on-r4-0-ubuntu18-04/93667/27 which speaks about the same area_of_use_auth_name error.

mohseniaref-InSAR commented 3 years ago

You might try find conda info --base -name epsg and set export PROJ_LIB=