Questions tagged [update]
The act or an instance of bringing something up to date.
277
questions
3
votes
2answers
57 views
PostGIS- slow spatial UPDATE queries on 50mil rows
PostgreSQL 11.8, AWS hosted RDS instance, SSD, 8GB RAM, 3.0 GHz Intel Scalable Processor. Plenty of storage space.
I'm finding running updates on a large table using spatial queries is taking a very ...
1
vote
0answers
23 views
What is the correct syntax for the item.publish command to update a hosted feature layer?
Trying to use the code provided at the bottom of this entry
overwrite feature class in arcgis online using python
to overwrite an existing hosted feature layer in my ArcGIS Online content.
I have ...
3
votes
1answer
57 views
Analysing differences between 2 dataset versions [closed]
In my GIS department, we purchase vector GIS data and regular updates. Each update delivery includes a new "snapshot" of the dataset, which is a brand new version of the entire dataset. As ...
1
vote
1answer
42 views
Manually updating the attribute table of a clipped shapefile
I need to do calculations of surfaces of polygons in vector layers. The clip tool does just what I want - I can clip the polygons of the input layer to the clipping layer. When I project the new layer ...
2
votes
1answer
98 views
Geometry buffer updating with ogr2ogr
I am trying to modify a dataset by replacing the geometry of each feature by its buffer. I try to do it directly, in update mode (not very secure I know). Here is what I tried:
ogr2ogr -update test....
1
vote
2answers
52 views
Error updating geopackage layer attribute in Python using sqlite3
I'm attempting to update an attribute field in a geopackage layer using the Python sqlite3 module, but any attempt at update is giving an error "no such function: ST_IsEmpty".
Is there ...
0
votes
1answer
57 views
OpenLayers 6 layer source parameter refresh problem
I'm trying to refresh a source with some parameter. There is a text input control on the html page, I look forward to updating the map based on user input after clicking the button, but it doesn't ...
0
votes
1answer
58 views
Why my Google Sheet document is not updating in ArcGIS Online?
I have a Google Sheet that updates from a survey I have live in Google forms. I added this to my content in ArcGIS and added as a layer to a map. I was sure to set the refresh interval. I have been ...
0
votes
0answers
44 views
Deleting existing data and thereafter appending updated data to hosted feature layer (layer within group layer) in ArcGIS Online
I am trying to figure out how to append new data to an existing feature layer in ArcGIS Online. I have tried to solely append the data (in ArcGIS Online), but the problem arises when I receive ...
0
votes
0answers
50 views
Updating/overwriting multiple layers within a feature layer in ArcGIS Online from a fgdb containing all the new feature classes
I am looking for a method to upload and replace multiple layers in ArcGIS Online that are stored within a (hosted) feature layer. I have the feature classes to be used to update (and identical in ...
0
votes
0answers
29 views
Inserting/Update a polygon into a field with null geometry in Oracle
How can I copy a previously created polygon that is in a temporary layer, to a field with null geometry in Oracle?
I can view the field in the table, use the "Add Part" tool to create a new ...
1
vote
1answer
48 views
Updating PostGIS layer with the result of intersection
I have a PostGIS layer which I would like to intersect with another layer (adjust its borders). The result of the intersection should then become the new PostGIS-layer (update the input layer).
I ...
0
votes
1answer
31 views
What happens in the DB when a user updates a record in a versioned table?
ArcGIS Desktop 10.7.1/Oracle 18c.
In a table that is versioned (with the option to move edits to base):
What happens in the database when a user updates a record?
It would be helpful to know what ...
2
votes
2answers
71 views
Update coordinates on geopackage with shapefile
I have a geopackage file that has all the information about certain items but the coordinates need to be updated. I'm using an old Leica 1200 GPS to get the new coordinates and giving the same ID to ...
1
vote
1answer
44 views
ArcObjects update feature attribute
I want to update enabled field of feature in an asp.net MVC application.
I have below code but it returned "No update session in progress" error
public string Test()
{
...
0
votes
1answer
29 views
Populate a combobox with vector layer name in QGIS 3.X plugin [closed]
I'm updating a QGIS 2.14 Python code plugin to QGIS 3.X.
I'm stuck in the attribution of vector name in combobox.
The problem is that I don't have any error message but the combobox aren't filled at ...
4
votes
2answers
304 views
QGIS update to 3.14 Pi
I try to update QGIS to 3.14 version with osgeo4w-setup-x86_64 but 3.14 does not appear in list. It only shows 3.12
0
votes
0answers
22 views
Update attribute table by values from other layer
let's imagine that I have 2 different layers with geometry. Some objects from the first layer are "within" the second layer's objects. I'd like to update firstLayer_value in attribute table ...
0
votes
1answer
42 views
Automatically update field when value in related table is changed
i have set up a 1:n relation in QGIS. The parent layer contains trees (point geometry) and some basic informations about. The related table contains measurements which should be carried out to keep ...
2
votes
1answer
42 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
40 views
Refreshing values in Attribute table automatically after they were changed in database
I've connected QGIS to an external database, which records the entry and exit of vehicles in a car park.The objective is to follow the entries and exits of vehicles in real time. However, the ...
1
vote
1answer
33 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
96 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
146 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
33 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.
...
1
vote
1answer
43 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 ...
1
vote
1answer
67 views
Updating tables from QGIS to pgAdmin
I have created a connection between QGIS (ver. 3.10.1-A Coruña) and PostgreSQL (pgAdmin 4).
Every time I edit/update my table in QGIS I have to delete the table in PostgreSQL and re-import again the ...
0
votes
2answers
46 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
30 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
673 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
97 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
87 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 ...
1
vote
3answers
38 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
33 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
35 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
43 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
95 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
124 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
58 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
108 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
53 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
298 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 ...
5
votes
1answer
399 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
71 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
44 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 domain codes to domain descriptions.
...
0
votes
2answers
37 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
33 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
386 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
94 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
75 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 ...
