Re: [Qgis-user] using nested case statements in labelling

[DelazJ]

Hi,
The issue resides in the use of || operator, which doesn't handle null
values: if any of the concatenated items is null then the result returns
null. In this case, better use the concat function. Something like below
should work (untested, though)

Case when  "signifcant"  = 'yes'
Then
concat( title( "Name" ), '\n',
 Case when "Cu_e_t" <1 Then '' Else round("Cu_e_t"/1000,0) || 'Kt Cu ' End,
 Case when "Pb_e_t" <1 Then '' Else round("Pb_e_t"/1000,0) || 'Kt Pb' End
)
Else null -- I think it's not really needed
End

See
http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#define-labels-based-on-expressions
for some sample of labeling code

Hope that helps,
Harrissou

Le mercredi 21 décembre 2016, damos  a écrit :
> HI I am trying to do a nested case statement for a labelling task.
> I have a list of mines of varying sizes with different commodities and
would
> like to label with the name of the mine and the amount of each commodity
at
> the mine in a new line below the name. I only want to label the mines
that I
> have decided are signifcant and for this I have made a new column in my
> table called significant.
> My difficulty is that not all mines have the same commodities, for example
> one mine has copper (Cu) and no lead(Pb), while another has both. yet
> another will only have Pb.
> i can easily label all of the sigificant mines and their copper amoutns
with
> a suffix of kt Cu using this code:
>
> case when  "signifcant"  = 'yes' then  title( "Name" ) ||   '\n'   ||
 case
> when "Cu_e_t" <1 then '' else round("Cu_e_t"/1000,0) || 'Kt Cu' end else
> null end
>
> however if I then try to add in the Pb amounts like this;
> case when  "signifcant"  = 'yes' then  title( "Name" ) ||   '\n'   ||
 case
> when "Cu_e_t" <1 then '' else round("Cu_e_t"/1000,0) || 'Kt Cu' end ||
> case when "Pb_e_t" <1 then '' else round("Pb_e_t"/1000,0) || 'Kt Pb' end
> else null end
>
> I lose all of the Cu only mines and only get labels for those with Cu and
Pb
> or just Pb.
> I understand that I am doing something wrong with the nested case
> statements, but cant figure out what.
>
> any help would be much appreciated.
> int the mean time I am going back to do the formula in excel where I am
> capable.
>
>
>
>
> --
> View this message in context:
http://osgeo-org.1560.x6.nabble.com/using-nested-case-statements-in-labelling-tp5300779.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
___
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] Tool to copy the content of the map canvas to the clipboard

[Karl-Magnus Jönsson]

Hi!
As I use Windows I usually use the Snipping tool in Windows for such needs. 
Isn’t that an option? Useful for other programs too.

Karl-Magnus Jönsson

Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Larry Shaffer
Skickat: den 20 december 2016 21:44
Till: DelazJ
Kopia: qgis-user@lists.osgeo.org
Ämne: Re: [Qgis-user] Tool to copy the content of the map canvas to the 
clipboard

Hi,

On Tue, Dec 20, 2016 at 11:02 AM, DelazJ 
> wrote:
Hi,
2016-12-20 18:23 GMT+01:00 Bo Victor Thomsen 
>:
Hi List-members -

Is there in Qgis a function / button / menu-item / short-cut / plugin to make a 
simple bitmap copy of the current content of the map-canvas and save it to the 
clipboard ? My users need this to make a copy of the map and paste into MS-Word 
or other software.

While not part of the QGIS app, one could use this PyQGIS snippet to do so 
(tested quickly on macOS 10.11.6 under QGIS 2.14) from the PyQGIS console:

from PyQt4.QtGui import *
QApplication.clipboard().setImage(QImage(QPixmap.grabWidget(iface.mapCanvas(

This avoids having to re-render the QGraphicsView (QgsMapCanvas) to a paint 
device, like an image. Code can be wrapped in a plugin, then have some key 
bindings applied (would need some more PyQt).

Larry Shaffer
Dakota Cartography
Black Hills, South Dakota

I really need the functionality for my users and I can't seem to find it. The 
closest I've come is the "save as png" menu-item in the project menu. But it's 
to cumbersome to use in this case.

Afaics, there's no "save as png" option but "save as image" in Project menu, 
option from which you can choose the image file format (bmp, jpg...). It's not 
on the clipboard but easier and more accessible than print composer.
Regards,
Harrissou


I'm familiar with the composer function. My users can't use this neither 
because it takes to long to activate (to many choices and to many buttons to 
click)

So I've decided to make a simple plugin to cover this functionality. But first 
I want to be very sure the function actually is missing ;-)

Regards
Bo Victor Thomsen
Municipality of Frederikssund, Denmark.
___
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

___
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] spatialjoin

[Erwan Conseil]

Hi
In my layer B , I have the name of the owner and the number of the parcel : 
this number , a polygon , have a WKT location . All this is in a SHP . As I 
grab points in layer A directly in Qgis (2.18) , I have also a SHP . And i need 
a dynamic join because I have no desire to make the spatial join each time...
Regards
Laurent 

> Le 21 déc. 2016 à 01:30, Randal Hale  a 
> écrit :
> 
> In your layer B - Do the Names of the Owners have a location (like a tax 
> parcel) or are they a spreadsheet (like Microsoft Excel)?
> 
> Randy
> 
> 
>> On 12/20/2016 06:03 PM, Laurent Bourlet wrote:
>> Hi at all
>> 
>> I'm a beginner in Qgis and i would make a dynamic spatialjoin.
>> In fact , i have created a vector layer ( for example  A) and i grab points 
>> in it when I'm outdoor ( these points are buildings unknowned by the 
>> government and so these building are not taxed ...) . I have also a layer 
>> (B) with the name of the owners of these lands .
>> You see what i would ?...
>> I would have these names transferred as attribut from B to A .
>> For that , i think about a spatialjoin with a dynamic feature . So i have 
>> downloaded the two plugins "reffunction" and "spatialjoin".
>> But i have certainly maked something wrong because i don't succeed ...
>> 
>> Is it the good method ?
>> 
>> And If yes , and if exist a doc about these plugins ...i'll take it :-))
>> 
>> regards
>> 
>> Laurent
>> 
>> ( pour les francophones ...je repère et saisis des points représentants  des 
>> batiments construits et visibles par Google Map mais inconnus par le 
>> cadastre et donc les impôts ...je voudrais donc enrichir la couche de saisie 
>> par les références des parcelles et les noms des propriétaires par une 
>> jointure spatiale dynamique ..à chaque point saisi , "monte" cette référence 
>> )
>> 
>> ___
>> 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
> 
> ___
> 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

[Qgis-user] using nested case statements in labelling

[damos]

HI I am trying to do a nested case statement for a labelling task.
I have a list of mines of varying sizes with different commodities and would
like to label with the name of the mine and the amount of each commodity at
the mine in a new line below the name. I only want to label the mines that I
have decided are signifcant and for this I have made a new column in my
table called significant.
My difficulty is that not all mines have the same commodities, for example
one mine has copper (Cu) and no lead(Pb), while another has both. yet
another will only have Pb.
i can easily label all of the sigificant mines and their copper amoutns with
a suffix of kt Cu using this code:

case when  "signifcant"  = 'yes' then  title( "Name" ) ||   '\n'   ||   case
when "Cu_e_t" <1 then '' else round("Cu_e_t"/1000,0) || 'Kt Cu' end else
null end

however if I then try to add in the Pb amounts like this;
case when  "signifcant"  = 'yes' then  title( "Name" ) ||   '\n'   ||   case
when "Cu_e_t" <1 then '' else round("Cu_e_t"/1000,0) || 'Kt Cu' end ||  
case when "Pb_e_t" <1 then '' else round("Pb_e_t"/1000,0) || 'Kt Pb' end
else null end

I lose all of the Cu only mines and only get labels for those with Cu and Pb 
or just Pb.
I understand that I am doing something wrong with the nested case
statements, but cant figure out what.

any help would be much appreciated.
int the mean time I am going back to do the formula in excel where I am
capable.




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/using-nested-case-statements-in-labelling-tp5300779.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] spatialjoin

[Randal Hale]

In your layer B - Do the Names of the Owners have a location (like a tax 
parcel) or are they a spreadsheet (like Microsoft Excel)?


Randy


On 12/20/2016 06:03 PM, Laurent Bourlet wrote:

Hi at all

I'm a beginner in Qgis and i would make a dynamic spatialjoin.
In fact , i have created a vector layer ( for example  A) and i grab 
points in it when I'm outdoor ( these points are buildings unknowned 
by the government and so these building are not taxed ...) . I have 
also a layer (B) with the name of the owners of these lands .

You see what i would ?...
I would have these names transferred as attribut from B to A .
For that , i think about a spatialjoin with a dynamic feature . So i 
have downloaded the two plugins "reffunction" and "spatialjoin".

But i have certainly maked something wrong because i don't succeed ...

Is it the good method ?

And If yes , and if exist a doc about these plugins ...i'll take it :-))

regards

Laurent

( pour les francophones ...je repère et saisis des points 
représentants  des batiments construits et visibles par Google Map 
mais inconnus par le cadastre et donc les impôts ...je voudrais donc 
enrichir la couche de saisie par les références des parcelles et les 
noms des propriétaires par une jointure spatiale dynamique ..à chaque 
point saisi , "monte" cette référence )


___
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

___
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] Tool to copy the content of the map canvas to the clipboard

[Larry Shaffer]

Hi,

On Tue, Dec 20, 2016 at 11:02 AM, DelazJ  wrote:

> Hi,
>
> 2016-12-20 18:23 GMT+01:00 Bo Victor Thomsen 
> :
>
>> Hi List-members -
>>
>> Is there in Qgis a function / button / menu-item / short-cut / plugin to
>> make a simple bitmap copy of the current content of the map-canvas and save
>> it to the clipboard ? My users need this to make a copy of the map and
>> paste into MS-Word or other software.
>>
>
While not part of the QGIS app, one could use this PyQGIS snippet to do so
(tested quickly on macOS 10.11.6 under QGIS 2.14) from the PyQGIS console:

from PyQt4.QtGui import *
QApplication.clipboard().setImage(QImage(QPixmap.grabWidget(iface.mapCanvas(

This avoids having to re-render the QGraphicsView (QgsMapCanvas) to a paint
device, like an image. Code can be wrapped in a plugin, then have some key
bindings applied (would need some more PyQt).

Larry Shaffer
Dakota Cartography
Black Hills, South Dakota


> I really need the functionality for my users and I can't seem to find it.
>> The closest I've come is the "save as png" menu-item in the project menu.
>> But it's to cumbersome to use in this case.
>>
>
> Afaics, there's no "save as png" option but "save as image" in Project
> menu, option from which you can choose the image file format (bmp, jpg...).
> It's not on the clipboard but easier and more accessible than print
> composer.
>
> Regards,
> Harrissou
>
>
>>
>> I'm familiar with the composer function. My users can't use this neither
>> because it takes to long to activate (to many choices and to many buttons
>> to click)
>>
>> So I've decided to make a simple plugin to cover this functionality. But
>> first I want to be very sure the function actually is missing ;-)
>>
>> Regards
>> Bo Victor Thomsen
>> Municipality of Frederikssund, Denmark.
>> ___
>> 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
>
___
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] Tool to copy the content of the map canvas to the clipboard

[DelazJ]

Hi,

2016-12-20 18:23 GMT+01:00 Bo Victor Thomsen :

> Hi List-members -
>
> Is there in Qgis a function / button / menu-item / short-cut / plugin to
> make a simple bitmap copy of the current content of the map-canvas and save
> it to the clipboard ? My users need this to make a copy of the map and
> paste into MS-Word or other software.
>
> I really need the functionality for my users and I can't seem to find it.
> The closest I've come is the "save as png" menu-item in the project menu.
> But it's to cumbersome to use in this case.
>

Afaics, there's no "save as png" option but "save as image" in Project
menu, option from which you can choose the image file format (bmp, jpg...).
It's not on the clipboard but easier and more accessible than print
composer.

Regards,
Harrissou


>
> I'm familiar with the composer function. My users can't use this neither
> because it takes to long to activate (to many choices and to many buttons
> to click)
>
> So I've decided to make a simple plugin to cover this functionality. But
> first I want to be very sure the function actually is missing ;-)
>
> Regards
> Bo Victor Thomsen
> Municipality of Frederikssund, Denmark.
> ___
> 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

[Qgis-user] Tool to copy the content of the map canvas to the clipboard

[Bo Victor Thomsen]

Hi List-members -

Is there in Qgis a function / button / menu-item / short-cut / plugin to 
make a simple bitmap copy of the current content of the map-canvas and 
save it to the clipboard ? My users need this to make a copy of the map 
and paste into MS-Word or other software.


I really need the functionality for my users and I can't seem to find 
it. The closest I've come is the "save as png" menu-item in the project 
menu. But it's to cumbersome to use in this case.


I'm familiar with the composer function. My users can't use this neither 
because it takes to long to activate (to many choices and to many 
buttons to click)


So I've decided to make a simple plugin to cover this functionality. But 
first I want to be very sure the function actually is missing ;-)


Regards
Bo Victor Thomsen
Municipality of Frederikssund, Denmark.
___
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] Convert Lines to Polygons

[Nicolas Cadieux]

Hi,
You could create a polygon from the layer extent.  Then use a spatial query to 
get the attributes from your current polylines.
Nicolas

> Le 20 déc. 2016 à 09:18, Richard McDonnell [via OSGeo.org] 
>  a écrit :
> 
> Apologies, 
> I meant to change the subject, but forgot!! So here it is, with a 
> correct subject! 
> 
> I need a little help, I have being trying to create an Index for a 
> series of CAD drawings, they each have a extent bounding box, but its 
> broken into individual lines. 
> 
> I have so far succeeded in creating a shapefile for all of them, but my 
> problem is that what I have is several thousand open polylines instead 
> of box's. each polyline starts and ends in the same point, but I need 
> them to form polygons. 
> The other thing is that the attribute data be preserved. 
> Any help appreciated. 
> Regards, 
> 
> Richard. 
> 
> 
> OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart 
> OPW - Looking to the future - Caring for the past 
> 
> *** 
> Email Disclaimer: http://www.opw.ie/en/disclaimer/
> 
> ___ 
> 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/False-positive-with-norton-whitelisting-tp5300440p5300627.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/False-positive-with-norton-whitelisting-tp5300440p5300643.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] Convert Lines to Polygons

[Randal Hale]

Well - Crap. Heh. There may be other suggestions coming!

Good Luck, We're all counting on you!

Randy


On 12/20/2016 09:50 AM, Richard McDonnell wrote:

Randal,
Thanks for getting back, tries it, but wont work. I might take another 
approach though, Split them up by attributes polygonize them and then 
merge them again into one...looks like its my only option at the moment!

Regards,

Richard.


On 20/12/2016 14:23, Randal Hale wrote:
First thought - take a look at the processing toolbox. Open it and 
search for Lines to Polygons and try that tool. It should convert 
your lines to polygons. The kicker is I don't *think* that will 
preserve attributes. So - you're halfway there *maybe*.


Randy


On 12/20/2016 09:18 AM, Richard McDonnell wrote:

Apologies,
I meant to change the subject, but forgot!! So here it is, with a 
correct subject!


I need a little help, I have being trying to create an Index for a 
series of CAD drawings, they each have a extent bounding box, but 
its broken into individual lines.


I have so far succeeded in creating a shapefile for all of them, but 
my problem is that what I have is several thousand open polylines 
instead of box's. each polyline starts and ends in the same point, 
but I need them to form polygons.

The other thing is that the attribute data be preserved.
Any help appreciated.
Regards,

Richard.


OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
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




--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543


--
-
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjh...@northrivergeographic.com
twitter:rjhale

___
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] Convert Lines to Polygons

[Richard McDonnell]

Randal,
Thanks for getting back, tries it, but wont work. I might take another 
approach though, Split them up by attributes polygonize them and then 
merge them again into one...looks like its my only option at the moment!

Regards,

Richard.


On 20/12/2016 14:23, Randal Hale wrote:
First thought - take a look at the processing toolbox. Open it and 
search for Lines to Polygons and try that tool. It should convert your 
lines to polygons. The kicker is I don't *think* that will preserve 
attributes. So - you're halfway there *maybe*.


Randy


On 12/20/2016 09:18 AM, Richard McDonnell wrote:

Apologies,
I meant to change the subject, but forgot!! So here it is, with a 
correct subject!


I need a little help, I have being trying to create an Index for a 
series of CAD drawings, they each have a extent bounding box, but its 
broken into individual lines.


I have so far succeeded in creating a shapefile for all of them, but 
my problem is that what I have is several thousand open polylines 
instead of box's. each polyline starts and ends in the same point, 
but I need them to form polygons.

The other thing is that the attribute data be preserved.
Any help appreciated.
Regards,

Richard.


OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
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




--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
___
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] Convert Lines to Polygons

[Randal Hale]

First thought - take a look at the processing toolbox. Open it and 
search for Lines to Polygons and try that tool. It should convert your 
lines to polygons. The kicker is I don't *think* that will preserve 
attributes. So - you're halfway there *maybe*.


Randy


On 12/20/2016 09:18 AM, Richard McDonnell wrote:

Apologies,
I meant to change the subject, but forgot!! So here it is, with a 
correct subject!


I need a little help, I have being trying to create an Index for a 
series of CAD drawings, they each have a extent bounding box, but its 
broken into individual lines.


I have so far succeeded in creating a shapefile for all of them, but 
my problem is that what I have is several thousand open polylines 
instead of box's. each polyline starts and ends in the same point, but 
I need them to form polygons.

The other thing is that the attribute data be preserved.
Any help appreciated.
Regards,

Richard.


OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
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

___
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] Convert Lines to Polygons

[Richard McDonnell]

Apologies,
I meant to change the subject, but forgot!! So here it is, with a 
correct subject!


I need a little help, I have being trying to create an Index for a 
series of CAD drawings, they each have a extent bounding box, but its 
broken into individual lines.


I have so far succeeded in creating a shapefile for all of them, but my 
problem is that what I have is several thousand open polylines instead 
of box's. each polyline starts and ends in the same point, but I need 
them to form polygons.

The other thing is that the attribute data be preserved.
Any help appreciated.
Regards,

Richard.


OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
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-it-user] QGIS 2.18.1 e vettore spatialite

[Totò Fiandaca]

Il giorno 20 dicembre 2016 12:03, Luca Mandolesi  ha
scritto:

> Salvatore, non è un errore che un campo integere accetti su spatialite
> valori testuali dato che è una regola di spatialite. I campi sono
> debolmente tipizzati e sta al Management System evitare questo.


​Ciao Luca,
ho letto anche io il cookbook di Furieri.
Il mio problema è relativo alla coppia spatialite qgis;
in qgis, diversamente da spatialite, ogni tipo di dato ha delle regole ben
precise​:

ciao



-- 
*Salvatore Fiandaca*
*mobile*.:+39 327.493.8955
*m*: *pigrecoinfin...@gmail.com *
*blog:** https://pigrecoinfinito.wordpress.com/
*

43°51'0.54"N  10°34'27.62"E - EPSG:4326

“Se la conoscenza deve essere aperta a tutti,
perchè mai limitarne l’accesso?”
R. Stallman
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] False positive with norton + whitelisting

[Richard McDonnell]

Hello all,
I need a little help, I have being trying to create an Index for a 
series of CAD drawings, they each have a extent bounding box, but its 
broken into individual lines.
I have so far succeeded in creating a shapefile for all of them, but my 
problem is that what I have is several thousand open polylines instead 
of box's. each polyline starts and ends in the same point, but I need 
them to form polygons.

The other thing is that the attribute data be preserved.
Any help appreciated.
Regards,

--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
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] [Qgis-developer] QGIS, Shapefiles, default encoding

[Bernd Vogelgesang]

Am 20.12.2016, 11:05 Uhr, schrieb Drexel Peter  
:




Hi,

please, can anyone tell me what default encoding QGIS uses when loading  
a Shapefile?


In my QGIS 2.14.7 on Windows 7 64bit  „Ignore shapefile encoding  
declaration“ is checked,


so if I load a Shapefile with a corresponding utf-8-cpg-file using “drag  
and drop” it is encoded as >‘system’ and the encoding is wrong (what  
encoding is ‘system’?).


If I load a Shapefile with a corresponding utf-8-cpg-file using “Add  
Vector Layer” it is encoded as >‘utf-8’ and the encoding is fine.


In both cases I can change the data source encoding in the properties  
dialog.



Is it possible to change the behavior of drag and drop to use utf-8


If I uncheck „Ignore shapefile encoding declaration“

and load the shapefile either using “Add Vector Layer” or drag and drop  
the cpg-file is interpreted >correctly and the encoding is set to utf-8.


But now I cannot change the data source encoding in the properties  
dialog anymore.


I think it should still be possible to change the encoding in the  
properties dialog.



Peter




Hi Peter,
welcome to the Babylon of computer stone age ;)

I think a lot of people share your confusion with codepages.
Your "system" encoding is that of your Windows, so presumably (in Western  
Europe) windows-1252 or CP1252 or ISO 8859-15.

On a Linux system, it is normally UTF-8.

I often run into problems with the encoding on my Linux system when  
dealing with files from Windows systems and vice versa.

Having files of mixed encodings in a project is a nightmare.
Those problems also seem to derive from files like gpx, kml etc. which  
always seem to be generated using UTF-8.
So even when I decide to handle everthing in Windows-style and convert  
files to windows-1252, those UTF-8 files bring in problems.
Same with the processing toolbox, where some algos happily switch the  
output encoding.


When unchecking „Ignore shapefile encoding declaration“, UTF-8 seems to be  
used internally (see https://hub.qgis.org/issues/11019).
But I have problems understanding all this, and worse, QGIS seems to not  
understand all this as well all the time.


P.s. Haven't touched ArcGIS for years. How does this handle different code  
pages in a project?


















--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374___
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-it-user] QGIS 2.18.1 e vettore spatialite

[Luca Mandolesi]

Salvatore, non è un errore che un campo integere accetti su spatialite
valori testuali dato che è una regola di spatialite. I campi sono
debolmente tipizzati e sta al Management System evitare questo.

Da Spatialite Cookbook pag 63:
A proposito dei tipi di SQLite
Detto molto velocemente: SQLite non usa per niente tipi di dati
.
Siete assolutamente liberi di inserire qualsiasi
tipo di dato in qualsiasi colonna: il tipo dichiarato per i dati della
colonna ha solo funzione
estetica
, me non è
controllato nè obbligato.
Questo non è per niente un
bug
: è una
specifica scelta di progetto
.
Comunque, tutti gli altri DBMS applicano precise qualificazione e controlli
di tipo, perciò il comportamento
di SQLite può apparire strano e sconcertante.
Siete avvertiti
.
In ogni caso SQLite gestisce internamente i seguenti tipi
di dato:
•
NULL
: nessun dato.
•
INTEGER
: interi a
64bit
, in grado di gestire valori molto grandi.
•
DOUBLE
: tipo decimale, doppia precisione.
•
TEXT
: qualsiasi stringa di testo con codifica
UTF­8
, di lunghezza arbitraria.
•
BLOB
: qualsiasi Oggetto Binario Lungo [
Binary Long Object]
, di lunghezza arbitraria ed illimitata.
Ricordate
: qualsiasi
cella
(intersezione di
riga/colonna
) può memorizzare ogni tipo arbitrario di dato.
Esiste una sola eccezione: le colonne dichiarate come
INTEGER PRIMARY KEY
richiedono assolutamente
valori interi.

Il giorno 14 dicembre 2016 12:43, Totò  ha
scritto:

> AV wrote
> > Gentilmente filma le operazioni che fai in Qgis, e posta il video sul
> > Tubo, grazie.
>
> Appena posso faccio il video,
> altre cosa che ho notato:
> 1. un campo definito integer in spatialite, qgis lo vede text ma mi
> permette
> immissione numerica senza segnalare errore;
> 2. il problema su QGIS è random, cioè su alcuni db sembra siano tutti text,
> in altri visualizza bene il tipo di dato.
>
> grazie
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.
> nabble.com/QGIS-2-18-1-e-vettore-spatialite-tp5299713p5299795.html
> Sent from the QGIS Italian User mailing list archive at Nabble.com.
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-it-user
>
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user