Re: [Qgis-user] Historical data in QGIS-PostGIS

On 11/14/20 12:11 AM, Vanildo Heleno Pereira wrote: > Hello everyone. > I would like to know if there is a possibility to work with historical > versions of geographic data in QGIS / PostGIS? > The geometries need to be stored in a single database table (PostgreSQL) and > you will receive data

Re: [Qgis-user] Historical data in QGIS-PostGIS

Brent, Vanildo, list; On Fri, Nov 13, 2020 at 5:23 PM Brent Wood wrote: > I think this is straightforward, if I understand you correctly... > > Assuming each year comprises a separate version of the data, have the year > as a column in the table, which allows you to select by year, group by

Re: [Qgis-user] Historical data in QGIS-PostGIS

I think this is straightforward, if I understand you correctly... Assuming each year comprises a separate version of the data, have the year as a column in the table, which allows you to select by year, group by year in the database, on an indexed integer value, which is very fast. In terms of

Re: [Qgis-user] Historical data in QGIS-PostGIS

Vanildo and list; On Fri, Nov 13, 2020 at 3:11 PM Vanildo Heleno Pereira wrote: > Hello everyone. > I would like to know if there is a possibility to work with historical > versions of geographic data in QGIS / PostGIS? > The geometries need to be stored in a single database table (PostgreSQL)

[Qgis-user] Historical data in QGIS-PostGIS

Hello everyone. I would like to know if there is a possibility to work with historical versions of geographic data in QGIS / PostGIS? 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

Re: [Qgis-user] Add Layer Search to Toolbar

QGIS allows you to setup relations between different data sources. But of course you need common keys to link the tables. So you could have a relation between a Oracle DB and a CSV file. But you need to setup this relation with the foreign key manually in menu "Project" --> "Properties" -->

Re: [Qgis-user] Update second table

they are not in the same database at the same datebase-server :-( i forgot to tell ... Am 13.11.2020 um 17:02 schrieb chris hermansen: L.W. and list On Fri, Nov 13, 2020, 06:39 L.W. mailto:eagl...@gmx.de>> wrote: hi, can I update a second table autom. if the value of first table

Re: [Qgis-user] Add Layer Search to Toolbar

thats true, but i need to add the foreign key to work with this relation. Am 13.11.2020 um 17:10 schrieb Andreas Neumann: Hi, To me this sounds like you want to set up a relation and define forms with relation reference and relation widgets (with or without embedded forms). In the project

Re: [Qgis-user] Add Layer Search to Toolbar

Hi, To me this sounds like you want to set up a relation and define forms with relation reference and relation widgets (with or without embedded forms). In the project settings you can define relations between tables and once you have defined them, they appear in the forms section of the

Re: [Qgis-user] Add Layer Search to Toolbar

Use-Case: I add a Point on map, the attribute-editor opens and I give some Data to it. want-to-have: I want to add a foreign-Key id, but can not add a search-form in this gui. so my idea was to search in the foreign table with a search-term and get the id of the found row. with this id I can

Re: [Qgis-user] Add Layer Search to Toolbar

Please describe your use-case more specific. What is the end result you want: - a location? - a value of a record (but not the one you search for? Can you use the filter function in the table? And maybe dock the table as a dockwidget? Can you implement a 'locator' yourself (python coding)? Or

Re: [Qgis-user] Add Layer Search to Toolbar

and this is the point: "With f @columname you search in the values of 'columname' in current active layer" I do want to search every time independant of the active layer ... and the search-field is not the result-field I need. Am 13.11.2020 um 16:37 schrieb Richard Duivenvoorde: Have a look

Re: [Qgis-user] Add Layer Search to Toolbar

Have a look in the settings/configure (right mouse context in the locator bar). With f ... you search in current active layer With f @columname you search in the values of 'columname' in current active layer (same with 'af' but then for all layers) See

Re: [Qgis-user] Add Layer Search to Toolbar

no, I have never used it, but, there are a hugh list of layers in my project and it seemed that I can not search in a specific layer. I only need result of one field displayed in a text field. Am 13.11.2020 um 16:24 schrieb Jorge Gustavo Rocha: Hi L.W., You already have a search toolbar, at

Re: [Qgis-user] Add Layer Search to Toolbar

Hi L.W., You already have a search toolbar, at the lower left corner. There are several search options. Have you tried them? Regards, Jorge Gustavo Às 14:39 de 13/11/20, L.W. escreveu: > Hi, > > is there a default option / way to have a textfield for searching in a > layer at the toolbar (or

[Qgis-user] Add Layer Search to Toolbar

Hi, is there a default option / way to have a textfield for searching in a layer at the toolbar (or dock-window)? Ill like to get the "fieldname"-value of the found dataset / attribute. regards ___ Qgis-user mailing list Qgis-user@lists.osgeo.org

[Qgis-user] Update second table

hi, can I update a second table autom. if the value of first table changes? regards ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe:

Re: [Qgis-user] Dynamic Line

Hi Nicolas, Yes - but that doesn't magically turn a "non geometry" table into a "geometry table" - as far as I know. So you probably need to create a "Virtual Layer" and create the geometry similar to what you propose. Andreas Am 13.11.20 um 15:22 schrieb Nicolas Cadieux: Hi, You can

Re: [Qgis-user] Dynamic Line

Hi, You can create a geometry from WKT if you have x and y fields using and expression in the field calculator. geom_from_wkt('POINT('||"x"||' '||"y"||')') https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry Nicolas Cadieux > Le 13 nov. 2020 à 09:07, Andreas Neumann a

Re: [Qgis-user] Dynamic Line

Hi Neither GeometryGenerators nor Vector Field Markers work on tables without geometry, unfortunately. You didn't inform us, that you don't have geometry in your table. You can, however, create a "Virtual Layer" and write some SQL to create a geometry from your attributes: menu "Layer" -->

Re: [Qgis-user] Dynamic Line

Does it works on Layers with no geometry? My layers do not have a geometry. Am 13.11.2020 um 11:56 schrieb Andreas Neumann: Yes, you need point data to start from, but then vectors can bei/are generated from the attributes you mentioned. Andreas Am 13.11.20 um 11:47 schrieb L.W.: from

Re: [QGIS-it-user] somme le aree nel poligono

pierluigi de rosa-2 wrote > Buongiorno, > > premetto che ci sono tante strade per risolvere il problema ma stavo > cercando di capire come potevo affrontare la cosa con il calcolatore di > campi. > > Ho due layer poligonali. Uno sono i limiti comunali e l'altro solo le aree > agricole. > Voglio

[QGIS-it-user] somme le aree nel poligono

Buongiorno, premetto che ci sono tante strade per risolvere il problema ma stavo cercando di capire come potevo affrontare la cosa con il calcolatore di campi. Ho due layer poligonali. Uno sono i limiti comunali e l'altro solo le aree agricole. Voglio nella tabella dei comuni la somma delle aree

Re: [Qgis-user] Dynamic Line

Yes, you need point data to start from, but then vectors can bei/are generated from the attributes you mentioned. Andreas Am 13.11.20 um 11:47 schrieb L.W.: from the docs ... It can only be used to render point data 12.2.2.2.6.The Vector Field Marker

Re: [Qgis-user] Dynamic Line

from the docs ... It can only be used to render point data 12.2.2.2.6.The Vector Field Marker The vector field marker is used to display vector field data such as earth

Re: [Qgis-user] Dynamic Line

Or even easier: use the "Vector Field Marker": https://docs.qgis.org/3.10/en/docs/user_manual/style_library/symbol_selector.html?#the-vector-field-marker Am 13.11.20 um 11:33 schrieb Andreas Neumann: Hi, Yes - you can use Geometry Generators for that. Use the make_point() and make_line()

Re: [Qgis-user] Dynamic Line

Hi, Yes - you can use Geometry Generators for that. Use the make_point() and make_line() expressions for that. See https://docs.qgis.org/3.10/en/docs/user_manual/style_library/symbol_selector.html?highlight=geometry%20generator#the-geometry-generator Greetings, Andreas Am 13.11.20 um

Re: [Qgis-user] Problems to upload *.nc files in QGIS ver 3.16

Great, thanks Pedro El jue., 12 nov. 2020 a las 15:28, Pedro Venâncio (< pedrongvenan...@gmail.com>) escribió: > It was already fixed in OGeo4W Carolina: > https://github.com/qgis/QGIS/issues/39729 > > Standalone shall be fixed in the next point release, next week. > > Best regards, > Pedro > >

[Qgis-user] Dynamic Line

Hi, is it possible to draw automatically a line between two points defined by 4 fields (x1,y1 - x2,y2) in an attributetable? but I do not want to add a line-layer based on this table nor want to draw the line by hand. thanks ___ Qgis-user mailing

[Qgis-user] Qgis startup crashes on Debian 10

Again as we saw with builds earlier this year, the latest 3.10.11 build will crash on startup. This happens on anything I can find running Debian 10. There aren't seen anything similar on Ubuntu. Is there likely to be some sort of issue with the build environment that affects Debian 10