Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

On Tue, Sep 01, 2015 at 01:15:59PM -0400, James Keener wrote:

> I'd also like to point out that the primary key need not be a single field. 
> For instance (state_fips, county_fips) could be a valid key for county-based 
> metrics. Going back to the previous question I posed, do we want to tell 
> users to conform to a single-field primary key or will qgis accept valid 
> schema designs. Again, it comes down to dev time vs the cost to the user 
> experience.


I'd note that supporting complex primary keys would also allow
qgis to identify rows based on an expensively computed fingerprint
of the hash of the canonical form of each and every field.


--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

On Wed, Sep 02, 2015 at 08:48:34AM +0200, Bernhard Ströbl wrote:
> Am 01.09.2015 um 17:49 schrieb Matthias Kuhn:


> >2. If there are tables without a PK open a second modal dialog with an
> >explanation of the problem and offer to select a pk from a combobox.
> 
> I hope you mean "relation" not table, a table should always have a
> PK.

It's not mandatory for a table to have a PK.
I guess by "tables without a PK" he means table for which no PRIMARY
KEY constraint is explicitly defined (should an UNIQUE key be
considered equally valid?).

> >3. Optional: Add a button "search suitable pk" which looks for a
> >suitable unique column.
> 
> yes, why not, although the label should read something like "analyze
> relation for use in QGIS" or similar (would include detection of
> geometry type and crs if needed) because if a user knows what a PK
> is, he will most probably know which field to use anyways :-)

+1, if a full scan has to be performed, it'd be better to gather
as much information as possible from it.

> >4. Optional: Add a selection "read-only" to the combobox and do some
> >row_number() or other black magic and warn the user with a big red
> >dialog that he's about to do something very dangerous, unreliable and
> >that his warranty is now very void.
> 
> -1 either load the thing properly and if that is not possible one
> has to change the view definition to make it compatible with QGIS if
> it is supposed to be used there. An average user would probably not
> understand what he accepts and complain about bad perfomrance or not
> being able to edit the layer later on. Warning messages are regarded
> as an annoyance to be accepted not to be read and understood :-)

Agreed, better refuse to load with a clear error message than
loading and failing later.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Fwd: Pisa & Bug report #11901

[Goyo]

Sorry, forwarding to the list.

Also the plugin looks a bit abandoned. There is an email address that
you can try in the source code.

Goyo

-- Forwarded message --
From: Goyo 
Date: 2015-09-03 9:49 GMT+02:00
Subject: Re: [Qgis-user] Pisa & Bug report #11901
To: Laurence Béchet 


2015-09-03 3:37 GMT+02:00 Laurence Béchet :
> Hi
>
> The bug can be extended to windows 64 bits (sorry cannot figure out how to
> contact the developer).

You can create an OSGeo4W account and then add a comment to the bug report.

http://www.qgis.org/es/site/getinvolved/development/index.html#bugs-features-and-issues

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

Re: [Qgis-user] Call for release name suggestions 2015

[Anita Graser]

Hi
​
Kosuke,

On Thu, Sep 3, 2015 at 2:51 AM, ASAHI Kosuke  wrote:
>
> Can you use local hackfests or user meeting place name to QGIS?
>

​We can, just submit some official suggestions with nice old map images and
I'll put it on the list.

Best wishes,
Anita​





>
> I'm one of the organizer of hackfests in Japan.
> We japanese comunity had three hackfests on 2015/8/1.
> - tokyo http://connpass.com/event/16560/
> - osaka http://peatix.com/event/106605#
> - hokkaido(sapporo) http://qgis-hack-hokkaido-2015.peatix.com/
>
> If you keep to use place name to QGIS, I propose one of those japanese
> city name.
> I think you can give good impact to non-alphabetical countriesa and local
> comunities.
>
> ​​
> Kosuke ASAHI
>
> On 2015/08/31 2:29, Anita Graser wrote:
>
>> Dear QGIS community,
>>
>> As you might know, given our new release cycle with three releases a
>> year, we are sooner or later going to run out of release names based on
>> developer meeting locations. This is why I would like to remind you to
>> suggest release names.
>>
>> If you have been hosting QGIS user meetings or if you have founded a
>> user group, why not suggest the meeting/foundling location?
>>
>> Here's a short description of what is needed to make a suggestion:
>>
>> -
>>
>> CALL for QGIS RELEASE NAME SUGGESTIONS
>>
>> The following rules apply:
>> - The suggestion should be the name of a place.
>> - The suggestion must not be the name of a software product. (Please try
>> to do some Google searches before submitting the suggestion.)
>> - Each suggestion must come with a suitable map image for splash design.
>> (Make sure that we have the rights to use the image. Since the splash is
>> also printed in our user guide, a minimum resolution of 3000x2000 px is
>> necessary.)
>> - Locations of developer meetings have priority.
>>
>> Submission format: Send an email with a short description of your
>> suggestion and a link to a ZIP file containing the map image(s) to
>> anitagra...@gmx.at 
>>
>> -
>>
>> Best wishes,
>> Anita
>>
>>
>>
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Font sizes in HTML rendering in the composer

[Alexandre Neto]

Hello all,

I'm struggling with the HTML rendering option of the composer's Labels. I'm
not sure if this is a QGIS question, or a html one, but, here it goes:

I'm using a html rendered label and I want to match the font size, style,
etc.. of parts of the text with the different fonts used across the
composition in other labels, scales, legend items. But I can't seem to be
able to control the HTML font sizes with exact values.

Please have a look at my example: http://imgur.com/uHctIyl

The top label is a normal label, using ubuntu regular, size 10.
The bottom label is HTML renderer, and uses the following syntax:



p {

font-family: ubuntu;

font-size: 10pt;

text-align: justify;

}





This text is writen with html rendering



Has you can see, they are not look equal.

Thanks for your help.

Alexandre Neto
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Black/White and colors maps

[Shane]

  I have the need to create two maps; one with color and the other 
black and white.  The color map has trails (in several shapefiles) with 
each trail a different color.  The other map has the same trails (same 
shapefiles) but each trail is represented as a dashed black line.


   The brute force way to do this is to add two layers of the same 
shapefile (with different layer names of course).  Then in the 
Properties of each layer, modify the line style as needed.  I've done this.


   What about using the "Data defined properties ..." button in the 
simple line style properties dialog?  Is that possible?  But I don't 
understand how I would trigger the selection of the required style.


   (I'm using QGIS 2.6.  Yes I know, a dinosaur, but it's working.)

   Shane

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