<div dir="auto">Great, thanks for sharing !</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le sam. 12 mars 2022 à 10:43, Bernd Vogelgesang <<a href="mailto:bernd.vogelgesang@gmx.de">bernd.vogelgesang@gmx.de</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<p>Hi Mike and list,</p>
<p>I took the challenge and so far succeeded at the very moment. Mike sent me a (not so clean list) of species and counties.</p>
<p>My idea was to produce an atlas. (Actually, it should be made by a report, but since those are a bit quirky still, I went the pure atlas way)</p>
<p>It's a bit hacky, a more straightforward way would be nice.</p>
<p>
</p>
<p>- cleaning the data and importing them (table species/county, county polygons)
</p>
<p>- create table of individual species (toolbox "Delete duplicates by attribute") -> 101 unique species</p>
<p>- Setting up a relation between county layer and species/county-table on the county name</p>
<p>- new text field in county layer "species" : </p>
<p>relation_aggregate('name_of_relation',
'concatenate',
"species_names",
',')
</p>
<p>this creates a comma-separated list of species for each county polygon
</p>
<p>Prepare Atlas</p>
<p>Coverage layer: (fake coverage, as it does not move)
</p>
<p>- create bounding box of the county-layer (Extract layer extent)</p>
<p>- take list of individual species and add the geometry: retrieved the wkt of the extent in the field calculator -> "Geometry by expression": geom_from_wkt('Polygon ((355937 4117435, 782844 4117435, 782844 4498773, 355937 4498773, 355937 4117435)')</p>
<p>-> 101 extents with species name as atlas coverage</p>
<p>
</p>
<p>- create new map layout</p>
<p>- Activating atlas, setting species name-field as page name
</p>
<p>
</p>
<p>- duplication of the county-layer and setting up a rule based style: </p>
<p>visible: array_contains( string_to_array( "species_names",','), @atlas_pagename) </p>
<p>invisible: else</p>
<p>this query will look for the pagename (= species name) in the array of species names in the county polygons, and if the name is in, then the polygon is shown in grey, alse transparent.
</p>
<p>add text field @atlas_pagename</p>
<p>set atlas output filename to @atlas_pagename</p>
<p>Export atlas as images</p>
<p>DONE
</p>
<p>
</p>
<p>Question: is there a way to aggregate the species per county without setting up that relation beforehand? This is an extra step which would be nice if it could be circumvented by some cool function.</p>
<p>Any ideas or comments?
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p></p>
<p>
</p>
<p>
</p>
<p>
</p>
<div>Am 12.03.22 um 10:04 schrieb Jésahel
Benoist via Qgis-user:<br>
</div>
<blockquote type="cite">
<div dir="auto">Hello Mike,
<div dir="auto"><br>
<div dir="auto">I tried to follow your question and the most I
read the less I understand !</div>
<div dir="auto">Could you simply explain what you want to see,
what action the user have to do and what he gets?</div>
<div dir="auto">For this, try to give input data and what will
link them : plants (table with plant name and states
distribution?), states (geometric data with states names?),
columns to link...</div>
<div dir="auto">The good point is that I'm sure QGIS can do
this. But nobody will engage work if objective isn't precise
enough.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Regards,</div>
<div dir="auto"><br>
</div>
<div dir="auto">J. B. </div>
<br>
<br>
<div class="gmail_quote" dir="auto">
<div dir="ltr" class="gmail_attr">Le ven. 11 mars 2022 à
21:50, Mike Breiding - Morgantown WV via Qgis-user <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">qgis-user@lists.osgeo.org</a>>
a écrit :<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I had
the range USA range map in the screen shot and have since
updated <br>
it. <a href="https://photos.app.goo.gl/ktn5quT6s6SRwrzBA" rel="noreferrer noreferrer noreferrer" target="_blank">https://photos.app.goo.gl/ktn5quT6s6SRwrzBA</a><br>
WV-Mike<br>
------------<br>
On 3/10/2022 11:04 AM, chris hermansen wrote:<br>
> Perhaps others are better understanding how you want
to visualize the <br>
> distributions, but what I get from your description
is that if you have <br>
> 100 (or 2500) species then you will have 100 (or
2500) maps, which <br>
> sounds unwieldy to me.<br>
<br>
I neglected to mention the use for the distribution maps.<br>
They will be used in a print brochure.<br>
A page mock up can be seen here:<br>
<a href="https://photos.app.goo.gl/ktn5quT6s6SRwrzBA" rel="noreferrer noreferrer noreferrer" target="_blank">https://photos.app.goo.gl/ktn5quT6s6SRwrzBA</a><br>
<br>
The USA distribution map in the mock up was made in Qgis
using the <br>
information from:<br>
<a href="https://plants.usda.gov/home/plantProfile?symbol=BODI2" rel="noreferrer noreferrer noreferrer" target="_blank">https://plants.usda.gov/home/plantProfile?symbol=BODI2</a><br>
<br>
This is interactive and will display down to the state and
county level.<br>
However, they are not up to date at the state/county
level. If they were <br>
I would simply make a screen shot and that would be the
end of it.<br>
<br>
The state distribution map used in the mock up was made
using Qgis based <br>
on data from the West Virginia University Herbarium which
has the most <br>
up to date information on distribution.<br>
<br>
WV-Mike<br>
<br>
<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" rel="noreferrer noreferrer" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">Qgis-user@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</div>
</blockquote></div>