I'd like some general advice on creating dynamic maps. I have a bunch of geospatial points saved on SQL Server and PostgreSQL. People will enter new data into the databases from time to time. I want those points to be automatically plotted into a series of base layers I have already created with QGIS. The plotting does not have to be instantaneous, but it would be nice if the map was updated every day. I've got a few
Right now, I am thinking the best thing for me to do would be learning
geoalchemy2 on python to create the type of map I want to create. I'm pretty sure
geoalchemy2 can do this, but could anyone confirm?