Re: [Qgis-user] A few question

[Martin Weis]

On 02.07.20 19:22, blubee blubeeme wrote:
> I have some aerial images;

Are they georeferenced already?


> Warning 4: Failed to open /usr/share/qgis/resources/data/world_map.gpkg:
> Permission denied
> then one of the below messages for each picture that's being imported.
> proj_concatoperation_get_step_count: Object is not a ConcatenatedOperation

No issues, no need to act.

> Is this just an issue with the images or something wrong my steps to create
> orthomosaic from a series of photos.

If these are raw photos you need a bundle adjustment/SfM step to
generate an orthophoto. This cannot be done 'directly' with gdal.
There are some commercial systems and clouds, or you try ODM (Open Drone
Map).
You may also need ground control points etc.

The resulting (georeferenced) orthophoto can be handled in QGIS.

___
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] R: QGIS Server on Debian - MSSqlServer layer

[Francesco D Alesio]

Chris,

thank you for the answer.


Unfortunately, while ogr2ogr is working properly following those suggestions, 
qgis is not.





Francesco





-Messaggio originale-
Da: chris hermansen 
Inviato: Venerdì 3 Luglio 2020 16:25
A: Francesco D Alesio 
Cc: qgis-user 
Oggetto: Re: [Qgis-user] QGIS Server on Debian - MSSqlServer layer

Francesco and list,

Please look at this 
http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-MSSQL-driver-not-found-amp-Can-t-open-lib-SQL-Server-QGIS-2-18-LTR-on-Debian-td5386050.html

On Fri, Jul 3, 2020, 01:16 Francesco D Alesio mailto:francesco.dale...@ies.it> > wrote:
Hello everybody,

I'm trying to display an MS Sql Server layer with QGIS Server (3.12) installed 
on a Debian 10 machine.



The project is giving the "Layer(s) not valid" error, because of the MS Sql 
Server layer (postgis layers are working properly).



I've installed the odbc driver, and now I can connect to sql server with 
ogr2ogr, specifyng "Driver={ODBC Driver 17 for SQL Server}" in the connection 
string.

Than I added a [SQL Server] section to /etc/odbcinst.ini , and now ogr2ogr 
works without the Driver in the connection string.

But QGIS is still giving the "Layer(s) not valid" error.



I've also tried to add the driver name to the source attribute of the 
layer-tree-layer element of the qgs file, without success.



Three questions:

1. What else can I try?

2. Is there a way to get more detailed error information? apache error logs are 
empty, and QGIS_SERVER_LOG_FILE contains just the layer id 
(QGIS_SERVER_LOG_LEVEL=0 and QGIS_DEBUG=9)

3. Do you recommend using windows instead of debian in this environment?



Thank you



Regards





Francesco









___
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] QGIS Server on Debian - MSSqlServer layer

[chris hermansen]

Francesco and list,

Please look at this
http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-MSSQL-driver-not-found-amp-Can-t-open-lib-SQL-Server-QGIS-2-18-LTR-on-Debian-td5386050.html

On Fri, Jul 3, 2020, 01:16 Francesco D Alesio 
wrote:

> Hello everybody,
>
> I'm trying to display an MS Sql Server layer with QGIS Server (3.12)
> installed on a Debian 10 machine.
>
>
> The project is giving the "Layer(s) not valid" error, because of the MS
> Sql Server layer (postgis layers are working properly).
>
>
> I've installed the odbc driver, and now I can connect to sql server with
> ogr2ogr, specifyng "Driver={ODBC Driver 17 for SQL Server}" in the
> connection string.
>
> Than I added a [SQL Server] section to /etc/odbcinst.ini , and now ogr2ogr
> works without the Driver in the connection string.
>
> But QGIS is still giving the "Layer(s) not valid" error.
>
>
> I've also tried to add the driver name to the source attribute of
> the layer-tree-layer element of the qgs file, without success.
>
>
> Three questions:
>
> 1. What else can I try?
>
> 2. Is there a way to get more detailed error information? apache error
> logs are empty, and QGIS_SERVER_LOG_FILE contains just the layer id 
> (QGIS_SERVER_LOG_LEVEL=0
> and QGIS_DEBUG=9)
>
> 3. Do you recommend using windows instead of debian in this environment?
>
>
> Thank you
>
>
> Regards
>
>
>
> Francesco
>
>
>
>
>
> ___
> 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] Inefficient SQL

[chris hermansen]

Paul and list,

On Fri, Jul 3, 2020, 05:11 Paul Wittle 
wrote:

> Hi,
>
>
>
> We noticed that one of our users was accidentally sending inefficient (or
> possibly just massive) SQL statements to the Oracle database. I need to do
> more work to try and replicate the behaviour but is anyone familiar with
> how it can happen?
>
>
>
> The query is in the form of select [statement] from table where ID = :a OR
> ID = :b … OR ID = :xxab
>

Could this be an Oracle table joined by QGIS to a (say) shapefile with the
user selecting a bunch of records (maybe selecting all; or selecting a few
,then inverting the selection; or selecting all records in a bounding box)
which is seen on the Oracle end as such a select?

I don't know this for a fact but it seems plausible. I would think it's
going to be a bunch of OR operators or an IN () with a long list.

>
>
> We wondered why that would happen as normally you would just do a spatial
> query or perhaps do that for a small number of rows but it seemed to be
> doing it for a large number of rows.
>
>
>
> Any tips to what might be the cause would help me to replicate the issue;
> my working theory is trying to load too many features in the attribute
> table but I’m not sure.
>
>
>
> Thanks,
>
>
>
> *Paul Wittle *
>
> 
>
> *Business Solutions Analyst (GIS)*
>
> *ICT Operations *
>
> *Dorset Council*
>
> 01305 228473
> <01305%20228473%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20>
>
> dorsetcouncil.gov.uk 
>
>
>
> 
>
> 
>
> 
>
>
> This e-mail and any files transmitted with it are intended solely for the
> use of the individual or entity to whom they are addressed. It may contain
> unclassified but sensitive or protectively marked material and should be
> handled accordingly. Unless you are the named addressee (or authorised to
> receive it for the addressee) you may not copy or use it, or disclose it to
> anyone else. If you have received this transmission in error please notify
> the sender immediately. All traffic may be subject to recording and/or
> monitoring in accordance with relevant legislation. Any views expressed in
> this message are those of the individual sender, except where the sender
> specifies and with authority, states them to be the views of Dorset
> Council. Dorset Council does not accept service of documents by fax or
> other electronic means. Virus checking: Whilst all reasonable steps have
> been taken to ensure that this electronic communication and its attachments
> whether encoded, encrypted or otherwise supplied are free from computer
> viruses, Dorset Council accepts no liability in respect of any loss, cost,
> damage or expense suffered as a result of accessing this message or any of
> its attachments. For information on how Dorset Council processes your
> information, please see www.dorsetcouncil.gov.uk/416433
> ___
> 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] Inefficient SQL

[Raymond Nijssen]

Hi Paul,

Not sure what causes this in QGIS, but I can imagine this happens when 
you need data for a manual selection. So you select 200 features on your 
screen (by dragging a box) and then export them to a file? Or maybe QGIS 
does this better but a plugin doesn't?


To add to this, I remember hitting a "maximum where clauses of 1000" in 
Oracle a while ago, so this doesn't only affect performance but can 
cause errors as well.


Regards,
Raymond



On 03-07-2020 14:11, Paul Wittle wrote:

Hi,

We noticed that one of our users was accidentally sending inefficient 
(or possibly just massive) SQL statements to the Oracle database. I need 
to do more work to try and replicate the behaviour but is anyone 
familiar with how it can happen?


The query is in the form of select [statement] from table where ID = :a 
OR ID = :b … OR ID = :xxab


We wondered why that would happen as normally you would just do a 
spatial query or perhaps do that for a small number of rows but it 
seemed to be doing it for a large number of rows.


Any tips to what might be the cause would help me to replicate the 
issue; my working theory is trying to load too many features in the 
attribute table but I’m not sure.


Thanks,

*Paul Wittle *





*Business Solutions Analyst (GIS)*

*ICT Operations *

*Dorset Council*

01305 228473 



dorsetcouncil.gov.uk 











This e-mail and any files transmitted with it are intended solely for 
the use of the individual or entity to whom they are addressed. It may 
contain unclassified but sensitive or protectively marked material and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, 
or disclose it to anyone else. If you have received this transmission in 
error please notify the sender immediately. All traffic may be subject 
to recording and/or monitoring in accordance with relevant legislation. 
Any views expressed in this message are those of the individual sender, 
except where the sender specifies and with authority, states them to be 
the views of Dorset Council. Dorset Council does not accept service of 
documents by fax or other electronic means. Virus checking: Whilst all 
reasonable steps have been taken to ensure that this electronic 
communication and its attachments whether encoded, encrypted or 
otherwise supplied are free from computer viruses, Dorset Council 
accepts no liability in respect of any loss, cost, damage or expense 
suffered as a result of accessing this message or any of its 
attachments. For information on how Dorset Council processes your 
information, please see www.dorsetcouncil.gov.uk/416433


___
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

[Qgis-user] Inefficient SQL

[Paul Wittle]

Hi,

We noticed that one of our users was accidentally sending inefficient (or 
possibly just massive) SQL statements to the Oracle database. I need to do more 
work to try and replicate the behaviour but is anyone familiar with how it can 
happen?

The query is in the form of select [statement] from table where ID = :a OR ID = 
:b ... OR ID = :xxab

We wondered why that would happen as normally you would just do a spatial query 
or perhaps do that for a small number of rows but it seemed to be doing it for 
a large number of rows.

Any tips to what might be the cause would help me to replicate the issue; my 
working theory is trying to load too many features in the attribute table but 
I'm not sure.

Thanks,

Paul Wittle
[cid:image001.jpg@01D6513B.651ABDE0]
Business Solutions Analyst (GIS)
ICT Operations
Dorset Council
01305 228473 

dorsetcouncil.gov.uk

[cid:image002.png@01D6513B.651ABDE0]
[cid:image003.png@01D6513B.651ABDE0]
[cid:image004.png@01D6513B.651ABDE0]

This e-mail and any files transmitted with it are intended solely for the use 
of the individual or entity to whom they are addressed. It may contain 
unclassified but sensitive or protectively marked material and should be 
handled accordingly. Unless you are the named addressee (or authorised to 
receive it for the addressee) you may not copy or use it, or disclose it to 
anyone else. If you have received this transmission in error please notify the 
sender immediately. All traffic may be subject to recording and/or monitoring 
in accordance with relevant legislation. Any views expressed in this message 
are those of the individual sender, except where the sender specifies and with 
authority, states them to be the views of Dorset Council. Dorset Council does 
not accept service of documents by fax or other electronic means. Virus 
checking: Whilst all reasonable steps have been taken to ensure that this 
electronic communication and its attachments whether encoded, encrypted or 
otherwise supplied are free from computer viruses, Dorset Council accepts no 
liability in respect of any loss, cost, damage or expense suffered as a result 
of accessing this message or any of its attachments. For information on how 
Dorset Council processes your information, please see 
www.dorsetcouncil.gov.uk/416433
___
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] A suggestion to define a proj4 string

[Tudorache, Marian]

Hi,

I got some vectorial projected data. The data reference is stereographic where 
lat_0=53.354166  and lon_0=-114.8525
The data spec also gave me this:
Major_Axis_Csp= 6378137
Minor_Axis_Csp= 6356752.31414
Gnomonic_Scale_Factor_Csp= 0.9984
Stereographic_Scale_Factor_Csp= 0.9996
Utm_Scale_Factor_Csp= 0.9996
Ups_Scale_Factor_Csp= 0.994
Rdps_Eccentricity_Squared_Csp= 0.00672267
False Northing= 0
False Easting = 0

So I tried to define a proj4 string to be used in QGIS.
This is what I found so far:
Major_Axis_Csp = +a
Minor_Axis_Csp = +b
False Northing   = +y_0
False Easting   = +x_0
I figured out based on major and minor axis the ellps is using GRS 1980 model
What I cannot figured out is how to use the four scale factors in proj4. My 
fist assumption is to use Stereographic_Scale_Factor_Csp value for k_0 scaling 
factor.
Did someone encountered such projection specifications?
This is the proj4 string that I defined
+proj=sterea +lat_0=53.354166 +lon_0=-114.8525 +k_0=0.9996 +x_0=0.0 +y_0=0.0 
+a=6378137 +b=6356752.31414 +ellps=GRS80 +units=m +no_defs
Do you think is correct?

Thank you,
Marian




This electronic message, as well as any transmitted files included in the 
electronic message, may contain privileged or confidential information and is 
intended solely for the use of the individual(s) or entity to which it is 
addressed. If you have received this electronic message in error please notify 
the sender immediately and delete the electronic message. Any unauthorized 
copying, disclosure or distribution of the electronic message is strictly 
forbidden. NAV CANADA accepts no liability for any damage caused by any virus 
and/or other malicious code transmitted by this electronic communication.

Le présent message électronique et tout fichier qui peut y être joint peuvent 
contenir des renseignements privilégiés ou confidentiels destinés à l’usage 
exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez 
reçu ce message électronique par erreur, veuillez en informer l’expéditeur 
immédiatement et supprimez le. Toute reproduction, divulgation ou distribution 
du présent message électronique est strictement interdite. NAV CANADA n’assume 
aucune responsabilité en cas de dommage causé par tout virus ou autre programme 
malveillant transmis par ce message électronique.
___
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] QGIS Server on Debian - MSSqlServer layer

[Francesco D Alesio]

Hello everybody,

I'm trying to display an MS Sql Server layer with QGIS Server (3.12) installed 
on a Debian 10 machine.



The project is giving the "Layer(s) not valid" error, because of the MS Sql 
Server layer (postgis layers are working properly).



I've installed the odbc driver, and now I can connect to sql server with 
ogr2ogr, specifyng "Driver={ODBC Driver 17 for SQL Server}" in the connection 
string.

Than I added a [SQL Server] section to /etc/odbcinst.ini , and now ogr2ogr 
works without the Driver in the connection string.

But QGIS is still giving the "Layer(s) not valid" error.



I've also tried to add the driver name to the source attribute of the 
layer-tree-layer element of the qgs file, without success.



Three questions:

1. What else can I try?

2. Is there a way to get more detailed error information? apache error logs are 
empty, and QGIS_SERVER_LOG_FILE contains just the layer id 
(QGIS_SERVER_LOG_LEVEL=0 and QGIS_DEBUG=9)

3. Do you recommend using windows instead of debian in this environment?



Thank you



Regards





Francesco
___
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