[Qgis-user] Automating creation of county distribution maps

[chris hermansen]

Mike and list,

On Thu, Mar 10, 2022 at 5:07 AM Mike Breiding - Morgantown WV via Qgis-user
<qgis-user at lists.osgeo.org> wrote:

> I appreciate you taking the time for writing such a detailed set of
> instructions.
> However, it is quicker for me to do it manually.
>
> If the process could be automated then of course it would be a different
> matter.
> I am working only with the ferns - less than a hundred records.
> The flower plants are over 2500.
>

Perhaps others are better understanding how you want to visualize the
distributions, but what I get from your description is that if you have 100
(or 2500) species then you will have 100 (or 2500) maps, which sounds
unwieldy to me.

This paper
https://www.sciencedirect.com/science/article/pii/S1574954116300097 might
have some interesting suggestions for you.

Taken as a database design question, the idea of having 100 columns to
record the presence or absence of each species is not elegant.  A more
normalized approach would be to have your geometry table (geometry of
counties and unique key, perhaps county name) and a separate table with
multiple rows per county, one for each species present, along with the
county unique key, and then a one-to-many table join between the two.

Of course this doesn't necessarily help with the business of visualizing
the data...


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220310/c69e1870/attachment.html>