[QGIS-it-user] Errore OGR

[Stefano Degli Esposti]

Salve,

anzitutto mi scuso se la domanda è già stata fatta o se è mal posta.
Lavorando su QGis ho riscontrato il seguente problema: Errori d'invio.
Errore OGR nella cancellazione dell'elemento x...
I dati di varie ore di lavoro non sono stati salvati a seguito di
segnalazione di errore.
Premetto che i progetti del Geopackage di QGis li salvo su un supporto usb:
per lavoro ho necessità di usare vari computer in uffici diversi oltre a
quello personale. In passato tuttavia non mi è mai successo.
Quale potrebbe essere la causa? Per evitare l'errore in futuro devo
ricreare ex-novo i layer in cui il programma dà l'errore.

Grazie mille, cordiali saluti

Stefano Degli Esposti
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] DEM error with OpenDataNRW

[qgis-user]

  
  
On 11/16/2020 12:09 PM, Prof. Dr.
  Martin Berchtold wrote:

The NRW data sort the other way round (see below).
So I probably “just” will have to rearrange Y and X in the NRW
data to get it ready … … … Yes, works! Cool.
 At the risk of stating the obvious, you could transpose the matrix
with just a few lines of Python or R.
  

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Prof. Dr. Martin Berchtold]

Thanks a lot for your help!
It seems that correct functionality only depends on the sequence and sorting of 
Y and X !?
"Cells with same Y coordinates must be placed on consecutive lines. For a same 
Y coordinate value, the lines in the dataset must be organized by increasing X 
values"

The data that works 
(http://www.vermkv.service24.rlp.de/opendat/dgm25/dgm25.zip) is sorted 
according to these organizing rules with ascending X for same Y...:

40.000 547.000 347.382
400025.000 547.000 345.370
400050.000 547.000 342.344
400075.000 547.000 341.794
400100.000 547.000 340.223
400125.000 547.000 337.833

The NRW data sort the other way round (see below). So I probably "just" will 
have to rearrange Y and X in the NRW data to get it ready ... ... ... Yes, 
works! Cool.

Thanks again!
Martin



Von: Nicolas Cadieux 
Gesendet: Montag, 16. November 2020 18:54
An: Prof. Dr. Martin Berchtold ; 
qgis-user@lists.osgeo.org
Betreff: Re: [Qgis-user] DEM error with OpenDataNRW


Hi,

I believe, but Even will confirm, that the data is not organized correctly for 
the gdal driver. I looked at line 2001 and the file is organized by x value 
with incrementing y values.  The x value is constant and the y value change on 
every line.  The error is detected on line 2001 when the x value changes
x y z
32342000.00 5659997.00   43.35
32342000.00 5659998.00   43.41
32342000.00 565.00   43.34
32342001.00 5658000.00   45.16 (line 2001)
32342001.00 5658001.00   45.13
32342001.00 5658002.00   45.00

I reprojected and srtm and save it as a xyz using gdal12xyz and this is what I 
got for the first few lines

xyz

26548864.985 8824521.429 -32768
26548904.304 8824521.429 -32768
26548943.623 8824521.429 -32768
26548982.941 8824521.429 -32768
and at line 4749 thing change to a new y coordinate
26735471.145 8824521.429 -32768
26735510.464 8824521.429 -32768
26548864.985 8824482.110 -32768
26548904.304 8824482.110 -32768

As you can see, the x values changes on every line and the y value is constant 
as stated in https://gdal.org/drivers/raster/xyz.html
"The spacing between each cell must be constant and no missing value is 
supported. Cells with same Y coordinates must be placed on consecutive lines. 
For a same Y coordinate value, the lines in the dataset must be organized by 
increasing X values. The value of the Y coordinate can increase or decrease 
however. The supported column separators are space, comma, semicolon and 
tabulations."


I am not sure the driver can handle this.  You can however open the data as a 
csv and rasterize or interpolate the data (using nearest neighbor) If you use 
the same pixel size and posting, this will work and not change the data.


Perhaps Even R. has a solution.
Nicolas






On 2020-11-16 9:49 a.m., Prof. Dr. Martin Berchtold wrote:
Dear all,

could somebody please explain me why QGIS doesn't process the DEM1 data from 
OpenDataNRW (.xyz, 1 meter, Nordrhein-Westfalen) while the DEM25 data from 
OpenDataRLP (.xyz, 25m, Rheinland-Pfalz, but congruent structure to NRW) works 
out without any problem???

Error message:
Ungültiger Layer: GDAL provider Cannot open GDAL dataset 
C:/[...]/dgm1_05315000_Köln_EPSG4647_XYZ/dgm1_32342_5658_2_nw.xyz: Ungridded 
dataset: At line 2001, change of Y direction Raster layer Datenanbieter ist 
ungültig (Anbieter gdal, URI: 
C:/[...]/dgm1_05315000_Köln_EPSG4647_XYZ/dgm1_32342_5658_2_nw.xyz

There is no change at line 2001... I have no idea, esp. because I can process 
the NRW files in ArcGIS pro without any problem.

Is there a limit of file size or line numbers?

Thanks for any help und kind regards
Martin

---

dvmP
Digitalisierung, Visualisierung & Monitoring in der Raumplanung
Jun.-Prof. Dr. Martin Berchtold

TU Kaiserslautern, Fachbereich Raum- und Umweltplanung
Pfaffenbergstraße 95 | D 67663 Kaiserslautern
Geb. 1, R. U28
T +49 631 205-5151 | M +49 177 3692249
martin.bercht...@ru.uni-kl.de
www.ru.uni-kl.de/dvmP




___

Qgis-user mailing list

Qgis-user@lists.osgeo.org

List info: https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Nicolas Cadieux]

Hi,

I believe, but Even will confirm, that the data is not organized 
correctly for the gdal driver. I looked at line 2001 and the file is 
organized by x value with incrementing y values.  The x value is 
constant and the y value change on every line.  The error is detected on 
line 2001 when the x value changes


x y z
32342000.00 5659997.00   43.35
32342000.00 5659998.00   43.41
32342000.00 565.00   43.34
32342001.00 5658000.00   45.16 (line 2001)
32342001.00 5658001.00   45.13
32342001.00 5658002.00   45.00

I reprojected and srtm and save it as a xyz using gdal12xyz and this is 
what I got for the first few lines


xyz

26548864.985 8824521.429 -32768
26548904.304 8824521.429 -32768
26548943.623 8824521.429 -32768
26548982.941 8824521.429 -32768

and at line 4749 thing change to a new y coordinate
26735471.145 8824521.429 -32768
26735510.464 8824521.429 -32768
26548864.985 8824482.110 -32768
26548904.304 8824482.110 -32768

As you can see, the x values changes on every line and the y value is 
constant as stated in https://gdal.org/drivers/raster/xyz.html
"The spacing between each cell must be constant and no missing value is 
supported. Cells with same Y coordinates must be placed on consecutive 
lines. For a same Y coordinate value, the lines in the dataset must be 
organized by increasing X values. The value of the Y coordinate can 
increase or decrease however. The supported column separators are space, 
comma, semicolon and tabulations."


I am not sure the driver can handle this.  You can however open the data 
as a csv and rasterize or interpolate the data (using nearest neighbor) 
If you use the same pixel size and posting, this will work and not 
change the data.


Perhaps Even R. has a solution.
Nicolas




On 2020-11-16 9:49 a.m., Prof. Dr. Martin Berchtold wrote:


Dear all,

could somebody please explain me why QGIS doesn’t process the DEM1 
data from OpenDataNRW (.xyz, 1 meter, Nordrhein-Westfalen) while the 
DEM25 data from OpenDataRLP (.xyz, 25m, Rheinland-Pfalz, but congruent 
structure to NRW) works out without any problem???


Error message:

*Ungültiger Layer: *GDAL provider Cannot open GDAL dataset 
C:/[…]/dgm1_05315000_Köln_EPSG4647_XYZ/dgm1_32342_5658_2_nw.xyz: 
Ungridded dataset: At line 2001, change of Y direction Raster layer 
Datenanbieter ist ungültig (Anbieter gdal, URI: 
C:/[…]/dgm1_05315000_Köln_EPSG4647_XYZ/dgm1_32342_5658_2_nw.xyz


There is no change at line 2001… I have no idea, esp. because I can 
process the NRW files in ArcGIS pro without any problem.


Is there a limit of file size or line numbers?

Thanks for any help und kind regards

Martin

---

dvm*P*

Digitalisierung, Visualisierung & Monitoring in der Raumplanung

Jun.-Prof. Dr. Martin Berchtold

TU Kaiserslautern, Fachbereich Raum- und Umweltplanung

Pfaffenbergstraße 95 | D 67663 Kaiserslautern

Geb. 1, R. U28

T +49 631 205-5151 | M +49 177 3692249

martin.bercht...@ru.uni-kl.de 

www.ru.uni-kl.de/dvmP 


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Even Rouault]

On lundi 16 novembre 2020 16:53:16 CET Tobias Wendorff wrote:
> Am 16.11.2020 um 16:16 schrieb Even Rouault:
>  > Please provide a link where to download this DEM1 dataset
> 
> Single tiles:
> https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz

Improvement to handle such datasets queued in
https://github.com/OSGeo/gdal/pull/3185

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Silent Installation of QGIS

[sanjay.rana]

Hi Everyone- Is it possible to do a silent installation of the latest versions 
of QGIS remotely? Thanks, Sanjay.

This message is confidential and the information must not be used, disclosed, 
or copied to any other person who is not entitled to receive it. If you have 
received this message in error please notify the sender and then delete it.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Kai Borgolte]

Am 16.11.2020 um 17:26 schrieb Kai Borgolte:

> 1. Data is organized columnwise. While
>  doesn't state it explicitly,
> I think GDAL expects data rowwise.

My fault, it *does* state "Cells with same Y coordinates must be placed
on consecutive lines."
--
Kai Borgolte, Bonn
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Tobias Wendorff]

Am 16.11.2020 um 17:26 schrieb Kai Borgolte:
>

2. X values have a leading "32". To read coordinates with EPSG 25832
this "32" must be deleted.


Or just use EPSG:4647
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Kai Borgolte]

Am 16.11.2020 um 15:49 schrieb Prof. Dr. Martin Berchtold:

> could somebody please explain me why QGIS doesn't process the DEM1 data from 
> OpenDataNRW (.xyz, 1 meter, Nordrhein-Westfalen)

Content of the files is like this:

3249.00 5744000.00  258.95
3249.00 5744001.00  259.09
...
3249.00 5745999.00  321.90
32490001.00 5744000.00  259.04
...
32491999.00 5745999.00  410.93

So IMHO there are two problems reading these files:

1. Data is organized columnwise. While
 doesn't state it explicitly,
I think GDAL expects data rowwise.

2. X values have a leading "32". To read coordinates with EPSG 25832
this "32" must be deleted.
--
Kai Borgolte, Bonn
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] DEM error with OpenDataNRW

[Tobias Wendorff]

Am 16.11.2020 um 16:16 schrieb Even Rouault:

> Please provide a link where to download this DEM1 dataset
Single tiles:
https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz

Municipals:
https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz_paketiert

Main folder, including some interesting Laserscanning stuff:
https://www.opengeodata.nrw.de/produkte/geobasis/hm/

License: https://www.govdata.de/dl-de/zero-2-0
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[QGIS-it-user] Problema con qgis - postgis nell'upgrade da ubuntu 18 a ubuntu 20

[cxc]

Buonasera,

mi ritrovo di fronte un problema con la lettura del db postgresql, 
aggiornato alla versione 12 con il passaggio di versione (da ubuntu 18 a 
20)... da qgis non riesco ad accedere ai layer presnti nel db.


questo l'errore nel pannello PostGIS :

NOTA: ATTENZIONE: non c'è alcuna transazione in corso

2020-11-16T16:10:52     WARNING Impossibile ottenere dal database 
l'elenco delle tabelle con dati spaziali


2020-11-16T16:10:59     WARNING Nessun supporto PostGIS nel database.

2020-11-16T16:11:03     WARNING Interrogazione errata: SELECT 
l.f_table_name,l.f_table_schema,l.f_geometry_column,upper(l.type),l.srid,l.coord_dimension,c.relkind,obj_description(c.oid),array_agg(a.attname 
ORDER BY a.attnum), count(CASE WHEN t.typname IN 
('geometry','geography') THEN 1 ELSE NULL END) , 1 FROM geometry_columns 
l,pg_class c,pg_namespace n,pg_attribute a,pg_type t WHERE 
c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND NOT 
a.attisdropped AND a.attrelid=c.oid AND a.atttypid=t.oid AND a.attnum>0 
AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND 
has_table_privilege(c.oid,'select') AND l.f_table_schema='comune' GROUP 
BY 1,2,3,4,5,6,7,c.oid,11 UNION SELECT 
l.f_table_name,l.f_table_schema,l.f_geography_column,upper(l.type),l.srid,2,c.relkind,obj_description(c.oid),array_agg(a.attname 
ORDER BY a.attnum), count(CASE WHEN t.typname IN 
('geometry','geography') THEN 1 ELSE NULL END) , 1 FROM 
geography_columns l,pg_class c,pg_namespace n,pg_attribute a,pg_type t 
WHERE c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND NOT 
a.attisdropped AND a.attrelid=c.oid AND a.atttypid=t.oid AND a.attnum>0 
AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND 
has_table_privilege(c.oid,'select') AND l.f_table_schema='comune' GROUP 
BY 1,2,3,4,5,6,7,c.oid,11 ORDER BY 2,1,3 ha restituito 7 [ERRORE: 
accesso al file "$libdir/postgis-2.4" fallito: File o directory non 
esistente


queste le specifiche :

Versione di QGIS



3.10.11-A Coruña



Revisione codice QGIS



d2171173e4 

Compilato con Qt



5.12.8



Esecuzione con Qt



5.12.8

Compilato con GDAL/OGR



3.0.4



Esecuzione con GDAL/OGR



3.0.4

Compilato con GEOS



3.8.0-CAPI-1.13.1



Esecuzione con GEOS



3.8.0-CAPI-1.13.1

Compilato su SQLite



3.31.1



In esecuzione su SQLite



3.31.1

Versione client PostgreSQL



12.4 (Ubuntu 12.4-0ubuntu0.20.04.1)



Versione SpatiaLite



4.3.0a

Versione QWT



6.1.4



Versione QScintilla2



2.11.2

Compilato con PROJ



6.3.1



Esecuzione con PROJ



Rel. 6.3.1, February 10th, 2020

Versione SO



Ubuntu 20.04.1 LTS

Ho cercato in ogni dove qualcosa su questo "$libdir/postgis-2.4" ma non 
sono riuscito a trovare nulla.


Grazie per ogni indicazione

saluti

Carlo A. Nicolini

Il 15/11/20 21:00, qgis-it-user-requ...@lists.osgeo.org ha scritto:

Invia le richieste di iscrizione alla lista QGIS-it-user all'indirizzo
qgis-it-user@lists.osgeo.org

Per iscriverti o cancellarti attraverso il web, visita
https://lists.osgeo.org/mailman/listinfo/qgis-it-user
oppure, via email, manda un messaggio con oggetto `help' all'indirizzo
qgis-it-user-requ...@lists.osgeo.org

Puoi contattare la persona che gestisce la lista all'indirizzo
qgis-it-user-ow...@lists.osgeo.org

Se rispondi a questo messaggio, per favore edita la linea dell'oggetto
in modo che sia più utile di un semplice "Re: Contenuti del digest
della lista QGIS-it-user..."


Argomenti del Giorno:

1. Re: Informazioni mancanti in QGIS per la recente aggiunta
   della lingua sarda (Totò)


--

Message: 1
Date: Sun, 15 Nov 2020 10:53:48 -0700 (MST)
From: Totò 
To: qgis-it-user@lists.osgeo.org
Subject: Re: [QGIS-it-user] Informazioni mancanti in QGIS per la
recente aggiunta della lingua sarda
Message-ID: <1605462828610-0.p...@n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

Ciao Valerio,
non sono un esperto in questo settore ma non puo' essere un problema legato
al formato e dimensione della immagine della bandiera?? almeno nel caso
della finestra della Traduzione.



saluti



-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html


--

Subject: Chiusura del digest

___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


--

Fine di Digest di QGIS-it-user, Volume 61, Numero 16

Re: [Qgis-user] DEM error with OpenDataNRW

[Even Rouault]

Martin,

> could somebody please explain me why QGIS doesn't process the DEM1 data from
> OpenDataNRW (.xyz, 1 meter, Nordrhein-Westfalen) while the DEM25 data from
> OpenDataRLP (.xyz, 25m, Rheinland-Pfalz, but congruent structure to NRW)
> works out without any problem???

Please provide a link where to download this DEM1 dataset

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Informazioni mancanti in QGIS per la recente aggiunta della lingua sarda

[Andrea Giudiceandrea]

Valerio Pinna wrote
> ti ringrazio veramente tanto per il tuo aiuto. 

Ciao Valerio,
mi sa che ancora la soluzione non è completa.

La mia patch rende visibile la bandierina, ma pare che non risolva la
visualizzazione del nome della lingua.
Dalle prove che ho fatto, mi pare che il problema sia nella libreria Qt che,
almeno nella versione 5.11.2 disponibile tramite OsGeo4W, non supporta
pienamente il sardo.
https://github.com/qgis/QGIS/pull/40083#issuecomment-727776362
In QGIS viene usato QLocale().nativeLanguageName() per ottenere il nome
della lingua dal codice a due lettere, ma QLocale("sc").nativeLanguageName()
restituisce una stringa vuota...

Se qualcuno in lista usa QGIS con una versione di Qt >= di 5.12 (forse su
Linux) potrebbe verificare qual è l'output del comando
QLocale("sc").nativeLanguageName() nella console di Pyhon?

A presto.

Andrea



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Informazioni mancanti in QGIS per la recente aggiunta della lingua sarda

[Valerio Pinna]

Ciao Andrea, 

ti ringrazio veramente tanto per il tuo aiuto. 

Avevo notato l'assenza del richiamo al relativo file in images/images.qrc.
Tuttavia non ero certo se si trattasse di una correzione da proporre con PR
o se invece fosse un file generato automaticamente da uno script. 

Segnalo, giusto per completezza, il fatto che al momento risultano ancora
completamente assenti sia il file i18n/qgis_sc.ts che un richiamo allo
stesso nel file i18n/CMakeLists.txt.

Considerando il dibattito dei giorni scorsi relativo alla necessitá di
risistemare i file CMakeLists.txt (cosa appena fatta da Nyall) non sapevo se
fosse il caso di proporre o meno una PR per quel file. 

Ancora grazie, 
Valerio





--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user