First of all, great video. We’ve been using this combo for a while in my company, but I’m wondering… how do you deal with complex layer styling, which is possible in QGIS but not in SLD?
Thanks! It's always nice to hear that our hard is appreciated. That is a great question. SLD styling has many limits so we try to keep it simple. We typically encounter two major limits: (1) complex symbology and (2) complex rule-based styling that combines multiple fields (e.g. if it's blue, type 7, and was installed on a Tuesday, make it green). The first one we have to choose to simplify the symbology to get as close to the QGIS style as we can. The second we will typically make a "style" or "label" field in the table that is populated by a trigger function, then we style or label using that field. IF, however, your data is fairly static, you could always create MBTiles in QGIS and serve that via Geoserver to get the exact QGIS symbology, but that comes with some significant limits. Happy to talk more about this if you reach out to us at lunageo.com
Can you briefly speak to the advantages of GeoServer when compared to other open source alternatives like the pairing of QGIS server/ Qgis Web Client 2?
There are a lot of open source webGIS solutions out there. We tend to build custom solutions using Geoserver. QGIS Server can do some of what Geoserver can do (e.g. WMS, WFS, WMTS, etc.), but Geoserver is a far more robust application. Unfortunately, we have not used the QGIS Web Client 2.
@@lunageospatial Appreciate your reply! I will have to try Geoserver out. I am currently building an enterprise GIS system (for fun) using QGIS Server and QWC2 and hosting it in Azure. The documentation on QWC2 and QGIS Server is a bit sparse, but I am slowly figuring it all out. QWC2 also has a Docker version built with containerized microservices that I have not yet experimented with.
Just an update to this - QWC2 ended up not being mature enough (in my view) for production. I did get it running but ran into all sorts of undocumented errors and bugs. I ended up going with GeoServer Cloud Native, which is still in its early days, but it was a lot easier to deploy and configure and it got me up and running in a test environment for my personal projects. I then built an OpenLayers front end which was simple enough.
What are your preferred solutions for a web front end content management and delivery? I've now successfully built a simular system hosted on Azure using PostgreSQL/Geoserver Cloud Native and am using OpenLayers to make my front end web map and it works fine for me, but I am wondering if there is a no-code or low-code Open Source web front end that would contain a collection of maps and data in a single portal that doesnt require custom web coding.
I just watched your BC video and you answered this question in that video. For anyone wondering, options are Leaflet/Open Layers for the maps and GeoNode for a web content portal.
@@devoidbmx1 The short answer is that there isn't a single low or no code solution for WebGIS, which is why we build custom solutions for our clients. Geonode is one option, but the setup is not for the faint of heart. There are a few other projects on the OSGeo website www.osgeo.org.
Excellent demo and tutorial on QGIS and PostGIS. People spend thousands of $ just to have half the ease and functionalities of this duo. Kudos!
😂 hundred thousands if you think about ESRI enterprise
God knows how many time I have watched this video...Kudos, Bravo 👏🏿
When ever I have watched your video. It is seem to be like useful. thank you very much for sharing video pls keep on upload more clips
First of all, great video. We’ve been using this combo for a while in my company, but I’m wondering… how do you deal with complex layer styling, which is possible in QGIS but not in SLD?
Thanks! It's always nice to hear that our hard is appreciated. That is a great question. SLD styling has many limits so we try to keep it simple. We typically encounter two major limits: (1) complex symbology and (2) complex rule-based styling that combines multiple fields (e.g. if it's blue, type 7, and was installed on a Tuesday, make it green). The first one we have to choose to simplify the symbology to get as close to the QGIS style as we can. The second we will typically make a "style" or "label" field in the table that is populated by a trigger function, then we style or label using that field. IF, however, your data is fairly static, you could always create MBTiles in QGIS and serve that via Geoserver to get the exact QGIS symbology, but that comes with some significant limits. Happy to talk more about this if you reach out to us at lunageo.com
Awesome!
Can you briefly speak to the advantages of GeoServer when compared to other open source alternatives like the pairing of QGIS server/ Qgis Web Client 2?
There are a lot of open source webGIS solutions out there. We tend to build custom solutions using Geoserver. QGIS Server can do some of what Geoserver can do (e.g. WMS, WFS, WMTS, etc.), but Geoserver is a far more robust application. Unfortunately, we have not used the QGIS Web Client 2.
@@lunageospatial Appreciate your reply! I will have to try Geoserver out. I am currently building an enterprise GIS system (for fun) using QGIS Server and QWC2 and hosting it in Azure. The documentation on QWC2 and QGIS Server is a bit sparse, but I am slowly figuring it all out. QWC2 also has a Docker version built with containerized microservices that I have not yet experimented with.
Just an update to this - QWC2 ended up not being mature enough (in my view) for production. I did get it running but ran into all sorts of undocumented errors and bugs. I ended up going with GeoServer Cloud Native, which is still in its early days, but it was a lot easier to deploy and configure and it got me up and running in a test environment for my personal projects. I then built an OpenLayers front end which was simple enough.
What are your preferred solutions for a web front end content management and delivery? I've now successfully built a simular system hosted on Azure using PostgreSQL/Geoserver Cloud Native and am using OpenLayers to make my front end web map and it works fine for me, but I am wondering if there is a no-code or low-code Open Source web front end that would contain a collection of maps and data in a single portal that doesnt require custom web coding.
I just watched your BC video and you answered this question in that video. For anyone wondering, options are Leaflet/Open Layers for the maps and GeoNode for a web content portal.
@@devoidbmx1 The short answer is that there isn't a single low or no code solution for WebGIS, which is why we build custom solutions for our clients. Geonode is one option, but the setup is not for the faint of heart. There are a few other projects on the OSGeo website www.osgeo.org.