Re: [Qgis-user] question abot shapes
Good morning, 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: 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. Thank you for your help, Kind regards Sylvain Ard Sylvain Ard 0549507724 0778380991 sylvain@gmail.com http://sylvain-ard.fr Entreprise individuelle SIRET : 80079243400022 Appt 26 Bât A Résidence Le Patio 83 rue de la Bugellerie 86000 Poitiers Le mar. 12 mars 2024 à 08:28, Régis Haubourg via QGIS-User < qgis-user@lists.osgeo.org> a écrit : > What is your question Sylvain? > > This is unclear > > Regards > > > On 08/03/2024 17:15, Sylvain Ard via QGIS-User wrote: > > > Good morning, > 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: > 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. > Thank you for your help, Kind regards > Sylvain Ard > > 0549507724 > 0778380991 > sylvain@gmail.com > http://sylvain-ard.fr > Entreprise individuelle SIRET : 80079243400022 > Appt 26 Bât A Résidence Le Patio > 83 rue de la Bugellerie > 86000 Poitiers > > ___ > QGIS-User mailing listqgis-u...@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > ___ > QGIS-User mailing list > QGIS-User@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] question abot shapes
What is your question Sylvain? This is unclear Regards On 08/03/2024 17:15, Sylvain Ard via QGIS-User wrote: Good morning, 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: 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. Thank you for your help, Kind regards Sylvain Ard 0549507724 0778380991 sylvain@gmail.com http://sylvain-ard.fr Entreprise individuelle SIRET : 80079243400022 Appt 26 Bât A Résidence Le Patio 83 rue de la Bugellerie 86000 Poitiers ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info:https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] question abot shapes
I precise that I want to do it on a command line web server so I have no GUI, I think about a script Sylvain Ard 0549507724 0778380991 sylvain@gmail.com http://sylvain-ard.fr Entreprise individuelle SIRET : 80079243400022 Appt 26 Bât A Résidence Le Patio 83 rue de la Bugellerie 86000 Poitiers Le ven. 8 mars 2024 à 18:58, chris hermansen a écrit : > Sorry everyone, pressed "send" too early! > > On Fri, Mar 8, 2024 at 9:55 AM chris hermansen > wrote: > >> Sylvain and list, >> >> On Fri, Mar 8, 2024 at 8:15 AM Sylvain Ard via QGIS-User < >> qgis-user@lists.osgeo.org> wrote: >> >>> >>> Good morning, >>> 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: >>> 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. >>> >> >> I don't have a "follow this recipe" answer for you, but I wonder if you >> have looked at "heat maps" as a general concept and thought about how that >> might apply to your needs. >> >> For example, there is this interesting discussion on StackExchange about >> density of bomb craters: >> >> https://gis.stackexchange.com/questions/385338/point-density-map-in-qgis >> >> Also worth learning about is how QGIS handles point clouds and whether > that might apply to solving your problem > > > https://docs.qgis.org/3.34/en/docs/user_manual/working_with_point_clouds/point_clouds.html > > -- > Chris Hermansen · clhermansen "at" gmail "dot" com > > C'est ma façon de parler. > ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] question abot shapes
Sorry everyone, pressed "send" too early! On Fri, Mar 8, 2024 at 9:55 AM chris hermansen wrote: > Sylvain and list, > > On Fri, Mar 8, 2024 at 8:15 AM Sylvain Ard via QGIS-User < > qgis-user@lists.osgeo.org> wrote: > >> >> Good morning, >> 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: >> 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. >> > > I don't have a "follow this recipe" answer for you, but I wonder if you > have looked at "heat maps" as a general concept and thought about how that > might apply to your needs. > > For example, there is this interesting discussion on StackExchange about > density of bomb craters: > > https://gis.stackexchange.com/questions/385338/point-density-map-in-qgis > > Also worth learning about is how QGIS handles point clouds and whether that might apply to solving your problem https://docs.qgis.org/3.34/en/docs/user_manual/working_with_point_clouds/point_clouds.html -- Chris Hermansen · clhermansen "at" gmail "dot" com C'est ma façon de parler. ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] question abot shapes
Sylvain and list, On Fri, Mar 8, 2024 at 8:15 AM Sylvain Ard via QGIS-User < qgis-user@lists.osgeo.org> wrote: > > Good morning, > 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: > 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. > I don't have a "follow this recipe" answer for you, but I wonder if you have looked at "heat maps" as a general concept and thought about how that might apply to your needs. For example, there is this interesting discussion on StackExchange about density of bomb craters: https://gis.stackexchange.com/questions/385338/point-density-map-in-qgis -- Chris Hermansen · clhermansen "at" gmail "dot" com C'est ma façon de parler. ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
