Re: [Qgis-user] Splitting Spatialite layers

[Nyall Dawson]

On 12 Dec 2016 13:14, "Ramon Andiñach"  wrote:

Ah. Thanks.

Can I echo Richard's request for a back port?


A backport of 3.0s fix isn't possible (it's part of a larger set of
changes). Maybe an alternative fix could be developed for 2.x, but I'm not
aware of anyone actively working on this.

Nyall


-ramon.

On 12 Dec. 2016, at 09:46, Randal Hale 
wrote:

You're hitting a bug that exists in QGIS 2.16 and 2.18 - They are working
on a resolution.

See Below:

http://hub.qgis.org/issues/15847

On 12/11/2016 08:39 PM, custard wrote:

Hi All,

As a  mostly shape/tab file user, I've been attempting to experiment with
spatialite dbs a bit recently, and am starting to get a bit more used to
them. I'm hitting a problem with splitting objects though, and wondered if
this annoyance counted as a bug?

If I have a spatialite layer and split an object, that's fine. But when I
save the layer I get a "Could not commit changes to layer LayerName"
banner. If I press "Show more" then I get something like this:
_

Could not commit changes to layer layername


Errors: SUCCESS: 1 geometries were changed.

SUCCESS: 1 attribute value(s) changed.

ERROR: 4 feature(s) not added.

Provider errors:

SQLite error: UNIQUE constraint failed: LayerName.pkuid

SQL: INSERT INTO "layername"("geometry","pkuid"
,"Code","Lith","Description","Quality","code1","lith1","description1","quality1")
VALUES (ST_Multi(GeomFromWKB(?, 28351)),?,?,?,?,?,?,?,?,?)




I'm not populaing the pkuid data, so I think QGIS is auto filling this.

I think that what's happening is that when QGIS splits the feature both new
parts have the same pkuid number. Certainly if I go in manually and change
the field I can save without errors.

If QGIS is auto filling this column, ought it not be handling the splitting
case too?


Thoughts?

-ramon.


___
Qgis-user mailing listqgis-u...@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user


-- 

Randal Hale
North River Geographic Systems,
Inchttp://www.northrivergeographic.com423.653.3611 <(423)%20653-3611>
rjh...@northrivergeographic.com
twitter:rjhale
http://about.me/rjhalehttp://www.northrivergeographic.com/introduction-to-quantum-gishttps://www.facebook.com/NRGSInc


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

Re: [Qgis-user] Splitting Spatialite layers

[Ramon Andiñach]

Ah. Thanks.

Can I echo Richard's request for a back port?

-ramon.

> On 12 Dec. 2016, at 09:46, Randal Hale  
> wrote:
> 
> You're hitting a bug that exists in QGIS 2.16 and 2.18 - They are working on 
> a resolution. 
> See Below: 
> http://hub.qgis.org/issues/15847
> 
> 
>> On 12/11/2016 08:39 PM, custard wrote:
>> Hi All,
>> 
>> As a  mostly shape/tab file user, I've been attempting to experiment with 
>> spatialite dbs a bit recently, and am starting to get a bit more used to 
>> them. I'm hitting a problem with splitting objects though, and wondered if 
>> this annoyance counted as a bug?
>> 
>> If I have a spatialite layer and split an object, that's fine. But when I 
>> save the layer I get a "Could not commit changes to layer LayerName" banner. 
>> If I press "Show more" then I get something like this:
>> _
>> Could not commit changes to layer layername
>> 
>> Errors: SUCCESS: 1 geometries were changed.
>> SUCCESS: 1 attribute value(s) changed.
>> ERROR: 4 feature(s) not added.
>> Provider errors:
>> SQLite error: UNIQUE constraint failed: LayerName.pkuid
>> SQL: INSERT INTO 
>> "layername"("geometry","pkuid","Code","Lith","Description","Quality","code1","lith1","description1","quality1")
>>  VALUES (ST_Multi(GeomFromWKB(?, 28351)),?,?,?,?,?,?,?,?,?)
>> 
>> 
>> I'm not populaing the pkuid data, so I think QGIS is auto filling this.
>> I think that what's happening is that when QGIS splits the feature both new 
>> parts have the same pkuid number. Certainly if I go in manually and change 
>> the field I can save without errors.
>> If QGIS is auto filling this column, ought it not be handling the splitting 
>> case too?
>> 
>> Thoughts?
>> -ramon.
>> 
>> 
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> -- 
> 
> Randal Hale
> North River Geographic Systems, Inc
> http://www.northrivergeographic.com
> 423.653.3611 rjh...@northrivergeographic.com
> twitter:rjhale http://about.me/rjhale
> http://www.northrivergeographic.com/introduction-to-quantum-gis
> https://www.facebook.com/NRGSInc
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Splitting Spatialite layers

[Randal Hale]

You're hitting a bug that exists in QGIS 2.16 and 2.18 - They are 
working on a resolution.


See Below:

http://hub.qgis.org/issues/15847


On 12/11/2016 08:39 PM, custard wrote:

Hi All,

As a  mostly shape/tab file user, I've been attempting to experiment 
with spatialite dbs a bit recently, and am starting to get a bit more 
used to them. I'm hitting a problem with splitting objects though, and 
wondered if this annoyance counted as a bug?


If I have a spatialite layer and split an object, that's fine. But 
when I save the layer I get a "Could not commit changes to layer 
LayerName" banner. If I press "Show more" then I get something like this:

_

Could not commit changes to layer layername


Errors: SUCCESS: 1 geometries were changed.

SUCCESS: 1 attribute value(s) changed.

ERROR: 4 feature(s) not added.

Provider errors:

SQLite error: UNIQUE constraint failed: LayerName.pkuid

SQL: INSERT INTO 
"layername"("geometry","pkuid","Code","Lith","Description","Quality","code1","lith1","description1","quality1") 
VALUES (ST_Multi(GeomFromWKB(?, 28351)),?,?,?,?,?,?,?,?,?)





I'm not populaing the pkuid data, so I think QGIS is auto filling this.

I think that what's happening is that when QGIS splits the feature 
both new parts have the same pkuid number. Certainly if I go in 
manually and change the field I can save without errors.


If QGIS is auto filling this column, ought it not be handling the 
splitting case too?



Thoughts?

-ramon.



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


--

Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjh...@northrivergeographic.com
twitter:rjhale http://about.me/rjhale
http://www.northrivergeographic.com/introduction-to-quantum-gis
https://www.facebook.com/NRGSInc

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

[Qgis-user] Splitting Spatialite layers

[custard]

Hi All,
As a  mostly shape/tab file user, I've been attempting to experiment
with spatialite dbs a bit recently, and am starting to get a bit more
used to them. I'm hitting a problem with splitting objects though, and
wondered if this annoyance counted as a bug?
If I have a spatialite layer and split an object, that's fine. But
when I save the layer I get a "Could not commit changes to layer
LayerName" banner. If I press "Show more" then I get something like
this:_

Could not commit changes to layer layername 

Errors: SUCCESS: 1 geometries were changed. 

 SUCCESS: 1 attribute value(s) changed. 

 ERROR: 4 feature(s) not added. 

 Provider errors: 

 SQLite error: UNIQUE constraint failed: LayerName.pkuid 

 SQL: INSERT INTO
"layername"("geometry","pkuid","Code","Lith","Description","Quality","code1","lith1","description1","quality1")
VALUES (ST_Multi(GeomFromWKB(?, 28351)),?,?,?,?,?,?,?,?,?) 



I'm not populaing the pkuid data, so I think QGIS is auto filling
this.

I think that what's happening is that when QGIS splits the feature
both new parts have the same pkuid number. Certainly if I go in
manually and change the field I can save without errors.

 If QGIS is auto filling this column, ought it not be handling the
splitting case too?

Thoughts?

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

Re: [Qgis-user] Lat/Long Grids

[Nicolas Cadieux]

Hi,

You also find the equivalent in dd and use that.  
This should help

http://www.equationsheets.com/latlon.xls

If it's just for printing, Lene has a better solution.
Nicolas

> Le 11 déc. 2016 à 03:45, Lene Fischer [via OSGeo.org] 
>  a écrit :
> 
> Hi Grant,
> In the Print Composer>Item Properties>Map you can find Grids / Draw Grid/ 
> Draw Coordinate
> Here you can specify the CRS and the format of the coordinates.
> 
> Here a quick video for an example (Sorry forgot to turn on the mic): 
> http://www.screencast.com/t/yy83fxLPm
> 
> Regards
> Lene Fischer
> From: Qgis-user [[hidden email]] on behalf of Grant Boxer [[hidden email]]
> Sent: 11 December 2016 07:05
> To: [hidden email]
> Subject: [Qgis-user] Lat/Long Grids
> 
> Is there a way to draw a geographic grid with degrees-min with exact minutes? 
> I don’t seem to be able to find the option to specify the degrees-minutes 
> option when displaying coordinates in the map composer. I get decimal 
> degrees-minutes with odd decimal grid values (e.g. 16deg 42.7’ for example). 
> The interval is only displayed in decimal degrees. Is there an option to 
> specify the minute value?
> 
>  
> 
> Grant Boxer
> 
> Consultant Geologist (FAIG R.P. Geo)
> 
> Perth, Western Australia
> 
>  
> 
> Email: [hidden email]
> 
> Mobile: 0418 954 059
> 
> Skype: grantboxer
> 
> Website: www.iinet.net.au/~gboxer
> 
>  
> 
> 
> ___ 
> Qgis-user mailing list 
> [hidden email] 
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
> 
> If you reply to this email, your message will be added to the discussion 
> below:
> http://osgeo-org.1560.x6.nabble.com/Lat-Long-Grids-tp5299482p5299485.html
> To start a new topic under Quantum GIS - User, email 
> ml-node+s1560n4125267...@n6.nabble.com 
> To unsubscribe from Quantum GIS - User, click here.
> NAML




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Lat-Long-Grids-tp5299482p5299504.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Lat/Long Grids

[Lene Fischer]

Hi Grant,
I do understand.
At first you can choose between decimal, degree/min , Dec/min/sec. That part 
one of the solutions.
Secondly you can use the offset. Simply take the minutes eg 42 and divide it 
with 60 in the x box write 42/60. It will then change the value to 0,7 and the 
grid will show as you wish.

Regards
Lene Fischer

From: Grant Boxer [box...@iinet.net.au]
Sent: 11 December 2016 09:50
To: Lene Fischer
Subject: RE: [Qgis-user] Lat/Long Grids
Hi Lene,

I have played around with these settings but my problem is getting QGIS to plot 
a grid with a specific value (say 123 deg 42 min for example), not as an 
automatic selection (123 deg 42.7 min) based on the interval (which is in 
decimal degrees). Ideally what I need it to do is to plot the grid at a 
specific minute spacing, not a decimal degree spacing.

Hope that makes sense!

Cheers Grant


From: Lene Fischer [mailto:l...@ign.ku.dk]
Sent: Sunday, 11 December 2016 4:45 PM
To: Grant Boxer ; qgis-user@lists.osgeo.org
Subject: RE: [Qgis-user] Lat/Long Grids

Hi Grant,
In the Print Composer>Item Properties>Map you can find Grids / Draw Grid/ Draw 
Coordinate
Here you can specify the CRS and the format of the coordinates.

Here a quick video for an example (Sorry forgot to turn on the mic): 
http://www.screencast.com/t/yy83fxLPm

Regards
Lene Fischer

From: Qgis-user [qgis-user-boun...@lists.osgeo.org] on behalf of Grant Boxer 
[box...@iinet.net.au]
Sent: 11 December 2016 07:05
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Lat/Long Grids
Is there a way to draw a geographic grid with degrees-min with exact minutes? I 
don't seem to be able to find the option to specify the degrees-minutes option 
when displaying coordinates in the map composer. I get decimal degrees-minutes 
with odd decimal grid values (e.g. 16deg 42.7' for example). The interval is 
only displayed in decimal degrees. Is there an option to specify the minute 
value?

Grant Boxer
Consultant Geologist (FAIG R.P. Geo)
Perth, Western Australia

Email: box...@iinet.net.au
Mobile: 0418 954 059
Skype: grantboxer
Website: www.iinet.net.au/~gboxer

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

Re: [Qgis-user] Lat/Long Grids

[Lene Fischer]

Hi Grant,
In the Print Composer>Item Properties>Map you can find Grids / Draw Grid/ Draw 
Coordinate
Here you can specify the CRS and the format of the coordinates.

Here a quick video for an example (Sorry forgot to turn on the mic): 
http://www.screencast.com/t/yy83fxLPm

Regards
Lene Fischer

From: Qgis-user [qgis-user-boun...@lists.osgeo.org] on behalf of Grant Boxer 
[box...@iinet.net.au]
Sent: 11 December 2016 07:05
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Lat/Long Grids

Is there a way to draw a geographic grid with degrees-min with exact minutes? I 
don’t seem to be able to find the option to specify the degrees-minutes option 
when displaying coordinates in the map composer. I get decimal degrees-minutes 
with odd decimal grid values (e.g. 16deg 42.7’ for example). The interval is 
only displayed in decimal degrees. Is there an option to specify the minute 
value?

Grant Boxer
Consultant Geologist (FAIG R.P. Geo)
Perth, Western Australia

Email: box...@iinet.net.au
Mobile: 0418 954 059
Skype: grantboxer
Website: www.iinet.net.au/~gboxer

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