Questions tagged [update-query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
2answers
55 views

Perform query on multiple tables

I need to apply the following query to 60+ tables: UPDATE variable_table_name ab SET elem_nr = ef.elem_nr FROM ga_mit_elemnr ef WHERE (ab.elem_nr NOT IN ( SELECT ...
3
votes
1answer
91 views

Displaying lines in QGIS from ST_MakeLine() not working with UPDATE, but works with CREATE TABLE

When using UPDATE to create geometries based on the SCHNUM (school number) of students to their attend school, not all the lines show up in QGIS. However, when the basic query result is written to a ...
0
votes
0answers
666 views

Update table with condition from another table in postgresql

I have two table name servers and sites. Servers contains timing and workmode and geometry values. Where sites contains geometry values and an empty time_stamp column. I want to fill this timing ...
0
votes
1answer
530 views

Update MGRS coordinates in Attribute table

How can I update MGRS coordinates in the attribute table of a point feature, when the position of points has been added without using a tool that creates a new feature? I am not using a special ...
0
votes
1answer
275 views

Update query on QGIS 2.14.13 [closed]

I am currently using QGIS and it's database tool with custom plugins. I have to update a specific Table using an SQL query but I cannot use Database specific programs like PostGIS. Here is the test ...
1
vote
1answer
46 views

Altering PostGIS table with X and Y values of lines

I have a PostGIS table of a road network. The roads have topology and have been split with pgr_nodeNetwork. I also have source and target columns for each of the road segment. I want to be able to ...
3
votes
1answer
1k views

How to update SQL query for a virtual layer?

I created a virtual layer which contains all the geometries and attributes from a shapefile using the following code: vlayer = QgsVectorLayer( "?layer=ogr:path/to/shapefile", "layerName", "virtual" ) ...
1
vote
0answers
153 views

Update query adding values from multi column case statement in QGIS

I am looking to calculate a single value from four columns using a CASE WHEN statement for each of four columns. For example, column a,b,c,d have numeric values and I want to classify them and sum the ...