Timeline for Create view table with QGIS and Geopackage
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 4, 2021 at 8:03 | history | edited | Zev_Zide | CC BY-SA 4.0 |
deleted 1 character in body
|
| Mar 3, 2021 at 20:36 | comment | added | Denilson | Follow to make QGIS see the views byDB Browser SQLite --1 - GPKG with spatial layers, ST and EB tables --2 - With DB Browser, Create a view. Example : CREATE VIEW EB_VW AS select E.* FROM EB as E, (select distinct uf, munic from ST) As S where E.uf = S.UF --3 - Edit the table gpkg_content with the view name and their parameters. EB_VW , Features , EB_VW , 2020-03-25T16:17:53.869Z , -73.99 , -33.75, -28.83 , 5.27 , 4674 --4 - Edit the tables gpkg_geometry_columns. EB_VW , geom , MULTIPOLYGON , 4674 , 0 , 0 | |
| Mar 3, 2021 at 9:01 | history | edited | Zev_Zide | CC BY-SA 4.0 |
added 121 characters in body
|
| Mar 1, 2021 at 10:48 | review | Late answers | |||
| Mar 1, 2021 at 11:01 | |||||
| Mar 1, 2021 at 10:30 | review | First posts | |||
| Mar 1, 2021 at 11:02 | |||||
| Mar 1, 2021 at 10:21 | history | answered | Zev_Zide | CC BY-SA 4.0 |