Questions tagged [update]
The act or an instance of bringing something up to date.
258
questions
2
votes
1answer
21 views
StopIteration: iteration not started
I'm trying to update a given field in this case the last one of the table by concatenating all values in the row excepting null values or '' values.
So far when execute the code until line: print (...
1
vote
1answer
16 views
QGIS -> MySQL Updates
I added a MySQL layer containing GeoData to my QGIS 3 project.
I want this layer updated every time the database updates.
Is there a way to do that?
2
votes
1answer
36 views
Insert/Update/Delete table from another table changes in PostGIS
I'm trying to build a function that Insert/Update/Delete rows of a table based from another table changes. Unfortunately I could not continue, some problems occured:
DELETE isn't work correctly: Any ...
1
vote
1answer
56 views
Update PostgreSQL table; insert data from subquery, on conflict do update duplicate id
Context
I run into (some good old) troubles when trying to update a PostgreSQL (10.12) table called nodes containing nodes with some few attributes from OSM + some few others.
I only want to update ...
1
vote
0answers
14 views
Add Join Management and UpdateCursor in Arcpy
How to join multiple table with shapefile, update cursor specific field of the table in shapefile table and remove the join table? I write some script but it not work, please correct my script.
...
0
votes
1answer
40 views
How do I get the latest version of QGIS to find my plugins
I just downloaded QGIS 3.12.2-București for the Mac (MacOS Mojave 10.14.6, 3.2 GHz with 32 GB ram). I've been running an older version (QGIS 2.18.2-Las Palmas) for a couple of years and have quite a ...
0
votes
2answers
44 views
Updating QGIS from 2.8.1 Wien to 3.12.2 [closed]
I am relatively inexperienced in using GIS systems, but was able to make great use of QGIS several years ago to make distribution maps for my dissertation. I'd like to keep QGIS updated. What will ...
0
votes
1answer
10 views
Updating the file path for a Google Earth layer
I have exported a lot of our data from ArcMap to Google Earth. Most of our company prefers to use Google Earth for basic searches. The users within the company have downloaded a "Master" Google Earth ...
1
vote
1answer
279 views
Google Earth Engine Update
I've opened code editor in google earth engine. in console table this message has shown:
Attention Python and JavaScript client library users!
Earth Engine servers now require client library v0.1.215,...
2
votes
3answers
41 views
PostgeSQL Trigger St_Intersect Insert, Update
I have a problem creating a trigger in PostgreSQL that will get data from polygon layer.
Issue:
I have two tables:
1. point (id, geom, address)
2. polygon (id, geom, address)
Polygon table ...
0
votes
0answers
38 views
Updating GDAL to 3.0+ from 2.4.1 on MAC to create GEOPDF's in QGIS 3.10
Title more or less says it. I installed QGIS originally quite awhile ago and compiled it to GDAL version 2.4.1 that it was packaged with. Since then, all subsequent versions of QGIS have compiled to ...
0
votes
3answers
27 views
How to use range value in UpdateCursor in ArcMap
I am trying to add range value in attribute tables by using UpdateCursor module of data access (da).
import arcpy
mxd = arcpy.mapping.MapDocument("CURRENT")
lyr = arcpy.mapping.ListLayers(mxd)[0]
sql ...
0
votes
0answers
25 views
Problem updating Georeferencing for TIFF
When I update georeferencing for TIFFs, the map disappears and doesn't save. Auto adjust is off, rectify wont save, control points I can save seperately. Settings are set to documentation suggestions. ...
1
vote
1answer
30 views
Populate field based on value within a field in another table [closed]
I have two datasets: dat_1 and dat_2.
I would like to populate field_1 in dat_1 based on values within field_1 in dat_2. I don't know if i need it, but they have ogr_ID field in common, with the same ...
1
vote
1answer
31 views
Update field based on values in other fields using search and update cursors
I'm a Python beginner, I'm doing a risk analysis with a point feature, and I'm trying to write a script that allow me to update a field (proximity) based on different numeric values within different ...
3
votes
2answers
88 views
UpdateCursor for field calculation based on unique values
UPDATE TO PREVIOUS QUESTION: I have an address feature class. I want to use an UpdateCursor that focuses on two fields: StreetName and Block_ID. For every instance of a unique StreetName, I want the ...
3
votes
1answer
86 views
Keeping QGIS-projects up to date
Background: We're doing a lot of project work using QGIS. These projects are based on "template"-projects for administrative units, which are always kept up to date, e.g. new WMS are added, newly ...
0
votes
0answers
45 views
Overwriting geopackage with Python
I have a QGIS project file with a few geopackage vector layers. Each of them is stored in its own file.
I created the files using Python. Now I am considering updateing the files per script. Can I ...
0
votes
0answers
47 views
Updating table with GeometryFromText of PostGIS
I'm trying to update a column public_geometry in a table by creating a point from longitude and latitude cols from the same table. The database is PostgreSQL with Pgadmin as program to handle the ...
0
votes
1answer
51 views
Updating geomesa record using Geomesa-Accumulo and Spark with Java API?
I have found here how to save data using spark and geomesa accumulo. But I can't find anywhere how to update existing records.
I know that Accumulo is under the hood. Accumulo provides data ...
0
votes
0answers
46 views
How often are OSM data in Cesium updated with new OSM data?
When users make edits to OpenStreetMap(OSM), or OSM data gets updated by any other means, how long does it generally take for those edits to show up in Cesium Ion or Cesium Sandcastle? Is this on the ...
0
votes
0answers
93 views
Updating xy fields in attribute table automatically when moving points to new locations in ArcMap?
I work on ArcGIS Desktop 10.3.1 and try to move several points so they are corresponding simultaneously to the coordinates value in the attribute table immediately.
I know this question repeats in ...
4
votes
1answer
221 views
QGIS incredibly slow when trying to update large tables?
My point postgresql table has about 500k rows and about 20 columns
People have about 5 fields that they update, the other fields are static
Selecting the points is fairly instant, however using the ...
1
vote
1answer
40 views
Update a field from a PostgreSQL point table (wherever it's NULL) with certain field value from closest polygon?
Given a point table (table1) and a polygon table (table2) in PostgreSQL, I am trying to update a field from table1 wherever its value is NULL. This field should be updated with a certain field value (...
0
votes
0answers
38 views
Select domain's last update date
I have tables in an Oracle 18c GDB that I integrate to a work order management system.
I create views on the tables to translate the data. For example, I translate codes to domain descriptions.
I ...
0
votes
2answers
32 views
Update row based on order of parameter
I'm trying to add a field to a created feature class, then create a key based on whether the AccountNo is equal to the imputed Feature1 through 6. For example, if Feature1 is equal to the AccountNo ...
0
votes
0answers
30 views
Update shapefile attributes after update of data source
In a project the data is stored in a relational database (so it could be moved to PostgreSQL) for presentation in a web repository to be presented in diagrams, tables, etc. During the last months ...
0
votes
2answers
198 views
AGOL View layer symbology is not updated when updating hosted feature layer
I have a feature layer called map in AGOL. I want to change the symbology, so I open arcgis Pro and I open this map and overwrite it with new symbols.
I see that the feature layer in AGOL is updated ...
1
vote
0answers
75 views
Automatically update records in layer based on changes in another
I am using QGIS and I have two layers the first one is "Reading" layer with the attribute details
The second layer is "Reading_History" layer with the attribute details
I want to use the expression ...
0
votes
0answers
57 views
Clean update of QGIS LTR on Windows 10
I work in a company that uses QGIS on every computer. We chose to only install LTR versions as a precaution. So when the 3.4 version came out, we launched the installation on every computer. It was ...
1
vote
0answers
119 views
When appending new data (points) in AGOL, the new points dont show up in the map?
So my workflow was:
Open csv file in arcgis pro and plotting points on the map
Make a feature service and upload it to arcgis onine
Added 1 extra row to the csv file with new data.
Saved this csv ...
4
votes
1answer
60 views
Updating raster pixel values where they overlap with another raster band
I am trying to replace/update the raster pixel values of band '3' of a Land Cover Map to a new value of '24', but only where these pixels overlap with value '4' of another raster layer. How do I write ...
0
votes
1answer
77 views
Updating z value of geometry using updateCursor?
I am trying to update the Z value of a polygon using update Cursor and it just doesn't work!
I have been exploring this site and trying different codes without success.
I have a shapefile with ...
0
votes
0answers
17 views
Updating building data?
I need to update a building data (shapes) in ArcGIS Desktop.
One Shape is with the buildings of a city from 2012 and the otherone with the buildings of the same city from the year 2019 (perhaps 300....
0
votes
2answers
101 views
Trouble updating field calculatd by st_ functions
I had first run this code on several of my fields of my T1 table at the same time.
UPDATE table_1
SET field_1 = liste.my_bool
FROM(
SELECT T1.id AS name,
bool_or((ST_Contains(T2.geom, T1.geom)...
1
vote
2answers
57 views
Transferring Data From One Table to Another Using Multiple Keys in ArcPy?
I have data in one field and I want to transfer it to a specific field in another table based on specific keys Such as ID, road_type and veg_type.
My original table looks like this
ID Road_Type ...
0
votes
0answers
43 views
Updating .aprx file after creating new layer using ArcPy?
I use arcpy function XYTableToPoint_management() to create a new layer vessel_coordinate into the current active map, as shown below.
But when I list the layers in this map (map.listLayers()), I hope ...
2
votes
1answer
35 views
Updating field in geodatabase table depending on other field using ArcPy?
I have a table in a file geodatabase that has "FieldA" and "FieldB".
I want to update FieldB with one of two values, depending on if there are one or more records with the same value of FieldA.
...
1
vote
0answers
36 views
Adding updates to current QGIS version from later ones?
I am currently using version 3.4 of QGIS, and I was wondering if it is possible to implement all of the awesome changes from version 3.5, 3.6, etc. into version 3.4 or do I need to keep installing the ...
1
vote
1answer
154 views
Replacement for moveLayer in QGIS 3?
I am a novice to QGIS tasked with updating other developers' plugins from QGIS 2 to QGIS 3.
Here's the code I need to replace:
legend = self.iface.legendInterface()
index = legend.addGroup('...
0
votes
1answer
47 views
UpdateCursor giving ValueError: need more than 1 value to unpack?
I am writing a script assigning the ADMINAREA value to the empty LOCALITY fields from TWB_Suburbs to TWB_Property layer. I am getting:
ValueError: need more than 1 value to unpack
Is anyone able ...
1
vote
0answers
98 views
Updating identify tool every time feature is selected with PyQGIS3
I want to use the "Identify Feature Tool" in code (PyQGIS3). What I've found in the internet doesn't use the tool, people usually print in console point features and ids. I also found a tool that ...
1
vote
1answer
75 views
Trying to add a value in the second row of a table
I am trying to add a specific value to a cell of the second row of a feature-class-table. Doesn't work with my code:
#First row
rows = arcpy.InsertCursor(tb_value)
row = rows.newRow()
...
0
votes
0answers
194 views
Alter and update a shapefile with a field from an ASCII file using ogr
I have a vector file "map.shp" with a field ID.
I have an attribute table (data.txt) with the following fields: ID, value1, value2. The field ID is the same in both files.
I want to update map.shp by ...
1
vote
1answer
667 views
Adding a column and update values using SQL in QGIS
I have a vector file "data.shp" containing the following fields:
ID, value1, AREA
I want to add a new column "value2" and set it as value1/AREA. Since I want to do that for many columns and files I ...
0
votes
1answer
226 views
Update attributes with arcpy.updateCursor and updateRow
I need to update attributes with arcpy.updateCursor and updateRow based on a list of service numbers, but I can't even get one row to update. This is my beginner code.
df= r"GAS FEATURES\SERVICE ...
0
votes
0answers
284 views
How to update column based on data from another table (Mapinfo Pro)?
What I want to do is update column (Table A) by values from another table (Table B) using condition intersects. There are few objects in table B which intersects one object from table A. When I try to ...
2
votes
1answer
766 views
QProgressDialog in QGIS 3.0 not updating
I am using a QProgressDialog to show the progress of a routine that is running. I found this very helpful question/answer how-to-show-a-moving-progress-bar-in-qgis, but I can not reproduce successful ...
0
votes
1answer
664 views
Using Update Cursor gives IndexError: list assignment index out of range?
I am trying to use an update cursor and receiving an error. I'm not very familiar with using cursors, so please bear with me. I am trying to write a 1 or 0 to a field, based on a condition.
The error ...
0
votes
1answer
807 views
Using UpdateCursor based on current selection of features
What I want to do is to manually select two features with the mouse (e.g. point or polygon), each in separate geodatabases to then copy the attributes values from one to the other (for only these two ...
