[Qgis-user] MSSQL multigeom issues QGIS 3.4.4

[Franklin, Chris - Perth.]

Hi,

I have MSSQL 2012, using Geometry for various datasets, im running into an 
issues when copying new features into a multi polygon table, QGIS reads them as 
separate features even though the are copied as one multi feature and saved 
back to SQL asseparate features. If I copy to Geopackage and do the same it 
works as expected.

The table type is multi polygon and I'm sure the older versions of QGIS did 
this without issue, has anyone else seen this behaviour?

Running on windows 10.

Chris

___
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] SQL QGIS offline plugin issue

[Franklin, Chris - Perth.]

Hi,

Im using QGIS 3.4.4 on windows, it's have issue when using the offline tool 
using either GeoPackage or SQLite , dates are producing this error:

2019-01-30T10:15:41 WARNINGOffline Editing Plugin : FEATREL: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:41 WARNINGOffline Editing Plugin : ATTRREL: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:41 WARNINGOffline Editing Plugin : CREATED: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:42 WARNINGOffline Editing Plugin : RETIRED: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:49 WARNINGOffline Editing Plugin : ERROR: 101905 
feature(s) not added - geometry type is not compatible with the current layer.
2019-01-30T10:15:49 WARNINGOffline Editing Plugin : DateCollected: 
Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:49 WARNINGOffline Editing Plugin : DateModified: 
Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : ERROR: 10 
feature(s) not added - geometry type is not compatible with the current layer.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Reg_Date: Unknown 
data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Reg_Renew_Date: 
Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Rep_Date: Unknown 
data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Ann_Exp_Date: 
Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Start_Date: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Start_Time: Unknown 
data type QTime. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : End_Date: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : End_Time: Unknown 
data type QTime. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Grant_Date: Unknown 
data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50 WARNINGOffline Editing Plugin : Grant_Time: Unknown 
data type QTime. Not using type affinity for the field.
2019-01-30T10:15:51 WARNINGOffline Editing Plugin : Load_Date: Unknown 
data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:51 WARNINGOffline Editing Plugin : Modified_Date: 
Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:51 WARNINGOffline Editing Plugin : Expiry_Date: 
Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:17:15 WARNINGCommit errors : Could not commit changes to 
layer tblSPAUSTRoadNetwork (offline)

In the DB Manager I can see the dates are missing type in the table structure


The source for this data is MSSQL 2012.

Kind Regards

[RDG-Logo-Tagline]

Chris Franklin
Senior GIS Officer
Level 2, Australia Place, 15 - 17 William Street
Perth, Western Australia 6000
T: +61 8 9261 6100  |  D: +61 8 9261 6127 |  M: +61 420 665660
www.rml.com.au


Please consider the environment before printing this email.
This email and any attached files are confidential and may be legally 
privileged. If you are not the intended recipient, any disclosure, 
reproduction, copying, distribution, or other dissemination or use of this 
communication is strictly prohibited. If you have received this transmission in 
error, please notify the sender immediately and then delete this email. Email 
transmission cannot be guaranteed to be secure or error free as information 
could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or 
contain viruses. The sender therefore is in no way liable for any errors or 
omissions in the content of this message, which may arise as a result of email 
transmission. If verification is required, please request a hard copy.

___
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] Performance of MSSQL Server with QGIS 3.4

[Franklin, Chris - Perth.]

Hi All,

Just confirming I am seeing the same issue, I can see all schemas, more than I 
could with 3.2 and 2.18.

Kind Regards

Chris


From: Qgis-user  On Behalf Of Baker, Matthew
Sent: Tuesday, 30 October 2018 3:29 PM
To: Nyall Dawson ; Andreas Neumann 
Cc: qgis-user 
Subject: Re: [Qgis-user] Performance of MSSQL Server with QGIS 3.4

Thanks for the reply, Nyall.

To clarify - this issue is just refreshing the database tree in the browser 
window - once refreshed (eventually), all tables behave normally (see below re. 
invalid geometries).

2.18 and 3.2 used to refresh the tables just fine. Upon installing 3.4, things 
have slowed down for all versions.

Another thing to note - 2.18 and 3.2 show only a handful of schemas in the 
database (not sure how it decides which one) - but now 3.4 is showing ALL 
schemas, including those without any tables and that weren't shown in 2.18/3.2 
- that's weird!

Re. skipping invalid geometries - this setting doesn't seem to have any effect 
on the behavior we're experiencing. (our data is in pretty good shape and we 
haven't had issues with invalid geometries prior to 3.4 when the option to 
'skip' was not available.)

Thanks again!

-m



-Original Message-
From: Nyall Dawson mailto:nyall.daw...@gmail.com>>
Sent: Monday, October 29, 2018 5:04 PM
To: Baker, Matthew mailto:matthew_ba...@dpsk12.org>>; 
Andreas Neumann mailto:andr...@qgis.org>>
Cc: qgis-user mailto:qgis-user@lists.osgeo.org>>
Subject: Re: [Qgis-user] Performance of MSSQL Server with QGIS 3.4

On Tue, 30 Oct 2018 at 05:18, Baker, Matthew 
mailto:matthew_ba...@dpsk12.org>> wrote:

> Everything was working fine even with version 3.2, and additionally, I tested 
> with version 2.18 (which used to work fine), and the same issue is happening.

Just to clarify -- you mean that 2.18 shows the same performance issue?

My suspicion here is that you're running into SQL Server's (very
annoying) invalid geometry handling. We've been fighting with this for a couple 
of releases, and it breaks down to two choices:

1. Don't have any code in place on QGIS' side to overcome invalid geometries on 
SQL server databases. Benefit: fastest performance.
Downside: if ANY features in your table have invalid geometries, SQL Server 
silently aborts the request and returns a truncated table. You may be missing 
features and never even know about them.

2. Handle invalid geometries by repairing all invalid geometries when fetching 
from SQL server. Benefit: no issues with randomly truncated tables. Downside: 
much slower retrieval of features due to all the extra processing (done on the 
SQL server itself)

Since later 2.18 releases and QGIS 3.4 we play it safe and take approach 2 by 
default. Because it's better to have a slower provider instead of silent data 
loss. BUT if you're 100% confident that your database has no invalid 
geometries, and never will have them, then you can take off the safeties and 
run at full performance by changing a setting in your SQL Server connection. 
Look for the "Skip invalid geometry handling" checkbox under the connection 
properties and turn it on. But you've been warned, turning this setting on 
pushes all responsibility back TO YOU to ensure that your database is safe.
You'll get 0 warnings if it isn't, and you'll have randomly missing features 
from your layers.

I wish there was another approach here, but as of current SQL Server versions 
there isn't*. Frankly, it's just a very poor decision made by SQL Server's 
engineers which makes SQL Server an inferior choice for an enterprise spatial 
database.

Nyall

* if there is something we've missed -- please let us know!

>
>
>
> This issue doesn’t seem to lie in the server itself, as our DB GUI’s (MSSQL 
> Server Management Studio, DBeaver, DataGrip) all seem to be behaving normally 
> – tables displaying with no issue, queries performing fine, etc.
>
>
>
> Any thoughts appreciated!
>
>
>
> Thank you!
>
>
>
> -Matthew Baker
>
> Denver Public Schools
>
> Denver, CO, USA
>
>
>
> ___
> 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 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] MS localdb crash error

[Franklin, Chris - Perth.]

Hi,

I have an ODBC connection to a MS localDB on my machine, I have a spatialised 
view in that Db showing only 2 point currently collected by a 3 party piece of 
software via an internal GPS unit, I can bring into QGIS but if I zoom in and 
out QGIS crashes - see report below. No other layers are loaded - im running 
QGIS3 on Windows 10. I have also tried in QGIS 2.18.20 with the same result.


h2. User Feedback



h2. Report Details

*Crash ID*: a3e6a017d398405b26144fef17da819ca6a5a747


*Stack Trace*

RtlEnterCriticalSection :
SQLDisconnect :
LockHandle :
SQLGetStmtAttrW :
isProvider :
isProvider :
isProvider :
QgsVectorLayerFeatureIterator::QgsVectorLayerFeatureIterator :
QgsVectorLayerFeatureSource::getFeatures :
QgsVectorLayerLabelProvider::registerFeature :
QgsMapRendererCustomPainterJob::doRender :
QgsMapRendererCustomPainterJob::staticRender :
QgsMapRendererJob::renderingTime :
QThreadPoolPrivate::reset :
QThread::start :
BaseThreadInitThunk :
RtlUserThreadStart :



*QGIS Info*
QGIS Version: 3.0.3-Girona
QGIS code revision: commit:8a899c8758
Compiled against Qt: 5.9.2
Running against Qt: 5.9.2
Compiled against GDAL: 2.2.4
Running against GDAL: 2.2.4



*System Info*
CPU Type: x86_64
Kernel Type: winnt
Kernel Version: 10.0.16299

Any help gratefully received.

Kind Regards

Chris


Kind Regards

[RDG-Logo-Tagline]

Chris Franklin
Senior GIS Officer
Level 2, Australia Place, 15 - 17 William Street
Perth, Western Australia 6000
T: +61 8 9261 6100  |  D: +61 8 9261 6127 |  M: +61 420 665660
www.rml.com.au


Please consider the environment before printing this email.
This email and any attached files are confidential and may be legally 
privileged. If you are not the intended recipient, any disclosure, 
reproduction, copying, distribution, or other dissemination or use of this 
communication is strictly prohibited. If you have received this transmission in 
error, please notify the sender immediately and then delete this email. Email 
transmission cannot be guaranteed to be secure or error free as information 
could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or 
contain viruses. The sender therefore is in no way liable for any errors or 
omissions in the content of this message, which may arise as a result of email 
transmission. If verification is required, please request a hard copy.

___
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] Custom Projection in QGIS

[Franklin, Chris - Perth]

Hi Kristian,

I was thinking maybe I needed to use the towgs84  in the proj.4 but maybe I was 
wrong, so what can I do in QGIS, will ask tomorrow to see if there is a 4 point 
projection parameters I can use.

Regards

Chris






On Thu, Nov 30, 2017 at 5:05 PM +0800, "Kristian Evers" 
<kr...@sdfe.dk<mailto:kr...@sdfe.dk>> wrote:

Hi Chris,

From your description I have no idea of what you are trying to do. It does 
however look like the parameters you have is for a 2D Helmert transformation. 
That is not something you can do in QGIS today. All transformations in QGIS are 
carried out by PROJ.4. The good news is that in the coming version of PROJ.4 
the 2D Helmert is available (as well as a bunch of other geodetic 
transformations). Eventually this will be available to you in QGIS as well.

/Kristian


Fra: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] På vegne af Franklin, 
Chris - Perth
Sendt: 30. november 2017 03:47
Til: Qgis-user@lists.osgeo.org
Emne: [Qgis-user] Custom Projection in QGIS

I have been given the parameters for a local grid – it’s a version of UTM Zone 
29N but I’m not sure where I need to change the syntax

The parameters I have been given are:

rl_correct =   -24.273
yd1= 22737.030
xd1= 17332.250
yd2= 25987.560
xd2= 17893.870
ym1=1193806.320
xm1=820224.327
ym2=1196784.417
ym2=821648.929

Note the Z adjustment

This results in the following transformation

Scale=  1.00801358
Rotation=  15.4548
Shift x=1171069.29
Shift y=802891.987


Can someone point me in the right direction as to where these are entered?

+proj=utm +zone=29 +datum=WGS84 +units=m +no_defs

Thanks

Chris

___
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] Custom Projection in QGIS

[Franklin, Chris - Perth]

I have been given the parameters for a local grid - it's a version of UTM Zone 
29N but I'm not sure where I need to change the syntax

The parameters I have been given are:

rl_correct =   -24.273
yd1= 22737.030
xd1= 17332.250
yd2= 25987.560
xd2= 17893.870
ym1=1193806.320
xm1=820224.327
ym2=1196784.417
ym2=821648.929

Note the Z adjustment

This results in the following transformation

Scale=  1.00801358
Rotation=  15.4548
Shift x=1171069.29
Shift y=802891.987


Can someone point me in the right direction as to where these are entered?

+proj=utm +zone=29 +datum=WGS84 +units=m +no_defs

Thanks

Chris

___
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