Questions tagged [update-query]
The update-query tag has no summary.
14 questions
0
votes
1
answer
77
views
System.FormatException: 24141: A number is expected at position 28 of the input
I'm trying to update the WKT of a record in SSMS version 20. Below is the wkt of the linestring geometry.
Use GisFoxMain;
DECLARE @mainGeom geometry;
DECLARE @
centerPoint geometry;
SET @mainGeom = ...
- 1
1
vote
1
answer
94
views
Automatic updating of column
Have come across a problem in Qgis (3.16.9)
I have a geometry layer (A) with lines and a csv file (B) with prices. I have a joint so the price from the csv file (B) comes over in the geometry file (A)....
4
votes
1
answer
859
views
Update array geometry field using array lat & long field in PostGIS
I have two array columns in Postgres named lat and long. Both have 1-5 values in their array field. Like the following
Now I need to create geometry from each value based on the array index of lat &...
- 177
1
vote
1
answer
105
views
Invalid SQL statement for Text columns lookup
I'm working in ArcGIS Pro and writing rows from a source file with Text data type field to another text field in a target file but it generates an error as such:
An invalid SQL statement was used. [...
-2
votes
1
answer
205
views
SQL statement (where_clause) does not work for UpdateCursor syntax but same works for SearchCursor syntax
feature class fc1 (daily data) and feature class fc2 (geodatabase) both have unique_id field which will be used to map Col1 rows in fc1 to update corresponding Col2 rows (not all rows) in fc2. Below ...
1
vote
0
answers
52
views
Updating and merging geometries using a 3rd table as the connector
I'm looking for some help with the following.
I have 3 tables in my Oracle Database.
Table A:
IDnumber Geometry
001 Geom1
002 Geom2
003 Geom3
Table B:
IDnumber Fieldnumber (...
- 11
2
votes
2
answers
1k
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 elem_nr FROM ...
- 23
3
votes
1
answer
409
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 ...
- 19.1k
0
votes
0
answers
797
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 ...
- 547
1
vote
1
answer
2k
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 ...
- 31
0
votes
1
answer
549
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 ...
- 481
1
vote
1
answer
76
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 ...
- 497
5
votes
1
answer
3k
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" )
...
- 76.7k
1
vote
0
answers
200
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 ...
- 9,597