<html><head></head><body>Have you tried the versioning command in db manager?<br>Cheers.<br><br><div class="gmail_quote">On 14 November 2020 08:47:08 CET, Richard Duivenvoorde <rdmailings@duif.net> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">On 11/14/20 12:11 AM, Vanildo Heleno Pereira wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">Hello everyone.<br>I would like to know if there is a possibility to work with historical versions of geographic data in QGIS / PostGIS?<br>The geometries need to be stored in a single database table (PostgreSQL) and you will receive data (new records from the same location) annually and I need to visualize each one in a different layer.<br></blockquote><br>Hi Vanildo,<br><br>What do you mean with 'historical version of geographical data'?<br>Is it that you have different versions of a certain geometric feature (be it a border, a street or an animal), and that versions actually has (should have) 2 (date)time columns, being 'first appearance' and 'last appearance'?<br>If so, this kind of data is to be viewed in a sort of 'time-frames'?<br><br>So say you have a set of streetdata, you could show a layer as: show me streets all streets of 1800-1900 as a dataset in which you have a filter like (first_appeareance > 1800 AND < 1900) or (last_appearance > 1800 AND < 1900) (or variations like this).<br>Then you can create views in the database with these filter queries, but you can also do that in different layers in QGIS (both if you want to be able to show different timeframes at a time)<br><br>You could also do this using the 'temporal controller' which is now in QGIS, then you kan keep it one layer and use the controller to show one certain 'time frame' at a time.<br><br>Or do I misunderstand you question?<br><br>Regards,<br><br>Richard Duivenvoorde<hr>Qgis-user mailing list<br>Qgis-user@lists.osgeo.org<br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre></blockquote></div><br>-- <br>Please excuse my brevity.</body></html>