[Qgis-user] Atlas by year
Andreas Neumann
a.neumann at carto.net
Tue Mar 26 06:14:34 PDT 2019
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190326/2a1dec93/attachment.html>
More information about the Qgis-user
mailing list