[Qgis-user] Atlas by year

[Alexandre Neto]

Hi Andreas,

Last time I tried, virtual layers did not work as coverage layers. One
would need to export the layer before using it.

Do you confirm this?

Cheers,

Alex Neto

A ter, 26/03/2019, 13:21, Marco Antônio Ferreira Pedrosa <
marcomottim at gmail.com> escreveu:

> Hi Andreas,
>
> Thanks, it will be useful!!
>
> Best regards!
>
>
> --
>
> Marcão
>
>
> skype: marco.afp
>
>
> Em ter, 26 de mar de 2019 às 10:14, Andreas Neumann <a.neumann at carto.net>
> escreveu:
>
>> Hi,
>>
>> It would be a join without a where clause, but limiting to the attribute
>> columns that are relevant. See
>> http://www.sqlitetutorial.net/sqlite-cross-join/
>>
>> You would have to create a new virtual table in QGIS for it. See
>> https://docs.qgis.org/3.4/en/docs/user_manual/managing_data_source/create_layers.html#creating-virtual-layers
>>
>> After creating that new virtual layer you can use it as Atlas coverage
>> layer.
>>
>> Greetings,
>>
>> Andreas
>>
>> On 2019-03-26 13:56, Marco Antônio Ferreira Pedrosa wrote:
>>
>> Hi Andreas,
>>
>> How can I create and use a cross-join in this case? (I think it would be
>> useful for the other tasks that I have to work on)
>>
>> Tnks in advance.
>>
>> --
>>
>> Marcão
>>
>> Em ter, 26 de mar de 2019 às 09:46, Andreas Neumann <a.neumann at carto.net>
>> escreveu:
>>
>>> Hi,
>>>
>>> Atlas with combinations of two or more attributes, and/or sometimes also
>>> feature geometries - this is a typical case for a cross-join in a database.
>>> You would create a new view as a cross-join with all combinations.
>>>
>>> But glad that you already found a solution.
>>>
>>> Greetings,
>>> Andreas
>>>
>>> On 2019-03-26 13:43, Marco Antônio Ferreira Pedrosa wrote:
>>>
>>> Hi Alexandre,
>>>
>>> It worked perfectly! As you said:
>>>
>>> 1) I made a unique list from the years and generate a new feature. Then
>>> used it as the coverage layer for atlas.
>>> 2) For each symboloy (rule-based):
>>>  (@atlas_pagename  =  "Year") AND ("Quality" = 'Excelent')
>>>  (@atlas_pagename  =   "Year"  ) AND ("Quality" = 'Good')
>>> so on...
>>>
>>> As you see I changed it a little bit, so I can use the "current" year
>>> from Atlas.
>>>
>>> Tnks a lot!
>>>
>>> P.S: PORTUGAL CARALHO!!!! (sou Brasileiro haha)
>>>
>>> --
>>>
>>> Marcão
>>>
>>> Em seg, 25 de mar de 2019 às 20:58, Alexandre Neto <
>>> senhor.neto at gmail.com> escreveu:
>>>
>>>> You need to create a layer, with a column called year, with each year
>>>> in a row. The layer does not need to have a geometry. Use that layer as the
>>>> coverage layer for atlas.
>>>>
>>>> For the layer you want to filter by year, create a rule-based
>>>> symbology, and use the following rule/expression:
>>>>
>>>> attribute(@atlasfeature, 'yea
>>>> r') = "year"
>>>>
>>>> This compares the current atlas feature field year, to the layer year
>>>> column, and renders the features only if the years match.
>>>>
>>>> Hope it helps.
>>>>
>>>> Alexandre Neto
>>>>
>>>> A seg, 25/03/2019, 13:50, Marco Antônio Ferreira Pedrosa <
>>>> marcomottim at gmail.com> escreveu:
>>>>
>>>>> Hi all,
>>>>>
>>>>> Sorry if s a silly question!
>>>>>
>>>>> How to generate an atlas by a value in the attibute table? (i.e:
>>>>> Year). QGIS Atlas would generate one map for each attribute value but not
>>>>> group by year.
>>>>>
>>>>> For each year, I want to show the features with a categorized
>>>>> symbology (same for all years, but I want to show just the features from
>>>>> that year).
>>>>>
>>>>> tnks in advance!
>>>>> _______________________________________________
>>>>> Qgis-user mailing list
>>>>> Qgis-user at lists.osgeo.org
>>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>>> --
>>>> Alexandre Neto
>>>> ---------------------
>>>> @AlexNetoGeo
>>>> http://sigsemgrilhetas.wordpress.com
>>>> http://gisunchained.wordpress.com
>>>>
>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>>
>>>
>> --
Alexandre Neto
---------------------
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190326/c52689dc/attachment.html>