<div dir="ltr">Good morning,<br>I have a PostgreSQL database of several million points with latitude/longitude and I would like to do the following with qgis-server or PostGis:<br>according to a number of shapes (hexagons, circles or squares) per mesh, calculate the number of points per shape and color the shape darker as there are points underneath. If there are no points the shape should not appear. If we zoom in, the meshes must be recalculated and reduced of course. On the other hand I would like a leaflet basemap.<br>Thank you for your help, Kind regards<br clear="all"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div><div><div>Sylvain Ard</div></div></div></div></div></div></div></div></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div><div><div>Sylvain Ard<br>0549507724<br>0778380991</div><div><a href="mailto:sylvain.ard@gmail.com" target="_blank">sylvain.ard@gmail.com</a></div><div><a href="http://sylvain-ard.fr" target="_blank">http://sylvain-ard.fr</a><br></div>Entreprise individuelle SIRET : 80079243400022<br></div>Appt 26 Bât A Résidence Le Patio<br></div>83 rue de la Bugellerie<br></div>86000 Poitiers<br></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mar. 12 mars 2024 à 08:28, Régis Haubourg via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div>
<p>What is your question Sylvain? </p>
<p>This is unclear <br>
</p>
<p>Regards</p>
<p><br>
</p>
<div>On 08/03/2024 17:15, Sylvain Ard via
QGIS-User wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr"><br>
Good morning,<br>
I have a PostgreSQL database of several million points with
latitude/longitude and I would like to do the following with
qgis-server or PostGis:<br>
according to a number of shapes (hexagons, circles or squares)
per mesh, calculate the number of points per shape and color the
shape darker as there are points underneath. If there are no
points the shape should not appear. If we zoom in, the meshes
must be recalculated and reduced of course. On the other hand I
would like a leaflet basemap.<br>
Thank you for your help, Kind regards<br>
<div>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div>
<div>
<div>Sylvain Ard</div>
<div><br>
0549507724<br>
0778380991</div>
<div><a href="mailto:sylvain.ard@gmail.com" target="_blank">sylvain.ard@gmail.com</a></div>
<div><a href="http://sylvain-ard.fr" target="_blank">http://sylvain-ard.fr</a><br>
</div>
Entreprise individuelle SIRET : 80079243400022<br>
</div>
Appt 26 Bât A Résidence Le Patio<br>
</div>
83 rue de la Bugellerie<br>
</div>
86000 Poitiers<br>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
QGIS-User mailing list
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<div id="m_4623338306974153024grammalecte_menu_main_button_shadow_host" style="width:0px;height:0px"></div>
</div>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="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" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div>